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

condition legal namecond_legal_nm

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

condition levelcond_lvl

The hierarchy position for a medical state or disease. 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 condition management and reporting.

condition license numbercond_lic_nbr

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

condition marital statuscond_mar_sts

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

condition master identifiercond_mstr_id

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

condition maximumcond_max

The upper limit value for a medical state or disease. 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 condition management and reporting.

condition medical record numbercond_mrn

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

condition middle namecond_mid_nm

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

condition minimumcond_min

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

condition mobilecond_mob

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

condition modified bycond_mod_by

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

condition modified datecond_mod_dt

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

condition modified timecond_mod_tm

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

condition namecond_nm

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

condition notecond_nt

The annotation text for a medical state or disease. 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 condition management and reporting.

condition numbercond_nbr

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

condition onset datecond_onset_dt

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

condition oxygen saturationcond_o2sat

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

condition paid amountcond_pd_amt

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

condition paid datecond_pd_dt

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

PreviousPage 115 of 802Next