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 dea numbersnomed_dea_nbr

The Drug Enforcement Administration registration number linked to a SNOMED CT concept code record, typically associated with controlled substance prescribing or provider identification. Used to cross-reference DEA credentials with standardized clinical terminology entries in pharmacy and prescribing systems.

snomed death datesnomed_death_dt

The recorded date of patient death associated with a SNOMED CT clinical concept code entry. Used in clinical data systems to link mortality events to standardized SNOMED CT diagnoses or findings, supporting mortality reporting, outcome analysis, and population health surveillance.

snomed deductible amountsnomed_ded_amt

The insurance deductible dollar amount associated with a SNOMED CT coded clinical service or diagnosis. Used to link standardized clinical terminology codes to patient financial responsibility data in systems that integrate clinical coding with healthcare claims and benefits adjudication workflows.

snomed deleted datesnomed_del_dt

The calendar date on which a SNOMED CT clinical concept code record was marked as deleted or retired within the system. Used in clinical terminology lifecycle management to track code inactivation events, supporting data governance, audit trails, and version control processes.

snomed deleted indicatorsnomed_del_ind

A flag indicating whether a SNOMED CT clinical concept code record has been logically deleted or inactivated within the system. Supports soft-delete functionality in clinical terminology databases, allowing historical records to be retained for audit and reporting while excluding retired codes from active use.

snomed descriptionsnomed_desc

The human-readable textual description associated with a SNOMED CT clinical concept code, providing the preferred term or synonym for the encoded clinical finding, procedure, or diagnosis. Used to display standardized clinical terminology in EHR interfaces, clinical documentation, and interoperability messaging.

snomed detailsnomed_dtl

Granular supplementary information associated with a SNOMED CT clinical concept code record, capturing additional attributes or metadata beyond the core code and description. Used in clinical data systems to provide extended context for coded clinical findings, procedures, or diagnoses in patient records.

snomed discharge datesnomed_dsch_dt

The date on which a patient was discharged from a clinical encounter or inpatient stay, associated with a SNOMED CT coded diagnosis or finding. Used to link discharge events to standardized clinical terminology codes for outcomes tracking, episode-of-care analysis, and inpatient reporting.

snomed due datesnomed_due_dt

The target or deadline date associated with a SNOMED CT coded clinical activity, follow-up, or payment obligation. Used in clinical workflow and care management systems to track when actions related to a SNOMED CT coded condition or service are expected to be completed or resolved.

snomed durationsnomed_dur

The measured length of time associated with a SNOMED CT coded clinical finding, condition, or procedure. Used in clinical documentation and analytics to capture how long a patient experienced a coded diagnosis or finding, supporting chronic disease management, treatment planning, and outcomes reporting.

snomed effective datesnomed_eff_dt

The date on which a SNOMED CT clinical concept code becomes active and valid for use within a system or clinical context. Used in terminology lifecycle management to govern when a code may be applied to clinical documentation, claims coding, or interoperability transactions, ensuring version-appropriate code usage.

snomed emailsnomed_eml

Email address associated with a SNOMED CT clinical concept record, used to contact the responsible clinician or entity linked to a coded finding, procedure, or diagnosis within clinical terminology management and EHR documentation workflows.

snomed emergency indicatorsnomed_emerg_ind

Flag identifying whether a SNOMED CT coded clinical event, encounter, or procedure was performed under emergency circumstances. Used in clinical documentation and claims processing to differentiate urgent care episodes from routine encounters for triage and billing purposes.

snomed end datesnomed_end_dt

Date on which a SNOMED CT coded clinical condition, finding, or procedure was resolved, discontinued, or concluded. Used in longitudinal patient records to track the duration and resolution of diagnoses, symptoms, or treatments captured using standardized SNOMED CT terminology.

snomed end timesnomed_end_tm

Timestamp marking the conclusion of a SNOMED CT coded clinical event, procedure, or observation. Used in clinical documentation to precisely capture procedure duration and care episode boundaries for audit, billing, and continuity of care purposes.

snomed enrollment statussnomed_enrl_sts

Indicates the active or inactive participation status of a SNOMED CT code within a clinical terminology value set, care program, or clinical decision support rule set. Used to manage terminology lifecycle and ensure only approved codes are applied in active clinical workflows.

snomed entered bysnomed_ent_by

Identifies the clinician, coder, or system user who recorded a SNOMED CT coded finding, diagnosis, or procedure into the clinical record. Used for audit trail purposes to ensure accountability and accuracy of clinical terminology entry in EHR and HIS environments.

snomed ethnicitysnomed_ethn

Patient ethnicity classification recorded alongside a SNOMED CT coded clinical event, supporting population health analysis, health equity reporting, and clinical research. Enables stratification of outcomes by demographic group using standardized SNOMED CT ethnicity concepts.

snomed expiration datesnomed_exp_dt

Date on which a SNOMED CT clinical concept code becomes inactive or retired within the terminology release cycle. Used in terminology management systems to prevent application of deprecated codes in clinical documentation, decision support, and interoperability workflows.

snomed external identifiersnomed_ext_id

Cross-reference identifier linking a SNOMED CT concept to a corresponding code in an external clinical terminology system such as ICD-10, LOINC, or RxNorm. Supports interoperability and semantic mapping across disparate healthcare systems and data exchange frameworks.

PreviousPage 649 of 806Next