RDT_TMPL_DFN_VW (SQL View)	Index Back
Display template definition This is a view of Definition for the display template.

RDT_TMPL_DFN_VW

(SQL View)

Display template definition

This is a view of Definition for the display template.

SELECT A.DISP_TMPL_ID , A.DESCR30 , A.COMMENTS254 FROM PS_RDT_TMPL_DEFN A , PS_RDT_TMPL_COMP B WHERE A.DISP_TMPL_ID = B.DISP_TMPL_ID AND B.PNLGRPNAME = 'RC_CASE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.

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

3 COMMENTS254 Character(254) VARCHAR2(254) NOT NULL Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DISP_TMPL_ID	Character(30)	VARCHAR2(30) NOT NULL	Template identifier to define the display template.
2	DESCR30	Character(30)	VARCHAR2(30) NOT NULL	Description
3	COMMENTS254	Character(254)	VARCHAR2(254) NOT NULL	Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)