Skip to content

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 Oracle* [unqualified]** R Stores the master help-text record (application code, reference key, description) for a screen field or entity clsHelpText
APPLICATION_HELP_DETAIL 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

SQL referencing this table

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

SQL referencing this table

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{)**.

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
    }

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