HRS_POSN_STS_VW (SQL View)	Index Back
Position Applied For Status Vw Retrieves latest status information for position applied for.

HRS_POSN_STS_VW

(SQL View)

Position Applied For Status Vw

Retrieves latest status information for position applied for.

SELECT DISTINCT A.HRS_PERSON_ID , C.HRS_PROFILE_SEQ , C.HRS_JOB_OPENING_ID , A.STATUS_DT , A.HRS_REC_STS_SEQ , A.STATUS_CODE , A.STATUS_REASON , B.STATUS_PHASE , B.OPEN_STS_IND , A.HRS_ROW_UPD_OPRID FROM PS_HRS_RCMNT_STS A , PS_HRS_STS_REC_I B , PS_HRS_RCMNT C WHERE A.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.HRS_RCMNT_ID = C.HRS_RCMNT_ID AND A.STATUS_DT = ( SELECT MAX(STATUS_DT) FROM PS_HRS_RCMNT_STS C WHERE %Join(COMMON_KEYS, HRS_RCMNT_STS A, HRS_RCMNT_STS C, HRS_REC_STS_SEQ) AND A.STATUS_CODE = C.STATUS_CODE) AND A.HRS_REC_STS_SEQ = ( SELECT MAX(HRS_REC_STS_SEQ) FROM PS_HRS_RCMNT_STS C WHERE %Join(COMMON_KEYS, HRS_RCMNT_STS A, HRS_RCMNT_STS C, HRS_REC_STS_SEQ) AND A.STATUS_CODE = C.STATUS_CODE) AND A.STATUS_CODE = B.STATUS_CODE

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_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece

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

4 STATUS_DT Date(10) DATE Status Date

5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

6 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
Prompt Table: HRS_STS_REC_I

7 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.
Prompt Table: HRS_RSN_REC_I

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 OPEN_STS_IND Character(1) VARCHAR2(1) NOT NULL Indicates an open state.
Y/N Table Edit

10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone
4	STATUS_DT	Date(10)	DATE	Status Date
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status. Prompt Table: HRS_STS_REC_I
7	STATUS_REASON	Character(3)	VARCHAR2(3) NOT NULL	Identifies a reason associated with a particular status. Prompt Table: HRS_RSN_REC_I
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	OPEN_STS_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates an open state. Y/N Table Edit
10	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.