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

# SAIF.Business.Claim.Person database tables

This page catalogs database tables accessed by this library.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [CL_AWARD_ELIGIBILITY](#cl-award-eligibility) | Oracle | [unqualified] | CDRU | Supports clsAwardEligibility, clsAwardEligibilityCollection data access in this library. | `clsAwardEligibility` |
| [CL_CLAIM_PERSON](#cl-claim-person) | Oracle | [unqualified] | U | Supports clsClaimPersonName, clsPersonTaxIDHistory data access in this library. | `clsClaimPersonName` |
| [CL_CLAIM_PERSON_NAME_HISTORY](#cl-claim-person-name-history) | Oracle | [unqualified] | CRU | Supports clsClaimPersonName, clsClaimPersonNameCollection data access in this library. | `clsClaimPersonName` |
| [CL_PERSON_TAX_ID_HISTORY](#cl-person-tax-id-history) | Oracle | [unqualified] | CRU | Supports clsPersonTaxIDHistory, clsPersonTaxIDHistoryCollection data access in this library. | `clsPersonTaxIDHistory` |
| [CL_WORKER_HEALTH_ISSUE](#cl-worker-health-issue) | Oracle | [unqualified] | CR | Supports clsWorkerHealthIssue, clsWorkerHealthIssueCollection data access in this library. | `clsWorkerHealthIssue` |
| [DUAL](#dual) | Oracle | [unqualified] | R | Supports clsClaimPersonAddress, clsClaimPersonName data access in this library. | `clsClaimPersonAddress` |

## CL_AWARD_ELIGIBILITY

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

### Operations referencing this table
- [Maintain award eligibility](operations/award-eligibility-management.md)

### SQL referencing this table
- [SQL-001: INSERT INTO CL_AWARD_ELIGIBILITY (PERSON_ID, AWARD_ELIG_EFF_DATE, AWAR](sql/sql-001-insert.md)
- [SQL-005: SELECT PERSON_ID as PersonID, AWARD_ELIG_EFF_DATE as AwardEligEffDate,](sql/sql-005-select.md)
- [SQL-015: UPDATE CL_AWARD_ELIGIBILITY SET AWARD_ELIG_EFF_DATE = TRUNC(:AwardElig](sql/sql-015-update.md)
- [SQL-020: Delete FROM CL_AWARD_ELIGIBILITY Where PERSON_ID = :PersonID and AWARD](sql/sql-020-delete.md)

---

## CL_CLAIM_PERSON

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

### Operations referencing this table
- [Manage person names](operations/claim-person-name-management.md)
- [Maintain tax ID history](operations/tax-id-history-management.md)

### Business rules referencing this table
- [BR-PER-002: Phonetic name generation is required for name maintenance](business-rules.md#br-per-002-phonetic-name-generation-is-required-for-name-maintenance)

### SQL referencing this table
- [SQL-016: Update CL_CLAIM_PERSON Set PRIMARY_LAST_NAME = :PrimaryLastName, PRIMA](sql/sql-016-update.md)
- [SQL-018: Update CL_CLAIM_PERSON Set PRIMARY_TAX_ID = :TaxID, UPDATE_DATE = SYSD](sql/sql-018-update.md)

---

## CL_CLAIM_PERSON_NAME_HISTORY

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

### Operations referencing this table
- [Manage person names](operations/claim-person-name-management.md)

### Business rules referencing this table
- [BR-PER-002: Phonetic name generation is required for name maintenance](business-rules.md#br-per-002-phonetic-name-generation-is-required-for-name-maintenance)

### SQL referencing this table
- [SQL-002: Insert into CL_CLAIM_PERSON_NAME_HISTORY ( FIRST_NAME, FIRST_NAME_UPPE](sql/sql-002-insert.md)
- [SQL-009: Select FIRST_NAME as FirstName, FIRST_NAME_UPPER_CASE as FirstNameUppe](sql/sql-009-select.md)
- [SQL-017: Update CL_CLAIM_PERSON_NAME_HISTORY Set PRIMARY_FLAG = :PrimaryFlag, U](sql/sql-017-update.md)

---

## CL_PERSON_TAX_ID_HISTORY

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

### Operations referencing this table
- [Maintain tax ID history](operations/tax-id-history-management.md)

### SQL referencing this table
- [SQL-003: Insert into CL_PERSON_TAX_ID_HISTORY ( PERSON_ID, PRIMARY_FLAG, PRIMAR](sql/sql-003-insert.md)
- [SQL-010: Select Count(*) From CL_PERSON_TAX_ID_HISTORY Where TAX_ID = :TaxID AN](sql/sql-010-select.md)
- [SQL-011: SELECT COUNT(*) FROM CL_PERSON_TAX_ID_HISTORY h, CL_CLAIM_PERSON p WHE](sql/sql-011-select.md)
- [SQL-012: Select Count(*) From CL_PERSON_TAX_ID_HISTORY Where TAX_ID = :TaxID AN](sql/sql-012-select.md)
- [SQL-013: Select PERSON_ID as PersonID, PRIMARY_FLAG as PrimaryFlag, PRIMARY_KEY](sql/sql-013-select.md)
- [SQL-019: Update CL_PERSON_TAX_ID_HISTORY Set PRIMARY_FLAG = :PrimaryFlag, UPDAT](sql/sql-019-update.md)

---

## CL_WORKER_HEALTH_ISSUE

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

### Operations referencing this table
- [Track worker health issues](operations/worker-health-issue-tracking.md)

### SQL referencing this table
- [SQL-004: Insert into CL_WORKER_HEALTH_ISSUE ( EXPOSURE_CODE, UPDATE_DATE, UPDAT](sql/sql-004-insert.md)
- [SQL-014: Select CL_WORKER_HEALTH_ISSUE.EXPOSURE_CODE as ExposureCode, CL_WORKER](sql/sql-014-select.md)

---

## DUAL

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

### Operations referencing this table
- [Manage person names](operations/claim-person-name-management.md)
- [Manage claim-person addresses](operations/claim-person-address-management.md)

### Business rules referencing this table
- [BR-PER-002: Phonetic name generation is required for name maintenance](business-rules.md#br-per-002-phonetic-name-generation-is-required-for-name-maintenance)

### SQL referencing this table
- [SQL-006: SELECT 1 FROM DUAL](sql/sql-006-select.md)
- [SQL-007: SELECT 1 FROM DUAL](sql/sql-007-select.md)
- [SQL-008: Select pk82028_phonetic_name.createPhoneticName(:LastName, :FirstName,](sql/sql-008-select.md)

---

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

```mermaid
erDiagram
    CL_CLAIM_PERSON ||--o{ CL_CLAIM_PERSON_NAME_HISTORY : "PERSON_ID"
    CL_CLAIM_PERSON ||--o{ CL_PERSON_TAX_ID_HISTORY : "PERSON_ID"
    CL_CLAIM_PERSON ||--o{ CL_AWARD_ELIGIBILITY : "PERSON_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)
- [Procedures](procedures/index.md)
- [API reference](api/index.md)

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

## Sources
- `Business\SAIF.Business.Claim.Person\clsAwardEligibility.vb`
- `Business\SAIF.Business.Claim.Person\clsAwardEligibilityCollection.vb`
- `Business\SAIF.Business.Claim.Person\clsClaimPersonAddress.vb`
- `Business\SAIF.Business.Claim.Person\clsClaimPersonName.vb`
- `Business\SAIF.Business.Claim.Person\clsClaimPersonNameCollection.vb`
- `Business\SAIF.Business.Claim.Person\clsPersonTaxIDHistory.vb`
- `Business\SAIF.Business.Claim.Person\clsPersonTaxIDHistoryCollection.vb`
- `Business\SAIF.Business.Claim.Person\clsWorkerHealthIssue.vb`
- `Business\SAIF.Business.Claim.Person\clsWorkerHealthIssueCollection.vb`