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

assessment scheduled timeasmt_sched_tm

The specific time of day at which a clinical assessment appointment is planned. Used alongside the scheduled date in care management and scheduling systems to manage clinician calendars, patient notifications, and assessment completion tracking workflows.

assessment street addressasmt_st_addr

The street-level address component of the location where a clinical assessment was performed or is scheduled to occur. Used in care management systems to document and verify the specific site of patient evaluation for care coordination and reporting purposes.

assessment unitasmt_unt

The unit of measure associated with a clinical assessment, such as a single encounter, a scored scale value, or a timed interval. Used in care management and claims systems to quantify assessment activity and support utilization tracking and outcome measurement.

assistant addressasst_addr

The physical or mailing address on record for a healthcare support worker, such as a medical assistant or clinical aide. Used in workforce management and credentialing systems to maintain accurate contact and location data for staffing, compliance, and communication purposes.

assistant ageasst_age

The current age in years of a healthcare support worker, derived from date of birth. Used in workforce management and HR systems for demographic reporting, labor analytics, and compliance with age-related employment regulations in healthcare settings.

assistant allowed amountasst_alwd_amt

The maximum dollar amount a payer will reimburse for services rendered by a healthcare support worker, such as a surgical assistant or clinical aide. Used in claims adjudication to calculate payment after applying contractual adjustments and coordination of benefits rules.

assistant amountasst_amt

The monetary value associated with a surgical or procedural assistant's contribution to a healthcare encounter. Used in claims processing and reimbursement workflows to capture the billed or allowed dollar amount tied to assistant surgeon or clinical assistant services rendered.

assistant approval statusasst_appr_sts

The current authorization state indicating whether a surgical or clinical assistant's involvement in a procedure has been approved, pending, or denied. Used in prior authorization workflows and claims adjudication to validate assistant service eligibility before or after care delivery.

assistant approved byasst_appr_by

The identifier or name of the individual, system, or review body that granted authorization for a surgical or clinical assistant's participation in a procedure. Used in claims and utilization management workflows to maintain an audit trail of approval decisions for assistant services.

assistant arrival timeasst_arrv_tm

The recorded time at which a surgical or clinical assistant arrived at the care setting for a scheduled procedure or encounter. Used in operative scheduling, staffing coordination, and clinical workflow systems to track punctuality and resource readiness for assistant personnel.

assistant arrived dateasst_arrv_dt

The calendar date on which a surgical or clinical assistant arrived at the care facility for a scheduled encounter or procedure. Used in operative scheduling and staffing records to document assistant attendance and support compliance with procedural staffing requirements.

assistant assessmentasst_asmt

The clinical evaluation or narrative documentation completed by a healthcare assistant during a patient encounter. Used in clinical documentation systems to capture structured or free-text findings, observations, or assessments contributed by assistant-level clinical staff supporting patient care delivery.

assistant birth dateasst_birth_dt

The date of birth of a surgical or clinical assistant, used to verify identity, licensure eligibility, and credentialing requirements within provider enrollment and workforce management systems. Supports age-based compliance checks and demographic record accuracy for assistant personnel.

assistant blood pressureasst_bp

The systolic and diastolic arterial pressure measurement recorded by or attributed to a healthcare assistant during a patient encounter. Used in clinical documentation systems to capture vital signs obtained by assistant-level staff, contributing to the overall patient assessment record.

assistant cancelled dateasst_cncl_dt

The calendar date on which a scheduled surgical or clinical assistant assignment was cancelled for a procedure or encounter. Used in operative scheduling and staffing management systems to track cancellation events, identify patterns, and support rebooking or resource reallocation workflows.

assistant categoryasst_cat

The classification grouping assigned to a surgical or clinical assistant based on role type, licensure level, or scope of practice. Used in workforce management, claims billing, and credentialing systems to distinguish between categories such as surgical assistant, physician assistant, or medical assistant.

assistant charge amountasst_chrg_amt

The billed dollar amount charged for services rendered by a surgical or clinical assistant during a healthcare encounter. Used in claims processing and revenue cycle management to represent the gross charge associated with assistant services prior to contractual adjustments or payer adjudication.

assistant chief complaintasst_cc

The primary symptom, concern, or reason for visit documented by a healthcare assistant at the start of a patient encounter. Used in clinical documentation systems to capture the patient's presenting complaint as recorded by assistant-level staff during intake or triage workflows.

assistant childasst_chld

A hierarchical reference identifying a subordinate or dependent record linked to a parent assistant record within a healthcare data system. Used in data modeling and workflow management to represent nested relationships, such as sub-tasks or secondary roles associated with an assistant assignment.

assistant cityasst_city

The city or municipality associated with a surgical or clinical assistant's practice location or mailing address. Used in provider enrollment, credentialing, and workforce management systems to capture geographic data for directory maintenance, licensing verification, and contact record accuracy.

PreviousPage 30 of 320Next