HRS_APP_NOTE_VW

(SQL View)
 Index Back

View with Applicant Notes/JO


SELECT A.HRS_PERSON_ID , A.HRS_NOTES_ID , COALESCE (B.HRS_JOB_OPENING_ID , 0) FROM PS_HRS_APPL_NOTES A LEFT OUTER JOIN PS_HRS_NOTES_JO B ON A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_NOTES_ID= B.HRS_NOTES_ID UNION SELECT F.HRS_PERSON_ID , F.HRS_CRSP_ID , COALESCE (F1.HRS_JOB_OPENING_ID , 0) FROM PS_HRS_APP_FRWD F LEFT OUTER JOIN PS_HRS_APP_FRWD_JO F1 ON F.HRS_PERSON_ID = F1.HRS_PERSON_ID AND F.HRS_CRSP_ID= F1.HRS_CRSP_ID UNION SELECT C.HRS_PERSON_ID , C.HRS_CRSP_ID , COALESCE (C1.HRS_JOB_OPENING_ID , 0) FROM PS_HRS_APP_CRSP C LEFT OUTER JOIN PS_HRS_SND_CRSP_JO C1 ON C.HRS_PERSON_ID = C1.HRS_PERSON_ID AND C.HRS_CRSP_ID= C1.HRS_CRSP_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_NOTES_ID Number(10,0) DECIMAL(10) NOT NULL Notes Id
3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone