TL_OT_STATUS_V

(SQL View)
 Index Back

Workflow for Overtime

This table stores the data about the workflow for Overtime Requests

SELECT A.EMPLID , A.EMPL_RCD , A.TL_SEQ_NUM , C.EMPLID_TO , O.OPRID , B.NAME , A.TL_SUBMIT_DT , A.TL_OT_DATE ,A.TL_OT_HOURS , A.TL_OT_STATUS , C.COMMENTS FROM PS_TL_OT_STATUS C , PS_TL_OT_DATA A , PS_PERSON_NAME B , PSOPRDEFN O , PSXLATITEM XLAT WHERE A.EMPLID=B.EMPLID AND C.EMPLID_TO = O.EMPLID AND A.EMPLID=C.EMPLID AND A.EMPL_RCD=C.EMPL_RCD AND A.TL_SEQ_NUM=C.TL_SEQ_NUM AND C.TL_WF_ACTION = 'NAP' AND A.TL_OT_STATUS = XLAT.FIELDVALUE AND XLAT.FIELDNAME='TL_OT_STATUS' AND %EffdtCheck(PSXLATITEM XLATA,XLAT,%CurrentDateIn)

  • Parent record: TL_OT_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: PERSON.EMPLID

    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 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL Empl ID To
    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 TL_SUBMIT_DT Date(10) DATE Submit Date
    8 TL_OT_DATE Date(10) DATE Overtime Date on Request.
    9 TL_OT_HOURS Number(5,2) DECIMAL(4,2) NOT NULL Overtime Hours
    10 TL_OT_STATUS Character(3) VARCHAR2(3) NOT NULL Status
    APV=Approved
    DNY=Denied
    ERR=Error
    NAP=Needs Approval
    PBK=Push Back
    SUB=Submitted
    11 COMMENTS Long Character CLOB Comment