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 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.

record instructionrec_instr

The guidance or directive text embedded within a healthcare information document to indicate processing rules or special handling requirements. Used in claims, enrollment, and EHR systems to communicate adjudication instructions, coordination of benefits directives, or data entry guidance to downstream processing workflows.

record keyrec_key

Represents the primary or surrogate key value used to uniquely identify a record within a healthcare data system or warehouse. Enables reliable record linkage, deduplication, and cross-system joins across clinical, claims, enrollment, and pharmacy datasets.

record languagerec_lang

Captures the preferred spoken or written language of an individual associated with a healthcare record, typically coded using ISO 639 standards. Used in member enrollment, care coordination, and patient communication workflows to ensure appropriate language access services.

record last namerec_last_nm

Stores the family surname of an individual associated with a healthcare record, used as a core identity attribute for patient matching, member enrollment, claims filing, and clinical documentation across health information systems.

record legal namerec_legal_nm

Captures the officially registered legal name of an individual as it appears on government-issued identification or legal documents. Used in member enrollment, provider credentialing, prior authorization, and billing workflows where legal identity verification is required.

record levelrec_lvl

The hierarchical position or tier assigned to a healthcare information document within a structured data model. Used in claims, enrollment, and benefit plan systems to indicate whether a record represents a header, detail, or summary level, supporting parent-child data relationships and multi-level reporting structures.

record license numberrec_lic_nbr

Stores the state-issued professional license number assigned to a healthcare provider or clinician. Used in provider credentialing, network enrollment, claims adjudication, and regulatory compliance reporting to verify active licensure and scope of practice.

record marital statusrec_mar_sts

Captures the legal marital status of an individual associated with a healthcare record, such as Single, Married, Divorced, or Widowed. Used in member enrollment, benefits eligibility determination, dependent coverage verification, and social determinants of health assessments.

record master identifierrec_mstr_id

Stores the enterprise master patient or member identifier assigned through an Master Person Index system, enabling consistent identity resolution across disparate clinical, claims, pharmacy, and enrollment data sources within a health system or payer organization.

record maximumrec_max

Represents the upper boundary or ceiling value defined for a clinical measurement, dosage parameter, benefit limit, or authorization threshold within a healthcare record. Used in utilization management, clinical decision support, and pharmacy benefit configuration.

record medical record numberrec_mrn

Stores the unique Medical Record Number assigned to a patient by a specific healthcare facility or health system. Serves as the primary patient identifier within that facility's EHR, linking all clinical encounters, orders, results, and documentation for that individual.

record middle namerec_mid_nm

Captures the middle name or initial of an individual associated with a healthcare record, used as a supplementary identity attribute to improve patient matching accuracy in member enrollment, clinical registration, and claims processing systems.

record minimumrec_min

Represents the lower boundary or floor value defined for a clinical measurement, dosage parameter, benefit threshold, or authorization requirement within a healthcare record. Used in clinical decision support, pharmacy benefit management, and utilization review workflows.

record mobilerec_mob

Stores the mobile or cellular telephone number associated with an individual's healthcare record. Used in member outreach, appointment reminders, care gap notifications, two-factor authentication, and emergency contact workflows across health plan and provider systems.

record modified byrec_mod_by

Captures the user ID or system identifier responsible for the most recent update to a healthcare record. Used in audit trail tracking, data governance, and compliance reporting to maintain accountability for changes made to clinical, claims, or enrollment data.

record modified daterec_mod_dt

The timestamp or date on which a healthcare information document was last updated or changed within a system of record. Used in EHR, claims, and enrollment platforms for audit trail maintenance, change data capture (CDC) processing, and data synchronization across integrated healthcare data pipelines.

record modified timerec_mod_tm

Stores the timestamp reflecting when a healthcare record was most recently updated or changed within a data system. Used in audit logging, data synchronization, change data capture pipelines, and compliance tracking to establish chronological history of record modifications.

record namerec_nm

The display label or descriptive text identifier assigned to a healthcare information document or entity record. Used in EHR, provider directories, and enrollment systems to store member names, facility names, or plan names for identification, search, and reporting purposes within healthcare data platforms.

record noterec_nt

The free-text or structured annotation associated with a healthcare information document, capturing supplemental clinical, administrative, or operational commentary. Used in EHR, claims, and care management systems to document exceptions, clinical observations, or processing remarks for audit and workflow support.

PreviousPage 197 of 325Next