RA_CMPGN_CMP_VW

(SQL View)
 Index Back

Campaign and Rollup Security

Security view for secured and unsecured campaigns and rollups.

SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , %Substring(A.RA_PROGRAM_NAME,1,50) , 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.ROLE_TYPE_ID , A.NAME , B.BO_NAME_AC , A.DIALOG_ID , A.RAE_EVENT_ID , C.OPRID ,%subrec(RB_AUDIT_SBR, A) FROM PS_RA_PROGRAM_TBL A LEFT OUTER JOIN PS_BO_NAME_PRIM_VW B ON (A.BO_ID_OWNER = B.BO_ID) LEFT OUTER JOIN PS_RA_CMP_SCRTY_VW C ON (A.BUSINESS_UNIT=C.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = C.RA_CAMPAIGN_ID) WHERE A.RA_PROGRAM_STATUS <> 'ARCH' AND A.RA_PROGRAM_TYPE IN ('CMP','RLU')

# 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