RA_WAVE_STAT_VW

(SQL View)
 Index Back

Campaign Wave Status View

This view joins campaign, wave and campaign status tables

SELECT b.setid , a.business_unit , a.ra_campaign_id , a.ra_cmpgn_wave_id , c.ra_cmpgn_status_cd , d.descr FROM ps_ra_cmpgn_wave a , ps_set_cntrl_rec b , PS_RA_CAMPAIGN c , ps_ra_ud_cpgn_stat d WHERE b.setcntrlvalue = %TrimSubstr(a.business_unit, 1, 5) AND b.recname = 'RA_UD_CPGN_STAT' AND c.business_unit = a.business_unit AND c.ra_campaign_id = a.ra_campaign_id AND d.setid = b.setid AND d.ra_cmpgn_status_cd = c.ra_cmpgn_status_cd

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 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.
4 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
5 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
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description