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 categoryref_cat

Classifies a specialist referral request into a defined grouping such as primary care, specialty, behavioral health, or urgent care within care management and utilization systems. Used to drive authorization workflows, reporting hierarchies, and network routing logic in healthcare data engineering pipelines.

referral chief complaintref_cc

Primary symptom or clinical concern documented by the referring clinician that prompted the specialist referral. Captured in structured or free-text form to communicate the patient's presenting problem, supporting appropriate specialist triage, scheduling prioritization, and care coordination.

referral childref_chld

Identifies a subordinate or dependent referral record linked to a parent referral within care management and utilization management systems. Used to represent hierarchical referral relationships, enabling data engineers to reconstruct referral chains, track authorization amendments, and support parent-child referral analytics.

referral cityref_city

City associated with the referred patient's residence or the receiving specialist's service location as recorded in the referral record. Used in geographic access analysis, network adequacy reporting, and care coordination workflows to assess proximity and availability of referred services.

referral claim dateref_clm_dt

Date on which a claim associated with a specialist referral was submitted to the payer for adjudication. Used in revenue cycle management and referral tracking to monitor billing timeliness, calculate days-to-submission metrics, and reconcile referral authorizations against actual claims activity.

referral claim statusref_clm_sts_cd

A code indicating the current processing or adjudication status of a healthcare claim that originated from or is associated with a provider referral, used to track whether referred services have been submitted, pended, paid, or denied by the payer. This field is used in care coordination workflows to close the loop on referral completion and in revenue cycle analytics to identify referral leakage — cases where a referral was made but no corresponding claim was received within an expected timeframe.

referral classref_cls

Defines the classification tier of a specialist referral request, such as routine, urgent, or emergent, within care management and utilization management systems. Used to prioritize authorization processing, apply business rules, and segment referral data for reporting and population health management workflows.

referral coderef_cd

Stores the standardized or system-specific code value identifying the type, specialty, or authorization category of a specialist referral within care management, claims, and EHR systems. Used in data integration pipelines to map referral transactions to provider networks, authorization rules, and clinical classification taxonomies.

referral commentref_cmt

Contains unstructured free-text notations entered by clinical or administrative staff regarding a specialist referral request within EHR and care management systems. Used in data pipelines for NLP processing, audit documentation, and supplemental context extraction to enrich structured referral records during analytics workflows.

referral completed dateref_cmpl_dt

Calendar date on which the referred specialist service was fully rendered and the referral episode was closed. Used in care coordination and utilization management reporting to measure referral completion rates, track time-to-completion intervals, and confirm closure of open referral authorizations.

referral confidential indicatorref_conf_ind

Flag designating that a referral record contains sensitive patient information requiring restricted access, such as behavioral health, substance use, or reproductive health data. Governs data sharing permissions in referral management systems to ensure compliance with HIPAA and applicable federal privacy regulations.

referral countref_cnt

Represents the total number of specialist referral requests associated with a member, provider, or authorization within care management, claims, and utilization management systems. Used in aggregate reporting, utilization analysis, and population health dashboards to measure referral volume trends and care coordination effectiveness.

referral countryref_ctry

Country associated with the referred patient's address or the specialist's service location as recorded in the referral record. Relevant in cross-border care coordination scenarios and used in international member population reporting, network adequacy assessments, and global benefit plan administration.

referral created byref_crtd_by

Unique identifier of the user, clinician, or system that originated the referral record in the care management or EHR platform. Captured for audit trail purposes to support accountability, workflow routing, and compliance reviews related to referral initiation and authorization processes.

referral created dateref_crtd_dt

The date a specialist service referral record was initially created in an EHR, care management, or utilization management system. Used by data engineers to measure referral turnaround time, track care coordination timelines, and support HEDIS and quality reporting metrics related to specialist access and follow-up.

referral created timeref_crtd_tm

Precise timestamp recording when a referral record was first entered into the care management or referral tracking system. Used to establish the official start of the referral workflow, calculate authorization turnaround times, and support audit and compliance reporting for utilization management.

referral creatinineref_cr

Serum creatinine lab value documented at the time of referral initiation or during the referred specialist encounter. Used as a key biomarker of renal function to support nephrology referral justification, chronic kidney disease staging, and longitudinal monitoring throughout the referral care episode.

referral dateref_dt

The calendar date a referral to a specialist or ancillary service was issued in EHR, claims, or care management systems. Data engineers use this field to track referral-to-appointment lag times, validate authorization timelines, and support quality and utilization reporting across managed care and value-based care programs.

referral datetimeref_dttm

The combined date and time a specialist referral was initiated or processed in EHR, care management, or utilization management platforms. Data engineers use this field to establish precise event sequencing, measure referral response times, and support SLA tracking and operational reporting in care coordination workflows.

referral dea numberref_dea_nbr

The Drug Enforcement Administration registration number associated with a specialist or referring clinician on a referral record. Used in controlled substance workflows to verify prescribing authority and link referrals to licensed practitioners within managed care authorization systems.

PreviousPage 115 of 178Next