RDT_DFT_NOBU_VW (SQL View)	Index Back
Default Template ID for Family This view returns the Default Template ID for a Family and Component Combination with No Business Unit Validation. This is used in Agent My Cases Pagelet to get default Template for given Family

RDT_DFT_NOBU_VW

(SQL View)

Default Template ID for Family

This view returns the Default Template ID for a Family and Component Combination with No Business Unit Validation. This is used in Agent My Cases Pagelet to get default Template for given Family

SELECT A.DISP_TMPL_FAM_CD , B.PNLGRPNAME , A.DISP_TMPL_ID , B.DEFAULT_FLAG FROM PS_RDT_TMPL_DEFN A , PS_RDT_TMPL_COMP B WHERE A.DISP_TMPL_ID = B.DISP_TMPL_ID

# 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 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

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

4 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL This field is a flag field to indicate default or not.
N=No
Y=Yes

#	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	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
3	DISP_TMPL_ID	Character(30)	VARCHAR2(30) NOT NULL	Template identifier to define the display template.
4	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field is a flag field to indicate default or not. N=No Y=Yes