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 COUNTRYTBL_LANG EO_ADDRFMT_LANG EO_ADDR_FMT_TBL EO_ADDR_VALIDAT

    • # 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 POST_SRCH_AVAIL Character(1) VARCHAR2(1) NOT NULL Postal search available

    Y/N Table Edit

    Default Value: N

    7 ADDR_VALIDAT Character(1) VARCHAR2(1) NOT NULL Address validate

    Y/N Table Edit

    Default Value: N

    8 EO_SEC_PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Address secondary page name

    Default Value: EO_ADDR_DFT_SEC

    Prompt Table: EO_ADDR_SUBPAGE