HRS_JOB_ASSO_VW

(SQL View)
 Index Back

Job Opening Emp Association

Association between a job opening and an employee.

SELECT J.HRS_JOB_OPENING_ID , J.ORIGINATOR_ID , 'G' FROM PS_HRS_JOB_OPENING J WHERE EXISTS ( SELECT 1 FROM PS_PERSON P WHERE P.EMPLID = J.ORIGINATOR_ID) UNION SELECT HRS_JOB_OPENING_ID , EMPLID , (CASE HRS_JO_TM_TYPE WHEN 'M' THEN 'M' WHEN 'R' THEN 'R' ELSE 'T' END) FROM PS_HRS_JO_TEAM WHERE HRS_JO_TM_TYPE IN ('M', 'R', 'A', 'I', 'O', 'S') UNION SELECT HRS_JOB_OPENING_ID , EMPLID , 'H' FROM PS_HRS_JO_TEAM WHERE HRS_JO_TM_TYPE = 'M' AND HRS_JO_TM_PRIMARY = 'Y' UNION SELECT HRS_JOB_OPENING_ID , EMPLID , 'P' FROM PS_HRS_JO_TEAM WHERE HRS_JO_TM_TYPE = 'R' AND HRS_JO_TM_PRIMARY = 'Y' UNION SELECT A.HRS_JOB_OPENING_ID , B.EMPLID , 'T' FROM PS_HRS_JO_PEND_APP A , PSOPRDEFN B WHERE A.OPRID = B.OPRID

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 HRS_ASSOCIATION_CD Character(1) VARCHAR2(1) NOT NULL Job opening association codes
A=Applied jobs
G=Created by Me
H=Primary Hiring Manager
M=Hiring Manager
N=Not applied Jobs
P=Primary Recruiter
R=Recruiter
T=Team Member