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 |