HRS_RCM_STS_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_REC_STS_SEQ , A.STATUS_DT , A.STATUS_CODE , A.STATUS_REASON , B.DESCR , B.STATUS_PHASE , %subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_RCMNT_STS A , PS_HRS_STS_REC_I B WHERE A.STATUS_CODE = B.STATUS_CODE

# 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_REC_STS_SEQ Number(3,0) SMALLINT NOT NULL Recruitment Status Sequence
4 STATUS_DT Date(10) DATE NOT NULL Status Date

Default Value: %date

5 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

Prompt Table: HRS_STS_REC_I

6 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

Prompt Table: HRS_RSN_REC_I

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 STATUS_PHASE Character(1) VARCHAR2(1) NOT NULL Identifies a phase within a status area.
1=1-Review
2=2-Applied
3=3-Screen
4=4-Route
5=5-Interview
6=6-Offer
7=7-Hire
8=8-Reject
9 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
10 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
11 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
12 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id