GPCH_OT_STATUS

(SQL Table)
 Index Back

Wokflow for Overtime

This record is a child of GPCH_OT_DATA and is used to store data about each step of the worflow approval process for an Overtime Entry

  • Parent record: GPCH_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

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 GPCH_ROW_NUM Number(5,0) INTEGER NOT NULL Row 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 Empl ID To
    9 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    10 GPCH_WF_ACTION Character(3) VARCHAR2(3) NOT NULL Workflow Action
    AAP=Automatic
    APC=Approved with Change
    APV=Approved
    CAN=Cancelled
    CHG=Changed
    CNL=Cancelled
    DNY=Denied
    REW=Rework required
    SAV=Saved
    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