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

capacity maximumcap_max

The upper threshold value defining the maximum allowable volume for a capacity-controlled resource, such as the highest number of beds, appointments, or patient encounters permitted within a defined unit, department, or time window in operational planning systems.

capacity medical record numbercap_mrn

The patient medical record number associated with a capacity record, linking an individual patient encounter or reservation to a specific capacity slot. Used in bed management and census tracking systems to reconcile patient assignments against available capacity.

capacity middle namecap_mid_nm

The middle name or initial of the individual associated with a capacity record, such as a patient assigned to a bed or a provider linked to an appointment slot. Used in identity matching to disambiguate records with similar first and last names in capacity management systems.

capacity minimumcap_min

The lower threshold value defining the minimum required volume for a capacity-controlled resource, such as the fewest beds or staff needed to maintain safe operations. Used in workforce planning and facility management systems to set baseline operational requirements.

capacity mobilecap_mob

The mobile phone number associated with an individual or contact linked to a capacity record, such as a patient awaiting bed assignment or a staff member managing a resource. Used in care coordination and notification workflows within capacity management systems.

capacity modified bycap_mod_by

The username or system identifier of the user or process that last updated a capacity record. Used in audit trail tracking within bed management, scheduling, and resource planning systems to maintain accountability for changes to capacity configurations or thresholds.

capacity modified datecap_mod_dt

The calendar date on which a capacity record was most recently updated. Used in audit and change tracking within bed management, scheduling, and resource planning systems to identify when capacity thresholds, assignments, or configurations were last altered.

capacity modified timecap_mod_tm

The timestamp indicating the precise time at which a capacity record was last updated. Used alongside the modified date in audit trail logging within bed management and scheduling systems to provide a complete chronological record of capacity configuration changes.

capacity namecap_nm

The human-readable label assigned to a capacity record, such as the name of a unit, bed pool, appointment type, or resource group. Used in scheduling, census management, and operational dashboards to identify and display capacity configurations in a meaningful format.

capacity numbercap_nbr

A numeric reference value assigned to a specific capacity record or slot, such as a bed number, room designation, or appointment queue position. Used in bed management, scheduling, and facility operations systems to uniquely identify individual capacity units within a larger pool.

capacity onset datecap_onset_dt

The date on which a capacity constraint, restriction, or configuration became effective, such as when a unit reduced available beds or a scheduling block was initiated. Used in capacity planning and utilization analysis to track the start of specific operational capacity conditions.

capacity oxygen saturationcap_o2sat

The recorded blood oxygen saturation level for a patient associated with a capacity record, such as during triage or bed assignment. Used in clinical bed management and acuity-based placement systems to align patient clinical status with appropriate care settings and available capacity.

capacity paid amountcap_pd_amt

The monetary amount paid in connection with a capacity-related transaction, such as a reserved bed, contracted slot, or facility usage fee. Used in financial reconciliation and capacity billing workflows to capture and track payments associated with specific resource reservations or utilization agreements.

capacity paid datecap_pd_dt

The date on which payment was received or processed for a capacity-related transaction, such as a contracted bed reservation or facility slot. Used in financial tracking and reconciliation systems to record when capacity-related charges were settled within healthcare operations or payer agreements.

capacity parentcap_prnt

The identifier of the higher-level entity in a capacity hierarchy, such as the parent unit, facility, or resource group to which a specific capacity record belongs. Used in bed management and scheduling systems to support hierarchical rollup reporting and organizational capacity analysis.

capacity percentagecap_pct

The proportional ratio of used capacity to total available capacity for a resource, such as percent of beds occupied or appointment slots filled. Used in operational dashboards and utilization reporting to monitor census levels, identify bottlenecks, and support capacity planning decisions.

capacity periodcap_prd

The defined time interval over which a capacity limit or constraint applies, such as a daily bed allotment, weekly appointment block, or monthly resource allocation window. Used in scheduling and census management systems to bound capacity rules within specific operational timeframes.

capacity phonecap_ph

The primary telephone number associated with an individual or contact linked to a capacity record, such as a patient on a bed waitlist or a unit coordinator managing resource allocation. Used in care coordination and operational communication workflows within capacity management systems.

capacity preferred namecap_pref_nm

The preferred or chosen display name of an individual associated with a capacity record, such as a patient assigned to a bed or waitlisted for a resource. Used in patient-facing communications and bed management workflows to ensure respectful, accurate identification in capacity-related interactions.

capacity pricecap_prc

The monetary cost associated with a defined capacity threshold or maximum volume limit in a healthcare setting, such as the price assigned to a bed block, service slot, or resource allocation unit used in facility and contract management.

PreviousPage 50 of 325Next