RA_RLUPCHILD_VW (SQL View)	Index Back
Roll Up Child View Marketing - View of Programs tied to a Roll Up program

RA_RLUPCHILD_VW

(SQL View)

Roll Up Child View

Marketing - View of Programs tied to a Roll Up program

SELECT BUSINESS_UNIT , RA_ROLLUP_CMPGN_ID , RA_PROGRAM_TYPE , RA_PROGRAM_NAME , RA_CAMPAIGN_ID , DIALOG_ID , RAE_EVENT_ID , RA_BUDGET_CURR FROM PS_RA_PROGRAM_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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_PROGRAM_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing Program type - field that contains valid program types used in marketing, such as Campaigns, Roll ups, Dialogs and Trade Promotions
CMP=Campaign
DLG=Dialog
EVT=Event
RLU=Roll up

4 RA_PROGRAM_NAME Character(254) VARCHAR2(254) NOT NULL Marketing Programs - name field

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

6 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.

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

8 RA_BUDGET_CURR Character(4) VARCHAR2(4) NOT NULL Campaign Budget Currency removed xlat values - use currency code table

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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_PROGRAM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Marketing Program type - field that contains valid program types used in marketing, such as Campaigns, Roll ups, Dialogs and Trade Promotions CMP=Campaign DLG=Dialog EVT=Event RLU=Roll up
4	RA_PROGRAM_NAME	Character(254)	VARCHAR2(254) NOT NULL	Marketing Programs - name field
5	RA_ROLLUP_CMPGN_ID	Character(15)	VARCHAR2(15) NOT NULL	Campaign - Roll Up (Parent) Campaign Identification
6	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
7	RAE_EVENT_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.
8	RA_BUDGET_CURR	Character(4)	VARCHAR2(4) NOT NULL	Campaign Budget Currency removed xlat values - use currency code table