RDT_STB_OPT_VW (SQL View)	Index Back
View on RDT_TMPL_OPT record. This view is used for the structure to cache the display templates.

RDT_STB_OPT_VW

(SQL View)

View on RDT_TMPL_OPT record.

This view is used for the structure to cache the display templates.

SELECT A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET , B.RB_APPCLASS_SET , A.RB_APPCLASS_EXT , B.TB_APPCLASSREF FROM PS_RDT_TMPL_OPT A , PS_RDT_CFG_OPT B WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET

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

3 MARKET Character(3) VARCHAR2(3) NOT NULL Market

4 RB_APPCLASS_SET Character(15) VARCHAR2(15) NOT NULL Application Class Set

5 RB_APPCLASS_EXT Character(15) VARCHAR2(15) NOT NULL Application Class Set

6 TB_APPCLASSREF Character(30) VARCHAR2(30) NOT NULL As part of the display template system data, this field contains the Toolbar Application Reference.

#	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	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
3	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
4	RB_APPCLASS_SET	Character(15)	VARCHAR2(15) NOT NULL	Application Class Set
5	RB_APPCLASS_EXT	Character(15)	VARCHAR2(15) NOT NULL	Application Class Set
6	TB_APPCLASSREF	Character(30)	VARCHAR2(30) NOT NULL	As part of the display template system data, this field contains the Toolbar Application Reference.