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 dea numberasst_dea_nbr

The Drug Enforcement Administration registration number assigned to a clinical assistant who is authorized to handle or administer controlled substances. Used to verify prescribing authority, ensure regulatory compliance, and support pharmacy and credentialing workflows in healthcare systems.

assistant death dateasst_death_dt

The recorded date of death for a clinical or administrative assistant, captured within the healthcare workforce or HR management system. Used to terminate active records, update credentialing status, and ensure accurate workforce reporting and compliance documentation.

assistant deleted dateasst_del_dt

The date on which a clinical or administrative assistant's record was marked as deleted or inactivated in the healthcare workforce management system. Supports data retention policies, audit trail requirements, and historical reporting within EHR and clinical data warehouses.

assistant deleted indicatorasst_del_ind

A flag indicating whether a clinical or administrative assistant's record has been logically deleted or inactivated in the healthcare workforce management system. Used to filter active records from reporting, maintain data integrity, and support soft-delete auditing practices in HIS platforms.

assistant descriptionasst_desc

A free-text or coded narrative describing the role, qualifications, or responsibilities of a clinical or administrative assistant within the healthcare organization. Used to support workforce documentation, credentialing profiles, and role-based access configuration in EHR and HIS systems.

assistant detailasst_dtl

Granular information associated with a clinical or administrative assistant's record, including role-specific attributes, assignments, or operational data. Used to support detailed workforce management, scheduling, and credentialing functions within healthcare information and data warehouse systems.

assistant due dateasst_due_dt

The date by which a required action, certification renewal, or compliance task must be completed for a clinical or administrative assistant. Used in credentialing workflows, license tracking, and workforce compliance management systems to ensure timely regulatory adherence.

assistant effective dateasst_eff_dt

The date on which a clinical or administrative assistant's record, role assignment, or credential becomes active and valid within the healthcare workforce management system. Used to manage enrollment windows, role transitions, and compliance timelines in EHR and HIS platforms.

assistant emailasst_eml

The professional electronic mail address associated with a clinical or administrative assistant, used for workforce communication, credentialing notifications, and system access within healthcare organizations. Stored in EHR and HIS platforms to support contact management and audit correspondence.

assistant end dateasst_end_dt

The date on which a clinical or administrative assistant's role, assignment, or credential expires or is terminated within the healthcare workforce management system. Used to manage contract periods, credential validity, and workforce transition workflows in EHR and HIS platforms.

assistant end timeasst_end_tm

The time at which a clinical or administrative assistant's shift, assignment, or scheduled task concludes within the healthcare workforce management system. Used in scheduling, payroll processing, and operational reporting to track labor hours and support workforce analytics.

assistant entered byasst_ent_by

The identifier of the user who manually entered or submitted the clinical or administrative assistant's data into the healthcare workforce management system. Supports data stewardship, audit trail documentation, and accountability tracking within EHR and clinical data warehouse environments.

assistant ethnicityasst_ethn

The self-reported or recorded ethnic background of a clinical or administrative assistant, captured for workforce diversity reporting and equal employment compliance. Used in HR analytics and regulatory submissions to support diversity, equity, and inclusion initiatives within healthcare organizations.

assistant expiration dateasst_exp_dt

The date on which a healthcare support worker's credentials, certification, or role assignment becomes invalid. Used in workforce management systems to trigger renewals, restrict system access, and maintain compliance with staffing and credentialing requirements.

assistant external identifierasst_ext_id

A reference code assigned to a healthcare support worker by an external system such as a staffing agency, credentialing body, or interfacing EHR platform. Used to reconcile assistant records across disparate systems and support data exchange in integrated healthcare environments.

assistant faxasst_fax

The facsimile telephone number associated with a healthcare support worker or their assigned department. Used in clinical and administrative workflows to route documents such as orders, referrals, and care coordination communications requiring direct contact with the assistant.

assistant feeasst_fee

The monetary charge or compensation rate associated with a healthcare support worker's services. Used in billing, payroll, and cost accounting workflows to track labor expenses, reconcile claims involving assistant services, and support financial reporting in healthcare operations.

assistant first nameasst_first_nm

The given or personal name of a healthcare support worker as recorded in the workforce or clinical system. Used in staff directories, care team displays, patient-facing documentation, and audit logs to identify the assistant in a readable, human-friendly format.

assistant flagasst_flg

A binary indicator used to mark a specific condition or status associated with a healthcare support worker, such as active assignment, supervisory oversight required, or restricted access. Supports filtering and workflow routing in staffing and clinical management systems.

assistant full nameasst_full_nm

The complete name of a healthcare support worker, typically combining first, middle, and last name fields. Used in official documentation, care team rosters, patient records, and compliance reporting where a fully qualified name is required for identification or legal purposes.

PreviousPage 32 of 325Next