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,391 operations terms

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.

capacity updated datecap_upd_dt

The most recent date on which a facility or service capacity limit was modified in the system. Used in facility management and scheduling systems to audit changes to bed counts, appointment slots, or other capacity constraints over time.

capacity urgencycap_urg

The time-sensitivity classification assigned to a capacity limit or constraint, indicating how quickly the capacity issue must be addressed. Used in facility operations to prioritize resource allocation decisions during high-demand or emergency situations.

capacity versioncap_ver

The sequential version number assigned to a capacity record each time it is updated, enabling historical tracking of capacity limit changes. Used in facility management systems to maintain a complete audit trail of capacity modifications over time.

capacity zipcap_zip

The five or nine-digit postal code associated with the physical location of a facility or service site where a capacity limit applies. Used in facility management and network planning systems to geographically identify and report on capacity constraints by location.

cardiology addresscard_addr

Physical location data element (card_addr) stored in provider master files, EHR practice management systems, and claims databases to capture the street address of cardiology specialty practices. Used in provider directory maintenance, network adequacy reporting, referral routing workflows, and care coordination systems for cardiovascular specialty services.

cardiology effective datecard_eff_dt

Identifies the date on which a cardiology-related record, authorization, contract term, or provider designation becomes active within EHR, payer, or provider management systems. Used in temporal filtering logic during ETL processing to ensure only currently valid cardiology data is surfaced in operational and analytical reporting.

cardiology scheduled datecard_sched_dt

The calendar date on which a cardiology appointment or cardiac procedure is planned to occur. Used in cardiology scheduling systems to coordinate patient access to heart specialty services including consultations, stress tests, echocardiograms, and interventional procedures.

cardiology scheduled timecard_sched_tm

The specific clock time at which a cardiology appointment or cardiac procedure is planned to begin. Used in cardiology scheduling systems alongside the scheduled date to manage patient flow, staff assignments, and equipment availability for cardiac care services.

cardiology street addresscard_st_addr

The physical street address of the cardiology practice, clinic, or hospital department where cardiac care services are delivered. Used in provider directories, referral management, and patient scheduling systems to direct patients to the correct cardiology service location.

PreviousPage 52 of 320Next