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

Claims

ICD-10, CPT, EDI 837/835, adjudication and remittance

3,545 claims terms

referral quantityref_qty

The numeric count of authorized visits, procedures, or services permitted under a specialist referral in EHR, managed care, and claims systems. Used to enforce utilization limits, validate claim adjudication, and track consumption against authorized referral allowances.

referral raceref_race

Patient's self-reported racial classification captured as part of the referral record. Used in population health analytics and HEDIS reporting to identify disparities in specialist access and referral completion rates across demographic groups within health plan or clinical networks.

referral rateref_rt

The contracted or negotiated unit price associated with a specialist referral service in managed care, PBM, and claims systems. Used in cost modeling, provider fee schedule validation, and reimbursement calculations during referral-based claim adjudication workflows.

referral ratingref_rtg

Numeric or coded score assigned to evaluate referral quality, urgency, or outcome within utilization management workflows. Used to measure appropriateness of specialist referrals against clinical guidelines, supporting quality improvement programs and network performance monitoring.

referral ratioref_ratio

Proportional measure comparing referral volume to a baseline population or service denominator. Used in network management and population health reporting to benchmark specialist utilization rates, identify outlier referral patterns, and support provider performance evaluations within health plans.

referral reasonref_rsn

The clinical or administrative explanation text documenting why a patient is being referred to a specialist in EHR and managed care systems. Typically maps to diagnosis codes or free-text narratives used to support medical necessity determinations and prior authorization reviews.

referral received dateref_rcvd_dt

Date the specialist or receiving facility confirmed receipt of the referral request from the ordering clinician. Used in utilization management systems to calculate referral processing turnaround times, measure authorization compliance, and track appointment scheduling lag within care coordination workflows.

referral referenceref_ref

An external identifier or pointer linking a specialist referral to related records across EHR, claims, or care management systems, such as prior authorization numbers or parent encounter IDs. Enables cross-system traceability and referral lifecycle tracking.

referral resolution dateref_resol_dt

Date on which a referral authorization was formally closed, fulfilled, or terminated within the utilization management system. Used to calculate the active duration of referral episodes and measure specialist visit completion rates against authorization expiration timelines.

referral respirationref_resp

Patient's respiratory rate in breaths per minute documented at the time the referral was initiated. Transmitted to the receiving specialist as part of the clinical referral package to provide baseline vital sign context, particularly relevant for pulmonology, cardiology, or urgent care referrals.

referral review systemsref_ros

Structured review of organ systems completed by the ordering clinician as part of the referral documentation. Captures relevant positive and negative findings across body systems to provide the receiving specialist with a comprehensive clinical picture supporting diagnostic workup at the referred encounter.

referral revisionref_rev

Version number or iteration count tracking updates made to a referral authorization after initial submission. Used in utilization management systems to maintain an audit trail of modifications such as extended service dates, changed procedures, or updated clinical justifications submitted for authorization.

referral riskref_rsk

Clinician-assigned or algorithm-derived risk stratification level associated with a patient's referral episode. Used in care management and utilization review workflows to prioritize high-risk referrals for expedited processing, case management intervention, or concurrent review authorization requirements.

referral routeref_rte

Designated care pathway or channel through which a referral is directed, such as in-network specialist, out-of-network provider, or telehealth consult. Used in managed care systems to enforce network routing rules, track referral steerage compliance, and calculate cost impact of referral decisions.

referral scoreref_scr

A calculated numeric rating assigned to a specialist referral in care management and analytics platforms, derived from clinical risk models, appropriateness criteria, or utilization patterns. Used to prioritize outreach, flag high-risk referrals, and support care coordination decisions.

referral sequenceref_seq

An ordinal number assigned to uniquely order or rank multiple referral records within an encounter, member episode, or authorization batch in EHR and managed care systems. Ensures correct processing order and supports deduplication logic in referral data pipelines.

referral service dateref_svc_dt

The actual or expected date of care delivery associated with an authorized specialist referral. Used in managed care, EHR, and claims systems to validate timely service utilization, reconcile encounters against authorizations, and support HEDIS quality measure calculations.

referral severityref_sev

A coded or free-text classification indicating the clinical seriousness of the condition prompting a specialist referral in EHR and managed care systems. Informs authorization prioritization, specialist scheduling urgency, and population health stratification in care management platforms.

referral sexref_sex

Patient's biological sex recorded on the referral authorization record. Used in utilization management and population health analytics to assess gender-based variations in specialist referral rates, support clinical appropriateness review, and meet regulatory demographic reporting requirements for health plans.

referral sourceref_src

The originating provider, facility, department, or system that initiated a specialist referral request in EHR and managed care platforms. Critical for attribution reporting, network adequacy analysis, and tracking care coordination pathways across referring and receiving provider relationships.

PreviousPage 119 of 178Next