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 strengthsnomed_str

The medication concentration or dosage strength associated with a SNOMED CT-coded pharmaceutical concept. Used when SNOMED CT codes represent drug products or substance findings, capturing potency details that inform clinical documentation, medication reconciliation, and pharmacological reporting.

snomed subtotalsnomed_subtot

A partial aggregated count or sum of SNOMED CT-coded clinical events within a defined subset or grouping. Used in clinical analytics and population health reporting to summarize coded findings across subpopulations, time periods, or care settings before final totals are calculated.

snomed surgery datesnomed_surg_dt

The date on which a surgical procedure represented by a SNOMED CT procedure code was performed. Links operative events to standardized clinical terminology, supporting surgical outcomes tracking, episode-of-care analysis, and perioperative quality measurement across clinical datasets.

snomed system identifiersnomed_sys_id

A unique system-generated key assigned to a SNOMED CT-coded record within a clinical or analytical data platform. Enables consistent cross-system referencing, deduplication, and traceability of SNOMED CT concepts across EHR, claims, and clinical data warehouse environments.

snomed targetsnomed_tgt

The intended destination concept, system, or mapping endpoint associated with a SNOMED CT code. Used in clinical terminology mapping workflows to indicate where a SNOMED CT concept translates to, such as ICD or LOINC codes, supporting interoperability and cross-terminology data exchange.

snomed taxonomy codesnomed_tax_cd

A hierarchical classification code that places a SNOMED CT concept within its clinical taxonomy, such as clinical finding, procedure, or body structure. Supports structured navigation of SNOMED CT hierarchies, enabling subsumption queries, grouping of related concepts, and ontology-driven clinical reporting.

snomed temperaturesnomed_temp

The body temperature measurement associated with a SNOMED CT-coded clinical observation or vital sign finding. Captures quantitative temperature values linked to standardized terminology, supporting fever detection, sepsis screening, and longitudinal vital sign analysis within clinical datasets.

snomed termination datesnomed_term_dt

The date on which a SNOMED CT-coded clinical condition, finding, or care episode was concluded, resolved, or inactivated. Used to define the end boundary of a clinical event period, supporting episode duration calculations, remission tracking, and longitudinal outcomes analysis.

snomed timesnomed_tm

The specific time of day recorded for a SNOMED CT-coded clinical event, observation, or finding. Provides temporal precision beyond the date field, enabling chronological sequencing of clinical events, time-of-day pattern analysis, and accurate reconstruction of clinical encounter timelines.

snomed timestampsnomed_ts

The combined date and time value recording when a SNOMED CT-coded clinical event was documented or occurred. Provides full temporal precision for audit trails, event sequencing, and longitudinal clinical analysis, capturing both the calendar date and exact time of the coded clinical activity.

snomed titlesnomed_ttl

The formal descriptive label or preferred term associated with a SNOMED CT concept code. Represents the human-readable name as defined in the SNOMED CT terminology standard, used for display in clinical interfaces, reporting outputs, and data dictionaries to identify coded clinical concepts clearly.

snomed totalsnomed_tot

The aggregated sum of SNOMED CT coded values associated with a clinical record or encounter. SNOMED CT is an international clinical terminology standard used to represent clinical findings, procedures, and diagnoses in electronic health records and interoperability exchanges.

snomed total countsnomed_tot_cnt

The total number of SNOMED CT code occurrences recorded for a patient, encounter, or clinical event. Used in clinical analytics to measure diagnostic or procedural coding frequency and support population health reporting across clinical data repositories.

snomed typesnomed_typ

The classification category assigned to a SNOMED CT concept, distinguishing between clinical hierarchies such as clinical findings, procedures, body structures, or observable entities. Drives clinical decision support logic and semantic interoperability in EHR and health information exchange systems.

snomed unitsnomed_unt

The unit of measure associated with a SNOMED CT observable entity or clinical finding, such as mg/dL or mmHg. Used in clinical documentation and lab result systems to define the scale of a recorded clinical measurement mapped to standardized SNOMED CT terminology.

snomed updated datesnomed_upd_dt

The date on which a SNOMED CT concept mapping or clinical record association was last modified or refreshed. Supports version control and audit tracking in clinical terminology management systems to ensure currency with SNOMED CT release cycles.

snomed urgencysnomed_urg

The clinical urgency or priority level encoded using a SNOMED CT concept, indicating the time-sensitivity of a diagnosis, procedure, or referral. Used in care coordination workflows and clinical triage systems to classify the acuity of a coded clinical event.

snomed valuesnomed_val

The specific clinical data point or coded result associated with a SNOMED CT observable entity or finding. Represents the discrete value captured during a patient encounter, such as a measurement result or clinical status, linked to its standardized SNOMED CT terminology code.

snomed versionsnomed_ver

The release version of the SNOMED CT terminology set under which a clinical concept or code was assigned or validated. Critical for maintaining coding accuracy across SNOMED CT release cycles and ensuring consistent clinical data interpretation in longitudinal health records.

snomed zipsnomed_zip

The postal code associated with a SNOMED CT-coded clinical event or patient record location. Used in population health and epidemiological analyses to geographically map the distribution of clinical findings or conditions coded using SNOMED CT terminology standards.

PreviousPage 654 of 806Next