RSF_PNLSECT_VW (SQL View)	Index Back
Lets user choose fields This view reads fields from PSPNLFIELD for a given page. Lets user decide which fields to show on a page.

RSF_PNLSECT_VW

(SQL View)

Lets user choose fields

This view reads fields from PSPNLFIELD for a given page. Lets user decide which fields to show on a page.

SELECT A.PNLNAME , A.FIELDNAME , B.LONGNAME , A.FIELDNUM , A.RECNAME FROM PSPNLFIELD A , PSDBFLDLABL B WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDTYPE = 2 AND B.DEFAULT_LABEL = 1 AND A.PNLFIELDNAME <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: RSF_PNLFIELD_VW

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: RSF_PNLFIELD_VW
3	LBLTEXT	Character(60)	VARCHAR2(60) NOT NULL	Label Text
4	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
5	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).