RDT_FLD_ST_VW (SQL View)	Index Back
View on RDT_TMPL_FLD_ST record This view is used for the structure to cache the display templates.

RDT_FLD_ST_VW

(SQL View)

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 FROM PS_RDT_TMPL_FLD_ST A , PS_RDT_TMPL_FIELD B 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

# 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

#	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