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 ratinghx_rtg

Records a historical assessment score or evaluation value assigned to a patient, member, plan, or clinical condition at a prior point in time. Used in care management and underwriting systems to preserve past risk ratings, quality scores, or clinical severity assessments for longitudinal performance and outcomes analysis.

history ratiohx_ratio

Stores a proportional value representing the relationship between two historical clinical or financial metrics. Used in claims analytics and population health systems to preserve past ratios such as medical loss ratios, lab result ratios, or utilization rates, enabling trend comparisons and retrospective performance benchmarking.

history reasonhx_rsn

Captures the documented explanation or justification associated with a historical clinical decision, administrative action, or claim adjustment. Used in EHR, claims, and care management systems to preserve past rationale for denials, treatment changes, or enrollment modifications, supporting audit trails and retrospective case review.

history received datehx_rcvd_dt

Records the date on which a historical document, claim, referral, or authorization request was received by the processing entity. Used in claims and utilization management systems to establish receipt timestamps for past transactions, supporting timeliness compliance tracking, adjudication audit trails, and retroactive dispute resolution.

history referencehx_ref

External pointer or unique identifier linking a historical medical event record to its source system, encounter, or related clinical document. Used in EHR and clinical data warehouses to maintain traceability across longitudinal patient records and audit trails.

history resolution datehx_resol_dt

Date on which a previously documented medical condition, symptom, or clinical problem was resolved or marked inactive in the patient's history. Used in longitudinal care records to define the end boundary of a condition's active period and support chronological clinical reporting.

history respirationhx_resp

Recorded breathing rate, measured in breaths per minute, captured as part of a historical clinical encounter or vital signs assessment. Used in clinical data systems to track respiratory trends over time and support retrospective review of a patient's physiological baseline.

history resulthx_rslt

Outcome value or finding recorded from a past diagnostic test, procedure, or clinical assessment in the patient's medical history. Used in clinical data warehouses to enable longitudinal comparison of lab results, imaging findings, or clinical measurements across encounters.

history review systemshx_ros

Structured documentation of body systems reviewed during a past clinical encounter, capturing the presence or absence of symptoms reported by the patient. Used in EHR history records to support clinical decision-making and retrospective completeness review of historical encounters.

history revisionhx_rev

Version or iteration number indicating how many times a historical medical record entry has been updated or amended since its original creation. Used in clinical data systems to maintain audit integrity and track corrections made to past encounter documentation over time.

history riskhx_rsk

Assessed risk level associated with a past medical event, condition, or clinical finding documented in the patient's history. Used in population health and clinical data systems to stratify patients based on historical risk indicators and inform current care planning decisions.

history routehx_rte

Administration pathway by which a medication or treatment was delivered during a past clinical event, such as oral, intravenous, or topical. Used in medication history records within EHR and pharmacy systems to document how drugs were administered in prior encounters.

history scorehx_scr

Calculated numeric rating derived from a past clinical assessment, risk tool, or standardized scoring instrument documented in the patient's medical history. Used in clinical data warehouses to enable retrospective analysis of patient acuity, functional status, or disease progression over time.

history sequencehx_seq

Numeric ordering value that defines the chronological or logical position of a historical medical event within a series of related clinical records. Used in EHR and clinical data systems to preserve the correct ordering of events such as procedures, diagnoses, or medication changes.

history service datehx_svc_dt

Date on which a clinical service, procedure, or encounter was delivered, as recorded in the patient's historical medical record. Used across EHR, claims, and clinical data warehouses to establish the timeline of care and support longitudinal reporting of past healthcare utilization.

history severityhx_sev

Documented level of seriousness or intensity associated with a past medical condition, symptom, or clinical event in the patient's history. Used in clinical records to characterize how severely a condition affected the patient at a prior point in time and support retrospective clinical review.

history sexhx_sex

Biological sex of the patient as recorded at the time of a past medical event or historical clinical encounter. Used in clinical data systems to ensure accurate context for historical diagnoses, procedures, and lab reference ranges that are sex-specific in their interpretation.

history sourcehx_src

Originating system, facility, provider, or document from which a historical medical record entry was obtained or imported. Used in EHR and clinical data warehouses to identify provenance of past health information, supporting data quality review and patient record reconciliation.

history start datehx_start_dt

Date marking the beginning of a past medical condition, treatment episode, or clinical event as documented in the patient's longitudinal health record. Used in clinical data systems to define the onset boundary of historical diagnoses, medications, or problems for chronological reporting.

history start timehx_start_tm

Timestamp indicating the precise time at which a past medical event, treatment, or clinical encounter began, as recorded in the patient's history. Used in clinical data systems where time-of-day precision is required, such as surgical procedures, medication administration, or emergency events.

PreviousPage 305 of 806Next