SAIF.Business.Menu database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
BUSONLINE_APPS_CODE	Oracle	[unqualified]**	C/R/U/D	Stores application identifiers used to scope menu pages	clsApplicationCode
DUAL	Oracle	Oracle system object*	R	Oracle system table used for sequence NEXTVAL retrieval	clsMenuFavorite, clsMenuItem, clsMenuPage, clsMenuSecurity
MENU_CATEGORY_CODE	Oracle	[unqualified]**	C/R/U/D	Stores category codes that classify menu items	clsMenuCategoryCode
MENU_FAVORITE	Oracle	[unqualified]**	C/R/U/D	Stores per-user favorite menu-item bookmarks	clsMenuFavorite
MENU_ITEM	Oracle	[unqualified]**	C/R/U/D	Stores the core menu item (tree node) records	clsMenuItem
MENU_PAGE	Oracle	[unqualified]**	C/R/U/D	Stores page-level grouping of menu items with toolbar-flag configuration	clsMenuPage
MENU_SECURITY	Oracle	[unqualified]**	C/R/U/D	Associates menu items with security-group string values	clsMenuSecurity
MENU_SECURITY_USER	Oracle	[unqualified]**	C/R/U/D	Associates individual users with security-group records	clsMenuSecurityUser

---

BUSONLINE APPS CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores application identifiers (code + description) that scope menu pages to a given application.
Access pattern	Direct inline SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	CODE, CODE_DESCR, ACTIVE_CODE
Sequence	N/A
Related tables	MENU_PAGE (joined on APPLICATION_CODE = CODE)
Business objects	clsApplicationCode, clsApplicationCodeCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Application code scoping
• Menu authorization data lookup

Business rules referencing this table

• BR-MNU-02: DML row-count enforcement
• BR-MNU-03: Active application code filtering

SQL referencing this table

• SQL-005: Insert application code
• SQL-012: Retrieve application code by key
• SQL-013: Retrieve active application codes
• SQL-014: Retrieve all application codes
• SQL-015: Retrieve all authorized menu items
• SQL-016: Retrieve authorized menu items for user
• SQL-031: Update application code
• SQL-038: Delete application code

---

DUAL

Field	Value
Database	Oracle
Schema/Link	Oracle system object*
Purpose	Oracle system table used exclusively to retrieve the next value from Oracle sequences (NEXTVAL FROM DUAL).
Access pattern	Direct inline SQL
CRUD operations	Read (sequence generation only)
Key columns used	N/A (no column selected — only NEXTVAL expression)
Sequence	MENU_FAVORITE_SEQ, MENU_ITEM_SEQ, MENU_PAGE_SEQ, MENU_SECURITY_SEQ
Related tables	N/A
Business objects	clsMenuFavorite, clsMenuItem, clsMenuPage, clsMenuSecurity

SQL referencing this table

• SQL-001: Generate MENU_FAVORITE_SEQ next value
• SQL-002: Generate MENU_ITEM_SEQ next value
• SQL-003: Generate MENU_PAGE_SEQ next value
• SQL-004: Generate MENU_SECURITY_SEQ next value

---

MENU CATEGORY CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores category codes and descriptions that classify menu items.
Access pattern	Direct inline SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	MENU_ITEM (joined on MENU_CATEGORY_CODE = CODE)
Business objects	clsMenuCategoryCode, clsMenuCategoryCodeCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Menu categorization
• Menu authorization data lookup

Business rules referencing this table

• BR-MNU-02: DML row-count enforcement

SQL referencing this table

• SQL-006: Insert menu category code
• SQL-015: Retrieve all authorized menu items
• SQL-016: Retrieve authorized menu items for user
• SQL-017: Retrieve menu category code by key
• SQL-018: Retrieve all menu category codes
• SQL-032: Update menu category code
• SQL-039: Delete menu category code

---

