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 targetdept_tgt

The destination department or organizational unit to which a patient, referral, or clinical transaction is directed within a health system. Used in ADT, EHR, and care coordination systems to manage patient routing, transfer workflows, and service attribution.

department taxonomy codedept_tax_cd

The NUCC Health Care Provider Taxonomy code assigned to a specific hospital department, identifying its clinical specialty or service classification. Used in provider enrollment, claims submission, and directory systems to accurately categorize departmental services for reimbursement, credentialing, and regulatory reporting purposes.

department temperaturedept_temp

The body temperature measurement recorded for a patient during a clinical encounter within a specific hospital department, typically expressed in degrees Fahrenheit or Celsius. Captured as a vital sign in EHR systems, this value informs clinical assessment, fever detection, and longitudinal monitoring across care settings.

department termination datedept_term_dt

The date on which a specific hospital department, departmental record, contract, or assignment became inactive or was formally closed. Used in EHR and administrative systems to manage the lifecycle of departmental entities, support historical reporting, and ensure accurate active status records for operational and regulatory purposes.

department timedept_tm

The specific time of day associated with a clinical event or service delivered within a hospital department or organizational unit. Used in EHR and scheduling systems to support operational reporting, staff utilization tracking, and timestamp-level audit trail construction.

department timestampdept_ts

The combined date and time value recording when a specific event occurred within a hospital department or organizational unit. Used in EHR audit logs, ADT systems, and clinical data warehouses for sequencing encounters, tracking workflow events, and supporting compliance reporting.

department titledept_ttl

The official name or formal designation assigned to a specific hospital department or clinical unit, such as Cardiology, Emergency Medicine, or Surgical Services. Used in EHR systems, facility directories, and administrative databases to accurately identify and display the department in clinical documentation, reporting, and patient communications.

department totaldept_tot

An aggregated numeric value representing the sum of charges, encounters, procedures, or other measurable activities attributed to a specific hospital department or organizational unit. Used in claims, EHR billing systems, and financial analytics platforms for cost center reconciliation and reporting.

department total countdept_tot_cnt

Aggregated count of clinical events, encounters, orders, or records attributed to a specific hospital department within a defined reporting period. Used in operational analytics to measure departmental workload, staffing needs, and utilization trends across healthcare systems.

department typedept_typ

A standardized classification code identifying the functional category of a hospital department or organizational unit, such as inpatient, outpatient, emergency, or ancillary. Used in EHR facility master data, claims routing, and revenue cycle systems to drive billing rules and reporting hierarchies.

department unitdept_unt

The unit of measure associated with services, resources, or activities tracked within a hospital department or organizational unit, such as hours, visits, or RVUs. Used in EHR, billing, and operational analytics systems for staffing benchmarks and cost allocation modeling.

department updated datedept_upd_dt

Timestamp recording the most recent modification to a hospital department's configuration, staffing, or operational record within the healthcare information system. Used to track data currency, audit changes, and ensure accurate department-level reporting in clinical and administrative workflows.

department urgencydept_urg

Indicates the clinical priority or time-sensitivity level assigned to a patient encounter, referral, or order routed to a specific hospital department. Supports triage workflows, scheduling prioritization, and care coordination by distinguishing routine, urgent, and emergent department-level requests.

department valuedept_val

A discrete data point or measured metric associated with a specific hospital department or organizational unit, such as a performance score, charge amount, or utilization figure. Used in EHR analytics, financial systems, and operational dashboards to support departmental benchmarking and reporting.

department versiondept_ver

Tracks the iteration number of a hospital department's record within the healthcare information system, incrementing with each administrative or structural update. Supports audit trails, change history, and data integrity validation across department configuration management workflows.

department zipdept_zip

Five or nine-digit postal code associated with a hospital department's physical location. Used in administrative records, claims submissions, and geographic reporting to identify facility location, support regulatory compliance, and enable population health analytics by geographic region.

dermatology addressderm_addr

Full address of the dermatology clinic or practice location where skin-related specialty care services are delivered. Used in provider directories, referral management, and patient scheduling systems to route patients to the correct dermatology facility for appointments and follow-up care.

dermatology effective datederm_eff_dt

Date on which a dermatology-related record, referral authorization, treatment plan, or contract becomes active. Used in specialty care workflows to determine coverage eligibility, referral validity, and the start of skin condition management protocols within clinical and administrative systems.

dermatology scheduled datederm_sched_dt

Calendar date on which a patient's dermatology appointment is planned within the specialty scheduling system. Used to coordinate skin care visits, manage provider availability, track referral completion, and measure appointment lead times for dermatology access and quality reporting.

dermatology scheduled timederm_sched_tm

Specific time of day assigned to a patient's planned dermatology appointment within the specialty scheduling system. Used alongside the scheduled date to allocate dermatologist availability, manage clinical workflow, and send patient appointment reminders for skin care specialty visits.

PreviousPage 82 of 325Next