RA_WAVEPROMO_VW (SQL View)	Index Back
Campaign Wave - Promotion code View to link unique Promotion code to Campaign Wave

RA_WAVEPROMO_VW

(SQL View)

Campaign Wave - Promotion code

View to link unique Promotion code to Campaign Wave

SELECT W.SETID ,W.RA_PROMOTION_CODE ,W.BUSINESS_UNIT ,W.SYNCID ,W.SYNCDTTM ,W.BUSINESS_UNIT ,W.RA_CAMPAIGN_ID ,W.RA_CMPGN_NAME ,W.RA_CMPGN_WAVE_ID ,W.RA_WAVE_NAME ,W.START_DATE ,W.END_DATE ,W.RA_CMPGN_STATUS_CD FROM PS_RA_PROMO_OFFER W

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RA_PROMOTION_CODE Character(35) VARCHAR2(35) NOT NULL Marketing - campaign wave promotion code

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT
Prompt Table: SP_BU_RA_NONVW

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

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

6 BUSINESS_UNIT_RA Character(5) VARCHAR2(5) NOT NULL Business Unit

7 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.
Prompt Table: RA_CAMPAIGN

8 RA_CMPGN_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.

9 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
Default Value: NEXT

10 RA_WAVE_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.

11 START_DATE Date(10) DATE Campaign Start Date

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

13 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	RA_PROMOTION_CODE	Character(35)	VARCHAR2(35) NOT NULL	Marketing - campaign wave promotion code
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT Prompt Table: SP_BU_RA_NONVW
4	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.
5	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
6	BUSINESS_UNIT_RA	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	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. Prompt Table: RA_CAMPAIGN
8	RA_CMPGN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Campaign Name - field containing the name of the campaign.
9	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID Default Value: NEXT
10	RA_WAVE_NAME	Character(50)	VARCHAR2(50) NOT NULL	Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.
11	START_DATE	Date(10)	DATE	Campaign Start Date
12	END_DATE	Date(10)	DATE	End date field to store an end date.
13	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