RA_CAMPAIGN_VW (SQL View)	Index Back
Marketing Campaign Record View Marketing Campaign record view - campaigns with status code not equal to archived

RA_CAMPAIGN_VW

(SQL View)

Marketing Campaign Record View

Marketing Campaign record view - campaigns with status code not equal to archived

SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_CMPGN_NAME , B.RA_PROGRAM_TYPE , A.DESCR254 , A.RA_OBJECTIVE_CD , A.RA_ROLLUP_CMPGN_ID , A.RA_CMPGN_STATUS_CD , A.START_DATE , A.END_DATE FROM PS_RA_CAMPAIGN A , PS_RA_PROGRAM_TBL B WHERE A.RA_CMPGN_STATUS_CD <> 'ARCH' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID

Related Language Record: RA_CAMPAIGN_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_RB.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.
Default Value: NEXT

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

8 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_CPGN_STAT

9 START_DATE Date(10) DATE Campaign Start Date

10 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 Default Value: OPR_DEF_TBL_RB.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. Default Value: NEXT
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
8	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_CPGN_STAT
9	START_DATE	Date(10)	DATE	Campaign Start Date
10	END_DATE	Date(10)	DATE	End date field to store an end date.