SFA_CITIZSHIPVW

(SQL View)
Index Back

Depend. Citizenship Interf V

Employee Dependent Citizenship Interface View

SELECT A.EMPLID , A.CITIZENSHIP_STATUS FROM PS_HCR_CITIZSHIP_I A , PS_INSTALLATION B WHERE B.COUNTRY = A.COUNTRY AND A.DEPENDENT_ID = ' '

  • 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: HCR_PERSON_I

    2 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: HCR_CTZN_STS_I
    Set Control Field: COUNTRY