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

guideline labelgdln_lbl

The short descriptive text or display name assigned to a clinical practice guideline for presentation in care management dashboards, member outreach reports, and clinical decision support interfaces. Provides a human-readable summary of the guideline without requiring the full formal guideline name.

guideline languagegdln_lang

The spoken or written language in which a clinical practice guideline or its associated member-facing materials are presented. Used in care management and member outreach systems to ensure guideline communications, educational content, and care gap notifications are delivered in the member's preferred language.

guideline last namegdln_last_nm

The family name or surname of the individual contact, author, or clinical steward associated with a practice guideline record. Used in care management systems to identify and communicate with the accountable clinician or administrator responsible for guideline oversight and updates.

guideline legal namegdln_legal_nm

The officially registered or formally published name of a clinical practice guideline as recognized by the issuing clinical body or regulatory authority. Used in compliance reporting and quality program documentation to ensure accurate attribution to the governing evidence-based standard.

guideline levelgdln_lvl

The hierarchical tier or classification assigned to a clinical practice guideline, indicating its scope, specificity, or position within a structured framework such as national, regional, or condition-specific protocols. Used in care management systems to apply the appropriate level of guideline logic during member stratification and care gap analysis.

guideline license numbergdln_lic_nbr

The official license or accreditation number assigned to a clinical practice guideline by a governing or issuing body. Used to validate guideline authority, track regulatory compliance, and confirm that recommendations meet established clinical or professional standards across care settings.

guideline marital statusgdln_mar_sts

Captures the lifecycle or publication status of a clinical practice guideline, such as draft, active, retired, or superseded. Used in guideline management systems to determine whether a recommendation is currently valid for clinical decision support, care pathway integration, or quality measure application.

guideline master identifiergdln_mstr_id

The enterprise-wide master identifier assigned to a clinical practice guideline, ensuring consistent cross-system reference. Used to link guideline records across clinical decision support tools, quality reporting platforms, and care management applications without duplication or misidentification.

guideline maximumgdln_max

The upper boundary value defined within a clinical practice guideline for a measurable parameter, such as maximum dosage, frequency, duration, or threshold. Used in clinical decision support to enforce evidence-based limits and trigger alerts when patient data or orders exceed recommended safe ranges.

guideline middle namegdln_mid_nm

A secondary or middle component of the official title or name assigned to a clinical practice guideline. Used in guideline cataloging and display systems to distinguish between similarly named recommendations and support accurate search, retrieval, and reference within clinical knowledge management platforms.

guideline minimumgdln_min

The lower boundary value defined within a clinical practice guideline for a measurable parameter, such as minimum dosage, frequency, or threshold. Used in clinical decision support to ensure evidence-based minimums are met and to trigger alerts when patient data or clinical orders fall below recommended values.

guideline mobilegdln_mob

Indicates whether a clinical practice guideline is formatted or accessible for mobile delivery, or stores a mobile contact for the guideline's issuing body or responsible clinical team. Used to support point-of-care access to recommendations via mobile health applications and clinical workflow tools.

guideline modified bygdln_mod_by

The unique identifier of the user, system, or administrator who last updated a clinical practice guideline record. Used in audit trails and change management processes to maintain accountability, track editorial history, and support compliance reviews within clinical knowledge management systems.

guideline modified dategdln_mod_dt

The calendar date on which a clinical practice guideline record was most recently updated or revised. Used in guideline lifecycle management to track version history, identify outdated recommendations, and ensure that clinical decision support systems are referencing current evidence-based content.

guideline modified timegdln_mod_tm

The precise time at which a clinical practice guideline record was most recently updated. Combined with the modified date, this field supports detailed audit logging, version control, and change management workflows in clinical knowledge management and decision support systems.

guideline namegdln_nm

The official human-readable title assigned to a clinical practice guideline. Used across clinical decision support tools, care management platforms, and quality reporting systems to identify and display the recommendation, ensuring consistent reference by clinicians, administrators, and analysts.

guideline notegdln_nt

Free-text or structured annotation associated with a clinical practice guideline record. Used to capture clarifications, exceptions, editorial comments, or implementation guidance that supplements the formal recommendation, supporting accurate interpretation and application in clinical and administrative workflows.

guideline numbergdln_nbr

A unique numeric or alphanumeric reference identifier assigned to a clinical practice guideline. Used to distinguish individual recommendations within a guideline library, support cross-referencing in clinical decision support systems, and facilitate accurate reporting and tracking across care management platforms.

guideline onset dategdln_onset_dt

The date on which a clinical practice guideline becomes effective or was first applicable for clinical use. Used in guideline lifecycle management to determine when a recommendation began governing clinical decisions, supporting version control and retrospective analysis of care delivered under specific guideline versions.

guideline oxygen saturationgdln_o2sat

The recommended blood oxygen saturation threshold or target range specified within a clinical practice guideline. Used in clinical decision support to define acceptable SpO2 parameters for specific conditions or treatments, triggering alerts when patient measurements fall outside evidence-based guideline boundaries.

PreviousPage 287 of 806Next