TAB_PAGE_IDTAB_IDENTLANGUAGE_CDDISPLAY_ORDERPrompt Table:
TL_TAB_PAGE_VW
Set Control Field: PORTAL_OBJNAME
N=No
Y=Yes
Default Value: N
TL_TABSUB_LNG(SQL View) |
Index Back |
|---|---|
Tab Definition DetailTab Definition Detail |
| SELECT DISTINCT PAGE_DTL.TAB_PAGE_ID , TAB_DTL.TAB_IDENT , PNLLNG.LANGUAGE_CD , TAB_DTL.DISPLAY_ORDER , TAB_DTL.PORTAL_NAME , TAB_DTL.PORTAL_OBJNAME , PORLNG.PORTAL_LABEL , TAB_DTL.PANELNAME , PNLGRP.ITEMLABEL , TAB_DTL.TAB_STARTING_PAGE , ITM.MENUNAME , ITM.BARNAME , ITM.ITEMNAME , ITM.PNLGRPNAME , PNLLNG.ITEMLABEL , TAB_DTL.TABLABEL_OPTN FROM PS_TL_TAB_PAGE_DTL PAGE_DTL , PS_TL_TAB_DTL TAB_DTL , PSPNLGROUP PNLGRP , PSPNLGROUPLANG PNLLNG , PSPRSMDEFN POR , PSPRSMDEFNLANG PORLNG , PSMENUITEM ITM WHERE PAGE_DTL.TAB_IDENT = TAB_DTL.TAB_IDENT AND TAB_DTL.PORTAL_NAME = POR.PORTAL_NAME AND TAB_DTL.PORTAL_OBJNAME = POR.PORTAL_OBJNAME AND POR.PORTAL_URI_SEG2 = PNLGRP.PNLGRPNAME AND PORLNG.PORTAL_NAME = POR.PORTAL_NAME AND PORLNG.PORTAL_OBJNAME = POR.PORTAL_OBJNAME AND PNLLNG.PNLGRPNAME = PNLGRP.PNLGRPNAME AND PNLLNG.PNLNAME = PNLGRP.PNLNAME AND TAB_DTL.PANELNAME = PNLGRP.PNLNAME AND ((ITM.MENUNAME = POR.PORTAL_URI_SEG1 AND ITM.PNLGRPNAME = POR.PORTAL_URI_SEG2) OR (ITM.MENUNAME = POR.PORTAL_URI_SEG1 AND ITM.ITEMNAME = POR.PORTAL_URI_SEG2)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TAB_PAGE_ID |
Character(10) | VARCHAR2(10) NOT NULL | TL Tab Page ID |
| 2 | TAB_IDENT |
Character(10) | VARCHAR2(10) NOT NULL | Tab Identification |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DISPLAY_ORDER |
Number(3,0) | SMALLINT NOT NULL | Display order for ordering items in a list - web style |
| 5 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 6 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 7 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 8 | PANELNAME | Character(18) | VARCHAR2(18) NOT NULL |
Panelname
Prompt Table:
TL_TAB_PAGE_VW
|
| 9 | ITEMLABEL | Character(30) | VARCHAR2(30) NOT NULL | Menu Item Label |
| 10 | TAB_STARTING_PAGE | Character(1) | VARCHAR2(1) NOT NULL |
Tab Starting Page
N=No Y=Yes Default Value: N |
| 11 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 12 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 13 | MENU_ITEM | Character(30) | VARCHAR2(30) NOT NULL | Menu Name |
| 14 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 15 | PAGELABEL | Character(30) | VARCHAR2(30) NOT NULL | Page Label |
| 16 | TABLABEL_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Page Name as Tab Label (Y/N)? |