RF_WFL_EVTST_VW

(SQL View)
 Index Back

WorkFlow EventSet Events

This table 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 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) 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 > 1)

# 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