HR_SRCH_PSEC_VW

(SQL View)
 Index Back

Search Person Security

This view has been created to implement Row level security for person search. It is on the same lines as the search record for Personal Data component.

SELECT DISTINCT SEC.EMPLID , CLS.CLASSID FROM PS_SJT_PERSON SEC , PS_SJT_CLASS_ALL CLS WHERE SEC.APPT_TYPE <> '1' AND CLS.SCRTY_SET_CD IN ('PPLJOB','PPLPOI') AND CLS.SCRTY_TYPE_CD = SEC.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = SEC.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = SEC.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = SEC.SCRTY_KEY3 AND CLS.TREE = 'Y' AND EXISTS ( SELECT 'X' FROM PS_SJT_OPR_CLS SOC WHERE SOC.CLASSID = CLS.CLASSID AND SOC.SEC_RSC_FLG IN ('1', '3')) UNION SELECT DISTINCT SEC.EMPLID , CLS.CLASSID FROM PS_SJT_PERSON SEC , PS_SJT_CLASS_ALL CLS WHERE SEC.APPT_TYPE <> '1' AND CLS.SCRTY_SET_CD IN ('PPLJOB','PPLPOI') AND CLS.SCRTY_TYPE_CD = SEC.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = SEC.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = SEC.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = SEC.SCRTY_KEY3 AND CLS.TREE = 'N' AND EXISTS ( SELECT 'X' FROM PS_SJT_OPR_CLS SOC WHERE SOC.CLASSID = CLS.CLASSID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security