RDT_TMP_SFLD_VW

(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.PNLNAME , A.PAGE_SECTION_ID , A.SECTION_STATE_ID , A.FIELD_REF_ID , A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET , B.RSEC_FUNC_CD , B.VISIBLE_FLG , C.RECNAME , C.FIELDNAME FROM PS_RDT_TMPL_FLD_ST A , PS_RDT_TMPL_FIELD B , PS_RDT_FIELD_REF 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 A.FIELD_REF_ID=C.FIELD_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 SECTION_STATE_ID Character(15) VARCHAR2(15) NOT NULL Field to identify the embedded tab (applicable for group box with embedded tabs)
4 FIELD_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id for the fields which are part of the display template.
5 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
6 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
7 MARKET Character(3) VARCHAR2(3) NOT NULL Market
8 RSEC_FUNC_CD Character(30) VARCHAR2(30) NOT NULL Security privilege code. Used by CRM self-service to define security privileges
9 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Visible Flag
N=No
Y=Yes
10 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
11 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).