RV_PLRECFLD_LVW

(SQL View)
 Index Back

Records used on panels

SELECT DISTINCT PNLNAME , RECNAME , FIELDNAME , FIELDTYPE , OCCURSLEVEL , LABEL_ID , LBLTEXT , FIELDNUM FROM PSPNLFIELD WHERE FIELDTYPE NOT IN (19,27) AND SECUREINVISIBLE = 0 AND FIELDNAME <> ' ' --------- SELECT DISTINCT A.PNLNAME , A.RECNAME , B.FIELDNAME , B.FIELDTYPE , A.OCCURSLEVEL , B.LABEL_ID , B.LBLTEXT , B.FIELDNUM FROM PSPNLFIELD A , PSPNLFIELD B WHERE B.FIELDTYPE NOT IN (8,11,18,19,21,27) AND B.SECUREINVISIBLE = 0 AND B.RECNAME <> ' ' AND A.FIELDTYPE NOT IN (18,19,21,27) AND A.SECUREINVISIBLE = 0 AND A.RECNAME <> ' ' AND (B.RECNAME = A.RECNAME OR B.RECNAME IN ( SELECT C.RECNAME FROM PSPNLFIELD C WHERE C.PNLNAME = A.SUBPNLNAME)) AND (B.PNLNAME = A.PNLNAME OR B.PNLNAME = A.SUBPNLNAME)

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

  • Related Language Record for RV_PNLRECFLD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).
    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    6 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text