Eligibility and Benefits Verification

This dataset provides granular, real-time details on patient insurance eligibility and benefits, including coverage status, effective dates, deductibles, copays, prior authorization requirements, and benefit limitations as transmitted via 270/271 EDI transactions. It is ideal for healthcare providers, payers, and revenue cycle teams seeking to streamline eligibility checks, prevent claim denials, and optimize patient financial counseling.

  • last updated 2 Nov 2025
  • by GoMask
The brief that made it

Automated insurance eligibility verification for patient intake

Sample rows

preview · 8 of 110 rows · all 20 columns
transaction_idstringcoverage_typestringcoinsurance_percentagefloatprior_authorization_requiredbooleanbenefit_limit_typestringpatient_idstringpayer_idstringprovider_idstringcoverage_statusstringcoverage_effective_datedatecoverage_end_datedatedeductible_met_amountfloatdeductible_total_amountfloatcopay_amountfloatbenefit_limit_valuefloatservice_type_codestringservice_type_descriptionstringtransaction_datetimedatetimeresponse_codestringresponse_messagestring
TRX00001medical20falseannualPAT0001PYR1001PRV2001active2023-03-18blank185.231200251000030Health Benefit Plan Coverage2024-04-11T09:46:00approvedEligibility and benefits confirmed for medical coverage. Annual limit is $10,000.
TRX00002dental15falsevisitPAT0002PYR1002PRV2002active2022-09-03blank60.520045835Routine Dental2024-02-21T14:20:00approvedDental coverage active. Visit limit is 8/year.
TRX00003pharmacy0falsedollarPAT0003PYR1003PRV2003terminated2022-04-012023-11-15757501500048Pharmacy Coverage2024-01-05T10:32:00deniedCoverage terminated as of 2023-11-15. No pharmacy benefits available.
TRX00004medical10truedollarPAT0004PYR1004PRV2004pending2024-04-02blank01800352000030Specialist Visit2024-04-10T11:04:00pendingPrior authorization required for coverage activation. Authorization details sent to provider.
TRX00005vision0falseannualPAT0005PYR1005PRV2005active2021-06-25blank15752030047Vision Exam2024-03-19T15:18:00approvedVision benefits confirmed. Annual limit is $300.
TRX00006other100trueotherPAT0006PYR1001PRV2001inactive2020-01-102023-06-01000199Other Coverage Type2024-02-10T13:00:00errorCoverage is inactive. Prior authorization required for legacy services.
TRX00007dental20falsevisitPAT0007PYR1002PRV2002active2023-10-14blank120250601035Preventive Dental2024-04-09T10:20:00approvedDental coverage confirmed. Preventive services up to 10 visits.
TRX00008pharmacy5falsedollarPAT0008PYR1003PRV2003active2022-05-30blank10507.5500048Pharmacy Benefits2024-03-15T17:12:00approvedPharmacy coverage active. Annual dollar limit is $5,000.

What the 110 rows show

from the 110-row sample

Other (coverage type) stands out: mean coinsurance_percentage is 100.0, against 7.9 for the rest.

  • 28%prior_authorization_required = true
  • 10median coinsurance_percentage
  • 4coverage statuses
  • 4response codes
  • 5service type codes
  • 18service type descriptions
Mean coinsurance_percentage by coverage_type110 rows
05010013.3medical26 rows10.9dental23 rows0.0vision26 rows7.5pharma…20 rows100.0other15 rows
coinsurance_percentage110 rows, in bands of 10
0255048301700000015050100coinsurance_percentage →

Median 10, from 0 to 100.

benefit_limit_type104 rows with a value · 6 left blank
  1. annual32
  2. visit22
  3. dollar22
  4. other15
  5. lifetime13
20 columns by typefrom the column list below
  • string 11
  • float 5
  • date 2
  • datetime 1
  • boolean 1

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 11 columns
transaction_idstringUnique identifier for the eligibility verification transaction (270/271 EDI).uniqueTRX00001
patient_idstringUnique identifier for the patient whose eligibility is being checked.PAT0001
payer_idstringUnique identifier for the insurance payer.PYR1001
provider_idstringUnique identifier for the healthcare provider submitting the eligibility check.PRV2001
coverage_statusstringCurrent coverage status for the patient (e.g., active, inactive, terminated, pending).active · inactive · terminated · pendingactive
coverage_typestringType of insurance coverage (e.g., medical, dental, vision, pharmacy).medical · dental · vision · pharmacy · othermedical
benefit_limit_typestringType of benefit limitation (e.g., annual, lifetime, visit, dollar).annual · lifetime · visit · dollar · other · optionalannual
service_type_codestringStandard code indicating the type of service (e.g., 30 for health benefit plan coverage).5 codes · optional30
service_type_descriptionstringDescription of the service type covered.optionalRoutine Dental
response_codestringCode indicating the outcome of the eligibility check (e.g., approved, denied, error).approved · denied · error · pendingapproved
response_messagestringDetailed message or notes returned from the payer regarding eligibility or benefits.optionalEligibility and benefits …
Numbers 5 columns
deductible_met_amountfloatAmount of deductible that has been met by the patient for the coverage period.0 or more · optional185.23
deductible_total_amountfloatTotal deductible amount required for the coverage period.0 or more · optional1200
copay_amountfloatCopay amount required for the covered service.0 or more · optional25
coinsurance_percentagefloatPercentage of coinsurance required for the covered service.0 to 100 · optional20
benefit_limit_valuefloatValue of the benefit limitation (e.g., number of visits, dollar amount).0 or more · optional10000
Dates and times 3 columns
coverage_effective_datedateDate when the coverage became effective.2023-03-18
coverage_end_datedateDate when the coverage ends or ended (if applicable).optional2023-11-15
transaction_datetimedatetimeDate and time when the eligibility check transaction occurred.2024-04-11T09:46:00
True or false 1 column
prior_authorization_requiredbooleanIndicates if prior authorization is required for the service.false

Use it for

  • prior authoriz…28%31 of 110 rowsmean coinsurance perc…13.3medi…10.9dent…0.0visi…7.5phar…

    A healthcare dashboard

    The prior_authorization_required rate, coinsurance_percentage by coverage_type and a breakdown of benefit_limit_type. Excel, Power BI or Tableau.

  • Why do the 15 other rows have a mean coinsurance_percentage of 100.0?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable transactions with patient_id, payer_id and provider_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset110 rows20 columns
Yours1,000 rows20 columns

blueprint · eligibility-and-benefits-verification

Behind this dataset

Same schema. As many rows as you need.

These 110 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • 270 EDI transaction: eligibility inquiry
  • 271 EDI transaction: eligibility response
  • Patient identifier: member ID, SSN, DOB
  • Subscriber vs dependent relationship
  • Coverage status: active, inactive, terminated
  • Effective date and termination date
  • Plan type: HMO, PPO, EPO, POS, HDHP
  • Deductible: individual and family amounts, remaining
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
eligibility-and-benefits-verification

What should your data show?

Preview 20 rows free
No signup. No card.