PNLNAMEPAGE_SECTION_IDN=No
Y=Yes
Y/N Table Edit
Default Value: Y
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
RDT_SECTION_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.PNLNAME , A.PAGE_SECTION_ID , A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET , 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 | 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 |
| 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 |