---
id: TST-PFM-LLM-046
title: Database checks for AI Settlement Sweep
kind: integration
product_area: platform
module: llm
revision: 1
status: draft
source_sha:
  services-platform: ad3f6a6582843008ed0f5a17b131878d15829af1
repository: services-platform
files:
  - modules/llm/tests/integration/services/reconciliation/llm-settlement-sweep.integration.spec.js
implements:
  - ATS-PFM-LLM-007-12
  - ATS-PFM-LLM-009-01
  - ATS-PFM-LLM-009-02
  - ATS-PFM-LLM-009-03
environment: local
implementation_state: implemented
latest_result: not-run
latest_run_at: null
latest_run_ref: null
conformance: not-verified
estimated_minutes: 3
isolation: Prepared local test database with suite-owned records and scoped cleanup.
evidence:
  - provenance: test
    source: >-
      services-platform:modules/llm/tests/integration/services/reconciliation/llm-settlement-sweep.integration.spec.js
source_boundary:
  provenance: observed
  source: >-
    services-platform:modules/llm/tests/integration/services/reconciliation/llm-settlement-sweep.integration.spec.js
---

# Database checks for AI Settlement Sweep

## Verification Boundary

The suite checks module persistence or service behavior against prepared PostgreSQL with scoped records.

## What This Suite Proves

Recovery releases an eligible recorded hold. Old nonterminal requests receive estimated settlement. Recent work remains untouched. Successful recovery is not charged twice. Combined bindings require every named suite; a component assertion alone does not establish the full experiment.

## What It Does Not Prove

The suite does not establish browser behavior, deployed routing, live model quality or actual recipient inbox delivery.

## Real Dependencies and Test Doubles

PostgreSQL, production sweep, per-workspace pass, ledger and request-state comparisons are real. A fixed clock controls eligibility; settlement statements are not doubled.

## Must Not Be Doubled

Retain PostgreSQL constraints, transaction behavior and the production persistence or dispatcher path under test. A scripted provider must not replace accounting or authorization.