OPRIDEMPLIDEMPL_RCDCWR=Contingent Worker
EMP=Employee
POI=Person of Interest
PER_SEC_SRCH_VW(SQL View) |
Index Back |
|---|---|
Srch for Workforce Job SummaryPER_SEC_SRCH_VW is used as a search view to select person records for you to use when you access the panel Workforce Job Summary. One row per EMPLID and distinct Search Items. Uses Security Sets PPLPOI and PPLJOB |
| SELECT DISTINCT OPR.OPRID , OPR.ROWSECCLASS , SEC.EMPLID ,SEC.EMPL_RCD ,NM.NAME_DISPLAY ,NM.NAME_DISPLAY_SRCH ,NM.LAST_NAME_SRCH ,NM.SECOND_LAST_SRCH ,NM.NAME_AC ,NM.MIDDLE_NAME ,SEC.PER_ORG FROM %Sql(SCRTY_PER_NM_FROM) WHERE %Sql(SCRTY_NO_APPT1) AND %Sql(SCRTY_NAME) 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 | 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 Rcd Nbr |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | NAME_DISPLAY_SRCH | Character(50) | VARCHAR2(50) NOT NULL | Uppercase version of Name to improve performance on searches. |
| 7 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Name |
| 9 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 10 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 11 | 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 |