RV_PNLFLD_VW1

(SQL View)
 Index Back

PANEL FIELD LABEL

SELECT PNLNAME ,PNLFLDID ,FIELDNUM ,RECNAME ,FIELDNAME ,PNLFIELDNAME ,LABEL_ID ,LBLTEXT ,FIELDTYPE ,OCCURSLEVEL FROM PSPNLFIELD WHERE RECNAME <> ' '

SELECT a.PNLNAME ,a.RECNAME ,a.FIELDNAME ,a.PNLFLDID ,a.FIELDNUM ,a.PNLFIELDNAME ,a.LABEL_ID ,a.LBLTEXT ,a.FIELDTYPE ,a.OCCURSLEVEL ,a.GRDCOLUMNCOUNT ,a.GRDLBLMSGSET ,a.GRDLBLMSGNUM , a.SUBPNLNAME FROM PSPNLFIELD a WHERE (a.FIELDTYPE <> 1 AND a.FIELDTYPE <>3 AND a.FIELDTYPE <>8 AND a.FIELDTYPE <>18 AND a.FIELDTYPE <>21 AND a.FIELDTYPE <>23 AND a.FIELDTYPE <>25 AND a.FIELDTYPE <>27) AND a.SECUREINVISIBLE = '0'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).

Prompt Table: PSPNLDEFN_VW

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

Prompt Table: PSRECDEFN

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

Prompt Table: PSDBFIELD

4 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
5 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
6 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
7 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
8 LABELTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
9 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
10 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
11 GRDCOLUMNCOUNT Number(3,0) SMALLINT NOT NULL Grid Column Count
12 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

Prompt Table: MSG_SET_VW

13 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

Prompt Table: MSG_CAT_VW

14 SUBPNLNAME Character(18) VARCHAR2(18) NOT NULL SubPanel Name