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 end timehx_end_tm

The specific time of day marking the conclusion of a historical clinical event or administrative record. Used in encounter, procedure, and scheduling history data to capture when a past appointment, surgical procedure, or clinical service ended, enabling precise duration calculations and workflow audit tracking.

history entered byhx_ent_by

The identifier of the user or system that originally created or submitted a historical record in a healthcare data system. Used in EHR, claims, and enrollment audit logs to maintain data provenance, support compliance reviews, and trace the source of past clinical or administrative data entries.

history ethnicityhx_ethn

The ethnicity classification associated with a patient or member as recorded at a specific historical point in time. Used in clinical, enrollment, and population health records to support retrospective demographic analysis, health equity reporting, and compliance with federal data collection requirements such as OMB standards.

history expiration datehx_exp_dt

The calendar date on which a historical record, authorization, credential, or benefit became invalid or expired. Used in claims, prior authorization, member enrollment, and provider credentialing history systems to identify when a past entitlement or approval period ended and to support retroactive eligibility verification.

history external identifierhx_ext_id

The cross-system reference ID assigned by an external platform to a past medical event record. Enables matching and reconciliation of historical clinical data across EHR systems, HIEs, and data warehouses when the internal identifier alone is insufficient for interoperability.

history faxhx_fax

The facsimile number associated with a past medical event record, typically linked to the facility, provider, or contact responsible for the historical encounter. Used to route clinical documents such as referrals, discharge summaries, or lab results tied to that historical event.

history feehx_fee

The service charge recorded for a past medical event, representing the billed or allowed amount associated with a historical encounter or procedure. Used in retrospective cost analysis, claims adjudication review, and longitudinal financial reporting across patient history records.

history first namehx_first_nm

The given name of the individual associated with a past medical event record, such as a patient or provider linked to that historical encounter. Used to display and verify identity when reviewing historical clinical data across EHR and health information systems.

history flaghx_flg

A binary indicator applied to a past medical event record to signal a specific condition, status, or alert requiring attention. Common uses include marking records as reviewed, flagging abnormal findings, or identifying events relevant to care management or quality reporting workflows.

history frequencyhx_freq

The dosing schedule or recurrence interval recorded for a medication, treatment, or procedure within a past medical event. Captures how often an intervention was administered historically, supporting medication reconciliation, chronic disease management, and longitudinal clinical review.

history full namehx_full_nm

The complete name of the individual associated with a past medical event record, combining given and family name components. Used to clearly identify patients, providers, or contacts when displaying or auditing historical clinical records across health information systems.

history genderhx_gndr

The sex or gender classification recorded at the time of a past medical event. Captures the biological sex or self-identified gender documented during a historical encounter, supporting clinical analysis, longitudinal patient profiling, and demographic reporting across health data systems.

history glucosehx_gluc

The blood glucose measurement recorded during a past medical event, representing a historical point-in-time reading used to track glycemic trends over time. Critical for managing conditions such as diabetes, supporting longitudinal lab result analysis and chronic disease care planning.

history group numberhx_grp_nbr

The insurance group plan identifier associated with a past medical event, capturing the member's health plan group at the time of the historical encounter. Used in claims research, coverage verification, and retrospective eligibility analysis across member enrollment and billing records.

history hemoglobinhx_hgb

The hemoglobin concentration measured and recorded during a past medical event, representing a historical lab value used to assess anemia, oxygen-carrying capacity, and overall hematologic status. Supports longitudinal clinical monitoring and trend analysis in chronic disease management.

history history present illnesshx_hpi

The clinical narrative documenting the patient's description of symptoms, onset, duration, and progression recorded at a past medical event. Captures the HPI as documented during a historical encounter, providing contextual detail essential for longitudinal clinical review and care continuity.

history identifierhx_id

The unique primary key assigned to a past medical event record within the health information system. Used to distinctly identify, retrieve, and link historical clinical data across encounters, claims, and longitudinal patient records in EHR and clinical data warehouse environments.

history indexhx_idx

The sequential position number assigned to a past medical event within an ordered set of historical records. Used to sort, paginate, or rank historical clinical entries by occurrence, priority, or encounter sequence in clinical data systems and longitudinal patient history displays.

history indicatorhx_ind

A coded boolean or categorical value that signals a specific condition, characteristic, or status associated with a past medical event. Used to flag clinically meaningful attributes such as chronic condition presence, prior authorization history, or care gap status in historical records.

history instructionhx_instr

The clinical or administrative guidance text documented in connection with a past medical event, such as discharge instructions, medication directions, or follow-up care notes. Preserves historical patient education and care directives for longitudinal clinical review and care coordination.

PreviousPage 302 of 806Next