COUNTRY_TBL_VW

(SQL View)
 Index Back

Countries

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

SELECT A.COUNTRY ,A.DESCR ,A.DESCRSHORT ,A.COUNTRY_2CHAR ,A.EU_MEMBER_STATE ,A.ADDR1_LBL ,A.ADDR1_AVAIL ,A.ADDR2_LBL ,A.ADDR2_AVAIL ,A.ADDR3_LBL ,A.ADDR3_AVAIL ,A.ADDR4_LBL ,A.ADDR4_AVAIL ,A.CITY_LBL ,A.CITY_AVAIL ,A.NUM1_LBL ,A.NUM1_AVAIL ,A.NUM2_LBL ,A.NUM2_AVAIL ,A.HOUSE_TYPE_LBL ,A.HOUSE_TYPE_AVAIL ,A.ADDR_FIELD1_LBL ,A.ADDR_FIELD1_AVAIL ,A.ADDR_FIELD2_LBL ,A.ADDR_FIELD2_AVAIL ,A.ADDR_FIELD3_LBL ,A.ADDR_FIELD3_AVAIL ,A.COUNTY_LBL ,A.COUNTY_AVAIL ,A.STATE_LBL ,A.STATE_AVAIL ,A.POSTAL_LBL ,A.POSTAL_AVAIL ,A.IN_CITY_LIM_LBL ,A.IN_CITY_LIM_AVAIL ,A.GEO_CODE_LBL ,A.GEO_CODE_AVAIL ,A.POST_SRCH_AVAIL ,A.GBSYS_CFGPATH_UK ,A.GBSYS_NRPATH_UK FROM PS_COUNTRY_TBL A

  • Related Language Record: COUNTRYTBL_LANG

    • # 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
    8 ADDR2_LBL Character(15) VARCHAR2(15) NOT NULL Address 2 Label
    9 ADDR2_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 2 Available
    10 ADDR3_LBL Character(15) VARCHAR2(15) NOT NULL Address 3 Label
    11 ADDR3_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 3 Available
    12 ADDR4_LBL Character(15) VARCHAR2(15) NOT NULL Address 4 Label
    13 ADDR4_AVAIL Character(1) VARCHAR2(1) NOT NULL Address 4 Available
    14 CITY_LBL Character(15) VARCHAR2(15) NOT NULL City Label
    15 CITY_AVAIL Character(1) VARCHAR2(1) NOT NULL City Available
    16 NUM1_LBL Character(15) VARCHAR2(15) NOT NULL Number 1 Label
    17 NUM1_AVAIL Character(1) VARCHAR2(1) NOT NULL Number 1 Available
    18 NUM2_LBL Character(15) VARCHAR2(15) NOT NULL Number 2 Label
    19 NUM2_AVAIL Character(1) VARCHAR2(1) NOT NULL Number 2 Available
    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
    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
    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
    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
    28 COUNTY_LBL Character(15) VARCHAR2(15) NOT NULL County Label
    29 COUNTY_AVAIL Character(1) VARCHAR2(1) NOT NULL County Available
    30 STATE_LBL Character(15) VARCHAR2(15) NOT NULL State Label
    31 STATE_AVAIL Character(1) VARCHAR2(1) NOT NULL State Available
    32 POSTAL_LBL Character(15) VARCHAR2(15) NOT NULL Postal Label
    33 POSTAL_AVAIL Character(1) VARCHAR2(1) NOT NULL Postal Available
    34 IN_CITY_LIM_LBL Character(15) VARCHAR2(15) NOT NULL In City Limit Label
    35 IN_CITY_LIM_AVAIL Character(1) VARCHAR2(1) NOT NULL In City Limit Available
    36 GEO_CODE_LBL Character(15) VARCHAR2(15) NOT NULL Geo Code Label
    37 GEO_CODE_AVAIL Character(1) VARCHAR2(1) NOT NULL Geo Code Availabel
    38 POST_SRCH_AVAIL Character(1) VARCHAR2(1) NOT NULL Post Search Available
    39 GBSYS_CFGPATH_UK Character(254) VARCHAR2(254) NOT NULL Configuration File Prefix
    40 GBSYS_NRPATH_UK Character(254) VARCHAR2(254) NOT NULL National Registry Directory