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

effective leveleff_lvl

The hierarchy position for a coverage start validity. 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 effective management and reporting.

effective license numbereff_lic_nbr

The professional license identifier for a coverage start validity. Used as a unique reference to identify and track the effective across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective marital statuseff_mar_sts

The relationship status for a coverage start validity. Used to track the current state or condition of the effective. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective master identifiereff_mstr_id

The enterprise master id for a coverage start validity. Used as a unique reference to identify and track the effective across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective maximumeff_max

The upper limit value for a coverage start validity. 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 effective management and reporting.

effective medical record numbereff_mrn

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

effective middle nameeff_mid_nm

The middle name or initial for a coverage start validity. Used to display and describe the effective in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective minimumeff_min

The lower limit value for a coverage start validity. 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 effective management and reporting.

effective mobileeff_mob

The mobile phone number for a coverage start validity. 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 effective management and reporting.

effective modified byeff_mod_by

The updating user identifier for a coverage start validity. 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 effective management and reporting.

effective modified dateeff_mod_dt

The record update date for a coverage start validity. Used to track temporal information related to effective modified date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective modified timeeff_mod_tm

The record update time for a coverage start validity. Used to track temporal information related to effective modified time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective nameeff_nm

The display label text for a coverage start validity. Used to display and describe the effective in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective noteeff_nt

The annotation text for a coverage start validity. 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 effective management and reporting.

effective numbereff_nbr

The reference number value for a coverage start validity. Used as a unique reference to identify and track the effective across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective onset dateeff_onset_dt

The symptom start date for a coverage start validity. Used to track temporal information related to effective onset date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective oxygen saturationeff_o2sat

The blood oxygen level for a coverage start validity. 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 effective management and reporting.

effective paid amounteff_pd_amt

The payment received value for a coverage start validity. Used to capture financial data associated with effective transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective paid dateeff_pd_dt

The payment date for a coverage start validity. Used to track temporal information related to effective paid date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for effective management and reporting.

effective parenteff_prnt

The superior relationship for a coverage start validity. 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 effective management and reporting.

PreviousPage 87 of 320Next