OPRIDEMPLIDPERALL_SEC_QRY(SQL View) |
Index Back |
|---|---|
Qry Srch - All PersonsPERALL_SEC_QRY is used as a search view to select person records for you to use when you use the Query Tool. This view includes all people (except Kenmu appts). Includes Future dated rows. One row per EMPLID and distinct Search Items. Uses Security Sets PPLPOI and PPLJOB |
| SELECT DISTINCT %Sql(SCRTY_SEL_PQRYKEY, OPR,SEC) FROM %Sql(SCRTY_PER_FROM) WHERE %Sql(SCRTY_NO_APPT1) AND SEC.FUTURE_FLG <> 'Y' AND (%Sql(SCRTY_WHERE, 'PPLJOB') OR %Sql(SCRTY_WHERE, 'PPLPOI')) |
| # | 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 |