RDT_TXN_FLDSTVW

(SQL View)
 Index Back

View on RDT_TMPL_FLD_ST 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.FIELD_REF_ID , B.RSEC_FUNC_CD FROM PS_RDT_TMPL_FLD_ST A , PS_RDT_TMPL_FIELD B , PS_RDT_CFG_FIELD C WHERE A.DISP_TMPL_ID = B.DISP_TMPL_ID AND 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.FIELD_REF_ID = B.FIELD_REF_ID AND C.PNLGRPNAME = B.PNLGRPNAME AND C.MARKET = B.MARKET AND C.PNLNAME = B.PNLNAME AND C.PAGE_SECTION_ID = B.PAGE_SECTION_ID AND C.FIELD_REF_ID = B.FIELD_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 SECTION_STATE_ID Character(15) VARCHAR2(15) NOT NULL Field to identify the embedded tab (applicable for group box with embedded tabs)
7 FIELD_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id for the fields which are part of the display template.
8 RSEC_FUNC_CD Character(30) VARCHAR2(30) NOT NULL Security privilege code. Used by CRM self-service to define security privileges