RBB_WS_WL_VW(SQL View) |
Index Back |
|---|---|
External Worklist ViewExternal Business Process Worklist View |
| SELECT B.OPRID , B.BUSPROCNAME , B.ACTIVITYNAME , B.EVENTNAME , B.WORKLISTNAME , B.INSTANCEID , B.INSTSTATUS , B.INSTAVAILABLEDTTM , B.INSTTIMEOUTDTTM , A.RBB_CONVERSATIONID , ' ' , B.INSTAVAILABLEDTTM , B.WL_PRIORITY , B.INSTTIMEOUTDTTM , ' ' , ' ' , A.RBB_BPELPROCNAME , A.RBB_BPELACTNAME , A.RBB_OUTCOME_ID , B.OPRID , B.ORIGINATORID , B.COMMENTSHORT , A.RBB_ENABLE_URL , A.RBB_ENABLE_EUM , A.RBB_TITLE , B.WL_PRIORITY , B.COMMENTSHORT , CASE WHEN B.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , A.WF_PURPOSE , B.SYNCID FROM PS_RBB_WS_WL A , PSWORKLIST B WHERE A.BUSPROCNAME = B.BUSPROCNAME AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.EVENTNAME = B.EVENTNAME AND A.WORKLISTNAME = B.WORKLISTNAME AND A.INSTANCEID = B.INSTANCEID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 3 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| 4 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 5 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 6 | INSTANCEID | Number(10,0) | DECIMAL(10) NOT NULL | For a given worklist the unique number of rows in PSWORKLIST |
| 7 | INSTSTATUS | Number(5,0) | INTEGER NOT NULL |
Determines worklist status, available, selected, worked, cancelled
0=Selected 1=Open 2=Worked 3=Cancelled |
| 8 | INSTAVAILABLEDTTM | DateTime(26) | TIMESTAMP | Datetime worklist instance was made available |
| 9 | INSTTIMEOUTDTTM | DateTime(26) | TIMESTAMP | Datetime that a worklist times out |
| 10 | RBB_CONVERSATIONID | Character(100) | VARCHAR2(100) NOT NULL | BPEL Conversation ID |
| 11 | RBB_BO_NAME_DISP | Character(30) | VARCHAR2(30) NOT NULL | Owner of the External Business Process Worklist entry |
| 12 | RBB_INSTAVAIL_DTTM | DateTime(26) | TIMESTAMP | External Business Process Worklist entry Created Date & Time |
| 13 | RBB_WL_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
External Worklist Entry Priority
1=1-High 2=2-Medium 3=3-Low |
| 14 | RBB_INSTTMOUT_DTTM | DateTime(26) | TIMESTAMP | External Business Process Timed-out Date Time |
| 15 | RBB_INITIATING_TRN | Character(1) | VARCHAR2(1) NOT NULL | URL to the Initiating Transaction |
| 16 | RBB_PROC_MONITOR | Character(1) | VARCHAR2(1) NOT NULL | URL to the BPEL End-User Monitor |
| 17 | RBB_BPELPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | External Business Process Name |
| 18 | RBB_BPELACTNAME | Character(30) | VARCHAR2(30) NOT NULL | External Business Process Activity Name |
| 19 | RBB_OUTCOME_ID | Character(30) | VARCHAR2(30) NOT NULL | Business Process Outcome ID |
| 20 | RBB_OPRID | Character(30) | VARCHAR2(30) NOT NULL | External Business Process Worklist entry Owner ID |
| 21 | RBB_ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL | Worklist Originator ID |
| 22 | RBB_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description of BPEL related setup objects. |
| 23 | RBB_ENABLE_URL | Character(1) | VARCHAR2(1) NOT NULL | Flag to enable hyperlink to the Initiating Transaction |
| 24 | RBB_ENABLE_EUM | Character(1) | VARCHAR2(1) NOT NULL | Flag to enable BPEL End-User Monitor |
| 25 | RBB_TITLE | Character(50) | VARCHAR2(50) NOT NULL | Title of the Activity Status Page |
| 26 | WL_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Worklist Priority
1=1-High 2=2-Medium 3=3-Low |
| 27 | COMMENTSHORT | Character(30) | VARCHAR2(30) NOT NULL | Short Comment |
| 28 | SHOW_COMPLETED | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to determine whether the worklist should be filtered to show only completed worklist entries.
Y/N Table Edit Default Value: N |
| 29 | 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 |
| 30 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |