ISIR_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 ,COUNTRY , CITIZENSHIP_STATUS , DEPENDENT_ID FROM PS_CITIZENSHIP WHERE DEPENDENT_ID = ' ' AND COUNTRY = 'USA'

  • Parent record: PERSON

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

    Prompt Table: PEOPLE_SRCH

    2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    3 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: CITIZEN_STS_TBL
    Set Control Field: COUNTRY

    4 DEPENDENT_ID Character(2) VARCHAR2(2) NOT NULL Dependent ID