PNLGRPNAMEMARKETPNLNAMEPAGE_SECTION_IDFIELD_REF_IDRDT_CFG_STB_VW(SQL View) |
Index Back |
|---|---|
Configurable fieldsSections for subtabs (defined as fields) |
| SELECT A.PNLGRPNAME , A.MARKET , A.PNLNAME , A.PAGE_SECTION_ID , A.FIELD_REF_ID , A.SORT_ORDER_NUM FROM PS_RDT_CFG_FIELD A , PS_RDT_CFG_SECTION B WHERE B.LAYOUT_TYPE = 'STB' AND B.PNLGRPNAME = A.PNLGRPNAME AND B.MARKET = A.MARKET AND B.PNLNAME = A.PNLNAME AND B.PAGE_SECTION_ID = A.PAGE_SECTION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 4 | 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. |
| 5 | FIELD_REF_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Field reference id for the fields which are part of the display template. |
| 6 | SORT_ORDER_NUM | Number(3,0) | SMALLINT NOT NULL | Field to capture the sort order number. |