SCC_NIDCNTRY_VW

(SQL View)
 Index Back

Countries

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

SELECT A.COUNTRY , A.DESCR FROM PS_COUNTRY_TBL A

  • Related Language Record: SCC_NIDCNTRY_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
    2 SCC_NID_CNTRYDESCR Character(30) VARCHAR2(30) NOT NULL NID Country