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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

guarantor total countguar_tot_cnt

Captures the total number of accounts, claims, or transactions associated with a guarantor in the patient billing or revenue cycle system. Used in accounts receivable reporting to measure the volume of financial responsibility held by an individual across multiple patient encounters or service episodes.

guarantor typeguar_typ

Classifies the category of the guarantor responsible for a patient's medical bills, such as self, spouse, parent, employer, or legal guardian. Used in revenue cycle systems to determine billing routing, apply appropriate collection rules, and segment accounts receivable reporting by responsible party relationship.

guarantor unitguar_unt

Identifies the specific billing unit, department, or service line within a healthcare organization to which a guarantor's financial responsibility is assigned. Used in revenue cycle management to allocate outstanding balances, route billing statements, and generate unit-level accounts receivable performance reports.

guarantor updated dateguar_upd_dt

The timestamp recording when a guarantor's account information was last modified in the billing system. Tracks changes to financial responsibility records, including address corrections, contact updates, or payment plan modifications, supporting accurate patient billing and collections workflows.

guarantor urgencyguar_urg

Indicates the priority level assigned to a guarantor's account for billing or collections purposes, such as urgent balance due, pending collections transfer, or standard billing cycle. Drives workflow prioritization in revenue cycle management systems to ensure timely resolution of outstanding patient financial obligations.

guarantor versionguar_ver

A sequential version number tracking the revision history of a guarantor's demographic or financial responsibility record. Enables audit trail maintenance and data reconciliation in patient billing systems by identifying which version of the guarantor record was active at the time of a specific financial transaction or claim submission.

guarantor zipguar_zip

The five or nine digit postal ZIP code associated with the guarantor's mailing or residential address. Used in patient billing and revenue cycle systems to route statements, verify eligibility, determine collection jurisdiction, and support geographic analysis of outstanding patient financial responsibility balances.

guideline addressgdln_addr

The physical or organizational address associated with the authoring or publishing body of a clinical practice guideline. Used in clinical decision support systems to reference the source institution, professional society, or regulatory body responsible for issuing evidence-based care recommendations adopted within the health system.

guideline approval statusgdln_appr_sts

Indicates the current review and authorization state of a clinical practice guideline within the health system, such as draft, under review, approved, or retired. Ensures clinical decision support tools and care protocols reference only validated, governance-approved recommendations that meet institutional and regulatory standards for patient care.

guideline charge amountgdln_chrg_amt

The standard charge associated with services or procedures recommended within a clinical practice guideline. Used in clinical decision support and care management systems to estimate anticipated costs when applying evidence-based protocols, supporting financial counseling, prior authorization workflows, and value-based care cost tracking.

guideline effective dategdln_eff_dt

The date on which a clinical practice guideline becomes active and applicable for use in clinical decision support, care protocols, or quality reporting. Enables version control within health systems to ensure clinicians reference current evidence-based recommendations and that retrospective analyses apply the correct guideline version to historical encounters.

guideline group numbergdln_grp_nbr

A numeric identifier assigned to a category or grouping of related clinical practice guidelines within a health system's decision support framework. Used to organize guidelines by specialty, condition, or care setting, facilitating structured retrieval, reporting on adherence rates, and administration of guideline-based quality improvement programs.

guideline medical record numbergdln_mrn

The patient medical record number linked to a specific application or instance of a clinical practice guideline within the health system. Associates guideline-driven care recommendations with individual patient records, supporting care gap analysis, compliance tracking, and population health reporting at the patient level.

guideline scheduled dategdln_sched_dt

The calendar date on which a guideline-recommended clinical intervention, screening, or follow-up is scheduled to occur for a patient. Used in care management and population health platforms to track adherence to evidence-based care timelines, monitor preventive care gaps, and support outreach for overdue guideline-directed services.

guideline scheduled timegdln_sched_tm

The specific time of day at which a guideline-recommended clinical intervention or patient encounter is scheduled. Used in clinical workflow and care coordination systems alongside the scheduled date to precisely sequence guideline-driven activities, ensuring timely delivery of evidence-based care as part of structured care management protocols.

guideline street addressgdln_st_addr

The street-level mailing or physical address associated with the organization or body that authored or published a clinical practice guideline. Used in clinical knowledge management systems to maintain accurate source attribution, facilitate correspondence with issuing professional societies, and support regulatory documentation requirements for adopted care standards.

guideline unitgdln_unt

The unit of measure or service unit associated with a recommended intervention or procedure within a clinical practice guideline, such as dosage units, visit frequency, or procedure quantity. Used in clinical decision support and order management systems to standardize the application of evidence-based recommendations across patient populations and care settings.

gynecology scheduled dategyn_sched_dt

The calendar date on which a gynecological examination, procedure, or follow-up appointment is scheduled for a patient. Captured in ambulatory scheduling and women's health EHR systems to coordinate reproductive health services, track preventive care compliance such as annual well-woman visits, and support gynecology department capacity planning.

gynecology scheduled timegyn_sched_tm

The specific time of day assigned for a scheduled gynecological appointment or procedure. Used in women's health and ambulatory scheduling systems alongside the scheduled date to allocate clinical resources, manage patient flow within gynecology departments, and coordinate time-sensitive reproductive health services such as colposcopies or fertility consultations.

gynecology unitgyn_unt

Identifies the specific gynecology clinical unit, department, or service line within a healthcare facility where a patient's care is being delivered or assigned. Used in hospital information systems to route orders, allocate nursing staff, track bed assignments, and support specialty-specific reporting for women's health services and gynecologic care outcomes.

PreviousPage 134 of 325Next