HRS_JP_ASSO_VW

(SQL View)
 Index Back

Job Opening Emp Association

Association between a job opening and an employee.

SELECT HRS_JOB_OPENING_ID , ORIGINATOR_ID , 'G' FROM PS_HRS_JOB_OPENING UNION SELECT HRS_JOB_OPENING_ID , EMPLID , 'M' FROM PS_HRS_JO_TEAM WHERE HRS_JO_TM_TYPE = 'M' 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 , 'R' FROM PS_HRS_JO_TEAM WHERE HRS_JO_TM_TYPE = 'R' 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 HRS_JOB_OPENING_ID , EMPLID , 'T' FROM PS_HRS_JO_TEAM WHERE HRS_JO_TM_TYPE IN ('A', 'I', 'O', 'S') UNION SELECT A.HRS_JOB_OPENING_ID , B.EMPLID , 'T' FROM PS_HRS_JOPND_APP_V A , PSOPRDEFN B WHERE A.OPRID = B.OPRID UNION SELECT X.HRS_JOB_OPENING_ID ,Y.EMPLID ,'A' FROM PS_HRS_RCMNT X ,PS_HRS_APPLICANT Y WHERE X.HRS_PERSON_ID = Y.HRS_PERSON_ID

# 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