SAIF.Business.Menu database tables

This page catalogs the 8 Oracle tables (7 business tables plus the DUAL pseudo-table) accessed by SAIF.Business.Menu. No OWNER.TABLE schema qualifier appears anywhere in the source, so schema/owner is recorded as unknown ([unqualified]**) for every table rather than inferred from table-name prefixes.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
MENU_PAGE	Oracle	[unqualified]**	CRUD	Stores the page definition placed into the menu — the page link, display name, and toolbar/tooltip flags.	clsMenuPage
MENU_ITEM	Oracle	[unqualified]**	CRUD	Places a menu page within a category, carrying its own security context and display order.	clsMenuItem
MENU_CATEGORY_CODE	Oracle	[unqualified]**	CRUD	Category lookup used to group menu items (e.g., for tabbed or sectioned navigation).	clsMenuCategoryCode
MENU_SECURITY	Oracle	[unqualified]**	CRUD	Maps a menu item to a security group, granting every member of that group access to the item.	clsMenuSecurity
MENU_SECURITY_USER	Oracle	[unqualified]**	CRUD	Maps a user to a security group, establishing which menu-security grants apply to them.	clsMenuSecurityUser
MENU_FAVORITE	Oracle	[unqualified]**	CRUD	Records a user's favorite menu item, including its display order and optional inactive date.	clsMenuFavorite
BUSONLINE_APPS_CODE	Oracle	[unqualified]**	CRUD	Application code lookup: maps a short code to its registered virtual application path and active status.	clsApplicationCode
DUAL	Oracle	[unqualified]**	R	Oracle pseudo-table used only to fetch the next value of a sequence via SEQ.NEXTVAL.	clsMenuFavorite

MENU_PAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores the page definition placed into the menu — the page link, display name, and toolbar/tooltip flags.
Access pattern	Direct inline SQL and StringBuilder-assembled SQL through the SAIF BOF data portal
CRUD operations	CRUD
Key columns used	MENU_PAGE_SEQ_NUM (PK), APPLICATION_CODE (FK to BUSONLINE_APPS_CODE), PAGE_LINK, PAGE_NAME
Sequence	MENU_PAGE_SEQ
Related tables	BUSONLINE_APPS_CODE, MENU_ITEM
Business objects	clsMenuPage, clsMenuPageCollection

Operations referencing this table

• Create a menu item
• Resolve a user's authorized menu items
• Update or delete a maintained object

Business rules referencing this table

• BR-MENU-016
• BR-MENU-019

SQL referencing this table

• SQL-009: Insert a new menu page
• SQL-015: Retrieve a user's authorized menu items
• SQL-016: Retrieve authorized menu items for all users
• SQL-024: Retrieve one menu page by sequence number
• SQL-025: Retrieve all menu pages
• SQL-035: Update a menu page
• SQL-042: Delete a menu page

---

MENU_ITEM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Places a menu page within a category, carrying its own security context and display order.
Access pattern	Direct inline SQL and StringBuilder-assembled SQL through the SAIF BOF data portal
CRUD operations	CRUD
Key columns used	MENU_ITEM_SEQ_NUM (PK), MENU_PAGE_SEQ_NUM (FK to MENU_PAGE), MENU_CATEGORY_CODE (FK to MENU_CATEGORY_CODE)
Sequence	MENU_ITEM_SEQ
Related tables	MENU_PAGE, MENU_CATEGORY_CODE, MENU_SECURITY, MENU_FAVORITE
Business objects	clsMenuItem, clsMenuItemCollection

Operations referencing this table

• Create a menu item
• Resolve a user's authorized menu items
• Update or delete a maintained object

Business rules referencing this table

• BR-MENU-004
• BR-MENU-016
• BR-MENU-019

SQL referencing this table

• SQL-008: Insert a new menu item
• SQL-015: Retrieve a user's authorized menu items
• SQL-016: Retrieve authorized menu items for all users
• SQL-022: Retrieve one menu item by sequence number
• SQL-023: Retrieve all menu items
• SQL-034: Update a menu item
• SQL-041: Delete a menu item

---

MENU_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Category lookup used to group menu items (e.g., for tabbed or sectioned navigation).
Access pattern	Direct inline SQL and StringBuilder-assembled SQL through the SAIF BOF data portal
CRUD operations	CRUD
Key columns used	CODE (PK, caller-supplied), CODE_DESCR
Sequence	N/A — CODE is caller-supplied, not sequence-assigned
Related tables	MENU_ITEM
Business objects	clsMenuCategoryCode, clsMenuCategoryCodeCollection

Operations referencing this table

• Create a menu item
• Resolve a user's authorized menu items
• Update or delete a maintained object

SQL referencing this table

