mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Member

Enrollment, eligibility, demographics and plan attribution

2,833 member terms

sample coinsurance amountsmpl_coins_amt

The patient's share of cost for services associated with a biological specimen collection, representing the percentage-based out-of-pocket amount owed after deductible under the member's health plan for lab sample procedures on a medical or pharmacy claim.

sample enrollment statussmpl_enrl_sts

Indicates the current insurance enrollment state of the member at the time a biological specimen was collected, used to validate coverage eligibility and determine claim payability for laboratory and diagnostic sample collection services.

sample plansmpl_pln

Identifies the insurance benefit plan associated with a biological specimen collection event, used to link laboratory sample records to the appropriate coverage plan for claims adjudication, cost-sharing calculation, and lab service reporting.

sample policy numbersmpl_pol_nbr

The unique insurance policy identifier associated with a biological specimen collection record, used to link laboratory sample data to the member's active coverage policy for claims processing, eligibility validation, and lab billing reconciliation.

satisfaction coinsurance amountsat_coins_amt

The patient cost-sharing amount recorded in association with a patient satisfaction survey encounter or service event, capturing the out-of-pocket coinsurance liability tied to the visit or interaction where satisfaction data was collected for financial reporting.

satisfaction enrollment statussat_enrl_sts

Indicates the member's insurance enrollment state at the time a patient satisfaction survey was conducted or scored, used to correlate coverage status with patient experience data for population-level quality and member engagement reporting.

satisfaction plansat_pln

Identifies the health benefit plan associated with a patient satisfaction survey record, enabling analysis of patient experience scores by insurance plan type, used in quality measurement, HEDIS reporting, and member experience performance tracking.

satisfaction policy numbersat_pol_nbr

The insurance policy identifier linked to a patient satisfaction record, used to associate survey responses and experience scores with a specific coverage policy for plan-level quality performance analysis and member satisfaction benchmarking.

scan coinsurance amountscn_coins_amt

The member's coinsurance liability for a diagnostic imaging scan service such as MRI, CT, or PET, representing the patient's percentage-based out-of-pocket obligation after deductible as adjudicated on a medical claim under the applicable benefit plan.

scan enrollment statusscn_enrl_sts

Indicates the insurance enrollment state of the member at the time a diagnostic imaging scan was performed, used to confirm active coverage eligibility and support claims adjudication for radiology and medical imaging services.

scan planscn_pln

Identifies the insurance benefit plan associated with a diagnostic imaging scan procedure such as MRI, CT, or ultrasound, used to link imaging service records to the correct coverage plan for claims processing and radiology utilization reporting.

scan policy numberscn_pol_nbr

The unique insurance policy identifier associated with a diagnostic imaging scan record, linking the radiology or imaging service to the member's active coverage policy for claims adjudication, prior authorization tracking, and medical imaging billing.

schedule enrollment statussched_enrl_sts

Indicates the insurance enrollment state of a member at the time an appointment or care schedule was created, used to verify active coverage prior to service delivery and support scheduling workflows in care management and utilization tracking systems.

sensitivity coinsurance amountsens_coins_amt

The patient's coinsurance cost-sharing amount for services related to a documented substance sensitivity or intolerance, representing the out-of-pocket liability adjudicated on a medical or allergy-related claim under the member's applicable health benefit plan.

sensitivity enrollment statussens_enrl_sts

Indicates the insurance enrollment state of the member at the time a substance sensitivity or intolerance was recorded or treated, used to validate coverage eligibility for allergy and sensitivity-related clinical services and associated claims adjudication.

sensitivity plansens_pln

Identifies the health benefit plan associated with a patient's substance sensitivity or intolerance record, used to link allergy and reactivity documentation to the appropriate coverage plan for claims processing and clinical care management reporting.

sensitivity policy numbersens_pol_nbr

The insurance policy identifier linked to a substance sensitivity or intolerance record, used to associate allergy and reactivity clinical data with a specific coverage policy for claims adjudication, prior authorization, and care management tracking purposes.

serology coinsurance amountsero_coins_amt

The member's coinsurance liability for serology laboratory services, including antibody and antigen testing, representing the percentage-based patient cost-sharing amount adjudicated on a medical or lab claim under the applicable health plan after deductible is met.

serology enrollment statussero_enrl_sts

Indicates the current participation status of a member within a serology-based antibody study or surveillance program. Tracks whether the member is actively enrolled, pending, withdrawn, or completed in the serological testing protocol.

serology plansero_pln

Identifies the specific health insurance or benefits plan associated with a member's serology testing encounter. Used in claims and laboratory data systems to link serum antibody testing services to the correct coverage plan for billing and reimbursement purposes.

PreviousPage 127 of 142Next