TAB_PAGE_IDDISPLAY_ORDERTAB_IDENTPrompt Table: TL_TAB
N=No
Y=Yes
TL_TAB_MAIN_VW(SQL View) |
Index Back |
|---|---|
Main Tab ViewMain Tab View |
| SELECT P_DTL.TAB_PAGE_ID , P_DTL.DISPLAY_ORDER , P_DTL.TAB_IDENT , TAB.TAB_LABEL , P_DTL.TAB_STARTING_PAGE FROM PS_TL_TAB_PAGE_DTL P_DTL , PS_TL_TAB TAB WHERE TAB.TAB_IDENT = P_DTL.TAB_IDENT |
| # | 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 | DISPLAY_ORDER |
Number(3,0) | SMALLINT NOT NULL | Display order for ordering items in a list - web style |
| 3 | TAB_IDENT |
Character(10) | VARCHAR2(10) NOT NULL |
Tab Identification
Prompt Table: TL_TAB |
| 4 | TAB_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Tab Label |
| 5 | TAB_STARTING_PAGE | Character(1) | VARCHAR2(1) NOT NULL |
Tab Starting Page
N=No Y=Yes |