OPRIDEMPLIDGP_SCH_EMPL_VW(SQL View) |
Index Back |
|---|---|
Admin/Manager Search VwSearch view intended for use by administrative operators such as data entry clerks or with Manager events. The view returns the employee names that the operator has access to. Access is determined using HR Security |
| SELECT A.OPRID , A.EMPLID , A.EMPL_RCD , A.NAME , A.DEPTID , A.JOBCODE , A.JOBCODE_DESCR FROM PS_GP_EMPLMT_SRCH A |
| # | 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 |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |