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

guarantor active statusguar_actv_sts

A categorical value representing the current lifecycle status of a guarantor account, such as Active, Inactive, or Deceased. Used in patient accounting and revenue cycle systems to manage billing responsibility, route statements, and determine eligibility for financial assistance programs or collections escalation.

guarantor admission dateguar_admn_dt

The inpatient admission date associated with a guarantor's financial responsibility for a patient encounter. Used in hospital billing and patient accounting to establish the start of the billable episode, link the guarantor to the correct account, and initiate the revenue cycle workflow for the responsible party.

guarantor assessmentguar_asmt

A financial or administrative evaluation of a guarantor's ability to fulfill payment obligations for patient account balances. Used in revenue cycle management and financial counseling workflows to determine eligibility for payment plans, charity care programs, or collections referral based on the guarantor's financial circumstances.

guarantor discharge dateguar_dsch_dt

The inpatient discharge date linked to a guarantor's financial responsibility for a patient account. Used in hospital billing and revenue cycle systems to mark the close of a billable episode, trigger final claim submission, and initiate post-discharge billing statements to the responsible guarantor party.

guarantor durationguar_dur

The length of time a guarantor has been assigned financial responsibility for a patient account, calculated from the assignment date to the current date or account closure. Used in revenue cycle analytics to monitor collection timelines, assess accounts receivable aging, and prioritize follow-up activities for outstanding balances.

guarantor emergency indicatorguar_emerg_ind

Flag identifying whether a guarantor's account requires urgent financial processing or emergency billing attention. Used in patient accounting systems to prioritize collection workflows and ensure timely financial counseling outreach when emergency circumstances affect payment responsibility.

guarantor history present illnessguar_hpi

Narrative field capturing clinical history of present illness associated with the guarantor's account in patient financial services. Used in hospital billing systems to document medical context that may affect financial responsibility determinations, hardship applications, or charity care eligibility assessments.

guarantor instructionguar_instr

Freetext or coded guidance associated with a guarantor's billing account, directing staff on how to handle collections, payment arrangements, or communication preferences. Used in revenue cycle management to ensure consistent account handling and compliance with patient-specific financial agreements.

guarantor labelguar_lbl

Display text or identifier used to distinguish and present the financially responsible party's account within patient accounting and billing systems. Used in revenue cycle workflows to clearly identify guarantor accounts across statements, correspondence, and system interfaces for accurate financial tracking.

guarantor noteguar_nt

Free-text annotation recorded against a guarantor's billing account documenting relevant communications, payment history, disputes, or special handling instructions. Used in patient financial services to maintain an audit trail of account interactions and support revenue cycle staff in managing collections and payment plans.

guarantor procedure dateguar_proc_dt

Date on which a clinical procedure was performed that is associated with the guarantor's financial responsibility for a patient account. Used in hospital billing systems to link service dates to the correct responsible party, ensuring accurate claim submission and coordination of patient financial liability.

guarantor rangeguar_rng

Defined value span or eligibility band associated with a guarantor's financial account, such as income range for sliding-scale fee programs or payment plan brackets. Used in patient financial services to determine appropriate payment tiers, charity care eligibility, and financial assistance program qualification.

guarantor resultguar_rslt

Outcome associated with a financial screening, eligibility determination, or collection action linked to a guarantor's account. Used in revenue cycle management systems to document the results of financial counseling sessions, insurance verification, or payment arrangement negotiations for patient billing purposes.

guarantor routeguar_rte

Designated pathway or method by which billing communications, statements, or collection activities are directed to the financially responsible party. Used in patient accounting systems to manage delivery preferences such as mail, electronic billing, or in-person financial counseling for guarantor account management.

guarantor strengthguar_str

Measure of a guarantor's financial capacity or creditworthiness as assessed during patient financial screening. Used in revenue cycle management to inform payment plan structuring, collection prioritization, and financial assistance eligibility, ensuring appropriate billing strategies are applied to each responsible party's account.

guarantor surgery dateguar_surg_dt

Date on which a surgical procedure was performed that establishes or affects a guarantor's financial liability for the associated patient encounter. Used in hospital billing systems to accurately attribute surgical service costs to the correct financially responsible party and support timely claim submission and billing reconciliation.

guideline active indicatorgdln_actv_ind

Binary flag indicating whether a clinical or administrative guideline is currently active and applicable for use in care delivery or operational decision-making. Used in clinical decision support systems to control which guidelines are presented to clinicians, ensuring only current, approved recommendations influence patient care workflows.

guideline active statusgdln_actv_sts

Current lifecycle state of a clinical or administrative guideline, indicating whether it is active, retired, pending review, or superseded. Used in clinical knowledge management systems to govern which guidelines are available for clinical decision support, quality measurement, and care protocol enforcement across health information platforms.

guideline admission dategdln_admn_dt

Date of inpatient hospital admission used as a reference point for applying time-sensitive clinical guidelines to a patient's care episode. Used in utilization management and clinical decision support systems to trigger guideline-based interventions, length-of-stay benchmarks, and care pathway adherence monitoring from admission through discharge.

guideline agegdln_age

Patient age criterion defined within a clinical guideline that determines the applicable population for a specific recommendation or protocol. Used in clinical decision support systems to filter and present age-appropriate guidelines to care teams, ensuring interventions such as screenings, vaccinations, or dosing protocols align with patient demographics.

PreviousPage 283 of 806Next