PeopleSoft 9 Asset Management |
Table Name | LOCATION_TBL |
Table Description |
LOCATION_TBL |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | char(5) | Yes | No |
LOCATION | char(10) | Yes | No |
EFFDT | PSDATE | Yes | No |
EFF_STATUS | char(1) | No | No |
DESCR | char(30) | No | No |
DESCR_AC | char(30) | No | No |
DESCRSHORT | char(10) | No | No |
BUILDING | char(10) | No | No |
FLOOR | char(10) | No | No |
SECTOR | char(10) | No | No |
JURISDICTION | char(5) | No | No |
ATTN_TO | char(30) | No | No |
COUNTRY | char(3) | No | Yes |
ADDRESS1 | char(55) | No | No |
ADDRESS2 | char(55) | No | No |
ADDRESS3 | char(55) | No | No |
ADDRESS4 | char(55) | No | No |
CITY | char(30) | No | No |
NUM1 | char(6) | No | No |
NUM2 | char(4) | No | No |
HOUSE_TYPE | char(2) | No | No |
ADDR_FIELD1 | char(2) | No | No |
ADDR_FIELD2 | char(4) | No | No |
ADDR_FIELD3 | char(4) | No | No |
COUNTY | char(30) | No | No |
STATE | char(6) | No | Yes |
POSTAL | char(12) | No | No |
GEO_CODE | char(11) | No | No |
IN_CITY_LIMIT | char(1) | No | No |
COUNTRY_CODE | char(3) | No | No |
PHONE | char(24) | No | No |
EXTENSION | char(6) | No | No |
FAX | char(24) | No | No |
SETID_SALARY | char(5) | No | No |
SAL_ADMIN_PLAN | char(4) | No | No |
LANG_CD | char(3) | No | No |
HOLIDAY_SCHEDULE | char(6) | No | No |
ESTABID | char(12) | No | No |
LOCALITY | char(10) | No | No |
CAN_CMA | char(2) | No | No |
CAN_OEE_AREACD | char(2) | No | No |
GEOLOC_CODE | char(10) | No | No |
OFFICE_TYPE | char(1) | No | No |
NCR_SW_CAN | char(1) | No | No |
TBS_OFFICE_CD_CAN | char(10) | No | No |
WRKS_CNCL_ID_LCL | char(9) | No | No |
SPK_COMM_ID_GER | char(9) | No | No |
TARIFF_AREA_GER | char(3) | No | No |
TARIFF_GER | char(2) | No | No |
INDUST_INSP_ID_GER | char(4) | No | No |
NI_REPORT_SW_UK | char(1) | No | No |
GVT_GEOLOC_CD | char(9) | No | No |
GVT_DESIG_AGENT | char(4) | No | No |
SOC_SEC_WRK_CTR | char(3) | No | No |
MATRICULA_NBR | smallint | No | No |
LABEL_FORMAT_ID2 | char(30) | No | No |
LABEL_FORMAT_ID3 | char(30) | No | No |
USG_LBL_FORMAT_ID | char(30) | No | No |
REG_REGION | char(5) | No | No |
COMMENTS_2000 | TEXT | No | No |
Index |
Name | Type | Unique | Member |
PS_LOCATION_TBL | PK | Yes |
![]() |
PS0LOCATION_TBL | IE1 | No |
![]() |
PSALOCATION_TBL | IE2 | No |
![]() |
Member(s) of "PS_LOCATION_TBL" Index |
SETID |
LOCATION |
EFFDT |
Member(s) of "PS0LOCATION_TBL" Index |
DESCR |
SETID |
LOCATION |
EFFDT |
Member(s) of "PSALOCATION_TBL" Index |
LOCATION |
Published December 16, 2006 |