• SQL-006: Insert a new menu category code
• SQL-015: Retrieve a user's authorized menu items
• SQL-016: Retrieve authorized menu items for all users
• SQL-017: Retrieve one menu category code
• SQL-018: Retrieve all menu category codes
• SQL-032: Update a menu category code
• SQL-039: Delete a menu category code

---

MENU_SECURITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Maps a menu item to a security group, granting every member of that group access to the item.
Access pattern	Direct inline SQL and StringBuilder-assembled SQL through the SAIF BOF data portal
CRUD operations	CRUD
Key columns used	MENU_SECURITY_SEQ_NUM (PK), MENU_ITEM_SEQ_NUM (FK to MENU_ITEM), SECURITY_GROUP_TXT
Sequence	MENU_SECURITY_SEQ
Related tables	MENU_ITEM, MENU_SECURITY_USER
Business objects	clsMenuSecurity, clsMenuSecurityCollection

Operations referencing this table

• Create a menu item
• Resolve a user's authorized menu items
• Load security grants for an item
• Update or delete a maintained object

Business rules referencing this table

• BR-MENU-002
• BR-MENU-003
• BR-MENU-004
• BR-MENU-016
• BR-MENU-021

SQL referencing this table

• SQL-010: Insert a new security-group grant
• SQL-015: Retrieve a user's authorized menu items
• SQL-016: Retrieve authorized menu items for all users
• SQL-026: Retrieve one security grant by sequence number
• SQL-027: Retrieve all security grants
• SQL-028: Retrieve security grants for one menu item
• SQL-036: Update a security-group grant
• SQL-043: Delete a security-group grant

---

MENU_SECURITY_USER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Maps a user to a security group, establishing which menu-security grants apply to them.
Access pattern	Direct inline SQL and StringBuilder-assembled SQL through the SAIF BOF data portal
CRUD operations	CRUD
Key columns used	MENU_SECURITY_USER_SEQ_NUM (PK, assigned inline from MENU_SECURITY_USER_SEQ.NEXTVAL), SECURITY_GROUP_TXT, MENU_USER_ID
Sequence	MENU_SECURITY_USER_SEQ (fetched inline in the INSERT, not as a separate statement)
Related tables	MENU_SECURITY
Business objects	clsMenuSecurityUser, clsMenuSecurityUserCollection

Operations referencing this table

• Create a menu item
• Resolve a user's authorized menu items
• Load a user's group memberships
• Update or delete a maintained object

Business rules referencing this table

• BR-MENU-002
• BR-MENU-003

SQL referencing this table

• SQL-011: Insert a new group membership
• SQL-015: Retrieve a user's authorized menu items
• SQL-016: Retrieve authorized menu items for all users
• SQL-029: Retrieve all group memberships
• SQL-030: Retrieve group memberships for one user
• SQL-037: Update a group membership
• SQL-044: Delete a group membership

---

MENU_FAVORITE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Records a user's favorite menu item, including its display order and optional inactive date.
Access pattern	Direct inline SQL and StringBuilder-assembled SQL through the SAIF BOF data portal
CRUD operations	CRUD
Key columns used	MENU_FAVORITE_SEQ_NUM (PK), MENU_ITEM_SEQ_NUM (FK to MENU_ITEM), ITEM_INACTIVE_DATE
Sequence	MENU_FAVORITE_SEQ
Related tables	MENU_ITEM
Business objects	clsMenuFavorite, clsMenuFavoriteCollection

Operations referencing this table

• Create a menu item
• Resolve a user's authorized menu items
• Load a user's favorites
• Update or delete a maintained object

Business rules referencing this table

• BR-MENU-005
• BR-MENU-006

SQL referencing this table

• SQL-007: Insert a new user favorite
• SQL-015: Retrieve a user's authorized menu items
• SQL-019: Retrieve one favorite by sequence number
• SQL-020: Retrieve all favorites for all users
• SQL-021: Retrieve favorites for one user
• SQL-033: Update a user favorite
• SQL-040: Delete a user favorite

---

BUSONLINE_APPS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Application code lookup: maps a short code to its registered virtual application path and active status.
Access pattern	Direct inline SQL and StringBuilder-assembled SQL through the SAIF BOF data portal
CRUD operations	CRUD
Key columns used	CODE (PK, caller-supplied), CODE_DESCR, ACTIVE_CODE
Sequence	N/A — CODE is caller-supplied, not sequence-assigned
Related tables	MENU_PAGE
Business objects	clsApplicationCode, clsApplicationCodeCollection

Operations referencing this table

• Create a menu item
• Load application codes
• Resolve a user's authorized menu items
• Update or delete a maintained object

Business rules referencing this table

• BR-MENU-012
• BR-MENU-013

