PSARCH_IDPSARCH_BATCHNUMEMPLIDEMPL_RCDTL_SEQ_NUMAPV=Approved
DNY=Denied
ERR=Error
NAP=Needs Approval
PBK=Push Back
SUB=Submitted
TL_OT_DATA_HST(SQL Table) |
Index Back |
|---|---|
Archive Rec - Overtime RequestArchive Record for Overtime Request |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | TL_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Table Lookup Sequence Number |
| 6 | TL_OT_DATE | Date(10) | DATE | Overtime Date on Request. |
| 7 | TL_OT_HOURS | Number(5,2) | DECIMAL(4,2) NOT NULL | Overtime Hours |
| 8 | TL_OT_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Status
APV=Approved DNY=Denied ERR=Error NAP=Needs Approval PBK=Push Back SUB=Submitted |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | TL_SUBMIT_DT | Date(10) | DATE | Submit Date |