EMPLIDEMPL_RCDTL_SEQ_NUMOPRIDAPV=Approved
DNY=Denied
ERR=Error
SUB=Submitted
TL_OT_APPR_VW(SQL View) |
Index Back |
|---|---|
Request Overtime View |
| SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.TL_SEQ_NUM , O.OPRID , B.NAME , A.TL_SUBMIT_DT , A.TL_OT_DATE , A.TL_OT_STATUS , C.EMPLID_TO FROM PS_TL_OT_DATA A , PS_PERSON_NAME B , PS_TL_OT_STATUS C , PSOPRDEFN O WHERE A.EMPLID=B.EMPLID AND A.EMPLID=C.EMPLID AND C.EMPLID_TO = O.EMPLID AND A.EMPL_RCD=C.EMPL_RCD AND A.TL_SEQ_NUM=C.TL_SEQ_NUM AND C.TL_WF_ACTION = ' ' AND C.CURRENT_STEP > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | TL_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Table Lookup Sequence Number |
| 4 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | TL_SUBMIT_DT | Date(10) | DATE | Submit Date |
| 7 | TL_OT_DATE | Date(10) | DATE | Overtime Date |
| 8 | TL_OT_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Status
APV=Approved DNY=Denied ERR=Error SUB=Submitted |
| 9 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | EmplID To |