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 sexcap_sex

Specifies the biological sex designation applied to a facility or unit capacity limit, such as gender-specific bed allocations in behavioral health or rehabilitation units. Used in capacity planning to ensure appropriate patient-to-unit assignments and regulatory compliance with sex-segregated care requirements.

capacity sourcecap_src

Identifies the originating system, department, or data feed that reported or established a facility capacity limit, such as a bed management system, ADT feed, or census report. Used in capacity tracking to maintain data lineage and reconcile capacity figures across multiple reporting systems.

capacity start datecap_start_dt

Records the calendar date on which a specific facility, unit, or service capacity limit becomes effective. Used in capacity management systems to track when a new bed count, staffing threshold, or service volume ceiling was activated, enabling historical trend analysis and regulatory reporting.

capacity start timecap_start_tm

Records the specific time of day at which a facility, unit, or service capacity limit becomes active. Used alongside capacity start date in intraday capacity management workflows to precisely track when surge protocols, diversion statuses, or census thresholds take effect within a care setting.

capacity statecap_st

Captures the U.S. state or territory associated with a facility or service capacity limit, used to apply state-specific regulatory requirements such as licensed bed counts, staffing ratios, or CMS-reported census thresholds. Supports multi-state health system capacity planning and compliance reporting.

capacity statuscap_sts

Reflects the current operational status of a facility or unit capacity limit, such as active, suspended, at capacity, or under diversion. Used in real-time bed management and patient flow systems to communicate whether a unit or service line is available to accept new patient admissions or referrals.

capacity street addresscap_st_addr

Stores the physical street address of the facility or care site associated with a specific capacity limit. Used in multi-site health systems and emergency management platforms to geographically locate and distinguish capacity records across campuses, clinics, or temporary care sites.

capacity strengthcap_str

Specifies the drug concentration or dosage strength associated with a pharmacy dispensing or formulary capacity constraint, such as maximum stock thresholds for a specific medication strength. Used in pharmacy inventory and supply chain management to monitor and control medication availability limits.

capacity subtotalcap_subtot

Represents an intermediate aggregated count of available or occupied units within a subset of a facility's total capacity, such as a wing, pod, or service line. Used in capacity reporting dashboards to present partial census figures before combining with other units to calculate overall facility totals.

capacity targetcap_tgt

Defines the intended or goal-level occupancy or throughput volume for a facility, unit, or service line, against which actual census figures are compared. Used in capacity planning and performance management to measure operational efficiency and identify when units are operating above or below optimal thresholds.

capacity taxonomy codecap_tax_cd

Stores the NUCC Health Care Provider Taxonomy code that classifies the specialty or service type associated with a specific capacity limit, such as codes distinguishing inpatient psychiatric beds from general medical-surgical beds. Used to align capacity records with specialty-specific regulatory and credentialing requirements.

capacity temperaturecap_temp

Records the environmental or storage temperature requirement associated with a capacity-limited resource, most commonly used in pharmacy or laboratory settings to define thresholds for refrigerated medication storage or biological specimen capacity. Supports compliance with cold chain management and storage regulations.

capacity termination datecap_term_dt

Records the calendar date on which a specific facility, unit, or service capacity limit expires or is deactivated. Used in capacity management systems to close out temporary capacity expansions, surge authorizations, or seasonal service adjustments and maintain accurate historical capacity records.

capacity timecap_tm

Captures the specific time of day associated with a facility or unit capacity measurement or limit, used to support intraday census snapshots and time-based capacity reporting. Enables operational teams to identify peak demand periods and adjust staffing or patient flow protocols accordingly.

capacity timestampcap_ts

Records the combined date and time at which a facility or unit capacity value was recorded, updated, or transmitted. Used in bed management and patient flow systems to maintain a precise audit trail of capacity changes, enabling real-time monitoring and retrospective analysis of census fluctuations.

capacity titlecap_ttl

Stores the formal name or label assigned to a specific capacity record, such as a unit designation, program name, or service line title like Adult ICU or Outpatient Infusion Suite. Used in capacity management reporting to provide human-readable identification of the resource or setting being tracked.

capacity totalcap_tot

Represents the aggregate sum of all available, occupied, or authorized units across a facility or defined service area, such as total licensed beds or total appointment slots. Used in executive dashboards and regulatory reporting to present a complete picture of a facility's overall operational capacity.

capacity total countcap_tot_cnt

Records the cumulative number of capacity units counted across all applicable categories or time intervals for a facility or service, such as total bed-days available or total patient encounters allowed. Used in capacity utilization analysis and volume-based contract reporting to quantify overall throughput limits.

capacity typecap_typ

Classifies the nature or category of a capacity limit, such as licensed beds, staffed beds, operational beds, appointment slots, or infusion chairs. Used in healthcare capacity management systems to distinguish between different resource types when calculating availability, utilization rates, and compliance with regulatory capacity standards.

capacity unitcap_unt

The unit of measure defining how a facility or service capacity limit is quantified, such as beds, appointment slots, or procedure rooms. Used in facility management systems to standardize capacity tracking across departments and care settings.

PreviousPage 52 of 325Next