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 levelsnomed_lvl

The hierarchical depth position of a SNOMED CT concept within its concept model taxonomy, indicating how specific or broad a clinical term is relative to its parent and child concepts. Used in subsumption queries and clinical grouping logic in analytical systems.

snomed license numbersnomed_lic_nbr

The license or affiliation identifier associated with an organization or user authorized to access and deploy SNOMED CT content. Used in terminology governance and compliance tracking to ensure that SNOMED CT is being used in accordance with licensing agreements.

snomed marital statussnomed_mar_sts

A SNOMED CT-coded value representing a patient's marital or relationship status, drawn from the SNOMED CT concept hierarchy for personal relationship status. Used in clinical documentation to capture structured demographic context alongside coded clinical findings.

snomed master identifiersnomed_mstr_id

The enterprise-level master identifier that uniquely links a SNOMED CT concept across multiple clinical systems, terminology servers, and data repositories. Supports consistent cross-system identification of clinical concepts in federated health information environments.

snomed maximumsnomed_max

The upper boundary value defined for a SNOMED CT-coded attribute or value range, such as the maximum numeric measurement associated with a clinical observable or reference range bound. Used in clinical decision support rules tied to SNOMED CT observable entities.

snomed medical record numbersnomed_mrn

The patient medical record number associated with a clinical record that contains a SNOMED CT-coded entry. Used to link standardized clinical terminology back to a specific patient encounter or longitudinal record in EHR and clinical data warehouse systems.

snomed middle namesnomed_mid_nm

The middle name or initial of an individual associated with a SNOMED CT-related record, such as a terminology author or clinical contributor. Used in identity resolution and audit trail management within terminology governance and clinical data attribution workflows.

snomed minimumsnomed_min

The lower boundary value defined for a SNOMED CT-coded attribute or value range, such as the minimum numeric threshold associated with a clinical observable. Used in clinical decision support and reference range logic tied to SNOMED CT-coded measurements.

snomed mobilesnomed_mob

The mobile phone number associated with an individual linked to a SNOMED CT record, such as a terminology contributor or clinical system contact. Used in terminology governance, stakeholder notification, and support workflows within clinical informatics teams.

snomed modified bysnomed_mod_by

The user identifier or system account that last updated a SNOMED CT concept record, mapping entry, or terminology configuration. Used in audit logging to track accountability for changes made to clinical terminology data in EHR and terminology management systems.

snomed modified datesnomed_mod_dt

The date and timestamp of the most recent update to a SNOMED CT concept record, mapping, or associated configuration. Used in version control, audit tracking, and change management processes to monitor terminology maintenance activity in clinical data systems.

snomed modified timesnomed_mod_tm

Timestamp recording when a SNOMED CT concept record was last updated in the clinical terminology database. Tracks changes to code attributes, mappings, or relationships and supports version control and audit trails in EHR and clinical data warehouse environments.

snomed namesnomed_nm

Human-readable label assigned to a SNOMED CT concept, used to display clinical findings, disorders, procedures, or observable entities in EHR interfaces and clinical documentation. Supports clinician recognition and accurate interpretation of coded clinical data across healthcare information systems.

snomed notesnomed_nt

Free-text annotation associated with a SNOMED CT concept record, providing supplemental clinical context, usage guidance, or mapping clarifications. Used by terminology administrators and clinical informaticists to document non-standard usage or system-specific implementation details within clinical data repositories.

snomed numbersnomed_nbr

Numeric identifier assigned to a SNOMED CT concept, serving as a unique reference key used to link clinical observations, diagnoses, and procedures across EHR, claims, and clinical data warehouse systems. Enables interoperability and consistent retrieval of standardized clinical terminology records.

snomed onset datesnomed_onset_dt

Date on which the clinical condition, symptom, or finding represented by a SNOMED CT concept was first observed or reported for a patient. Captured in clinical documentation to support disease progression tracking, epidemiological analysis, and longitudinal care management within EHR systems.

snomed oxygen saturationsnomed_o2sat

Peripheral blood oxygen saturation level recorded as a vital sign observation and coded using a SNOMED CT concept. Expressed as a percentage of hemoglobin carrying oxygen, this value is captured in clinical flowsheets, inpatient monitoring, and respiratory care documentation within EHR systems.

snomed paid amountsnomed_pd_amt

Dollar amount reimbursed or paid in connection with a clinical service coded using a SNOMED CT concept. Used in healthcare financial systems to reconcile payments against clinical terminology-coded encounters, supporting cost analysis and revenue cycle reporting across claims and clinical data platforms.

snomed paid datesnomed_pd_dt

Date on which payment was issued for a clinical service associated with a SNOMED CT coded encounter or procedure. Used in revenue cycle management and financial reporting systems to track reimbursement timelines and reconcile claims activity linked to standardized clinical terminology codes.

snomed parentsnomed_prnt

Identifier referencing the hierarchically superior SNOMED CT concept from which a child concept inherits attributes via the IS-A relationship. Used in clinical terminology management to navigate ontological hierarchies, support subsumption queries, and enable consistent grouping of related clinical concepts across healthcare systems.

PreviousPage 651 of 806Next