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 allowed amountgdln_alwd_amt

Maximum reimbursable dollar value established within a clinical or payer guideline for a specific service, procedure, or care pathway. Used in utilization management and claims adjudication to evaluate whether billed charges align with guideline-driven cost benchmarks and to support medical necessity reviews and prior authorization decisions.

guideline amountgdln_amt

Monetary value specified within a clinical or administrative guideline representing a cost threshold, reimbursement target, or financial benchmark for a defined service or care intervention. Used in utilization management, value-based care programs, and claims processing to assess cost alignment with evidence-based care standards.

guideline approved bygdln_appr_by

Identifier of the individual, committee, or governing body that formally authorized a clinical or administrative guideline for use within the organization. Used in clinical knowledge management systems to maintain accountability, support regulatory compliance, and provide an audit trail for guideline governance and version control processes.

guideline arrival timegdln_arrv_tm

Timestamp recording when a patient arrived at a care setting, used as a benchmark reference for applying time-sensitive clinical guidelines such as sepsis protocols or stroke pathways. Used in quality reporting and clinical decision support to measure adherence to guideline-mandated intervention windows from patient arrival.

guideline arrived dategdln_arrv_dt

Calendar date on which a patient arrived at a care setting, serving as a baseline reference for initiating guideline-driven care protocols. Used in quality measurement, utilization management, and clinical decision support systems to assess timely adherence to evidence-based care pathways from the point of patient presentation.

guideline assessmentgdln_asmt

The structured clinical evaluation text documenting a clinician's review of an evidence-based practice guideline, capturing whether the recommendation is applicable to a patient's condition, care plan, or treatment pathway within clinical decision support workflows.

guideline balancegdln_bal

The remaining unpaid financial amount associated with a clinical guideline-driven service or intervention, representing the difference between billed charges and payments received, used in healthcare revenue cycle tracking for guideline-linked care activities.

guideline billed amountgdln_bill_amt

The total dollar amount invoiced for a clinical service or intervention performed in adherence to an evidence-based guideline, used in revenue cycle management to correlate guideline compliance with billing activity and reimbursement outcomes.

guideline birth dategdln_birth_dt

The date of birth of the patient or member associated with a clinical guideline evaluation, used to determine age-based eligibility criteria and ensure that guideline recommendations are applied to the appropriate age cohort within care management programs.

guideline blood pressuregdln_bp

The recorded systolic and diastolic arterial pressure measurement captured in the context of a clinical guideline evaluation, used to assess patient compliance with evidence-based hypertension or cardiovascular care protocols and quality benchmarks.

guideline cancelled dategdln_cncl_dt

The date on which a previously initiated clinical guideline recommendation or associated care activity was formally cancelled, used to track care plan changes, measure guideline adherence gaps, and support retrospective quality reporting in care management systems.

guideline categorygdln_cat

The high-level classification grouping assigned to a clinical guideline, such as preventive care, chronic disease management, or behavioral health, used to organize and filter guidelines within care management platforms for population health reporting and quality program administration.

guideline chief complaintgdln_cc

The primary symptom or clinical concern reported by the patient that triggered the evaluation or application of a specific evidence-based guideline, used to link patient-reported symptoms to appropriate care pathways and clinical decision support recommendations.

guideline childgdln_chld

A subordinate or dependent guideline record linked to a parent guideline in a hierarchical clinical decision support structure, used to represent sub-recommendations, nested care steps, or condition-specific branches within a broader evidence-based care protocol.

guideline citygdln_city

The municipality name associated with the location where a clinical guideline-related service or intervention is delivered, used to support geographic analysis of guideline adherence, regional care variation reporting, and population health program targeting.

guideline classgdln_cls

The classification tier assigned to a clinical guideline indicating its strength of evidence, priority level, or applicability category, used to stratify guideline recommendations for clinical decision support, quality program enrollment, and care management workflow prioritization.

guideline codegdln_cd

The standardized alphanumeric identifier assigned to a specific evidence-based clinical guideline, used as a unique reference key to link guideline records across care management systems, quality reporting platforms, and clinical decision support tools for consistent tracking and analysis.

guideline commentgdln_cmt

The free-text notation entered by a clinician or care manager documenting observations, exceptions, or contextual details related to the application or non-application of a clinical guideline, supporting care coordination documentation and retrospective quality review.

guideline completed dategdln_cmpl_dt

The date on which a guideline-recommended clinical service, screening, or intervention was fully performed and documented, used to measure guideline adherence timelines, calculate care gaps, and support HEDIS or similar quality measure reporting within care management programs.

guideline confidential indicatorgdln_conf_ind

A flag indicating that a clinical guideline record or associated patient information is designated as sensitive or restricted, requiring additional privacy controls in accordance with HIPAA regulations or organizational policy, limiting access within clinical and administrative data systems.

PreviousPage 284 of 806Next