RDT_TXN_STATEVW

(SQL View)
Index Back

View on RDT_TMPL_STATE record.

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

SELECT A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET , A.PNLNAME , A.PAGE_SECTION_ID , A.SECTION_STATE_ID , A.VISIBLE_FLG , A.SORT_ORDER_NUM , A.DEFAULT_STATE_FLG , C.MESSAGE_SET_NBR , C.MESSAGE_NBR , D.MESSAGE_SET_NBR , D.MESSAGE_NBR , B.APPCLASSREF FROM PS_RDT_TMPL_STATE A , PS_RDT_CFG_STATE B , PS_RDT_LABEL_REF C , PS_RDT_LABEL_REF D 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 A.SECTION_STATE_ID = B.SECTION_STATE_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 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.
6 SECTION_STATE_ID Character(15) VARCHAR2(15) NOT NULL Field to identify the embedded tab (applicable for group box with embedded tabs)
7 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Visible Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

8 SORT_ORDER_NUM Number(3,0) SMALLINT NOT NULL Field to capture the sort order number.
9 DEFAULT_STATE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine if this tab is the default tab or not.
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.
14 APPCLASSREF Character(30) VARCHAR2(30) NOT NULL Application Class ID Reference