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

site targetsite_tgt

The designated benchmark or goal value assigned to a care delivery location, such as a patient volume target, quality metric threshold, or performance objective. Used in network management, value-based care contracting, and operational reporting to measure site-level performance.

site taxonomy codesite_tax_cd

The NUCC Health Care Provider Taxonomy code assigned to a care delivery location, classifying its specialty or service type, such as hospital, ambulatory surgical center, or urgent care. Used for claims routing, network adequacy assessment, and directory classification in payer systems.

site temperaturesite_temp

The recorded ambient or storage temperature at a care delivery location, particularly relevant for facilities storing vaccines, biologics, or temperature-sensitive pharmaceuticals. Used in pharmacy compliance monitoring, cold chain management, and regulatory reporting for medication storage standards.

site termination datesite_term_dt

The calendar date on which a care delivery location ceased participation in a network, contract, or operational status. Used to enforce claim denial logic for services rendered after termination, and to maintain accurate historical records in provider directories and credentialing systems.

site timesite_tm

A recorded time value associated with a specific event or transaction at a care delivery location, such as patient check-in, service delivery, or data entry. Used to sequence clinical and administrative events for audit trails, workflow analysis, and operational efficiency reporting.

site timestampsite_ts

The combined date and time value marking when a specific record, transaction, or event was created or modified for a care delivery location. Used for audit logging, data synchronization, system integration sequencing, and regulatory compliance documentation across healthcare information systems.

site titlesite_ttl

The official or formal name designation of a care delivery location as recognized in provider directories, contracts, and regulatory filings. Distinguishes branded facility names from internal identifiers and supports patient-facing communications, referral documentation, and network directory displays.

site totalsite_tot

The complete aggregated financial or utilization figure for a care delivery location, encompassing all applicable charges, payments, or encounter counts after adjustments. Used in cost analysis, reimbursement reconciliation, and performance reporting across claims and administrative healthcare data systems.

site total countsite_tot_cnt

The complete tally of records, encounters, claims, or transactions associated with a care delivery location within a defined reporting period. Used to measure facility utilization, validate data completeness, monitor patient volume trends, and support capacity planning in healthcare analytics.

site typesite_typ

Classifies a care delivery location by its functional category, such as hospital, federally qualified health center, urgent care, long-term care, or outpatient clinic. Determines applicable billing rules, reimbursement rates, regulatory requirements, and network tier assignments in payer and provider systems.

site unitsite_unt

Identifies a distinct subdivision or department within a care delivery location, such as a specific ward, floor, clinic pod, or service line. Used in clinical operations, staffing allocation, cost center reporting, and inpatient data management to attribute activity to the correct organizational subunit.

site updated datesite_upd_dt

The timestamp recording when a care delivery location's record was last modified in the system. Used to audit data currency, trigger downstream synchronization processes, and ensure scheduling and credentialing systems reflect the most current site configuration and operational details.

site urgencysite_urg

Indicates the priority or time-sensitivity level assigned to a care delivery location, such as emergency, urgent care, or routine. Used in scheduling systems and care coordination workflows to route patients appropriately based on acuity and the site's capacity to handle emergent clinical needs.

site versionsite_ver

A sequential version number tracking the revision history of a care delivery location's record within the system. Enables audit trails, rollback capabilities, and change management by identifying which iteration of site data was active during a given period of clinical or administrative activity.

site zipsite_zip

The five or nine-digit US postal code for a care delivery location's physical address. Used in geographic analysis, provider directory accuracy, network adequacy assessments, and claims adjudication to validate service area eligibility and calculate distance-based metrics for member access.

skilled nursing facility qualifying stay flagsnf_qual_stay_flg

A flag indicating that a patient had a qualifying three-day inpatient hospital stay meeting Medicare requirements for skilled nursing facility coverage following discharge, used in care transition planning and post-acute care analytics to identify patients eligible for Medicare-covered SNF benefits and to prevent inappropriate SNF admissions for patients without qualifying stays.

slot addressslot_addr

The physical or virtual location associated with a specific appointment slot, indicating where the scheduled encounter will take place. Used in scheduling systems to direct patients and clinicians to the correct room, building, or telehealth link when a booking is confirmed or modified.

slot ageslot_age

The patient's age at the time of the scheduled appointment slot. Used in scheduling and clinical workflows to apply age-appropriate care protocols, verify eligibility for specific services, and support population health stratification based on the age profile of booked appointments.

slot allowed amountslot_alwd_amt

The maximum reimbursable dollar amount determined by the payer's fee schedule for services rendered during a specific appointment slot. Used in revenue cycle management to calculate contractual adjustments between billed charges and payer-permitted rates during claims adjudication.

slot amountslot_amt

The total monetary value associated with a scheduled appointment slot, representing the aggregate financial transaction tied to services expected or rendered. Used in revenue cycle and scheduling analytics to forecast revenue, track visit-level financials, and reconcile payments against booked encounters.

PreviousPage 234 of 325Next