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 start dateemerg_start_dt

Date field (emerg_start_dt) capturing the precise calendar date an emergency encounter or episode of care began, stored in EHR, hospital ADT, and claims systems. Critical for calculating length of stay, episode duration, timely filing compliance, and emergency department throughput reporting.

emergency start timeemerg_start_tm

The timestamp marking the beginning of an emergency department encounter, typically recorded at patient arrival or triage initiation. Used to calculate door-to-provider time, track ED throughput metrics, and support performance benchmarking and regulatory reporting for emergency care quality.

emergency stateemerg_st

The US state or territory associated with an emergency department encounter, typically reflecting the facility location or patient's home address. Used in ED administrative records for jurisdictional reporting, public health surveillance, and geographic analysis of emergency care utilization patterns.

emergency statusemerg_sts

Field (emerg_sts) in EHR and claims systems indicating the current processing or clinical state of an emergency encounter, such as active, discharged, admitted, or billed. Used by utilization management platforms and revenue cycle systems to track case progression and trigger workflow automation.

emergency street addressemerg_st_addr

The street-level address associated with an emergency department encounter, capturing either the patient's residence or the treating facility location. Used in ED administrative records to support patient contact, care coordination, social determinants of health screening, and geographic utilization analysis.

emergency strengthemerg_str

The concentration or potency of a medication administered during an emergency department encounter, expressed as the amount of active ingredient per unit dose. Recorded in ED medication administration records to ensure accurate dosing, support pharmacist review, and maintain complete clinical documentation.

emergency subtotalemerg_subtot

The partial sum of charges or costs attributable to a subset of services within an emergency department encounter, prior to applying adjustments, taxes, or additional fees. Used in ED billing records to break down the cost components of a claim before calculating the final billed amount.

emergency surgery dateemerg_surg_dt

The date on which a surgical procedure was performed in connection with an emergency department encounter or urgent inpatient admission. Recorded in operative and ED clinical records to track time from presentation to intervention, supporting quality measures for emergency surgical care.

emergency system identifieremerg_sys_id

The unique system-generated identifier assigned to an emergency department encounter within a health information system. Used as the primary key to link ED clinical, billing, and administrative records across EHR platforms, data warehouses, and downstream systems for reporting and care coordination.

emergency targetemerg_tgt

Reference field (emerg_tgt) in ED workflow and care coordination systems identifying the destination or receiving entity for an emergency patient, such as a receiving facility, specialty unit, or care team. Used in transfer records, EHR routing logic, and interoperability data exchanges to support continuity of care.

emergency taxonomy codeemerg_tax_cd

The National Uniform Claim Committee taxonomy code identifying the specialty classification of the clinician or facility providing emergency department services. Used in ED claims and credentialing records to designate provider type, support accurate claims adjudication, and meet payer enrollment requirements.

emergency temperatureemerg_temp

The body temperature, measured in Fahrenheit or Celsius, recorded as part of the vital signs assessment during an emergency department encounter. Used in ED triage and clinical documentation to identify fever, hypothermia, or sepsis indicators that inform diagnostic workup and treatment decisions.

emergency termination dateemerg_term_dt

The date on which an emergency department record, authorization, or related service period officially ended or was closed. Used in ED administrative and utilization management systems to define the active window of a treatment episode and support claims adjudication and reporting timelines.

emergency timeemerg_tm

Time-of-day field (emerg_tm) stored in EHR, ADT, and claims systems capturing the specific clock time of an emergency event, triage, or intervention. Essential for calculating door-to-provider intervals, ED throughput metrics, CMS quality measures, and shift-based staffing analysis in hospital operational reporting.

emergency timestampemerg_ts

Combined date-time field (emerg_ts) in EHR, claims, and ADT systems recording the precise moment an emergency encounter event occurred, including triage, assessment, or intervention. Supports audit trails, regulatory reporting, care gap analysis, and synchronization across integrated health information exchange platforms.

emergency titleemerg_ttl

The formal name or label assigned to an emergency department encounter type, protocol, or clinical record, such as the designation of an ED visit category or procedure name. Used in ED documentation systems to standardize record classification and support consistent reporting across clinical workflows.

emergency totalemerg_tot

Aggregated numeric field (emerg_tot) in claims and hospital billing systems representing the sum of charges, visits, or units associated with an emergency encounter. Used in revenue cycle management, payer contract performance reporting, and population health analytics to measure ED utilization cost and volume trends.

emergency total countemerg_tot_cnt

The aggregate number of emergency department encounters, events, or service units within a defined reporting period or patient episode. Used in ED operational analytics and population health reporting to measure utilization volume, identify high-frequency users, and support capacity planning and quality initiatives.

emergency typeemerg_typ

Categorical classification field (emerg_typ) in EHR and claims systems distinguishing emergency encounter categories such as trauma, cardiac, behavioral health, or obstetric events. Drives coding workflows, DRG assignment, triage protocols, and downstream analytics in hospital billing, utilization management, and public health reporting systems.

emergency updated dateemerg_upd_dt

The date on which an emergency department encounter record was most recently modified or amended in the health information system. Used to track documentation changes, support data governance and audit trail requirements, and ensure downstream systems reflect the most current clinical and administrative information.

PreviousPage 228 of 806Next