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

# SAIF.Business.UnitStat.Claim database tables

This page catalogs database tables accessed by this library.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [DUAL](#dual) | Oracle | [unqualified]** | C, R | Supports Criteria, clsLossSummary, clsThirdPartyPrediction data access in this library. | `Criteria` |
| [US_COVERAGE_COMBINATION](#us_coverage_combination) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria, clsCurrentLoss data access in this library. | `Criteria` |
| [US_LOSS_CATEGORY](#us_loss_category) | Oracle | [unqualified]** | C, D, U | Supports Criteria data access in this library. | `Criteria` |
| [US_LOSS_CATEGORY_OFFSET](#us_loss_category_offset) | Oracle | [unqualified]** | C, D, U | Supports Criteria data access in this library. | `Criteria` |
| [US_LOSS_SUMMARY](#us_loss_summary) | Oracle | [unqualified]** | C, D, U | Supports Criteria data access in this library. | `Criteria` |
| [us_policy_unit](#us_policy_unit) | Oracle | [unqualified]** | R | Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library. | `clsCurrentLoss` |
| [us_claim_unit](#us_claim_unit) | Oracle | [unqualified]** | R | Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library. | `clsCurrentLoss` |
| [cl_injury_claim](#cl_injury_claim) | Oracle | [unqualified]** | R | Supports clsCurrentLoss data access in this library. | `clsCurrentLoss` |
| [cl_injury_source_code](#cl_injury_source_code) | Oracle | [unqualified]** | R | Supports clsCurrentLoss data access in this library. | `clsCurrentLoss` |
| [cl_injury_nature_code](#cl_injury_nature_code) | Oracle | [unqualified]** | R | Supports clsCurrentLoss data access in this library. | `clsCurrentLoss` |
| [cl_body_part_code](#cl_body_part_code) | Oracle | [unqualified]** | R | Supports clsCurrentLoss data access in this library. | `clsCurrentLoss` |
| [us_unit_report](#us_unit_report) | Oracle | [unqualified]** | R | Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library. | `clsCurrentLoss` |
| [us_report_batch](#us_report_batch) | Oracle | [unqualified]** | R | Supports clsCurrentLoss data access in this library. | `clsCurrentLoss` |
| [us_reported_loss](#us_reported_loss) | Oracle | [unqualified]** | R | Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library. | `clsCurrentLoss` |
| [us_catastrophic_claim](#us_catastrophic_claim) | Oracle | [unqualified]** | R | Supports clsCurrentLoss data access in this library. | `clsCurrentLoss` |
| [us_catastrophe](#us_catastrophe) | Oracle | [unqualified]** | R | Supports clsCurrentLoss data access in this library. | `clsCurrentLoss` |
| [settlement_exists](#settlement_exists) | Oracle | [unqualified]** | R | Supports clsLossValuation, clsThirdPartyPrediction data access in this library. | `clsLossValuation` |
| [thrdparty_case](#thrdparty_case) | Oracle | [unqualified]** | R | Supports clsThirdPartyPrediction data access in this library. | `clsThirdPartyPrediction` |
| [thrdparty_prediction](#thrdparty_prediction) | Oracle | [unqualified]** | R | Supports clsThirdPartyPrediction data access in this library. | `clsThirdPartyPrediction` |

## DUAL

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

### Operations referencing this table
- [Coverage combination management](operations/coverage-combination-management.md)
- [Loss summary maintenance](operations/loss-summary-maintenance.md)

### Business rules referencing this table
- [BR-004: Coverage-combination identifiers come from an Oracle sequence](business-rules.md#br-004-coverage-combination-identifiers-come-from-an-oracle-sequence)

### SQL referencing this table
- [SQL-001: SELECT COVERAGE_COMBINATION_SEQ_NUM_NEXTVAL FROM DUAL](sql/sql-001-select.md)

---

## US_COVERAGE_COMBINATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports Criteria, clsCurrentLoss 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, clsCurrentLoss` |

### Operations referencing this table
- [Coverage combination management](operations/coverage-combination-management.md)

### Business rules referencing this table
- [BR-001: NCCI claim type derives from claim and coverage context](business-rules.md#br-001-ncci-claim-type-derives-from-claim-and-coverage-context)
- [BR-004: Coverage-combination identifiers come from an Oracle sequence](business-rules.md#br-004-coverage-combination-identifiers-come-from-an-oracle-sequence)

### SQL referencing this table
- [SQL-002: Insert into US_COVERAGE_COMBINATION ( COVERAGE_COMBINATION_SEQ_NUM, PA](sql/sql-002-insert.md)
- [SQL-017: Select US_COVERAGE_COMBINATION.COVERAGE_COMBINATION_SEQ_NUM as Coverag](sql/sql-017-select.md)
- [SQL-018: Update US_COVERAGE_COMBINATION Set COVERAGE_COMBINATION_SEQ_NUM = :Cov](sql/sql-018-update.md)
- [SQL-022: Delete US_COVERAGE_COMBINATION Where](sql/sql-022-delete.md)

---

## US_LOSS_CATEGORY

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

### Operations referencing this table
- [Loss category and offset maintenance](operations/loss-category-offset-maintenance.md)

### SQL referencing this table
- [SQL-004: Insert into US_LOSS_CATEGORY ( US_LOSS_CATEGORY_SEQ_NUM, US_LOSS_SUMMA](sql/sql-004-insert.md)
- [SQL-019: Update US_LOSS_CATEGORY Set US_LOSS_CATEGORY_SEQ_NUM = :LossCategorySe](sql/sql-019-update.md)
- [SQL-024: Delete US_LOSS_CATEGORY Where US_LOSS_CATEGORY.US_LOSS_CATEGORY_SEQ_NU](sql/sql-024-delete.md)

---

## US_LOSS_CATEGORY_OFFSET

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

### Operations referencing this table
- [Loss category and offset maintenance](operations/loss-category-offset-maintenance.md)

### SQL referencing this table
- [SQL-005: Insert into US_LOSS_CATEGORY_OFFSET ( US_LOSS_CAT_OFFSET_SEQ_NUM, US_L](sql/sql-005-insert.md)
- [SQL-020: Update US_LOSS_CATEGORY_OFFSET Set US_LOSS_CAT_OFFSET_SEQ_NUM = :LossC](sql/sql-020-update.md)
- [SQL-025: Delete US_LOSS_CATEGORY_OFFSET Where US_LOSS_CATEGORY_OFFSET.US_LOSS_C](sql/sql-025-delete.md)

---

## US_LOSS_SUMMARY

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

### Operations referencing this table
- [Loss summary maintenance](operations/loss-summary-maintenance.md)

### SQL referencing this table
- [SQL-006: Insert into US_LOSS_SUMMARY ( US_LOSS_SUMMARY_SEQ_NUM, CLAIM_ID, US_PO](sql/sql-006-insert.md)
- [SQL-021: Update US_LOSS_SUMMARY Set US_LOSS_SUMMARY_SEQ_NUM = :LossSummarySeqNu](sql/sql-021-update.md)
- [SQL-026: Delete US_LOSS_SUMMARY Where US_LOSS_SUMMARY.US_LOSS_SUMMARY_SEQ_NUM =](sql/sql-026-delete.md)

---

## us_policy_unit

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library. |
| **Access pattern** | Both |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | 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, settlement_exists, us_reported_loss, us_claim_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_unit_report |
| **Business objects** | `clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)
- [SQL-012: pk73304_loss_summary.get_final_denial_dates](sql/sql-012-pk73304_loss_summary-get_final_denial_dates.md)
- [SQL-014: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-014-pk73304_loss_summary-get_thirdparty_prediction.md)
- [SQL-015: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-015-pk73304_loss_summary-get_thirdparty_prediction.md)

---

## us_claim_unit

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library. |
| **Access pattern** | Both |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | us_policy_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, settlement_exists, us_reported_loss, us_policy_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_policy_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_policy_unit, us_unit_report |
| **Business objects** | `clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)
- [SQL-012: pk73304_loss_summary.get_final_denial_dates](sql/sql-012-pk73304_loss_summary-get_final_denial_dates.md)
- [SQL-014: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-014-pk73304_loss_summary-get_thirdparty_prediction.md)
- [SQL-015: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-015-pk73304_loss_summary-get_thirdparty_prediction.md)

---

## cl_injury_claim

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss data access in this library. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | us_policy_unit, us_claim_unit, 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 |
| **Business objects** | `clsCurrentLoss` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)

---

## cl_injury_source_code

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss data access in this library. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | us_policy_unit, us_claim_unit, cl_injury_claim, 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 |
| **Business objects** | `clsCurrentLoss` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)

---

## cl_injury_nature_code

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss data access in this library. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | us_policy_unit, us_claim_unit, cl_injury_claim, cl_injury_source_code, cl_body_part_code, us_unit_report, us_report_batch, us_reported_loss, us_coverage_combination, us_catastrophic_claim, us_catastrophe |
| **Business objects** | `clsCurrentLoss` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)

---

## cl_body_part_code

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss data access in this library. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | us_policy_unit, us_claim_unit, cl_injury_claim, cl_injury_source_code, cl_injury_nature_code, us_unit_report, us_report_batch, us_reported_loss, us_coverage_combination, us_catastrophic_claim, us_catastrophe |
| **Business objects** | `clsCurrentLoss` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)

---

## us_unit_report

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library. |
| **Access pattern** | Both |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | us_policy_unit, us_claim_unit, cl_injury_claim, cl_injury_source_code, cl_injury_nature_code, cl_body_part_code, us_report_batch, us_reported_loss, us_coverage_combination, us_catastrophic_claim, us_catastrophe, settlement_exists, us_reported_loss, us_claim_unit, us_policy_unit, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit |
| **Business objects** | `clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)
- [SQL-012: pk73304_loss_summary.get_final_denial_dates](sql/sql-012-pk73304_loss_summary-get_final_denial_dates.md)
- [SQL-014: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-014-pk73304_loss_summary-get_thirdparty_prediction.md)
- [SQL-015: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-015-pk73304_loss_summary-get_thirdparty_prediction.md)

---

## us_report_batch

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss data access in this library. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | 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_reported_loss, us_coverage_combination, us_catastrophic_claim, us_catastrophe |
| **Business objects** | `clsCurrentLoss` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)

---

## us_reported_loss

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library. |
| **Access pattern** | Both |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | 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_coverage_combination, us_catastrophic_claim, us_catastrophe, settlement_exists, us_claim_unit, us_policy_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_claim_unit, us_policy_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_claim_unit, us_policy_unit, us_unit_report |
| **Business objects** | `clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)
- [SQL-012: pk73304_loss_summary.get_final_denial_dates](sql/sql-012-pk73304_loss_summary-get_final_denial_dates.md)
- [SQL-014: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-014-pk73304_loss_summary-get_thirdparty_prediction.md)
- [SQL-015: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-015-pk73304_loss_summary-get_thirdparty_prediction.md)

---

## us_catastrophic_claim

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss data access in this library. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | 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_catastrophe |
| **Business objects** | `clsCurrentLoss` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)

---

## us_catastrophe

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsCurrentLoss data access in this library. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | 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 |
| **Business objects** | `clsCurrentLoss` |

### SQL referencing this table
- [SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a](sql/sql-007-select.md)

---

## settlement_exists

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsLossValuation, clsThirdPartyPrediction data access in this library. |
| **Access pattern** | Stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report |
| **Business objects** | `clsLossValuation, clsThirdPartyPrediction` |

### SQL referencing this table
- [SQL-012: pk73304_loss_summary.get_final_denial_dates](sql/sql-012-pk73304_loss_summary-get_final_denial_dates.md)
- [SQL-014: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-014-pk73304_loss_summary-get_thirdparty_prediction.md)
- [SQL-015: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-015-pk73304_loss_summary-get_thirdparty_prediction.md)

---

## thrdparty_case

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsThirdPartyPrediction data access in this library. |
| **Access pattern** | Stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | settlement_exists, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report, settlement_exists, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report |
| **Business objects** | `clsThirdPartyPrediction` |

### SQL referencing this table
- [SQL-014: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-014-pk73304_loss_summary-get_thirdparty_prediction.md)
- [SQL-015: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-015-pk73304_loss_summary-get_thirdparty_prediction.md)

---

## thrdparty_prediction

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Supports clsThirdPartyPrediction data access in this library. |
| **Access pattern** | Stored procedure |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents.* |
| **Sequence** | N/A |
| **Related tables** | settlement_exists, thrdparty_case, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report, settlement_exists, thrdparty_case, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report |
| **Business objects** | `clsThirdPartyPrediction` |

### SQL referencing this table
- [SQL-014: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-014-pk73304_loss_summary-get_thirdparty_prediction.md)
- [SQL-015: pk73304_loss_summary.get_thirdparty_prediction](sql/sql-015-pk73304_loss_summary-get_thirdparty_prediction.md)

---

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

```mermaid
erDiagram
    US_POLICY_UNIT ||--o{ US_CLAIM_UNIT : "policy unit"
    US_CLAIM_UNIT ||--o{ US_REPORTED_LOSS : "claim_id"
    US_LOSS_SUMMARY ||--o{ US_LOSS_CATEGORY : "summary seq"
    US_LOSS_CATEGORY ||--o{ US_LOSS_CATEGORY_OFFSET : "category seq"
```

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

> **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
- `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\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\clsThirdPartyPrediction.vb`