HRS_EE_RF_J_VW

(SQL View)
 Index Back

eRecruit Referral Job Req

This record maintains information about specific jobs requisitions to which applicants were referred.

SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.EMPLID , A.HRS_JOB_OPENING_ID , A.REFERRAL_ID , A.REFERRAL_PWD , A.HRS_ROW_ADD_DTTM , A.HRS_ROW_ADD_OPRID , A.HRS_ROW_UPD_DTTM , A.HRS_ROW_UPD_OPRID FROM PS_HRS_EE_REF_JO A WHERE A.HRS_ROW_ADD_DTTM = ( SELECT MAX(B.HRS_ROW_ADD_DTTM) FROM PS_HRS_EE_REF_JO B WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND B.HRS_PROFILE_SEQ = A.HRS_PROFILE_SEQ AND B.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID)

  • Parent record: HRS_EE_REFERRAL

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    4 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JOB_OPENING

    5 REFERRAL_ID Character(20) VARCHAR2(20) NOT NULL Referral Track ID
    6 REFERRAL_PWD Character(6) VARCHAR2(6) NOT NULL Referral Password
    7 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    8 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    9 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    10 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id