PSXPTMPLDEFN (SQL Table)	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.

PSXPTMPLDEFN

(SQL Table)

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 PeopleSoft Field Type Database Column Type Description

1 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 PT_TEMPLATE_TYPE Character(3) VARCHAR2(3) NOT NULL Template Type
ETX=eText
PDF=PDF
RTF=RTF
XLS=Excel
XSL=XSL
Prompt Table: PSXPTMPLTYPE

4 DIST_CHANNEL Character(3) VARCHAR2(3) NOT NULL Channel
0=Web Posting
1=EFT
2=Printer
3=Email
4=Fax
5=SMS

5 TMPLLANGCD Character(3) VARCHAR2(3) NOT NULL Language Code

6 IS_SUBTEMPLATE Character(1) VARCHAR2(1) NOT NULL Subtemplate?
N=Report Template
Y=Sub-Template
Y/N Table Edit

7 REPORT_CATEGORY_ID Character(18) VARCHAR2(18) NOT NULL Report Category ID

8 REGISTERED_BY Character(30) VARCHAR2(30) NOT NULL Registered By

9 REGISTERED_DTTM DateTime(26) TIMESTAMP Registered Date/Time

10 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

11 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

12 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.

13 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	PT_TEMPLATE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Template Type ETX=eText PDF=PDF RTF=RTF XLS=Excel XSL=XSL Prompt Table: PSXPTMPLTYPE
4	DIST_CHANNEL	Character(3)	VARCHAR2(3) NOT NULL	Channel 0=Web Posting 1=EFT 2=Printer 3=Email 4=Fax 5=SMS
5	TMPLLANGCD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	IS_SUBTEMPLATE	Character(1)	VARCHAR2(1) NOT NULL	Subtemplate? N=Report Template Y=Sub-Template Y/N Table Edit
7	REPORT_CATEGORY_ID	Character(18)	VARCHAR2(18) NOT NULL	Report Category ID
8	REGISTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Registered By
9	REGISTERED_DTTM	DateTime(26)	TIMESTAMP	Registered Date/Time
10	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
11	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
12	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.
13	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.