---
title: SAIF.Business.UnitStat database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.UnitStat
reference_type: package
---

# SAIF.Business.UnitStat database tables

This page catalogs the Oracle tables and code tables accessed by this library.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [CALCULATION_TYPE_CODE](#calculation-type-code) | Oracle | [unqualified]** | R | Stores calculation-type code values loaded into the extended mapping layer. | CodeMappings.clsCalculationTypeMap |
| [CL_INJURY_CLAIM](#cl-injury-claim) | Oracle | [unqualified]** | R | Supplies the denial-final flag used by non-compensable checks. | clsClaimUnit.IsDeniedFinal |
| [US_AUDIT_CONDITION](#us-audit-condition) | Oracle | [unqualified]** | C/R/D | Stores current audit and edit conditions associated with policy units, exposures, and claims. | clsAuditCondition, clsAuditConditionCollection |
| [US_AUDIT_CONDITION_HISTORY](#us-audit-condition-history) | Oracle | [unqualified]** | C/R/U | Stores historical audit-condition observations keyed by policy unit, claim, and description. | clsAuditConditionHistory, clsAuditConditionHistoryCollection |
| [US_CLAIM_UNIT](#us-claim-unit) | Oracle | [unqualified]** | C/R/U/D | Stores the claim-to-policy-unit association and its reporting-state flags. | clsClaimUnit, clsClaimUnitCollection |
| [US_COST_TYPE_CODE](#us-cost-type-code) | Oracle | [unqualified]** | R | Stores cost-type code values loaded into the extended mapping layer. | CodeMappings.clsCostTypeMap |
| [US_OFFSET_TYPE_CODE](#us-offset-type-code) | Oracle | [unqualified]** | R | Stores offset-type code values loaded into the extended mapping layer. | CodeMappings.clsOffsetTypeMap |
| [US_POLICY_UNIT](#us-policy-unit) | Oracle | [unqualified]** | C/R/U/D | Stores the policy-level reporting unit and its valuation, activity, correction, and retention flags. | clsPolicyUnit, clsPolicyUnitCollection, clsClaimUnit, clsAuditConditionCollection |

## CALCULATION_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores calculation-type code values loaded into the extended mapping layer. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See SQL catalog for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram and SQL catalog. |
| **Business objects** | CodeMappings.clsCalculationTypeMap |

### Operations referencing this table
- [Code map loading](operations/code-map-loading.md)

### SQL referencing this table
- [SQL-017: CALCULATION_TYPE_CODE code-table load](sql/SQL-017-calculation-type-code-code-table-load.md)

---

## CL_INJURY_CLAIM

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supplies the denial-final flag used by non-compensable checks. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See SQL catalog for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram and SQL catalog. |
| **Business objects** | clsClaimUnit.IsDeniedFinal |

### Operations referencing this table
- [Denial and fraud eligibility](operations/denial-fraud-eligibility.md)

### Business rules referencing this table
- [BR-US-027: Denial-final checks and fully-fraudulent checks only apply to policy units effective on or after 2013-01-01](business-rules.md#br-us-027-denial-final-checks-and-fully-fraudulent-checks-only-apply-to-policy-units-effective-on-or-after-2013-01-01)

### SQL referencing this table
- [SQL-014: CL_INJURY_CLAIM denial-final lookup](sql/SQL-014-cl-injury-claim-denial-final-lookup.md)

---

## US_AUDIT_CONDITION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores current audit and edit conditions associated with policy units, exposures, and claims. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/R/D |
| **Key columns used** | See SQL catalog for exact column usage. |
| **Sequence** | US_AUDIT_CONDITION_SEQ |
| **Related tables** | See relationship diagram and SQL catalog. |
| **Business objects** | clsAuditCondition, clsAuditConditionCollection |

### Operations referencing this table
- [Audit condition maintenance](operations/audit-condition-maintenance.md)

### Business rules referencing this table
- [BR-US-004: Audit condition description must have non-zero length](business-rules.md#br-us-004-audit-condition-description-must-have-non-zero-length)
- [BR-US-024: A policy unit has errors when its audit condition collection contains conditions with non-null exposure summary seq num AND non-null claim ID](business-rules.md#br-us-024-a-policy-unit-has-errors-when-its-audit-condition-collection-contains-conditions-with-non-null-exposure-summary-seq-num-and-non-null-claim-id)

### SQL referencing this table
- [SQL-001: US_AUDIT_CONDITION insert](sql/SQL-001-us-audit-condition-insert.md)
- [SQL-005: US_AUDIT_CONDITION by sequence](sql/SQL-005-us-audit-condition-by-sequence.md)
- [SQL-006: US_AUDIT_CONDITION all rows](sql/SQL-006-us-audit-condition-all-rows.md)
- [SQL-007: US_AUDIT_CONDITION by policy period](sql/SQL-007-us-audit-condition-by-policy-period.md)
- [SQL-008: US_AUDIT_CONDITION by policy unit](sql/SQL-008-us-audit-condition-by-policy-unit.md)
- [SQL-009: US_AUDIT_CONDITION by update user](sql/SQL-009-us-audit-condition-by-update-user.md)
- [SQL-030: US_AUDIT_CONDITION delete by edit type](sql/SQL-030-us-audit-condition-delete-by-edit-type.md)
- [SQL-031: US_AUDIT_CONDITION delete by policy period](sql/SQL-031-us-audit-condition-delete-by-policy-period.md)
- [SQL-032: US_AUDIT_CONDITION delete by policy period and edit type](sql/SQL-032-us-audit-condition-delete-by-policy-period-and-edit-type.md)
- [SQL-033: US_AUDIT_CONDITION delete by policy unit and edit type](sql/SQL-033-us-audit-condition-delete-by-policy-unit-and-edit-type.md)

---

## US_AUDIT_CONDITION_HISTORY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores historical audit-condition observations keyed by policy unit, claim, and description. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/R/U |
| **Key columns used** | See SQL catalog for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram and SQL catalog. |
| **Business objects** | clsAuditConditionHistory, clsAuditConditionHistoryCollection |

### Operations referencing this table
- [Audit condition history tracking](operations/audit-condition-history-tracking.md)

### Business rules referencing this table
- [BR-US-005: Audit condition history description must have non-zero length](business-rules.md#br-us-005-audit-condition-history-description-must-have-non-zero-length)
- [BR-US-020: Database contention on update or delete is detected by checking RowsAffected <> 1](business-rules.md#br-us-020-database-contention-on-update-or-delete-is-detected-by-checking-rowsaffected-1)

### SQL referencing this table
- [SQL-002: US_AUDIT_CONDITION_HISTORY insert](sql/SQL-002-us-audit-condition-history-insert.md)
- [SQL-010: US_AUDIT_CONDITION_HISTORY by composite key](sql/SQL-010-us-audit-condition-history-by-composite-key.md)
- [SQL-011: US_AUDIT_CONDITION_HISTORY collection by composite key](sql/SQL-011-us-audit-condition-history-collection-by-composite-key.md)
- [SQL-026: US_AUDIT_CONDITION_HISTORY update last-update date](sql/SQL-026-us-audit-condition-history-update-last-update-date.md)
- [SQL-027: US_AUDIT_CONDITION_HISTORY collection update](sql/SQL-027-us-audit-condition-history-collection-update.md)

---

## US_CLAIM_UNIT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores the claim-to-policy-unit association and its reporting-state flags. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/R/U/D |
| **Key columns used** | See SQL catalog for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram and SQL catalog. |
| **Business objects** | clsClaimUnit, clsClaimUnitCollection |

### Operations referencing this table
- [Claim unit maintenance](operations/claim-unit-maintenance.md)
- [Denial and fraud eligibility](operations/denial-fraud-eligibility.md)

### Business rules referencing this table
- [BR-US-002: Claim unit policy unit sequence number must be greater than zero](business-rules.md#br-us-002-claim-unit-policy-unit-sequence-number-must-be-greater-than-zero)
- [BR-US-003: Claim unit claim ID must be greater than zero](business-rules.md#br-us-003-claim-unit-claim-id-must-be-greater-than-zero)
- [BR-US-018: ActiveUnitFlag for claim units defaults to 'Y'](business-rules.md#br-us-018-activeunitflag-for-claim-units-defaults-to-y)
- [BR-US-019: A claim unit active lookup filters to ACTIVE_UNIT_FLAG = 'Y'](business-rules.md#br-us-019-a-claim-unit-active-lookup-filters-to-activeunitflag-y)
- [BR-US-020: Database contention on update or delete is detected by checking RowsAffected <> 1](business-rules.md#br-us-020-database-contention-on-update-or-delete-is-detected-by-checking-rowsaffected-1)
- [BR-US-027: Denial-final checks and fully-fraudulent checks only apply to policy units effective on or after 2013-01-01](business-rules.md#br-us-027-denial-final-checks-and-fully-fraudulent-checks-only-apply-to-policy-units-effective-on-or-after-2013-01-01)

### SQL referencing this table
- [SQL-003: US_CLAIM_UNIT insert](sql/SQL-003-us-claim-unit-insert.md)
- [SQL-012: US_CLAIM_UNIT active row by claim](sql/SQL-012-us-claim-unit-active-row-by-claim.md)
- [SQL-013: US_CLAIM_UNIT row by claim and policy unit](sql/SQL-013-us-claim-unit-row-by-claim-and-policy-unit.md)
- [SQL-015: US_CLAIM_UNIT / US_POLICY_UNIT fraud flag eligibility lookup](sql/SQL-015-us-claim-unit-us-policy-unit-fraud-flag-eligibility-lookup.md)
- [SQL-016: US_CLAIM_UNIT collection by policy unit](sql/SQL-016-us-claim-unit-collection-by-policy-unit.md)
- [SQL-028: US_CLAIM_UNIT update](sql/SQL-028-us-claim-unit-update.md)
- [SQL-034: US_CLAIM_UNIT delete](sql/SQL-034-us-claim-unit-delete.md)

---

## US_COST_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores cost-type code values loaded into the extended mapping layer. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See SQL catalog for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram and SQL catalog. |
| **Business objects** | CodeMappings.clsCostTypeMap |

### Operations referencing this table
- [Code map loading](operations/code-map-loading.md)

### SQL referencing this table
- [SQL-018: US_COST_TYPE_CODE code-table load](sql/SQL-018-us-cost-type-code-code-table-load.md)

---

## US_OFFSET_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores offset-type code values loaded into the extended mapping layer. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See SQL catalog for exact column usage. |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram and SQL catalog. |
| **Business objects** | CodeMappings.clsOffsetTypeMap |

### Operations referencing this table
- [Code map loading](operations/code-map-loading.md)

### SQL referencing this table
- [SQL-019: US_OFFSET_TYPE_CODE code-table load](sql/SQL-019-us-offset-type-code-code-table-load.md)

---

## US_POLICY_UNIT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Stores the policy-level reporting unit and its valuation, activity, correction, and retention flags. |
| **Access pattern** | direct SQL |
| **CRUD operations** | C/R/U/D |
| **Key columns used** | See SQL catalog for exact column usage. |
| **Sequence** | US_POLICY_UNIT_SEQ |
| **Related tables** | See relationship diagram and SQL catalog. |
| **Business objects** | clsPolicyUnit, clsPolicyUnitCollection, clsClaimUnit, clsAuditConditionCollection |

### Operations referencing this table
- [Policy unit CRUD](operations/policy-unit-crud.md)
- [Denial and fraud eligibility](operations/denial-fraud-eligibility.md)
- [Audit condition maintenance](operations/audit-condition-maintenance.md)

### Business rules referencing this table
- [BR-US-001: Policy unit sequence number must be greater than zero](business-rules.md#br-us-001-policy-unit-sequence-number-must-be-greater-than-zero)
- [BR-US-006: A policy unit retrieved by natural key must be active (ACTIVE_UNIT_FLAG = 'Y')](business-rules.md#br-us-006-a-policy-unit-retrieved-by-natural-key-must-be-active-activeunitflag-y)
- [BR-US-007: A policy unit retrieved by injury date must be active](business-rules.md#br-us-007-a-policy-unit-retrieved-by-injury-date-must-be-active)
- [BR-US-012: Activating a policy unit that has been previously reported must also set correction flags](business-rules.md#br-us-012-activating-a-policy-unit-that-has-been-previously-reported-must-also-set-correction-flags)
- [BR-US-013: Non-compensable rules apply only to policy units effective on or after 2013-01-01](business-rules.md#br-us-013-non-compensable-rules-apply-only-to-policy-units-effective-on-or-after-2013-01-01)
- [BR-US-014: Active unit flag defaults to 'Y' when not set](business-rules.md#br-us-014-active-unit-flag-defaults-to-y-when-not-set)
- [BR-US-015: LossEditFlag and ExposureEditFlag default to 'Y' when not set](business-rules.md#br-us-015-losseditflag-and-exposureeditflag-default-to-y-when-not-set)
- [BR-US-016: Correction flags (UnitCorrectionFlag, ExposureCorrectionFlag, LossCorrectionFlag) default to 'N'](business-rules.md#br-us-016-correction-flags-unitcorrectionflag-exposurecorrectionflag-losscorrectionflag-default-to-n)
- [BR-US-017: HistoricalFlag defaults to 'N' when not set](business-rules.md#br-us-017-historicalflag-defaults-to-n-when-not-set)
- [BR-US-020: Database contention on update or delete is detected by checking RowsAffected <> 1](business-rules.md#br-us-020-database-contention-on-update-or-delete-is-detected-by-checking-rowsaffected-1)

### SQL referencing this table
- [SQL-004: US_POLICY_UNIT insert](sql/SQL-004-us-policy-unit-insert.md)
- [SQL-007: US_AUDIT_CONDITION by policy period](sql/SQL-007-us-audit-condition-by-policy-period.md)
- [SQL-015: US_CLAIM_UNIT / US_POLICY_UNIT fraud flag eligibility lookup](sql/SQL-015-us-claim-unit-us-policy-unit-fraud-flag-eligibility-lookup.md)
- [SQL-020: US_POLICY_UNIT active row by retrieve date](sql/SQL-020-us-policy-unit-active-row-by-retrieve-date.md)
- [SQL-021: US_POLICY_UNIT active row by natural key](sql/SQL-021-us-policy-unit-active-row-by-natural-key.md)
- [SQL-022: US_POLICY_UNIT row by sequence](sql/SQL-022-us-policy-unit-row-by-sequence.md)
- [SQL-023: US_POLICY_UNIT rows requiring loss edits](sql/SQL-023-us-policy-unit-rows-requiring-loss-edits.md)
- [SQL-024: US_POLICY_UNIT collection by policy](sql/SQL-024-us-policy-unit-collection-by-policy.md)
- [SQL-025: US_POLICY_UNIT collection by policy period](sql/SQL-025-us-policy-unit-collection-by-policy-period.md)
- [SQL-029: US_POLICY_UNIT update](sql/SQL-029-us-policy-unit-update.md)
- [SQL-031: US_AUDIT_CONDITION delete by policy period](sql/SQL-031-us-audit-condition-delete-by-policy-period.md)
- [SQL-032: US_AUDIT_CONDITION delete by policy period and edit type](sql/SQL-032-us-audit-condition-delete-by-policy-period-and-edit-type.md)
- [SQL-035: US_POLICY_UNIT delete](sql/SQL-035-us-policy-unit-delete.md)

---

## Table relationship diagram

The following diagram shows the discoverable relationships across unit-stat tables and claim lookups.

```mermaid
erDiagram
    US_POLICY_UNIT ||--o{ US_CLAIM_UNIT : "US_POLICY_UNIT_SEQ_NUM"
    US_POLICY_UNIT ||--o{ US_AUDIT_CONDITION : "US_POLICY_UNIT_SEQ_NUM"
    US_POLICY_UNIT ||--o{ US_AUDIT_CONDITION_HISTORY : "US_POLICY_UNIT_SEQ_NUM"
    US_CLAIM_UNIT }o--|| CL_INJURY_CLAIM : "CLAIM_ID"
    US_CLAIM_UNIT ||--o{ US_AUDIT_CONDITION : "CLAIM_ID"
    US_CLAIM_UNIT ||--o{ US_AUDIT_CONDITION_HISTORY : "CLAIM_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)
- [Configuration](configuration.md)

> **Note:** Statements marked with `**` could not be confirmed; treat as unknown until verified.

## 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`