RA_UD_MCADD_VW

(SQL View)
 Index Back

Marketing Center no Users

View of Marketing centers with no User IDs assigned to them.

SELECT A.RA_MKT_CENTER , A.DESCR50 FROM PS_RA_UD_MKTCENTER A WHERE NOT EXISTS ( SELECT B.RA_MKT_CENTER FROM PS_RA_UD_MC_OPR B WHERE A.RA_MKT_CENTER =B.RA_MKT_CENTER)

  • Related Language Record: RA_UD_MCADD_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_MKT_CENTER Character(10) VARCHAR2(10) NOT NULL Marketing Center code

    Prompt Table: RA_UD_MKTCENTER

    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50