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 countemerg_cnt

Numeric tally of emergency department or urgent care visits for a member within a defined period, used in claims and EHR analytics to identify high-utilization patients, support care management programs, and calculate risk scores in PBM and managed care reporting systems.

emergency countryemerg_ctry

The nation in which emergency care services were rendered or where the patient is domiciled. Used in claims and enrollment systems to support international coverage determinations, coordination of benefits, and geographic analysis of emergency utilization patterns.

emergency created byemerg_crtd_by

The unique identifier of the user, clinician, or system that originated the emergency encounter record in the healthcare information system. Used in audit trails and data governance workflows to establish record provenance and accountability within ED and claims platforms.

emergency created dateemerg_crtd_dt

Timestamp recorded when an emergency encounter record is first instantiated in an EHR, claims, or care management system. Used for audit trails, SLA compliance tracking, and data lineage in emergency department workflows and downstream analytics pipelines.

emergency created timeemerg_crtd_tm

The timestamp indicating when the emergency encounter record was first created in the system of record. Used in clinical and operational workflows to establish data entry timelines, support audit logging, and measure documentation timeliness relative to patient arrival.

emergency creatinineemerg_cr

The serum or urine creatinine laboratory value measured during an emergency encounter, serving as a key biomarker for assessing acute kidney function. Captured in clinical data systems to support ED diagnosis coding, renal injury protocols, and downstream quality reporting.

emergency dateemerg_dt

Calendar date on which an emergency or urgent care encounter occurred, captured in EHR admission records and professional or institutional claims. Used for episode grouping, utilization trending, and timely filing validation in claims adjudication systems.

emergency datetimeemerg_dttm

Combined date and timestamp marking the precise moment an emergency encounter began or was recorded in an EHR or claims system. Supports time-sensitive workflows such as triage sequencing, door-to-provider time calculations, and real-time ED throughput analytics.

emergency dea numberemerg_dea_nbr

The Drug Enforcement Administration registration number associated with the prescribing clinician involved in an emergency encounter. Used in pharmacy and clinical records to validate controlled substance prescribing authority and support regulatory compliance and audit workflows.

emergency death dateemerg_death_dt

Date of patient death associated with an emergency encounter, recorded in EHR mortality tracking and institutional claims via condition code 17 or discharge status code 20. Used for quality reporting, mortality rate analysis, and CMS value-based care program submissions.

emergency deductible amountemerg_ded_amt

The dollar amount applied toward a member's annual deductible as a result of an emergency department visit. Captured during claims adjudication to track accumulator balances, determine cost-sharing responsibility, and support accurate explanation of benefits generation.

emergency deleted dateemerg_del_dt

The calendar date on which an emergency encounter record was logically removed or voided from the active dataset. Used in data governance and audit processes to maintain a complete record history, support compliance reviews, and track data lifecycle management in clinical systems.

emergency deleted indicatoremerg_del_ind

A flag identifying that an emergency encounter record has been logically deleted or voided without physical removal from the database. Used in claims and clinical systems to exclude inactive records from reporting while preserving the full audit history for compliance and reconciliation purposes.

emergency descriptionemerg_desc

Free-text or coded narrative field describing the nature of an emergency encounter, captured in EHR chief complaint fields and claims remarks. Used in clinical documentation, NLP pipelines, and quality audits to categorize emergency visit reasons across ED information systems.

emergency detailemerg_dtl

Granular clinical or administrative information associated with an emergency encounter, including triage notes, procedure specifics, and disposition details stored in EHR encounter records. Referenced by data engineers building ED analytics pipelines and population health platforms.

emergency discharge dateemerg_dsch_dt

Date on which a patient was formally released from an emergency department or transitioned to inpatient status, captured in EHR ADT systems and institutional claims. Used to calculate ED length of stay, boarding metrics, and readmission risk in quality reporting workflows.

emergency due dateemerg_due_dt

The date by which a payment obligation, clinical action, or administrative task associated with an emergency encounter must be completed. Used in billing and revenue cycle systems to manage accounts receivable timelines, track claim payment deadlines, and trigger follow-up workflows.

emergency durationemerg_dur

The total elapsed time from patient registration or triage to discharge or admission for an emergency department encounter. Used in operational and quality reporting to measure ED throughput efficiency, benchmark against CMS metrics, and support capacity management initiatives.

emergency effective dateemerg_eff_dt

Date on which an emergency-related record, authorization, or benefit provision becomes active within a claims, EHR, or member enrollment system. Used in eligibility validation, prior authorization tracking, and contract management for emergency care services under managed care plans.

emergency emailemerg_eml

Electronic mail address associated with an emergency contact or provider involved in urgent care coordination, stored in EHR patient demographics or provider directory systems. Used for automated notifications, care coordination messaging, and patient communication workflows in health IT platforms.

PreviousPage 223 of 806Next