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

assistant timeasst_tm

Specific time of day associated with an assisting clinician's documented activity within a clinical encounter or procedure. Used in operative and procedural records to capture discrete time points for scheduling accuracy, staff utilization reporting, and medicolegal documentation purposes.

assistant timestampasst_ts

Combined date and time value recording when a specific action, event, or data entry was associated with an assisting clinician in a clinical or administrative system. Used in audit trails, operative logs, and workflow systems to establish precise chronological accountability for assistant-related activities.

assistant titleasst_ttl

Formal professional designation or credential title associated with an assisting clinician, such as Certified Surgical Technologist or Physician Assistant. Used in provider directories, credentialing records, and clinical documentation to accurately identify the assistant's role and qualifications within the care team.

assistant totalasst_tot

Aggregate monetary amount or unit count representing the full billable contribution of an assisting clinician across one or more procedures within a claim or billing period. Used in claims adjudication and financial reporting to determine total reimbursement owed for assistant-level services rendered.

assistant total countasst_tot_cnt

Cumulative number of instances, procedures, or encounters in which an assisting clinician was documented as participating. Used in workforce analytics, quality reporting, and claims auditing to measure assistant utilization patterns across surgical programs, care settings, or specific time periods.

assistant typeasst_typ

Categorical classification identifying the role or credential type of an assisting clinician, such as surgical assistant, medical assistant, or physician assistant. Used in claims, credentialing, and staffing systems to distinguish between assistant classifications for billing accuracy, scope-of-practice compliance, and workforce reporting.

assistant unitasst_unt

The unit of measure associated with a healthcare support worker's service or task, such as hours, visits, or procedures. Used in clinical and administrative systems to quantify workload, schedule assignments, and calculate staffing costs across care delivery workflows.

assistant updated dateasst_upd_dt

The most recent date on which a healthcare support worker's record was modified in the system. Used in audit trails and data governance processes to track changes to credentials, assignments, scheduling, or contact information over time in clinical staffing systems.

assistant urgencyasst_urg

The time sensitivity classification assigned to a healthcare support worker's task or service request, such as routine, urgent, or emergent. Used to prioritize workflows and allocate support staff appropriately in clinical scheduling and care coordination systems.

assistant versionasst_ver

The sequential version number assigned to a healthcare support worker's record, incrementing each time the record is updated. Used in data management systems to maintain record history, support audit compliance, and identify the most current version of staffing or credentialing information.

assistant zipasst_zip

The five or nine digit postal ZIP code associated with a healthcare support worker's address on file. Used in workforce management and credentialing systems to verify geographic assignment, calculate travel zones, and support regulatory reporting for staffing and labor compliance.

authorization addressauth_addr

The physical location associated with a prior authorization request, identifying where services are approved to be rendered. Stored in utilization management and EHR systems to validate that care is delivered at the approved facility or provider site specified during the payer authorization approval process.

authorization approval statusauth_appr_sts

The current decision state of a prior authorization request for a healthcare service, such as approved, pending, denied, or under review. Used in utilization management systems to determine whether a payer has authorized coverage for a requested procedure, referral, or admission before services are rendered.

authorization charge amountauth_chrg_amt

The estimated or actual dollar amount associated with the service or procedure covered under a prior authorization request. Used in utilization management and revenue cycle systems to validate that billed charges align with the approved service scope and to support financial forecasting for authorized care.

authorization effective dateauth_eff_dt

The date on which a prior authorization becomes valid and services may begin under its approval in payer, EHR, and utilization management systems. Used by data engineers to enforce date-range validation during claims adjudication, build authorization eligibility checks, and support coverage period analytics across claims and PBM data pipelines.

authorization medical record numberauth_mrn

The unique patient medical record number linked to a prior authorization request, used to associate the approved service with the correct patient record. Supports cross-system matching between utilization management, clinical documentation, and claims processing workflows.

authorization scheduled dateauth_sched_dt

The calendar date on which the authorized service or procedure is planned to be performed. Used in utilization management and scheduling systems to ensure services are rendered within the authorization validity window and to coordinate care delivery with payer approval timelines.

authorization scheduled timeauth_sched_tm

The specific time of day at which the prior-authorized service or procedure is planned to occur. Used alongside the scheduled date in care coordination and scheduling systems to confirm appointment alignment with authorization approval periods and facility resource availability.

authorization street addressauth_st_addr

The physical street address of the facility or location where the authorized service is approved to be rendered. Used in utilization management systems to validate that care is delivered at the payer-approved site, supporting compliance with network requirements and location-specific authorization terms.

authorization unitauth_unt

The standardized unit of measure associated with an approved service authorization, such as days, visits, or procedures, within utilization management and claims platforms. Critical for data engineers validating that claim line units submitted by providers align with authorized units in prior authorization records during adjudication.

PreviousPage 36 of 320Next