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 expiration dateeff_exp_dt

The validity end date for a coverage start validity. Used to track temporal information related to effective expiration 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 external identifiereff_ext_id

The external system reference 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 faxeff_fax

The facsimile 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 feeeff_fee

The service charge 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 first nameeff_first_nm

The given name 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 flageff_flg

The binary status marker 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 frequencyeff_freq

The dosing schedule 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 full nameeff_full_nm

The complete name 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 gendereff_gndr

The sex classification 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 glucoseeff_gluc

The blood sugar 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 group numbereff_grp_nbr

The insurance group 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 hemoglobineff_hgb

The blood hemoglobin 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 identifiereff_id

The unique identifying 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 indexeff_idx

The position 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 indicatoreff_ind

The boolean state value 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 instructioneff_instr

The guidance 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 keyeff_key

The lookup reference 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 languageeff_lang

The preferred communication language 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 last nameeff_last_nm

The family surname 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 legal nameeff_legal_nm

The official registered name 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.

PreviousPage 86 of 320Next