RA_PROGRAMS_VW3

(SQL View)
Index Back

Marketing Programs - EVENTS

summary of all marketing EVENT programs, used in the calendar component

SELECT A.BUSINESS_UNIT , B.RAE_EVENT_ID , A.RA_PROGRAM_TYPE , A.RA_ROLLUP_CMPGN_ID , B.RAE_EVENT_NAME , B.RAE_EVENTSTATUS_CD , B.RA_OBJECTIVE_CD , B.BO_ID_OWNER , B.START_DATE , B.END_DATE , 0 , 0 , %TrimSubstr(A.RA_ROLLUP_CMPGN_ID,1,15) %Concat A.RA_CAMPAIGN_ID FROM PS_RA_PROGRAM_TBL A , PS_RAE_EVENT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RAE_EVENT_ID

# 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_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
4 RA_ROLLUP_CMPGN_ID Character(15) VARCHAR2(15) NOT NULL Campaign - Roll Up (Parent) Campaign Identification
5 RA_CMPGN_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.
6 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
7 RA_OBJECTIVE_CD Character(4) VARCHAR2(4) NOT NULL Objective code of the campaign
8 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
9 START_DATE Date(10) DATE Start Date for Gen Standing PO
10 END_DATE Date(10) DATE End date field to store an end date.
11 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
12 ROW_NUM Number(3,0) SMALLINT NOT NULL This field is used to specify the row number.
13 SORTFIELD Character(40) VARCHAR2(40) NOT NULL Sort Field