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 modified byasst_mod_by

The user identifier of the individual who last updated the clinical or administrative assistant's record in the system. Used for audit trail purposes in workforce and HR management platforms to track data stewardship, accountability, and compliance with record governance policies.

assistant modified dateasst_mod_dt

The calendar date on which a clinical or administrative assistant's record was most recently updated in the system. Used in workforce and HR management platforms to support audit trails, data quality monitoring, and change history tracking for compliance and reporting purposes.

assistant modified timeasst_mod_tm

The timestamp indicating the exact time a clinical or administrative assistant's record was last updated in the system. Used alongside the modified date in audit logs and change history tracking within workforce and HR management platforms to ensure data integrity and accountability.

assistant nameasst_nm

The full display name of a clinical or administrative assistant as recorded in workforce and HR management systems. Used to identify the individual in scheduling, credentialing, staffing assignments, and reporting, and typically derived from a combination of first, middle, and last name fields.

assistant numberasst_nbr

A system-assigned or administratively assigned reference number uniquely identifying a clinical or administrative assistant within workforce management, HR, or scheduling systems. Used to track the individual across operational records, payroll, credentialing, and departmental assignments.

assistant onset dateasst_onset_dt

The date on which a relevant condition, event, or status change first occurred for a clinical or administrative assistant, such as the start of a leave of absence, disability, or occupational health matter. Used in HR and occupational health tracking systems for case management and compliance reporting.

assistant oxygen saturationasst_o2sat

The blood oxygen saturation level recorded for a clinical or administrative assistant in their capacity as a patient or participant in an occupational health assessment. Captured as a percentage of hemoglobin saturation and used in employee health screenings or return-to-work evaluations.

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.

PreviousPage 34 of 325Next