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

consultation ratingconsult_rtg

The assessment value for a specialist opinion request. 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 consultation management and reporting.

consultation ratioconsult_ratio

The proportional value for a specialist opinion request. 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 consultation management and reporting.

consultation reasonconsult_rsn

Coded or free-text explanation documenting the clinical justification for initiating a specialist consultation request, such as ICD-10 diagnosis codes or symptom descriptions in EHR and utilization management systems. Used by data engineers to support prior authorization workflows, quality measures, and clinical analytics pipelines.

consultation received dateconsult_rcvd_dt

The receipt date for a specialist opinion request. Used to track temporal information related to consultation received date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for consultation management and reporting.

consultation referenceconsult_ref

External identifier or pointer linking a specialist consultation request to a related record in another system, such as a claims number, authorization ID, or provider NPI in EHR, payer, or care management platforms. Used by data engineers to perform cross-system joins, data lineage tracking, and referral reconciliation.

consultation resolution dateconsult_resol_dt

The condition end date for a specialist opinion request. Used to track temporal information related to consultation resolution date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for consultation management and reporting.

consultation respirationconsult_resp

The breathing rate value for a specialist opinion request. 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 consultation management and reporting.

consultation resultconsult_rslt

Documented outcome or clinical finding returned by a specialist in response to a consultation request, stored in EHR or care management systems as structured codes or narrative text. Used by data engineers to capture specialist recommendations, feed downstream quality reporting, and close care gaps in population health models.

consultation revisionconsult_rev

The update iteration number for a specialist opinion request. 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 consultation management and reporting.

consultation riskconsult_rsk

The danger level assessment for a specialist opinion request. 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 consultation management and reporting.

consultation routeconsult_rte

The administration pathway for a specialist opinion request. 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 consultation management and reporting.

consultation scoreconsult_scr

Calculated numeric rating assigned to a specialist consultation request or outcome, derived from clinical assessments, risk stratification models, or quality algorithms in EHR and care management systems. Used by data engineers to rank consultations, drive prioritization logic, and support value-based care performance measurement.

consultation sequenceconsult_seq

Ordinal position number indicating the order in which a specialist consultation request occurs within a series of related consultations, referrals, or care plan steps in EHR and care management systems. Used by data engineers to maintain event ordering, reconstruct clinical timelines, and support longitudinal patient journey analysis.

consultation severityconsult_sev

Clinical classification indicating the seriousness or acuity of the condition prompting a specialist consultation request, often aligned with ICD-10 severity indicators or triage scales in EHR and utilization management systems. Used by data engineers to stratify patient populations, prioritize workflows, and support risk-adjustment models.

consultation sexconsult_sex

The biological classification for a specialist opinion request. 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 consultation management and reporting.

consultation sourceconsult_src

Identifies the originating system, provider, facility, or data feed from which a specialist consultation request was generated, such as an EHR, referral platform, claims system, or care management tool. Used by data engineers to track data provenance, resolve duplicate records, and manage ETL source-to-target mappings.

consultation start dateconsult_start_dt

The date a specialist consultation request was initiated within EHR or care coordination systems. Used by data engineers to calculate consultation lead times, measure referral-to-visit intervals, and support utilization analytics across clinical workflows.

consultation start timeconsult_start_tm

The beginning time value for a specialist opinion request. Used to track temporal information related to consultation start time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for consultation management and reporting.

consultation stateconsult_st

The state or province for a specialist opinion request. 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 consultation management and reporting.

consultation statusconsult_sts

The current processing state of a specialist consultation request in EHR or care management platforms, such as pending, active, completed, or cancelled. Used to monitor referral workflow progression, identify bottlenecks, and support care coordination reporting.

PreviousPage 131 of 802Next