RSF_PAGE_FLD_VW

(SQL View)
 Index Back

Fields on a page

Contains fields user chooses to appear on a page.

SELECT A.PNLNAME , B.DESCR , A.FIELDNAME , A.FIELDNUM FROM PS_RSF_PAGE_FIELDS A , PSPNLDEFN B WHERE A.PNLNAME = B.PNLNAME

  • Related Language Record: RSF_PAGE_FLD_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Prompt Table: RSF_PNLDEFN_VW

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number