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 statehx_st

State or province associated with the location where a past medical event occurred or where the patient resided at the time of a historical clinical record. Used in clinical and administrative data systems to support geographic analysis of historical care delivery and member residency.

history statushx_sts

Current state or standing of a historical medical record entry, such as active, resolved, inactive, or cancelled. Used in EHR and clinical data systems to indicate whether a past condition or event remains clinically relevant and to filter records appropriately in longitudinal patient history views.

history street addresshx_st_addr

Street-level address associated with either the patient's residence or the care delivery location at the time of a past medical event. Used in clinical and administrative records to support geographic analysis, care coordination follow-up, and historical documentation of patient or facility location.

history strengthhx_str

Concentration or potency of a medication as documented in a past prescription or medication administration record within the patient's history. Used in pharmacy and EHR medication history systems to capture the exact drug strength dispensed or administered during prior treatment episodes.

history subtotalhx_subtot

Intermediate sum of charges, services, or clinical measurements recorded within a patient's historical medical record segment. Used in claims adjudication and clinical data warehouses to aggregate partial totals before final reconciliation across multiple history record groups.

history surgery datehx_surg_dt

Calendar date on which a previously performed surgical procedure was conducted, as recorded in the patient's past surgical history. Used in clinical documentation and prior authorization workflows to establish surgical timelines, assess post-operative risk, and identify relevant comorbidities.

history system identifierhx_sys_id

Unique system-generated key assigned to a historical medical record entry, enabling cross-system tracking of past clinical events. Used in data integration pipelines to link patient history records across EHR platforms, claims systems, and health information exchanges without duplication.

history targethx_tgt

Reference value or destination endpoint associated with a historical clinical event or metric, such as a treatment goal or care plan objective recorded in past encounters. Used in population health management to compare historical targets against actual outcomes across reporting periods.

history taxonomy codehx_tax_cd

National Uniform Claim Committee (NUCC) taxonomy code identifying the specialty or classification of the clinician or service associated with a historical medical event. Used in claims history analysis to categorize past care by provider specialty and support utilization reporting.

history temperaturehx_temp

Body temperature measurement, recorded in Fahrenheit or Celsius, captured during a past clinical encounter and stored as part of the patient's vital sign history. Used in longitudinal clinical analysis to track fever patterns, monitor chronic conditions, and support retrospective diagnostic review.

history termination datehx_term_dt

Date on which a historical record, enrollment period, benefit, or clinical episode was officially ended or closed. Used in member enrollment, claims processing, and care management systems to define the boundary of a past coverage period or treatment episode for audit and reporting.

history timehx_tm

Time of day, in HH:MM:SS format, associated with a past clinical event or transaction recorded in the patient's medical history. Used in clinical data warehouses and EHR audit logs to establish precise sequencing of historical encounters, orders, and administrative events.

history timestamphx_ts

Combined date and time value marking when a historical clinical event, transaction, or record change occurred. Used in EHR audit trails, claims history systems, and data warehouses to establish an exact chronological record of past medical events for compliance and clinical review.

history titlehx_ttl

Formal label or descriptive name assigned to a historical medical record entry, clinical document, or past encounter type. Used in clinical data management to categorize and display past medical events within patient records, supporting navigation and retrieval across health information systems.

history totalhx_tot

Aggregate sum of all charges, units, services, or clinical measurements associated with a patient's complete historical record segment. Used in claims adjudication and financial reporting to calculate cumulative totals across all historical line items within a defined episode or benefit period.

history total counthx_tot_cnt

Cumulative number of occurrences of a specific clinical event, service, diagnosis, or transaction recorded within a patient's medical history. Used in utilization management and population health analytics to quantify historical service frequency and identify patterns across past care episodes.

history typehx_typ

Classification code or category label that identifies the nature of a historical medical record entry, such as surgical history, family history, medication history, or social history. Used in clinical documentation systems to organize and filter past medical events by category for care coordination and reporting.

history updated datehx_upd_dt

Date on which a historical medical record entry was most recently modified, corrected, or supplemented by a clinician or system process. Used in EHR audit trails and data governance workflows to track record amendments, ensure data integrity, and support regulatory compliance reviews.

history urgencyhx_urg

Coded indicator reflecting the clinical urgency or time-sensitivity level assigned to a past medical event or historical service request, such as routine, urgent, or emergent. Used in care management and utilization review to contextualize historical treatment decisions and triage patterns.

history valuehx_val

Discrete measured or recorded data point associated with a past clinical event, such as a lab result, vital sign reading, or scored assessment captured in the patient's medical history. Used in longitudinal clinical analytics to track changes in patient metrics over time across historical encounters.

PreviousPage 306 of 806Next