XPTMPLDEFN_VW (SQL View)	Index Back
BIP Template Defn vw (trans) This table stores template (including sub-template) definition for BI Publisher. Template definition has eff-dated template files as a child object.

XPTMPLDEFN_VW

(SQL View)

BIP Template Defn vw (trans)

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

SELECT TMPLDEFN_ID , DESCR , VERSION FROM PSXPTMPLDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN).
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference