GP_MT_CREC_VW

(SQL View)
 Index Back

Records in a Component

This record serves as a prompt view for records (names and descriptions) within a component. Only records of type - SQL Table - SQL View - Derived are selected.

SELECT DISTINCT PG.PNLGRPNAME , RD.RECNAME , RD.RECDESCR FROM PSPNLGROUP PG , PSPNLFIELD PF , PSRECDEFN RD WHERE RD.RECNAME = PF.RECNAME AND RD.RECTYPE IN (0,1,2) AND PF.ASSOCFIELDNUM = 0 AND PF.PNLNAME<>' ' AND ( 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))

  • Related Language Record: GP_MT_CR_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description