RA_PGM_TYPE_LNG

(SQL View)
 Index Back

Program Types

Filter Program types by product installation

SELECT X.FIELDVALUE ,X.LANGUAGE_CD , X.XLATLONGNAME , X.XLATSHORTNAME FROM PSXLATITEMLANG 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')))

  • Related Language Record for RA_PGM_TYPE_VW

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