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

RDT_TMPL_FLD_VW

(SQL View)

View on RDT_TMPL_FIELD record.

This view is used for the structure to cache the display templates.

SELECT A.PNLNAME , A.PAGE_SECTION_ID , A.FIELD_REF_ID , A.RSEC_FUNC_CD , A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET , A.VISIBLE_FLG , A.ALWAYS_EXP_FLG , D.LABEL_REF_ID , A.LABEL_REF_ID , B.ALWAYS_FLD_REF_ID , B.EXPANDD_FLD_REF_ID , C.RECNAME , C.FIELDNAME , A.SECURE_FLG , B.ADAPTER_FLD_FLG , B.ADAPTER_GB_REF_ID FROM PS_RDT_TMPL_FIELD A , PS_RDT_CFG_FIELD B , PS_RDT_FIELD_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.FIELD_REF_ID = B.FIELD_REF_ID AND B.FIELD_REF_ID = C.FIELD_REF_ID AND C.LABEL_REF_ID = D.LABEL_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 FIELD_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id for the fields which are part of the display template.

4 RSEC_FUNC_CD Character(30) VARCHAR2(30) NOT NULL Security privilege code. Used by CRM self-service to define security privileges
Prompt Table: RSEC_FUNC_DEFN

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 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Visible Flag
N=No
Y=Yes
Default Value: Y

9 ALWAYS_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine whether the configurable field is part of the "Always" section or the "Expanded" section of the expandable group box.
A=Always
E=Expanded

10 LABEL_REF_ID Number(31,0) DECIMAL(31) NOT NULL Label reference id for the fields which are part of the display template.

11 LABEL_REF_ID2 Number(31,0) DECIMAL(31) NOT NULL Label reference id for the fields which are part of the display template.

12 ALWAYS_FLD_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id when the field is part of "Always" section of the expandable group box. (applicable for expandable group box only)

13 EXPANDD_FLD_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id when the field is part of "Expanded" section of the expandable group box. (applicable for expandable group box only)

14 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

15 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

16 SECURE_FLG Character(1) VARCHAR2(1) NOT NULL Security Flag that denotes whether a Field is secured by function privileges defined in the Application Security Framework
N=No
Y=Yes

17 ADAPTER_FLD_FLG Character(1) VARCHAR2(1) NOT NULL Adapter Flag Field. This field is used in Display Template to Flag the BO Adapter Fields.

18 ADAPTER_GB_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id for the fields which are part of the display template.

#	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	FIELD_REF_ID	Number(31,0)	DECIMAL(31) NOT NULL	Field reference id for the fields which are part of the display template.
4	RSEC_FUNC_CD	Character(30)	VARCHAR2(30) NOT NULL	Security privilege code. Used by CRM self-service to define security privileges Prompt Table: RSEC_FUNC_DEFN
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	VISIBLE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Visible Flag N=No Y=Yes Default Value: Y
9	ALWAYS_EXP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to determine whether the configurable field is part of the "Always" section or the "Expanded" section of the expandable group box. A=Always E=Expanded
10	LABEL_REF_ID	Number(31,0)	DECIMAL(31) NOT NULL	Label reference id for the fields which are part of the display template.
11	LABEL_REF_ID2	Number(31,0)	DECIMAL(31) NOT NULL	Label reference id for the fields which are part of the display template.
12	ALWAYS_FLD_REF_ID	Number(31,0)	DECIMAL(31) NOT NULL	Field reference id when the field is part of "Always" section of the expandable group box. (applicable for expandable group box only)
13	EXPANDD_FLD_REF_ID	Number(31,0)	DECIMAL(31) NOT NULL	Field reference id when the field is part of "Expanded" section of the expandable group box. (applicable for expandable group box only)
14	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
15	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
16	SECURE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Security Flag that denotes whether a Field is secured by function privileges defined in the Application Security Framework N=No Y=Yes
17	ADAPTER_FLD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Adapter Flag Field. This field is used in Display Template to Flag the BO Adapter Fields.
18	ADAPTER_GB_REF_ID	Number(31,0)	DECIMAL(31) NOT NULL	Field reference id for the fields which are part of the display template.