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 onset datehx_onset_dt

The date on which a condition, symptom, or clinical event was first observed or reported, as documented in a patient's historical medical record. Used in clinical coding, chronic disease management, and population health analytics to establish disease timelines, calculate duration of illness, and support risk stratification models.

history oxygen saturationhx_o2sat

The recorded peripheral blood oxygen saturation level captured during a historical clinical encounter or vital signs assessment. Used in chronic disease management, inpatient care documentation, and population health analytics to track respiratory status trends over time and support retrospective clinical quality measure evaluation.

history paid amounthx_pd_amt

The dollar amount paid on a historical claim, encounter, or financial transaction at a prior point in time. Used in claims analytics, provider reimbursement reconciliation, and actuarial reporting to evaluate historical payment patterns, identify adjustments, and support financial audits across payer and healthcare system environments.

history paid datehx_pd_dt

The date on which payment was issued for a historical claim or financial transaction, recorded for audit and reconciliation purposes. Used in claims processing, accounts payable, and revenue cycle management systems to track payment timelines, measure prompt pay compliance, and support historical financial reporting and dispute resolution.

history parenthx_prnt

Identifies the superior or parent record in a hierarchical relationship within a patient's past medical history. Used in clinical data systems to link subordinate history entries to a primary event, condition, or episode, enabling accurate longitudinal patient record navigation.

history percentagehx_pct

Stores a ratio expressed as a percentage value associated with a historical clinical or administrative event. Used in clinical data warehouses to capture metrics such as historical benefit utilization rates, clinical measurement percentages, or coverage levels tied to past member or patient records.

history periodhx_prd

Defines the specific time interval or duration associated with a past medical, clinical, or administrative event. Used in longitudinal patient records and claims data to establish the temporal boundaries of a historical condition, treatment episode, or coverage period for trending and analysis.

history phonehx_ph

Records a telephone number associated with a historical patient, member, or provider contact record. Used in member enrollment and clinical data systems to preserve past contact information at a point in time, supporting audit trails and historical communication verification workflows.

history planhx_pln

Captures the documented treatment or care plan strategy associated with a historical clinical encounter or episode. Used in EHR systems to preserve past clinical decision-making, enabling clinicians to review prior therapeutic strategies when evaluating ongoing or recurring patient conditions.

history policy numberhx_pol_nbr

Records the insurance policy identifier associated with a member's historical coverage record. Used in claims and member enrollment systems to link past adjudicated claims or benefit transactions to the specific policy that was active during a prior coverage period for audit and reconciliation purposes.

history preferred namehx_pref_nm

Stores the patient's or member's previously used preferred display name as recorded at a prior point in time. Used in member enrollment and clinical systems to maintain historical identity records, supporting accurate longitudinal matching and audit of demographic changes over time.

history pricehx_prc

Captures the cost or pricing value associated with a historical healthcare service, drug, or benefit transaction. Used in claims and pharmacy data systems to retain past pricing data for cost trend analysis, retrospective audits, and comparison against current reimbursement or formulary pricing structures.

history primary indicatorhx_prim_ind

A flag that designates whether a historical record was the primary entry among multiple related records at a given point in time. Used in clinical and enrollment data systems to identify the principal diagnosis, primary coverage, or main contact record within a set of historical entries.

history priorityhx_prty

Records the importance or urgency ranking assigned to a historical clinical task, condition, or administrative event. Used in care management and clinical workflow systems to preserve past triage or prioritization decisions, supporting retrospective review of how patient needs were ranked and addressed over time.

history procedure datehx_proc_dt

Stores the date on which a clinical procedure was historically performed for a patient. Used in EHR and claims data systems to establish the exact service date of past surgical, diagnostic, or therapeutic procedures, supporting longitudinal care tracking, quality measures, and retrospective utilization analysis.

history pulsehx_pulse

Records a patient's historical heart rate measurement captured during a past clinical encounter or vital signs assessment. Used in EHR and clinical data warehouses to preserve longitudinal vital sign data, enabling trend analysis, chronic disease monitoring, and retrospective clinical decision support for patient care.

history quantityhx_qty

Captures the count or volume value associated with a historical clinical, pharmacy, or administrative transaction. Used in pharmacy and claims data systems to retain past dispensing quantities, units of service, or supply counts, supporting retrospective utilization review, drug adherence analysis, and cost reporting.

history racehx_race

Records the racial or ethnic classification reported for a patient or member at a previous point in time. Used in clinical and member enrollment systems to maintain historical demographic data, supporting longitudinal population health analysis, health equity reporting, and compliance with regulatory demographic data collection requirements.

history rangehx_rng

Stores the minimum and maximum boundary values associated with a historical clinical measurement or administrative parameter. Used in EHR and clinical data warehouses to preserve past reference ranges for lab results or vital signs, enabling retrospective comparison of patient values against applicable normal ranges at the time of service.

history ratehx_rt

Captures the unit cost or reimbursement rate applied to a historical healthcare service or pharmacy transaction. Used in claims and contracting data systems to retain past negotiated or allowed rates for retrospective payment accuracy audits, cost trend analysis, and provider contract performance reporting.

PreviousPage 304 of 806Next