HR_MGR_REP_DAT

(SQL Table)
 Index Back

Wkflow Status - Reporting Chg

Contains workflow status information for the HR Reporting Change transaction

  • Parent Record Of FE_MGR_REP_TRAN HR_REPORT_TRANS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
    2 ACTION_DT_SS Date(10) DATE NOT NULL Reporting Change Date
    3 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Default Value: DTA

    Prompt Table: ACTION_TBL

    4 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
    5 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
    A=Approved
    C=Cancelled
    D=Denied
    E=Error. Contact Administrator.
    F=Awaiting final approval
    I=In Approval Process
    M=Administrator is Processing
    N=Not Available
    P=Rework
    S=Submitted
    V=Data Saved
    6 HR_REPCHNG_REASON Character(3) VARCHAR2(3) NOT NULL Action / Reason
    DTA=Reporting Change

    Default Value: DTA

    7 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

    Prompt Table: HR_ACTIVE_DVW

    8 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

    Prompt Table: POSITION_DATA

    9 APPROVAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
    N=No Approval Required
    Y=Approval Required
    10 COMMENTS Long Character CLOB Comment