HCSC_NAV_VW(SQL View) |
Index Back |
---|---|
Navigation ViewView 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) |
# | 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 |