HRS_APP_USA_VW

(SQL View)
 Index Back

Applicant/EE

Applicant/EE

SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , B.EFFDT , A.PREV_TERM_DT , A.PREV_EMPL_BY_COMPY , B.US_WORK_ELIGIBILTY , B.MILITARY_STATUS FROM PS_HRS_APP_PROFILE A , PS_HRS_APP_USA B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_HRS_APP_USA B1 WHERE B.HRS_PERSON_ID = B1.HRS_PERSON_ID AND B1.EFFDT <= %CurrentDateIn)

  • Parent record: HRS_APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 PREV_TERM_DT Date(10) DATE Previous Termination Date
    5 PREV_EMPL_BY_COMPY Character(1) VARCHAR2(1) NOT NULL Previously Employed by Company
    N=No
    Y=Yes
    6 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.
    N=No
    Y=Yes
    7 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status