RBB_WS_WL

(SQL Table)
Index Back

RBB_WS_WL

Main External Business Process Worklist Table

# 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 RBB_TITLE Character(50) VARCHAR2(50) NOT NULL Title of the Activity Status Page
8 RBB_MAPPING_ID Character(30) VARCHAR2(30) NOT NULL Application Specific Mapping Identifier
9 RBB_OUTCOME_ID Character(30) VARCHAR2(30) NOT NULL Business Process Outcome ID
10 RBB_OUTCOME_CD Character(4) VARCHAR2(4) NOT NULL Business Process Outcome Code
YES=YES
11 RBB_DFLT_OUTCOME Character(30) VARCHAR2(30) NOT NULL Default Outcome Code
12 RBB_CONVERSATIONID Character(100) VARCHAR2(100) NOT NULL BPEL Conversation ID
13 RBB_URL Character(254) VARCHAR2(254) NOT NULL Application Alternate URL for the secondary Transaction
14 WORKLIST_DESCR Character(50) VARCHAR2(50) NOT NULL Description
15 RBB_BPELPROCNAME Character(30) VARCHAR2(30) NOT NULL External Business Process Name
16 RBB_BPELACTNAME Character(30) VARCHAR2(30) NOT NULL External Business Process Activity Name
17 RBB_ENABLE_EUM Character(1) VARCHAR2(1) NOT NULL Flag to enable BPEL End-User Monitor

Default Value: Y

18 RBB_ENABLE_URL Character(1) VARCHAR2(1) NOT NULL Flag to enable hyperlink to the Initiating Transaction

Default Value: Y

19 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