---
title: SAIF.Business.Claim.SupportOrder database tables
summary: Database tables used by the SAIF.Business.Claim.SupportOrder library with relationships and usage context.
status: draft
owner: SAIF
last_reviewed: 2026-07-28
library: SAIF.Business.Claim.SupportOrder
reference_type: package
---

# SAIF.Business.Claim.SupportOrder database tables

This page catalogs database tables accessed by this library.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [CL_CLAIM_SUPPORT_ORDER](#cl-claim-support-order) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` |
| [CL_CLAIM_SUPPORT_ORDER_CONN](#cl-claim-support-order-conn) | Oracle | [unqualified]** | C, D, R | Supports Criteria data access in this library. | `Criteria` |

## CL_CLAIM_SUPPORT_ORDER

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports Criteria data access in this library. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | C, D, R, U |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | N/A |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Support order retrieval and maintenance](operations/support-order-retrieval-and-maintenance.md)

### Business rules referencing this table
- [BR-001: Support-order updates require a current row version](business-rules.md#br-001-support-order-updates-require-a-current-row-version)
- [BR-002: Support-order inserts and updates must affect one row](business-rules.md#br-002-support-order-inserts-and-updates-must-affect-one-row)

### SQL referencing this table
- [SQL-001: Insert into CL_CLAIM_SUPPORT_ORDER ( ALL_CLAIM_FLAG, ARREARAGE_FLAG, D](sql/sql-001-insert.md)
- [SQL-003: Select CL_CLAIM_SUPPORT_ORDER.ALL_CLAIM_FLAG as AllClaimFlag, CL_CLAIM](sql/sql-003-select.md)
- [SQL-004: Select CL_CLAIM_SUPPORT_ORDER.ALL_CLAIM_FLAG as AllClaimFlag, CL_CLAIM](sql/sql-004-select.md)
- [SQL-006: Update CL_CLAIM_SUPPORT_ORDER Set ALL_CLAIM_FLAG = :AllClaimFlag, ARRE](sql/sql-006-update.md)
- [SQL-007: Delete CL_CLAIM_SUPPORT_ORDER Where CL_CLAIM_SUPPORT_ORDER.WORKER_ID =](sql/sql-007-delete.md)

---

## CL_CLAIM_SUPPORT_ORDER_CONN

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports Criteria data access in this library. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | C, D, R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | N/A |
| **Business objects** | `Criteria` |

### Operations referencing this table
- [Support order connection management](operations/support-order-connection-management.md)

### Business rules referencing this table
- [BR-003: Connection deletes must affect one row](business-rules.md#br-003-connection-deletes-must-affect-one-row)
- [BR-004: Connection inserts must affect one row](business-rules.md#br-004-connection-inserts-must-affect-one-row)

### SQL referencing this table
- [SQL-002: Insert into CL_CLAIM_SUPPORT_ORDER_CONN ( CLAIM_ID, SUPPORT_ORDER_ID, ](sql/sql-002-insert.md)
- [SQL-005: Select CL_CLAIM_SUPPORT_ORDER_CONN.CLAIM_ID as ClaimID, CL_CLAIM_SUPPO](sql/sql-005-select.md)
- [SQL-008: Delete CL_CLAIM_SUPPORT_ORDER_CONN Where CL_CLAIM_SUPPORT_ORDER_CONN.C](sql/sql-008-delete.md)

---

## Table relationship diagram
The following diagram shows relationships between tables used by this library.

```mermaid
erDiagram
    CL_CLAIM_SUPPORT_ORDER ||--o{ CL_CLAIM_SUPPORT_ORDER_CONN : "SUPPORT_ORDER_ID"
```

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

> **Note:** Statements marked with `*` were inferred from code structure or contextual evidence.

## Sources
- `Business\SAIF.Business.Claim.SupportOrder\clsClaimSupportOrder.vb`
- `Business\SAIF.Business.Claim.SupportOrder\clsClaimSupportOrderCollection.vb`
- `Business\SAIF.Business.Claim.SupportOrder\clsClaimSupportOrderConnection.vb`
- `Business\SAIF.Business.Claim.SupportOrder\clsClaimSupportOrderConnectionCollection.vb`