PeopleSoft 9
Asset Management

Table Name COUNTRY_TBL

Table Description
COUNTRY_TBL
Columns
Name Datatype Is PK Is FK
COUNTRY char(3) Yes No
DESCR char(30) No No
DESCRSHORT char(10) No No
COUNTRY_2CHAR char(2) No No
EU_MEMBER_STATE char(1) No No
ADDR1_LBL char(15) No No
ADDR1_AVAIL char(1) No No
ADDR2_LBL char(15) No No
ADDR2_AVAIL char(1) No No
ADDR3_LBL char(15) No No
ADDR3_AVAIL char(1) No No
ADDR4_LBL char(15) No No
ADDR4_AVAIL char(1) No No
CITY_LBL char(15) No No
CITY_AVAIL char(1) No No
NUM1_LBL char(15) No No
NUM1_AVAIL char(1) No No
NUM2_LBL char(15) No No
NUM2_AVAIL char(1) No No
HOUSE_TYPE_LBL char(15) No No
HOUSE_TYPE_AVAIL char(1) No No
ADDR_FIELD1_LBL char(15) No No
ADDR_FIELD1_AVAIL char(1) No No
ADDR_FIELD2_LBL char(15) No No
ADDR_FIELD2_AVAIL char(1) No No
ADDR_FIELD3_LBL char(15) No No
ADDR_FIELD3_AVAIL char(1) No No
COUNTY_LBL char(15) No No
COUNTY_AVAIL char(1) No No
STATE_LBL char(15) No No
STATE_AVAIL char(1) No No
POSTAL_LBL char(15) No No
POSTAL_AVAIL char(1) No No
IN_CITY_LIM_AVAIL char(1) No No
IN_CITY_LIM_LBL char(15) No No
GEO_CODE_AVAIL char(1) No No
GEO_CODE_LBL char(15) No No
POST_SRCH_AVAIL char(1) No No
GBSYS_NRPATH_UK char(254) No No
GBSYS_CFGPATH_UK char(254) No No
SYNCID int No No
SYNCDTTM PSDATETIME No No
Index
Name Type Unique Member
PS_COUNTRY_TBL PK Yes
PS0COUNTRY_TBL IE1 No
PSACOUNTRY_TBL IE2 No
Member(s) of "PS_COUNTRY_TBL" Index
COUNTRY
Member(s) of "PS0COUNTRY_TBL" Index
DESCR
COUNTRY
Member(s) of "PSACOUNTRY_TBL" Index
SYNCID

Published December 16, 2006