HRS_JSCH_SEC_VW

(SQL View)
 Index Back

Job Opening Search Security

View of job opening search security key

SELECT JO.HRS_JOB_OPENING_ID , 'E:' %Concat JO.EMPLID FROM PS_HRS_SJT_JO JO WHERE JO.EMPLID <> ' ' UNION SELECT JO.HRS_JOB_OPENING_ID , 'C:' %Concat CLS.CLASSID FROM PS_HRS_SJT_JO JO , PS_SJT_CLASS_ALL CLS WHERE CLS.SCRTY_SET_CD = 'RSOPN' AND CLS.SCRTY_TYPE_CD = JO.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = JO.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = JO.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = JO.SCRTY_KEY3 AND JO.EMPLID = ' ' UNION SELECT JO.HRS_JOB_OPENING_ID , 'C:' %Concat CLS.CLASSID FROM PS_HRS_SJT_JO JO , PS_SJT_CLASS_ALL CLS WHERE CLS.SCRTY_SET_CD = 'PPLJOB' AND CLS.SCRTY_TYPE_CD = '001' AND CLS.SCRTY_KEY1 = JO.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = JO.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = JO.SCRTY_KEY3 AND JO.EMPLID = ' ' UNION SELECT 0 , 'A:ALL' FROM PS_HRS_RCMNT

# 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 HRS_JPS_SRCH_SECID Character(30) VARCHAR2(30) NOT NULL Search Security Id