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

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,027 clinical terms

diagnosis minimumdiag_min

The lower limit value for a medical condition identification. 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 diagnosis management and reporting.

diagnosis mobilediag_mob

The mobile phone number for a medical condition identification. 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 diagnosis management and reporting.

diagnosis modified bydiag_mod_by

The updating user identifier for a medical condition identification. 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 diagnosis management and reporting.

diagnosis modified datediag_mod_dt

Timestamp recording the most recent update to a diagnosis record in EHR, claims, or billing systems. Critical for incremental data loads, audit trails, and change-data-capture pipelines ensuring downstream data warehouses reflect current coding and clinical documentation.

diagnosis modified timediag_mod_tm

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

diagnosis namediag_nm

Human-readable display label corresponding to an ICD-10 or proprietary diagnosis code within EHR, claims, and billing systems. Used in reporting interfaces, provider portals, and member communications to present clinical condition descriptions without requiring code lookup.

diagnosis notediag_nt

Free-text or structured annotation attached to a diagnosis record in EHR or claims systems, capturing coder clarifications, clinical context, or payer-specific documentation. Used in audit, compliance, and clinical data integration workflows to supplement coded diagnosis data.

diagnosis numberdiag_nbr

System-assigned or payer-defined reference number associated with a diagnosis within pharmacy and billing processes, used to track drug-diagnosis linkage for prior authorization, formulary adjudication, and clinical reporting in PBM and claims systems.

diagnosis onset datediag_onset_dt

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

diagnosis oxygen saturationdiag_o2sat

The blood oxygen level for a medical condition identification. 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 diagnosis management and reporting.

diagnosis paid amountdiag_pd_amt

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

diagnosis paid datediag_pd_dt

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

diagnosis parentdiag_prnt

Reference to the hierarchically superior diagnosis code or category in an ICD-10 or proprietary code taxonomy, enabling rollup aggregation in EHR and claims reporting systems. Used to support drill-down analytics and condition grouping in data warehouse environments.

diagnosis percentdiag_pct

Proportional value representing a diagnosis contribution to a calculated measure, such as risk score weighting, condition prevalence, or cost attribution within claims and population health analytics systems. Used in actuarial modeling, quality reporting, and care management platforms.

diagnosis perioddiag_prd

Defined date range during which a diagnosis is considered active or clinically relevant on a member record, encounter, or claim. Used in EHR chronic condition tracking, eligibility systems, and claims analytics to scope diagnosis validity for reporting and risk adjustment.

diagnosis phonediag_ph

Telephone contact number associated with a diagnosing provider, facility, or clinical department linked to a diagnosis record in EHR or provider master data systems. Used in care coordination workflows, provider data management, and claims routing for follow-up communications.

diagnosis plandiag_pln

The treatment strategy text for a medical condition identification. 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 diagnosis management and reporting.

diagnosis policy numberdiag_pol_nbr

The coverage policy identifier for a medical condition identification. Used as a unique reference to identify and track the diagnosis across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for diagnosis management and reporting.

diagnosis preferred namediag_pref_nm

The chosen display name for a medical condition identification. Used to display and describe the diagnosis in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for diagnosis management and reporting.

diagnosis previousdiag_prev

Historical diagnosis code or record from a prior encounter, claim, or coding period associated with a member or patient in EHR and claims systems. Used in longitudinal data analysis, chronic condition management, and transition-of-care workflows to track diagnostic history over time.

PreviousPage 164 of 802Next