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

RDT_STB_SECT_VW

(SQL View)

View on RDT_TMPL_SECTN record.

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

SELECT A.PNLNAME , A.PAGE_SECTION_ID , A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET FROM PS_RDT_TMPL_SECTN A , PS_RDT_CFG_SECTION B WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND A.PNLNAME = B.PNLNAME AND A.PAGE_SECTION_ID = B.PAGE_SECTION_ID AND B.LAYOUT_TYPE = 'STB'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

2 PAGE_SECTION_ID Character(15) VARCHAR2(15) NOT NULL Section Identifier defined for the section (various types of group boxes or grouping of fields) in the configurable component.

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
2	PAGE_SECTION_ID	Character(15)	VARCHAR2(15) NOT NULL	Section Identifier defined for the section (various types of group boxes or grouping of fields) in the configurable component.
3	DISP_TMPL_ID	Character(30)	VARCHAR2(30) NOT NULL	Template identifier to define the display template.
4	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
5	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market