Schema Care

HIPAA Compliant Data Extraction, Field by Field

By Schema CarePublished Updated

HIPAA compliant data extraction treats every field pulled from a medical document as protected health information, extracts only the fields a task needs, and protects each place those fields travel: the review queue, the export and the receiving system. No agency certifies extraction software, so the safeguards and the business associate agreement carry the weight.

Why extracted fields are still PHI after data extraction

Data extraction is the step that turns a scanned page into named fields, such as a member ID, a service date or a paid amount. Pulling a value off the page does not change its legal status. A patient's paid amount in a database row is as much protected health information (PHI) as the same number printed on the EOB.

The definitions explain why. Under 45 CFR 160.103 on the eCFR, health information includes information that relates to "the past, present, or future payment for the provision of health care to an individual." It becomes individually identifiable when it identifies the person or when "there is a reasonable basis to believe the information can be used to identify the individual." PHI is that information whether it is "transmitted by electronic media," "maintained in electronic media," or held in any other form.

Three consequences follow for extraction work:

  • Payment data counts. Allowed amounts, plan payments and adjustment codes are health information because they relate to payment for care, not only diagnoses.
  • Combinations count. A row with a date of service, a ZIP code and a procedure code may identify someone even with the name stripped. The test is a reasonable basis to identify, not the presence of a name.
  • The format does not matter. A CSV, a JSON payload, a database table or a screenshot all hold PHI when the values came from a patient's document.

Removing identifiers can change the status, but only by meeting a defined standard. 45 CFR 164.514 on the eCFR treats health information as not individually identifiable only when there is "no reasonable basis to believe" it can identify a person, determined by one of the two methods that section sets out. Dropping the patient name column from an export does not, by itself, meet that standard.

Applying the minimum necessary standard to data extraction

The minimum necessary standard is the Privacy Rule requirement to limit PHI to what a task actually needs. Applied to data extraction, it means deciding field by field what to pull from each document type, and leaving the rest on the page. Fewer extracted fields means fewer copies to protect downstream.

The rule text is short. 45 CFR 164.502(b) on the eCFR says a covered entity or business associate "must make reasonable efforts to limit protected health information to the minimum necessary to accomplish the intended purpose of the use, disclosure, or request." The same section lists exceptions, including disclosures to a provider for treatment. Billing and payment posting do not appear on that list, so extraction work done for payment generally falls under the standard.

The HHS minimum necessary guidance adds that, for routine and recurring requests, policies "may be standard protocols," and individual review of each disclosure "is not required." A field list per document type is exactly that kind of protocol. You decide once which fields payment posting needs from an EOB, write it down, and configure extraction to match.

Worked example: a fictional EOB

The table below takes one fictional provider EOB and sorts everything on it. All names, numbers and amounts are made up for the example. The task is posting the payment to the practice management system.

Item on the pageExample valueNeeded to post?Decision
Payer nameExample Health PlanYesExtract
Check or EFT number and totalEFT 000482913, $1,284.50YesExtract
Patient nameDana Ruiz (example)Yes, to match the accountExtract
Member IDW123456789 (example)Yes, to match the accountExtract
Payer claim number2026-1015-00731 (example)YesExtract
Service line: procedure code and date99213, 2026-09-12YesExtract
Billed and allowed amounts$250.00 billed, $160.00 allowedYesExtract
Plan payment$96.00YesExtract
Adjustment and remark codesCO-45, PR-1, PR-2YesExtract
Subscriber's employer group nameExample Logistics Inc.NoLeave on page
Subscriber address14 Elm Street (example)NoLeave on page
Other patients' claims on the same pageTwo more claimsOnly on their own linesExtract per claim, never cross-copy
Plan marketing text and phone numbersMember services lineNoLeave on page
Appeal rights paragraphStandard noticeNoLeave on page

The decision column is the protocol. It also shapes what Schema Care does on EOBs, where the fields it reads are service lines, allowed amounts, plan payments and remark codes, as listed on the supported documents section. For more on reading an EOB line by line, the EOBs and remittances category collects the guides.

Where do extracted fields travel after data extraction?

Extracted fields travel further than the source page. After data extraction they can sit in a review queue, an export file, a processing log, a billing system, a data warehouse and a backup. Each stop is a new copy of PHI, and each needs an owner, an access rule and a deletion date.

