RB_TEST_VW4

(SQL View)
Index Back

Common application record

The common application view that retrieves fields for a particular page.

SELECT PNLNAME , RECNAME , FIELDNAME , PNLFIELDNAME , FIELDNUM , LBLTEXT FROM PSPNLFIELD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page 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 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
5 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
6 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text