RC_OM_CALLBK_VW (SQL View)	Index Back
OM Result View Outbound Marketing View of callback records by campaign/wave per group

RC_OM_CALLBK_VW

(SQL View)

OM Result View

Outbound Marketing View of callback records by campaign/wave per group

SELECT C.PROVIDER_GRP_ID , B.RA_CAMPAIGN_ID , B.RA_CMPGN_WAVE_ID , A.LEAD_ID , B.BO_ID_CUST , A.SETID_PROV_GRP FROM PS_RC_CALL_RESULT A , PS_RSF_LEAD B , PS_RC_GRP_ASGMNT C WHERE A.DONE_FLAG <> 'Y' AND A.LEAD_ID = B.LEAD_ID AND (A.RC_CALLBACK_DATE < %CurrentDateIn OR (A.RC_CALLBACK_DATE = %CurrentDateIn AND A.RC_CALLBACK_TIME < %CurrentTimeIn)) AND B.BUSINESS_UNIT_RA = C.BUSINESS_UNIT AND B.RA_CAMPAIGN_ID = C.RA_CAMPAIGN_ID AND B.RA_CMPGN_WAVE_ID = C.RA_CMPGN_WAVE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

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 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

5 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

6 SETID_PROV_GRP Character(5) VARCHAR2(5) NOT NULL SetID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
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	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
5	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
6	SETID_PROV_GRP	Character(5)	VARCHAR2(5) NOT NULL	SetID