mdatool
LibraryBlogPricing
mdatool
mdatool

Healthcare data architecture platform for data engineers, architects, and analysts building modern health systems.

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 engineers & architects.

Back to Glossary

Domain

Operations

Scheduling, facilities, departments, workflows, and staff

6,386 operations terms

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.

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.

slot approval statusslot_appr_sts

The current authorization or approval state of a scheduled appointment slot, such as pending, approved, denied, or cancelled. Used in prior authorization workflows and scheduling systems to confirm whether the planned service has received necessary payer or administrative approval before the encounter occurs.

slot approved byslot_appr_by

The identifier of the user, clinician, or administrative staff member who authorized or approved a specific appointment slot. Used in scheduling audit trails, compliance reporting, and workflow accountability to document who granted approval for the encounter and when the action was performed.

slot arrival timeslot_arrv_tm

The recorded time a patient physically arrived at the care site for their scheduled appointment slot. Used in operational analytics to measure patient flow efficiency, calculate wait times, assess no-show and late arrival patterns, and optimize scheduling templates across clinical departments.

slot arrived dateslot_arrv_dt

The calendar date on which a patient arrived at the facility for their scheduled appointment slot. Used in conjunction with arrival time to support patient flow analysis, appointment adherence reporting, and operational benchmarking of scheduling efficiency across care delivery sites.

slot assessmentslot_asmt

The clinical evaluation or assessment documentation captured in association with a specific appointment slot. Includes the clinician's structured or free-text findings used to inform diagnosis, treatment planning, and care coordination activities occurring during or following the scheduled patient encounter.

slot balanceslot_bal

The remaining outstanding dollar amount owed on a scheduled or completed appointment slot after payments and adjustments have been applied. Used in patient billing workflows and accounts receivable reporting to track unpaid balances, drive collections activity, and reconcile visit-level financial transactions.

PreviousPage 230 of 320Next