Detect and Block Duplicate Activity Submissions Across Affiliated Organizations
Double-reporting is the core compliance risk for NHF, where a peer mentor affiliated with multiple lokallag could register the same activity under different organizational contexts either accidentally or due to confusion. The Duplicate Report Prevention Service uses configurable fuzzy matching across the dimensions of activity type, contact identifier, date, and duration. When a potential duplicate is detected against existing records in any of the user's affiliated organizations (accessed via the Membership Repository with RLS-scoped cross-org queries), the system raises an inline warning before the submit action is confirmed. Administrators configure the matching sensitivity thresholds; the peer mentor sees the warning at submission time. This story covers the administrator's ability to review the duplicate detection audit log and understand which submissions were flagged or blocked.
User Story
Acceptance Criteria
- Given a peer mentor registers an activity with the same activity type, contact, and date as an existing record under a different affiliated organization, when the Duplicate Report Prevention Service evaluates the submission, then a duplicate warning is surfaced to the user before finalization
- Given a duplicate warning is raised, when the administrator reviews the audit log, then they can see the original record, the duplicate candidate, the matched fields, and the confidence score
- Given a peer mentor acknowledges a duplicate warning and chooses to proceed, when the activity is submitted, then it is logged with a 'confirmed-duplicate-override' flag for administrator review
- Given an Organization Administrator reviews the duplicate detection log, when they view a flagged item, then they can see the full context of both records and take action to merge, reject, or approve the newer submission
- Given the Duplicate Report Prevention Service queries across affiliated organizations, when performing deduplication checks, then only data explicitly permitted by the Membership RLS Policy is accessed — no broader cross-organization data leakage occurs
Business Value
Double-reporting is a documented compliance and funding risk for NHF, where inaccurate Bufdir grant reports can trigger audits and funding disputes. Automated duplicate detection directly addresses this identified pain point, eliminating the need for manual cross-check reconciliation and protecting the integrity of grant applications across all affiliated lokallag.
Components
- Duplicate Report Prevention Service service
- Membership Repository data
- Membership RLS Policy Configuration infrastructure
- Membership Service service