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 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.

assistant classasst_cls

The classification tier assigned to a surgical or clinical assistant based on training level, certification type, or scope of practice. Used in credentialing, workforce management, and claims systems to differentiate assistant classifications such as certified surgical technologist, first assistant, or medical assistant.

assistant codeasst_cd

A standardized identifier or classification value assigned to a surgical or clinical assistant to uniquely represent their role, credential type, or service category across healthcare systems. Used in claims billing, credentialing, and workforce management to reference and track assistant records consistently.

assistant commentasst_cmt

Free-text notation or supplementary remarks associated with a surgical or clinical assistant's record, assignment, or service event. Used in clinical documentation and workforce management systems to capture additional context, clarifications, or instructions that do not fit within structured data fields.

assistant completed dateasst_cmpl_dt

The calendar date on which a surgical or clinical assistant completed their assigned service, procedure participation, or task within a healthcare encounter. Used in operative scheduling, claims processing, and workforce management systems to confirm service delivery and support timely billing and documentation workflows.

assistant confidential indicatorasst_conf_ind

A flag designating whether a surgical or clinical assistant's record or associated information is subject to confidentiality restrictions. Used in workforce management and credentialing systems to control data access, protect sensitive personnel information, and enforce privacy policies in compliance with regulatory requirements.

assistant countasst_cnt

The total number of surgical or clinical assistants assigned to, participating in, or recorded across a set of healthcare encounters or procedures. Used in operative scheduling, staffing analytics, and claims reporting to quantify assistant resource utilization and support workforce planning decisions.

assistant countryasst_ctry

The country of residence or practice for a clinical or administrative assistant recorded in the healthcare workforce management system. Used to support credentialing, compliance reporting, and cross-border care coordination in EHR and HIS platforms.

assistant created byasst_crtd_by

The unique identifier of the user who created the assistant's record in the healthcare workforce or credentialing system. Supports audit trail requirements, data governance, and accountability tracking across EHR and clinical data warehouse environments.

assistant created dateasst_crtd_dt

The calendar date on which the assistant's record was first entered into the healthcare workforce or credentialing system. Used to establish record lifecycle timelines, support audit compliance, and track onboarding activity within HIS and data warehouse platforms.

assistant created timeasst_crtd_tm

The timestamp indicating when the assistant's record was first created in the healthcare workforce or credentialing system. Paired with the created date to provide precise audit trail documentation and support data lineage tracking in clinical information systems.

assistant creatinineasst_cr

The serum or urine creatinine measurement recorded for a clinical assistant as part of occupational health screening or employee wellness programs. Used to monitor kidney function and support workforce health management within clinical and occupational health data systems.

assistant dateasst_dt

A general-purpose date value associated with a clinical or administrative assistant's record in the healthcare workforce management system. Provides temporal context for workforce events, scheduling, or administrative transactions tracked in EHR and HIS platforms.

assistant datetimeasst_dttm

A combined date and time value associated with a clinical or administrative assistant's record, capturing the precise moment of a workforce-related event or transaction. Used in audit logging, scheduling, and operational reporting within healthcare information systems.

PreviousPage 31 of 325Next