MENU FAVORITE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores per-user bookmarks to frequently used menu items, including display order and optional deactivation date.
Access pattern	Direct inline SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	MENU_FAVORITE_SEQ_NUM, MENU_USER, MENU_USER_EMPLID, MENU_ITEM_SEQ_NUM, MENU_ORDER_NUM, ITEM_INACTIVE_DATE
Sequence	MENU_FAVORITE_SEQ
Related tables	MENU_ITEM (joined on MENU_ITEM_SEQ_NUM)
Business objects	clsMenuFavorite, clsMenuFavoriteCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Favorite menu management
• Menu authorization data lookup

Business rules referencing this table

• BR-MNU-02: DML row-count enforcement
• BR-MNU-05: Favorite active-status enforcement

SQL referencing this table

• SQL-001: Generate MENU_FAVORITE_SEQ next value
• SQL-007: Insert menu favorite
• SQL-016: Retrieve authorized menu items for user
• SQL-019: Retrieve menu favorite by key
• SQL-020: Retrieve favorites by user ID
• SQL-021: Retrieve all menu favorites
• SQL-033: Update menu favorite
• SQL-040: Delete menu favorite

---

MENU ITEM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores core menu-item records (tree nodes), including page association, category, tooltip, visibility flag, and display order.
Access pattern	Direct inline SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	MENU_ITEM_SEQ_NUM, MENU_PAGE_SEQ_NUM, MENU_CATEGORY_CODE, TOOL_TIP_TXT, VISIBLE_FLAG, PAGE_ORDER_NUM, UPDATE_DATE, UPDATE_USER
Sequence	MENU_ITEM_SEQ
Related tables	MENU_PAGE (parent), MENU_CATEGORY_CODE (lookup), MENU_SECURITY (child), MENU_FAVORITE (child)
Business objects	clsMenuItem, clsMenuItemCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Menu tree construction
• Menu authorization data lookup

Business rules referencing this table

• BR-MNU-01: Menu item visibility determined by security-group or user mapping
• BR-MNU-02: DML row-count enforcement

SQL referencing this table

• SQL-002: Generate MENU_ITEM_SEQ next value
• SQL-008: Insert menu item
• SQL-015: Retrieve all authorized menu items
• SQL-016: Retrieve authorized menu items for user
• SQL-022: Retrieve menu item by key
• SQL-023: Retrieve all menu items
• SQL-034: Update menu item
• SQL-041: Delete menu item

---

MENU PAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores page-level grouping records for menu items, including application association, page links, toolbar-button visibility flags, and tooltip text for each button.
Access pattern	Direct inline SQL (StringBuilder-assembled for insert/update)
CRUD operations	Create, Read, Update, Delete
Key columns used	MENU_PAGE_SEQ_NUM, PAGE_NAME, PAGE_LINK_TXT, APPLICATION_CODE, FAVORITE_NAME, SAVE_PREFERENCES_FLAG, PRINT_FLAG, DOWNLOAD_FLAG, HELP_FLAG, SAVE_FLAG, INSERT_FLAG, DELETE_FLAG, PRINT_TIP_TXT, DOWNLOAD_TIP_TXT, SAVE_TOOLTIP_TXT, INSERT_TOOLTIP_TXT, DELETE_TOOLTIP_TXT, UPDATE_DATE, UPDATE_USER
Sequence	MENU_PAGE_SEQ
Related tables	BUSONLINE_APPS_CODE (parent on APPLICATION_CODE), MENU_ITEM (child)
Business objects	clsMenuPage, clsMenuPageCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Menu tree construction
• Menu authorization data lookup

Business rules referencing this table

• BR-MNU-02: DML row-count enforcement

SQL referencing this table

• SQL-003: Generate MENU_PAGE_SEQ next value
• SQL-009: Insert menu page
• SQL-015: Retrieve all authorized menu items
• SQL-016: Retrieve authorized menu items for user
• SQL-024: Retrieve menu page by key
• SQL-025: Retrieve all menu pages
• SQL-035: Update menu page
• SQL-042: Delete menu page

---

MENU SECURITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Associates a menu item with a security-group string tag used to determine which users can see that item.
Access pattern	Direct inline SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	MENU_SECURITY_SEQ_NUM, MENU_ITEM_SEQ_NUM, SECURITY_GROUP_TXT, UPDATE_DATE, UPDATE_USER
Sequence	MENU_SECURITY_SEQ
Related tables	MENU_ITEM (parent), MENU_SECURITY_USER (related via SECURITY_GROUP_TXT)
Business objects	clsMenuSecurity, clsMenuSecurityCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Menu authorization data lookup

