Template library
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

  1. 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.
  2. 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.
  3. 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)

Keyboard shortcuts

⌘K or /
Search everything
?
This list
g h
Home
g l
Guide library
g f
Find my path
g t
Templates
g p
Playbooks
g w
My workspace
g d
Deadline calendar
g c
Regulatory changes