SQL referencing this table

• SQL-005: Insert a new application code
• SQL-012: Retrieve one application code by code
• SQL-013: Retrieve all application codes
• SQL-014: Retrieve only active application codes
• SQL-015: Retrieve a user's authorized menu items
• SQL-016: Retrieve authorized menu items for all users
• SQL-031: Update an application code
• SQL-038: Delete an application code

---

DUAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Oracle pseudo-table used only to fetch the next value of a sequence via SEQ.NEXTVAL.
Access pattern	Direct inline SQL through the SAIF BOF data portal
CRUD operations	R
Key columns used	N/A
Sequence	N/A — target of all four scalar NEXTVAL statements (SQL-001–SQL-004)
Related tables	(none — not joined to any business table)
Business objects	clsMenuFavorite, clsMenuItem, clsMenuPage, clsMenuSecurity

Operations referencing this table

• Create a menu item

SQL referencing this table

• SQL-001: Fetch next MENU_FAVORITE sequence value
• SQL-002: Fetch next MENU_ITEM sequence value
• SQL-003: Fetch next MENU_PAGE sequence value
• SQL-004: Fetch next MENU_SECURITY sequence value

---

Table relationship diagram

The following diagram shows relationships between tables used by this library, derived from the join predicates in SQL-015 and SQL-016 (the only statements that join across tables).

erDiagram
    BUSONLINE_APPS_CODE ||--o{ MENU_PAGE : "APP.CODE = PAG.APPLICATION_CODE"
    MENU_PAGE ||--o{ MENU_ITEM : "PAG.MENU_PAGE_SEQ_NUM = ITM.MENU_PAGE_SEQ_NUM"
    MENU_CATEGORY_CODE ||--o{ MENU_ITEM : "CAT.CODE = ITM.MENU_CATEGORY_CODE"
    MENU_ITEM ||--o{ MENU_SECURITY : "SEC.MENU_ITEM_SEQ_NUM = ITM.MENU_ITEM_SEQ_NUM"
    MENU_SECURITY ||--o{ MENU_SECURITY_USER : "upper(group text) match (not a surrogate key)"
    MENU_ITEM ||--o{ MENU_FAVORITE : "ITM.MENU_ITEM_SEQ_NUM = FAV.MENU_ITEM_SEQ_NUM"
    BUSONLINE_APPS_CODE {
        VARCHAR2 CODE PK
        VARCHAR2 CODE_DESCR
        VARCHAR2 ACTIVE_CODE
    }
    MENU_PAGE {
        NUMBER MENU_PAGE_SEQ_NUM PK
        VARCHAR2 APPLICATION_CODE FK
        VARCHAR2 PAGE_LINK
    }
    MENU_CATEGORY_CODE {
        VARCHAR2 CODE PK
        VARCHAR2 CODE_DESCR
    }
    MENU_ITEM {
        NUMBER MENU_ITEM_SEQ_NUM PK
        NUMBER MENU_PAGE_SEQ_NUM FK
        VARCHAR2 MENU_CATEGORY_CODE FK
    }
    MENU_SECURITY {
        NUMBER MENU_SECURITY_SEQ_NUM PK
        NUMBER MENU_ITEM_SEQ_NUM FK
        VARCHAR2 SECURITY_GROUP_TXT
    }
    MENU_SECURITY_USER {
        NUMBER MENU_SECURITY_USER_SEQ_NUM PK
        VARCHAR2 SECURITY_GROUP_TXT
        VARCHAR2 MENU_USER_ID
    }
    MENU_FAVORITE {
        NUMBER MENU_FAVORITE_SEQ_NUM PK
        NUMBER MENU_ITEM_SEQ_NUM FK
        DATE ITEM_INACTIVE_DATE
    }

DUAL is omitted from the diagram — it is an Oracle pseudo-table with no foreign-key relationship to any business table; it is used only as the source table for the four SEQ.NEXTVAL scalar statements (SQL-001–SQL-004).

Related documentation

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

Note: Statements marked with ** could not be confirmed; treat as unknown until verified. Schema/owner is recorded as [unqualified]** for every table because no OWNER.TABLE qualifier or connection string is present in the repository.

Sources

• SAIF.Business.Menu/clsMenuAuthorizedItemCollection.vb
• SAIF.Business.Menu/clsMenuItem.vb
• SAIF.Business.Menu/clsMenuPage.vb
• SAIF.Business.Menu/clsMenuSecurity.vb
• SAIF.Business.Menu/clsMenuSecurityUser.vb
• SAIF.Business.Menu/clsMenuFavorite.vb
• SAIF.Business.Menu/clsMenuCategoryCode.vb
• SAIF.Business.Menu/clsApplicationCode.vb