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 taxonomy codegdln_tax_cd

A structured classification code that categorizes a clinical guideline by specialty, condition type, or care domain, enabling consistent organization and retrieval across health information systems. Used in clinical decision support and quality reporting systems to align guidelines with relevant clinical specialties and care settings.

guideline temperaturegdln_temp

Specifies a body temperature threshold or value referenced within a clinical guideline, such as fever criteria for sepsis screening or hypothermia protocols. Used in clinical decision support systems to trigger condition-specific alerts and interventions when a patient's recorded temperature meets or exceeds guideline-defined thresholds.

guideline termination dategdln_term_dt

Records the calendar date on which a clinical guideline expires, is retired, or ceases to apply to a patient's care plan. Used in care management and clinical decision support systems to automatically deactivate outdated protocols and ensure clinicians are guided only by currently valid evidence-based recommendations.

guideline timegdln_tm

Captures the specific time of day associated with a clinical guideline event, intervention, or evaluation within a patient encounter. Used in clinical decision support and care management systems to enforce time-sensitive protocols, such as medication administration windows or diagnostic screening schedules defined by evidence-based standards.

guideline timestampgdln_ts

Records the precise date and time at which a clinical guideline action was triggered, evaluated, or documented within a health information system. Used in clinical decision support and audit systems to establish a complete temporal record of guideline interactions, supporting compliance reporting and retrospective quality analysis.

guideline titlegdln_ttl

The formal name assigned to a clinical practice guideline, such as a treatment protocol or screening recommendation. Used in care management systems to identify and retrieve specific guidelines governing clinical decision-making and standardized care pathways.

guideline totalgdln_tot

The aggregate numeric value associated with a clinical practice guideline, such as the cumulative score, weighted measure, or combined metric used in quality reporting systems to evaluate adherence to evidence-based care standards across patient populations.

guideline total countgdln_tot_cnt

The total number of instances a clinical practice guideline has been applied, triggered, or referenced within a reporting period. Used in quality management and population health systems to measure guideline utilization and compliance rates across clinical programs.

guideline typegdln_typ

The classification category assigned to a clinical practice guideline, such as preventive care, chronic disease management, or acute treatment protocol. Used in care management systems to organize and filter guidelines by clinical domain, enabling targeted application across patient care workflows.

guideline updated dategdln_upd_dt

The most recent date on which a clinical practice guideline was revised or amended to reflect new evidence, regulatory changes, or organizational policy updates. Used in care management systems to ensure clinicians and staff are referencing the current version of care standards.

guideline urgencygdln_urg

The time-sensitivity classification assigned to a clinical practice guideline, indicating how quickly the recommended intervention or action must be initiated. Used in care management and clinical decision support systems to prioritize guideline-driven alerts and care gap interventions.

guideline versiongdln_ver

The sequential version identifier assigned to a clinical practice guideline, tracking iterative revisions over time. Used in care management and quality reporting systems to ensure proper version control, audit compliance, and accurate attribution of care decisions to the applicable guideline revision.

guideline zipgdln_zip

The postal ZIP code associated with the geographic region or facility for which a clinical practice guideline applies or was issued. Used in population health and care management systems to support regional guideline distribution, geographic reporting, and localized care standard compliance tracking.

gynecology active indicatorgyn_actv_ind

A binary flag indicating whether a gynecological case, referral, or care episode is currently active within the clinical system. Used in EHR and care management platforms to filter active gynecological patient records from closed or historical encounters for reporting and clinical workflow prioritization.

gynecology active statusgyn_actv_sts

The current activity state of a gynecological care record, referral, or treatment episode, such as active, inactive, or suspended. Used in clinical and care management systems to track the lifecycle of gynecological cases and support accurate patient panel management and reporting.

gynecology addressgyn_addr

The physical or mailing address associated with a gynecological care record, such as the patient's home address or the treating facility location. Used in clinical and administrative systems to support correspondence, care coordination, and geographic analysis of gynecological service utilization.

gynecology adjustment amountgyn_adj_amt

The dollar value of financial adjustments applied to a gynecological claim or service transaction, including contractual write-offs, payment corrections, or coordination of benefits adjustments. Used in healthcare billing and claims processing systems to reconcile reimbursement against billed charges.

gynecology admission dategyn_admn_dt

The calendar date on which a patient was admitted to a facility for gynecological care or a related inpatient procedure. Used in clinical and claims systems to establish the episode start date for inpatient gynecological encounters, supporting length-of-stay calculations and billing period determinations.

gynecology agegyn_age

The patient's age at the time of a gynecological encounter, diagnosis, or service. Used in clinical analytics, quality reporting, and population health systems to stratify gynecological care data by age cohort for screening compliance tracking, risk stratification, and outcomes analysis.

gynecology allowed amountgyn_alwd_amt

The maximum dollar amount a health plan will reimburse for a gynecological service based on the contracted fee schedule or benefit design. Used in claims adjudication systems to determine the plan's payment obligation and calculate member cost-sharing responsibilities such as copays and coinsurance.

PreviousPage 290 of 806Next