RA_PGM_TYPE_VW

(SQL View)
 Index Back

Program Types

Filter Program types by product installation. Currently only used by configurable search, set as prompt on search field Program Type

SELECT X.FIELDVALUE , X.XLATLONGNAME , X.XLATSHORTNAME FROM PSXLATITEM X , PS_INSTALLATION I WHERE X.FIELDNAME = 'RA_PROGRAM_TYPE' AND X.EFFDT = ( SELECT MAX(X_EF.EFFDT) FROM PSXLATITEM X_EF WHERE X_EF.FIELDNAME = X.FIELDNAME AND X_EF.FIELDVALUE = X.FIELDVALUE AND X_EF.EFFDT <= %CurrentDateIn AND X_EF.EFF_STATUS = 'A') AND ((I.RA = 'Y' AND I.OMK='Y') OR (I.OMK = 'N' AND X.FIELDVALUE IN ('CMP', 'RLU', 'EVT')))

  • Related Language Record: RA_PGM_TYPE_LNG

    • # 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name