Business rules referencing this table

• BR-MNU-01: Menu item visibility determined by security-group or user mapping
• BR-MNU-02: DML row-count enforcement
• BR-MNU-04: Case-insensitive security-group matching

SQL referencing this table

• SQL-004: Generate MENU_SECURITY_SEQ next value
• SQL-010: Insert menu security
• SQL-015: Retrieve all authorized menu items
• SQL-016: Retrieve authorized menu items for user
• SQL-026: Retrieve menu security by key
• SQL-027: Retrieve menu security by menu item
• SQL-028: Retrieve all menu security records
• SQL-036: Update menu security
• SQL-043: Delete menu security

---

MENU SECURITY USER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Associates individual users with security-group records, enabling the authorized-item UNION queries to match users to menu items by security group.
Access pattern	Direct inline SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	MENU_SECURITY_USER_SEQ_NUM, SECURITY_GROUP_TXT, MENU_USER, MENU_USER_ID, MENU_USER_EMPLID
Sequence	MENU_SECURITY_USER_SEQ (used inline in InsertSQL via MENU_SECURITY_USER_SEQ.NEXTVAL)
Related tables	MENU_SECURITY (related via SECURITY_GROUP_TXT)
Business objects	clsMenuSecurityUser, clsMenuSecurityUserCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Menu authorization data lookup

Business rules referencing this table

• BR-MNU-01: Menu item visibility determined by security-group or user mapping
• BR-MNU-02: DML row-count enforcement
• BR-MNU-04: Case-insensitive security-group matching

SQL referencing this table

• SQL-011: Insert menu security user
• SQL-015: Retrieve all authorized menu items
• SQL-016: Retrieve authorized menu items for user
• SQL-029: Retrieve security users by MenuUser
• SQL-030: Retrieve all menu security users
• SQL-037: Update menu security user
• SQL-044: Delete menu security user

---

Table relationship diagram

The following diagram shows relationships between tables used by this library.

erDiagram
    BUSONLINE_APPS_CODE ||--o{ MENU_PAGE : "APPLICATION_CODE = CODE"
    MENU_PAGE ||--o{ MENU_ITEM : "MENU_PAGE_SEQ_NUM"
    MENU_CATEGORY_CODE ||--o{ MENU_ITEM : "MENU_CATEGORY_CODE = CODE"
    MENU_ITEM ||--o{ MENU_SECURITY : "MENU_ITEM_SEQ_NUM"
    MENU_ITEM ||--o{ MENU_FAVORITE : "MENU_ITEM_SEQ_NUM"
    MENU_SECURITY }o--o{ MENU_SECURITY_USER : "SECURITY_GROUP_TXT (upper-cased)"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• API reference

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.Menu\clsApplicationCode.vb
• Business\SAIF.Business.Menu\clsApplicationCodeCollection.vb
• Business\SAIF.Business.Menu\clsMenuAuthorizedItemCollection.vb
• Business\SAIF.Business.Menu\clsMenuCategoryCode.vb
• Business\SAIF.Business.Menu\clsMenuCategoryCodeCollection.vb
• Business\SAIF.Business.Menu\clsMenuFavorite.vb
• Business\SAIF.Business.Menu\clsMenuFavoriteCollection.vb
• Business\SAIF.Business.Menu\clsMenuItem.vb
• Business\SAIF.Business.Menu\clsMenuItemCollection.vb
• Business\SAIF.Business.Menu\clsMenuPage.vb
• Business\SAIF.Business.Menu\clsMenuPageCollection.vb
• Business\SAIF.Business.Menu\clsMenuSecurity.vb
• Business\SAIF.Business.Menu\clsMenuSecurityCollection.vb
• Business\SAIF.Business.Menu\clsMenuSecurityUser.vb
• Business\SAIF.Business.Menu\clsMenuSecurityUserCollection.vb
• Business\SAIF.Business.Menu\app.config