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,390 operations terms

appointment temperatureappt_temp

The patient body temperature reading recorded in association with a scheduled care visit, typically captured at check-in or during triage. Used in clinical documentation, pre-visit screening workflows, infection control monitoring, and vital signs trending within EHR systems.

appointment termination dateappt_term_dt

The date on which a scheduled patient visit record was formally ended, cancelled, or closed in the scheduling system. Used to track appointment lifecycle, calculate no-show lag times, support audit reporting, and manage care gap identification for unresolved visits.

appointment timeappt_tm

The scheduled clock time of a patient visit as recorded in the EHR or practice management system. Used for provider schedule management, patient notification and reminder workflows, wait time analysis, and operational reporting on appointment distribution throughout the care day.

appointment timestampappt_ts

The combined date and time value marking a specific event in the appointment lifecycle, such as when it was created, modified, or completed. Used for audit trails, scheduling system synchronization, workflow trigger sequencing, and longitudinal visit history reconstruction.

appointment titleappt_ttl

The descriptive label or name assigned to a scheduled patient visit in the EHR or scheduling system, such as Annual Wellness Visit or Follow-Up Consultation. Used to communicate visit purpose to patients and staff, support schedule display, and enable visit-type reporting.

appointment totalappt_tot

The complete financial amount associated with a scheduled patient visit after all charges, fees, and adjustments are applied. Used in pre-service cost estimation, patient financial responsibility calculation, revenue cycle forecasting, and episodic cost analysis across visit types.

appointment total countappt_tot_cnt

The aggregate number of scheduled patient visits meeting specified criteria within a defined period or population. Used in capacity planning, provider productivity measurement, no-show rate calculation, access reporting, and population health program engagement tracking.

appointment typeappt_typ

The classification category assigned to a scheduled patient visit, such as new patient, follow-up, preventive, telehealth, or urgent care. Drives scheduling rules, slot duration assignment, billing code selection, resource allocation, and utilization reporting across care settings.

appointment unitappt_unt

The discrete unit of measure associated with a scheduled patient visit, such as the clinical department, care unit, billing unit, or time block increment. Used in scheduling configuration, provider workload distribution, operational reporting, and facility-level capacity management.

appointment updated dateappt_upd_dt

The most recent date on which a scheduled patient visit record was modified in the EHR or scheduling system, including changes to time, provider, location, or status. Used for audit logging, change history tracking, scheduling system reconciliation, and data governance compliance.

appointment urgencyappt_urg

The clinical priority level assigned to a scheduled patient visit indicating how quickly the patient needs to be seen, such as routine, urgent, or emergent. Used to triage scheduling queues, ensure timely access for high-acuity patients, and support access-to-care performance measurement.

appointment versionappt_ver

The sequential version number of a scheduled patient visit record, incremented each time the appointment is modified in the scheduling system. Supports optimistic concurrency control, change history auditing, system integration conflict resolution, and data lineage tracking across EHR platforms.

appointment zipappt_zip

The five or nine-digit postal code for the location where a scheduled patient visit is set to occur. Used to identify care site geography, analyze patient travel burden, support network adequacy reporting, and enable social determinants of health assessments tied to visit location.

approval active indicatorappr_actv_ind

Binary flag indicating whether a prior authorization or service approval record is currently active within the utilization management system. Active approvals permit claim adjudication against authorized services. Inactive records may reflect expired, voided, or superseded authorizations.

approval active statusappr_actv_sts

Categorical status value describing the current activity state of a prior authorization or service approval, such as Active, Inactive, Expired, or Suspended. Used in utilization management workflows to determine whether an authorization remains valid for claim processing and service delivery.

approval addressappr_addr

The physical location associated with a prior authorization or permission grant record in utilization management and claims systems. Stored as a structured or free-text field in EHR and payer platforms; used to validate provider or facility eligibility during approval workflow processing and audit trail reconciliation.

approval ageappr_age

The age of the member or patient at the time a prior authorization or service approval was requested or granted. Used in utilization management to apply age-based medical necessity criteria, benefit eligibility rules, and clinical guidelines during the authorization review process.

approval allowed amountappr_alwd_amt

The maximum dollar amount a health plan will reimburse for services covered under a prior authorization. Establishes the financial ceiling for claim payments associated with the approved services, used during claims adjudication to validate billed charges against authorized reimbursement limits.

approval amountappr_amt

The authorized monetary value associated with a prior authorization or permission grant in utilization management and claims adjudication systems. Stored as a numeric field in payer and EHR platforms; used to validate claim payments against approved thresholds, trigger overpayment reviews, and support financial reconciliation in healthcare billing workflows.

approval approval statusappr_appr_sts

The authorization decision outcome for a prior authorization request, indicating whether services have been approved, denied, pended, or partially approved by the utilization management team. Drives downstream claim adjudication and member and provider notification workflows.

PreviousPage 22 of 320Next