CITIZEN_STS_LNG

(SQL Table)
 Index Back

Citizen Status Language Table

This table is the related language table for CITIZEN_STS_TBL. This table was created in release 8.0 CITIZEN_STS_TBL holds citizenship status by country. Citinzenship status differ by country, therefore country + citizenship status are the key structure for CITIZEN_STS_TBL table. And, on the other hand, country + citizenship + language code are the key structure for CITIZEN_STS_LNG

  • Related Language Record for CITIZEN_STS_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    2 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description