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 classrng_cls

Designates the classification tier of a normal value range, such as critical, borderline, or standard, within a clinical reference interval framework. Used in lab information systems and EHRs to stratify result interpretation and prioritize clinical response based on severity levels.

range coderng_cd

A standardized alphanumeric identifier assigned to a specific normal value range within clinical or laboratory information systems. Used to uniquely reference and retrieve defined thresholds across EHR, LIS, and data warehouse environments for result interpretation and reporting.

range coinsurance amountrng_coins_amt

Represents the patient's coinsurance responsibility calculated within a defined cost range for a healthcare service or claim. Used in insurance billing and benefits administration systems to determine member cost-sharing obligations based on contractual plan tiers and service categories.

range commentrng_cmt

Stores free-text annotations associated with a defined normal value range, providing clinical context or exceptions not captured in structured fields. Used in laboratory and EHR systems to document range-specific notes, methodology caveats, or clinician guidance for result interpretation.

range completed daterng_cmpl_dt

Records the date on which a normal value range definition or associated clinical workflow was finalized and marked complete. Used in clinical data management systems to track lifecycle milestones of reference intervals and ensure accurate versioning of active range records.

range confidential indicatorrng_conf_ind

A binary flag indicating whether a specific normal value range or its associated data is designated as confidential within clinical systems. Governs access controls in EHR and data warehouse environments, ensuring sensitive range configurations are restricted to authorized clinical users.

range copay amountrng_cpay_amt

Specifies the fixed patient copayment amount applicable within a defined service or benefit range in healthcare insurance systems. Used in claims processing and member benefits administration to calculate patient out-of-pocket costs based on plan-defined copay tiers and service thresholds.

range countrng_cnt

Tracks the total number of occurrences or records associated with a specific normal value range within a clinical or analytical dataset. Used in reporting and quality management systems to measure the frequency of range utilization, exceptions, or related clinical events across populations.

range countryrng_ctry

Identifies the country associated with a geographically defined normal value range, reflecting population-specific clinical benchmarks. Used in international clinical data systems and research databases to apply country-appropriate reference intervals for laboratory results and vital sign interpretation.

range created byrng_crtd_by

Captures the user identifier of the individual who created a specific normal value range record in a clinical or laboratory information system. Supports audit trail requirements, accountability tracking, and change management workflows in EHR and data governance environments.

range created daterng_crtd_dt

Records the calendar date on which a normal value range was initially created and entered into a clinical or laboratory information system. Used for version control, audit trail maintenance, and historical analysis of reference interval configurations across healthcare data platforms.

range created timerng_crtd_tm

Captures the precise timestamp at which a normal value range record was created within a clinical or laboratory system. Used alongside the created date to support detailed audit trails, concurrency management, and sequencing of reference interval changes in healthcare data environments.

range creatininerng_cr

Defines the acceptable minimum and maximum creatinine concentration thresholds used to assess kidney function in clinical laboratory systems. Values outside this range flag potential renal impairment, guiding clinical decision-making for diagnosis, medication dosing, and chronic kidney disease management.

range daterng_dt

The calendar date associated with a reference range definition in clinical laboratory or diagnostic systems. Captures when a specific normal value interval was recorded or applied, supporting time-based tracking of range validity across clinical data workflows.

range datetimerng_dttm

The combined date and time stamp associated with a reference range entry in clinical laboratory or diagnostic systems. Captures the precise moment a normal value interval was recorded or modified, enabling accurate temporal tracking in clinical data warehouses.

range dea numberrng_dea_nbr

The Drug Enforcement Administration registration number associated with a reference range record in pharmacy or clinical systems. Links controlled substance prescribing authority to specific normal value limits, supporting regulatory compliance and audit tracking across healthcare data systems.

range death daterng_death_dt

The date of death associated with a patient record linked to a clinical reference range. Used in longitudinal clinical data analysis to establish the end of a patient's active range applicability period, supporting mortality tracking and outcomes reporting in healthcare data warehouses.

range deductible amountrng_ded_amt

The insurance deductible dollar amount associated with a reference range record in healthcare claims or benefits systems. Captures the member financial threshold tied to a range transaction, supporting cost-sharing calculations and financial reporting across health plan data workflows.

range deleted daterng_del_dt

The calendar date on which a reference range record was marked as deleted within a clinical or laboratory information system. Supports data governance and audit trail requirements by preserving the timestamp of logical record removal across healthcare data management workflows.

range deleted indicatorrng_del_ind

A flag indicating whether a reference range record has been logically removed from active use in a clinical or laboratory information system. Enables soft-delete functionality, allowing historical range data to be retained for audit and compliance purposes without appearing in active reporting.

PreviousPage 556 of 806Next