---
title: "SAIF.Business.Menu SQL catalog"
summary: "Index of all SQL statements used by this library, grouped by operation type."
status: draft
owner: SAIF documentation team
last_reviewed: 2026-08-17
library: SAIF.Business.Menu
reference_type: package
---

# SAIF.Business.Menu SQL catalog

This page indexes all inline SQL statements used by `SAIF.Business.Menu`, grouped by CRUD type.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-MENU-002](SQL-MENU-002-insert-application-code.md) | Insert a new application-code lookup entry | Inline | [BUSONLINE_APPS_CODE](../database-tables.md#busonlineappscode) | `clsApplicationCode` |
| [SQL-MENU-008](SQL-MENU-008-insert-menu-category-code.md) | Insert a new menu category code | Inline | [MENU_CATEGORY_CODE](../database-tables.md#menucategorycode) | `clsMenuCategoryCode` |
| [SQL-MENU-014](SQL-MENU-014-insert-menu-item.md) | Insert a new menu item | Inline | [MENU_ITEM](../database-tables.md#menuitem) | `clsMenuItem` |
| [SQL-MENU-020](SQL-MENU-020-insert-menu-page.md) | Insert a new menu page | Inline | [MENU_PAGE](../database-tables.md#menupage) | `clsMenuPage` |
| [SQL-MENU-026](SQL-MENU-026-insert-menu-security-row.md) | Insert a menu-item security-group assignment | Inline | [MENU_SECURITY](../database-tables.md#menusecurity) | `clsMenuSecurity` |
| [SQL-MENU-032](SQL-MENU-032-insert-menu-security-user-row.md) | Insert a user-to-security-group membership | Inline | [MENU_SECURITY_USER](../database-tables.md#menusecurityuser) | `clsMenuSecurityUser` |
| [SQL-MENU-038](SQL-MENU-038-insert-menu-favorite.md) | Insert a menu favorite row | Inline | [MENU_FAVORITE](../database-tables.md#menufavorite) | `clsMenuFavorite` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-MENU-003](SQL-MENU-003-retrieve-application-code.md) | Retrieve an application code by its lookup key | Inline | [BUSONLINE_APPS_CODE](../database-tables.md#busonlineappscode) | `clsApplicationCode` |
| [SQL-MENU-005](SQL-MENU-005-retrieve-all-application-codes.md) | Retrieve all application code rows | Inline | [BUSONLINE_APPS_CODE](../database-tables.md#busonlineappscode) | `clsApplicationCodeCollection` |
| [SQL-MENU-006](SQL-MENU-006-retrieve-active-application-codes.md) | Retrieve active application code rows | Inline | [BUSONLINE_APPS_CODE](../database-tables.md#busonlineappscode) | `clsApplicationCodeCollection` |
| [SQL-MENU-009](SQL-MENU-009-retrieve-menu-category-code.md) | Retrieve a menu category code by its key | Inline | [MENU_CATEGORY_CODE](../database-tables.md#menucategorycode) | `clsMenuCategoryCode` |
| [SQL-MENU-011](SQL-MENU-011-retrieve-all-menu-category-codes.md) | Retrieve all menu category code rows | Inline | [MENU_CATEGORY_CODE](../database-tables.md#menucategorycode) | `clsMenuCategoryCodeCollection` |
| [SQL-MENU-015](SQL-MENU-015-retrieve-menu-item.md) | Retrieve a menu item by its sequence key | Inline | [MENU_ITEM](../database-tables.md#menuitem) | `clsMenuItem` |
| [SQL-MENU-017](SQL-MENU-017-retrieve-all-menu-items.md) | Retrieve all menu items for maintenance | Inline | [MENU_ITEM](../database-tables.md#menuitem) | `clsMenuItemCollection` |
| [SQL-MENU-021](SQL-MENU-021-retrieve-menu-page.md) | Retrieve a menu page row | Inline | [MENU_PAGE](../database-tables.md#menupage) | `clsMenuPage` |
| [SQL-MENU-023](SQL-MENU-023-retrieve-all-menu-pages.md) | Retrieve all menu page rows | Inline | [MENU_PAGE](../database-tables.md#menupage) | `clsMenuPageCollection` |
| [SQL-MENU-027](SQL-MENU-027-retrieve-menu-security-row.md) | Retrieve a menu-item security-group assignment | Inline | [MENU_SECURITY](../database-tables.md#menusecurity) | `clsMenuSecurity` |
| [SQL-MENU-029](SQL-MENU-029-retrieve-all-menu-security-rows.md) | Retrieve all menu-item security-group assignments | Inline | [MENU_SECURITY](../database-tables.md#menusecurity) | `clsMenuSecurityCollection` |
| [SQL-MENU-030](SQL-MENU-030-retrieve-menu-security-for-item.md) | Retrieve security groups for a menu item | Inline | [MENU_SECURITY](../database-tables.md#menusecurity) | `clsMenuSecurityCollection` |
| [SQL-MENU-034](SQL-MENU-034-retrieve-all-menu-security-user-rows.md) | Retrieve all user-to-security-group memberships | Inline | [MENU_SECURITY_USER](../database-tables.md#menusecurityuser) | `clsMenuSecurityUserCollection` |
| [SQL-MENU-035](SQL-MENU-035-retrieve-menu-security-users-for-user.md) | Retrieve security groups for a user | Inline | [MENU_SECURITY_USER](../database-tables.md#menusecurityuser) | `clsMenuSecurityUserCollection` |
| [SQL-MENU-039](SQL-MENU-039-retrieve-menu-favorite.md) | Retrieve a menu favorite row | Inline | [MENU_FAVORITE](../database-tables.md#menufavorite) | `clsMenuFavorite` |
| [SQL-MENU-041](SQL-MENU-041-retrieve-all-menu-favorites.md) | Retrieve all menu favorite rows | Inline | [MENU_FAVORITE](../database-tables.md#menufavorite) | `clsMenuFavoriteCollection` |
| [SQL-MENU-042](SQL-MENU-042-retrieve-menu-favorites-for-user.md) | Retrieve menu favorites for a user | Inline | [MENU_FAVORITE](../database-tables.md#menufavorite) | `clsMenuFavoriteCollection` |
| [SQL-MENU-043](SQL-MENU-043-retrieve-authorized-menu-items-for-user.md) | Retrieve authorized menu items for a user | Inline | [BUSONLINE_APPS_CODE](../database-tables.md#busonlineappscode)<br>[MENU_CATEGORY_CODE](../database-tables.md#menucategorycode)<br>[MENU_PAGE](../database-tables.md#menupage)<br>[MENU_ITEM](../database-tables.md#menuitem)<br>[MENU_SECURITY](../database-tables.md#menusecurity)<br>[MENU_SECURITY_USER](../database-tables.md#menusecurityuser)<br>[MENU_FAVORITE](../database-tables.md#menufavorite) | `clsMenuAuthorizedItemCollection` |
| [SQL-MENU-044](SQL-MENU-044-retrieve-all-authorized-menu-items.md) | Retrieve the full authorized menu snapshot | Inline | [BUSONLINE_APPS_CODE](../database-tables.md#busonlineappscode)<br>[MENU_CATEGORY_CODE](../database-tables.md#menucategorycode)<br>[MENU_PAGE](../database-tables.md#menupage)<br>[MENU_ITEM](../database-tables.md#menuitem)<br>[MENU_SECURITY](../database-tables.md#menusecurity)<br>[MENU_SECURITY_USER](../database-tables.md#menusecurityuser) | `clsMenuAuthorizedItemCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-MENU-004](SQL-MENU-004-update-application-code.md) | Update an application-code mapping | Inline | [BUSONLINE_APPS_CODE](../database-tables.md#busonlineappscode) | `clsApplicationCode` |
| [SQL-MENU-010](SQL-MENU-010-update-menu-category-code.md) | Update a menu category code's description | Inline | [MENU_CATEGORY_CODE](../database-tables.md#menucategorycode) | `clsMenuCategoryCode` |
| [SQL-MENU-016](SQL-MENU-016-update-menu-item.md) | Update a menu item's placement and display attributes | Inline | [MENU_ITEM](../database-tables.md#menuitem) | `clsMenuItem` |
| [SQL-MENU-022](SQL-MENU-022-update-menu-page.md) | Update a menu page's attributes | Inline | [MENU_PAGE](../database-tables.md#menupage) | `clsMenuPage` |
| [SQL-MENU-028](SQL-MENU-028-update-menu-security-row.md) | Update a menu-item security-group assignment | Inline | [MENU_SECURITY](../database-tables.md#menusecurity) | `clsMenuSecurity` |
| [SQL-MENU-033](SQL-MENU-033-update-menu-security-user-row.md) | Update a user-to-security-group membership | Inline | [MENU_SECURITY_USER](../database-tables.md#menusecurityuser) | `clsMenuSecurityUser` |
| [SQL-MENU-040](SQL-MENU-040-update-menu-favorite.md) | Update a menu favorite row | Inline | [MENU_FAVORITE](../database-tables.md#menufavorite) | `clsMenuFavorite` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-MENU-001](SQL-MENU-001-delete-application-code.md) | Delete an application-code lookup entry | Inline | [BUSONLINE_APPS_CODE](../database-tables.md#busonlineappscode) | `clsApplicationCode` |
| [SQL-MENU-007](SQL-MENU-007-delete-menu-category-code.md) | Delete a menu category code | Inline | [MENU_CATEGORY_CODE](../database-tables.md#menucategorycode) | `clsMenuCategoryCode` |
| [SQL-MENU-013](SQL-MENU-013-delete-menu-item.md) | Delete a menu item | Inline | [MENU_ITEM](../database-tables.md#menuitem) | `clsMenuItem` |
| [SQL-MENU-019](SQL-MENU-019-delete-menu-page.md) | Delete a menu page | Inline | [MENU_PAGE](../database-tables.md#menupage) | `clsMenuPage` |
| [SQL-MENU-025](SQL-MENU-025-delete-menu-security-row.md) | Delete a menu-item security-group assignment | Inline | [MENU_SECURITY](../database-tables.md#menusecurity) | `clsMenuSecurity` |
| [SQL-MENU-031](SQL-MENU-031-delete-menu-security-user-row.md) | Delete a user-to-security-group membership | Inline | [MENU_SECURITY_USER](../database-tables.md#menusecurityuser) | `clsMenuSecurityUser` |
| [SQL-MENU-037](SQL-MENU-037-delete-menu-favorite.md) | Delete a menu favorite row | Inline | [MENU_FAVORITE](../database-tables.md#menufavorite) | `clsMenuFavorite` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-MENU-012](SQL-MENU-012-next-menu-item-sequence.md) | Fetch the next menu item key | `MENU_ITEM_SEQ` | [MENU_ITEM](../database-tables.md#menuitem) | `clsMenuItem` |
| [SQL-MENU-018](SQL-MENU-018-next-menu-page-sequence.md) | Fetch the next menu page key | `MENU_PAGE_SEQ` | [MENU_PAGE](../database-tables.md#menupage) | `clsMenuPage` |
| [SQL-MENU-024](SQL-MENU-024-next-menu-security-sequence.md) | Fetch the next menu security key | `MENU_SECURITY_SEQ` | [MENU_SECURITY](../database-tables.md#menusecurity) | `clsMenuSecurity` |
| [SQL-MENU-036](SQL-MENU-036-next-menu-favorite-sequence.md) | Fetch the next menu favorite key | `MENU_FAVORITE_SEQ` | [MENU_FAVORITE](../database-tables.md#menufavorite) | `clsMenuFavorite` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Security and authorization](../security-authorization.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)

## Sources
- `SAIF.Business.Menu\clsApplicationCode.vb`
- `SAIF.Business.Menu\clsApplicationCodeCollection.vb`
- `SAIF.Business.Menu\clsMenuAuthorizedItemCollection.vb`
- `SAIF.Business.Menu\clsMenuCategoryCode.vb`
- `SAIF.Business.Menu\clsMenuFavorite.vb`
- `SAIF.Business.Menu\clsMenuFavoriteCollection.vb`
- `SAIF.Business.Menu\clsMenuItem.vb`
- `SAIF.Business.Menu\clsMenuItemCollection.vb`
- `SAIF.Business.Menu\clsMenuPage.vb`
- `SAIF.Business.Menu\clsMenuPageCollection.vb`
- `SAIF.Business.Menu\clsMenuSecurity.vb`
- `SAIF.Business.Menu\clsMenuSecurityCollection.vb`
- `SAIF.Business.Menu\clsMenuSecurityUser.vb`
- `SAIF.Business.Menu\clsMenuSecurityUserCollection.vb`