RC_CALL_PSPT_VW (SQL View)	Index Back
Work flow Action Request Telemarketing Work flow Action Request View

RC_CALL_PSPT_VW

(SQL View)

Work flow Action Request

Telemarketing Work flow Action Request View

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.TRANSACTIONID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , B.BUSINESS_UNIT , B.RA_CAMPAIGN_ID , B.RA_CMPGN_WAVE_ID , B.RB_WF_WL_PRIORITY , B.LEAD_ID , B.RC_CALL_STATUS , B.RC_FINAL_DISPOSTN , B.SETID , B.PRODUCT_ID , B.REQUEST_DT , B.PERSON_ID , B.WORKLIST_DESCR , A.WL_PRIORITY , A.COMMENTSHORT , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , A.SYNCID FROM PSWORKLIST A , PS_RC_CALL_PSPT_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.TRANSACTIONID = B.TRANSACTIONID 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 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier

8 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
0=Selected
1=Open
2=Worked
3=Cancelled

9 INSTAVAILABLEDTTM DateTime(26) TIMESTAMP Datetime worklist instance was made available

10 INSTTIMEOUTDTTM DateTime(26) TIMESTAMP Datetime that a worklist times out

11 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier

12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

14 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID

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

16 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

17 RC_CALL_STATUS Character(2) VARCHAR2(2) NOT NULL Outbound Marketing
CB=Call Back
CL=Close
NC=No Contact

18 RC_FINAL_DISPOSTN Character(2) VARCHAR2(2) NOT NULL Outbound Marketing final disposition status field
DN=Do Not Call Again
GC=To Capture an Order
GL=Generate a Lead
NI=Not Interested
SA=Sale
SE=Send Collateral by Email
SM=Send Collateral by Mail

19 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

20 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

21 REQUEST_DT Date(10) DATE Request date field to store request date value.

22 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

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

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

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

26 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

27 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	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
8	INSTSTATUS	Number(5,0)	INTEGER NOT NULL	Determines worklist status, available, selected, worked, cancelled 0=Selected 1=Open 2=Worked 3=Cancelled
9	INSTAVAILABLEDTTM	DateTime(26)	TIMESTAMP	Datetime worklist instance was made available
10	INSTTIMEOUTDTTM	DateTime(26)	TIMESTAMP	Datetime that a worklist times out
11	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
12	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
13	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.
14	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID
15	RB_WF_WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Notification Priority 1=High 2=Medium 3=Low
16	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
17	RC_CALL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Outbound Marketing CB=Call Back CL=Close NC=No Contact
18	RC_FINAL_DISPOSTN	Character(2)	VARCHAR2(2) NOT NULL	Outbound Marketing final disposition status field DN=Do Not Call Again GC=To Capture an Order GL=Generate a Lead NI=Not Interested SA=Sale SE=Send Collateral by Email SM=Send Collateral by Mail
19	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
20	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
21	REQUEST_DT	Date(10)	DATE	Request date field to store request date value.
22	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
23	WORKLIST_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
24	WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-High 2=2-Medium 3=3-Low
25	COMMENTSHORT	Character(30)	VARCHAR2(30) NOT NULL	Short Comment
26	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
27	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.