GM_X_CITIZEN_VW

(SQL View)
 Index Back

EE/Dependent Citizenship

Use CITIZENSHIP to record an employee's or dependent's country of citizenship. You can enter related passport data on CITIZEN_PSSPRT.

SELECT EMPLID , CITIZENSHIP_STATUS FROM PS_CITIZENSHIP WHERE COUNTRY = 'USA'

  • Parent record: PERSONAL_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    2 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
    1=Native
    2=Naturalized
    3=Alien Permanent
    4=Alien Temporary
    5=Permanent resident of U.S.
    6=Working Visa
    7=Canadian Citizen
    8=Other
    E=Not Entered
    N=Not Indicated