RV_PNLRECGRD_VW

(SQL View)
 Index Back

Records used on panels

This view returns all the records for a panel definition.

SELECT DISTINCT a.PNLNAME , CASE WHEN D.RECTYPE = 3 THEN a.RECNAME ELSE b.RECNAME END AS RECNAME ,b.PNLFIELDNAME ,b.FIELDTYPE ,b.OCCURSLEVEL ,b.GRDLBLMSGSET ,b.GRDLBLMSGNUM FROM PSPNLFIELD a , PSPNLFIELD b , PSRECDEFN D WHERE b.FIELDTYPE = 19 AND b.SECUREINVISIBLE = '0' AND b.RECNAME <> ' ' AND b.RECNAME IN ( SELECT C.RECNAME FROM PSPNLFIELD C WHERE C.PNLNAME = a.SUBPNLNAME OR C.PNLNAME = a.PNLNAME) AND (b.PNLNAME = a.PNLNAME OR b.PNLNAME = a.SUBPNLNAME) AND D.RECNAME = b.RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
5 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
6 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

7 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