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 routerng_rte

Administration pathway boundaries associated with a medication or treatment reference range, such as oral, intravenous, or subcutaneous routes. Used in pharmacy and clinical systems to define appropriate dosing or therapeutic range limits specific to a given route of administration.

range scorerng_scr

Calculated rating boundaries defining normal or acceptable score intervals for clinical assessment tools, such as pain scales, risk indices, or functional status instruments. Used in clinical documentation to interpret scored assessments and flag values requiring clinical intervention or follow-up.

range sequencerng_seq

Ordering number that establishes the positional sequence of a reference range within a series of defined value limits for a laboratory test or clinical measure. Used to organize multiple range definitions, such as age-stratified or condition-specific intervals, within lab and clinical data systems.

range service daterng_svc_dt

Care delivery date associated with the effective period of a clinical or laboratory reference range. Used to determine which normal value limits were applicable at the time a clinical service was rendered, ensuring accurate result interpretation and historical reporting in clinical data systems.

range severityrng_sev

Seriousness classification boundaries within a clinical reference range, distinguishing between mild, moderate, and severe value thresholds for a given condition or measurement. Used in clinical documentation and alerting systems to prioritize patient care responses based on the degree of deviation from normal.

range sexrng_sex

Biological sex classification used to stratify normal value limits within a clinical or laboratory reference range. Many lab tests and vital sign parameters have sex-specific thresholds, requiring separate range definitions for males and females to ensure accurate result interpretation and clinical decision support.

range sourcerng_src

Origin reference identifying the authoritative body, instrument manufacturer, clinical guideline, or institutional protocol from which a reference range's normal value limits are derived. Used in lab and clinical systems to document the evidence basis for accepted thresholds and support range validation audits.

range start daterng_start_dt

Beginning date marking when a clinical or laboratory reference range definition becomes effective within the system. Establishes the start of the period during which the defined normal value limits are valid, supporting accurate historical result interpretation and range lifecycle management in clinical data systems.

range start timerng_start_tm

Beginning timestamp marking the precise time at which a clinical or laboratory reference range definition becomes effective. Used in systems requiring time-level granularity for range transitions, ensuring that test results are evaluated against the correct normal value limits active at the exact moment of collection.

range staterng_st

State or province associated with a geographic or regulatory jurisdiction that governs the applicable reference range standards. Used in clinical and laboratory systems where normal value limits or reporting requirements vary by state-level regulatory frameworks, accreditation bodies, or regional clinical practice guidelines.

range statusrng_sts

Current operational state of a clinical or laboratory reference range definition, indicating whether the range is active, inactive, pending, or superseded. Used to manage the lifecycle of normal value limits within lab and clinical systems, ensuring only valid ranges are applied to result interpretation and reporting.

range street addressrng_st_addr

Street-level location associated with the facility, laboratory, or clinical site for which a specific reference range applies. Used when normal value limits are site-specific, reflecting differences in instrumentation, patient populations, or accreditation standards across physical care delivery locations.

range strengthrng_str

Drug concentration boundaries defining the acceptable therapeutic range for a medication's strength or dosage form. Used in pharmacy and clinical systems to establish normal value limits for drug concentration measurements, supporting medication safety checks, therapeutic drug monitoring, and dosing decisions.

range subtotalrng_subtot

Intermediate sum calculated within a defined subset of clinical reference range values, used in laboratory and diagnostic reporting to aggregate partial results before computing final totals across the complete normal value limits dataset.

range surgery daterng_surg_dt

The calendar date on which a surgical procedure was performed, captured within clinical reference range datasets to correlate operative interventions with applicable normal value limits for post-operative lab and vital sign interpretation.

range system identifierrng_sys_id

Unique system-generated key assigned to a specific clinical reference range record, enabling consistent identification and cross-system linkage of normal value limit configurations across laboratory, EHR, and clinical data warehouse platforms.

range targetrng_tgt

The desired clinical outcome value or benchmark within a reference range definition, representing the optimal measurement goal used in care management protocols, disease management programs, and clinical quality reporting for patient monitoring.

range taxonomy coderng_tax_cd

Standardized classification code used to categorize clinical reference ranges by specialty type or clinical domain, enabling appropriate routing and filtering of normal value limits based on discipline-specific diagnostic or laboratory standards.

range temperaturerng_temp

The acceptable minimum and maximum body temperature measurements defined within clinical reference ranges, used in vital signs monitoring to flag abnormal readings and trigger clinical alerts in patient care and disease management workflows.

range termination daterng_term_dt

The date on which a specific clinical reference range definition becomes inactive or expires, used in laboratory and clinical systems to ensure historical normal value limits are applied correctly to results collected within their valid effective periods.

PreviousPage 561 of 806Next