RV_PNLRECFLD_VW (SQL View)	Index Back
Records used on panels SELECT DISTINCT PNLNAME , RECNAME , FIELDNAME , FIELDTYPE , OCCURSLEVEL , LABEL_ID , LBLTEXT , FIELDNUM FROM PSPNLFIELD WHERE FIELDTYPE NOT IN (19,27) AND SECUREINVISIBLE = 0 AND FIELDNAME <> ' ' --------- SELECT DISTINCT A.PNLNAME , A.RECNAME , B.FIELDNAME , B.FIELDTYPE , A.OCCURSLEVEL , B.LABEL_ID , B.LBLTEXT , B.FIELDNUM FROM PSPNLFIELD A , PSPNLFIELD B WHERE B.FIELDTYPE NOT IN (8,11,18,19,21,27) AND B.SECUREINVISIBLE = 0 AND B.RECNAME <> ' ' AND A.FIELDTYPE NOT IN (18,19,21,27) AND A.SECUREINVISIBLE = 0 AND A.RECNAME <> ' ' AND (B.RECNAME = A.RECNAME OR B.RECNAME IN ( SELECT C.RECNAME FROM PSPNLFIELD C WHERE C.PNLNAME = A.SUBPNLNAME)) AND (B.PNLNAME = A.PNLNAME OR B.PNLNAME = A.SUBPNLNAME)

RV_PNLRECFLD_VW

(SQL View)

Records used on panels

SELECT DISTINCT PNLNAME , RECNAME , FIELDNAME , FIELDTYPE , OCCURSLEVEL , LABEL_ID , LBLTEXT , FIELDNUM FROM PSPNLFIELD WHERE FIELDTYPE NOT IN (19,27) AND SECUREINVISIBLE = 0 AND FIELDNAME <> ' ' --------- SELECT DISTINCT A.PNLNAME , A.RECNAME , B.FIELDNAME , B.FIELDTYPE , A.OCCURSLEVEL , B.LABEL_ID , B.LBLTEXT , B.FIELDNUM FROM PSPNLFIELD A , PSPNLFIELD B WHERE B.FIELDTYPE NOT IN (8,11,18,19,21,27) AND B.SECUREINVISIBLE = 0 AND B.RECNAME <> ' ' AND A.FIELDTYPE NOT IN (18,19,21,27) AND A.SECUREINVISIBLE = 0 AND A.RECNAME <> ' ' AND (B.RECNAME = A.RECNAME OR B.RECNAME IN ( SELECT C.RECNAME FROM PSPNLFIELD C WHERE C.PNLNAME = A.SUBPNLNAME)) AND (B.PNLNAME = A.PNLNAME OR B.PNLNAME = A.SUBPNLNAME)

SELECT DISTINCT A.PNLNAME , CASE WHEN D.RECTYPE = 3 THEN A.RECNAME ELSE B.RECNAME END AS RECNAME , B.FIELDNAME , B.FIELDTYPE , B.OCCURSLEVEL , B.LABEL_ID , B.LBLTEXT , B.FIELDNUM FROM PSPNLFIELD A , PSPNLFIELD B , PSRECDEFN D WHERE B.FIELDTYPE NOT IN (8,11,18,19,21,27) 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

Related Language Record: RV_PLRECFLD_LVW

# 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 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

7 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text

8 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

#	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	LABEL_ID	Character(18)	VARCHAR2(18) NOT NULL	LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
7	LBLTEXT	Character(60)	VARCHAR2(60) NOT NULL	Label Text
8	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number