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 referencerec_ref

External pointer or cross-reference identifier linking a healthcare record to related documents, transactions, or systems. Used in EHR, claims, and PBM platforms to maintain referential integrity across source systems during ETL processing and data lineage tracking.

record resolution daterec_resol_dt

The condition end date for a healthcare information document. Used to track temporal information related to record resolution 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 respirationrec_resp

The breathing rate 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 revisionrec_rev

The update iteration 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 riskrec_rsk

The danger level assessment 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 routerec_rte

The administration pathway 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 scheduled daterec_sched_dt

The planned appointment date for a healthcare information document. Used to track temporal information related to record scheduled 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 scheduled timerec_sched_tm

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

record scorerec_scr

Calculated numeric or alpha rating assigned to a healthcare record, such as a risk score, quality measure score, or match confidence score. Used in EHR, claims analytics, and member enrollment systems to prioritize records for clinical or administrative workflows.

record sequencerec_seq

Numeric ordering value assigned to healthcare records to establish processing order or version history within a dataset. Used in EHR, claims, and pharmacy systems to manage chronological sequencing of transactions, adjustments, and multi-line claim records during ETL loads.

record severityrec_sev

Coded or descriptive indicator capturing the seriousness of a clinical condition, error, or event within a healthcare record. Used in EHR, adverse event reporting, and claims systems to classify diagnoses or data quality issues for triage, routing, and reporting by data engineers.

record sexrec_sex

The biological classification 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 sourcerec_src

Origin identifier indicating the system, facility, or organization that generated a healthcare record. Critical in EHR, claims, PBM, and member enrollment platforms for data lineage tracking, source-to-target mapping, and resolving conflicts during master patient index matching.

record start daterec_start_dt

The effective beginning date marking when a healthcare record becomes active or valid within a system. Used in EHR, claims, member enrollment, and pharmacy platforms to define temporal validity windows for slowly changing dimension (SCD) processing and longitudinal data analysis.

record start timerec_start_tm

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

record staterec_st

The state or province 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 statusrec_sts

Indicates the current processing or lifecycle state of a healthcare information document within EHR, claims, or enrollment systems. Common values include active, pending, voided, or closed, enabling data engineers to filter or route records accurately during ETL workflows.

record street addressrec_st_addr

The street location 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 strengthrec_str

The drug concentration 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 subtotalrec_subtot

The partial sum 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.

PreviousPage 195 of 320Next