---
title: SAIF.Framework.Validation SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: Claims Systems Team
last_reviewed: 2026-08-14
library: SAIF.Framework.Validation
reference_type: package
---

# SAIF.Framework.Validation 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 | Insert a validation failure record for a claim | Inline | ValidationFailureAudit | `ValidationAuditRepository` |
| SQL-002 | Insert the header row for a rule set run | Inline | RuleSetExecution | `RuleSetExecutionRepository` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| SQL-004 | Retrieve active rule definitions for a jurisdiction | Inline | ValidationRuleDefinition, Jurisdiction | `RuleDefinitionRepository` |
| [SQL-007](SQL-007.md) | Retrieve pending premium audits for a processing window | Stored Proc | PremiumAuditQueue, Policy, AuditStatus | `PendingAuditRepository` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| SQL-009 | Update the validation status of a claim | Inline | ClaimValidationStatus | `ClaimValidationStatusRepository` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| SQL-011 | Delete cached rule definitions past their retention | Inline | RuleDefinitionCache | `RuleCacheRepository` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| SQL-012 | Fetch next generated identity for an audit row | `SCOPE_IDENTITY()` | ValidationFailureAudit | `ValidationAuditRepository` |

## Related documentation
- Index
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- Database tables
- API reference

## Sources
- src/SAIF.Framework.Validation/Data/ValidationAuditRepository.vb
- src/SAIF.Framework.Validation/Data/RuleSetExecutionRepository.vb
- src/SAIF.Framework.Validation/Data/RuleDefinitionRepository.vb
- src/SAIF.Framework.Validation/Data/ClaimValidationStatusRepository.vb
- src/SAIF.Framework.Validation/Data/RuleCacheRepository.vb
- src/SAIF.Framework.Validation/Data/PendingAuditRepository.vb