PSXPTMPLDEFN

index back

BIP Template Definition

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 TypeColumn TypeDescription
    TMPLDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLTemplate ID
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    PT_TEMPLATE_TYPECharacter(3)VARCHAR2(3) NOT NULLTemplate Type
    ETX=eText
    PDF=PDF
    RTF=RTF
    XSL=XSL

    Prompt Table: PSXPTMPLTYPE

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

    Y/N Table Edit

    REPORT_CATEGORY_IDCharacter(18)VARCHAR2(18) NOT NULLReport Category ID
    REGISTERED_BYCharacter(30)VARCHAR2(30) NOT NULLRegistered By
    REGISTERED_DTTMDateTime(26)TIMESTAMPRegistered Date/Time
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(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.
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19