RV_PNLGRID_VW

(SQL View)
 Index Back

PANEL FIELD LABEL

SELECT a.PNLNAME ,a.PNLFLDID ,a.FIELDNUM ,a.PNLFIELDNAME ,a.RECNAME ,a.FIELDNAME ,a.LABEL_ID ,a.LBLTEXT ,a.FIELDTYPE ,a.OCCURSLEVEL ,a.GRDCOLUMNCOUNT ,a.GRDLBLMSGSET ,a.GRDLBLMSGNUM FROM PSPNLFIELD a WHERE a.FIELDTYPE IN (19)

SELECT DISTINCT a.PNLNAME , CASE WHEN D.RECTYPE = 3 THEN a.RECNAME ELSE b.RECNAME END AS RECNAME ,b.FIELDNAME ,b.PNLFLDID ,b.FIELDNUM ,b.PNLFIELDNAME ,b.LABEL_ID ,b.LBLTEXT ,b.FIELDTYPE ,b.OCCURSLEVEL ,b.GRDCOLUMNCOUNT ,b.GRDLBLMSGSET ,b.GRDLBLMSGNUM FROM PSPNLFIELD a , PSPNLFIELD b , PSRECDEFN D WHERE b.PNLNAME IN (a.PNLNAME,a.SUBPNLNAME) AND b.FIELDTYPE = 19 AND b.SECUREINVISIBLE = '0' AND b.RECNAME = D.RECNAME

# 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