RF_WFL_EVTS_VW3(SQL View) |
Index Back |
|---|---|
WorkFlow EventSet EventsThis 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 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 |