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 genderrng_gndr

The biological sex classification used to stratify and apply gender-specific normal value ranges in clinical and laboratory systems. Many reference ranges such as hemoglobin, creatinine, and hormone levels differ between males and females, requiring sex-based range segmentation for accurate diagnostic interpretation.

range glucoserng_gluc

The defined normal value boundaries for blood glucose measurements within clinical or laboratory systems. Specifies acceptable fasting, postprandial, or random glucose thresholds used to assess glycemic status, screen for diabetes, and guide treatment decisions in patient care workflows.

range group numberrng_grp_nbr

The insurance group identifier associated with a defined normal value range configuration. Used to apply population-specific or plan-specific reference range parameters when evaluating clinical results for members belonging to a particular health plan or benefit group.

range hemoglobinrng_hgb

The defined normal value boundaries for hemoglobin concentration in blood, stratified by age, sex, or clinical population. Used in laboratory systems to evaluate oxygen-carrying capacity, identify anemia or polycythemia, and support clinical decision-making in hematology workflows.

range history present illnessrng_hpi

The clinical narrative or contextual condition information associated with establishing a patient-specific normal value range. Captures relevant presenting symptoms or medical history that influence the selection or adjustment of reference range thresholds during diagnostic evaluation.

range identifierrng_id

The unique primary key assigned to a specific normal value range record within a clinical or laboratory information system. Serves as the definitive reference used to retrieve, link, and manage reference range configurations across diagnostic, EHR, and data warehouse environments.

range indexrng_idx

The ordinal position number assigned to a normal value range within a defined sequence or set of reference ranges. Used in laboratory and clinical systems to order, prioritize, or navigate multiple range configurations associated with a single test or clinical parameter.

range indicatorrng_ind

A coded value indicating the status or directional classification of a clinical measurement relative to established normal value range boundaries. Signals whether a result is within normal limits, critically high, critically low, or outside expected thresholds in laboratory reporting systems.

range instructionrng_instr

Guidance text associated with the proper application or interpretation of a clinical normal value range. Provides clinicians and laboratory staff with context-specific directions for evaluating results, handling borderline values, or applying age- and condition-adjusted reference thresholds.

range keyrng_key

The lookup reference value used to retrieve or cross-reference a specific normal value range within clinical data systems. Serves as a relational link between reference range configurations and associated laboratory tests, patient populations, or diagnostic panels in data repositories.

range labelrng_lbl

The human-readable display text used to identify and present a clinical normal value range in laboratory reports, clinical interfaces, and analytical dashboards. Provides a concise, standardized descriptor such as Normal, High, Low, or Critical for result interpretation workflows.

range languagerng_lang

The preferred communication language associated with the display or reporting of a clinical normal value range. Ensures that reference range descriptions, result labels, and instructional text are presented in the appropriate language for the clinician or patient receiving the diagnostic information.

range last namerng_last_nm

The family surname of the individual or clinician associated with a defined normal value range record. Used to identify the responsible contact or approving authority linked to a reference range configuration within laboratory information or clinical data management systems.

range legal namerng_legal_nm

The official registered legal name associated with a reference range definition used in clinical laboratory or diagnostic systems. Provides the formal, standardized label for identifying the range record in compliance and regulatory reporting contexts.

range levelrng_lvl

The hierarchical tier or classification assigned to a clinical reference range, indicating its position within a structured range taxonomy. Used in laboratory and diagnostic systems to organize normal value limits by severity, population group, or clinical priority.

range license numberrng_lic_nbr

A license or certification identifier associated with a clinical reference range definition, typically linking the range to a validated diagnostic standard or accredited laboratory protocol used to establish normal value thresholds in clinical data systems.

range marital statusrng_mar_sts

A demographic attribute used to define or segment clinical reference ranges by marital status, where applicable. Supports population-specific normal value thresholds in laboratory or clinical risk stratification models where this demographic variable affects expected values.

range master identifierrng_mstr_id

The enterprise-level unique identifier assigned to a clinical reference range record across integrated healthcare data systems. Ensures consistent cross-system linking of normal value limit definitions in laboratory, EHR, and clinical data warehouse environments.

range maximumrng_max

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

range medical record numberrng_mrn

The patient medical record number associated with a patient-specific or context-specific clinical reference range. Used to link individualized normal value thresholds to a specific patient record in laboratory or clinical documentation systems.

PreviousPage 558 of 806Next