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

dependent timestampdep_ts

A combined date and time value recording when a dependent-related event, record creation, or data modification occurred within a healthcare system. Used in member enrollment, EHR, claims, and PBM platforms to support audit trails, change history tracking, data reconciliation, and sequencing of transactions associated with dependent member records.

dependent titledep_ttl

The formal honorific or title associated with a dependent enrolled under a primary insurance subscriber, such as Mr., Ms., Dr., or Jr. Used in member enrollment and correspondence systems to ensure accurate personalization of plan communications, explanation of benefits documents, and member-facing materials throughout the coverage period.

dependent totaldep_tot

The aggregated count or summed value associated with dependents covered under a member's health plan in enrollment or claims systems. Used in premium calculation, family deductible accumulation, capitation reporting, and actuarial analytics to quantify dependent-level financial exposure across payer and PBM platforms.

dependent total countdep_tot_cnt

The total number of dependents enrolled under a primary insurance subscriber's health plan. Used in member enrollment analytics to track family unit size, calculate premium tiers, and support benefits administration reporting across health plan and eligibility systems.

dependent typedep_typ

A categorical classification identifying the relationship of a covered dependent to the primary insured member in health plan enrollment and claims systems. Common values include spouse, child, or domestic partner. Used in eligibility verification, premium tiering, and benefit coordination workflows across EHR and payer platforms.

dependent unitdep_unt

The unit of measurement applied to a dependent's benefit allocation or service quantity in healthcare payer or PBM systems. Used in benefit utilization tracking, pharmacy dispensing calculations, and capitation models to quantify dependent-level resource consumption within family enrollment and claims adjudication workflows.

dependent updated datedep_upd_dt

The most recent date on which a dependent's enrollment or demographic record was modified in the health plan system. Used to audit record changes, synchronize eligibility data across payers and clearinghouses, and maintain accurate member roster information for claims adjudication.

dependent urgencydep_urg

Indicates the clinical or administrative time-sensitivity level assigned to a care request or authorization for a subscriber's dependent. Used in utilization management workflows to prioritize prior authorization reviews and referral processing based on urgency classifications such as routine, urgent, or emergent.

dependent valuedep_val

The measured or recorded data point associated with an insurance beneficiary who is covered under a primary subscriber's health plan. Used in EHR, claims, and enrollment systems to distinguish dependent-specific metrics such as utilization, cost, or clinical outcomes from subscriber-level data, enabling accurate family-unit analytics and reporting.

dependent versiondep_ver

A sequential version number assigned to a dependent's enrollment record each time it is updated in the health plan or eligibility system. Enables tracking of record history and ensures downstream systems such as claims adjudication platforms consume the most current eligibility data for the dependent.

dependent zipdep_zip

The five or nine digit postal ZIP code associated with the residential address of an insurance subscriber's dependent. Used in member enrollment records to determine geographic network eligibility, assign regional health plans, calculate area risk factors, and support population health reporting.

dermatology coinsurance amountderm_coins_amt

The dollar amount a member is responsible for paying as their share of costs for a dermatology specialty service after the deductible is met. Calculated based on the member's health plan coinsurance percentage applied to the allowed amount for skin-related procedures and visits on an adjudicated claim.

dermatology enrollment statusderm_enrl_sts

Indicates whether a member is actively enrolled in a dermatology specialty care program or managed dermatology benefit plan. Reflects the current participation state such as active, inactive, or terminated, used to validate coverage eligibility during claims adjudication for skin specialty services.

dermatology planderm_pln

The structured treatment plan documented by a dermatologist outlining planned interventions, therapies, medications, and follow-up care for a patient's skin condition. Captured in clinical encounter records and used to coordinate care, support prior authorizations, and guide ongoing disease management for dermatological conditions.

dermatology policy numberderm_pol_nbr

The unique identifier assigned to a member's insurance policy that governs coverage for dermatology specialty services. Used during claims adjudication and eligibility verification to link dermatology claims to the correct health plan contract and apply the appropriate benefits, copays, and network rules.

device enrollment statusdev_enrl_sts

Indicates the current participation state of a medical device in a health plan benefit program or device management registry. Reflects whether a durable medical equipment item such as an insulin pump or CPAP machine is actively enrolled, pending approval, or terminated within the member's coverage benefit.

directive coinsurance amountdir_coins_amt

The member cost-sharing dollar amount applied to services rendered pursuant to an advance directive or care instruction, such as palliative care or hospice services. Represents the member's coinsurance obligation after deductible on adjudicated claims tied to directive-guided care plans within the health plan benefit structure.

directive enrollment statusdir_enrl_sts

Indicates whether a patient's advance directive, such as a do-not-resuscitate order or living will, has been formally registered and is active within the clinical or health plan system. Used to ensure care teams and payers apply appropriate care protocols and coverage rules aligned with the patient's documented care instructions.

directive plandir_pln

The documented clinical care plan that aligns with a patient's advance directive instructions, outlining the scope of treatments to be provided or withheld based on the patient's stated wishes. Used in care coordination workflows to guide clinicians and ensure treatment decisions comply with legally documented patient preferences.

directive policy numberdir_pol_nbr

The unique insurance policy identifier associated with coverage terms governing services related to a patient's advance directive, such as hospice or palliative care benefits. Used during claims processing to validate eligibility and apply the correct benefit rules for directive-driven care service claims.

PreviousPage 52 of 142Next