COPRSETR WORKSHEET
Affected-person reconciliation and threshold matrix
HIPAA breach notification operations · Step 3 · Reconcile people, data, locations and thresholds- Who prepares it
- Privacy analytics lead + Security forensics + Health information management + Business associate data team
- When to prepare it
- Run continuously while investigation proceeds; freeze each version used for a filing or notice
Template fields
Fill in each section with details from your work.
- Fictional population row
- [Add details here]
- Fictional threshold summary
- [Add details here]
Gather first
- Patient, member or employee ID
- Source-system exports
- Business associate files
- Address and residence state
- Data-type and event mapping
How to prepare it
- Create a restricted person-level staging table. Normalize identifiers, retain source record IDs, deduplicate across systems and flag unresolved identities rather than silently dropping them.
- Calculate the total unique individuals and separate counts by state or jurisdiction of residence. Classify confirmed, estimated and maximum potential counts and document the query, exclusions, assumptions and cutoff timestamp.
- Check the 500-person overall threshold for contemporaneous OCR notice and the separate more-than-500-residents-in-one-state threshold for media notice. If the large-breach count is uncertain, prepare an estimate and a dated addendum plan.
Review
The covered entity can defend who was included, which counts remain estimated and whether each legal threshold was crossed.
Handoff
Freeze the approved extract and give it to the notice production and OCR filing owners.
Use the issuer’s current instructions and any required forms when you submit.
45 CFR Part 164, Subpart D (opens in a new tab)