TL_OT_DATA

(SQL Table)
 Index Back

Overtime Request Data

This table stores the overtime request data of the employees

  • Parent Record Of TL_OTSTATUS_HST TL_OT_STATUS TL_OT_STATUS_V

    • # 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 TL_OT_DATE Date(10) DATE Overtime Date on Request.
    5 TL_OT_HOURS Number(5,2) DECIMAL(4,2) NOT NULL Overtime Hours
    6 TL_OT_STATUS Character(3) VARCHAR2(3) NOT NULL Status
    APV=Approved
    DNY=Denied
    ERR=Error
    NAP=Needs Approval
    PBK=Push Back
    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