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 plandept_pln

The documented clinical treatment or care plan established within a specific hospital department, outlining intended interventions, follow-up actions, and therapeutic goals for a patient encounter recorded in departmental clinical notes or EHR documentation.

department policy numberdept_pol_nbr

The insurance policy identifier associated with coverage for services rendered by a specific hospital department, used in claims processing and billing workflows to link departmental charges to the correct payer policy for adjudication and reimbursement.

department preferred namedept_pref_nm

The preferred display name recorded for an individual within a specific hospital department's system, used to ensure patient-centered care by addressing patients or staff by their chosen name in departmental communications, scheduling, and clinical documentation.

department previousdept_prev

A reference field capturing the prior organizational unit associated with a provider, encounter, or cost center record in EHR, workforce, or claims systems. Used in data migration, organizational restructuring audits, and historical reporting to track departmental transitions and maintain continuity of care documentation.

department pricedept_prc

The charge or cost amount assigned to a service, procedure, or item within a specific hospital department, used in revenue cycle management, departmental charge capture, and financial reporting to reflect the department's standard or negotiated pricing structure.

department primary indicatordept_prim_ind

A flag designating whether a specific department record, association, or attribute is the primary one among multiple entries, used in clinical and administrative systems to determine which department record takes precedence for routing, reporting, and billing purposes.

department prioritydept_prty

A ranked or coded value assigned to an organizational unit indicating its relative importance for claims routing, referral processing, resource allocation, or system configuration workflows in EHR and health plan administration platforms. Drives business rules for queue management, escalation logic, and service prioritization in data pipelines.

department pulsedept_pulse

The heart rate in beats per minute recorded as a vital sign for a patient within a specific hospital department, used to monitor cardiovascular status and inform clinical decision-making in departmental care settings such as emergency, cardiology, or inpatient units.

department quantitydept_qty

The numeric count or volume measure associated with a specific organizational unit within a healthcare facility or payer system. Used in hospital cost accounting, workforce management, and claims grouping systems to aggregate service volumes, staff headcounts, or procedure counts by department.

department racedept_race

The racial or ethnic classification recorded for a patient within a specific hospital department's documentation, used to support health equity reporting, population health analytics, and regulatory compliance with federal demographic data collection requirements such as UDS or HEDIS.

department rangedept_rng

The defined minimum and maximum value span associated with a specific organizational unit in a healthcare system. Used in revenue cycle management, budgeting, and clinical analytics platforms to set thresholds for departmental metrics such as cost bands, utilization limits, or staffing ratios.

department ratedept_rt

The unit price or reimbursement rate applied to services rendered within a specific organizational department of a healthcare facility. Referenced in hospital chargemaster systems, cost accounting platforms, and claims adjudication engines to calculate department-level billing amounts and cost allocations.

department ratingdept_rtg

A scored assessment value assigned within a specific hospital department, which may represent patient satisfaction scores, quality performance ratings, acuity levels, or clinical risk scores used to evaluate departmental outcomes and support performance improvement initiatives.

department ratiodept_ratio

A calculated proportional value specific to a hospital department, such as a nurse-to-patient ratio, cost-to-charge ratio, or utilization rate, used in operational analytics and workforce planning to evaluate departmental efficiency, compliance, and resource allocation.

department reasondept_rsn

The coded or free-text explanation associated with an action, transaction, or event attributed to a specific organizational unit within a healthcare facility. Used in EHR audit logs, denial management systems, and revenue cycle platforms to document rationale for departmental decisions, adjustments, or exceptions.

department received datedept_rcvd_dt

The date a document, referral, order, or request was received by a specific hospital or clinical department. Used in EHR and HIS workflows to measure processing turnaround times, track departmental workload, and support compliance auditing across care settings.

department referencedept_ref

An external identifier or pointer linking a record to a specific organizational unit within a healthcare facility or payer system. Used in EHR integration engines, claims processing platforms, and EDI transactions to cross-reference departmental codes across source systems and downstream analytics environments.

department resolution datedept_resol_dt

The date on which an issue, case, request, or clinical concern assigned to a specific hospital department was formally resolved or closed. Used to measure departmental response efficiency, service level adherence, and operational throughput in clinical and administrative workflows.

department respirationdept_resp

The respiratory rate, measured in breaths per minute, recorded for a patient during a clinical encounter within a specific hospital department. Captured as a vital sign in EHR systems, this value supports clinical assessment, triage decisions, and longitudinal patient monitoring across inpatient and outpatient settings.

department resultdept_rslt

The recorded outcome or measurement produced by a specific organizational unit within a healthcare delivery or administrative system. Used in clinical data warehouses, quality reporting platforms, and hospital analytics systems to capture departmental performance indicators, diagnostic results, or operational metrics.

PreviousPage 80 of 325Next