EMPLIDEMPL_RCDTL_SEQ_NUMAPV=Approved
DNY=Denied
ERR=Error
SUB=Submitted
TL_OT_DATA(SQL Table) |
Index Back |
|---|---|
Overtime Request DataThis table stores the overtime request data of the employees |
| # | 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 | TL_OT_DATE | Date(10) | DATE | Overtime Date |
| 5 | TL_OT_HOURS | Number(2,0) | SMALLINT NOT NULL | Overtime Hours |
| 6 | TL_OT_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Status
APV=Approved DNY=Denied ERR=Error SUB=Submitted |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 8 | TL_SUBMIT_DT | Date(10) | DATE | Submit Date |