RC_OB_TEAMCW_VW (SQL View)	Index Back
Call Team Campaign Wave Telemarketing team by Campaign Wave

RC_OB_TEAMCW_VW

(SQL View)

Call Team Campaign Wave

Telemarketing team by Campaign Wave

SELECT A.SETID , A.PROVIDER_GRP_ID , B.BUSINESS_UNIT , B.RA_CAMPAIGN_ID , B.RA_CMPGN_WAVE_ID , B.RA_WAVE_NAME , B.RA_PRIORITY , D.RC_CALLS_LEFT FROM PS_RF_PROVIDER_GRP A , PS_RA_CMPGN_WAVE B , PS_SET_CNTRL_REC C , PS_RC_CALL_SUMMRY D , PS_RA_UD_CHNL_TYPE E , PS_SET_CNTRL_REC SC WHERE A.SETID = C.SETID AND C.RECNAME = 'RF_PROVIDER_GRP' AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND B.RA_CMPGN_STATUS_CD = 'EXEC' AND SC.SETCNTRLVALUE = B.BUSINESS_UNIT AND SC.RECNAME = 'RA_UD_CHNL_TYPE' AND E.SETID = SC.SETID AND B.RA_CHANNEL_TYPE = E.RA_CHANNEL_TYPE AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.RA_CAMPAIGN_ID = D.RA_CAMPAIGN_ID AND B.RA_CMPGN_WAVE_ID = D.RA_CMPGN_WAVE_ID AND D.RC_LIST_COUNT <> 0

# 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 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 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.

5 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID

6 RA_WAVE_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.

7 RA_PRIORITY Character(1) VARCHAR2(1) NOT NULL Marketing - campaign wave content task priority
1=High Priority
2=Medium Priority
3=Low Priority

8 RC_CALLS_LEFT Number(8,0) INTEGER NOT NULL Calls Remaining

#	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	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	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.
5	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID
6	RA_WAVE_NAME	Character(50)	VARCHAR2(50) NOT NULL	Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.
7	RA_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Marketing - campaign wave content task priority 1=High Priority 2=Medium Priority 3=Low Priority
8	RC_CALLS_LEFT	Number(8,0)	INTEGER NOT NULL	Calls Remaining