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 countgdln_cnt

The total number of clinical guideline instances, recommendations, or associated encounters recorded for a patient or population within a defined time period, used for reporting guideline utilization, measuring care management program reach, and supporting quality performance analysis.

guideline countrygdln_ctry

The country associated with the location where a guideline-driven clinical service is rendered or where the patient resides, used to support international care management program administration, cross-border population health reporting, and geographic compliance tracking.

guideline created bygdln_crtd_by

The unique identifier of the user, clinician, or system that initially created the clinical guideline record, used to establish accountability and traceability within care management workflows, audit trails, and clinical data governance processes across healthcare information systems.

guideline created dategdln_crtd_dt

The calendar date on which a clinical guideline record was first entered into the system, used to establish the timeline of guideline initiation, support audit and compliance reviews, and measure care management program responsiveness from initial guideline creation to completion.

guideline created timegdln_crtd_tm

The precise timestamp at which a clinical guideline record was first created in the system, used alongside the created date to support detailed audit logging, workflow sequencing, and operational reporting within care management and clinical decision support platforms.

guideline creatininegdln_cr

Serum creatinine value recorded in the context of a clinical practice guideline, used to assess renal function thresholds that determine patient eligibility, dosing adjustments, or care pathway recommendations within disease management protocols.

guideline dategdln_dt

Calendar date associated with a clinical practice guideline event or action, such as the date a guideline was issued, reviewed, or applied to a patient care plan within a disease management or quality measure tracking program.

guideline datetimegdln_dttm

Precise timestamp combining date and time associated with a clinical practice guideline event, capturing when a guideline was triggered, applied, or recorded in a disease management system or clinical decision support workflow.

guideline dea numbergdln_dea_nbr

Drug Enforcement Administration registration number associated with a prescribing clinician referenced within a clinical practice guideline, used to identify and verify prescriber authority for controlled substance recommendations in care management programs.

guideline death dategdln_death_dt

Date of patient death recorded in the context of a clinical practice guideline or disease management program, used to close open guideline records, terminate care interventions, and support outcomes reporting and population health analytics.

guideline deleted dategdln_del_dt

Date on which a clinical practice guideline record was logically removed or inactivated within the disease management system, supporting audit trail requirements and enabling historical tracking of when guideline records were withdrawn from active use.

guideline deleted indicatorgdln_del_ind

Boolean flag indicating whether a clinical practice guideline record has been logically deleted or inactivated within the disease management system, allowing soft-delete functionality while preserving historical data for audit and compliance reporting.

guideline descriptiongdln_desc

Human-readable text describing the clinical practice guideline, including its clinical purpose, target patient population, and care recommendations, used to communicate guideline intent within disease management platforms and clinical decision support systems.

guideline detailgdln_dtl

Granular clinical or administrative information associated with a specific practice guideline, capturing supplementary data points such as measurement results, intervention notes, or compliance criteria used within disease management and care coordination workflows.

guideline discharge dategdln_dsch_dt

Date a patient was discharged from an inpatient or facility setting as recorded within a clinical practice guideline workflow, used to trigger post-discharge care protocols, follow-up interventions, and transitions-of-care guideline actions in disease management programs.

guideline due dategdln_due_dt

Target date by which a clinical guideline action, intervention, or outreach must be completed for a patient enrolled in a disease management or quality improvement program, used to drive care coordinator workqueues and compliance tracking.

guideline durationgdln_dur

Length of time over which a clinical practice guideline applies to a patient, such as the recommended treatment window or monitoring period, used in disease management programs to define intervention timelines and measure adherence to care protocols.

guideline emailgdln_eml

Electronic mail address associated with a patient, caregiver, or care team member within a clinical guideline or disease management record, used to facilitate outreach communications, appointment reminders, and guideline-driven health education delivery.

guideline emergency indicatorgdln_emerg_ind

Flag identifying whether a clinical practice guideline action or patient condition has been designated as urgent or emergent, used to prioritize care coordinator interventions and escalate outreach within disease management and care management platforms.

guideline end dategdln_end_dt

Date marking the conclusion of a clinical practice guideline's applicability to a patient, such as the end of a monitoring period or care intervention window, used in disease management systems to close active guideline records and assess completion.

PreviousPage 285 of 806Next