RC_OMPR_ASGND_V (SQL View)	Index Back
Telemarketing Assigned View Telemarketing, this view contains all prospects ordered by person id, campaign wave that are assigned, prospect switch is a Y and PROSPECT STATUS is Assigned

RC_OMPR_ASGND_V

(SQL View)

Telemarketing Assigned View

Telemarketing, this view contains all prospects ordered by person id, campaign wave that are assigned, prospect switch is a Y and PROSPECT STATUS is Assigned

SELECT B.ASSIGNED_TO , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.LEAD_ID FROM PS_RSF_LEAD A , PS_RC_CALL_RESULT B WHERE A.RC_PROSPECT_SW = 'Y' AND A.RC_PROSPECT_STAT = 'A' AND A.LEAD_ID = B.LEAD_ID AND B.DONE_FLAG <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
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.