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

# SAIF.Business.UnitStat.Claim SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-002](sql-002-insert.md) | Inline create used by Criteria | Inline | US_COVERAGE_COMBINATION | ``Criteria`` |
| [SQL-003](sql-003-insert.md) | Inline create used by Criteria | Inline | us_coverage_combination | ``Criteria`` |
| [SQL-004](sql-004-insert.md) | Inline create used by Criteria | Inline | US_LOSS_CATEGORY | ``Criteria`` |
| [SQL-005](sql-005-insert.md) | Inline create used by Criteria | Inline | US_LOSS_CATEGORY_OFFSET | ``Criteria`` |
| [SQL-006](sql-006-insert.md) | Inline create used by Criteria | Inline | US_LOSS_SUMMARY | ``Criteria`` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-007](sql-007-select.md) | Inline read used by clsCurrentLoss | Inline | us_policy_unit, us_claim_unit, cl_injury_claim, cl_injury_source_code, cl_injury_nature_code, cl_body_part_code, us_unit_report, us_report_batch, us_reported_loss, us_coverage_combination, us_catastrophic_claim, us_catastrophe | ``clsCurrentLoss`` |
| [SQL-008](sql-008-pk73304_loss_summary-get_denied_final_flag.md) | pk73304_loss_summary.get_denied_final_flag | StoredProc | — | ``clsDeniedFinal`` |
| [SQL-009](sql-009-pk73304_loss_summary-get_final_denial_date.md) | pk73304_loss_summary.get_final_denial_date | StoredProc | — | ``clsFinalDenial`` |
| [SQL-010](sql-010-pk73304_loss_summary-get_fraud_recovery_date.md) | pk73304_loss_summary.get_fraud_recovery_date | StoredProc | — | ``clsFraudRecovery`` |
| [SQL-011](sql-011-select.md) | Inline read used by clsLossSummary | Inline | dual | ``clsLossSummary`` |
| [SQL-012](sql-012-pk73304_loss_summary-get_final_denial_dates.md) | pk73304_loss_summary.get_final_denial_dates | StoredProc | settlement_exists, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report | ``clsLossValuation`` |
| [SQL-013](sql-013-pk73304_loss_summary-get_refund_dates.md) | pk73304_loss_summary.get_refund_dates | StoredProc | — | ``clsRefund`` |
| [SQL-014](sql-014-pk73304_loss_summary-get_thirdparty_prediction.md) | pk73304_loss_summary.get_thirdparty_prediction | StoredProc | settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report | ``clsThirdPartyPrediction`` |
| [SQL-015](sql-015-pk73304_loss_summary-get_thirdparty_prediction.md) | pk73304_loss_summary.get_thirdparty_prediction | StoredProc | settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report | ``clsThirdPartyPrediction`` |
| [SQL-016](sql-016-select.md) | Inline read used by clsThirdPartyPrediction | Inline | dual | ``clsThirdPartyPrediction`` |
| [SQL-017](sql-017-select.md) | Inline read used by Criteria | Inline | US_COVERAGE_COMBINATION | ``Criteria`` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-018](sql-018-update.md) | Inline update used by Criteria | Inline | US_COVERAGE_COMBINATION | ``Criteria`` |
| [SQL-019](sql-019-update.md) | Inline update used by Criteria | Inline | US_LOSS_CATEGORY | ``Criteria`` |
| [SQL-020](sql-020-update.md) | Inline update used by Criteria | Inline | US_LOSS_CATEGORY_OFFSET | ``Criteria`` |
| [SQL-021](sql-021-update.md) | Inline update used by Criteria | Inline | US_LOSS_SUMMARY | ``Criteria`` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-022](sql-022-delete.md) | Inline delete used by Criteria | Inline | US_COVERAGE_COMBINATION | ``Criteria`` |
| [SQL-023](sql-023-delete.md) | Inline delete used by Criteria | Inline | us_coverage_combination | ``Criteria`` |
| [SQL-024](sql-024-delete.md) | Inline delete used by Criteria | Inline | US_LOSS_CATEGORY | ``Criteria`` |
| [SQL-025](sql-025-delete.md) | Inline delete used by Criteria | Inline | US_LOSS_CATEGORY_OFFSET | ``Criteria`` |
| [SQL-026](sql-026-delete.md) | Inline delete used by Criteria | Inline | US_LOSS_SUMMARY | ``Criteria`` |

## Sequence operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](sql-001-select.md) | Inline sequence used by Criteria | Inline | DUAL | ``Criteria`` |

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

## Sources
- `Business\SAIF.Business.UnitStat.Claim\Coverage Combination\clsCoverageCombination.vb`
- `Business\SAIF.Business.UnitStat.Claim\Coverage Combination\clsCoverageCombinationCollection.vb`
- `Business\SAIF.Business.UnitStat.Claim\Current Loss\clsCurrentLoss.vb`
- `Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsDeniedFinal.vb`
- `Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsFinalDenial.vb`
- `Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsFraudRecovery.vb`
- `Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsLossCategory.vb`
- `Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsLossCategoryOffset.vb`
- `Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsLossSummary.vb`
- `Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsLossValuation.vb`
- `Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsRefund.vb`
- `Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsThirdPartyPrediction.vb`