PSXPRPTTMPL_VW

index back

BIP report-template mapping

This view maps report definition and template definition.
SELECT 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 NameField TypeColumn TypeDescription
    REPORT_DEFN_IDCharacter(12)VARCHAR2(12) NOT NULLReport Name (see PSXPRPTDEFN).
    TMPLDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLTemplate ID (see PSXPTMPLDEFN).
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    DIST_CHANNELCharacter(3)VARCHAR2(3) NOT NULLChannel
    0=Web Posting
    1=EFT
    2=Printer
    3=Email
    4=Fax
    5=SMS
    IS_DEFAULTCharacter(1)VARCHAR2(1) NOT NULLDefault Template
    N=No
    Y=Yes

    Y/N Table Edit

    Default: N

    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19