TL_OT_STATUS

(SQL Table)
 Index Back

Workflow for Overtime

This table stores the data about the workflow for Overtime Requests

  • 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 Rcd Nbr
    3 TL_SEQ_NUM Number(5,0) INTEGER NOT NULL Table Lookup Sequence Number
    4 APPR_STEP Character(3) VARCHAR2(3) NOT NULL Approval Step
    1=Approval Step 1
    2=Approval Step 2
    3=Approval Step 3
    4=Approval Step 4
    5=Approval Step 5
    6=Approval Step 6
    7=Approval Step 7
    8=Approval Step 8
    9=Approval Step 9
    5 APPR_PATH Character(3) VARCHAR2(3) NOT NULL Approval Path
    A=Approval Path A
    B=Approval Path B
    C=Approval Path C
    D=Approval Path D
    E=Approval Path E
    6 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    7 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    8 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL EmplID To
    9 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    10 TL_WF_ACTION Character(3) VARCHAR2(3) NOT NULL Workflow Action
    APV=Approved
    DNY=Denied
    SUB=Submitted
    11 TRANS_DT Date(10) DATE Transaction Date
    12 CURRENT_STEP Number(3,0) SMALLINT NOT NULL Current Step Number
    13 COMMENTS Long Character CLOB Comment