GP_MT_RFLD_VW

(SQL View)
 Index Back

Record-Fields in a Component

This view selects all the fields on a record within a component. It includes all the fields that are on subrecords. For that purpose the Tools view PSRECFIELDSALL is used. Therefore the expansion goes down to one level only.

SELECT DISTINCT PG.PNLGRPNAME , RF.RECNAME , RF.FIELDNAME , FL.LONGNAME FROM PSPNLGROUP PG , PSPNLFIELD PF , PSRECFIELDALL RF , PSDBFLDLABL FL WHERE (PF.PNLNAME = PG.PNLNAME OR PF.PNLNAME IN ( SELECT PF1.SUBPNLNAME FROM PSPNLGROUP PG1 , PSPNLFIELD PF1 WHERE PG1.PNLGRPNAME = PG.PNLGRPNAME AND PF1.PNLNAME = PG1.PNLNAME AND PF1.SUBPNLNAME <> ' ' )) AND PF.ASSOCFIELDNUM = 0 AND PF.RECNAME <> ' ' AND PF.FIELDNUM = ( SELECT MIN(PF1.FIELDNUM) FROM PSPNLFIELD PF1 WHERE PF1.PNLNAME = PF.PNLNAME AND PF1.RECNAME = PF.RECNAME ) AND RF.RECNAME = PF.RECNAME AND FL.FIELDNAME = RF.FIELDNAME AND FL.DEFAULT_LABEL = 1

  • Related Language Record: GP_MT_RFL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description