OPRIDPER_ORGCWR=Contingent Worker
EMP=Employee
POI=Person of Interest
EMPLIDGPES_PER_SEC_VW(SQL View) |
Index Back |
|---|---|
Srch - All Persons SQRReplicated from PERALL_SEC_SQR which is used as a search view to select person records for use in SQR or other Batch programs. This view includes all people (except Kenmu appts). Includes Future dated rows. One row per EMPLID Uses Security Sets PPLPOI and PPLJOB |
| SELECT DISTINCT OPR.OPRID ,SEC.PER_ORG , OPR.ROWSECCLASS , SEC.EMPLID ,SEC.EMPL_RCD , NM.NAME FROM %Sql(SCRTY_PER_FROM) ,PS_NAMES NM WHERE %Sql(SCRTY_NO_APPT1) AND SEC.FUTURE_FLG <> 'Y' AND (%Sql(SCRTY_WHERE, 'PPLJOB') OR %Sql(SCRTY_WHERE, 'PPLPOI')) AND SEC.EMPLID = NM.EMPLID AND NM.NAME_TYPE = 'PRI' AND NM.EFFDT = ( SELECT MAX(EFFDT) FROM PS_NAMES WHERE EMPLID = NM.EMPLID AND NAME_TYPE = 'PRI' AND EFFDT <= %CurrentDateIn) |
| # | 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 | PER_ORG |
Character(3) | VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker EMP=Employee POI=Person of Interest |
| 3 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |