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 completed daterec_cmpl_dt

The service completion date for a healthcare information document. Used to track temporal information related to record completed 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 confidential indicatorrec_conf_ind

The privacy protection flag for a healthcare information document. Used to track the current state or condition of the record. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for record management and reporting.

record contactrec_cntct

Communication reference point associated with a healthcare document, capturing provider, member, or facility contact details in EHR and member enrollment systems. Data engineers use this field to support outreach workflows, provider directory reconciliation, and master data management linkage processes.

record countrec_cnt

Numeric value representing the total occurrences of a specific healthcare record type within EHR, claims, or pharmacy data sets. Used by data engineers for data volume validation, pipeline throughput monitoring, reconciliation checks between source and target systems, and anomaly detection in batch processing jobs.

record countryrec_ctry

The nation name 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 created byrec_crtd_by

The creating user identifier 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 created daterec_crtd_dt

System-generated timestamp capturing when a healthcare document was first written to EHR, claims adjudication, or enrollment platforms. Critical for data engineers building audit trails, incremental load strategies, change data capture pipelines, and SLA compliance reporting across healthcare data warehouses.

record created timerec_crtd_tm

The record creation time for a healthcare information document. Used to track temporal information related to record created 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 creatininerec_cr

The kidney function marker 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 daterec_dt

Calendar date value associated with a healthcare document in EHR, claims, and pharmacy systems, representing the business-relevant date of the record event. Data engineers use this field for temporal partitioning, date-range filtering, cohort analysis, and aligning records across disparate source system timelines.

record datetimerec_dttm

Combined date and time timestamp for a healthcare document in EHR, claims, and PBM systems, providing precise temporal context beyond date-only fields. Data engineers rely on this field for event sequencing, latency calculations, real-time streaming pipelines, and sub-daily partitioning in data lake architectures.

record dea numberrec_dea_nbr

The drug enforcement administration number 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 death daterec_death_dt

Date field capturing the recorded date of member or patient death within EHR, member enrollment, and claims systems. Data engineers use this field to terminate eligibility spans, suppress downstream communications, update master patient indexes, and trigger mortality-based cohort exclusions in analytics pipelines.

record deleted daterec_del_dt

The record deletion date for a healthcare information document. Used to track temporal information related to record deleted 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 deleted indicatorrec_del_ind

The removal status flag for a healthcare information document. Used to track the current state or condition of the record. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for record management and reporting.

record descriptionrec_desc

Textual explanation field providing human-readable context for a healthcare document in EHR, claims, and care management systems. Data engineers use this field for full-text search indexing, metadata cataloging, data lineage documentation, and enriching downstream analytical datasets with descriptive record context.

record detailrec_dtl

Granular information field containing specific clinical, administrative, or financial attributes of a healthcare document in EHR, claims, and pharmacy systems. Data engineers parse and normalize this field during ETL processing to extract structured data elements for dimensional modeling and reporting layer population.

record due daterec_due_dt

The payment deadline date for a healthcare information document. Used to track temporal information related to record due 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 durationrec_dur

The time span length 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 effective daterec_eff_dt

The date on which a healthcare information document or record becomes active and valid within a system. Used in member enrollment, provider contracts, and benefit configuration systems to define coverage start dates, eligibility windows, and temporal data integrity in healthcare data environments.

PreviousPage 191 of 320Next