WF_HR_TRANS

(SQL Table)
 Index Back

Workflow Configuration Record

Workflow Configuration record for page WF_CO_CONFIG. Values based off EO_TRANSACTIONS.

  • Parent record: EO_TRANSACTIONS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name

    Prompt Table: HCM_EO_TXN_VW

    2 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN
    Set Control Field: ROLENAME

    3 ALLOW_DB_UPDT Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Allow Auto Update" on configuration page.
    N=Don't Allow Updates
    Y=Allow Updates

    Y/N Table Edit

    Default Value: N

    4 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

    Default Value: N

    5 APPR_LOGIC_EXISTS Character(1) VARCHAR2(1) NOT NULL Field used in record WF_HR_TRANS. This field will be used as a flag to show a checkbox.
    N=No Approval Logic
    Y=Approval Logic

    Default Value: N

    6 HR_ADMIN_APPR_REQ 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

    Default Value: N

    7 HR_ADMIN_NC_STATUS Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Notification Composer" on configuration page.
    N=Notifi Composer not enabled
    Y=Notifi Composer enabled

    Default Value: N

    8 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Default Value: N