RV_PNLFLD_VW

(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 ,b.PNLFLDID ,b.FIELDNUM ,b.PNLFIELDNAME ,b.LABEL_ID ,b.LBLTEXT ,b.FIELDTYPE ,b.OCCURSLEVEL ,b.GRDCOLUMNCOUNT ,b.GRDLBLMSGSET ,b.GRDLBLMSGNUM FROM PSPNLFIELD a , PSPNLFIELD b , PSRECDEFN D 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

  • Related Language Record: RV_PNLFLD_LVW

    • # 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 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
    5 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    6 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
    7 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    8 LABELTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
    9 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    10 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
    11 GRDCOLUMNCOUNT Number(3,0) SMALLINT NOT NULL Grid Column Count
    12 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: MSG_SET_VW

    13 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: MSG_CAT_VW