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 |