Tracing the fields from the fictional EOB above shows the usual path:

  1. The extraction tool's results store. The fields, their confidence scores and links to the source page.
  2. The review queue. Fields that fell below the confidence threshold wait here for a person.
  3. Activity records. Each approval or correction may be logged with the user, the time and sometimes the old and new value.
  4. The export. Approved fields leave as a file or a transfer to the billing system.
  5. The receiving system. The practice management system now holds the posted payment.
  6. Backups. Every system above may keep copies for weeks or months.

The Security Rule follows the fields to every stop. 45 CFR 164.312 on the eCFR requires access control on systems that maintain electronic PHI, audit controls that "record and examine activity," integrity protections against "improper alteration or destruction," and transmission security for data moving over a network. A field copied into a system with none of these is a gap, however well the extraction tool itself is run.

Logs deserve their own check. A correction record that stores "member ID changed from W123456788 to W123456789" holds PHI. That is often useful for audits, but it means the log needs the same access rules as the data.

Long-term storage of documents and fields belongs to a separate decision. The guide to HIPAA compliant document management covers what a records system needs, and AI models in the path are covered in HIPAA compliant AI.

How should reviewers see PHI during data extraction review?

Reviewers in a data extraction workflow should see enough of the source page to check the field in front of them, and no more documents than their role requires. The minimum necessary standard applies to your own workforce, so a reviewer checking EOB payments does not need access to intake forms or discharge summaries.

The workforce side of the standard is in 45 CFR 164.514(d). It requires a covered entity to identify the people or classes of people "who need access to protected health information to carry out their duties," the categories of PHI each needs, and to "make reasonable efforts to limit the access" accordingly. HHS's minimum necessary guidance adds that where an entire record is necessary, policies "must state so explicitly and include a justification."

For review screens, that translates into a few design choices:

  • Show the field in context. A reviewer checking a paid amount of $96.00 needs to see the service line it came from. A highlight on the source page answers the question faster than the whole document.
  • Route by document type. Payment posters see EOBs; intake staff see intake forms. Mixing queues widens access for no gain.
  • Separate logins. Unique user identification is a required specification in 164.312, and it is what makes activity records mean anything.
  • Limit downloads. A reviewer who can approve a field rarely needs to download the whole PDF.

Schema Care's review step works the field-in-context way: a field below the customer's threshold appears highlighted on the original page, and the reviewer approves or corrects it. How to set up roles for review queues is the subject of the section on role-based access for review queues. Confidence thresholds as a quality tool, rather than a privacy one, are covered in the human review category.

Data extraction exports that leak PHI: CSVs, spreadsheets and screenshots

Data extraction exports leak PHI when a file leaves the protected tool and stops following its rules. A CSV in a downloads folder, a spreadsheet attached to an email or a screenshot pasted into a chat each create an uncontrolled copy. These habits can undo every control the extraction tool applies.

CSV and spreadsheet exports. A full export "to be safe" usually carries every field, including ones the minimum necessary protocol left out. Example: a billing lead exports all 1,200 extracted rows for September to find one payer's underpayments. A filtered export of that payer's 80 rows, with only the columns the analysis needs, serves the same purpose with far less exposure.

Email attachments. Sending the export to a colleague puts PHI into two mailboxes, the sent folder and any mail archive. The transmission security standard in 164.312 calls for protecting PHI moving over a network. A shared folder with access rules, or the receiving system's own import, avoids the attachment altogether.

Screenshots. A reviewer stuck on a blurry field may screenshot it to ask a colleague. The image now holds a patient name, a member ID and an amount in a chat tool that may not be covered by any business associate agreement.

Desktop copies after import. Once the billing system has taken the data, the export file has done its job. A rule to delete it after import, and a periodic check of shared folders, closes the gap.

Test and training files. Teams often keep a "good example" export to train new staff. Unless it has been de-identified to the standard in 164.514, it is still PHI and needs the same handling as live data.

Each of these is a workforce habit more than a software flaw. The Security Rule's administrative safeguards in 45 CFR 164.308 on the eCFR include a security awareness and training program for all staff and a sanction policy for those who do not follow procedures. Naming exports, screenshots and side tools in that training is the cheapest control on this list.

All posts in HIPAA, BAAs and PHI