ROF_REC_TST_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
3	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
4	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
5	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
8	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.
9	RA_OFFER_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing Offer ID
10	ROF_OFFER_SCORE	Number(6,2)	DECIMAL(5,2) NOT NULL	Offer score value
11	ROF_OFFER_DISP_ID	Character(4)	VARCHAR2(4) NOT NULL	Offer disposition ACPT=Offer Accepted ADVS=Went to Advisor Dialog BSCR=Went to Branch Script FOPP=Offer Deferred NOTP=Not Presented PRES=Presented, No Action Taken REJC=Offer Rejected
12	RA_SCRIPT_ID_INBN	Number(12,0)	DECIMAL(12) NOT NULL	Inbound Script ID - Numeric
13	RAD_ADVISOR_ID	Character(20)	VARCHAR2(20) NOT NULL	Advisor Dialog Guid - represents internally the Advisor dialog
14	ROF_FROM_3RD_PARTY	Character(1)	VARCHAR2(1) NOT NULL	Is offer from a third party Y/N Table Edit Default Value: N
15	BUSINESS_UNIT_RA	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
16	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.
17	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID