EODC_PNLGR4_VW

(SQL View)
 Index Back

Component Page & Subpage View

Listing all the pages and subpages for every component. This view support up to 3 level deep into the subpages. Component Page - Subpages 1 - Subpages 2 - Subpages 3

SELECT DISTINCT MARKET , PNLGRPNAME , PNLNAME , 0 , ' ' FROM PSPNLGROUP UNION SELECT MARKET , PNLGRPNAME , PNLNAME , OCCURSLEVEL , RECNAME FROM PS_EODC_PNLGR1_VW UNION SELECT MARKET , PNLGRPNAME , PNLNAME , OCCURSLEVEL , RECNAME FROM PS_EODC_PNLGR2_VW UNION SELECT MARKET , PNLGRPNAME , PNLNAME , OCCURSLEVEL , RECNAME FROM PS_EODC_PNLGR3_VW UNION SELECT DISTINCT D.MARKET , D.PNLGRPNAME , E.SUBPNLNAME , E.OCCURSLEVEL + D.OCCURSLEVEL , E.RECNAME FROM PSPNLFIELD E , PS_EODC_PNLGR3_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).