OPRIDEMPLIDPOI_SEC_SQR(SQL View) |
Index Back |
|---|---|
SQR Srch - PPL no JobsPOI_SEC_SQRis used as a search view to select person records for you to use when you use SQR or another batch job.. This view includes only People without Jobs. One row per EMPLID Uses Security Sets PPLPOI |
| SELECT DISTINCT %Sql(SCRTY_SEL_PSQRKEY, OPR,SEC) FROM %Sql(SCRTY_PER_FROM) WHERE SEC.FUTURE_FLG <> 'Y' AND %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 | 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 |