RA_CMPGN_GRD_VW (SQL View)	Index Back
Roll up Campaign Grid View Marketing Campaign Roll up Campaign grid view

RA_CMPGN_GRD_VW

(SQL View)

Roll up Campaign Grid View

Marketing Campaign Roll up Campaign grid view

SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_CMPGN_NAME , A.RA_PROGRAM_TYPE , A.DESCR254 , A.RA_OBJECTIVE_CD , A.RA_ROLLUP_CMPGN_ID , A.RA_ROLLUP_CM_NAME , A.RA_PROGRAM_STATUS , A.RA_PROGRAM_STATUS , A.START_DATE , A.END_DATE , A.INDUSTRY_ID , A.BO_ID_OWNER , A.BO_ROLE_TYPE_ID , A.BO_NAME , A.BO_NAME_AC , A.DIALOG_ID , A.RAE_EVENT_ID , A.OPRID ,%subrec(RB_AUDIT_SBR, A) FROM PS_RA_CMPGN_CMP_VW A UNION SELECT B.BUSINESS_UNIT , B.RA_CAMPAIGN_ID , B.RA_CMPGN_NAME , B.RA_PROGRAM_TYPE , B.DESCR254 , B.RA_OBJECTIVE_CD , B.RA_ROLLUP_CMPGN_ID , B.RA_ROLLUP_CM_NAME , B.RA_PROGRAM_STATUS , B.RA_PROGRAM_STATUS , B.START_DATE , B.END_DATE , B.INDUSTRY_ID , B.BO_ID_OWNER , B.BO_ROLE_TYPE_ID , B.BO_NAME , B.BO_NAME_AC , B.DIALOG_ID , B.RAE_EVENT_ID , B.OPRID ,%subrec(RB_AUDIT_SBR, B) FROM PS_RA_CMPGN_DLG_VW B UNION SELECT C.BUSINESS_UNIT , C.RA_CAMPAIGN_ID , C.RA_CMPGN_NAME , C.RA_PROGRAM_TYPE , C.DESCR254 , C.RA_OBJECTIVE_CD , C.RA_ROLLUP_CMPGN_ID , C.RA_ROLLUP_CM_NAME , C.RA_PROGRAM_STATUS , C.RA_PROGRAM_STATUS , C.START_DATE , C.END_DATE , C.INDUSTRY_ID , C.BO_ID_OWNER , C.BO_ROLE_TYPE_ID , C.BO_NAME , C.BO_NAME_AC , C.DIALOG_ID , C.RAE_EVENT_ID , C.OPRID ,%subrec(RB_AUDIT_SBR, C) FROM PS_RA_CMPGN_EVT_VW C

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RA_NONVW

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_CMPGN_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.

4 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

5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

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

7 RA_ROLLUP_CMPGN_ID Character(15) VARCHAR2(15) NOT NULL Campaign - Roll Up (Parent) Campaign Identification
Prompt Table: RA_ROLLCM_GRDVW

8 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

9 RA_CMPGN_STATUS_CD Character(4) VARCHAR2(4) NOT NULL Valid Campaign and Wave Status Codes
APPR=Approved
ARCH=Archived
CMPL=Completed
DCLN=Declined
EXEC=Executing
IREV=In Review
NEW=New
STOP=Stop
TRIG=Trigger Approved
Prompt Table: RA_UD_GRDCS_VW

10 RA_PROGRAM_STATUS Character(4) VARCHAR2(4) NOT NULL Program Status - this is used by Marketing

11 START_DATE Date(10) DATE Campaign Start Date

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

13 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.
Prompt Table: RSF_INDUSTRY_VW

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

15 BO_ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID

16 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

17 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

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

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

20 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

21 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

22 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

23 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

24 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

25 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

26 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RA_NONVW
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_CMPGN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Campaign Name - field containing the name of the campaign.
4	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
5	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
6	RA_OBJECTIVE_CD	Character(4)	VARCHAR2(4) NOT NULL	Objective code of the campaign
7	RA_ROLLUP_CMPGN_ID	Character(15)	VARCHAR2(15) NOT NULL	Campaign - Roll Up (Parent) Campaign Identification Prompt Table: RA_ROLLCM_GRDVW
8	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
9	RA_CMPGN_STATUS_CD	Character(4)	VARCHAR2(4) NOT NULL	Valid Campaign and Wave Status Codes APPR=Approved ARCH=Archived CMPL=Completed DCLN=Declined EXEC=Executing IREV=In Review NEW=New STOP=Stop TRIG=Trigger Approved Prompt Table: RA_UD_GRDCS_VW
10	RA_PROGRAM_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Program Status - this is used by Marketing
11	START_DATE	Date(10)	DATE	Campaign Start Date
12	END_DATE	Date(10)	DATE	End date field to store an end date.
13	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID. Prompt Table: RSF_INDUSTRY_VW
14	BO_ID_OWNER	Number(31,0)	DECIMAL(31) NOT NULL	Financial Account Business Object ID
15	BO_ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	BO_ROLE_TYPE_ID
16	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
17	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
18	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
19	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.
20	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
21	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
22	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
23	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
24	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
25	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
26	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time