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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

record subtotalrec_subtot

An intermediate sum representing a partial aggregation of charges, units, or counts within a healthcare record before final totals are calculated. Used in claims processing and financial reporting to break down costs by service category, date range, or benefit type prior to adjudication.

record targetrec_tgt

Identifies the intended destination system, entity, or recipient for a healthcare information document. Used in HL7, claims routing, and EHR integration pipelines to ensure accurate delivery of clinical or administrative records across interoperable healthcare data platforms.

record taxonomy coderec_tax_cd

The NUCC Health Care Provider Taxonomy code associated with a record, identifying a clinician's specialty, subspecialty, or provider type. Used in claims adjudication and network management to validate scope of practice, apply correct reimbursement rules, and route authorizations appropriately.

record temperaturerec_temp

The measured body temperature value captured within a clinical record, typically expressed in degrees Fahrenheit or Celsius. Used in inpatient and outpatient clinical documentation to track patient vital signs, monitor for fever or hypothermia, and support clinical decision-making during care.

record termination daterec_term_dt

The date on which a healthcare record's validity or active status ends, such as the expiration of a member enrollment span, contract period, or authorization. Used in eligibility systems and data warehouses to define record lifecycle boundaries and support retroactive adjustments.

record timerec_tm

Captures the specific time of day a healthcare information document was created, modified, or processed within EHR, claims, or pharmacy systems. Used by data engineers to support time-based partitioning, event sequencing, and audit trail construction in healthcare data pipelines.

record timestamprec_ts

Stores the combined date and time value marking when a healthcare information document was created, updated, or transmitted within EHR, claims, or PBM systems. Critical for data lineage tracking, deduplication logic, and incremental load strategies in healthcare data engineering workflows.

record titlerec_ttl

The formal name or label assigned to a healthcare document or record, such as a clinical note type, policy title, or plan name. Used in document management systems and data catalogs to classify records, support retrieval workflows, and maintain consistent naming conventions across systems.

record totalrec_tot

Represents the aggregated sum of values within a healthcare information document, such as total charges on a claim or total dispensed units in a pharmacy record. Used in reconciliation processes across claims, PBM, and billing systems to validate financial and clinical data accuracy.

record total countrec_tot_cnt

The complete count of records, line items, services, or occurrences within a healthcare dataset or transaction batch. Used in claims processing, pharmacy reconciliation, and data quality audits to validate completeness and ensure all expected records are accounted for during processing.

record typerec_typ

Classifies a healthcare information document into a defined category such as professional claim, institutional claim, pharmacy transaction, or enrollment record. Used in EHR, claims, and PBM systems to drive business logic, routing rules, and schema selection during data ingestion and transformation.

record unitrec_unt

The standardized unit of measure associated with a value stored in a healthcare record, such as mg, mL, or days supply. Used in EHR, pharmacy, and lab result systems to ensure dimensional consistency during data normalization, aggregation, and cross-system comparisons in ETL pipelines.

record updated daterec_upd_dt

The date on which a healthcare record was most recently modified, corrected, or refreshed within a system. Used in data governance, audit logging, and ETL processing to identify changed records, manage incremental data loads, and maintain accurate historical tracking across clinical and administrative systems.

record urgencyrec_urg

A coded or descriptive indicator of the clinical or operational priority level assigned to a healthcare record, such as routine, urgent, or emergent. Used in care management, prior authorization, and referral workflows to determine processing timelines and ensure timely responses per regulatory and clinical standards.

record valuerec_val

Represents a discrete measured or observed data point captured within a healthcare information document, such as a lab result, vital sign reading, or claim line amount. Used across EHR, claims, and pharmacy systems to store quantitative or qualitative clinical and financial information for downstream analytics.

record versionrec_ver

A sequential numeric or alphanumeric identifier that tracks the iteration of a healthcare record following updates or corrections. Used in clinical data warehouses and claims systems to distinguish original records from amendments, support audit trails, and ensure downstream systems process the most current data.

record ziprec_zip

The five or nine digit US postal code associated with a healthcare record, reflecting the geographic location of a member, patient, or service site. Used in claims processing, member enrollment, network adequacy analysis, and population health reporting to support geographic segmentation and benefit determination.

referral addressref_addr

Physical location details, including street, city, state, and ZIP, associated with the specialist or facility named in a referral request. Used in EHR and managed care systems to route authorizations, validate network participation, and support provider directory matching during claims adjudication workflows.

referral approval statusref_appr_sts

A coded value indicating the current authorization decision for a specialist or ancillary service referral, such as approved, pending, denied, or cancelled. Used in utilization management and care coordination workflows to determine whether a referred service is covered and to trigger appropriate member and provider notifications.

referral charge amountref_chrg_amt

The billed or expected charge associated with a specialist or ancillary service referral, representing the cost of the referred encounter or procedure. Used in utilization management and claims processing to estimate financial liability, apply cost-sharing rules, and reconcile actual paid amounts against anticipated referral costs.

PreviousPage 200 of 325Next