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 middle namerng_mid_nm

The middle name or initial associated with a named clinical reference range definition or its author. Used to fully identify the range record or its attributed source within clinical laboratory documentation and reference range management systems.

range minimumrng_min

The lower boundary value of a clinical reference range, defining the lowest acceptable normal measurement for a given laboratory test or clinical parameter. Values below this threshold may indicate an abnormal or clinically significant result requiring clinical review.

range mobilerng_mob

A mobile phone contact number associated with a clinical reference range record or its responsible party. Used in laboratory and clinical data management systems to enable direct contact for range validation, review, or update notifications.

range modified byrng_mod_by

The user identifier or system account that last updated a clinical reference range record. Supports audit trail requirements in laboratory and clinical data systems by tracking accountability for changes to normal value threshold definitions.

range modified daterng_mod_dt

The calendar date on which a clinical reference range record was last updated or revised. Supports version control and audit tracking in laboratory information systems, ensuring the most current normal value thresholds are applied in clinical decision support.

range modified timerng_mod_tm

The timestamp indicating the exact time a clinical reference range record was last modified. Used alongside the modified date to provide precise audit trail documentation for changes to normal value limit definitions in laboratory and clinical data systems.

range namerng_nm

The human-readable display label assigned to a clinical reference range definition, identifying the specific normal value limit set by name. Used in laboratory reports, clinical dashboards, and data dictionaries to present reference ranges in a meaningful, interpretable format.

range noterng_nt

Free-text annotation or explanatory comment attached to a clinical reference range record. Captures contextual details such as population-specific exceptions, methodology notes, or clinical guidance associated with the interpretation of the defined normal value limits.

range numberrng_nbr

A unique numeric identifier assigned to a clinical reference range record within a laboratory or clinical data system. Used to reference, track, and retrieve specific normal value limit definitions across laboratory information systems and clinical data warehouses.

range onset daterng_onset_dt

The effective start date from which a clinical reference range becomes applicable, indicating when the defined normal value limits were first adopted or became clinically valid for use in laboratory result interpretation and clinical decision support workflows.

range oxygen saturationrng_o2sat

The defined normal value limits for blood oxygen saturation (SpO2) as measured by pulse oximetry or arterial blood gas analysis. Specifies the acceptable minimum and maximum oxygen saturation percentages used to evaluate respiratory and circulatory status in clinical settings.

range paid amountrng_pd_amt

The monetary value paid in association with a reference range service, validation, or licensing transaction. Captured in healthcare financial and administrative systems to track costs related to clinical reference range management, laboratory standard procurement, or diagnostic benchmarking services.

range paid daterng_pd_dt

The calendar date on which payment was processed for a reference range-related service or transaction. Recorded in healthcare financial systems to support accounts payable reconciliation and financial reporting associated with laboratory reference range procurement or validation activities.

range parentrng_prnt

Identifies the hierarchical superior record in a reference range taxonomy, linking a child range definition to its parent category. Used in clinical decision support systems to organize normal value limits into structured hierarchies for lab results, vitals, and diagnostic thresholds.

range percentagerng_pct

Captures the ratio expressed as a percentage that defines acceptable boundaries within a clinical reference range. Used in laboratory and diagnostic systems to express normal value limits as proportional thresholds, supporting result interpretation and clinical alerting for out-of-range findings.

range periodrng_prd

Specifies the time interval or duration over which a clinical reference range is considered valid and applicable. Used in laboratory information systems to define age-specific, seasonal, or condition-specific normal value limits that change over time for accurate result interpretation.

range phonerng_ph

Records the telephone contact number associated with a clinical reference range record, typically linking to the laboratory or clinical department responsible for maintaining or interpreting the normal value limits. Supports operational communication workflows in diagnostic and lab information systems.

range planrng_pln

Describes the clinical or operational strategy associated with managing a specific reference range definition, including protocols for handling values that fall outside normal limits. Used in clinical decision support and laboratory information systems to guide care responses to abnormal results.

range policy numberrng_pol_nbr

Stores the policy or protocol identifier governing the application of a specific clinical reference range. Used in laboratory and clinical data systems to associate normal value limits with institutional or regulatory policies that define acceptable thresholds for diagnostic measurements and test results.

range preferred namerng_pref_nm

Holds the standardized display label assigned to a clinical reference range for use in reporting interfaces and clinical documentation. Used in laboratory information systems to present normal value limit sets in a consistent, human-readable format across EHR displays, lab reports, and clinical dashboards.

PreviousPage 559 of 806Next