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 created timecap_crtd_tm

The timestamp recording the exact time a capacity record defining a maximum volume limit was first entered into the healthcare system. Supports audit logging and chronological sequencing of capacity configuration events within scheduling and resource management systems.

capacity creatininecap_cr

The creatinine level value recorded within a capacity context, representing a key kidney function biomarker used to assess renal health. In clinical data systems, this value informs treatment thresholds, medication dosing limits, and patient eligibility for specific procedures or interventions.

capacity datecap_dt

The specific calendar date associated with a capacity record that defines a maximum volume or service limit. Used in scheduling and resource management systems to identify when a particular capacity constraint is applicable for facility, staff, or service slot planning.

capacity datetimecap_dttm

The combined date and time value associated with a capacity record, capturing the precise moment a maximum volume limit applies or was recorded. Used in scheduling systems to enable granular, time-sensitive capacity management for services, facilities, or clinical resources.

capacity dea numbercap_dea_nbr

The Drug Enforcement Administration registration number associated with a capacity record, identifying the licensed prescriber or facility authorized to dispense controlled substances up to a defined volume limit. Used in pharmacy and prescribing systems to enforce regulatory compliance with controlled substance thresholds.

capacity death datecap_death_dt

The date of death recorded in association with a capacity record, used to deactivate or close capacity allocations tied to a deceased patient or provider. Ensures that scheduling, enrollment, or service limit records are accurately terminated in clinical and administrative systems.

capacity deleted datecap_del_dt

The date on which a capacity record defining a maximum volume limit was logically removed from the active dataset. Used in capacity management systems to maintain a historical audit trail of when service or resource constraints were retired without permanently purging the underlying data.

capacity deleted indicatorcap_del_ind

A flag denoting whether a capacity record defining a maximum volume limit has been logically removed from active use. Used in scheduling and resource management systems to filter out retired capacity constraints while preserving the historical record for audit and reporting purposes.

capacity descriptioncap_desc

A human-readable text field providing narrative detail about the nature and purpose of a capacity record defining a maximum volume limit. Used in scheduling and resource management systems to clarify the scope, conditions, or rationale behind a specific service or facility constraint.

capacity detailcap_dtl

Granular information associated with a capacity record that elaborates on the specific parameters, conditions, or constraints of a maximum volume limit. Used in scheduling and resource management systems to capture supplementary data that supports accurate capacity planning and operational decision-making.

capacity due datecap_due_dt

The deadline date by which a capacity-related obligation or action must be completed, such as fulfilling a contracted service volume or submitting capacity documentation. Used in healthcare operations and contract management systems to monitor compliance with capacity commitments and service level agreements.

capacity effective datecap_eff_dt

The date on which a capacity record and its associated maximum volume limit becomes active and enforceable within the healthcare system. Used in scheduling and resource management workflows to determine when a defined service, facility, or staffing constraint begins governing operational planning.

capacity emailcap_eml

The electronic mail address associated with a capacity record, used to route notifications, alerts, or communications regarding maximum volume limits or scheduling constraints. Supports automated messaging workflows in healthcare scheduling and resource management systems when capacity thresholds are reached or updated.

capacity end datecap_end_dt

The date on which a capacity record and its associated maximum volume limit ceases to be active within the healthcare system. Used in scheduling and resource management workflows to define the expiration boundary of a service, facility, or staffing constraint, enabling accurate capacity planning over time.

capacity end timecap_end_tm

The specific time at which a capacity record and its associated maximum volume limit ceases to be applicable within the healthcare system. Used in scheduling and resource management systems to define precise time-bounded constraints for service slots, facility availability, or staffing allocations.

capacity entered bycap_ent_by

The identifier of the user or system that initially created or submitted a capacity record defining a maximum volume limit. Used in scheduling and resource management systems to maintain accountability, support audit trails, and attribute data entry actions to specific personnel or automated processes.

capacity ethnicitycap_ethn

The ethnicity classification associated with a capacity record, used to track demographic distribution of service utilization relative to defined volume limits. Supports health equity analysis and population-based capacity planning by identifying ethnic group representation within allocated service or facility constraints.

capacity expiration datecap_exp_dt

The date on which a capacity record's maximum volume limit is no longer valid and must be renewed or replaced. Used in scheduling, credentialing, and resource management systems to trigger reviews and prevent the application of outdated capacity constraints to active operational planning.

capacity external identifiercap_ext_id

A reference identifier assigned by an external system to uniquely identify a capacity record across integrated healthcare platforms. Used in scheduling and resource management data exchanges to maintain consistent cross-system linkage of maximum volume limit records between source systems, data warehouses, and downstream applications.

capacity faxcap_fax

The facsimile transmission number associated with a benefit plan or contract capacity limit record. Used in member enrollment and plan administration systems to route communications related to maximum enrollment thresholds or coverage volume constraints to the responsible managing entity.

PreviousPage 48 of 325Next