OPRIDEMPLIDEFFDTDefault Value: %date
A=Active
I=Inactive
TL_TR_ESS_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.EFFDT , 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 FROM PS_TL_EMPL_DATA E , PS_TL_OPR_CLASS_VW O WHERE E.EMPLID = O.EMPLID AND E.TIME_RPTG_STATUS = '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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 5 | TIME_RPTG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Time Reporter Status
A=Active I=Inactive |
| 6 | WORKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Workgroup |
| 7 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Taskgroup |
| 8 | TASK_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |
| 9 | ELP_TR_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Elapsed Reporting Template |
| 10 | PCH_TR_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Punch Reporting Template |
| 11 | PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL | Time Period ID |