RDT_TMPL_FAM4VW (SQL View)	Index Back
Display Template Family View This view returns all display template families for which the customer is licensed.

RDT_TMPL_FAM4VW

(SQL View)

Display Template Family View

This view returns all display template families for which the customer is licensed.

SELECT DISTINCT A.DISP_TMPL_FAM_CD , A.DESCR , C.PNLGRPNAME , A.COMMENTS254 FROM PS_RDT_TMPL_FAMILY A , PS_RDT_TMPL_DEFN B , PS_RDT_TMPL_COMP C WHERE B.DISP_TMPL_FAM_CD = A.DISP_TMPL_FAM_CD AND C.DISP_TMPL_ID = B.DISP_TMPL_ID AND C.MARKET = 'GBL'

Related Language Record: RDT_TMPL_FAM_L

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

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

3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

4 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_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
4	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)