HRS_RCM_ST_VW

(SQL View)
 Index Back

Recruitment Status

Maintains the history of recruitment status throughout the flow of an application.

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_ROW_UPD_DTTM ,%DateDiff ( ( SELECT MIN(B.STATUS_DT) FROM PS_HRS_RCMNT_STS B , PS_HRS_STS_REC_I C WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_RCMNT_ID = B.HRS_RCMNT_ID AND B.STATUS_CODE = C.STATUS_CODE AND C.STATUS_PHASE = '1' ) ,( SELECT MIN(B.STATUS_DT) FROM PS_HRS_RCMNT_STS B , PS_HRS_STS_REC_I C WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_RCMNT_ID = B.HRS_RCMNT_ID AND B.STATUS_CODE = C.STATUS_CODE AND C.STATUS_PHASE IN ('7') ) ) FROM PS_HRS_RCMNT A

  • Parent record: HRS_RCMNT

    • # 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_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    3 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    4 HRS_DAYS_TO_FILL Number(5,0) INTEGER NOT NULL Days to Fill