MENU 
Default Table Name  MENU 
Definition 
Name: System Menu Items and Layout Description: This table contains menu items, layout and ordering.
 

MENU Columns 
ColumnName  Domain  Datatype  NULL  Definition 
MENU_CD(PK)    VARCHAR2(10)  NO 
Name: Menu Description: The identifier for the menu.
 
TOP_MENU_CD    VARCHAR2(10)  YES 
Name: Top Menu Description: The module to which the menu belongs - valid values are TIME,EXPENSE,ADMIN,SELFSERVE
 
PARENT_MENU_CD    VARCHAR2(10)  YES 
Name: Parent Menu Description: The parent for the menu.
 
MENU_LABEL_CD    VARCHAR2(7)  NO 
Name: Menu Label Code Description: A field used in conjunction with the internationalization of menu labels.
 
MENU_ORDER_NO    NUMBER(10, 0)  NO 
Name: Menu Order Description: A numeric field that is used to sort the menus for presentation.
 
SCREEN_CD(FK)    VARCHAR2(10)  YES 
Name: Screen Description: The screen associated with the menu.
 
ACTIVITY_MENU_CD    VARCHAR2(10)  YES 
Name: Activity Menu Description: The activity within the module to which the menu belongs.
 
MODIFIED_BY    VARCHAR2(20)  NO 
 
ROWVERSION    NUMBER(10, 0)  NO 
 
TIME_STAMP    DATE  NO 
 

MENU Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0300  PrimaryKey  MENU_CD 

MENU Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
SCREENS  Non-Identifying  Zero or One to Zero or More  F00441      SCREEN_CD  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable