PERS_SRCH_QRY

(SQL View)
 Index Back

Core VW: PERS_SRCH for Query

PERS_SRCH_QRY is used as the Query Security Record based on PERS_SRCH_GBL. It returns only one row per employee and no Future dated only people (ie future dated hires).

SELECT DISTINCT OPR.OPRID , SEC.EMPLID FROM %Table(SJT_PERSON) SEC , %Table(PSOPRDEFN) OPR , %Table(SJT_CLASS_ALL) CLS , %Table(SJT_OPR_CLS) SOC WHERE SEC.APPT_TYPE <> '1' AND SEC.FUTURE_FLG <> 'Y' 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 SOC.OPRID = OPR.OPRID AND SOC.CLASSID = CLS.CLASSID AND CLS.SCRTY_SET_CD = 'PPLJOB' AND (CLS.TREE = 'N' OR (CLS.TREE = 'Y' AND SOC.CLASSID = OPR.ROWSECCLASS AND SOC.SEC_RSC_FLG IN ('1', '3')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID