RA_MKTCTR_VW

(SQL View)
 Index Back

prompt table Marketing Center

View used as a prompt table for Marketing Center 3/17/2009 - Eliminate Inactive MC from view

SELECT DISTINCT D.OPRID , A.RA_MKT_CENTER , A.DESCR50 , B.INSTITUTION , B.DESCR , C.XLATSHORTNAME FROM PS_RA_UD_MKTCENTER A LEFT OUTER JOIN PS_RA_INSTEFDT_VW B ON A.CS_INSTITUTION=B.INSTITUTION LEFT OUTER JOIN PS_RA_CTRMAXEFF_VW C ON A.RA_HE_CENTER_TYPE=C.FIELDVALUE AND C.FIELDNAME='RA_HE_CENTER_TYPE' , PS_RA_MC_OPRANC_VW D WHERE A.RA_MKT_CENTER=D.RA_MKT_CENTER AND A.STATUS = 'A'

  • Related Language Record: RA_MKTCTR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RA_MKT_CENTER Character(10) VARCHAR2(10) NOT NULL Marketing Center code
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    4 CS_INSTITUTION Character(5) VARCHAR2(5) NOT NULL CS_INSTITUTION is used in OLM Profile student admin Dialog for OLM/SA Integration.

    Prompt Table: INSTITUTION_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR1 Character(30) VARCHAR2(30) NOT NULL Center Type