# Affected-person reconciliation and threshold matrix

HIPAA breach notification operations | Worked example with fictional data

Step: Reconcile people, data, locations and thresholds
Owner: Privacy analytics lead + Security forensics + Health information management + Business associate data team
When: Run continuously while investigation proceeds; freeze each version used for a filing or notice

## 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.

## Example

### 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.

## 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.

Official reference: 45 CFR Part 164, Subpart D
https://www.ecfr.gov/current/title-45/subtitle-A/subchapter-C/part-164/subpart-D

Use the current rules and any prescribed forms for your engagement.
