RA_WHATIF_LNG (SQL View)	Index Back
View used in BAM reports Related Language view for RA_WHATIFQRY_VW

RA_WHATIF_LNG

(SQL View)

View used in BAM reports

Related Language view for RA_WHATIFQRY_VW

SELECT A.BUSINESS_UNIT ,PRG.RA_ROLLUP_CMPGN_ID ,A.RA_CAMPAIGN_ID ,B.RA_CMPGN_WAVE_ID ,L.LANGUAGE_CD ,A.RA_CMPGN_NAME ,B.RA_WAVE_NAME ,L.DESCR ,PRG.RA_ROLLUP_CM_NAME FROM PS_RA_CAMPAIGN A ,PS_RA_CMPGN_WAVE B ,PS_RA_WAVE_STAT_VW RR ,PS_RA_UD_CHNLT_LNG L ,PS_RA_PGM_GRD_VW1 PRG WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND A.BUSINESS_UNIT = PRG.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = PRG.RA_CAMPAIGN_ID AND B.BUSINESS_UNIT = RR.BUSINESS_UNIT(+) AND B.RA_CAMPAIGN_ID = RR.RA_CAMPAIGN_ID(+) AND B.RA_CMPGN_WAVE_ID = RR.RA_CMPGN_WAVE_ID(+) AND B.RA_ACTIVITY_CD = L.RA_ACTIVITY_CD(+) AND B.RA_CHANNEL_TYPE = L.RA_CHANNEL_TYPE(+) AND L.SETID = RR.SETID GROUP BY A.BUSINESS_UNIT, PRG.RA_ROLLUP_CMPGN_ID, A.RA_CAMPAIGN_ID, B.RA_CMPGN_WAVE_ID, L.LANGUAGE_CD, A.RA_CMPGN_NAME, B.RA_WAVE_NAME, L.DESCR, PRG.RA_ROLLUP_CM_NAME

Related Language Record for RA_WHATIFQRY_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RA_ROLLUP_CMPGN_ID Character(15) VARCHAR2(15) NOT NULL Campaign - Roll Up (Parent) Campaign Identification

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

4 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
Prompt Table: RA_UD_CPGN_STAT

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 RA_CMPGN_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.

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

8 DESCR Character(30) VARCHAR2(30) NOT NULL Description

9 RA_ROLLUP_CM_NAME Character(50) VARCHAR2(50) NOT NULL Rollup Campaign Name - used in view for Home Grd. This is the name of the rollup campaign

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RA_ROLLUP_CMPGN_ID	Character(15)	VARCHAR2(15) NOT NULL	Campaign - Roll Up (Parent) Campaign Identification
3	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.
4	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID Prompt Table: RA_UD_CPGN_STAT
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	RA_CMPGN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Campaign Name - field containing the name of the campaign.
7	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.
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	RA_ROLLUP_CM_NAME	Character(50)	VARCHAR2(50) NOT NULL	Rollup Campaign Name - used in view for Home Grd. This is the name of the rollup campaign