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

snomed resolution datesnomed_resol_dt

The date on which a SNOMED CT-coded clinical condition, problem, or finding was resolved, inactivated, or marked as no longer active. Used in problem list management and longitudinal patient records to track the lifecycle of diagnoses and clinical conditions with standardized terminology.

snomed respirationsnomed_resp

The patient breathing rate or respiratory pattern recorded as a SNOMED CT-coded clinical observation, typically expressed as breaths per minute. Captured during clinical assessments and vital sign documentation, supporting standardized exchange of respiratory findings across EHR and clinical monitoring systems.

snomed resultsnomed_rslt

The outcome or finding value returned for a SNOMED CT-coded clinical observation, test, or procedure, such as a lab result, diagnostic finding, or assessment outcome. Enables structured representation of clinical results linked to standardized concepts for interoperability, reporting, and quality measurement.

snomed review systemssnomed_ros

The structured review of organ systems documented using SNOMED CT-coded clinical concepts, capturing patient-reported symptoms or absence of symptoms across body systems during a clinical encounter. Supports standardized documentation of the review of systems component in clinical history and physical records.

snomed revisionsnomed_rev

The version or iteration number associated with a SNOMED CT concept or clinical record update, indicating modifications made to coded clinical content. Used in clinical data governance to track changes to SNOMED-coded entries over time, supporting audit trails and version-controlled clinical documentation.

snomed risksnomed_rsk

The clinical risk level or danger classification associated with a SNOMED CT-coded condition, patient factor, or care scenario, such as fall risk or surgical risk stratification. Used in care planning and clinical decision support to document and communicate standardized risk assessments across healthcare settings.

snomed routesnomed_rte

The administration pathway encoded using SNOMED CT terminology, indicating how a medication or substance is delivered to the patient, such as oral, intravenous, or topical. Used in medication administration records and pharmacy systems to standardize route documentation for clinical safety and interoperability.

snomed scheduled datesnomed_sched_dt

The planned calendar date for a SNOMED CT-coded clinical event, such as a procedure, follow-up visit, or diagnostic test. Used in clinical scheduling and care coordination workflows to track anticipated service dates linked to standardized clinical concepts, supporting care planning and appointment management.

snomed scheduled timesnomed_sched_tm

The planned clock time associated with a SNOMED CT-coded clinical event, such as a procedure, medication administration, or patient appointment. Used alongside the scheduled date to enable precise clinical scheduling and workflow coordination, ensuring accurate timing documentation for time-sensitive clinical activities.

snomed scoresnomed_scr

A calculated numeric value derived from a clinical assessment tool and encoded using SNOMED CT terminology, such as APGAR, Glasgow Coma Scale, or risk stratification scores. Used to document structured clinical evaluations in a standardized format enabling cross-system comparison and quality reporting.

snomed sequencesnomed_seq

The ordinal position or sequential order assigned to a SNOMED CT-coded clinical item within a series, such as the order of diagnoses on a problem list, procedure steps, or coded observations in a clinical dataset. Ensures correct processing order and logical organization of coded clinical content.

snomed service datesnomed_svc_dt

The date on which a clinical service was rendered and documented using a SNOMED CT code. Links the standardized clinical terminology to a specific point of care event, enabling longitudinal tracking of diagnoses, procedures, and clinical findings across encounters.

snomed severitysnomed_sev

Indicates the clinical severity level of a condition or finding as expressed through SNOMED CT terminology. Captures gradations such as mild, moderate, or severe to support clinical decision-making, risk stratification, and outcomes measurement across patient populations.

snomed sexsnomed_sex

The biological sex classification associated with a SNOMED CT-coded clinical concept. Used to contextualize diagnoses, findings, or procedures where biological sex is clinically relevant, supporting sex-specific reporting, epidemiological analysis, and care appropriateness validation.

snomed sourcesnomed_src

Identifies the originating system, dataset, or clinical document from which a SNOMED CT-coded concept was captured. Supports data provenance tracking, enabling analysts to assess reliability, reconcile duplicate records, and trace clinical terminology back to its point of origin.

snomed start datesnomed_start_dt

The date marking the onset or initiation of a clinical condition, finding, or intervention represented by a SNOMED CT code. Used in longitudinal clinical analysis to establish the beginning of a diagnosis episode, symptom period, or treatment timeline within patient records.

snomed start timesnomed_start_tm

The specific time of day at which a SNOMED CT-coded clinical event, procedure, or finding began. Captures intra-day temporal precision necessary for sequencing clinical events, calculating procedure durations, and supporting time-sensitive clinical documentation requirements.

snomed statesnomed_st

The US state or territory associated with a SNOMED CT-coded clinical record or reporting entity. Used in geographic analysis of clinical data, enabling regional disease surveillance, population health reporting, and jurisdiction-specific compliance with clinical terminology standards.

snomed statussnomed_sts

Indicates the current clinical or administrative status of a SNOMED CT-coded concept, such as active, inactive, resolved, or refuted. Tracks whether a diagnosis, finding, or procedure remains clinically relevant or has been superseded, aiding care coordination and longitudinal record accuracy.

snomed street addresssnomed_st_addr

The street-level address associated with a SNOMED CT-coded clinical record or related entity, such as a care site or service location. Supports geographic data enrichment and location-based analysis of clinical events documented with SNOMED CT terminology in healthcare datasets.

PreviousPage 653 of 806Next