EMPLIDEMPL_RCDTL_SEQ_NUMAPV=Approved
DNY=Denied
ERR=Error
SUB=Submitted
TL_OTS_VW(SQL View) |
Index Back |
|---|---|
Request Overtime - view |
| SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.TL_SEQ_NUM , B.NAME , A.TL_SUBMIT_DT , A.TL_OT_DATE , A.TL_OT_STATUS , A.TL_OT_HOURS , C.EMPLID_TO FROM PS_TL_OT_DATA A , PS_PERSON_NAME B , PS_TL_OT_STATUS C WHERE A.EMPLID=B.EMPLID AND A.EMPLID=C.EMPLID AND A.EMPL_RCD=C.EMPL_RCD AND A.TL_OT_STATUS = 'SUB' 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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | TL_SUBMIT_DT | Date(10) | DATE | Submit Date |
| 6 | TL_OT_DATE | Date(10) | DATE | Overtime Date |
| 7 | TL_OT_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Status
APV=Approved DNY=Denied ERR=Error SUB=Submitted |
| 8 | TL_OT_HOURS | Number(2,0) | SMALLINT NOT NULL | Overtime Hours |
| 9 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | EmplID To |