COUNTRY_TBL

(SQL Table)
 Index Back

Countries

Official Country codes per ISO. Also contains European Union member status and dynamic address formatting. Object Owner ID marked as SCC

  • Related Language Record: COUNTRYTBL_LANG

  • Parent Record Of ADDRSRCHRSLT_FL COUNTRYTBL_LANG EO_ADDRFMT_LANG EO_ADDR_FMT_TBL EO_ADDR_VALIDAT GPMX_MIN_W_REC HCIEOADDRFMTLVW HCI_EOADDRFMTVW HRS_CNTRY_LNG HRS_DM_CNTRY_LN NAME_CNTRY_FORM SCC_ADDRFMT_LNG SCC_NIDCNTRY_LN

    • # 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

    9 EO_ADDR_VAL_CLASS Character(30) VARCHAR2(30) NOT NULL Address validation application class package ID. Object Owner ID marked as SCC

    Prompt Table: EO_ADDR_CLASSVW

    10 EO_ADDR_VAL_PATH Character(254) VARCHAR2(254) NOT NULL Address validation class path. Object Owner ID marked as SCC

    Prompt Table: EO_ADDR_PATH_VW

    11 EO_ADDR_VAL_METHOD Character(32) VARCHAR2(32) NOT NULL Address validation application class method name. Object Owner ID marked as SCC

    Prompt Table: EO_UPDADDR_DVW