Service Layer medium complexity backend
0
Dependencies
0
Dependents
0
Entities
0
Integrations

Description

Backend service that validates custom report definitions, executes the queries against organizational data, and returns formatted results. Enforces organization scoping so admins can only query their own org's data.

Feature: Custom Reports

custom-report-service

Sources & reasoning

Custom Reports are listed in the canonical area taxonomy for admin-reporting. They are not part of the MVP or Core Product roadmap and are most consistent with the Phase 3 'Growth & Engagement' goal of extending platform capability beyond core operational needs.

  • admin-reporting | Reporting & Export | Team Reports, Bufdir Report Generation, Bufdir Export, Custom Reports

Responsibilities

  • Validate report definition structure and field combinations
  • Translate definitions into safe parameterized queries
  • Enforce strict organization scoping on every query
  • Aggregate counts, hours, and reimbursement totals
  • Format results into requested output formats

Interfaces

validateDefinition(definition): ValidationResult
executeReport(definitionId, orgId): ReportResult
listDefinitions(orgId): ReportDefinition[]
deleteDefinition(definitionId, orgId): void