RV_PNLFLD_LVW

(SQL View)
 Index Back

PANEL FIELD LABEL

SELECT PNLNAME ,PNLFLDID ,FIELDNUM ,RECNAME ,FIELDNAME ,PNLFIELDNAME ,LABEL_ID ,LBLTEXT ,FIELDTYPE ,OCCURSLEVEL FROM PSPNLFIELD WHERE RECNAME <> ' '

SELECT DISTINCT a.PNLNAME , CASE WHEN D.RECTYPE = 3 THEN a.RECNAME ELSE b.RECNAME END AS RECNAME ,b.FIELDNAME ,E.LANGUAGE_CD ,b.PNLFIELDNAME ,b.LABEL_ID ,b.LBLTEXT FROM PSPNLFIELD a , PSPNLFIELD b , PSRECDEFN D , PSPNLFIELDLANG E WHERE b.PNLNAME IN (a.PNLNAME,a.SUBPNLNAME) AND (b.FIELDTYPE <> 8 AND b.FIELDTYPE <> 11 AND b.FIELDTYPE <> 18 AND b.FIELDTYPE <> 21 AND b.FIELDTYPE <> 27 AND b.FIELDTYPE <> 1 AND b.FIELDTYPE <> 23) AND (a.FIELDTYPE <> 18 AND a.FIELDTYPE <> 1) AND b.SECUREINVISIBLE = '0' AND b.RECNAME = D.RECNAME AND E.PNLNAME = B.PNLNAME AND E.PNLFLDID = B.PNLFLDID

  • Related Language Record for RV_PNLFLD_VW

    • # 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 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
    6 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    7 LABELTEXT Character(60) VARCHAR2(60) NOT NULL Label Text