SFA_PERUSACURVW

(SQL View)
 Index Back

Interface of PERSON for USA

Extension of the PERSON object for US specific fields with EFFDT

SELECT A.EMPLID ,A.US_WORK_ELIGIBILTY ,A.MILITARY_STATUS ,A.CITIZEN_PROOF1 ,A.CITIZEN_PROOF2 ,A.MEDICARE_ENTLD_DT FROM PS_HCR_PER_USA_I A WHERE A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_HCR_PER_USA_I A2 WHERE A2.EMPLID = A.EMPLID AND A2.EFFDT <= %CurrentDateIn )

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.
    N=No
    Y=Yes

    Y/N Table Edit

    3 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status
    4 CITIZEN_PROOF1 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 1)
    5 CITIZEN_PROOF2 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 2)
    6 MEDICARE_ENTLD_DT Date(10) DATE Date Entitled to Medicare