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