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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

history keyhx_key

The lookup reference value used to retrieve or link a past medical event record within a database or data dictionary. Functions as a relational identifier connecting historical clinical entries to associated records such as diagnoses, procedures, or member profiles across health data systems.

history labelhx_lbl

The human-readable display text assigned to a past medical event record, providing a descriptive name or category for presentation in clinical interfaces and reports. Used to render historical data in a meaningful, user-friendly format across EHR dashboards and health information systems.

history languagehx_lang

The preferred or documented communication language recorded in connection with a past medical event, typically reflecting the patient's primary language at the time of the historical encounter. Supports culturally competent care review, translation needs assessment, and longitudinal patient profiling.

history last namehx_last_nm

The family surname of the individual associated with a past medical event record, such as a patient or provider linked to that historical encounter. Used for identity verification, record matching, and display when reviewing or auditing historical clinical data across health information systems.

history legal namehx_legal_nm

The official registered legal name associated with a historical record, such as a prior member enrollment, provider credential, or patient identity entry. Used to maintain accurate audit trails when names change due to marriage, legal proceedings, or administrative corrections in healthcare systems.

history levelhx_lvl

The hierarchical position or tier assigned to a historical record within a structured data model, such as a clinical encounter, benefit plan, or organizational hierarchy. Used to determine the precedence, scope, and inheritance of rules or attributes across nested healthcare data structures.

history license numberhx_lic_nbr

The professional license number recorded at a specific point in time for a practitioner or facility, capturing prior credential states. Used in provider credentialing and claims adjudication to validate licensure status that was active during a historical period of service delivery.

history marital statushx_mar_sts

The recorded marital status of a member or patient at a prior point in time, preserved for longitudinal tracking of demographic changes. Used in member enrollment and eligibility systems to support coordination of benefits determinations, dependent coverage reviews, and historical reporting.

history master identifierhx_mstr_id

The enterprise master person or record identifier assigned to a historical entry, linking it to a canonical identity across disparate healthcare systems. Used in master data management to reconcile duplicate records, support longitudinal patient matching, and maintain referential integrity across data sources.

history maximumhx_max

The upper boundary value recorded for a historical data element, such as a dosage ceiling, benefit limit, or clinical measurement threshold captured at a prior point in time. Used in pharmacy benefit management, utilization review, and clinical decision support to evaluate past policy or clinical constraints.

history medical record numberhx_mrn

The medical record number assigned to a patient at a prior point in time or at a previous facility, preserved for longitudinal identity tracking. Used in clinical data integration and patient matching workflows to link historical encounters to the correct patient across health system transitions or mergers.

history middle namehx_mid_nm

The middle name or initial recorded for an individual at a prior point in time, capturing historical identity details for a member, patient, or provider. Used in enrollment, credentialing, and identity resolution workflows to support accurate matching when names have changed or were previously recorded differently.

history minimumhx_min

The lower boundary value recorded for a historical data element, such as a minimum dosage, benefit floor, or clinical measurement threshold captured at a prior point in time. Used in pharmacy management, benefit configuration audits, and clinical data analysis to evaluate past thresholds and policy baselines.

history mobilehx_mob

The mobile phone number on record for a member, patient, or contact at a prior point in time, preserved for longitudinal communication tracking. Used in member engagement systems and care management platforms to audit historical outreach attempts and validate current contact information against prior records.

history modified byhx_mod_by

The unique identifier of the user, system, or process that last updated a historical record, providing an audit trail of data stewardship. Used in healthcare data governance and compliance workflows to track accountability for changes made to clinical, administrative, or enrollment records over time.

history modified datehx_mod_dt

The calendar date on which a historical record was last updated, forming part of the audit trail for data governance and compliance. Used in clinical and administrative systems to sequence record changes, support version control, and satisfy regulatory requirements for documentation integrity and traceability.

history modified timehx_mod_tm

The precise timestamp at which a historical record was last updated, providing granular audit trail detail beyond the modification date alone. Used in clinical documentation, claims processing, and enrollment systems to sequence concurrent updates and resolve conflicts in high-volume data transaction environments.

history namehx_nm

The display name or label associated with a historical record, such as a prior plan name, diagnosis description, or facility name captured at a specific point in time. Used in reporting and data presentation layers to render human-readable historical context within clinical, administrative, or claims-based workflows.

history notehx_nt

Free-text annotation or comment associated with a historical record, capturing contextual details not represented in structured data fields. Used in clinical documentation, utilization management, and member services workflows to preserve qualitative observations, administrative decisions, or care coordination notes tied to past events.

history numberhx_nbr

A reference number assigned to a historical record to uniquely identify it within a sequence or series, such as a prior authorization number, claim sequence, or encounter reference captured at a past point in time. Used in claims and utilization management systems to link related historical transactions and support audit retrieval.

PreviousPage 303 of 806Next