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

Operations

Scheduling, facilities, departments, workflows, and staff

6,387 operations terms

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 provider specialty classification for a healthcare information document. Used as a unique reference to identify and track the record across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for record management and reporting.

record temperaturerec_temp

The body temperature value for a healthcare information document. 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 record management and reporting.

record termination daterec_term_dt

The ending date value for a healthcare information document. Used to track temporal information related to record termination date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for record management and reporting.

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 designation for a healthcare information document. 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 record management and reporting.

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 sum of occurrences for a healthcare information document. 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 record management and reporting.

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 last change date for a healthcare information document. Used to track temporal information related to record updated date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for record management and reporting.

record urgencyrec_urg

The time sensitivity level for a healthcare information document. 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 record management and reporting.

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

The record version number for a healthcare information document. 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 record management and reporting.

record ziprec_zip

The postal code for a healthcare information document. 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 record management and reporting.

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

The authorization state for a provider-to-provider patient direction. Used to track the current state or condition of the referral. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for referral management and reporting.

referral charge amountref_chrg_amt

The service charge value for a provider-to-provider patient direction. Used to capture financial data associated with referral transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for referral management and reporting.

referral effective dateref_eff_dt

The calendar date on which a specialist referral authorization becomes valid for use. Used in EHR, managed care, and claims systems to enforce referral validity windows during adjudication, ensuring services rendered outside the effective period are flagged for review or denial by data engineers.

PreviousPage 196 of 320Next