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

authorization charge amountauth_chrg_amt

The estimated or actual dollar amount associated with the service or procedure covered under a prior authorization request. Used in utilization management and revenue cycle systems to validate that billed charges align with the approved service scope and to support financial forecasting for authorized care.

authorization effective dateauth_eff_dt

The date on which a prior authorization becomes valid and services may begin under its approval in payer, EHR, and utilization management systems. Used by data engineers to enforce date-range validation during claims adjudication, build authorization eligibility checks, and support coverage period analytics across claims and PBM data pipelines.

authorization medical record numberauth_mrn

The unique patient medical record number linked to a prior authorization request, used to associate the approved service with the correct patient record. Supports cross-system matching between utilization management, clinical documentation, and claims processing workflows.

authorization scheduled dateauth_sched_dt

The calendar date on which the authorized service or procedure is planned to be performed. Used in utilization management and scheduling systems to ensure services are rendered within the authorization validity window and to coordinate care delivery with payer approval timelines.

authorization scheduled timeauth_sched_tm

The specific time of day at which the prior-authorized service or procedure is planned to occur. Used alongside the scheduled date in care coordination and scheduling systems to confirm appointment alignment with authorization approval periods and facility resource availability.

authorization street addressauth_st_addr

The physical street address of the facility or location where the authorized service is approved to be rendered. Used in utilization management systems to validate that care is delivered at the payer-approved site, supporting compliance with network requirements and location-specific authorization terms.

authorization unitauth_unt

The standardized unit of measure associated with an approved service authorization, such as days, visits, or procedures, within utilization management and claims platforms. Critical for data engineers validating that claim line units submitted by providers align with authorized units in prior authorization records during adjudication.

bad debt amountbad_debt_wrtoff_amt

The dollar amount of patient accounts receivable determined to be uncollectable after reasonable collection efforts, representing services rendered but for which payment was not received due to patient inability or unwillingness to pay. Bad debt amounts are tracked separately from charity care in hospital financial reporting and affect net revenue calculations and operating margin analytics.

balance addressbal_addr

The full physical address associated with the account or entity carrying an outstanding balance, such as a patient, guarantor, or payer. Used in billing and accounts receivable systems to route statements, collections correspondence, and payment notices to the correct mailing location.

balance approval statusbal_appr_sts

The current approval or review state of an outstanding balance, indicating whether the amount has been validated, disputed, written off, or approved for collection. Used in revenue cycle and accounts receivable systems to manage balance resolution workflows and payer adjudication follow-up.

balance charge amountbal_chrg_amt

The gross charge amount associated with an outstanding balance on a patient or payer account. Used in revenue cycle management to track billed service costs before adjustments, payments, or contractual write-offs are applied, supporting reconciliation and accounts receivable reporting.

balance effective datebal_eff_dt

The date on which an outstanding balance became active or was established on a patient or payer account. Used in accounts receivable and billing systems to determine aging buckets, calculate interest or late fees, and track the start of collection timelines for unpaid amounts.

balance group numberbal_grp_nbr

The insurance group identifier associated with the payer account responsible for an outstanding balance. Used in billing and claims follow-up systems to link unpaid amounts to the correct employer group plan, supporting secondary billing, remittance matching, and payer-specific balance resolution.

balance medical record numberbal_mrn

The unique patient medical record number linked to an outstanding account balance, used to associate unpaid amounts with the correct patient's clinical and financial record. Supports cross-functional workflows between revenue cycle, billing, and clinical documentation systems for accurate balance attribution.

balance scheduled datebal_sched_dt

The date on which a payment, adjustment, or balance resolution activity is scheduled to occur on an outstanding account. Used in accounts receivable and billing systems to manage payment plan schedules, anticipated write-offs, and follow-up timelines for unpaid patient or payer balances.

balance scheduled timebal_sched_tm

The specific time associated with a scheduled payment or balance resolution event on an outstanding account. Used in revenue cycle systems alongside the scheduled date to coordinate automated payment processing, patient billing calls, or payer follow-up activities at a precise point in time.

balance street addressbal_st_addr

The street-level mailing address tied to the account or guarantor responsible for an outstanding balance. Used in patient billing, collections, and accounts receivable systems to direct invoices, dunning notices, and payment communications to the correct physical location for balance resolution.

balance unitbal_unt

The unit of measure applied to an outstanding balance amount in healthcare billing and accounts receivable. Defines whether the balance is tracked per claim, per service line, per day, or per encounter, ensuring accurate reconciliation across revenue cycle and financial reporting systems.

batch identifierbatch_id

A unique value identifying a specific batch of records submitted or processed together in a healthcare data system. Used in EDI transaction sets, claims submission batches, and ETL processing runs to group related records and support batch-level error handling and reprocessing.

bed account numberbed_acct_nbr

The unique account identifier assigned to a specific inpatient bed within a hospital or facility. Used in bed management systems to link patient assignments, billing charges, occupancy tracking, and census reporting to a distinct bed location across admissions and clinical workflows.

PreviousPage 37 of 325Next