EODC_PNLGR2_VW

(SQL View)
Index Back

Second Level Subpage View.

Listing all the subpages under the first level of subpages.

SELECT DISTINCT D.MARKET , D.PNLGRPNAME , E.SUBPNLNAME , E.OCCURSLEVEL + D.OCCURSLEVEL , E.RECNAME FROM PSPNLFIELD E , PS_EODC_PNLGR1_VW D WHERE D.PNLNAME = E.PNLNAME AND E.SUBPNLNAME <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MARKET Character(3) VARCHAR2(3) NOT NULL Market
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
4 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).