Expense Summary Repository

Data access layer that reads from the materialized expense_summary_snapshots table for pre-aggregated figures and executes ad-hoc queries against expense_claims and expense_items for real-time deltas and drill-down results. Uses composite indexes on submitter_id, expense_type, and created_at to keep on-demand queries performant.

Feature: Reimbursement Overview

expense-summary-repository

• Read nightly aggregate snapshots from expense_summary_snapshots keyed by org and period
• Execute real-time aggregation on expense_claims for the current calendar day
• Execute parameterized drill-down queries with index-aware filtering
• Return rolling average and standard deviation baseline data per organization for anomaly detection