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 account numbersnomed_acct_nbr

Unique account reference identifier associated with a SNOMED CT code record within a healthcare organization's terminology management system. Used to link SNOMED clinical concepts to internal financial, administrative, or licensing accounts for tracking and reconciliation purposes.

snomed active indicatorsnomed_actv_ind

Boolean flag indicating whether a specific SNOMED CT concept or code is currently active and valid for use in clinical documentation, coding, and terminology mapping. Inactive codes have been deprecated and should not be applied to new clinical records or transactions.

snomed active statussnomed_actv_sts

The current lifecycle state of a SNOMED CT concept within the terminology system, indicating whether the concept is active, retired, or pending review. Governs which SNOMED codes are permissible for use in clinical documentation, interoperability standards, and EHR coding workflows.

snomed addresssnomed_addr

Physical or logical location information associated with a SNOMED CT code record, which may reference the publishing authority, terminology server location, or organization responsible for maintaining the concept within a clinical terminology management infrastructure.

snomed adjustment amountsnomed_adj_amt

The monetary adjustment value applied to a transaction associated with a SNOMED CT-coded clinical concept, such as a diagnosis or procedure. Used in claims processing and revenue cycle systems to reconcile billing amounts tied to SNOMED-mapped clinical services.

snomed admission datesnomed_admn_dt

The date a patient was admitted to a healthcare facility in the context of a clinical event coded using SNOMED CT terminology. Associates inpatient admission timing with specific SNOMED-coded diagnoses or clinical findings for clinical data analysis and reporting.

snomed agesnomed_age

The patient's age associated with a clinical event or condition documented using a SNOMED CT concept code. Used in clinical analytics and terminology-based reporting to stratify SNOMED-coded diagnoses, findings, or procedures by patient age for population health analysis.

snomed allowed amountsnomed_alwd_amt

The maximum reimbursable dollar amount approved for a clinical service or procedure associated with a SNOMED CT-coded concept. Used in claims adjudication to establish payer-determined reimbursement limits for services mapped to standardized SNOMED clinical terminology.

snomed amountsnomed_amt

The monetary value associated with a clinical service, procedure, or finding represented by a SNOMED CT concept code. Captures the financial component linked to SNOMED-coded clinical events within claims processing, cost analysis, or healthcare reimbursement workflows.

snomed approval statussnomed_appr_sts

The authorization or review state of a SNOMED CT concept within a terminology governance workflow, indicating whether the concept has been approved for use, is under review, or requires validation. Supports terminology stewardship and clinical coding quality management processes.

snomed approved bysnomed_appr_by

The identifier or name of the user, committee, or authority that authorized a SNOMED CT concept for use within a healthcare organization's terminology system. Supports terminology governance, audit trail requirements, and quality assurance in clinical coding and EHR data management.

snomed arrival timesnomed_arrv_tm

The precise time a patient physically arrived at a clinical facility, recorded against a SNOMED CT concept code. Used in EHR encounter records to measure wait times, throughput efficiency, and care timeline accuracy for quality reporting and operational analytics.

snomed arrived datesnomed_arrv_dt

The calendar date on which a patient arrived for a clinical encounter, linked to a SNOMED CT concept code. Used in EHR and clinical data warehouses to establish encounter timelines, support care gap analysis, and enable longitudinal patient history reporting across episodes of care.

snomed assessmentsnomed_asmt

The clinician's structured or free-text evaluation of a patient's condition, mapped to a SNOMED CT concept. Captures diagnostic impressions documented during an encounter, supporting clinical decision support, care coordination, and population health analytics in EHR and HIS environments.

snomed balancesnomed_bal

The remaining financial obligation associated with a SNOMED CT-coded clinical service after insurance payments and adjustments have been applied. Used in revenue cycle management to track patient responsibility balances and reconcile billing records against expected reimbursements for coded encounters.

snomed billed amountsnomed_bill_amt

The total gross charge submitted to a payer for a clinical service identified by a SNOMED CT concept code. Represents the provider's full list price before contractual adjustments, used in claims processing and revenue cycle analytics to measure billing activity for coded clinical events.

snomed birth datesnomed_birth_dt

The patient's date of birth associated with a SNOMED CT-coded clinical record. Used to calculate age at time of encounter, support age-based clinical logic, validate eligibility, and enable demographic stratification in population health reporting and clinical quality measure calculations.

snomed blood pressuresnomed_bp

The systolic and diastolic arterial pressure measurement recorded during a clinical encounter and associated with a SNOMED CT vital sign concept code. Used in EHR systems for chronic disease monitoring, hypertension management, clinical decision support, and quality measure reporting.

snomed cancelled datesnomed_cncl_dt

The date on which a SNOMED CT-coded clinical service, order, or encounter was formally cancelled. Used in EHR and scheduling systems to track appointment cancellations, discontinued orders, and care plan modifications, supporting operational reporting and utilization analysis.

snomed categorysnomed_cat

The high-level grouping classification assigned to a SNOMED CT concept, such as clinical finding, procedure, or observable entity. Used to organize coded clinical data for retrieval, filtering, and reporting across EHR systems and clinical data warehouses supporting terminology management workflows.

PreviousPage 647 of 806Next