HRS_RCJOB_SRCH

(SQL View)
 Index Back

Recruitment Status

Tracks the jobs the applicant may have applied for. Replaces the tables GVT_APPL-CONSID and GVT_PSN_APPLFOR.

SELECT DISTINCT B.HRS_JOB_OPENING_ID FROM PS_HRS_RCMNT_JOB A , PS_HRS_RCMNT B WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND B.HRS_RCMNT_ID = A.HRS_RCMNT_ID

  • Parent record: HRS_RCMNT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone