Reimbursement Admin Repository

Data access layer optimized for the admin oversight use case, providing complex filtered and paginated queries that join reimbursements, expenses, receipts, and users tables. Implements role-scoped WHERE clauses ensuring coordinators are limited to their local association's data. Distinct from the peer mentor-facing reimbursement repository in that it supports multi-record bulk updates and aggregated status counts for the dashboard.

Feature: Admin Reimbursement Oversight

reimbursement-admin-repository

• Execute paginated, filtered queries joining reimbursements to expenses, receipts, and peer mentor user records
• Apply organization and local-association scoping at the SQL query level
• Perform transactional bulk status updates for batch approval or rejection
• Provide aggregated counts of pending, approved, and rejected reimbursements per organization
• Support cursor-based or offset pagination for large result sets