HRS_RCM_SCR3_VW (SQL View)	Index Back
Job Screening Veiw This view is used to display applicants associated with the job opening and applicants' status as s/he moves through the job opening screening process. It is used as a no-autoselect derived display grid on the job opening screening component. This view should not be exposed through query and should not be used for any other purpose.

HRS_RCM_SCR3_VW

(SQL View)

Job Screening Veiw

This view is used to display applicants associated with the job opening and applicants' status as s/he moves through the job opening screening process. It is used as a no-autoselect derived display grid on the job opening screening component. This view should not be exposed through query and should not be used for any other purpose.

SELECT DISTINCT A.HRS_JOB_OPENING_ID , A.JOBCODE FROM PS_HRS_JO_JOBCD_I A

# 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
Prompt Table: HRS_JO_OPEN_I

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

#	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 Prompt Table: HRS_JO_OPEN_I
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code