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

appointment chief complaintappt_cc

The primary symptom reported for a scheduled care visit. 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 appointment management and reporting.

appointment childappt_chld

The subordinate relationship for a scheduled care visit. 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 appointment management and reporting.

appointment cityappt_city

The municipality name for a scheduled care visit. 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 appointment management and reporting.

appointment classappt_cls

The classification tier for a scheduled care visit. 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 appointment management and reporting.

appointment codeappt_cd

The standardized classification value for a scheduled care visit. Used as a unique reference to identify and track the appointment across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for appointment management and reporting.

appointment commentappt_cmt

The free text notation for a scheduled care visit. 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 appointment management and reporting.

appointment completed dateappt_cmpl_dt

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

appointment confidential indicatorappt_conf_ind

The privacy protection flag for a scheduled care visit. Used to track the current state or condition of the appointment. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for appointment management and reporting.

appointment countappt_cnt

The occurrence number for a scheduled care visit. 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 appointment management and reporting.

appointment countryappt_ctry

The nation name for a scheduled care visit. 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 appointment management and reporting.

appointment created byappt_crtd_by

The creating user identifier for a scheduled care visit. 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 appointment management and reporting.

appointment created dateappt_crtd_dt

The record creation date for a scheduled care visit. Used to track temporal information related to appointment created date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for appointment management and reporting.

appointment created timeappt_crtd_tm

The record creation time for a scheduled care visit. Used to track temporal information related to appointment created time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for appointment management and reporting.

appointment creatinineappt_cr

The kidney function marker for a scheduled care visit. 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 appointment management and reporting.

appointment dateappt_dt

The calendar date value for a scheduled care visit. Used to track temporal information related to appointment date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for appointment management and reporting.

appointment datetimeappt_dttm

The combined date-time value for a scheduled care visit. Used to track temporal information related to appointment datetime. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for appointment management and reporting.

appointment dea numberappt_dea_nbr

The drug enforcement administration number for a scheduled care visit. Used as a unique reference to identify and track the appointment across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for appointment management and reporting.

appointment death dateappt_death_dt

The date of death for a scheduled care visit. Used to track temporal information related to appointment death date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for appointment management and reporting.

appointment deleted dateappt_del_dt

The record deletion date for a scheduled care visit. Used to track temporal information related to appointment deleted date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for appointment management and reporting.

appointment deleted indicatorappt_del_ind

The removal status flag for a scheduled care visit. Used to track the current state or condition of the appointment. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for appointment management and reporting.

PreviousPage 17 of 320Next