PSXPRPTTMPL_VW

Return to Index

This view maps report definition and template definition.

PlatformView Text
DefaultSELECT A.REPORT_DEFN_ID , A.TMPLDEFN_ID , B.DESCR , B.TMPLLANGCD , B.DIST_CHANNEL , A.IS_DEFAULT , B.VERSION FROM PSXPRPTTMPL A , PSXPTMPLDEFN B WHERE A.TMPLDEFN_ID = B.TMPLDEFN_ID

  • Parent record: PSXPRPTDEFN_WRK

    • PeopleSoft Field NameDescription
    REPORT_DEFN_IDReport Name
    TMPLDEFN_IDTemplate ID
    DESCRDescription
    LANGUAGE_CDLanguage Code translate values
    DIST_CHANNELChannel
    0=Web Posting
    1=EFT
    2=Printer
    3=Email
    4=Fax
    5=SMS
    IS_DEFAULTDefault Template
    N=No (default)
    Y=Yes

    Y/N Table Edit

    VERSIONInternal PeopleTools version to control reloading of objects in cache.

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010