HRS_G_APPRT_SCH

(SQL View)
 Index Back

Rqsn/Jobcode Considered For

Applicant Rating Search Record.

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , E.HRS_JOB_OPENING_ID , A.JOBCODE , A.GVT_QUALS_DETERM , A.STATUS_CODE , B.NAME FROM PS_HRS_RCMNT_JOB A ,PS_HRS_APP_NAME_I B ,PS_HRS_STS_REC_I C ,PS_HRS_JO_JOBCD_I D ,PS_HRS_RCMNT E WHERE A.HRS_PERSON_ID = E.HRS_PERSON_ID AND A.HRS_RCMNT_ID = E.HRS_PERSON_ID AND E.HRS_JOB_OPENING_ID = D.HRS_JOB_OPENING_ID AND A.JOBCODE = D.JOBCODE AND ((A.GVT_QUALS_DETERM IN ('Q', 'B', 'W') AND C.STATUS_PHASE = '1') OR (A.GVT_QUALS_DETERM = 'N' AND C.STATUS_PHASE = '2' )) AND A.STATUS_CODE = C.STATUS_CODE AND A.HRS_PERSON_ID = B.HRS_PERSON_ID

# 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_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
4 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
5 GVT_QUALS_DETERM Character(1) VARCHAR2(1) NOT NULL Qualifications Determination Flag
B=Best Qualified
D=Does Not Meet Min Quals
N=Eligible/Not Rated
Q=Qualified
W=Well Qualified
6 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

Prompt Table: HRS_STS_REC_I

7 NAME Character(50) VARCHAR2(50) NOT NULL Name