Data model¶

This application interacts with 6 SQL Server tables in the dbo schema across 2 libraries.

Policy audit domain¶

Table	Owner library	Owner class	CRUD	SQL docs	Notes
`dbo.PolicyAudit`	SAIF.PremiumAudit.Batch	`AuditProcessor`	R, U	SQL index	Read through `dbo.usp_GetPendingAudits`; `Status`, `PostedDate`, and `PostedBy` updated inside the per-audit transaction.
`dbo.PolicyAuditDetail`	SAIF.PremiumAudit.Batch	`AuditProcessor`	R	SQL index	Audited payroll by class code for each audit. Read only; corrections are made by the underwriting application.
`dbo.PolicyAuditReject`	SAIF.PremiumAudit.Batch	`AuditProcessor`	C	SQL index	One row per rejected audit recording the failing business rule id; mirrors the File2 report.

Table	Owner library	Owner class	CRUD	SQL docs	Notes
`dbo.PayrollClassCode`	SAIF.PremiumAudit.Batch	`AuditProcessor`	R	SQL index	Rate table loaded into memory during PreProcess and filtered by policy effective date at lookup time.
`dbo.ClassCodeValidation`	SAIF.Framework.Validation	`ClassCodeValidator`	R	SQL index	Valid class code ranges and payroll limits used by BR-001 and BR-002.

Table	Owner library	Owner class	CRUD	SQL docs	Notes
`dbo.PremiumTransaction`	SAIF.PremiumAudit.Batch	`AuditProcessor`	C	SQL index	One adjustment row per posted audit. Inserted in the same transaction that updates `dbo.PolicyAudit`, so a rolled back audit leaves no transaction row.