PSDOCTPLDEFN_VW (SQL View)	Index Back
MAP Templates view. Selects templates not flagged as sub-templates.

PSDOCTPLDEFN_VW

(SQL View)

MAP Templates view.

Selects templates not flagged as sub-templates.

SELECT IB_DOCTMPLNAME FROM PSDOCTPLDEFN WHERE IB_TEMPLATE_TYPE = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IB_DOCTMPLNAME Character(30) VARCHAR2(30) NOT NULL Template Name (see PSDOCTPLDEFN).