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

staff turnover ratestaff_trnvr_rt

The percentage of staff positions in a department or facility that turned over due to resignation, termination, or retirement during a defined period, calculated as separations divided by average headcount. Staff turnover rate is a leading indicator of workforce stability affecting care quality, operational continuity, and recruitment and training costs in healthcare operations analytics.

staffing ratiostaff_ratio

The numeric relationship between the number of clinical staff members and the number of patients they are responsible for during a defined shift or time period, such as a nurse-to-patient ratio of 1:4. Staffing ratios are used in workforce analytics to monitor compliance with state-mandated minimum ratios, assess workload equity across units, and model staffing costs against patient volume and acuity.

standard addressstd_addr

The normalized and validated physical mailing or service address formatted according to postal standards. Used across member enrollment, provider directories, and claims systems to ensure accurate correspondence, eligibility verification, and geographic analysis of healthcare service locations.

standard agestd_age

The normalized age value calculated or assigned according to a defined methodology, such as age at enrollment or age at service date. Used in clinical quality measures, risk stratification, actuarial analysis, and population health reporting to ensure consistent age-based calculations across datasets.

standard allowed amountstd_alwd_amt

The maximum reimbursable dollar amount permitted under a standard fee schedule or contract methodology for a given service. Used in claims adjudication to determine the baseline payment after applying contractual adjustments, prior to member cost-sharing calculations such as deductibles and copays.

standard amountstd_amt

The predefined monetary value established by a payer, health plan, or regulatory body for a specific service, procedure, or transaction type. Used in claims adjudication and reimbursement workflows to benchmark or cap allowable payment amounts against contractual or fee schedule standards.

standard approval statusstd_appr_sts

Indicates the current authorization state of a defined clinical or administrative standard, such as pending, approved, rejected, or expired. Used in clinical governance workflows to track whether a protocol, guideline, or policy has received the required organizational or regulatory sign-off.

standard approved bystd_appr_by

Identifies the individual user, role, or governing body that authorized a clinical protocol, administrative policy, or operational guideline. Captured in healthcare governance and compliance systems to maintain an auditable record of who granted formal approval and under what authority.

standard arrival timestd_arrv_tm

Records the clock time at which a patient physically arrived at a care setting, such as an emergency department, clinic, or inpatient unit, relative to a defined care standard. Used in operational reporting to measure throughput, triage compliance, and adherence to door-to-treatment time benchmarks.

standard arrived datestd_arrv_dt

Records the calendar date on which a patient arrived at a care facility or was received into a care process, measured against an established protocol or operational standard. Used in clinical operations and quality reporting to calculate wait times and assess compliance with access-to-care benchmarks.

standard assessmentstd_asmt

The structured or free-text clinical evaluation performed according to an established protocol or guideline, documenting a patient's condition, risk level, or care needs. Captured in clinical documentation systems to ensure consistent evaluation practices and support care planning, coding, and quality measurement.

standard birth datestd_birth_dt

The verified or normalized date of birth associated with a patient record, standardized for use across health plan enrollment, claims processing, and eligibility verification systems. Ensures consistent member identification and supports age-based benefit determination, eligibility checks, and demographic analytics.

standard blood pressurestd_bp

The systolic and diastolic arterial pressure measurement recorded according to a defined clinical protocol or guideline, expressed in mmHg. Captured during clinical encounters to monitor cardiovascular health, assess hypertension management, and support quality measures such as HEDIS blood pressure control reporting.

standard cancelled datestd_cncl_dt

The calendar date on which a scheduled service, appointment, procedure, or administrative action was formally cancelled in accordance with an operational or clinical standard. Used in scheduling, utilization management, and claims systems to track cancellation patterns and assess care continuity impacts.

standard categorystd_cat

A defined classification grouping that organizes clinical protocols, administrative policies, or healthcare standards into structured hierarchies for reporting and management. Used in healthcare information systems to segment standards by type, department, or regulatory domain, enabling efficient retrieval and compliance tracking.

standard charge amountstd_chrg_amt

The predefined fee a healthcare facility or payer assigns to a specific service or procedure before adjustments, discounts, or contractual allowances are applied. Used in revenue cycle management and claims processing to establish a baseline billing amount against which payer-negotiated rates and patient cost-sharing are calculated.

standard chief complaintstd_cc

The primary symptom, concern, or reason for visit documented at the point of care according to a structured clinical intake standard. Captured in clinical documentation and triage workflows to guide diagnostic coding, care prioritization, and episode-of-care analysis across inpatient, outpatient, and emergency settings.

standard childstd_chld

Represents a subordinate element within a hierarchical classification or data structure, linked to a parent standard record. Used in healthcare taxonomy and clinical terminology management systems to organize standards, code sets, or policy frameworks into parent-child relationships that support drill-down reporting and structured navigation.

standard citystd_city

The standardized municipality name associated with a patient, member, or facility address record, normalized for consistency across healthcare systems. Used in member enrollment, claims processing, and provider directory management to support accurate geographic assignment, network determination, and population health segmentation.

standard classstd_cls

A defined tier or classification level assigned to a clinical protocol, benefit plan element, or administrative standard within a structured taxonomy. Used in health plan administration and clinical governance systems to segment standards by priority, complexity, or regulatory category, enabling consistent policy application and reporting.

PreviousPage 242 of 325Next