RA_ACT_SUMM_VW

(SQL View)
 Index Back

Activity summary View

Used by Marketing Activity Summary page.

SELECT ACT.BUSINESS_UNIT , ACT.RA_CAMPAIGN_ID , ACT.RA_CMPGN_WAVE_ID , ACT.RA_CMPGN_STATUS_CD , CM.RA_CMPGN_NAME , CM.START_DATE , CM.END_DATE , CM.BO_ID_OWNER , ACT.RA_WAVE_NAME , ACT.START_DATE , ACT.END_DATE , ACT.RA_LEAD_ACCEPT_DT , DSC.RA_ACTIVITY_DESCR , DSC.RA_ACTIVITY_CTA , ACT.RA_LIST_ID , ACT.RA_OFFER_ID FROM PS_RA_CMPGN_WAVE ACT , PS_RA_CAMPAIGN CM , PS_RA_CM_ACT_DESCR DSC WHERE ACT.BUSINESS_UNIT = CM.BUSINESS_UNIT AND ACT.RA_CAMPAIGN_ID = CM.RA_CAMPAIGN_ID AND ACT.BUSINESS_UNIT = DSC.BUSINESS_UNIT AND ACT.RA_CAMPAIGN_ID = DSC.RA_CAMPAIGN_ID AND ACT.RA_CMPGN_WAVE_ID = DSC.RA_CMPGN_WAVE_ID

  • Related Language Record: RA_ACT_SUMM_LNG

    • # 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_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
    5 RA_CMPGN_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.
    6 START_DATE Date(10) DATE Start Date for Gen Standing PO
    7 END_DATE Date(10) DATE End date field to store an end date.
    8 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
    9 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.
    10 START_DT Date(10) DATE Start date field to store start date value.
    11 END_DT Date(10) DATE This field stores the end date values.
    12 RA_LEAD_ACCEPT_DT Date(10) DATE Date used for final date in which leads can be attached to a marketing activity
    13 RA_ACTIVITY_DESCR Character(254) VARCHAR2(254) NOT NULL Marketing Activity Summary Description
    14 RA_ACTIVITY_CTA Long Character CLOB Call to Action on Activity Summary page
    15 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID
    16 RA_OFFER_ID Character(15) VARCHAR2(15) NOT NULL Marketing Offer ID