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
Worked example
This example uses fictional details. Use the same fields with evidence from your work.
- Fictional population row
- An identity appears in the hospital and vendor export with different account numbers. The analyst links both to one person but keeps both source IDs for reconciliation.
- Fictional threshold summary
- The current estimate is 612 people across five states. California has 492 confirmed residents and 38 unresolved addresses. The media decision remains open until the address review sets a defensible count.
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)