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

assistant statusasst_sts

Current operational or credentialing state of an assisting clinician, such as active, inactive, suspended, or pending verification. Used in provider management and surgical scheduling systems to confirm eligibility before assigning an assistant to a procedure or clinical role.

assistant street addressasst_st_addr

Physical street address associated with an assisting clinician's primary practice location or mailing address on record. Used in provider credentialing, workforce management, and claims processing systems to support identity verification, correspondence, and geographic assignment of clinical staff.

assistant subtotalasst_subtot

Partial monetary or unit sum attributable to an assisting clinician's services within a claim or billing record, prior to applying adjustments, modifiers, or combined totals. Used in claims processing to isolate assistant-specific charges from primary procedure costs for accurate reimbursement calculation.

assistant targetasst_tgt

Designated recipient system, facility, or role assignment toward which an assisting clinician's record, task, or referral is directed. Used in care coordination and clinical workflow systems to route assistant-related actions or documentation to the appropriate downstream process or care team member.

assistant taxonomy codeasst_tax_cd

National Uniform Claim Committee (NUCC) taxonomy code that classifies the specialty and role of an assisting clinician. Used on professional claims and credentialing records to identify the assistant's specific clinical discipline, such as surgical technologist or physician assistant, for billing and directory purposes.

assistant temperatureasst_temp

Measured body temperature recorded for a patient in the context of an encounter where an assisting clinician is documented. Used in clinical vital signs records and operative assessments to track patient physiological status during procedures involving assistant-level clinical support.

assistant termination dateasst_term_dt

Calendar date on which an assisting clinician's participation in a procedure, care episode, or employment engagement formally ended. Used in credentialing, workforce management, and surgical records to close an assistant's active assignment and ensure accurate historical staffing and billing records.

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.

PreviousPage 36 of 325Next