RA_WF_CMP_TK_VW (SQL View)	Index Back
CRM Workflow Action Request VW CRM Workflow Action Request View campaign task

RA_WF_CMP_TK_VW

(SQL View)

CRM Workflow Action Request VW

CRM Workflow Action Request View campaign task

SELECT a.oprid , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , B.BUSINESS_UNIT , B.RA_CAMPAIGN_ID , B.RB_WF_WL_PRIORITY , B.SEQNO , B.TASKDESCR , B.RA_REASON_RECEIVE , B.RA_TASK_STATUS , B.RA_TASK_TYPE , B.RA_PCT_COMPLETE , B.R_DATE_REPORTED , B.WORKLIST_DESCR , A.WL_PRIORITY , A.COMMENTSHORT , C.START_DATE , C.DUE_DT , C.RA_PRIORITY , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , B.WF_PURPOSE , A.SYNCID FROM PSWORKLIST A , PS_RA_CAMP_TASK_WL B , PS_RA_CMPGN_TASK 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 C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND C.SEQNO = B.SEQNO AND A.INSTSTATUS <= 2

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

12 RA_CAMPAIGN_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.

13 RB_WF_WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Notification Priority
1=High
2=Medium
3=Low

14 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

15 TASKDESCR Character(30) VARCHAR2(30) NOT NULL Task Description

16 RA_REASON_RECEIVE Character(100) VARCHAR2(100) NOT NULL Reason to Receive Routing

17 RA_TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Status of the task
ASGN=Assigned
CANC=Cancelled
CMPL=Completed
NEW=New task - not assigned
OVER=Over Due
REJD=Rejected

18 RA_TASK_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing - Task Type

19 RA_PCT_COMPLETE Character(3) VARCHAR2(3) NOT NULL Marketing - Task - Percent Complete

20 R_DATE_REPORTED Date(10) DATE Reported date

21 WORKLIST_DESCR Character(50) VARCHAR2(50) NOT NULL Description

22 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=1-High
2=2-Medium
3=3-Low

23 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment

24 START_DATE Date(10) DATE Start Date for Gen Standing PO

25 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

26 RA_PRIORITY Character(1) VARCHAR2(1) NOT NULL Marketing - campaign wave content task priority
1=High Priority
2=Medium Priority
3=Low Priority

27 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

28 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

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

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	RA_CAMPAIGN_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.
13	RB_WF_WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Notification Priority 1=High 2=Medium 3=Low
14	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
15	TASKDESCR	Character(30)	VARCHAR2(30) NOT NULL	Task Description
16	RA_REASON_RECEIVE	Character(100)	VARCHAR2(100) NOT NULL	Reason to Receive Routing
17	RA_TASK_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Status of the task ASGN=Assigned CANC=Cancelled CMPL=Completed NEW=New task - not assigned OVER=Over Due REJD=Rejected
18	RA_TASK_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Marketing - Task Type
19	RA_PCT_COMPLETE	Character(3)	VARCHAR2(3) NOT NULL	Marketing - Task - Percent Complete
20	R_DATE_REPORTED	Date(10)	DATE	Reported date
21	WORKLIST_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
22	WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-High 2=2-Medium 3=3-Low
23	COMMENTSHORT	Character(30)	VARCHAR2(30) NOT NULL	Short Comment
24	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
25	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
26	RA_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Marketing - campaign wave content task priority 1=High Priority 2=Medium Priority 3=Low Priority
27	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
28	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
29	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.