HRS_JO_CHART_VW (SQL View)	Index Back
View for displaying JO Chart This view is used to display recruitment phases chart for a job opening.

HRS_JO_CHART_VW

(SQL View)

View for displaying JO Chart

This view is used to display recruitment phases chart for a job opening.

SELECT HRS_JOB_OPENING_ID , STATUS_PHASE , COUNT(*) FROM PS_HRS_RCMNT_I A , PS_HRS_STS_REC_I B WHERE A.STATUS_CODE = B.STATUS_CODE AND B.STATUS_PHASE <> ' ' GROUP BY HRS_JOB_OPENING_ID, STATUS_PHASE

# 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

2 STATUS_PHASE Character(1) VARCHAR2(1) NOT NULL Identifies a phase within a status area.
1=1-Applied
2=2-Reviewed
3=3-Screen
4=4-Route
5=5-Interview
6=6-Offer
7=7-Hire
8=8-Hold
9=9-Reject

3 HRS_CHART_COUNT Number(5,0) INTEGER NOT NULL This field displays number of applicants and applications on the Job Opening Chart.

#	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
2	STATUS_PHASE	Character(1)	VARCHAR2(1) NOT NULL	Identifies a phase within a status area. 1=1-Applied 2=2-Reviewed 3=3-Screen 4=4-Route 5=5-Interview 6=6-Offer 7=7-Hire 8=8-Hold 9=9-Reject
3	HRS_CHART_COUNT	Number(5,0)	INTEGER NOT NULL	This field displays number of applicants and applications on the Job Opening Chart.