RC_CALL_SUMMRY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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.
3	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID
4	RC_LIST_COUNT	Number(8,0)	INTEGER NOT NULL	Outbound Marketing
5	RC_COMPLETED_CALL	Number(8,0)	INTEGER NOT NULL	Outbound Marketing
6	RC_ATTEMPTED_CALL	Number(8,0)	INTEGER NOT NULL	Call Center - Outbound Marketing Prospects - Attempted Calls
7	RC_POSITIVE_CALL	Number(8,0)	INTEGER NOT NULL	Call Center - Outbound Marketing Prospects - Positive Calls
8	RC_ORDER_CALL	Number(8,0)	INTEGER NOT NULL	Call Center - Outbound Marketing Prospects -Order Calls
9	RC_DONOT_CALL	Number(8,0)	INTEGER NOT NULL	Call Center - Outbound Marketing Prospects -Do Not Contact Calls
10	RC_CALLS_LEFT	Number(8,0)	INTEGER NOT NULL	Calls Remaining
11	RC_CALLBACK_CALL	Number(8,0)	INTEGER NOT NULL	Outbound Marketing
12	RC_NO_CONTACT	Number(8,0)	INTEGER NOT NULL	Outbound Marketing
13	RC_OM_CNTCT_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Outbound Marketing - Contact Method E=Email M=Mail O=Other P=Phone
14	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
15	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
16	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
17	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
18	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.
19	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time