RSF_PNLFLD_LVW

(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 B.PNLNAME , B.FIELDNAME , A.LANGUAGE_CD , A.LBLTEXT FROM PSPNLFIELDLANG A , PSPNLFIELD B WHERE A.PNLNAME = B.PNLNAME AND A.PNLFLDID = B.PNLFLDID AND B.OCCURSLEVEL IN (1,2) AND B.LABEL_ID <> ' ' AND B.LBLTEXT <> ' ' AND B.PNLFIELDNAME <> ' ' AND B.FIELDTYPE NOT IN (9,12)

  • Related Language Record for RSF_PNLFIELD_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text