Use Daily Aggregates for HQ History and Scoped Reads for Live Detail

Context

HQ comparisons need a common reporting source without granting raw cross-organization request access.

Decision

Rebuild organization-day aggregates from settled and refused requests for cross-organization history, while entering organization scope for live positions and individual records.

Alternatives Considered

Read every raw organization for every historical chart: It scales reporting work with all underlying request records.

Bypass organization policy for raw reporting: The proposed system scope is not built and exposes more than aggregate figures.

Increment reporting counters on every settlement: Lost or repeated movements can create drift that full-day replacement avoids.

Consequences

The dedicated reporting reader accesses aggregate columns rather than raw requests. Historical data lags successful rollup progress and excludes running requests. Unreadable organization discovery blocks global progress. The UTC-day reporting boundary remains proposed.