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 scheduled timedep_sched_tm

The specific time at which a healthcare appointment or procedure is planned for a dependent covered under a primary insurance subscriber. Used in clinical scheduling systems to coordinate provider availability, manage appointment slots, and support timely care delivery tracking within health plan and clinical operations workflows.

dependent scoredep_scr

A derived numeric value representing a calculated rating or risk assessment associated with an insured dependent, such as a health risk score, chronic condition index, or predictive utilization score. Used in population health management, payer analytics, and care management platforms to stratify dependents for targeted interventions.

dependent sequencedep_seq

An integer value that defines the ordinal position of a dependent within a subscriber's enrollment record or a multi-dependent transaction set. Used in member enrollment, EDI 834 transaction processing, and claims systems to maintain ordered relationships and distinguish between multiple dependents associated with a single subscriber.

dependent service datedep_svc_dt

The specific calendar date on which a covered dependent received a healthcare service, procedure, or prescription. Captured in claims, EHR, and PBM systems to validate eligibility at time of service, support claims adjudication, enforce coordination of benefits, and generate utilization reports for dependent members.

dependent severitydep_sev

A coded or scaled indicator representing the clinical seriousness of a condition, diagnosis, or episode of care associated with an insured dependent. Used in EHR, claims, and population health systems to drive care management prioritization, risk stratification, utilization review, and actuarial modeling for dependent populations.

dependent sexdep_sex

The biological sex recorded for a dependent enrolled under a primary insurance subscriber, typically designated as male, female, or unknown. Used in member enrollment records, claims adjudication, and clinical data systems to support accurate benefit application, gender-specific screening guidelines, and population health reporting.

dependent sourcedep_src

The originating system, file, or entity from which a dependent's demographic or eligibility data was received, such as an employer HR feed, EDI 834 transaction, or state Medicaid enrollment file. Tracked in member enrollment and payer platforms to support data lineage, reconciliation workflows, and audit compliance requirements.

dependent start datedep_start_dt

The effective date marking the beginning of a dependent's coverage eligibility under a subscriber's health insurance plan. Stored in member enrollment and payer systems to validate claims, enforce benefit period boundaries, support EDI 834 processing, and calculate duration of coverage for reporting and compliance purposes.

dependent start timedep_start_tm

The recorded start time of a clinical service, procedure, or encounter for a dependent covered under a primary insurance subscriber. Used in facility and professional claims data to calculate service duration, support anesthesia billing, validate concurrent procedure timelines, and ensure accurate revenue cycle documentation.

dependent statedep_st

The U.S. state or territory recorded as part of the residential or mailing address for a dependent enrolled under a primary insurance subscriber. Used in member enrollment systems to determine applicable state benefit mandates, coordinate network assignments, verify residency for coverage eligibility, and support geographic reporting.

dependent statusdep_sts

A coded value representing the current enrollment or eligibility state of an insured dependent, such as active, terminated, suspended, or pending. Used in member enrollment, payer, and EHR systems to control claims processing eligibility, drive benefit determination logic, and maintain accurate plan participation records for dependent members.

dependent street addressdep_st_addr

The primary street address associated with a dependent enrolled under a primary insurance subscriber. Used in member enrollment and eligibility systems to verify residency for state benefit compliance, coordinate care management outreach, deliver plan correspondence, and validate geographic network eligibility for covered services.

dependent strengthdep_str

The recorded drug concentration or dosage strength of a medication prescribed or dispensed for a dependent covered under a primary insurance subscriber. Captured in pharmacy claims and medication management systems to support drug utilization review, formulary compliance, clinical safety checks, and accurate prescription billing.

dependent subtotaldep_subtot

The partial sum of costs, claims, or benefit amounts calculated for a dependent covered under a primary insurance subscriber before final adjustments, deductibles, or plan-level rollups are applied. Used in claims adjudication and member cost-sharing calculations to support explanation of benefits reporting and financial reconciliation.

dependent system identifierdep_sys_id

The unique system-generated identifier assigned to a dependent within the health plan's enrollment or claims processing platform. Used to consistently reference and link the dependent's eligibility records, claims history, and benefit utilization data across internal and external healthcare information systems throughout the coverage period.

dependent targetdep_tgt

A reference identifier or system destination associated with a dependent record during data routing, transformation, or integration workflows, such as a target payer system, data warehouse table, or downstream claims processor. Used in ETL pipelines and interoperability platforms to direct dependent data to the appropriate processing environment.

dependent taxonomy codedep_tax_cd

A taxonomy code recorded in association with a dependent's enrollment or claims record, typically used to classify the type of coverage or service relationship. While taxonomy codes primarily identify provider specialties in HIPAA transactions, in this context the field may indicate benefit classification or service category relevant to the dependent's coverage.

dependent temperaturedep_temp

The recorded body temperature measurement for a dependent covered under a primary insurance subscriber, typically expressed in degrees Fahrenheit or Celsius. Captured as a vital sign during clinical encounters, this value supports acute illness assessment, infection monitoring, triage protocols, and longitudinal health tracking in clinical data systems.

dependent termination datedep_term_dt

The effective date on which a dependent's health plan coverage ends, triggered by qualifying life events such as aging out, divorce, or loss of subscriber eligibility. Stored in member enrollment and payer systems to halt claims payment, enforce eligibility rules, and support COBRA notifications and regulatory compliance reporting.

dependent timedep_tm

The specific time-of-day value associated with a dependent-related event or transaction, such as a service delivery time or eligibility update. Used in EHR, claims, and member enrollment systems to support precise event sequencing, audit logging, and time-sensitive processing workflows where date alone is insufficient for accurate record management.

PreviousPage 51 of 142Next