RC_CALL_PSP_WL3 (SQL Table)	Index Back
Telemarketing Telemarketing Campaign Work List

RC_CALL_PSP_WL3

(SQL Table)

Telemarketing

Telemarketing Campaign Work List

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

2 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).

3 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

4 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name

5 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST

6 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier

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

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

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

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

11 RB_WF_WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Notification Priority
1=High
2=Medium
3=Low
Default Value: 1

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

13 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

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

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

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

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

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

19 RA_WAVE_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN).
2	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN).
3	EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Defines a routing event for PS Workflow
4	WORKLISTNAME	Character(30)	VARCHAR2(30) NOT NULL	Worklist Name
5	INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	For a given worklist the unique number of rows in PSWORKLIST
6	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	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.
9	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID
10	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
11	RB_WF_WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Notification Priority 1=High 2=Medium 3=Low Default Value: 1
12	RC_CALL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Outbound Marketing CB=Call Back CL=Close NC=No Contact
13	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
14	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
15	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
16	REQUEST_DT	Date(10)	DATE	Request date field to store request date value.
17	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
18	WORKLIST_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
19	RA_WAVE_NAME	Character(50)	VARCHAR2(50) NOT NULL	Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.