EMPLIDEMPL_RCDTL_SEQ_NUMAPV=Approved
DNY=Denied
ERR=Error
NAP=Needs Approval
PBK=Push Back
SUB=Submitted
TL_OT_DATA_VW(SQL View) |
Index Back |
|---|---|
Overtime Request DataThis table stores the overtime request data of the employees |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.TL_SEQ_NUM ,NAM.NAME_DISPLAY ,A.TL_OT_DATE ,A.TL_OT_HOURS ,'' ,A.TL_OT_STATUS ,A.OPRID ,A.TL_SUBMIT_DT FROM PS_TL_OT_DATA A , PS_NAMES NAM WHERE A.EMPLID = NAM.EMPLID AND NAM.EFFDT = ( SELECT MAX (NM1.EFFDT) FROM PS_NAMES NM1 WHERE NAM.EMPLID = NM1.EMPLID AND NM1.NAME_TYPE = 'PRI' AND NM1.EFFDT <= %CurrentDateIn) |
| # | 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 Record |
| 3 | TL_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Table Lookup Sequence Number |
| 4 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 5 | TL_OT_DATE | Date(10) | DATE | Overtime Date on Request. |
| 6 | TL_OT_HOURS | Number(5,2) | DECIMAL(4,2) NOT NULL | Overtime Hours |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 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 |