OPRIDEMPLIDA=Active
I=Inactive
TL_ESS_SRCH_VW(SQL View) |
Index Back |
|---|---|
Self Service Search VwSearch view intended for use with Self Service events that are not date driven. For the Operator who is logged in, the view returns a row for each current job associated to the Operator's Employee ID. |
| SELECT O.OPRID , E.EMPLID , E.EMPL_RCD , E.TIME_RPTG_STATUS , E.WORKGROUP , E.TASKGROUP , E.TASK_PROFILE_ID , E.ELP_TR_TMPLT_ID , E.PCH_TR_TMPLT_ID , E.PERIOD_ID , P.NAME FROM PS_TL_EMPL_DATA E , PS_PERSON_NAME P , PS_TL_OPR_CLASS_VW O WHERE E.EMPLID = O.EMPLID AND E.EMPLID = P.EMPLID AND E.EFFDT = ( SELECT MAX(E1.EFFDT) FROM PS_TL_EMPL_DATA E1 WHERE E1.EMPLID = E.EMPLID AND E1.EMPL_RCD = E.EMPL_RCD AND E1.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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | TIME_RPTG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Time Reporter Status
A=Active I=Inactive |
| 5 | WORKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Workgroup |
| 6 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Taskgroup |
| 7 | TASK_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |
| 8 | ELP_TR_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Elapsed Reporting Template |
| 9 | PCH_TR_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Punch Reporting Template |
| 10 | PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL | Time Period ID |
| 11 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |