RA_WF_CON_TK_VW (SQL View)	Index Back
CRM Workflow Action Request VW CRM Workflow Action Request View content task

RA_WF_CON_TK_VW

(SQL View)

CRM Workflow Action Request VW

CRM Workflow Action Request View content task

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , B.SETID , B.RA_CONTENT_ID , B.SEQNO , B.TASKDESCR , B.RB_WF_WL_PRIORITY , B.RA_TASK_STATUS , B.RA_TASK_TYPE , C.DUE_DT , B.RA_REASON_RECEIVE , C.RA_PCT_COMPLETE , B.R_DATE_REPORTED , B.WORKLIST_DESCR , A.WL_PRIORITY , A.COMMENTSHORT , C.START_DATE , C.RA_PRIORITY , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , B.WF_PURPOSE , A.SYNCID FROM PSWORKLIST A , PS_RA_CONT_TASK_WL B , PS_RA_CONTENT_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.SETID = B.SETID AND C.RA_CONTENT_ID = B.RA_CONTENT_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 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

12 RA_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Content ID

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

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

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

16 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

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

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

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

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

21 R_DATE_REPORTED Date(10) DATE Reported date

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

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

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

25 START_DATE Date(10) DATE Date Assigned

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	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
12	RA_CONTENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing - Content ID
13	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
14	TASKDESCR	Character(30)	VARCHAR2(30) NOT NULL	Task Description
15	RB_WF_WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Notification Priority 1=High 2=Medium 3=Low
16	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
17	RA_TASK_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Marketing - Task Type
18	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.
19	RA_REASON_RECEIVE	Character(100)	VARCHAR2(100) NOT NULL	Reason to Receive Routing
20	RA_PCT_COMPLETE	Character(3)	VARCHAR2(3) NOT NULL	Marketing - Task - Percent Complete
21	R_DATE_REPORTED	Date(10)	DATE	Reported date
22	WORKLIST_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
23	WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-High 2=2-Medium 3=3-Low
24	COMMENTSHORT	Character(30)	VARCHAR2(30) NOT NULL	Short Comment
25	START_DATE	Date(10)	DATE	Date Assigned
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.