RDT_TXN_SCTN_VW

(SQL View)
 Index Back

View on RDT_TMPL_SECTN 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.VISIBLE_FLG , A.DISABLE_SCROLL_FLG , B.FIELD_REF_ID , D.LABEL_REF_ID , A.LABEL_REF_ID , B.LAYOUT_TYPE , B.EXPANDED_GB_REF_ID , B.ALW_EXP_ICN_REF_ID , B.ALW_EXP_HL_REF_ID , B.ALW_LABEL_REF_ID , A.ALW_LABEL_REF_ID , B.EXP_LABEL_REF_ID , A.EXP_LABEL_REF_ID , B.HTML_FIELD_REF_ID , B.APPCLASSREF FROM PS_RDT_TMPL_SECTN A , PS_RDT_CFG_SECTION B , PS_RDT_FIELD_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 B.FIELD_REF_ID = C.FIELD_REF_ID AND C.LABEL_REF_ID = D.LABEL_REF_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 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Visible Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

7 DISABLE_SCROLL_FLG Character(1) VARCHAR2(1) NOT NULL Flag to decide whether to scroll or not.
8 FIELD_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id for the fields which are part of the display template.
9 LABEL_REF_ID Number(31,0) DECIMAL(31) NOT NULL Label reference id for the fields which are part of the display template.
10 LABEL_REF_ID2 Number(31,0) DECIMAL(31) NOT NULL Label reference id for the fields which are part of the display template.
11 LAYOUT_TYPE Character(3) VARCHAR2(3) NOT NULL Layout type to use for the various types of group boxes displayed using the display template.
EMB=Embedded Tabs
EXP=Expandable Section
FLD=Fields without Group Box
GRD=Standard Group Box with a Grid
STB=Sub Tabs
STD=Standard Group Box
12 EXPANDED_GB_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id of the group box surrounding the fields in the "Expanded" section. (applicable for expandable group box only)
13 ALW_EXP_ICN_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id for the fields which are part of the display template.
14 ALW_EXP_HL_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id of the group box surrounding the hyperlink icons and text for going from the "Always" state to the "Expanded" state. (applicable for expandable group box only)
15 ALW_LABEL_REF_ID Number(31,0) DECIMAL(31) NOT NULL Label reference id for the fields which are part of the display template.
16 ALW_LABEL_REF_ID2 Number(31,0) DECIMAL(31) NOT NULL Label reference id for the fields which are part of the display template.
17 EXP_LABEL_REF_ID Number(31,0) DECIMAL(31) NOT NULL Label reference id for the fields which are part of the display template.
18 EXP_LABEL_REF_ID2 Number(31,0) DECIMAL(31) NOT NULL Label reference id for the fields which are part of the display template.
19 HTML_FIELD_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id for the fields which are part of the display template.
20 APPCLASSREF Character(30) VARCHAR2(30) NOT NULL Application Class ID Reference