SAIF.Business.Menu database tables

This page catalogs the Oracle tables accessed by SAIF.Business.Menu.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
BUSONLINE_APPS_CODE	Oracle	[unqualified]**	C, R, U, D	Stores application-code to application-path mappings.	clsApplicationCode
MENU_CATEGORY_CODE	Oracle	[unqualified]**	C, R, U, D	Stores menu category codes and descriptions.	clsMenuCategoryCode
MENU_PAGE	Oracle	[unqualified]**	C, R, U, D	Stores page definitions, favorite labels, flags, and tooltips.	clsMenuPage
MENU_ITEM	Oracle	[unqualified]**	C, R, U, D	Stores menu items, page links, categories, order, and visibility.	clsMenuItem
MENU_SECURITY	Oracle	[unqualified]**	C, R, U, D	Stores security groups assigned to menu items.	clsMenuSecurity
MENU_SECURITY_USER	Oracle	[unqualified]**	C, R, U, D	Stores user-to-security-group memberships.	clsMenuSecurityUser
MENU_FAVORITE	Oracle	[unqualified]**	C, R, U, D	Stores per-user favorite items, order, and inactive date.	clsMenuFavorite

BUSONLINE_APPS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores application-code to application-path mappings.
Access pattern	Direct SQL
CRUD operations	C, R, U, D
Key columns used	CODE, CODE_DESCR, ACTIVE_CODE
Sequence	N/A
Related tables	MENU_PAGE
Business objects	clsApplicationCode, clsApplicationCodeCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Build a user's authorized menu
• Maintain reference data

Business rules referencing this table

• None documented.

SQL referencing this table

• SQL-MENU-001: Delete application code
• SQL-MENU-002: Insert application code
• SQL-MENU-003: Retrieve application code
• SQL-MENU-004: Update application code
• SQL-MENU-005: Retrieve all application codes
• SQL-MENU-006: Retrieve active application codes
• SQL-MENU-043: Retrieve authorized menu items for user
• SQL-MENU-044: Retrieve all authorized menu items

---

MENU_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores menu category codes and descriptions.
Access pattern	Direct SQL
CRUD operations	C, R, U, D
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	MENU_ITEM
Business objects	clsMenuCategoryCode, clsMenuCategoryCodeCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Build a user's authorized menu
• Maintain a menu item together with its security-group assignments
• Maintain reference data

Business rules referencing this table

• None documented.

SQL referencing this table

• SQL-MENU-007: Delete menu category code
• SQL-MENU-008: Insert menu category code
• SQL-MENU-009: Retrieve menu category code
• SQL-MENU-010: Update menu category code
• SQL-MENU-011: Retrieve all menu category codes
• SQL-MENU-014: Insert menu item
• SQL-MENU-015: Retrieve menu item
• SQL-MENU-016: Update menu item
• SQL-MENU-017: Retrieve all menu items
• SQL-MENU-043: Retrieve authorized menu items for user
• SQL-MENU-044: Retrieve all authorized menu items

---

MENU_PAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores page definitions, favorite labels, flags, and tooltips.
Access pattern	Direct SQL
CRUD operations	C, R, U, D
Key columns used	MENU_PAGE_SEQ_NUM, PAGE_LINK_TXT, APPLICATION_CODE
Sequence	MENU_PAGE_SEQ
Related tables	BUSONLINE_APPS_CODE, MENU_ITEM
Business objects	clsMenuPage, clsMenuPageCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Build a user's authorized menu
• Maintain a menu item together with its security-group assignments
• Maintain reference data

Business rules referencing this table

• BR-MENU-004: Favorites are always included and ordered

SQL referencing this table

• SQL-MENU-018: Fetch next menu page sequence value
• SQL-MENU-019: Delete menu page
• SQL-MENU-020: Insert menu page
• SQL-MENU-021: Retrieve menu page
• SQL-MENU-022: Update menu page
• SQL-MENU-023: Retrieve all menu pages
• SQL-MENU-043: Retrieve authorized menu items for user
• SQL-MENU-044: Retrieve all authorized menu items

---

MENU_ITEM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores menu items, page links, categories, order, and visibility.
Access pattern	Direct SQL
CRUD operations	C, R, U, D
Key columns used	MENU_ITEM_SEQ_NUM, MENU_PAGE_SEQ_NUM, MENU_CATEGORY_CODE, PAGE_ORDER_NUM
Sequence	MENU_ITEM_SEQ
Related tables	MENU_PAGE, MENU_CATEGORY_CODE, MENU_SECURITY, MENU_FAVORITE
Business objects	clsMenuItem, clsMenuItemCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Build a user's authorized menu
• Manage a user's menu favorites
• Maintain a menu item together with its security-group assignments

Business rules referencing this table

