RA_CTMG_RPT_LVW

(SQL View)
 Index Back

Content Mgmt Report View

View created to support Content Management Report Query

SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , D.LANGUAGE_CD , B.RA_CMPGN_WAVE_ID , C.RA_PAR_CONTENT_ID , C1.DESCR , B.RA_CONTENT_ID , C.DESCR , D.XLATSHORTNAME FROM PS_RA_CAMPAIGN A , PS_RA_CMPGN_WAVE B , PS_RA_CONTENT C , PS_RA_CONTENT C1 , PSXLATITEMLANG D , PSXLATITEM E WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND D.FIELDNAME = E.FIELDNAME AND D.FIELDVALUE = E.FIELDVALUE AND D.EFFDT = E.EFFDT AND B.RA_CONTENT_ID <> ' ' AND C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = B.BUSINESS_UNIT AND RECNAME = 'RA_CONTENT') AND C.RA_CONTENT_ID = B.RA_CONTENT_ID AND C.SETID = C1.SETID (+) AND C.RA_PAR_CONTENT_ID = C1.RA_CONTENT_ID (+) AND E.FIELDNAME = 'RA_CONTENT_STATUS' AND E.FIELDVALUE = C.RA_CONTENT_STATUS AND E.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM WHERE FIELDNAME = E.FIELDNAME AND FIELDVALUE = E.FIELDVALUE AND EFFDT <= %CurrentDateIn) AND E.EFF_STATUS = 'A'

  • Related Language Record for RA_CNTMG_RPT_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
    5 RA_PAR_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing Content Parent ID
    6 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    7 RA_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Content ID
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name