Team Reports

All four workshop organizations require coordinators and org admins to monitor team-level activity without resorting to manual Excel aggregation. NHF currently routes Word forms through regions to central Excel - a process described as unsustainable. Team Reports replaces this with a structured, always-current view that directly reduces administrative overhead. For Bufdir-funded organizations, team-level data is also a prerequisite for generating compliant reports, making this feature a foundational dependency for the reporting pipeline. Providing this in MVP prevents coordinators from reverting to legacy systems while Bufdir export is rolled out in Fase 2.

Implement as a server-rendered Next.js page in the Admin Web Portal, querying the shared PostgreSQL database via parameterized SQL aggregations grouped by organization, area, and coordinator. Use row-level security or explicit tenant_id filtering to enforce isolation. The API endpoint should return pre-aggregated totals (activity count, unique contacts, total hours) to avoid sending raw records to the client. Pagination and date-range filtering are required for organizations with high activity volumes (HLF reported one peer mentor with 380 registrations in a year). Export to CSV should be a stretch goal for MVP, promoted to confirmed scope in Fase 2 alongside Bufdir export.