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

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

MENU Keys 
Key Name  Key Type  Keys 
PI_0300  PrimaryKey  MENU_CD 

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