CITIZEN_STS_TBL

(SQL Table)
 Index Back

Citizen Status Table

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

  • Related Language Record: CITIZEN_STS_LNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description