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

benefit unitbnft_unt

The standardized unit of measurement applied to a covered healthcare service or item, such as days, visits, milligrams, or units. Used in EHR, PBM, and claims systems to enforce benefit limits, calculate utilization, and apply quantity restrictions in adjudication and reporting workflows.

bill addressbill_addr

The full street address associated with a billing record, identifying where invoice or payment correspondence should be directed. Used in revenue cycle management to route statements to the correct payer, guarantor, or facility, and to validate billing entity location data during claim adjudication.

bill approval statusbill_appr_sts

The current authorization or review state of a billing record, indicating whether the bill has been approved, pending review, rejected, or requires correction. Used in revenue cycle workflows to manage billing queue prioritization, track accounts receivable status, and support audit and compliance reporting.

bill charge amountbill_chrg_amt

The gross dollar amount charged on a billing record before adjustments, contractual allowances, or payer discounts are applied. Used in revenue cycle management to establish the billed charge baseline for claim submission, reimbursement negotiation, and financial reconciliation against expected payment amounts.

bill effective datebill_eff_dt

The date on which a billing record becomes active or financially valid, marking the start of the billing period for the associated service or charge. Used in revenue cycle management to establish payment timelines, apply correct fee schedules, and support accurate aging of accounts receivable.

bill group numberbill_grp_nbr

The insurance group identifier associated with a billing record, linking the bill to a specific employer group or health plan contract. Used in claim submission and revenue cycle operations to route bills to the correct payer plan, apply group-specific benefits, and support employer billing reconciliation.

bill medical record numberbill_mrn

The unique patient medical record number linked to a billing record, connecting the financial transaction to the corresponding clinical encounter. Used in revenue cycle management to ensure accurate patient matching, support charge capture reconciliation, and enable cross-referencing between clinical documentation and billing data.

bill scheduled datebill_sched_dt

The anticipated calendar date on which a billing record is planned to be generated or submitted. Used in revenue cycle management to coordinate billing cycles, manage claim submission timelines, and track whether bills are produced on schedule relative to service dates and payer filing deadlines.

bill scheduled timebill_sched_tm

The planned clock time at which a billing record is scheduled to be generated or submitted within a billing cycle. Used in revenue cycle systems to sequence automated billing processes, manage batch claim submissions, and coordinate timing across multiple payers or billing entities within a healthcare organization.

bill street addressbill_st_addr

The street-level physical address recorded on a billing record, identifying the location of the patient, guarantor, or service site for invoicing purposes. Used in revenue cycle management to ensure accurate statement delivery, validate service location for payer billing rules, and support geographic reporting of billed services.

bill unitbill_unt

The discrete unit of measure applied to a line item on a billing record, such as a single visit, procedure, day, or quantity of supplies. Used in revenue cycle management to quantify billed services, calculate total charges, and ensure submitted units align with payer-specific billing guidelines and coverage policies.

business keybus_key

A unique identifier used by a healthcare business to identify an entity such as a member, provider, or claim. Examples include member ID, NPI number, claim number, and drug NDC code. Business keys are preserved in data warehouses as natural keys alongside system-generated surrogate keys for data lineage.

capacity addresscap_addr

The physical street address associated with a facility or service location at which capacity limits are tracked. Used in healthcare operations management to identify where maximum volume constraints apply, support network planning, and enable geographic analysis of service availability across care settings.

capacity agecap_age

The age value associated with a capacity record, typically representing an age-based eligibility threshold or demographic constraint tied to a maximum service volume limit. Used in health plan operations and facility management to apply age-specific capacity rules and ensure appropriate service allocation across member populations.

capacity allowed amountcap_alwd_amt

The maximum dollar amount permitted under a capacity constraint for reimbursement of services at a given location or within a defined period. Used in health plan financial management to enforce benefit caps, model budget impact of volume limits, and reconcile actual payments against contractually defined capacity ceilings.

capacity amountcap_amt

The total monetary value associated with a capacity record, representing the financial measure of a maximum volume or throughput limit. Used in healthcare operations and financial planning to quantify resource constraints, support budget forecasting, and analyze the cost implications of capacity limits on service delivery.

capacity approval statuscap_appr_sts

The current authorization or review state indicating whether a capacity limit or allocation has been approved, is pending review, or has been denied. Used in healthcare operations management to govern changes to service volume ceilings, track approval workflows, and ensure capacity decisions align with contractual and regulatory requirements.

capacity approved bycap_appr_by

The identifier of the user, role, or authority that authorized a capacity limit or allocation decision. Used in healthcare operations and compliance workflows to maintain an audit trail of capacity approvals, support accountability reporting, and ensure that volume or resource constraints are sanctioned by appropriate personnel.

capacity arrival timecap_arrv_tm

The recorded clock time at which a patient or resource arrives relative to a capacity-tracked service event. Used in facility and operations management to measure throughput, assess demand against available capacity at specific time intervals, and support scheduling optimization and wait time reduction initiatives.

capacity arrived datecap_arrv_dt

The date a patient physically arrived at a facility location tracked within a capacity management system. Used to monitor throughput against maximum occupancy thresholds, measure door-to-bed intervals, and identify bottlenecks in patient flow and bed assignment workflows.

PreviousPage 46 of 325Next