WF_HR_TRANS_NOT

(SQL Table)
 Index Back

HR SelfService Workflow Config

Child table to WF_HR_TRANS - defines Administrator Notification rules and objects to be used for workflow.

  • Parent record: WF_HR_TRANS

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

    Prompt Table: PSPNLGRPDEFN_VW

    3 NOTIFY_ON_SUCCESS Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Notify on Success" on configuration page.
    N=Not Successful
    Y=Notify on Success

    Default Value: N

    4 NOTIFY_ON_WARNINGS Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Notify on Warnings" on configuration page.
    N=No Warning
    Y=Notify on Warning

    Default Value: N

    5 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

    Prompt Table: PSBUSPROCDEFN

    6 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).

    Prompt Table: ACTIVITY_PROMPT

    7 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

    Prompt Table: PSEVENTDEFN

    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