RDT_CFG_FLD_VW

(SQL View)
 Index Back

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.PNLGRPNAME , A.MARKET , A.ALWAYS_FLD_REF_ID , A.EXPANDD_FLD_REF_ID , A.ADAPTER_FLD_FLG , A.ADAPTER_GB_REF_ID FROM PS_RDT_CFG_FIELD A

# 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 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
5 MARKET Character(3) VARCHAR2(3) NOT NULL Market
6 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)
7 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)
8 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.
9 ADAPTER_GB_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id for the fields which are part of the display template.