RA_WF_LIST_VW (SQL View)	Index Back
CRM Workflow Action Request VW CRM Workflow Action Request View

RA_WF_LIST_VW

(SQL View)

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.RA_LIST_ID , B.DESCR , B.RB_WF_WL_PRIORITY , B.RA_LIST_STATUS , B.RA_LIST_SOURCE , B.RA_REASON_WORKFLOW , B.QRYNAME , B.LIST_GENERATE_DTTM , B.WORKLIST_DESCR , A.WL_PRIORITY , A.COMMENTSHORT , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , A.SYNCID FROM PSWORKLIST A , PS_RA_LIST_WL 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 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 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID

12 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

14 RA_LIST_STATUS Character(4) VARCHAR2(4) NOT NULL Audience / List Status
010=In Design
020=Designed
030=Scheduled
040=Processing
050=Generated
060=Approved
070=Committed
080=Archived

15 RA_LIST_SOURCE Character(4) VARCHAR2(4) NOT NULL Audience / List Source
CGRP=Control Group
COMP=Combine Audiences
CRIT=Audience Builder
EXT=External Audience
IMP=Import
QRY=PS Query
SEG=Segment
SRCH=Saved Search
TEST=Test Audience
Prompt Table: RA_LIST_SRC_VW

16 RA_REASON_WORKFLOW Character(254) VARCHAR2(254) NOT NULL Reason for Workflow Routing

17 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

18 LIST_GENERATE_DTTM DateTime(26) TIMESTAMP Audience - date last generated

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

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

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

22 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

23 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	RA_LIST_ID	Character(15)	VARCHAR2(15) NOT NULL	Audience ID
12	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
13	RB_WF_WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Notification Priority 1=High 2=Medium 3=Low
14	RA_LIST_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Audience / List Status 010=In Design 020=Designed 030=Scheduled 040=Processing 050=Generated 060=Approved 070=Committed 080=Archived
15	RA_LIST_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Audience / List Source CGRP=Control Group COMP=Combine Audiences CRIT=Audience Builder EXT=External Audience IMP=Import QRY=PS Query SEG=Segment SRCH=Saved Search TEST=Test Audience Prompt Table: RA_LIST_SRC_VW
16	RA_REASON_WORKFLOW	Character(254)	VARCHAR2(254) NOT NULL	Reason for Workflow Routing
17	QRYNAME	Character(30)	VARCHAR2(30) NOT NULL	Query Name
18	LIST_GENERATE_DTTM	DateTime(26)	TIMESTAMP	Audience - date last generated
19	WORKLIST_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
20	WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-High 2=2-Medium 3=3-Low
21	COMMENTSHORT	Character(30)	VARCHAR2(30) NOT NULL	Short Comment
22	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
23	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.