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 emailrec_eml

Electronic mail address associated with a healthcare document record in EHR, member enrollment, and provider directory systems. Data engineers must apply PHI masking, format validation, and deduplication logic when processing this field across member communication, outreach, and identity resolution pipelines.

record end daterec_end_dt

Date value marking the completion or closure of a healthcare document's effective period in EHR, claims, and member enrollment systems. Data engineers use this field to manage slowly changing dimensions, define coverage spans, filter active records, and construct valid-time temporal tables in analytical data stores.

record end timerec_end_tm

The completion time value for a healthcare information document. Used to track temporal information related to record end 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 entered byrec_ent_by

The data entry user 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 ethnicityrec_ethn

The cultural 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 expiration daterec_exp_dt

Date field indicating when a healthcare document or credential becomes invalid in EHR, provider credentialing, and payer contract systems. Data engineers use this field to automate record archival, trigger renewal workflows, enforce data retention policies, and filter expired records from active analytical datasets.

record external identifierrec_ext_id

The external system reference id 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 faxrec_fax

The facsimile 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 feerec_fee

The service charge 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 first namerec_first_nm

The given name for a healthcare information document. Used to display and describe the record in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for record management and reporting.

record flagrec_flg

Binary or enumerated status marker applied to a healthcare document in EHR, claims adjudication, and pharmacy systems to indicate special processing states such as audit review, fraud suspicion, or clinical alert. Data engineers use this field to route records through conditional transformation logic and exception handling workflows.

record frequencyrec_freq

The dosing schedule 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 full namerec_full_nm

The complete name for a healthcare information document. Used to display and describe the record in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for record management and reporting.

record genderrec_gndr

The sex 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 glucoserec_gluc

The blood sugar 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 group numberrec_grp_nbr

The insurance group identifier 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 hemoglobinrec_hgb

The blood hemoglobin 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 identifierrec_id

Unique key value assigned to a healthcare document in EHR, claims, pharmacy, and enrollment systems to enable precise record retrieval and cross-system linkage. Data engineers rely on this field as a primary or foreign key in relational models, deduplication logic, and master data management reconciliation processes.

record indexrec_idx

Positional or sequential number assigned to a healthcare document within a dataset, batch file, or document set in EHR and claims processing systems. Data engineers use this field to maintain processing order, support pagination in API extracts, and enable row-level tracking during bulk ingestion and transformation jobs.

record indicatorrec_ind

Boolean or coded state value attached to a healthcare document in EHR, claims, and PBM systems signaling a specific condition such as active status, eligibility confirmation, or prior authorization approval. Data engineers use this field as a filter predicate, conditional join key, and business rule trigger in transformation pipelines.

PreviousPage 192 of 320Next