RA_UD_MCADD_LVW

(SQL View)
 Index Back

Marketing Center no Users

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

SELECT A.RA_MKT_CENTER , A.LANGUAGE_CD , A.DESCR50 FROM PS_RA_UD_MKTCTR_LG 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 for RA_UD_MCADD_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50