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

RDT_STB_ST_VW

(SQL View)

View on RDT_TMPL_STATE record.

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

SELECT A.PNLNAME , A.PAGE_SECTION_ID , A.SECTION_STATE_ID , A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET , A.SORT_ORDER_NUM , A.DEFAULT_STATE_FLG , A.VISIBLE_FLG , C.MESSAGE_SET_NBR , C.MESSAGE_NBR , D.MESSAGE_SET_NBR , D.MESSAGE_NBR FROM PS_RDT_CFG_SECTION E , PS_RDT_TMPL_STATE A , PS_RDT_LABEL_REF C , PS_RDT_LABEL_REF D WHERE E.LAYOUT_TYPE = 'STB' AND E.PNLGRPNAME = A.PNLGRPNAME AND E.MARKET = A.MARKET AND E.PNLNAME = A.PNLNAME AND E.PAGE_SECTION_ID = A.PAGE_SECTION_ID AND A.LABEL_REF_ID = C.LABEL_REF_ID AND A.GOTO_LABEL_REF_ID = D.LABEL_REF_ID AND A.VISIBLE_FLG = 'Y' AND EXISTS ( SELECT 'X' FROM PS_RDT_TMPL_FLD_ST WHERE A.DISP_TMPL_ID = PS_RDT_TMPL_FLD_ST.DISP_TMPL_ID AND A.PNLGRPNAME = PS_RDT_TMPL_FLD_ST.PNLGRPNAME AND A.MARKET = PS_RDT_TMPL_FLD_ST.MARKET AND A.PNLNAME = PS_RDT_TMPL_FLD_ST.PNLNAME AND A.PAGE_SECTION_ID = PS_RDT_TMPL_FLD_ST.PAGE_SECTION_ID AND A.SECTION_STATE_ID = PS_RDT_TMPL_FLD_ST.SECTION_STATE_ID)

# 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 SECTION_STATE_ID Character(15) VARCHAR2(15) NOT NULL Field to identify the embedded tab (applicable for group box with embedded tabs)

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

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

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

7 SORT_ORDER_NUM Number(3,0) SMALLINT NOT NULL Field to capture the sort order number.

8 DEFAULT_STATE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine if this tab is the default tab or not.

9 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Visible Flag
N=No
Y=Yes

10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

12 MESSAGE_SET_NBR02 Number(5,0) INTEGER NOT NULL Message Set Number

13 MESSAGE_NBR02 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

#	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	SECTION_STATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Field to identify the embedded tab (applicable for group box with embedded tabs)
4	DISP_TMPL_ID	Character(30)	VARCHAR2(30) NOT NULL	Template identifier to define the display template.
5	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
6	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
7	SORT_ORDER_NUM	Number(3,0)	SMALLINT NOT NULL	Field to capture the sort order number.
8	DEFAULT_STATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to determine if this tab is the default tab or not.
9	VISIBLE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Visible Flag N=No Y=Yes
10	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
11	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
12	MESSAGE_SET_NBR02	Number(5,0)	INTEGER NOT NULL	Message Set Number
13	MESSAGE_NBR02	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.