HCSC_NAV_VW

(SQL View)
Index Back

Navigation View

View for finding navigation Path

SELECT POR.PORTAL_NAME , MNU.MENUNAME , MNU.BARNAME , MNU.ITEMNAME , MNU.PNLGRPNAME , MNU.MARKET , PNL.PNLNAME , PNL.ITEMNAME , GRP.DFLTACTION , POR.PORTAL_LABEL , POR.PORTAL_OBJNAME , POR.PORTAL_PRNTOBJNAME , ' ' , ' ' FROM PSPNLGROUP PNL , PSMENUITEM MNU , PSPRSMDEFN POR , PSPNLGRPDEFN GRP WHERE PNL.PNLGRPNAME=MNU.PNLGRPNAME AND POR.PORTAL_REFTYPE='C' AND PNL.PNLGRPNAME=GRP.PNLGRPNAME AND PNL.MARKET=GRP.MARKET AND PNL.HIDDEN=0 AND POR.PORTAL_URI_SEG1=MNU.MENUNAME AND POR.PORTAL_URI_SEG2=GRP.PNLGRPNAME AND POR.PORTAL_URI_SEG3=GRP.MARKET AND PNL.SUBITEMNUM = ( SELECT MIN(PNL2.SUBITEMNUM) FROM PSPNLGROUP PNL2 WHERE PNL2.PNLGRPNAME=PNL.PNLGRPNAME AND PNL2.HIDDEN=0)

  • Related Language Record: HCSC_NAV_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    2 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    3 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    4 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
    5 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    6 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    7 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    8 PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
    9 DFLTACTION Number(5,0) INTEGER NOT NULL Default srch action-internet
    10 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    11 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    12 PORTAL_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name
    13 NAVIGATION Character(254) VARCHAR2(254) NOT NULL Navigation
    14 FIND_NAV_GOTO Character(1) VARCHAR2(1) NOT NULL HR Notepad: Hyperlink