---
title: SAIF.Business.UnitStat SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.UnitStat
reference_type: package
---

# SAIF.Business.UnitStat SQL catalog

This page indexes all SQL statements used by this library, grouped by CRUD type.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-us-audit-condition-insert.md) | US_AUDIT_CONDITION insert | Inline | [US_AUDIT_CONDITION](../database-tables.md#us-audit-condition) | `clsAuditCondition` |
| [SQL-002](SQL-002-us-audit-condition-history-insert.md) | US_AUDIT_CONDITION_HISTORY insert | Inline | [US_AUDIT_CONDITION_HISTORY](../database-tables.md#us-audit-condition-history) | `clsAuditConditionHistory` |
| [SQL-003](SQL-003-us-claim-unit-insert.md) | US_CLAIM_UNIT insert | Inline | [US_CLAIM_UNIT](../database-tables.md#us-claim-unit) | `clsClaimUnit` |
| [SQL-004](SQL-004-us-policy-unit-insert.md) | US_POLICY_UNIT insert | Inline | [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsPolicyUnit` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-005](SQL-005-us-audit-condition-by-sequence.md) | US_AUDIT_CONDITION by sequence | Inline | [US_AUDIT_CONDITION](../database-tables.md#us-audit-condition) | `clsAuditCondition` |
| [SQL-006](SQL-006-us-audit-condition-all-rows.md) | US_AUDIT_CONDITION all rows | Inline | [US_AUDIT_CONDITION](../database-tables.md#us-audit-condition) | `clsAuditConditionCollection` |
| [SQL-007](SQL-007-us-audit-condition-by-policy-period.md) | US_AUDIT_CONDITION by policy period | Inline | [US_AUDIT_CONDITION](../database-tables.md#us-audit-condition), [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsAuditConditionCollection` |
| [SQL-008](SQL-008-us-audit-condition-by-policy-unit.md) | US_AUDIT_CONDITION by policy unit | Inline | [US_AUDIT_CONDITION](../database-tables.md#us-audit-condition) | `clsAuditConditionCollection` |
| [SQL-009](SQL-009-us-audit-condition-by-update-user.md) | US_AUDIT_CONDITION by update user | Inline | [US_AUDIT_CONDITION](../database-tables.md#us-audit-condition) | `clsAuditConditionCollection` |
| [SQL-010](SQL-010-us-audit-condition-history-by-composite-key.md) | US_AUDIT_CONDITION_HISTORY by composite key | Inline | [US_AUDIT_CONDITION_HISTORY](../database-tables.md#us-audit-condition-history) | `clsAuditConditionHistory` |
| [SQL-011](SQL-011-us-audit-condition-history-collection-by-composite-key.md) | US_AUDIT_CONDITION_HISTORY collection by composite key | Inline | [US_AUDIT_CONDITION_HISTORY](../database-tables.md#us-audit-condition-history) | `clsAuditConditionHistoryCollection` |
| [SQL-012](SQL-012-us-claim-unit-active-row-by-claim.md) | US_CLAIM_UNIT active row by claim | Inline | [US_CLAIM_UNIT](../database-tables.md#us-claim-unit) | `clsClaimUnit` |
| [SQL-013](SQL-013-us-claim-unit-row-by-claim-and-policy-unit.md) | US_CLAIM_UNIT row by claim and policy unit | Inline | [US_CLAIM_UNIT](../database-tables.md#us-claim-unit) | `clsClaimUnit` |
| [SQL-014](SQL-014-cl-injury-claim-denial-final-lookup.md) | CL_INJURY_CLAIM denial-final lookup | Inline | [CL_INJURY_CLAIM](../database-tables.md#cl-injury-claim) | `clsClaimUnit.IsDeniedFinal` |
| [SQL-015](SQL-015-us-claim-unit-us-policy-unit-fraud-flag-eligibility-lookup.md) | US_CLAIM_UNIT / US_POLICY_UNIT fraud flag eligibility lookup | Inline | [US_CLAIM_UNIT](../database-tables.md#us-claim-unit), [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsClaimUnit.IsFullyFraudulent` |
| [SQL-016](SQL-016-us-claim-unit-collection-by-policy-unit.md) | US_CLAIM_UNIT collection by policy unit | Inline | [US_CLAIM_UNIT](../database-tables.md#us-claim-unit) | `clsClaimUnitCollection` |
| [SQL-017](SQL-017-calculation-type-code-code-table-load.md) | CALCULATION_TYPE_CODE code-table load | Inline | [CALCULATION_TYPE_CODE](../database-tables.md#calculation-type-code) | `CodeMappings.clsCalculationTypeMap` |
| [SQL-018](SQL-018-us-cost-type-code-code-table-load.md) | US_COST_TYPE_CODE code-table load | Inline | [US_COST_TYPE_CODE](../database-tables.md#us-cost-type-code) | `CodeMappings.clsCostTypeMap` |
| [SQL-019](SQL-019-us-offset-type-code-code-table-load.md) | US_OFFSET_TYPE_CODE code-table load | Inline | [US_OFFSET_TYPE_CODE](../database-tables.md#us-offset-type-code) | `CodeMappings.clsOffsetTypeMap` |
| [SQL-020](SQL-020-us-policy-unit-active-row-by-retrieve-date.md) | US_POLICY_UNIT active row by retrieve date | Inline | [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsPolicyUnit` |
| [SQL-021](SQL-021-us-policy-unit-active-row-by-natural-key.md) | US_POLICY_UNIT active row by natural key | Inline | [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsPolicyUnit` |
| [SQL-022](SQL-022-us-policy-unit-row-by-sequence.md) | US_POLICY_UNIT row by sequence | Inline | [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsPolicyUnit` |
| [SQL-023](SQL-023-us-policy-unit-rows-requiring-loss-edits.md) | US_POLICY_UNIT rows requiring loss edits | Inline | [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsPolicyUnitCollection` |
| [SQL-024](SQL-024-us-policy-unit-collection-by-policy.md) | US_POLICY_UNIT collection by policy | Inline | [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsPolicyUnitCollection` |
| [SQL-025](SQL-025-us-policy-unit-collection-by-policy-period.md) | US_POLICY_UNIT collection by policy period | Inline | [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsPolicyUnitCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-026](SQL-026-us-audit-condition-history-update-last-update-date.md) | US_AUDIT_CONDITION_HISTORY update last-update date | Inline | [US_AUDIT_CONDITION_HISTORY](../database-tables.md#us-audit-condition-history) | `clsAuditConditionHistory` |
| [SQL-027](SQL-027-us-audit-condition-history-collection-update.md) | US_AUDIT_CONDITION_HISTORY collection update | Inline | [US_AUDIT_CONDITION_HISTORY](../database-tables.md#us-audit-condition-history) | `clsAuditConditionHistoryCollection` |
| [SQL-028](SQL-028-us-claim-unit-update.md) | US_CLAIM_UNIT update | Inline | [US_CLAIM_UNIT](../database-tables.md#us-claim-unit) | `clsClaimUnit` |
| [SQL-029](SQL-029-us-policy-unit-update.md) | US_POLICY_UNIT update | Inline | [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsPolicyUnit` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-030](SQL-030-us-audit-condition-delete-by-edit-type.md) | US_AUDIT_CONDITION delete by edit type | Inline | [US_AUDIT_CONDITION](../database-tables.md#us-audit-condition) | `clsAuditConditionCollection` |
| [SQL-031](SQL-031-us-audit-condition-delete-by-policy-period.md) | US_AUDIT_CONDITION delete by policy period | Inline | [US_AUDIT_CONDITION](../database-tables.md#us-audit-condition), [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsAuditConditionCollection` |
| [SQL-032](SQL-032-us-audit-condition-delete-by-policy-period-and-edit-type.md) | US_AUDIT_CONDITION delete by policy period and edit type | Inline | [US_AUDIT_CONDITION](../database-tables.md#us-audit-condition), [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsAuditConditionCollection` |
| [SQL-033](SQL-033-us-audit-condition-delete-by-policy-unit-and-edit-type.md) | US_AUDIT_CONDITION delete by policy unit and edit type | Inline | [US_AUDIT_CONDITION](../database-tables.md#us-audit-condition) | `clsAuditConditionCollection` |
| [SQL-034](SQL-034-us-claim-unit-delete.md) | US_CLAIM_UNIT delete | Inline | [US_CLAIM_UNIT](../database-tables.md#us-claim-unit) | `clsClaimUnit` |
| [SQL-035](SQL-035-us-policy-unit-delete.md) | US_POLICY_UNIT delete | Inline | [US_POLICY_UNIT](../database-tables.md#us-policy-unit) | `clsPolicyUnit` |

## 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)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)
- [Configuration](../configuration.md)

## Sources

- `Business\SAIF.Business.UnitStat\App.config`
- `Business\SAIF.Business.UnitStat\clsAuditCondition.vb`
- `Business\SAIF.Business.UnitStat\clsAuditConditionCollection.vb`
- `Business\SAIF.Business.UnitStat\clsAuditConditionHistory.vb`
- `Business\SAIF.Business.UnitStat\clsAuditConditionHistoryCollection.vb`
- `Business\SAIF.Business.UnitStat\clsClaimUnit.vb`
- `Business\SAIF.Business.UnitStat\clsClaimUnitCollection.vb`
- `Business\SAIF.Business.UnitStat\clsPolicyUnit.vb`
- `Business\SAIF.Business.UnitStat\clsPolicyUnitCollection.vb`
- `Business\SAIF.Business.UnitStat\mdlCodeMaps.vb`