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 paid amountasst_pd_amt

The total monetary amount paid to a clinical or administrative assistant for services rendered, hours worked, or as part of a compensation transaction. Recorded in payroll or financial management systems and used for compensation tracking, budget reconciliation, and workforce cost reporting.

assistant paid dateasst_pd_dt

The date on which a payment was issued to a clinical or administrative assistant for compensation, reimbursement, or other financial transaction. Recorded in payroll and financial management systems to support payment reconciliation, audit trails, and workforce cost reporting.

assistant parentasst_prnt

The parent entity, department, supervisor, or hierarchical record associated with a clinical or administrative assistant in workforce or HR management systems. Used to establish organizational hierarchy, reporting relationships, and departmental alignment for staffing and operational management.

assistant percentageasst_pct

A percentage value associated with a clinical or administrative assistant's record, such as a full-time equivalent ratio, productivity rate, cost allocation percentage, or coverage share. Used in workforce planning, payroll distribution, and staffing analytics to quantify the assistant's proportional contribution or assignment.

assistant periodasst_prd

The defined time interval or duration associated with a clinical or administrative assistant's assignment, contract, pay cycle, or service record. Used in workforce management and HR systems to establish the relevant timeframe for scheduling, compensation calculations, and performance or productivity reporting.

assistant phoneasst_ph

The primary telephone contact number for a clinical or administrative assistant, stored in workforce and HR management systems. Used to facilitate scheduling communications, interdepartmental coordination, emergency contact notifications, and direct outreach for operational staffing needs.

assistant preferred nameasst_pref_nm

The chosen display name for a clinical or administrative assistant, such as a medical assistant or surgical assistant. Used in staff directories, care team rosters, and scheduling systems to identify the assistant in a patient-facing or operational context.

assistant priceasst_prc

The billed or contracted cost associated with assistant services rendered during a clinical encounter or procedure. Captured on claims or service records to reflect the charge amount attributed to an assisting clinician, such as a surgical or procedural assistant.

assistant primary indicatorasst_prim_ind

A flag identifying whether a designated assistant holds the primary assisting role in a clinical encounter, care team assignment, or procedure. Used in surgical records, care coordination workflows, and claims processing to distinguish the lead assistant from secondary supporting staff.

assistant priorityasst_prty

A ranking value that determines the order or urgency with which an assistant is assigned or dispatched in clinical or administrative workflows. Used in scheduling, care coordination, and task management systems to ensure timely allocation of assistant resources across patient care activities.

assistant pulseasst_pulse

The recorded heart rate measurement for an individual identified in the assistant role during a clinical encounter, typically captured as part of occupational health or pre-procedure screening documentation. Stored in beats per minute within clinical or occupational health records.

assistant quantityasst_qty

The number of assistant staff units associated with a clinical encounter, service, or procedure. Used in staffing models, claims adjudication, and operating room records to track how many assistants were present or billed for a given healthcare service event.

assistant raceasst_race

The self-reported or recorded racial classification of an individual serving in an assistant role, such as a medical or surgical assistant. Captured for workforce demographic reporting, equity analysis, and compliance with federal healthcare workforce data collection requirements.

assistant rateasst_rt

The unit cost or reimbursement rate applied to services provided by a clinical assistant, such as a surgical or medical assistant. Used in claims processing, contract management, and fee schedule administration to calculate payment amounts for assistant-level services.

assistant ratingasst_rtg

A performance or quality assessment score assigned to an assistant based on clinical outcomes, peer review, or patient satisfaction data. Used in credentialing, workforce performance management, and quality improvement programs to evaluate assistant staff effectiveness.

assistant ratioasst_ratio

The proportional relationship between the number of assistants and patients, providers, or procedures within a clinical setting. Used in staffing analysis, regulatory compliance reporting, and operational planning to ensure adequate assistant coverage relative to care demand.

assistant reasonasst_rsn

The documented explanation for an action, assignment, or status change related to an assistant in a clinical or administrative workflow. Captures the rationale for events such as reassignment, absence, or escalation within care team management and staffing records.

assistant received dateasst_rcvd_dt

The date on which an assistant assignment, referral, or request was received and logged in a clinical or administrative system. Used in workforce management, care coordination workflows, and scheduling systems to track the intake timing of assistant-related service requests.

assistant referenceasst_ref

An identifier or pointer linking an assistant record to an external system, document, or related entity such as a credential file, contract, or care episode. Used in data integration and cross-system lookups to associate assistant records with broader clinical or operational contexts.

assistant resolution dateasst_resol_dt

The date on which an assistant-related task, issue, or assignment was formally closed or completed within a clinical or administrative workflow. Used in care coordination, incident tracking, and staffing management systems to document when an open assistant action item reached its final disposition.

PreviousPage 34 of 320Next