OPRIDEMPLIDHR_I9_S_SRCH_VW(SQL View) |
Index Back |
|---|---|
Search - All Pers w/ an ERNSearch view to select person records for you to use when you access a panel. This view shows you records only for persons in departments that your operator class is allowed to access. All PER_ORG Types are returned. |
| SELECT DISTINCT OPR.OPRID , OPR.ROWSECCLASS , SEC.EMPLID , SEC.EMPL_RCD FROM PS_SJT_PERSON SEC , PSOPRDEFN OPR , PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS SOC WHERE SEC.APPT_TYPE <> '1' 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 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |