GPCH_OT_DATA

(SQL Table)
 Index Back

Wkflow Status - Overtime Entry

Contains workflow status information for the Overtime Entry transaction

  • Parent Record Of GPCH_OT_STATUS

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

    Prompt Table: PERSON_NAME

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 GPCH_ROW_NUM Number(5,0) INTEGER NOT NULL Row Number
    4 ACTION_DT_SS Date(10) DATE *Effective Date
    5 GPCH_BEGIN_DATE Date(10) DATE NOT NULL Begin Date
    6 GPCH_END_DATE Date(10) DATE NOT NULL End Date
    7 GPCH_TYPE_OT Character(3) VARCHAR2(3) NOT NULL Type of Overtime

    Prompt Table: GPCH_OT_ENTRY
    Set Control Field: GPCH_TYPE_OT

    8 GPCH_OT_SS_HH Signed Number(7,2) DECIMAL(5,2) NOT NULL Number of Overtime Hours
    9 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    11 GPCH_STATUS Character(3) VARCHAR2(3) NOT NULL Status
    AAP=Approved automatically
    AFA=Awaiting final approval
    APC=Approved with Change
    APV=Approved
    AWC=Approved with change
    CAN=Cancelled
    CNL=Cancelled
    CPR=Cancelled
    DNY=Denied
    ERR=Error - Contact Administrator
    PRC=Processed
    PWC=Processed with change
    REW=Rework required
    SAV=Saved
    SUB=Submitted
    12 PROCESS_DT Date(10) DATE Process Date