RAE_EVENT_WL

(SQL Table)
Index Back

Event Work list

Event Work list - business process designer routing information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
2 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
3 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
4 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
5 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
6 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 RAE_EVENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.
9 RB_WF_WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Notification Priority
1=High
2=Medium
3=Low
10 RAE_EVENT_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.
11 RAE_EVENTSTATUS_CD Character(4) VARCHAR2(4) NOT NULL Valid Campaign and Wave Status Codes
APPR=Approved
CMPL=Completed
DCLN=Declined
EXEC=Executing
IREV=In Review
NEW=New
STOP=Stopped
12 RA_REASON_WORKFLOW Character(254) VARCHAR2(254) NOT NULL Reason for Workflow Routing
13 R_DATE_REPORTED Date(10) DATE Reported date
14 WORKLIST_DESCR Character(50) VARCHAR2(50) NOT NULL Description
15 WF_PURPOSE Character(4) VARCHAR2(4) NOT NULL Purpose of the Notification
0=FYI
APPR=Approval Required
ASSN=Assignment
ESCA=Escalation
FOLL=Follow-Up Requested
HOLD=Hold Notification
SLA=SLA Warning
SLAX=SLA Exception
STAT=Status Change
TASG=Task Assignment
UPD=Update Notification