PNLNAMEPAGE_SECTION_IDRDT_EMB_SECT_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.DISABLE_SCROLL_FLG , B.HTML_FIELD_REF_ID FROM PS_RDT_TMPL_SECTN A , PS_RDT_CFG_SECTION B 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.LAYOUT_TYPE = 'EMB' AND A.VISIBLE_FLG = 'Y' |
| # | 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 | DISABLE_SCROLL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag to decide whether to scroll or not. |
| 7 | HTML_FIELD_REF_ID | Number(31,0) | DECIMAL(31) NOT NULL | Field reference id for the fields which are part of the display template. |