RA_PGM_ROLUPVW2 (SQL View)	Index Back
Program Roll Up ID and Name 2 Program Roll Up ID, Name, Start and End Date, used by only Marketing program configurable search to allow selection of multiple ID's using IN.

RA_PGM_ROLUPVW2

(SQL View)

Program Roll Up ID and Name 2

Program Roll Up ID, Name, Start and End Date, used by only Marketing program configurable search to allow selection of multiple ID's using IN.

SELECT A.BUSINESS_UNIT , A.RA_CMPGN_NAME , A.START_DATE , A.END_DATE FROM PS_RA_CAMPAIGN A , PS_RA_PROGRAM_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND B.RA_PROGRAM_TYPE = 'RLU'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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

3 START_DATE Date(10) DATE Start Date

4 END_DATE Date(10) DATE End date field to store an end date.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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
3	START_DATE	Date(10)	DATE	Start Date
4	END_DATE	Date(10)	DATE	End date field to store an end date.