RC_PNLFIELD_LVW

(SQL View)
 Index Back

Panel Fields

Field that are used in a Page. This view is used in Self Service Configuration Setup Page.

SELECT A.PNLNAME , B.FIELDNUM , A.LANGUAGE_CD , A.LABEL_ID , A.LBLTEXT FROM PSPNLFIELDLANG A , PSPNLFIELD B WHERE A.PNLNAME = B.PNLNAME AND A.PNLFLDID = B.PNLFLDID

  • Related Language Record for RC_PSPNLFIELD

  • Parent record: PSPNLDEFN

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

    Prompt Table: PSPNLDEFN_VW

    2 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Prompt Table: PSPNLDEFN

    4 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    5 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text