RA_CAMPAIGN_LVW

(SQL View)
 Index Back

Marketing Campaign Record View

Marketing Campaign Language record view - campaigns with status code not equal to archived

SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , C.LANGUAGE_CD , A.DESCR254 FROM PS_RA_CAMPAIGN A , PS_RA_PROGRAM_TBL B , PS_RA_CAMPAIGN_LNG C WHERE A.RA_CMPGN_STATUS_CD <> 'ARCH' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND A.RA_CAMPAIGN_ID = C.RA_CAMPAIGN_ID

  • Related Language Record for RA_CAMPAIGN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

    Prompt Table: SP_BU_RA_NONVW

    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.

    Default Value: NEXT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254