RA_PGM_STAT_VW

(SQL View)
 Index Back

marketing program status value

marketing program status values

SELECT DISTINCT A.RA_PROGRAM_TYPE , A.RA_PROGRAM_STATUS , B.DESCR50 , ' ' FROM PS_RA_PROGRAM_TBL A , PS_RA_PGM_STAT_VW2 B WHERE A.RA_PROGRAM_STATUS = B.RA_PROGRAM_STATUS

  • Related Language Record: RA_PGM_STATLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_PROGRAM_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing Program type - field that contains valid program types used in marketing, such as Campaigns, Roll ups, Dialogs and Trade Promotions
    CMP=Campaign
    DLG=Dialog
    EVT=Event
    RLU=Roll up
    2 RA_PROGRAM_STATUS Character(4) VARCHAR2(4) NOT NULL Program Status - this is used by Marketing
    3 STATUS_DESCR Character(50) VARCHAR2(50) NOT NULL Field used to show the status description. Field used as edit box.
    4 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.