HIGH story-multi-org-membership-handling-global-admin-007 5 pts

User Story

As a Global Administrator
I want to view a platform-wide dashboard showing the count of users with multi-organization memberships, the number of duplicate detection events raised and resolved per organization, and any unresolved membership conflicts flagged for administrator action
So that So that I can identify organizations that are struggling with multi-membership complexity, provide targeted support to Organization Administrators, and ensure platform-wide data quality ahead of Bufdir reporting cycles

Acceptance Criteria

  • Given a Global Administrator accesses the multi-membership monitoring dashboard, when the page loads, then they see aggregate counts of multi-membership users per organization
  • Given the dashboard is loaded, when the Global Administrator views the duplicate detection summary, then they see per-organization counts of: total warnings raised, confirmed duplicates blocked, and overrides accepted in the current reporting period
  • Given one or more organizations have unresolved membership conflicts older than the configured SLA threshold, when the dashboard loads, then those organizations are highlighted with an alert indicator and a count of overdue conflicts
  • Given a Global Administrator selects a specific organization's conflict summary, when they drill down, then they see a list of unresolved items with metadata including conflict type, date raised, and the Organization Administrator responsible — without exposing underlying activity content
  • Given the Membership RLS Policy governs data access, when the Global Administrator queries cross-organization membership data, then only metadata and aggregate statistics are returned — individual peer mentor activity content remains isolated per organization

Business Value

Global Administrators currently lack a unified platform health view, making it difficult to proactively support Organization Administrators before multi-membership issues escalate into inaccurate Bufdir submissions. A platform-wide monitoring dashboard enables data-driven support prioritization and ensures no organization's compliance risks go undetected across reporting cycles.