RDT_FIELDREF_VW

(SQL View)
 Index Back

View on RDT_FIELD_REF record.

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

SELECT FIELD_REF_ID , FIELDTYPE_CHAR , OCCURSLEVEL , SCROLL_NAME_1 , SCROLL_NAME_2 , SCROLL_NAME_3 , GRID_NAME , RECNAME , FIELDNAME , PNLFIELDNAME , LABEL_REF_ID , GRID_COLUMN_FLG , SECT_SEQ_NBR , FIELD_SEQ_NBR , RTLB_WIDTH FROM PS_RDT_FIELD_REF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELD_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id for the fields which are part of the display template.
2 FIELDTYPE_CHAR Character(2) VARCHAR2(2) NOT NULL Field Type
0=Static Text
1=Frame
10=Scroll Bar
11=Subpanel
12=Push Button
17=Process Button
18=Secondary Panel
2=Group Box
3=Static Image
4=Edit Box
5=Drop Down Listbox
6=Long Edit Box
7=Check Box
8=Radio Button
9=Image
3 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
4 SCROLL_NAME_1 Character(18) VARCHAR2(18) NOT NULL This field captures the scroll name. It is either a panel field name for grids (if applicable) or record name for others
5 SCROLL_NAME_2 Character(18) VARCHAR2(18) NOT NULL This field captures the scroll name. It is either a panel field name for grids (if applicable) or record name for others
6 SCROLL_NAME_3 Character(18) VARCHAR2(18) NOT NULL This field captures the scroll name. It is either a panel field name for grids (if applicable) or record name for others
7 GRID_NAME Character(15) VARCHAR2(15) NOT NULL Grid Name Field. Used in Display Templdate - System Data Component.
8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
10 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
11 LABEL_REF_ID Number(31,0) DECIMAL(31) NOT NULL Label reference id for the fields which are part of the display template.
12 GRID_COLUMN_FLG Character(1) VARCHAR2(1) NOT NULL Grid Column Flag. Used in Display Template Details Component.
13 SECT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Section Sequence Number
14 FIELD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Field Sequence Number
15 RTLB_WIDTH Number(4,0) SMALLINT NOT NULL Toolbar runtime width