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

# SAIF.Business.Claim.Person 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-001](sql-001-insert.md) | Inline create used by clsAwardEligibility | Inline | CL_AWARD_ELIGIBILITY | `clsAwardEligibility` |
| [SQL-002](sql-002-insert.md) | Inline create used by clsClaimPersonName | Inline | CL_CLAIM_PERSON_NAME_HISTORY | `clsClaimPersonName` |
| [SQL-003](sql-003-insert.md) | Inline create used by clsPersonTaxIDHistory | Inline | CL_PERSON_TAX_ID_HISTORY | `clsPersonTaxIDHistory` |
| [SQL-004](sql-004-insert.md) | Inline create used by clsWorkerHealthIssue | Inline | CL_WORKER_HEALTH_ISSUE | `clsWorkerHealthIssue` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-005](sql-005-select.md) | Inline read used by clsAwardEligibilityCollection | Inline | CL_AWARD_ELIGIBILITY | `clsAwardEligibilityCollection` |
| [SQL-006](sql-006-select.md) | Inline read used by clsClaimPersonAddress | Inline | DUAL | `clsClaimPersonAddress` |
| [SQL-007](sql-007-select.md) | Inline read used by clsClaimPersonAddress | Inline | DUAL | `clsClaimPersonAddress` |
| [SQL-008](sql-008-select.md) | Inline read used by clsClaimPersonName | Inline | DUAL | `clsClaimPersonName` |
| [SQL-009](sql-009-select.md) | Inline read used by clsClaimPersonNameCollection | Inline | CL_CLAIM_PERSON_NAME_HISTORY | `clsClaimPersonNameCollection` |
| [SQL-010](sql-010-select.md) | Inline read used by clsPersonTaxIDHistory | Inline | CL_PERSON_TAX_ID_HISTORY | `clsPersonTaxIDHistory` |
| [SQL-011](sql-011-select.md) | Inline read used by clsPersonTaxIDHistory | Inline | CL_PERSON_TAX_ID_HISTORY | `clsPersonTaxIDHistory` |
| [SQL-012](sql-012-select.md) | Inline read used by clsPersonTaxIDHistory | Inline | CL_PERSON_TAX_ID_HISTORY | `clsPersonTaxIDHistory` |
| [SQL-013](sql-013-select.md) | Inline read used by clsPersonTaxIDHistoryCollection | Inline | CL_PERSON_TAX_ID_HISTORY | `clsPersonTaxIDHistoryCollection` |
| [SQL-014](sql-014-select.md) | Inline read used by clsWorkerHealthIssueCollection | Inline | CL_WORKER_HEALTH_ISSUE | `clsWorkerHealthIssueCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-015](sql-015-update.md) | Inline update used by clsAwardEligibility | Inline | CL_AWARD_ELIGIBILITY | `clsAwardEligibility` |
| [SQL-016](sql-016-update.md) | Inline update used by clsClaimPersonName | Inline | CL_CLAIM_PERSON | `clsClaimPersonName` |
| [SQL-017](sql-017-update.md) | Inline update used by clsClaimPersonName | Inline | CL_CLAIM_PERSON_NAME_HISTORY | `clsClaimPersonName` |
| [SQL-018](sql-018-update.md) | Inline update used by clsPersonTaxIDHistory | Inline | CL_CLAIM_PERSON | `clsPersonTaxIDHistory` |
| [SQL-019](sql-019-update.md) | Inline update used by clsPersonTaxIDHistory | Inline | CL_PERSON_TAX_ID_HISTORY | `clsPersonTaxIDHistory` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-020](sql-020-delete.md) | Inline delete used by clsAwardEligibility | Inline | CL_AWARD_ELIGIBILITY | `clsAwardEligibility` |
| [SQL-021](sql-021-delete.md) | Inline delete used by clsClaimPersonName | Inline | — | `clsClaimPersonName` |
| [SQL-022](sql-022-delete.md) | Inline delete used by clsPersonTaxIDHistory | Inline | — | `clsPersonTaxIDHistory` |
| [SQL-023](sql-023-delete.md) | Inline delete used by clsWorkerHealthIssue | Inline | — | `clsWorkerHealthIssue` |

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