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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

emergency urgencyemerg_urg

Captures the triage urgency classification assigned to a patient presenting for emergency or urgent care, such as emergent, urgent, or non-urgent. Drives resource allocation, care prioritization, and supports ED throughput analytics and patient acuity reporting in clinical systems.

emergency valueemerg_val

Numeric or coded data field (emerg_val) in EHR and claims systems capturing a specific measured or assessed value within an emergency encounter, such as a vital sign, lab result, or severity score. Used in clinical decision support, quality reporting, and risk stratification analytics tied to emergency care episodes.

emergency versionemerg_ver

Tracks the sequential version number of an emergency or urgent care encounter record, incrementing each time the record is updated or amended. Supports audit trail integrity, record reconciliation, and downstream processing in clinical data warehouses and EHR systems.

emergency zipemerg_zip

Records the postal ZIP code associated with the patient's address at the time of an emergency or urgent care visit. Used in population health analytics, geographic disparity reporting, care gap identification, and public health surveillance for emergency service utilization patterns.

encounter account numberenc_acct_nbr

The unique billing account identifier assigned to a specific patient encounter, linking clinical services to the revenue cycle. Used to reconcile charges, payments, and adjustments across EHR, hospital information systems, and claims processing platforms throughout the billing lifecycle.

encounter active indicatorenc_actv_ind

A binary flag indicating whether a healthcare encounter record is currently active or has been deactivated, voided, or replaced. Used in EHR and data warehouse environments to filter valid records for clinical reporting, billing workflows, and downstream system integrations.

encounter active statusenc_actv_sts

Describes the current activity state of a healthcare encounter, such as scheduled, in-progress, completed, or cancelled. Used across EHR and clinical operations platforms to manage care delivery workflows, appointment tracking, and encounter lifecycle reporting in ambulatory and inpatient settings.

encounter addressenc_addr

Physical location field capturing the street address, city, state, and ZIP where a healthcare service interaction occurred. Stored in EHR and claims systems to support provider network validation, geographic analysis, and service site identification in institutional and professional claim records.

encounter adjustment amountenc_adj_amt

The monetary value of contractual, administrative, or financial adjustments applied to an encounter's charges, such as payer contractual write-offs or corrections. Used in revenue cycle management to reconcile billed charges against net reimbursable amounts across claims and billing systems.

encounter admission dateenc_admn_dt

Date field capturing when a patient was formally admitted to a facility for inpatient or observation services. Used in EHR, claims, and HIPAA 837I transaction systems to calculate length of stay, trigger DRG grouping logic, coordinate benefits, and support utilization management workflows.

encounter ageenc_age

Records the patient's age at the time of the healthcare encounter, typically calculated from date of birth to the encounter date. Used in clinical analytics, risk stratification, age-specific quality measure reporting, and demographic analysis across ambulatory, inpatient, and claims datasets.

encounter allowed amountenc_alwd_amt

The maximum dollar amount a payer will reimburse for services rendered during an encounter, based on contracted rates or fee schedules. Used in revenue cycle management to calculate patient responsibility, contractual adjustments, and net reimbursement across claim adjudication workflows.

encounter amountenc_amt

Monetary value associated with a specific healthcare service interaction, representing billed, allowed, or paid charges at the encounter level. Used in claims adjudication, EHR billing modules, and PBM systems to support cost analytics, reimbursement calculations, and financial reconciliation reporting.

encounter approval statusenc_appr_sts

Indicates the authorization or approval state of an encounter, such as pending review, approved, or denied. Used in clinical documentation workflows, care management platforms, and utilization management systems to track whether an encounter has met payer or internal authorization requirements prior to billing.

encounter approved byenc_appr_by

Identifies the user, clinician, or supervisor who authorized or approved the encounter record, such as a supervising physician or billing reviewer. Used in audit trails, clinical documentation compliance workflows, and quality assurance processes within EHR and practice management systems.

encounter arrival timeenc_arrv_tm

Records the exact time a patient physically arrived for a healthcare encounter, used in ED throughput analysis, wait time calculations, and door-to-provider metrics. Supports operational performance reporting, patient experience measurement, and regulatory reporting in emergency and ambulatory care settings.

encounter arrived dateenc_arrv_dt

Captures the calendar date on which a patient arrived for a scheduled or unscheduled healthcare encounter. Used in operational reporting, appointment adherence tracking, and care gap analysis across ambulatory, emergency, and inpatient settings within EHR and clinical data warehouse platforms.

encounter assessmentenc_asmt

Contains the clinician's documented clinical assessment or diagnostic impression resulting from the encounter, often corresponding to the Assessment section of a SOAP note. Used to capture diagnostic reasoning, support coding workflows, and populate clinical summaries in EHR and health information exchange systems.

encounter averageenc_avg

Calculated metric representing the mean monetary or utilization value across a defined set of healthcare service interactions. Used in claims analytics, population health platforms, and PBM reporting systems to benchmark provider efficiency, assess cost trends, and support actuarial and quality improvement analyses.

encounter balanceenc_bal

Outstanding financial amount remaining on a healthcare service interaction after insurance payments, adjustments, and patient payments are applied. Used in EHR billing systems, claims adjudication platforms, and patient financial services modules to track accounts receivable and drive patient responsibility workflows.

PreviousPage 229 of 806Next