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

length of stay variance dayslos_var_days

The difference in calendar days between a patient actual length of stay and the expected or benchmark length of stay for their diagnosis-related group or condition, used to identify outlier cases driving excess utilization, measure the effectiveness of discharge planning interventions, and benchmark facility performance against regional and national norms.

location account numberloc_acct_nbr

The unique account identifier assigned to a specific physical healthcare service site, such as a clinic, hospital, or outpatient facility. Used to link financial transactions, claims, and operational records to the correct facility within billing and healthcare information systems.

location active indicatorloc_actv_ind

A binary flag indicating whether a specific physical healthcare service site is currently active and operational. Used in facility management systems to control which locations are available for scheduling, claims submission, and care delivery, ensuring only valid sites are referenced in transactions.

location active statusloc_actv_sts

The operational status of a specific physical healthcare service site, indicating whether it is currently active, inactive, or suspended. Used in facility and network management to govern eligibility for patient scheduling, claims processing, and provider directory listings across healthcare systems.

location addressloc_addr

Structured physical address of a healthcare service site, including street, city, state, and ZIP code, stored in provider directories, EHR, and claims systems. Used for provider credentialing, claims adjudication, network management, and patient assignment workflows requiring geographic or facility-level data.

location adjustment amountloc_adj_amt

The dollar value of a financial adjustment applied to charges or reimbursements associated with a specific physical healthcare service site. Used in revenue cycle management to reflect contractual write-offs, corrections, or payer-negotiated rate modifications on location-level billing transactions.

location ageloc_age

The number of years a specific physical healthcare service site has been in operation since its establishment date. Used in facility management and strategic planning to assess site maturity, inform maintenance scheduling, and support operational performance benchmarking across the healthcare network.

location allowed amountloc_alwd_amt

The maximum dollar amount a payer will reimburse for services rendered at a specific physical healthcare service site, based on contracted rates or fee schedules. Used in revenue cycle management to calculate expected reimbursement and identify the patient responsibility portion of claims.

location amountloc_amt

The monetary value associated with a specific physical service site, representing charges, payments, or adjustments tied to that facility. Used in claims adjudication, facility billing, and cost allocation processing within EHR and PBM data systems.

location approval statusloc_appr_sts

The current authorization or credentialing state of a specific physical healthcare service site, indicating whether it has been approved to deliver services within a payer network or regulatory framework. Used to validate facility eligibility before processing claims or scheduling patient care activities.

location approved byloc_appr_by

The name or identifier of the user, administrator, or authority who granted approval for a specific physical healthcare service site to operate or participate in a network. Used in facility credentialing and compliance workflows to maintain an audit trail of authorization decisions.

location arrival timeloc_arrv_tm

The recorded time at which a patient arrived at a specific physical healthcare service site during an encounter or visit. Used in clinical operations and quality reporting to measure wait times, assess throughput efficiency, and support patient flow analytics across care settings.

location arrived dateloc_arrv_dt

The calendar date on which a patient arrived at a specific physical healthcare service site for a scheduled or unscheduled encounter. Used in clinical documentation and utilization reporting to establish the encounter timeline and support length-of-stay and access-to-care metric calculations.

location assessmentloc_asmt

The clinical or operational evaluation narrative associated with a specific physical healthcare service site, capturing findings related to patient care quality, facility readiness, or compliance status. Used in accreditation, quality improvement, and site review workflows within healthcare management systems.

location averageloc_avg

The calculated mean value of a metric, such as cost, LOS, or utilization, aggregated for a specific physical service site. Used in analytics and reporting systems to benchmark facility performance across EHR, claims, and care management data platforms.

location balanceloc_bal

The outstanding financial amount remaining for a specific physical service site after payments, adjustments, and credits have been applied. Used in accounts receivable, claims adjudication, and revenue cycle management systems to track facility-level liabilities.

location billed amountloc_bill_amt

The total dollar amount charged by a specific physical healthcare service site for services rendered and submitted to a payer on a claim. Used in revenue cycle management to track gross charges at the facility level and support financial reconciliation against allowed and paid amounts.

location birth dateloc_birth_dt

The date of birth associated with an individual or entity record linked to a specific physical service site, such as a provider or credentialed staff member. Used in provider directories, credentialing systems, and EHR master data management platforms.

location blood pressureloc_bp

The blood pressure reading recorded for a patient at a specific physical healthcare service site during a clinical encounter. Used in vital signs documentation to monitor cardiovascular health, track trends over multiple visits, and support clinical decision-making within EHR systems.

location cancelled dateloc_cncl_dt

The calendar date on which a scheduled service, appointment, or event at a specific physical healthcare service site was cancelled. Used in scheduling and operational reporting to track cancellation patterns, assess no-show rates, and support capacity planning and patient access management.

PreviousPage 139 of 325Next