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	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
• Architecture
• Dependencies
• Operations and processes
• Business rules
• 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