COUNTRY_TBL

(SQL Table)
 Index Back

Countries

Official Country codes per ISO. Also contains European Union member status and dynamic address formatting.

  • Related Language Record: COUNTRYTBL_LANG

  • Parent Record Of ABE_COUNTRY_LVW COUNTRYTBL_LANG STATE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: COUNTRY_TBL.DESCR

    4 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code
    5 EU_MEMBER_STATE Character(1) VARCHAR2(1) NOT NULL EU Member State

    Y/N Table Edit

    Default Value: N

    6 ADDR1_LBL Character(15) VARCHAR2(15) NOT NULL Address 1 Label
    7 ADDR1_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 1 Available

    Y/N Table Edit

    Default Value: Y

    8 ADDR2_LBL Character(15) VARCHAR2(15) NOT NULL Address 2 Label
    9 ADDR2_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 2 Available

    Y/N Table Edit

    Default Value: Y

    10 ADDR3_LBL Character(15) VARCHAR2(15) NOT NULL Address 3 Label
    11 ADDR3_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 3 Available

    Y/N Table Edit

    Default Value: Y

    12 ADDR4_LBL Character(15) VARCHAR2(15) NOT NULL Address 4 Label
    13 ADDR4_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 4 Available

    Y/N Table Edit

    Default Value: Y

    14 CITY_LBL Character(15) VARCHAR2(15) NOT NULL City Label
    15 CITY_AVAIL Character(1) VARCHAR2(1) NOT NULL City Available

    Y/N Table Edit

    Default Value: Y

    16 NUM1_LBL Character(15) VARCHAR2(15) NOT NULL Number 1 Label
    17 NUM1_AVAIL Character(1) VARCHAR2(1) NOT NULL Number 1 Available

    Y/N Table Edit

    Default Value: N

    18 NUM2_LBL Character(15) VARCHAR2(15) NOT NULL Number 2 Label
    19 NUM2_AVAIL Character(1) VARCHAR2(1) NOT NULL Number 2 Available

    Y/N Table Edit

    Default Value: N

    20 HOUSE_TYPE_LBL Character(15) VARCHAR2(15) NOT NULL House Type Label
    21 HOUSE_TYPE_AVAIL Character(1) VARCHAR2(1) NOT NULL House Type Available

    Y/N Table Edit

    Default Value: N

    22 ADDR_FIELD1_LBL Character(15) VARCHAR2(15) NOT NULL Address Field 1 Label
    23 ADDR_FIELD1_AVAIL Character(1) VARCHAR2(1) NOT NULL Address Field 1 Available

    Y/N Table Edit

    Default Value: N

    24 ADDR_FIELD2_LBL Character(15) VARCHAR2(15) NOT NULL Address Field 2 Label
    25 ADDR_FIELD2_AVAIL Character(1) VARCHAR2(1) NOT NULL Address Field 2 Available

    Y/N Table Edit

    Default Value: N

    26 ADDR_FIELD3_LBL Character(15) VARCHAR2(15) NOT NULL Address Field 3 Label
    27 ADDR_FIELD3_AVAIL Character(1) VARCHAR2(1) NOT NULL Address Field 3 Available

    Y/N Table Edit

    Default Value: N

    28 COUNTY_LBL Character(15) VARCHAR2(15) NOT NULL County Label
    29 COUNTY_AVAIL Character(1) VARCHAR2(1) NOT NULL County Available

    Y/N Table Edit

    Default Value: Y

    30 STATE_LBL Character(15) VARCHAR2(15) NOT NULL State Label
    31 STATE_AVAIL Character(1) VARCHAR2(1) NOT NULL State Available

    Y/N Table Edit

    Default Value: Y

    32 POSTAL_LBL Character(15) VARCHAR2(15) NOT NULL Postal Label
    33 POSTAL_AVAIL Character(1) VARCHAR2(1) NOT NULL Postal Available

    Y/N Table Edit

    Default Value: Y

    34 IN_CITY_LIM_AVAIL Character(1) VARCHAR2(1) NOT NULL In City Limit Available

    Y/N Table Edit

    Default Value: N

    35 IN_CITY_LIM_LBL Character(15) VARCHAR2(15) NOT NULL In City Limit Label
    36 GEO_CODE_AVAIL Character(1) VARCHAR2(1) NOT NULL Geo Code Availabel

    Y/N Table Edit

    Default Value: N

    37 GEO_CODE_LBL Character(15) VARCHAR2(15) NOT NULL Geo Code Label
    38 POST_SRCH_AVAIL Character(1) VARCHAR2(1) NOT NULL Post Search Available

    Y/N Table Edit

    Default Value: N

    39 GBSYS_NRPATH_UK Character(254) VARCHAR2(254) NOT NULL National Registry Directory
    40 GBSYS_CFGPATH_UK Character(254) VARCHAR2(254) NOT NULL Configuration File Prefix
    41 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    42 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time