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 engineers & architects.

Back to Glossary

Domain

Member

Enrollment, eligibility, demographics and plan attribution

2,781 member terms

beneficiary datetimebenf_dttm

The combined date-time value for a insurance coverage recipient. Used to track temporal information related to beneficiary datetime. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary dea numberbenf_dea_nbr

The drug enforcement administration number for a insurance coverage recipient. Used as a unique reference to identify and track the beneficiary across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary death datebenf_death_dt

The date of death for a insurance coverage recipient. Used to track temporal information related to beneficiary death date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary deductible amountbenf_ded_amt

The insurance threshold value for a insurance coverage recipient. Used to capture financial data associated with beneficiary transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary deleted datebenf_del_dt

The record deletion date for a insurance coverage recipient. Used to track temporal information related to beneficiary deleted date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary deleted indicatorbenf_del_ind

The removal status flag for a insurance coverage recipient. Used to track the current state or condition of the beneficiary. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary descriptionbenf_desc

The textual explanation for a insurance coverage recipient. Used to display and describe the beneficiary in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary detailbenf_dtl

The specific information for a insurance coverage recipient. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary due datebenf_due_dt

The payment deadline date for a insurance coverage recipient. Used to track temporal information related to beneficiary due date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary durationbenf_dur

The time span length for a insurance coverage recipient. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary effective datebenf_eff_dt

The active beginning date for a insurance coverage recipient. Used to track temporal information related to beneficiary effective date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary emailbenf_eml

The electronic mail address for a insurance coverage recipient. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary emergency indicatorbenf_emerg_ind

The urgent status flag for a insurance coverage recipient. Used to track the current state or condition of the beneficiary. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary end datebenf_end_dt

The completion date value for a insurance coverage recipient. Used to track temporal information related to beneficiary end date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary end timebenf_end_tm

The completion time value for a insurance coverage recipient. Used to track temporal information related to beneficiary end time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary enrollment statusbenf_enrl_sts

The membership state for a insurance coverage recipient. Used to track the current state or condition of the beneficiary. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary entered bybenf_ent_by

The data entry user for a insurance coverage recipient. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary ethnicitybenf_ethn

The cultural classification for a insurance coverage recipient. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary expiration datebenf_exp_dt

The validity end date for a insurance coverage recipient. Used to track temporal information related to beneficiary expiration date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

beneficiary external identifierbenf_ext_id

The external system reference id for a insurance coverage recipient. Used as a unique reference to identify and track the beneficiary across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for beneficiary management and reporting.

PreviousPage 7 of 140Next