RA_ACT_SUMM_LNG

(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 , DSC.LANGUAGE_CD , DSC.RA_ACTIVITY_DESCR , DSC.RA_ACTIVITY_CTA FROM PS_RA_CMPGN_WAVE ACT , PS_RA_CAMPAIGN CM , PS_RA_CM_ACT_DLANG 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 for RA_ACT_SUMM_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 RA_ACTIVITY_DESCR Character(254) VARCHAR2(254) NOT NULL Marketing Activity Summary Description
    6 RA_ACTIVITY_CTA Long Character CLOB Call to Action on Activity Summary page