RA_ACTEXELST_VW

(SQL View)
 Index Back

Campaign Activity Executing

Campaign Activity records in executing status with lists (audience) associated with them.

SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.RA_WAVE_NAME , A.RA_CMPGN_STATUS_CD , A.RA_ACTIVITY_CD , A.RA_CHANNEL_TYPE , A.RA_CHANNEL , B.RA_LIST_ID , B.RA_LIST_NAME , B.RA_LIST_STATUS , B.RA_LIST_SOURCE , B.RA_INT_EXT_IND , B.RA_STAT_DYN_IND FROM PS_RA_CMPGN_WAVE A , PS_RA_LIST B , PS_SET_CNTRL_REC C , PS_RA_UD_CHNL_TYPE CE WHERE A.RA_CMPGN_STATUS_CD = 'EXEC' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RA_LIST' AND C.SETID = B.SETID AND B.RA_LIST_ID = A.RA_LIST_ID AND C.SETID = CE.SETID AND A.RA_ACTIVITY_CD = CE.RA_ACTIVITY_CD AND A.RA_CHANNEL_TYPE = CE.RA_CHANNEL_TYPE AND (CE.RA_CHNL_EXECUTION = '010' OR CE.RA_CHNL_EXECUTION = '060')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
4 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.
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 RA_ACTIVITY_CD Character(4) VARCHAR2(4) NOT NULL Campaign - Activity Code. Code is used for initial selection of channels.
7 RA_CHANNEL_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing Channel Types
8 RA_CHANNEL Character(4) VARCHAR2(4) NOT NULL Marketing Channels
9 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID
10 RA_LIST_NAME Character(30) VARCHAR2(30) NOT NULL Audience / List Name
11 RA_LIST_STATUS Character(4) VARCHAR2(4) NOT NULL Audience / List Status
010=In Design
020=Designed
030=Scheduled
040=Processing
050=Generated
060=Approved
070=Committed
080=Archived
12 RA_LIST_SOURCE Character(4) VARCHAR2(4) NOT NULL Audience / List Source
CGRP=Control Group
COMP=Combine Audiences
CRIT=Audience Builder
EXT=External Audience
IMP=Import
QRY=PS Query
SEG=Segment
SRCH=Saved Search
TEST=Test Audience

Prompt Table: RA_LIST_SRC_VW

13 RA_INT_EXT_IND Character(1) VARCHAR2(1) NOT NULL Internal/External Audience indicator
E=External Audience
I=Internal Audience
14 RA_STAT_DYN_IND Character(1) VARCHAR2(1) NOT NULL Fixed/Dynamic Audience indicator
D=Dynamic Audience
S=Fixed Audience