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 timerng_tm

The specific time of day associated with a clinical reference range record, capturing when normal value limits apply or were recorded to support time-sensitive lab result interpretation and clinical decision support logic.

range timestamprng_ts

The combined date and time value marking when a clinical reference range record was created, modified, or applied, providing a precise audit trail for normal value limit changes used in laboratory result validation and compliance reporting.

range titlerng_ttl

The formal descriptive name assigned to a clinical reference range definition, identifying the specific normal value limit set by its clinical purpose, test type, or patient population context within laboratory and diagnostic information systems.

range totalrng_tot

The aggregate sum of all values calculated across a complete clinical reference range dataset, used in laboratory and quality reporting to summarize measurement distributions and validate completeness of normal value limit configurations.

range total countrng_tot_cnt

The cumulative count of all records or occurrences within a clinical reference range dataset, used in laboratory reporting and data quality audits to verify the completeness and volume of normal value limit entries across patient populations.

range typerng_typ

The classification category assigned to a clinical reference range, distinguishing between types such as age-adjusted, sex-specific, or condition-based normal value limits to ensure appropriate application during lab result interpretation and clinical decision support.

range updated daterng_upd_dt

The most recent date on which a clinical reference range record was modified, providing an audit trail for changes to normal value limits and supporting regulatory compliance, version control, and historical result reprocessing in laboratory systems.

range urgencyrng_urg

The priority level assigned to a clinical reference range alert or result, indicating how quickly clinicians must respond when patient measurements fall outside normal value limits, used in critical value reporting and clinical notification workflows.

range valuerng_val

The specific numerical measurement or boundary point within a clinical reference range, representing either the minimum or maximum acceptable threshold used to evaluate whether patient lab results or vital signs fall within established normal value limits.

range versionrng_ver

The sequential version number assigned to a clinical reference range record, tracking iterative updates to normal value limit definitions and enabling laboratories to apply the correct version of reference standards to historical and current patient results.

range ziprng_zip

The postal code associated with a geographic region used to contextualize clinical reference ranges, supporting population-specific normal value limit configurations where demographic or environmental factors influence expected baseline measurements.

reaction admission daterxn_admn_dt

The date a patient was admitted to an inpatient facility due to an adverse physiological reaction, such as an allergic response or drug reaction, used in clinical and claims records to establish the episode start date for reaction-related care.

reaction discharge daterxn_dsch_dt

The date a patient was discharged from an inpatient facility following treatment for an adverse physiological reaction, used in clinical and claims records to calculate length of stay and close the episode of care associated with the reaction event.

reaction labelrxn_lbl

The standardized display text used to identify and describe a documented adverse reaction in clinical records. Supports consistent presentation of reaction names across allergy tracking, clinical decision support alerts, and patient safety reporting workflows in EHR systems.

reaction procedure daterxn_proc_dt

The calendar date on which a medical procedure was performed in response to or in connection with a documented adverse reaction. Used in clinical documentation to establish care timelines, link treatments to triggering events, and support adverse event analysis in health records.

reaction surgery daterxn_surg_dt

The calendar date on which a surgical intervention was performed as a direct result of or in association with a documented adverse reaction. Supports clinical timeline reconstruction, operative record linkage, and adverse event outcome tracking in surgical and EHR systems.

readmission account numberreadm_acct_nbr

The unique financial account identifier assigned to a patient encounter that qualifies as a hospital readmission, typically within 30 days of a prior discharge. Links billing records, claims submissions, and clinical documentation to a specific unplanned return hospitalization for tracking and reimbursement purposes.

readmission active indicatorreadm_actv_ind

A binary flag indicating whether a readmission record is currently active and valid within the system. Used in hospital billing and quality reporting workflows to filter active readmission encounters from voided, canceled, or historical records during claims processing and outcome measurement.

readmission active statusreadm_actv_sts

A coded value representing the current processing or workflow state of a readmission encounter record, such as open, closed, pending, or discharged. Supports readmission tracking, utilization management reviews, and hospital quality metric reporting across clinical and administrative systems.

readmission addressreadm_addr

The physical or mailing address associated with a readmission encounter record, typically capturing the patient's residential address at the time of the return hospitalization. Used in population health analysis, care coordination outreach, and hospital readmission risk stratification workflows.

PreviousPage 562 of 806Next