RA_CONT_MGT_VW

(SQL View)
 Index Back

Content Mgmt Report View

View created to support Content Management Report Query

SELECT A.RA_PAR_CONTENT_ID , A.RA_CONTENT_ID , B.DESCR DESCR1 , A.DESCR , A.RA_CONTENT_STATUS , A.RA_AVAIL_QTY , D.XLATSHORTNAME FROM PS_RA_CONTENT A , PS_RA_CONTENT B , PSXLATITEM D WHERE A.SETID = B.SETID (+) AND A.RA_PAR_CONTENT_ID = B.RA_CONTENT_ID (+) AND D.FIELDNAME = 'RA_CONTENT_STATUS' AND D.FIELDVALUE = A.RA_CONTENT_STATUS AND D.EFFDT = ( SELECT MAX(E.EFFDT) FROM PSXLATITEM E WHERE E.FIELDNAME = D.FIELDNAME AND E.FIELDVALUE = D.FIELDVALUE AND E.EFFDT <= %CurrentDateIn) AND D.EFF_STATUS = 'A'

  • Related Language Record: RA_CONT_MGT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_PAR_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing Content Parent ID
    2 RA_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Content ID
    3 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 RA_CONTENT_STATUS Character(4) VARCHAR2(4) NOT NULL Marketing - Content Status
    CMPL=Completed
    EXPR=Expired
    IREV=In Review
    NEW=New
    PLAN=Planning
    RWRK=Re-Work
    6 RA_AVAIL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Requested Quantity to have available
    7 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name