mdatool
LibraryBlogPricing
mdatool
mdatool

Healthcare data architecture platform for data engineers, architects, and analysts building modern health systems.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator

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 engineers & architects.

Back to Glossary

Domain

Operations

Scheduling, facilities, departments, workflows, and staff

6,387 operations terms

assistant termination dateasst_term_dt

The ending date value for a healthcare support worker. Used to track temporal information related to assistant termination date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant timeasst_tm

The time of day value for a healthcare support worker. Used to track temporal information related to assistant time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant timestampasst_ts

The date and time value for a healthcare support worker. Used to track temporal information related to assistant timestamp. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant titleasst_ttl

The formal designation for a healthcare support worker. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant totalasst_tot

The sum value for a healthcare support worker. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant total countasst_tot_cnt

The sum of occurrences for a healthcare support worker. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant typeasst_typ

The category classification for a healthcare support worker. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant unitasst_unt

The single item or measure for a healthcare support worker. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant updated dateasst_upd_dt

The last change date for a healthcare support worker. Used to track temporal information related to assistant updated date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant urgencyasst_urg

The time sensitivity level for a healthcare support worker. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant versionasst_ver

The record version number for a healthcare support worker. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

assistant zipasst_zip

The postal code for a healthcare support worker. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assistant management and reporting.

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 authorization state for a service pre-approval. Used to track the current state or condition of the authorization. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for authorization management and reporting.

authorization charge amountauth_chrg_amt

The service charge value for a service pre-approval. Used to capture financial data associated with authorization transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for authorization management and reporting.

authorization effective dateauth_eff_dt

The date on which a prior authorization becomes valid and services may begin under its approval in payer, EHR, and utilization management systems. Used by data engineers to enforce date-range validation during claims adjudication, build authorization eligibility checks, and support coverage period analytics across claims and PBM data pipelines.

authorization medical record numberauth_mrn

The patient medical record number for a service pre-approval. Used as a unique reference to identify and track the authorization across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for authorization management and reporting.

authorization scheduled dateauth_sched_dt

The planned appointment date for a service pre-approval. Used to track temporal information related to authorization scheduled date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for authorization management and reporting.

authorization scheduled timeauth_sched_tm

The planned time for a service pre-approval. Used to track temporal information related to authorization scheduled time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for authorization management and reporting.

authorization street addressauth_st_addr

The street location for a service pre-approval. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for authorization management and reporting.

PreviousPage 36 of 320Next