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 Name Field Type Column Type Description
    TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    PT_TEMPLATE_TYPE Character(3) VARCHAR2(3) NOT NULL Template Type
    ETX=eText
    PDF=PDF
    RTF=RTF
    XLS=Excel
    XSL=XSL

    Prompt Table: PSXPTMPLTYPE

    DIST_CHANNEL Character(3) VARCHAR2(3) NOT NULL Channel
    0=Web Posting
    1=EFT
    2=Printer
    3=Email
    4=Fax
    5=SMS
    TMPLLANGCD Character(3) VARCHAR2(3) NOT NULL Language Code
    IS_SUBTEMPLATE Character(1) VARCHAR2(1) NOT NULL Subtemplate?
    N=Report Template
    Y=Sub-Template

    Y/N Table Edit

    REPORT_CATEGORY_ID Character(18) VARCHAR2(18) NOT NULL Report Category ID
    REGISTERED_BY Character(30) VARCHAR2(30) NOT NULL Registered By
    REGISTERED_DTTM DateTime(26) TIMESTAMP Registered Date/Time
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20