prescreening view for display pass fail

HRS_PSCRN_PASS2

(SQL View)
 Index Back

SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.HRS_RCMNT_ID , A.HRS_JOB_OPENING_ID , B.HRS_SCR_STATUS , A.ENTRY_SOURCE , A.HRS_SUBMIT_SOURCE , A.HRS_LOGICAL_DELETE FROM PS_HRS_APP_RCMNT_I A LEFT OUTER JOIN PS_HRS_APP_JOPSCR2 B ON A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = B.HRS_PROFILE_SEQ AND A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID WHERE A.HRS_JOB_OPENING_ID NOT IN ( SELECT HRS_JOB_OPENING_ID FROM PS_HRS_APP_JOPSCRN A1 , PS_HRS_JO_SCR_LVL JSL , PS_HRS_SCREEN_TBL SCR WHERE A1.HRS_SCR_STATUS = '2' AND A1.HRS_JO_SCR_SUMM_ID = JSL.HRS_JO_SCR_SUMM_ID AND A1.HRS_JO_SCR_SEQ = JSL.HRS_JO_SCR_SEQ AND JSL.HRS_SCREENING_ID = SCR.HRS_SCREENING_ID AND SCR.HRS_PRE_APP_SCR = 'Y' AND A1.HRS_PERSON_ID = A.HRS_PERSON_ID AND A1.HRS_PROFILE_SEQ = A.HRS_PROFILE_SEQ)

# 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_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
4 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
5 HRS_SCR_STATUS Character(1) VARCHAR2(1) NOT NULL Screening Status
1=Passed
2=Failed
6 ENTRY_SOURCE Character(1) VARCHAR2(1) NOT NULL Entry Source
A=Application
O=Organization
7 HRS_SUBMIT_SOURCE Character(1) VARCHAR2(1) NOT NULL field used to identify where this application was submitted from: C- Candidate Gateway, T- TAM
C=Candidate Gateway
T=TAM
8 HRS_LOGICAL_DELETE Character(1) VARCHAR2(1) NOT NULL Indicates row has been logically deleted.