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 confidential indicatorguar_conf_ind

A flag that designates a guarantor record as confidential, restricting access to the financially responsible party's personal and financial information. Used in patient registration and revenue cycle systems to protect sensitive data where privacy regulations or patient requests require limited disclosure of guarantor details.

guarantor countguar_cnt

The total number of guarantor records or financial responsibility assignments associated with a patient, account, or defined population. Used in revenue cycle reporting and patient accounting analytics to measure guarantor volume, track registration completeness, and support workload management.

guarantor countryguar_ctry

The country of residence or mailing address for the financially responsible party on a patient account. Captured during patient registration and used in hospital billing systems to support international billing workflows, address validation, and demographic reporting for guarantors residing outside the United States.

guarantor created byguar_crtd_by

Identifies the user account or system process that created the guarantor record in the patient accounting or registration system. Used in audit trails to track data entry accountability for the financially responsible party linked to a patient account.

guarantor created dateguar_crtd_dt

Records the calendar date on which the guarantor record was first established in the patient accounting or registration system. Used in audit tracking and billing workflows to establish when financial responsibility for a patient account was formally assigned.

guarantor created timeguar_crtd_tm

Records the timestamp at which the guarantor record was first established in the patient accounting or registration system. Combined with the creation date, provides a precise audit trail for when financial responsibility for a patient account was formally recorded.

guarantor creatinineguar_cr

Records the serum creatinine lab value for the guarantor, who is the individual financially responsible for a patient account. Captured when the guarantor is also the patient, supporting clinical and billing reconciliation workflows in hospital information systems.

guarantor dateguar_dt

A general-purpose calendar date field associated with the guarantor record in patient accounting systems. Represents a key date relevant to the financially responsible party's account, such as a transaction, review, or status change date within the revenue cycle workflow.

guarantor datetimeguar_dttm

A combined date and time stamp associated with the guarantor record in patient accounting systems. Captures a precise moment relevant to the financially responsible party's account activity, supporting revenue cycle audit trails and billing event sequencing.

guarantor dea numberguar_dea_nbr

Stores the Drug Enforcement Administration registration number associated with the guarantor in cases where the financially responsible party is also a licensed prescriber. Rarely populated in billing contexts but used when guarantor identity overlaps with prescribing credentials.

guarantor death dateguar_death_dt

Records the date of death for the guarantor, the individual financially responsible for a patient account. This date triggers updates to billing workflows, estate collection processes, and account status changes within hospital patient accounting and revenue cycle systems.

guarantor deleted dateguar_del_dt

Records the date on which a guarantor record was logically removed or inactivated in the patient accounting system. Supports audit compliance and data governance by preserving a timestamp of when the financially responsible party record was flagged for deletion.

guarantor deleted indicatorguar_del_ind

A flag indicating whether the guarantor record has been logically deleted or inactivated in the patient accounting system. When set, signals that the financially responsible party record should be excluded from active billing workflows while retained for historical audit purposes.

guarantor descriptionguar_desc

A free-text or coded descriptive field providing additional context about the guarantor in the patient accounting system. May capture relationship details, account notes, or classification information identifying the financially responsible party's role relative to the patient.

guarantor detailguar_dtl

Contains supplementary information about the guarantor record within patient accounting or hospital billing systems. May include extended demographic, financial, or relationship data about the individual or entity responsible for settling a patient's account balance.

guarantor due dateguar_due_dt

The date by which a payment or financial obligation is expected from the guarantor, the party responsible for settling a patient account balance. Used in revenue cycle management to track billing cycles, generate statements, and monitor overdue accounts receivable.

guarantor effective dateguar_eff_dt

The date on which the guarantor's financial responsibility for a patient account becomes active. Used in patient accounting systems to define the start of the billing relationship and ensure charges are routed to the correct responsible party during the revenue cycle.

guarantor emailguar_eml

The electronic mail address on file for the guarantor, the individual financially responsible for a patient account. Used in patient accounting and revenue cycle systems to deliver billing statements, payment reminders, and account notifications electronically.

guarantor end dateguar_end_dt

The date on which the guarantor's financial responsibility for a patient account concludes. Used in patient accounting systems to define the termination of a billing relationship, supporting transitions between guarantors or the closure of an account in the revenue cycle.

guarantor end timeguar_end_tm

The precise time at which the guarantor's financial responsibility for a patient account concludes. Combined with the end date, provides an exact timestamp for closing or transferring billing responsibility in patient accounting and revenue cycle management systems.

PreviousPage 129 of 325Next