---
title: SAIF.Presentation.Web.Controls.AJAX.Infragistics103 database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: SAIF documentation generator
last_reviewed: 2026-08-17
library: SAIF.Presentation.Web.Controls.AJAX.Infragistics103
reference_type: package
---

# SAIF.Presentation.Web.Controls.AJAX.Infragistics103 database tables

This page catalogs database tables accessed by this library. All access is read-only: the two `IBusinessCriteria` implementations in this library (`clsHelpText.Criteria`, `clsHelpTextCollection.Criteria`) implement only `RetrieveSQL`; `CreateSQL`, `InsertSQL`, `UpdateSQL`, and `DeleteSQL` all throw `ApplicationException(BOC.Messages.InvalidSQLProperty)` rather than executing SQL.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [APPLICATION_HELP_MASTER](#applicationhelpmaster) | Oracle* | `[unqualified]**` | R | Stores the master help-text record (application code, reference key, description) for a screen field or entity | `clsHelpText` |
| [APPLICATION_HELP_DETAIL](#applicationhelpdetail) | Oracle* | `[unqualified]**` | R | Stores the detail help-text body joined to its master record | `clsHelpText` |

## APPLICATION_HELP_MASTER

| Field | Value |
| --- | --- |
| **Database** | Oracle* — inferred from colon-prefixed bind-variable syntax (`:ApplicationCode`, `:ReferenceKeyValue`); not directly confirmed |
| **Schema/Link** | `[unqualified]**` — no explicit schema qualifier appears in the SQL text |
| **Purpose** | Master record identifying a help-text entry by application code and reference key, with a human-readable description of the reference key |
| **Access pattern** | Direct SQL (inline `SELECT`, no stored procedure) |
| **CRUD operations** | Read only — `CreateSQL`/`InsertSQL`/`UpdateSQL`/`DeleteSQL` are unsupported stub throws* |
| **Key columns used** | `APPLICATION_CODE`, `REFERENCE_KEY_DESCR`, `REFERENCE_KEY_VALUE` |
| **Sequence** | N/A |
| **Related tables** | `APPLICATION_HELP_DETAIL` |
| **Business objects** | `clsHelpText`, `clsHelpTextCollection` |

### Operations referencing this table
- [Retrieve help text for a screen field](operations/retrieve-help-text-for-a-screen-field.md)
- [Retrieve all help text entries for an application](operations/retrieve-all-help-text-entries-for-an-application.md)

### SQL referencing this table
- [SQL-HELP-001: Retrieve help text for a screen field](sql/SQL-HELP-001-retrieve-help-text-for-a-screen-field.md)
- [SQL-HELP-002: Retrieve all help text entries for an application](sql/SQL-HELP-002-retrieve-all-help-text-entries-for-an-application.md)

---

## APPLICATION_HELP_DETAIL

| Field | Value |
| --- | --- |
| **Database** | Oracle* — inferred from colon-prefixed bind-variable syntax (`:ApplicationCode`, `:ReferenceKeyValue`); not directly confirmed |
| **Schema/Link** | `[unqualified]**` — no explicit schema qualifier appears in the SQL text |
| **Purpose** | Detail record holding the actual help-text body for a master help-text entry |
| **Access pattern** | Direct SQL (inline `SELECT`, no stored procedure) |
| **CRUD operations** | Read only — `CreateSQL`/`InsertSQL`/`UpdateSQL`/`DeleteSQL` are unsupported stub throws* |
| **Key columns used** | `HELP_TEXT`, `REFERENCE_KEY_VALUE` |
| **Sequence** | N/A |
| **Related tables** | `APPLICATION_HELP_MASTER` |
| **Business objects** | `clsHelpText`, `clsHelpTextCollection` |

### Operations referencing this table
- [Retrieve help text for a screen field](operations/retrieve-help-text-for-a-screen-field.md)
- [Retrieve all help text entries for an application](operations/retrieve-all-help-text-entries-for-an-application.md)

### SQL referencing this table
- [SQL-HELP-001: Retrieve help text for a screen field](sql/SQL-HELP-001-retrieve-help-text-for-a-screen-field.md)
- [SQL-HELP-002: Retrieve all help text entries for an application](sql/SQL-HELP-002-retrieve-all-help-text-entries-for-an-application.md)

---

## Table relationship diagram

The following diagram shows the join between the two tables used by this library; the join is established solely by the `REFERENCE_KEY_VALUE` predicate in the retrieval SQL, and no table constraints or schema metadata are available to confirm cardinality, so the relationship is shown as unknown (`}o--o{`)**.

```mermaid
erDiagram
    APPLICATION_HELP_MASTER }o--o{ APPLICATION_HELP_DETAIL : "REFERENCE_KEY_VALUE (join only, cardinality unknown)"
    APPLICATION_HELP_MASTER {
        VARCHAR2 APPLICATION_CODE
        VARCHAR2 REFERENCE_KEY_VALUE
        VARCHAR2 REFERENCE_KEY_DESCR
    }
    APPLICATION_HELP_DETAIL {
        VARCHAR2 REFERENCE_KEY_VALUE
        VARCHAR2 HELP_TEXT
    }
```

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

> **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
- `SAIF.Presentation.Web.Controls.AJAX.Infragistics103\clsHelpText.vb`
- `SAIF.Presentation.Web.Controls.AJAX.Infragistics103\clsHelpTextCollection.vb`