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

range descriptionrng_desc

The human-readable text label or explanation associated with a clinical reference range definition. Describes the nature, scope, or purpose of the normal value interval in laboratory, diagnostic, or clinical data systems, supporting display and interpretation across healthcare reporting workflows.

range detailrng_dtl

Granular supplemental information associated with a clinical reference range record. Captures specific attributes or contextual data points that further define or clarify the normal value interval within laboratory, diagnostic, or clinical information systems used in healthcare data management.

range discharge daterng_dsch_dt

The hospital or facility discharge date associated with a patient encounter linked to a clinical reference range record. Used in inpatient and outpatient data analysis to correlate normal value limits with episode-of-care boundaries, supporting outcomes and utilization reporting in healthcare systems.

range due daterng_due_dt

The payment or action deadline date associated with a reference range record in healthcare claims or administrative systems. Captures the date by which a financial obligation or required task related to the range must be completed, supporting billing cycle and accounts receivable workflows.

range durationrng_dur

The length of time over which a clinical reference range remains applicable or active within a laboratory or diagnostic information system. Defines the interval between a range's effective and expiration dates, supporting longitudinal analysis of normal value applicability in healthcare data warehouses.

range effective daterng_eff_dt

The date on which a clinical reference range becomes active and applicable within a laboratory or diagnostic information system. Marks the start of the period during which the defined normal value limits are valid for use in clinical decision support, reporting, and result interpretation workflows.

range emailrng_eml

The electronic mail address associated with a contact or entity linked to a clinical reference range record. Used in healthcare administrative and communication workflows to route notifications, updates, or alerts related to normal value limit changes across laboratory or clinical information systems.

range emergency indicatorrng_emerg_ind

A flag denoting whether a clinical reference range is associated with emergency or critical-value conditions in a laboratory or diagnostic system. Identifies ranges requiring urgent clinical response, supporting critical value alerting and escalation workflows in healthcare information and EHR systems.

range end daterng_end_dt

The calendar date on which a clinical reference range ceases to be active or applicable within a laboratory or diagnostic information system. Defines the upper boundary of the range's validity period, supporting version control and historical accuracy in clinical data warehouses and reporting systems.

range end timerng_end_tm

The specific time at which a clinical reference range becomes inactive within a laboratory or diagnostic information system. Provides precise temporal granularity beyond the end date, supporting accurate version control and time-sensitive clinical workflows in healthcare data management environments.

range entered byrng_ent_by

The identifier of the user or system responsible for initially entering a clinical reference range record into a laboratory or healthcare information system. Supports data provenance, accountability, and audit trail requirements by capturing the source of normal value limit data entry.

range ethnicityrng_ethn

The ethnicity classification associated with a patient or population segment for whom a clinical reference range is defined. Used in laboratory and diagnostic systems to apply population-specific normal value limits, accounting for ethnic variation in clinical markers to improve diagnostic accuracy and equity.

range expiration daterng_exp_dt

The date on which a clinical reference range is no longer valid or authorized for use within a laboratory or diagnostic information system. Defines the end of the range's active lifecycle, ensuring that outdated normal value limits are systematically retired and replaced in clinical reporting workflows.

range external identifierrng_ext_id

The cross-system reference identifier assigned to a laboratory or clinical normal value range by an external system. Enables consistent tracking and reconciliation of reference range records across disparate clinical data platforms, LIS, and EHR integrations.

range faxrng_fax

The facsimile number associated with the source or administering entity responsible for defining a clinical normal value range. Used to facilitate communication with laboratories or clinical departments when reference range parameters require clarification or updates.

range feerng_fee

The service charge associated with processing or applying a defined normal value range in clinical or laboratory workflows. May reflect costs tied to specialized reference range panels, age-adjusted calculations, or population-specific threshold evaluations used in diagnostic testing.

range first namerng_first_nm

The given name of the individual or clinician associated with a defined normal value range record. Used to identify the responsible party or contact person linked to a specific reference range configuration within laboratory or clinical information systems.

range flagrng_flg

A binary status marker indicating whether a clinical measurement falls outside the established normal value range thresholds. Used in laboratory and clinical systems to trigger alerts, highlight abnormal results, or initiate follow-up workflows for out-of-range diagnostic findings.

range frequencyrng_freq

The interval or recurrence schedule at which a normal value range is applied, reviewed, or evaluated within clinical workflows. Used in laboratory and chronic disease management systems to determine how often reference range comparisons are performed for ongoing patient monitoring.

range full namerng_full_nm

The complete descriptive name of a clinical normal value range, combining all name components into a single display string. Used in laboratory reporting and clinical data systems to clearly identify and present reference range configurations in a human-readable format.

PreviousPage 557 of 806Next