RA_LIST_AD_WV_L

(SQL View)
 Index Back

Associate Wave to List Related

Valid list of audiences based upon set identification, related language

SELECT B.SETID , A.RA_PROMOTION_CODE , E.LANGUAGE_CD , E.DESCR FROM PS_RA_CMPGN_WAVE A , PS_SET_CNTRL_REC B , PS_RA_CAMPAIGN C , PS_SET_CNTRL_REC D , PS_RA_UD_CSTAT_LNG E WHERE B.SETCNTRLVALUE = %TrimSubstr(A.BUSINESS_UNIT, 1, 5) AND B.RECNAME = 'RA_LIST' AND A.RA_LIST_ID = ' ' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.RA_CAMPAIGN_ID = A.RA_CAMPAIGN_ID AND A.RA_CMPGN_STATUS_CD IN ('NEW', 'IREV') AND D.SETCNTRLVALUE = %TrimSubstr(A.BUSINESS_UNIT, 1, 5) AND D.RECNAME = 'RA_UD_CPGN_STAT' AND E.SETID = D.SETID AND E.RA_CMPGN_STATUS_CD = A.RA_CMPGN_STATUS_CD

  • Related Language Record for RA_LIST_ADD_WV2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 RA_PROMOTION_CODE Character(35) VARCHAR2(35) NOT NULL Marketing - campaign wave promotion code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 RA_CMPGN_STAT_DESC Character(30) VARCHAR2(30) NOT NULL Campaign and Wave Status Description