---
title: SAIF.Business.Claim.EAIP SQL catalog
summary: Index of SQL statements used by SAIF.Business.Claim.EAIP.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-28
library: SAIF.Business.Claim.EAIP
reference_type: package
---

# SAIF.Business.Claim.EAIP SQL catalog

This page indexes SQL statements and stored-procedure calls used by `SAIF.Business.Claim.EAIP`.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-008](SQL-008.md) | StoredProc create used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-009](SQL-009.md) | StoredProc create used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-010](SQL-010.md) | StoredProc create used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-011](SQL-011.md) | Inline create used by Criteria | Inline | EAIP_PERIOD_TIMECARD | `Criteria` |
| [SQL-012](SQL-012.md) | StoredProc create used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-013](SQL-013.md) | StoredProc create used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-014](SQL-014.md) | StoredProc create used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-015](SQL-015.md) | StoredProc create used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-016](SQL-016.md) | StoredProc create used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-017](SQL-017.md) | StoredProc create used by Criteria | StoredProc | N/A | `Criteria` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-018](SQL-018.md) | StoredProc read used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-019](SQL-019.md) | StoredProc read used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-020](SQL-020.md) | StoredProc read used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-021](SQL-021.md) | StoredProc read used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-022](SQL-022.md) | StoredProc read used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-023](SQL-023.md) | StoredProc read used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-024](SQL-024.md) | StoredProc read used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-025](SQL-025.md) | StoredProc read used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-026](SQL-026.md) | StoredProc read used by Criteria | StoredProc | N/A | `Criteria` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-027](SQL-027.md) | StoredProc update used by clsCreditCardPayment | StoredProc | N/A | `clsCreditCardPayment` |
| [SQL-028](SQL-028.md) | StoredProc update used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-029](SQL-029.md) | StoredProc update used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-030](SQL-030.md) | StoredProc update used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-031](SQL-031.md) | Inline update used by Criteria | Inline | EAIP_PERIOD_TIMECARD | `Criteria` |
| [SQL-032](SQL-032.md) | StoredProc update used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-033](SQL-033.md) | StoredProc update used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-034](SQL-034.md) | StoredProc update used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-035](SQL-035.md) | StoredProc update used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-036](SQL-036.md) | StoredProc update used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-037](SQL-037.md) | StoredProc update used by Criteria | StoredProc | N/A | `Criteria` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-038](SQL-038.md) | StoredProc delete used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-039](SQL-039.md) | StoredProc delete used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-040](SQL-040.md) | StoredProc delete used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-041](SQL-041.md) | Inline delete used by Criteria | Inline | EAIP_PERIOD_TIMECARD | `Criteria` |
| [SQL-042](SQL-042.md) | StoredProc delete used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-043](SQL-043.md) | StoredProc delete used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-044](SQL-044.md) | StoredProc delete used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-045](SQL-045.md) | StoredProc delete used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-046](SQL-046.md) | StoredProc delete used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-047](SQL-047.md) | StoredProc delete used by Criteria | StoredProc | N/A | `Criteria` |
| [SQL-048](SQL-048.md) | StoredProc delete used by CriteriaBase | StoredProc | N/A | `CriteriaBase` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001.md) | `select eaip_billing_seq.nextval from dual` sequence used by Criteria | `select eaip_billing_seq.nextval from dual` | N/A | `Criteria` |
| [SQL-002](SQL-002.md) | `select eaip_pay_period_seq.nextval from dual` sequence used by Criteria | `select eaip_pay_period_seq.nextval from dual` | N/A | `Criteria` |
| [SQL-003](SQL-003.md) | `select eaip_period_timecard_seq.nextval from dual` sequence used by Criteria | `select eaip_period_timecard_seq.nextval from dual` | N/A | `Criteria` |
| [SQL-004](SQL-004.md) | `select eaip_period_seq.nextval from dual` sequence used by Criteria | `select eaip_period_seq.nextval from dual` | N/A | `Criteria` |
| [SQL-005](SQL-005.md) | `select eaip_reimb_seq.nextval from dual` sequence used by Criteria | `select eaip_reimb_seq.nextval from dual` | N/A | `Criteria` |
| [SQL-006](SQL-006.md) | `select eaip_reimb_detail_seq.nextval from dual` sequence used by Criteria | `select eaip_reimb_detail_seq.nextval from dual` | N/A | `Criteria` |
| [SQL-007](SQL-007.md) | `select eaip_expense_seq.nextval from dual` sequence used by CriteriaBase | `select eaip_expense_seq.nextval from dual` | N/A | `CriteriaBase` |

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