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 agerec_age

The calculated age or elapsed time of a data record since its creation or effective date within a healthcare information system. Used in data governance, retention management, and audit processes to identify records approaching purge thresholds, assess data currency, or trigger review workflows.

record allowed amountrec_alwd_amt

The maximum dollar amount a payer will reimburse for a specific service as reflected in a claims or remittance record. Derived from contracted fee schedules or adjudication logic, this value drives payment calculations, patient cost-sharing determinations, and provider payment reconciliation in claims processing systems.

record amountrec_amt

The monetary value captured within a healthcare information document, such as a claim, remittance, or enrollment record. Used in EHR, claims adjudication, and PBM systems to represent billed, allowed, paid, or contractual amounts for financial reconciliation and reporting workflows.

record approval statusrec_appr_sts

A coded value indicating the current authorization state of a data record within a clinical or administrative workflow, such as pending, approved, rejected, or under review. Used in systems requiring multi-step validation, such as prior authorization platforms, clinical documentation review, and administrative record governance processes.

record approved byrec_appr_by

The identifier or name of the user, clinician, or administrator who authorized or approved a specific data record within a healthcare information system. Captured for audit trail purposes, compliance reporting, and accountability tracking across clinical documentation, billing authorization, and data governance workflows.

record arrival timerec_arrv_tm

The clock time at which a patient physically arrived at a care facility or the time a data record was received by a processing system. Used in emergency department throughput tracking, scheduling adherence analysis, and claims adjudication to measure timeliness and support operational performance reporting.

record arrived daterec_arrv_dt

The calendar date on which a patient arrived at a healthcare facility or a data record was received by an administrative or clinical system. Used in encounter management, claims processing, and scheduling systems to establish visit timelines, measure access metrics, and support regulatory reporting requirements.

record assessmentrec_asmt

The clinical evaluation or diagnostic impression documented within a healthcare record, capturing the clinician's interpretation of a patient's condition based on subjective and objective findings. Corresponds to the assessment component of SOAP-structured clinical notes and supports coding, care planning, and quality measure documentation.

record balancerec_bal

The outstanding or remaining monetary amount associated with a healthcare information document, such as an unpaid claim or member account balance. Used in claims, billing, and accounts receivable systems to track unresolved financial obligations and support revenue cycle management processes.

record billed amountrec_bill_amt

The total dollar amount submitted by a provider on a claim or invoice for services rendered, before payer adjudication or contractual adjustments are applied. Represents the gross charge captured in claims data and serves as the starting point for allowed amount calculation, write-off analysis, and revenue cycle reporting.

record birth daterec_birth_dt

The date of birth value stored within a healthcare information document for a member, patient, or dependent record. Used across EHR, enrollment, and claims systems for eligibility verification, age-based benefit determination, HIPAA compliance, and demographic data validation in healthcare data pipelines.

record blood pressurerec_bp

The systolic and diastolic arterial pressure values documented within a clinical encounter record, typically expressed in mmHg. Captured as a vital sign during patient assessments, this data element supports chronic disease management, hypertension monitoring, medication titration decisions, and population health quality measure reporting.

record cancelled daterec_cncl_dt

The calendar date on which a healthcare record, appointment, order, or transaction was officially cancelled within a clinical or administrative system. Used in scheduling analytics, claims adjustment tracking, and operational reporting to measure cancellation rates, identify patterns, and support downstream workflow notifications.

record categoryrec_cat

Hierarchical grouping classification assigned to healthcare information documents in EHR, claims, and document management systems. Enables data engineers to segment records by type (clinical, administrative, financial) for downstream processing, reporting pipelines, and data governance workflows.

record charge amountrec_chrg_amt

The gross dollar amount charged for a specific healthcare service or item as recorded on a claim or encounter record, reflecting the provider's standard fee before any payer contractual adjustments or patient cost-sharing. Used in revenue cycle management, charge capture audits, and financial performance analysis.

record chief complaintrec_cc

The primary symptom or reason for a clinical encounter as documented in the health record. Captures the patient's self-reported complaint in their own words, driving triage decisions, clinical documentation, and care planning across inpatient and outpatient settings.

record childrec_chld

Subordinate record linked to a parent in a parent-child hierarchy within EHR, claims adjudication, and enrollment systems. Used by data engineers to model relational dependencies, traverse document trees, and maintain referential integrity across healthcare data pipelines and ETL processes.

record cityrec_city

The municipality name associated with a health record, typically reflecting a patient's residential address or a facility's location. Used in member enrollment, claims adjudication, geographic analysis, and population health reporting to support regional care coordination.

record classrec_cls

Classification tier assigned to healthcare documents within EHR, claims, and PBM systems that defines the structural type and handling rules for a record. Data engineers use this field to route records through appropriate validation logic, transformation layers, and storage partitioning strategies.

record coderec_cd

Standardized coded value assigned to a healthcare document in EHR, claims, and pharmacy systems, often referencing controlled vocabularies such as ICD, CPT, or proprietary payer codes. Used by data engineers to classify, filter, and join records across heterogeneous source systems during ingestion and transformation.

PreviousPage 194 of 325Next