RDT_STB_VW (SQL View)	Index Back
Configurable fields Sections for subtabs (defined as fields)

RDT_STB_VW

(SQL View)

Configurable fields

Sections for subtabs (defined as fields)

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

# 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 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

5 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.

#	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	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
5	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.