RA_MC_REASG_VW

(SQL View)
 Index Back

Marketing Center Information

Used at Reassign Marketing Center Page, Markting Center field prompt view

SELECT MKT.RA_MKT_CENTER , MKT.DESCR50 , INS.INSTITUTION , INS.DESCR FROM PS_RA_UD_MKTCENTER MKT , PS_INSTITUTION_TBL INS WHERE MKT.RA_HE_CENTER_TYPE <> 'A' AND MKT.STATUS ='A' AND MKT.CS_INSTITUTION = INS.INSTITUTION UNION SELECT MKT1.RA_MKT_CENTER , MKT1.DESCR50 , ' ' , ' ' FROM PS_RA_UD_MKTCENTER MKT1 WHERE MKT1.RA_HE_CENTER_TYPE <> 'A' AND MKT1.STATUS ='A' AND MKT1.CS_INSTITUTION =' '

  • Related Language Record: RA_MC_REASG_LVW

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