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

department classdept_cls

A classification tier assigned to an organizational unit that designates its functional role within a healthcare enterprise, such as revenue-generating or support. Used in EHR and cost accounting systems to drive reporting logic, reimbursement allocation, and operational benchmarking.

department codedept_cd

A standardized alphanumeric identifier assigned to an organizational unit within a healthcare enterprise. Referenced across EHR, claims, and billing systems to route transactions, allocate costs, and link clinical or administrative activity to the appropriate departmental cost center.

department coinsurance amountdept_coins_amt

The portion of a healthcare service cost that a patient is responsible for paying after the deductible is met, attributed to a specific department's services. Used in revenue cycle systems to calculate patient liability and reconcile insurance payments at the department level.

department commentdept_cmt

A free-text annotation field associated with an organizational unit record in a healthcare system. Used in EHR administrative modules to capture contextual notes, operational exceptions, or audit trail remarks relevant to department configuration, changes, or data quality issues.

department completed datedept_cmpl_dt

The calendar date on which a department-specific service, procedure, or workflow task was fully completed. Used in clinical operations and revenue cycle systems to track service turnaround times, billing readiness, and departmental throughput metrics.

department confidential indicatordept_conf_ind

A flag indicating that records or information associated with a specific department encounter are subject to heightened privacy protections, such as behavioral health or substance use services. Used in EHR access control systems to restrict visibility per regulatory requirements including 42 CFR Part 2.

department contactdept_cntct

The designated communication point or responsible individual associated with an organizational unit in a healthcare system. Stored in EHR administrative and provider directory systems to facilitate operational coordination, escalation routing, and inter-departmental data exchange workflows.

department copay amountdept_cpay_amt

The fixed out-of-pocket payment amount a patient is required to pay at the time of service for care delivered within a specific department. Used in patient financial services and claims adjudication systems to calculate member cost-sharing obligations based on benefit plan design.

department costdept_cst

The total internal expense incurred by a hospital or clinical department to deliver patient care services, including labor, supplies, and overhead allocations. Used in cost accounting and healthcare finance systems to support budgeting, benchmarking, and departmental profitability analysis.

department countdept_cnt

A numeric aggregation of occurrences, records, or entities associated with a specific organizational unit in a healthcare system. Used in EHR reporting, claims analytics, and operational dashboards to measure volume metrics such as patient encounters, staff headcount, or service transactions.

department countrydept_ctry

The country in which a specific hospital department or clinical facility is located. Used in facility master data and multi-national health system records to support international care coordination, regulatory compliance reporting, and geographic segmentation of service delivery.

department created bydept_crtd_by

The unique identifier of the user or system that originally created the department record within a healthcare information system. Used in audit trail and data governance workflows to establish record ownership, support compliance reviews, and track administrative changes to departmental configurations.

department created datedept_crtd_dt

The timestamp recording when an organizational unit record was first inserted into a healthcare system's database. Critical for EHR data governance, audit trails, and ETL pipeline validation to establish record lineage and ensure accurate historical reporting across administrative datasets.

department created timedept_crtd_tm

The exact timestamp recording when a department record was first created in a healthcare information system. Used in audit logging, data lineage tracking, and system administration workflows to establish record provenance and support troubleshooting of department-level configuration changes.

department creatininedept_cr

The creatinine measurement value documented within a specific clinical department context, used as an indicator of renal function for patients receiving care in that unit. Captured in laboratory and clinical documentation systems to support nephrology monitoring, medication dosing, and care protocols.

department currentdept_curr

A flag or indicator identifying whether an organizational unit record represents the active, present-state configuration within a healthcare system. Used in EHR and hospital information systems to filter historical department records and ensure data pipelines reference only valid, active departmental entities.

department datedept_dt

A generic calendar date value associated with an organizational unit record in a healthcare system. Context-dependent in EHR and administrative databases, this field may represent reporting periods, review cycles, or operational milestones tied to departmental activity or configuration changes.

department datetimedept_dttm

A combined date and timestamp value associated with an organizational unit event or transaction in a healthcare system. Used in EHR audit logs and administrative databases to capture precise timing of departmental record updates, status changes, or system-generated events for compliance and traceability.

department dea numberdept_dea_nbr

The Drug Enforcement Administration registration number assigned to a specific clinical department authorized to prescribe, dispense, or administer controlled substances. Used in pharmacy and prescribing systems to validate controlled substance orders and maintain regulatory compliance with DEA requirements.

department death datedept_death_dt

The official date an organizational unit was dissolved, decommissioned, or merged within a healthcare enterprise. Recorded in EHR administrative and HR systems to terminate cost center activity, close departmental records, and maintain accurate historical data for financial and operational reporting.

PreviousPage 76 of 325Next