RC_CALL_PSP_WL1

(SQL Table)
Index Back

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: 2

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