Multi-Organization Hierarchy

NHF operates across 12 national associations, 9 regions, and 1,400 local associations, making a flat organization model entirely inadequate for correct activity attribution and Bufdir reporting. Without hierarchy support, data cannot be attributed to the appropriate organizational level, breaking both internal analytics and government reporting. The duplicate-activity detection requirement - where coordinators at different levels register the same activity - is only solvable with an explicit hierarchy model. Supporting multi-level structures is therefore a hard prerequisite for NHF adoption, a flagship launch organization.

The org_hierarchies table stores parent-child relationships between organizations with depth constraints enforced by the API to prevent cycles. The local_associations table represents sub-units within organizations. Roll-up queries use recursive CTEs on the hierarchy graph. The admin UI renders a tree view of the hierarchy with reordering controls that include a keyboard-accessible alternative for WCAG compliance. Duplicate activity detection runs at write time using the hierarchy graph to identify overlapping registrations across levels. API-layer cycle detection prevents malformed hierarchies from reaching the database.