mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

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 teams.

Back to Glossary

Domain

Clinical

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

16,101 clinical terms

consultation preferred nameconsult_pref_nm

The patient's chosen name or alias to be used during specialist consultation encounters, which may differ from their legal name. Supports patient-centered care by ensuring clinical staff address the patient appropriately during referral and consultation workflows.

consultation priceconsult_prc

The billed or established charge amount associated with a specialist consultation service before payer adjudication or contract adjustments. Used in pricing transparency reporting, cost estimation tools, and pre-authorization workflows within healthcare billing systems.

consultation primary indicatorconsult_prim_ind

A flag designating whether a specialist consultation is the primary or principal referral among multiple concurrent consultation requests for a patient. Used in clinical workflows to prioritize specialist coordination and ensure accurate attribution in care management reporting.

consultation priorityconsult_prty

Ranked urgency level assigned to a specialist consultation request, such as Routine, Urgent, or STAT, as recorded in EHR, care management, or utilization management systems. Used by data engineers to segment consultation queues, trigger workflow alerts, and measure response time compliance against clinical protocols.

consultation procedure dateconsult_proc_dt

The calendar date on which the specialist performed the clinical procedure or examination associated with the consultation request. Used in claims adjudication, authorization validation, and clinical timeline documentation to confirm services were rendered within approved timeframes.

consultation pulseconsult_pulse

Records the patient's heart rate in beats per minute measured at the time of the specialist consultation encounter. Captured as a vital sign to support the consulting specialist's clinical evaluation and document cardiovascular baseline status at the time of referral.

consultation quantityconsult_qty

Numeric count representing the volume of specialist consultation requests, visits, or associated service units within a defined encounter or authorization record in EHR or claims systems. Used by data engineers to aggregate utilization metrics, validate billing data, and support member-level consumption analysis.

consultation raceconsult_race

Records the patient's self-reported racial identity associated with a specialist consultation encounter. Used in population health analytics, health equity reporting, and disparity monitoring to identify gaps in specialist referral patterns across demographic groups.

consultation rangeconsult_rng

Defined minimum and maximum value boundaries applicable to a specialist consultation attribute, such as acceptable response timeframes, cost thresholds, or lab result ranges in EHR or care management systems. Used by data engineers to implement validation rules, anomaly detection, and clinical decision support logic.

consultation rateconsult_rt

Unit cost or reimbursement amount associated with a specialist consultation service as defined in fee schedules, contracts, or claims adjudication systems. Used by data engineers to calculate expected payments, reconcile remittance data, and support cost analysis across provider network and PBM platforms.

consultation ratingconsult_rtg

A scored assessment value applied to a specialist consultation, which may reflect clinical severity, patient satisfaction, or quality performance metrics. Used in provider performance reporting, utilization management, and quality improvement programs within managed care systems.

consultation ratioconsult_ratio

A calculated proportional value associated with a specialist consultation, such as the ratio of consultations requested to those completed, or cost-to-utilization ratios. Used in network performance analytics, utilization review, and specialist access reporting within health plan operations.

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 date on which the specialist or receiving clinical entity acknowledged and accepted the inbound consultation request from the referring provider. Used to measure referral response times, track care coordination timeliness, and support prior authorization audit trails.

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 date on which a specialist consultation was formally closed, completed, or resolved, indicating the consulting specialist's findings were communicated back to the referring provider. Used in care coordination tracking, referral lifecycle management, and clinical workflow reporting.

consultation respirationconsult_resp

Records the patient's respiratory rate in breaths per minute documented at the time of the specialist consultation encounter. Captured as a clinical vital sign to support the consulting specialist's assessment and establish baseline pulmonary status within the consultation record.

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

Tracks the version or iteration number of a specialist consultation request that has been modified, amended, or updated after initial submission. Used in clinical documentation auditing, referral management systems, and compliance workflows to maintain an accurate change history.

consultation riskconsult_rsk

A stratified assessment of the clinical or financial risk level associated with a specialist consultation, reflecting patient acuity, complexity, or likelihood of adverse outcomes. Used in utilization management, case management prioritization, and risk-adjusted quality reporting programs.

PreviousPage 131 of 806Next