TL_START_MENU(SQL Table) |
Index Back |
---|---|
TL/GA Application Start Menu09/24/13 EGS: Created |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
2 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
3 | PAGEID | Character(18) | VARCHAR2(18) NOT NULL | Page ID for discounts and perks category pages. |
4 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
5 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
6 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
7 | ACCESS_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Access Mode
A=Add C=Correction L=Update/Display All U=Update/Display |
8 | TL_ICON | Image Reference(30) | VARCHAR2(30) | 07/17/13 EGS: Created |
9 | CREF_PATH | Character(254) | VARCHAR2(254) NOT NULL | Content Reference Path |
10 | MENU_SUBTYPE | Character(1) | VARCHAR2(1) NOT NULL |
10/02/13 EGS: Created
1=Employee 2=Manager Default Value: 1 |