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 entered byguar_ent_by

Identifies the user or system that initially entered the guarantor's information into the patient accounting or registration system. Supports data governance and audit compliance by attributing data entry responsibility for the financially responsible party record.

guarantor ethnicityguar_ethn

Records the self-reported or assigned ethnicity of the guarantor, the individual financially responsible for a patient account. Captured during registration to support demographic reporting, health equity analytics, and regulatory compliance requirements in healthcare billing systems.

guarantor expiration dateguar_exp_dt

The date after which the guarantor's designation as financially responsible for a patient account is no longer valid. Used in patient accounting systems to manage the lifecycle of billing relationships and trigger review or reassignment of financial responsibility.

guarantor external identifierguar_ext_id

The cross-system reference ID assigned to the guarantor by an external billing or registration platform. Used to link guarantor records across hospital billing systems, patient accounting software, and revenue cycle management tools when reconciling financial responsibility for patient accounts.

guarantor faxguar_fax

The facsimile number associated with the guarantor responsible for paying a patient's medical bills. Used in patient billing workflows to transmit statements, payment plans, and financial assistance documentation to the party legally accountable for the account balance.

guarantor feeguar_fee

The service charge or administrative fee assessed to the guarantor responsible for a patient's account balance. Used in patient billing and revenue cycle workflows to track fees associated with payment plans, collections processing, or account management beyond standard medical service charges.

guarantor first nameguar_first_nm

The given name of the individual financially responsible for a patient's medical bills, who may or may not be the patient. Used in billing statements, payment correspondence, and collections workflows to properly address the party legally accountable for the outstanding account balance.

guarantor flagguar_flg

A binary indicator applied to a guarantor record in patient billing systems to signal a specific status condition, such as active collections, hardship designation, payment plan enrollment, or deceased status. Used in revenue cycle workflows to route accounts for appropriate financial processing and follow-up.

guarantor full nameguar_full_nm

The complete name, including first, middle, and last name, of the individual financially responsible for a patient's medical bills. Used in billing statements, legal correspondence, payment plan agreements, and collections documentation to formally identify the accountable party.

guarantor genderguar_gndr

The gender identity or sex classification recorded for the individual financially responsible for a patient's medical bills. Used in billing and patient registration systems to ensure accurate demographic records for the guarantor, supporting correspondence and identity verification during payment processing.

guarantor glucoseguar_gluc

The blood glucose measurement recorded for the guarantor, typically captured when the guarantor is also the patient. Used in clinical documentation systems where patient and billing demographics are stored in a shared record, linking financial responsibility data with clinical lab results.

guarantor group numberguar_grp_nbr

The insurance group identifier associated with the guarantor's health plan coverage. Used in patient billing and claims processing to verify the guarantor's insurance benefits, coordinate coverage for dependent patients, and determine the appropriate payer responsible for the account balance.

guarantor hemoglobinguar_hgb

The hemoglobin measurement recorded for the guarantor, typically captured when the guarantor is also the patient. Used in clinical documentation systems where patient and billing demographics share a unified record, linking financial responsibility data with laboratory values.

guarantor identifierguar_ident_id

A unique identifier assigned to the individual or entity responsible for paying a patient's healthcare bills, which may be the patient themselves, a family member, or an employer. The guarantor identifier links billing records to the financially responsible party in patient accounting and revenue cycle systems, and is distinct from the member or subscriber identifier used in insurance eligibility transactions. In data warehouse schemas, the guarantor identifier is a key foreign key in patient billing fact tables and is used in accounts receivable aging analysis and bad debt segmentation.

guarantor indexguar_idx

The sequential position number assigned to a guarantor within a patient account or billing system, used when multiple guarantors exist across a patient's visit history. Supports ordering and retrieval of guarantor records in revenue cycle and patient financial services workflows.

guarantor indicatorguar_ind

A boolean or coded value denoting whether a specific individual or account record has been designated as the financially responsible party for a patient's medical bills. Used in billing registration workflows to flag which party should receive statements and collection activity.

guarantor keyguar_key

The surrogate or natural key value used to uniquely identify and retrieve a guarantor record within patient billing databases and data warehouses. Supports joining guarantor demographic and financial data across revenue cycle tables for reporting, collections tracking, and account management.

guarantor languageguar_lang

The preferred spoken or written language of the individual financially responsible for a patient's medical bills. Used in patient billing and financial counseling workflows to ensure billing statements, payment plan agreements, and collections correspondence are provided in the guarantor's primary language.

guarantor last nameguar_last_nm

The family surname of the individual financially responsible for a patient's medical bills, who may differ from the patient. Used in billing statements, collections correspondence, payment processing, and identity verification workflows within revenue cycle management and patient financial services systems.

guarantor legal nameguar_legal_nm

The officially registered full name of the individual legally responsible for paying a patient's medical bills, as recorded on government-issued identification. Used in collections, financial assistance applications, payment plan agreements, and legal correspondence where formal name verification is required.

PreviousPage 130 of 325Next