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 scheduled timeguar_sched_tm

The specific time of day associated with a scheduled patient financial services activity or appointment for a guarantor account. Used alongside the scheduled date in revenue cycle systems to coordinate financial counseling sessions, payment arrangements, and automated billing communication workflows.

guarantor scoreguar_scr

A calculated numeric value representing the creditworthiness, propensity to pay, or financial risk of the guarantor on a patient account. Derived from payment history, demographic factors, or third-party credit data, this score is used in revenue cycle management to prioritize collections and offer appropriate payment options.

guarantor sequenceguar_seq

A numeric value defining the order in which a guarantor record appears or is processed within a patient account containing multiple financially responsible parties. Used in patient accounting systems to control billing statement sequencing, payment allocation order, and collections escalation logic in revenue cycle workflows.

guarantor severityguar_sev

Indicates the seriousness level of a guarantor's account or financial obligation in patient billing systems. Used to prioritize collection efforts and payment plan assignments based on outstanding balance risk or delinquency level associated with the financially responsible party.

guarantor sexguar_sex

Records the biological sex of the guarantor, the individual financially responsible for a patient's medical bills. Used in patient billing and accounts receivable systems to support demographic verification, correspondence personalization, and identity matching across healthcare billing workflows.

guarantor sourceguar_src

Identifies the origin channel through which a guarantor record was established in the patient billing system, such as self-pay registration, insurance referral, or employer sponsorship. Supports traceability and audit workflows in accounts receivable and revenue cycle management.

guarantor start dateguar_start_dt

Records the date on which a guarantor assumed financial responsibility for a patient account in the billing or revenue cycle system. Used to establish the active period of liability, support collections workflows, and calculate aging of financial responsibility in accounts receivable reporting.

guarantor start timeguar_start_tm

Captures the specific time of day when a guarantor's financial responsibility became effective for a patient account. Used in conjunction with guarantor start date to provide precise timestamping for billing system audit trails and revenue cycle transaction logging.

guarantor stateguar_st

Records the U.S. state or territory of the guarantor's mailing or residential address in the patient billing system. Used to route billing statements, apply state-specific billing regulations, verify identity, and support collections compliance requirements for financially responsible parties.

guarantor statusguar_sts

Indicates the current standing of a guarantor's financial responsibility on a patient account, such as active, inactive, deceased, or in collections. Drives billing workflow routing, statement generation, and collections escalation decisions within the revenue cycle management system.

guarantor street addressguar_st_addr

Stores the physical or mailing street address of the guarantor responsible for a patient's healthcare bill. Used in revenue cycle systems to deliver billing statements, support identity verification, enable collections outreach, and comply with billing notification requirements.

guarantor subtotalguar_subtot

Represents a partial sum of financial charges or payments attributed to a guarantor before final adjustments, credits, or additional fees are applied in the patient billing system. Used in revenue cycle reporting to track intermediate balance calculations for accounts receivable management.

guarantor targetguar_tgt

Specifies a designated financial target or collection goal assigned to a guarantor account within the revenue cycle or collections management system. Used to benchmark payment plan progress, prioritize outreach efforts, and measure collection performance against outstanding patient balances.

guarantor taxonomy codeguar_tax_cd

Captures a classification code assigned to a guarantor to categorize their relationship type or financial responsibility category within the billing system. Supports segmentation of patient accounts by guarantor class, enabling targeted billing workflows and revenue cycle reporting by account type.

guarantor temperatureguar_temp

Records a body temperature measurement associated with a guarantor when the guarantor is also the patient receiving care. Bridges clinical and financial records in integrated EHR-billing systems where patient vitals are linked to the responsible party's encounter and account record.

guarantor termination dateguar_term_dt

Records the date on which a guarantor's financial responsibility for a patient account ended in the billing or revenue cycle system. Used to define the close of the liability period, support balance transfer workflows, and maintain accurate accounts receivable aging records.

guarantor timeguar_tm

Captures a specific time value associated with a guarantor-related transaction or event in the patient billing system. Used to timestamp key billing actions such as payment posting, account updates, or collections contacts for audit trail and revenue cycle workflow tracking purposes.

guarantor timestampguar_ts

Records the combined date and time of a significant event or transaction associated with a guarantor account in the billing system. Supports precise audit logging, payment reconciliation, collections activity tracking, and regulatory compliance reporting within the revenue cycle management workflow.

guarantor titleguar_ttl

Stores the formal name prefix or honorific, such as Mr., Mrs., Dr., or Rev., associated with the guarantor in the patient billing system. Used to ensure accurate and respectful correspondence in billing statements, collection notices, and patient financial services communications.

guarantor totalguar_tot

Represents the complete financial amount owed by or attributed to a guarantor on a patient account after all charges, adjustments, and payments are applied in the revenue cycle system. Used in billing statements, collections workflows, and accounts receivable reporting to reflect the net balance due.

PreviousPage 133 of 325Next