RF_WFL_EVTS_VW2

(SQL View)
 Index Back

WorkFlow EventSet Events

This view is used for WorkFlow EventSet Events.

SELECT A.SETID , A.MARKET , A.PNLGRPNAME , A.SEQNUM , A.ORDER_NBR , A.ENABLED , A.EVENTNAME , A.RC_ES_ITEM_TYPE , A.EVENTNAME_EVAL , A.RULE_NAME , A.EMAIL_FORMID , A.INCLUDE_URL FROM PS_RF_WFL_EVTSTEVT A WHERE A.ENABLED = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_RC_EVENTDFN_ROW B WHERE A.MARKET = B.MARKET AND A.PNLGRPNAME = B.PNLGRPNAME AND A.EVENTNAME = B.EVENTNAME AND B.OCCURSLEVEL > 0)

  • Parent record: RF_WFL_EVENTSET

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Default Value: GBL

    3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: RC_EVENT_MODEL

    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    5 ORDER_NBR Number(3,0) SMALLINT NOT NULL Order Nbr

    Default Value: 10

    6 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.
    7 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

    Prompt Table: RC_EVENT_DFN

    8 RC_ES_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL RC_ES_ITEM_TYPE
    0=Notify Immediately
    1=Delay Notification

    Default Value: 0

    9 EVENTNAME_EVAL Character(30) VARCHAR2(30) NOT NULL Defines a routing evaluation event for PS Workflow

    Prompt Table: RC_EVENT_DFN

    10 RULE_NAME Character(30) VARCHAR2(30) NOT NULL This field is a text field of 30 character long.

    Prompt Table: RB_ACTV_WFRULE

    11 EMAIL_FORMID Character(20) VARCHAR2(20) NOT NULL Email Template
    12 INCLUDE_URL Character(1) VARCHAR2(1) NOT NULL INCLUDE_URL
    N=No
    Y=Yes

    Default Value: Y