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

coverage resolution datecov_resol_dt

The date on which a coverage dispute, coordination of benefits issue, or eligibility discrepancy was resolved. Used in member enrollment and claims adjudication to close outstanding coverage conflicts and establish a finalized effective coverage determination.

coverage respirationcov_resp

Indicates whether respiratory therapy services, ventilator support, or breathing-related treatments are included within the scope of a member's health insurance plan. Used in benefits configuration to define covered services for pulmonary and respiratory care.

coverage revisioncov_rev

A version or iteration number tracking changes made to a member's insurance coverage record over time. Used in enrollment systems to maintain an audit history of plan modifications, benefit updates, or eligibility corrections applied to a coverage record.

coverage riskcov_rsk

A risk classification assigned to a member's insurance coverage, reflecting factors such as health status, claims history, or actuarial risk tier. Used in underwriting and care management to stratify members and guide coverage terms or intervention programs.

coverage routecov_rte

Identifies the channel or pathway through which insurance coverage was obtained, such as employer-sponsored, individual marketplace, Medicaid, or Medicare. Used in enrollment systems to categorize coverage origin and apply applicable plan rules and regulatory requirements.

coverage scorecov_scr

A calculated numeric rating reflecting the comprehensiveness, quality, or adequacy of a member's insurance coverage. Used in health plan analytics and member management to evaluate benefit levels, gaps in coverage, or actuarial performance against defined benchmarks.

coverage sequencecov_seq

A numeric value indicating the order of a coverage record among multiple active or historical insurance plans for a member. Used in coordination of benefits to determine primary, secondary, and tertiary payer responsibility during claims adjudication.

coverage severitycov_sev

A classification indicating the level of benefit limitation or restriction within a member's insurance coverage, such as limited mental health days or high-deductible thresholds. Used in benefits administration to flag coverage gaps and inform member eligibility decisions.

coverage sexcov_sex

The biological sex recorded on a member's insurance coverage record, used to apply sex-specific benefit rules, actuarial rating factors, and preventive care eligibility. Used in enrollment and claims systems to ensure appropriate coverage determinations under applicable plan guidelines.

coverage sourcecov_src

Identifies the originating entity or system that established a member's insurance coverage, such as an employer group, government program, or insurance exchange. Used in enrollment processing to trace coverage provenance and apply correct plan terms and funding arrangements.

coverage start datecov_start_dt

The calendar date marking the beginning of a coverage period for a member under a specific insurance plan or policy, used in member enrollment and eligibility systems to define benefit applicability windows. Critical for claims validation, retroactive enrollment processing, and coordination of benefits logic in payer and EHR platforms.

coverage start timecov_start_tm

The specific timestamp marking when insurance coverage became effective for a member, including hours and minutes where applicable. Used in enrollment and claims systems to determine precise eligibility windows, particularly for same-day coverage changes or newborn enrollment scenarios.

coverage statecov_st

The U.S. state or territory associated with a member's insurance coverage record, used to apply state-specific regulatory requirements, mandated benefits, and network configurations. Used in enrollment systems to route coverage under the correct jurisdiction and compliance framework.

coverage statuscov_sts

Indicates the current active, inactive, terminated, or suspended state of a member's insurance coverage. Used in enrollment and claims systems to validate eligibility at the time of service and determine whether a member's benefits are in force for adjudication purposes.

coverage strengthcov_str

Indicates the level or degree of insurance benefit protection provided under a member's health plan, such as catastrophic, bronze, silver, gold, or platinum tier. Used in enrollment and benefits administration to categorize cost-sharing structures and covered service levels.

coverage subtotalcov_subtot

A partial financial sum representing a subset of costs within a member's insurance coverage calculation, such as pre-deductible or pre-coinsurance amounts. Used in claims adjudication and member cost-sharing calculations to track incremental payment obligations before final totals are applied.

coverage system identifiercov_sys_id

A system-generated unique identifier assigned to a member's insurance coverage record within a health plan or enrollment platform. Used to track, link, and retrieve coverage details consistently across claims, eligibility verification, and member management systems throughout the coverage lifecycle.

coverage targetcov_tgt

Identifies the intended beneficiary population, geographic region, or benefit category that a specific insurance coverage plan is designed to serve. Used in health plan configuration and enrollment systems to align coverage terms with eligible member segments and contracted service areas.

coverage taxonomy codecov_tax_cd

A standardized NUCC taxonomy code associated with the type of coverage or health plan category, used to classify the nature of insurance benefits. Used in enrollment and claims processing to identify plan type and apply correct adjudication rules and network configurations.

coverage temperaturecov_temp

Indicates whether temperature-sensitive services, such as cryotherapy or thermotherapy treatments, are included within a member's insurance plan benefits. Used in benefits configuration to define covered ancillary or specialty services subject to specific clinical coverage criteria.

PreviousPage 41 of 142Next