RSF_PNLFIELD_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.

SELECT A.PNLNAME , A.FIELDNAME , A.LBLTEXT , A.FIELDNUM FROM PSPNLFIELD A WHERE A.OCCURSLEVEL IN (1, 2) AND A.LABEL_ID <> ' ' AND A.LBLTEXT <> ' ' AND A.PNLFIELDNAME <> ' ' AND A.FIELDTYPE NOT IN (9, 12)

  • Related Language Record: RSF_PNLFLD_LVW

    • # 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