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

hcpcs routehcpcs_rte

The method of administration associated with an HCPCS-coded drug or biological service, such as intravenous, intramuscular, or subcutaneous. Used in pharmacy and medical claims processing to validate correct code selection, support dosing audits, and ensure reimbursement aligns with the documented delivery method.

hcpcs strengthhcpcs_str

The drug concentration or dosage strength associated with an HCPCS-coded pharmaceutical or biological product, such as milligrams per milliliter. Used in claims processing and pharmacy benefit management to validate correct HCPCS code selection, support dose-based reimbursement, and detect billing discrepancies in drug administration claims.

hcpcs surgery datehcpcs_surg_dt

The date on which a surgical procedure billed under an HCPCS code was performed. Used in claims adjudication to confirm the service date falls within the authorized coverage period, validate surgical HCPCS code applicability, and support coordination of benefits and global surgery period calculations.

hematology admission datehem_admn_dt

The date a patient was admitted to a facility for hematology-related care, such as treatment for blood disorders including anemia, leukemia, or coagulation conditions. Used to establish the inpatient episode timeline, validate hematology service claims, and support blood disorder-specific utilization and outcomes reporting.

hematology discharge datehem_dsch_dt

The date a patient was released from inpatient or observation care following a hematology-related admission, such as treatment for anemia, leukemia, or coagulation disorders. Used to calculate length of stay and support hematology care episode tracking.

hematology labelhem_lbl

The descriptive display text assigned to a hematology record, test, or procedure, such as a CBC panel name or bone marrow biopsy descriptor. Used to identify and categorize blood study records within clinical and laboratory information systems for workflow and reporting.

hematology procedure datehem_proc_dt

The date on which a hematology-related clinical procedure was performed, such as a bone marrow biopsy, phlebotomy, or apheresis. Used to sequence care events, measure treatment timelines, and support clinical documentation for blood disorder management.

hematology surgery datehem_surg_dt

The date on which a surgical procedure related to a hematologic condition was performed, such as splenectomy for hereditary spherocytosis or lymph node biopsy for lymphoma staging. Used to anchor surgical events within a patient's hematology care timeline.

history active indicatorhx_actv_ind

A binary flag indicating whether a patient's historical medical record, condition, or event is currently active or has been inactivated, voided, or superseded. Used to filter relevant clinical history from archived or deprecated records during care delivery and reporting.

history active statushx_actv_sts

A coded or descriptive value representing the current activity state of a historical medical record or clinical event, such as Active, Inactive, Resolved, or Voided. Used to manage record lifecycle and ensure accurate representation of a patient's longitudinal medical history.

history addresshx_addr

The physical or mailing address associated with a historical patient record or encounter, capturing location data at a prior point in time. Used to support longitudinal member tracking, eligibility verification, and retrospective analysis of care access across geographic locations.

history adjustment amounthx_adj_amt

The monetary value of a financial adjustment applied to a historical claim or transaction, such as a contractual write-off, correction, or retroactive rate change. Used in claims reconciliation and audit processes to account for post-payment modifications in historical billing records.

history admission datehx_admn_dt

The date a patient was formally admitted to a facility during a historical inpatient or observation encounter. Used to establish the start of a care episode in longitudinal records, calculate length of stay, and support retrospective utilization and quality reporting.

history agehx_age

The patient's age, in years, recorded at the time of a historical clinical event or encounter. Used to support age-stratified analysis, retrospective clinical research, and population health reporting where current age differs from the age relevant to a past medical event.

history allowed amounthx_alwd_amt

The maximum reimbursable amount contractually permitted for a service on a historical claim, reflecting the negotiated rate between payer and provider at the time of the encounter. Used in retrospective financial analysis, payment accuracy audits, and cost trend reporting.

history amounthx_amt

The monetary value associated with a historical financial transaction or claim record, representing charges, payments, or adjustments tied to a past medical event. Used in financial reporting, trend analysis, and reconciliation of historical billing activity across care episodes.

history approval statushx_appr_sts

The authorization or approval state of a historical clinical or administrative record, such as Approved, Pending, or Denied, captured at the time of the original transaction. Used to audit prior authorization decisions and track approval workflow outcomes in retrospective reviews.

history approved byhx_appr_by

The identifier or name of the user, clinician, or system that authorized a historical clinical or administrative record. Used in audit trails to establish accountability for approval decisions made on past medical events, orders, or financial transactions in the clinical or claims workflow.

history arrival timehx_arrv_tm

The recorded time at which a patient arrived at a care facility during a historical encounter, such as an emergency department visit or scheduled appointment. Used to measure wait times, assess throughput efficiency, and support retrospective operational and quality analyses.

history arrived datehx_arrv_dt

The calendar date on which a patient arrived at a care facility for a historical encounter. Used alongside arrival time to reconstruct the timeline of past visits, support retrospective access-to-care analysis, and validate encounter records in clinical and administrative data systems.

PreviousPage 299 of 806Next