RSF_WF_OPP_VW

(SQL View)
Index Back

CRM Workflow Action Request VW

CRM Workflow Action Request View

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , B.OPPORTUNITY_ID , C.BUSINESS_UNIT , C.BO_ID_CUST , B.OPPORTUNITY_NAME , B.WORKLIST_DESCR , A.WL_PRIORITY , A.COMMENTSHORT , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , B.WF_PURPOSE , A.SYNCID FROM PSWORKLIST A , PS_RSF_OPP_WL1 B , PS_RSF_OPPORTUNITY C 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 AND A.INSTSTATUS <= 2 AND B.OPPORTUNITY_ID = C.OPPORTUNITY_ID

# 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 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
11 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
13 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
14 OPPORTUNITY_NAME Character(50) VARCHAR2(50) NOT NULL Opportunity Name - User Enters this field in Mixed Case.
15 WORKLIST_DESCR Character(50) VARCHAR2(50) NOT NULL Description
16 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=1-High
2=2-Medium
3=3-Low
17 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
18 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

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
20 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.