---
title: SAIF.Presentation.Web.MVC database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: SAIF Documentation Team
last_reviewed: 2026-08-17
library: SAIF.Presentation.Web.MVC
reference_type: package
---

# SAIF.Presentation.Web.MVC database tables

This page catalogs database tables accessed by this library. Access is direct ADO.NET (`SqlConnection`/`SqlCommand`/`SqlDataAdapter`), not the standard BOF `IBusinessCriteria` pattern used elsewhere in SAIF.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [Context](#context) | SQL Server (catalog `NETFRAMEWORK`) | `[unqualified]**` | C, R, D | Persists/retrieves cross-application MVC "context" hand-off values (claim ID, policy number, SAIF claim number, provider location sequence number) during navigation between SAIF applications. | `clsContext` |

## Context

| Field | Value |
| --- | --- |
| **Database** | SQL Server (catalog `NETFRAMEWORK`) |
| **Schema/Link** | `[unqualified]**` — no `OWNER.TABLE_NAME` qualifier appears anywhere in the SQL text; actual owning schema could not be confirmed from this library's source alone. |
| **Purpose** | Backs cross-application/cross-page session state hand-off: when a user navigates from one SAIF web application to another, the source application writes context values (claim ID, policy number, SAIF claim number, provider location sequence number) keyed by application name and ASP.NET session ID; the target application reads and then deletes those rows on arrival. |
| **Access pattern** | Direct ADO.NET (`SqlCommand`/`SqlDataAdapter`, inline SQL text, `CommandType.Text`) via the private nested `clsContextRepository` class in `clsContext.vb` — not the BOF `IBusinessCriteria` pattern. |
| **CRUD operations** | Create (Insert), Read (two Retrieve variants), Delete. No Update operation exists against this table in this library. |
| **Key columns used** | `AppName`, `SessionID`, `ContextName`, `ContextValue`, `ID` (SELECT-list only, no identity-retrieval code present), `UpdateDate` (populated via `CURRENT_TIMESTAMP` literal on insert, not a bound parameter). |
| **Sequence** | N/A — key-generation strategy (identity column vs. natural key) is unknown**; no `SCOPE_IDENTITY()`/`@@IDENTITY` retrieval exists in source. |
| **Related tables** | None — `Context` is the only table referenced anywhere in `clsContext.vb`, `clsOnlineContext.vb`, or the calling code in `clsControllerBase.vb`; no `JOIN` clauses appear in any of the four SQL statements. |
| **Business objects** | `clsContext`, `clsOnlineContext` (subclass; performs no additional table access of its own) |

### Operations referencing this table
- [Cross-application context hand-off](operations/cross-application-context-hand-off.md)
- [Cross-application navigation](operations/cross-application-navigation.md)

### Business rules referencing this table
- [BR-MVC-005: Cross-application context transfer only across distinct applications](business-rules.md#br-mvc-005-cross-application-context-transfer-only-across-distinct-applications)

### SQL referencing this table
- [SQL-MVC-001: Insert context value](sql/SQL-MVC-001-insert-context-value.md)
- [SQL-MVC-002: Retrieve cross-application context](sql/SQL-MVC-002-retrieve-cross-application-context.md)
- [SQL-MVC-003: Retrieve single context value by session and name](sql/SQL-MVC-003-retrieve-single-context-value.md)
- [SQL-MVC-004: Delete context rows](sql/SQL-MVC-004-delete-context-rows.md)

---

## Table relationship diagram

No cross-table relationships were identified in this library's SQL. `Context` is a single, standalone table with no `JOIN` clauses or shared-key references to any other table in this library's scope.

## 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)
- [Configuration](configuration.md)
- [SQL catalog](sql/index.md)
- [API reference](api/index.md)

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

## Sources
- SAIF.Presentation.Web.MVC\clsContext.vb
- SAIF.Presentation.Web.MVC\clsOnlineContext.vb
- SAIF.Presentation.Web.MVC\clsControllerBase.vb