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

otolaryngology medical record numberent_mrn

The unique patient identifier assigned within an ENT clinic or otolaryngology department. Used to consolidate clinical records including audiograms, endoscopy findings, surgical notes, and follow-up visits for a specific patient across ear, nose, and throat care episodes.

otolaryngology scheduled dateent_sched_dt

The calendar date on which an ENT appointment, diagnostic procedure, or surgical intervention is planned to occur. Used in otolaryngology scheduling systems to manage clinic capacity, surgical block time, and pre-operative coordination for ear, nose, and throat care.

otolaryngology scheduled timeent_sched_tm

The specific time of day an ENT appointment or surgical procedure is planned to begin. Used in otolaryngology scheduling and operating room management systems to coordinate clinical staff, equipment availability, and patient preparation for ear, nose, and throat procedures.

otolaryngology street addressent_st_addr

The street-level portion of an ENT clinic or ambulatory surgery center's physical address. Used in provider directories, referral workflows, and patient-facing communication systems to direct members to the correct facility for ear, nose, and throat specialty care.

otolaryngology unitent_unt

The standardized unit of measure applied to otolaryngology (ENT) services, procedures, or supplies within clinical and billing systems. Used to quantify ear, nose, and throat treatments for charge capture, claims submission, and utilization tracking across inpatient and outpatient encounters.

out of network benefit indicatoroon_ben_ind

A flag indicating that a claim was processed under out-of-network benefit provisions rather than in-network contracted rates, resulting in higher member cost-sharing and typically lower provider reimbursement. Out-of-network benefit tracking is used in network adequacy analytics, surprise billing compliance monitoring, and member cost-sharing dispute resolution.

out of pocket scheduled dateoop_sched_dt

The calendar date on which an out-of-pocket cost event, payment arrangement, or member cost-share activity is scheduled to occur. Used in member benefits and billing systems to track deductible, copay, or coinsurance milestones within a plan year accumulation cycle.

out of pocket scheduled timeoop_sched_tm

The specific time component associated with a scheduled out-of-pocket cost event or member payment activity. Used in conjunction with the scheduled date to precisely timestamp billing or cost-share transactions for audit trails and member financial responsibility tracking.

out of pocket unitoop_unt

The unit of measure representing a discrete out-of-pocket cost element such as a copay, coinsurance amount, or deductible installment. Used in member benefits and claims adjudication systems to quantify and accumulate patient financial responsibility toward annual plan limits.

overtime hoursot_hrs

The number of hours worked by employees beyond their scheduled or standard shift hours during a defined period, used in labor cost analytics to monitor overtime expense, identify units with chronic overtime patterns indicating understaffing, and assess compliance with labor regulations and collective bargaining agreement overtime provisions.

panel scheduled datepnl_sched_dt

The calendar date on which a laboratory test panel, such as a comprehensive metabolic panel or lipid panel, is scheduled to be collected or processed. Used in laboratory information systems to coordinate specimen collection, resource allocation, and result turnaround workflows.

panel scheduled timepnl_sched_tm

The specific time at which a laboratory test panel is scheduled for specimen collection or analysis. Used in laboratory information systems and order management workflows to sequence testing, allocate analyzer capacity, and ensure timely result delivery for clinical decision-making.

panel sizepanel_sz

The total number of patients actively attributed to or assigned to a specific primary care provider panel during a defined period, used in capacity planning to ensure providers are not over- or under-paneled relative to benchmark panel size recommendations that balance access, quality, and financial sustainability for the practice.

panel unitpnl_unt

The standardized measurement unit applied to a grouped set of related diagnostic tests ordered together in EHR and laboratory information systems. Defines quantity and dosage dimensions for panel-level order processing, billing, and results reporting in clinical workflows.

pathologist scheduled datepath_sched_dt

The calendar date on which a pathologist is scheduled to review, interpret, or sign out specimens such as biopsies, cytology slides, or surgical pathology cases. Used in laboratory scheduling systems to manage case workloads, turnaround times, and diagnostic reporting timelines.

pathologist scheduled timepath_sched_tm

The specific time at which a pathologist is scheduled to perform specimen review or diagnostic interpretation. Used in laboratory information systems to coordinate case assignments, manage concurrent review workloads, and support timely pathology report completion for clinical care decisions.

pathologist unitpath_unt

The standardized unit of measure applied to pathology services or interpretations performed by a pathologist, used for charge capture and claims billing. Quantifies discrete diagnostic activities such as slide interpretations or frozen section reviews for reimbursement and utilization reporting.

patient acuity scorepat_acuity_scr

A numeric score quantifying the clinical complexity and care intensity required for a specific patient based on diagnosis burden, functional status, medication complexity, and care coordination needs, used to drive nursing staffing ratios, care management resource allocation, and patient assignment decisions across inpatient units and care management programs.

patient day countpat_day_cnt

The total number of inpatient days accumulated by patients in a facility or unit during a defined reporting period, calculated as the sum of each patient length of stay. Patient day counts are a fundamental utilization metric used in staffing cost modeling, payer contract negotiations, and facility capacity benchmarking against licensed bed capacity.

patient fall ratepat_fall_rt

The number of patient falls per 1,000 patient days in a defined unit or facility during a reporting period, a standardized patient safety metric used for benchmarking against national databases such as NDNQI, identifying high-risk units for fall prevention program investment, and tracking the effectiveness of fall prevention interventions over time.

PreviousPage 168 of 325Next