RA_DBPROGRAM_VW (SQL View)	Index Back
Program Table for Dash Board View of Program Table used for Dash Board data extraction

RA_DBPROGRAM_VW

(SQL View)

Program Table for Dash Board

View of Program Table used for Dash Board data extraction

SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_PROGRAM_TYPE , ITM.XLATLONGNAME , A.RA_PROGRAM_NAME , B.RA_OBJECTIVE_CD , B.DESCR , A.START_DATE , A.END_DATE , A.INDUSTRY_ID , A.BO_ID_OWNER , A.NAME , B.SETID FROM PS_RA_PROGRAM_TBL A , PS_RA_UD_CMPGN_OBJ B , PS_SET_CNTRL_REC C , PSXLATITEM ITM WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'RA_UD_CMPGN_OBJ' AND C.SETID = B.SETID AND A.RA_OBJECTIVE_CD = B.RA_OBJECTIVE_CD AND ITM.FIELDNAME = 'RA_PROGRAM_TYPE' AND ITM.EFF_STATUS = 'A' AND A.RA_PROGRAM_TYPE = ITM.FIELDVALUE

# 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 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description

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

6 RA_OBJECTIVE_CD Character(4) VARCHAR2(4) NOT NULL Objective code of the campaign

7 RA_OBJECTIVE Character(50) VARCHAR2(50) NOT NULL Objective / Initiative free form entry field

8 START_DATE Date(10) DATE Start Date

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

10 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.

11 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID

12 NAME Character(50) VARCHAR2(50) NOT NULL Name

13 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

#	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	DESCR30	Character(30)	VARCHAR2(30) NOT NULL	Description
5	RA_PROGRAM_NAME	Character(254)	VARCHAR2(254) NOT NULL	Marketing Programs - name field
6	RA_OBJECTIVE_CD	Character(4)	VARCHAR2(4) NOT NULL	Objective code of the campaign
7	RA_OBJECTIVE	Character(50)	VARCHAR2(50) NOT NULL	Objective / Initiative free form entry field
8	START_DATE	Date(10)	DATE	Start Date
9	END_DATE	Date(10)	DATE	End date field to store an end date.
10	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID.
11	BO_ID_OWNER	Number(31,0)	DECIMAL(31) NOT NULL	Financial Account Business Object ID
12	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
13	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.