• BR-MENU-002: Unsecured menu items are visible by default
• BR-MENU-003: Security-group matching is case-insensitive
• BR-MENU-005: Menu-item validity and dirtiness cascade to security groups
• BR-MENU-006: Retrieve-all uses the UNSECURED wildcard sentinel

SQL referencing this table

• SQL-MENU-012: Fetch next menu item sequence value
• SQL-MENU-013: Delete menu item
• SQL-MENU-014: Insert menu item
• SQL-MENU-015: Retrieve menu item
• SQL-MENU-016: Update menu item
• SQL-MENU-017: Retrieve all menu items
• SQL-MENU-043: Retrieve authorized menu items for user
• SQL-MENU-044: Retrieve all authorized menu items

---

MENU_SECURITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores security groups assigned to menu items.
Access pattern	Direct SQL
CRUD operations	C, R, U, D
Key columns used	MENU_SECURITY_SEQ_NUM, MENU_ITEM_SEQ_NUM, SECURITY_GROUP_TXT
Sequence	MENU_SECURITY_SEQ
Related tables	MENU_ITEM, MENU_SECURITY_USER
Business objects	clsMenuSecurity, clsMenuSecurityCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Build a user's authorized menu
• Maintain a menu item together with its security-group assignments

Business rules referencing this table

• BR-MENU-002: Unsecured menu items are visible by default
• BR-MENU-003: Security-group matching is case-insensitive
• BR-MENU-005: Menu-item validity and dirtiness cascade to security groups
• BR-MENU-006: Retrieve-all uses the UNSECURED wildcard sentinel

SQL referencing this table

• SQL-MENU-024: Fetch next menu security sequence value
• SQL-MENU-025: Delete menu security row
• SQL-MENU-026: Insert menu security row
• SQL-MENU-027: Retrieve menu security row
• SQL-MENU-028: Update menu security row
• SQL-MENU-029: Retrieve all menu security rows
• SQL-MENU-030: Retrieve menu security for item
• SQL-MENU-043: Retrieve authorized menu items for user
• SQL-MENU-044: Retrieve all authorized menu items

---

MENU_SECURITY_USER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores user-to-security-group memberships.
Access pattern	Direct SQL
CRUD operations	C, R, U, D
Key columns used	MENU_SECURITY_USER_SEQ_NUM, MENU_USER, SECURITY_GROUP_TXT, MENU_USER_EMPLID
Sequence	MENU_SECURITY_USER_SEQ (inline in INSERT)
Related tables	MENU_SECURITY
Business objects	clsMenuSecurityUser, clsMenuSecurityUserCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Build a user's authorized menu
• Maintain reference data

Business rules referencing this table

• BR-MENU-003: Security-group matching is case-insensitive

SQL referencing this table

• SQL-MENU-031: Delete menu security user row
• SQL-MENU-032: Insert menu security user row
• SQL-MENU-033: Update menu security user row
• SQL-MENU-034: Retrieve all menu security user rows
• SQL-MENU-035: Retrieve menu security users for user
• SQL-MENU-043: Retrieve authorized menu items for user
• SQL-MENU-044: Retrieve all authorized menu items

---

MENU_FAVORITE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores per-user favorite items, order, and inactive date.
Access pattern	Direct SQL
CRUD operations	C, R, U, D
Key columns used	MENU_FAVORITE_SEQ_NUM, MENU_USER, MENU_ITEM_SEQ_NUM, MENU_ORDER_NUM, ITEM_INACTIVE_DATE
Sequence	MENU_FAVORITE_SEQ
Related tables	MENU_ITEM
Business objects	clsMenuFavorite, clsMenuFavoriteCollection, clsMenuAuthorizedItemCollection

Operations referencing this table

• Build a user's authorized menu
• Manage a user's menu favorites

Business rules referencing this table

• BR-MENU-004: Favorites are always included and ordered

SQL referencing this table

• SQL-MENU-036: Fetch next menu favorite sequence value
• SQL-MENU-037: Delete menu favorite
• SQL-MENU-038: Insert menu favorite
• SQL-MENU-039: Retrieve menu favorite
• SQL-MENU-040: Update menu favorite
• SQL-MENU-041: Retrieve all menu favorites
• SQL-MENU-042: Retrieve menu favorites for user
• SQL-MENU-043: Retrieve authorized menu items for user

---

Table relationship diagram

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

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

Related documentation

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

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

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\clsMenuItem.vb
• SAIF.Business.Menu\clsMenuPage.vb
• SAIF.Business.Menu\clsMenuSecurity.vb
• SAIF.Business.Menu\clsMenuSecurityCollection.vb
• SAIF.Business.Menu\clsMenuSecurityUser.vb
• SAIF.Business.Menu\clsMenuSecurityUserCollection.vb