PSXPTMPLDEFN

Return to Index

This table stores template (including sub-template) definition for BI Publisher. Template definition has eff-dated template files as a child object.

  • Related language record: PSXPTMPLDEFNLNG
  • Parent record of PSXPTMPLFILEDEF
  • PeopleSoft Field NameField TypeDescription
    TMPLDEFN_IDVARCHAR2(30) NOT NULLTemplate ID
    DESCRVARCHAR2(30) NOT NULLDescription
    PT_TEMPLATE_TYPEVARCHAR2(3) NOT NULLTemplate Type
    ETX=eText
    PDF=PDF
    RTF=RTF
    XSL=XSL

    Prompt Table: PSXPTMPLTYPE

    DIST_CHANNELVARCHAR2(3) NOT NULLChannel
    0=Web Posting
    1=EFT
    2=Printer
    3=Email
    4=Fax
    5=SMS
    TMPLLANGCDVARCHAR2(3) NOT NULLLanguage Code
    IS_SUBTEMPLATEVARCHAR2(1) NOT NULLSubtemplate?
    N=Report Template
    Y=Sub-Template

    Y/N Table Edit

    REPORT_CATEGORY_IDVARCHAR2(18) NOT NULLReport Category ID
    REGISTERED_BYVARCHAR2(30) NOT NULLRegistered By
    REGISTERED_DTTMDATERegistered Date/Time
    OBJECTOWNERIDVARCHAR2(4) NOT NULLObject owner identifier translate values
    VERSIONDECIMAL(10) NOT NULLVersion
    LASTUPDDTTMDATESpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRIDVARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Author: PeopleTools 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015