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 rangeemerg_rng

Defined minimum and maximum boundary values associated with an emergency or urgent care service metric, such as acceptable response time thresholds or vital sign reference ranges within EHR and clinical analytics systems. Used by data engineers to apply data validation rules, flag outliers, and enforce quality checks on emergency encounter data.

emergency rateemerg_rt

Unit price or reimbursement rate applied to an emergency or urgent care service within claims, fee schedule, or PBM systems. Reflects contracted rates, CMS facility fee schedules, or blended payment amounts. Used by data engineers to calculate allowed amounts, validate claim adjudication outputs, and populate emergency service cost tables.

emergency ratingemerg_rtg

A scored assessment value assigned during an emergency department encounter, such as a triage acuity level, pain scale score, or severity rating. Used to standardize clinical decision-making, prioritize patient care based on urgency, and support quality measurement and benchmarking of emergency department performance.

emergency ratioemerg_ratio

A proportional measure used in emergency department operations or clinical assessment, such as staff-to-patient ratios, bed occupancy rates, or clinical index values. Used to monitor emergency department capacity, staffing adequacy, and clinical risk levels that influence patient safety and care quality outcomes.

emergency reasonemerg_rsn

Coded or free-text explanation documenting why an emergency or urgent care service was initiated, such as chief complaint, ICD-10 diagnosis, or referral cause within EHR and claims systems. Used by data engineers to categorize encounter drivers, support clinical analytics, and populate emergency utilization reason codes in reporting pipelines.

emergency received dateemerg_rcvd_dt

The date on which an emergency department claim, referral, authorization request, or patient record was received and logged by the processing entity. Used in claims management and utilization review workflows to measure intake timeliness, track payer response windows, and ensure compliance with regulatory processing deadlines for emergency care submissions.

emergency referenceemerg_ref

External identifier or cross-system pointer linking an emergency or urgent care service record to a related entity such as an authorization number, prior claim, or external registry within EHR, claims, or care management platforms. Used by data engineers to join records across systems and maintain data lineage in emergency encounter workflows.

emergency resolution dateemerg_resol_dt

The date on which an emergency department visit or urgent medical condition was considered resolved. Used in ED clinical records to track episode duration, measure throughput metrics, and support quality reporting on emergency care outcomes and disposition timing.

emergency respirationemerg_resp

The respiratory rate, measured in breaths per minute, recorded during an emergency department encounter. Captured as part of the patient's vital signs triage assessment and monitored throughout the ED visit to detect respiratory distress or deterioration in clinical status.

emergency resultemerg_rslt

Recorded outcome or measurement produced by an emergency or urgent care service, such as diagnostic test findings, triage disposition, or treatment response within EHR and clinical data systems. Used by data engineers to populate clinical outcome tables, support quality measure calculations, and link emergency encounters to downstream result records.

emergency review systemsemerg_ros

Documents the body systems reviewed during an emergency department or urgent care visit, such as cardiovascular, respiratory, or neurological. Used in clinical documentation to support medical decision-making complexity levels and CPT E&M code selection for ED encounters.

emergency revisionemerg_rev

The version or iteration number indicating how many times an emergency department encounter record has been updated or amended. Tracks documentation changes in ED clinical records, supporting audit trails and ensuring data integrity across health information systems.

emergency riskemerg_rsk

The clinical risk stratification level assigned to a patient during an emergency department encounter, reflecting likelihood of adverse outcomes or deterioration. Used in ED triage protocols such as ESI scoring to prioritize care and allocate resources to high-acuity patients appropriately.

emergency routeemerg_rte

The administration pathway for medications or treatments delivered during an emergency department encounter, such as intravenous, intramuscular, or oral routes. Recorded in ED medication administration records to ensure safe delivery and support clinical documentation requirements.

emergency scoreemerg_scr

Calculated numeric rating assigned to an emergency or urgent care encounter, such as an ESI triage score, APACHE severity index, or risk stratification value within EHR and clinical analytics systems. Used by data engineers to classify encounter acuity, validate scoring logic, and support population health and quality reporting pipelines.

emergency sequenceemerg_seq

Ordinal position number assigned to an emergency or urgent care service record within an encounter, claim, or workflow queue in EHR or claims systems. Used by data engineers to order service lines, manage ETL record processing order, maintain relational integrity, and reconstruct the chronological sequence of emergency care events.

emergency service dateemerg_svc_dt

Date on which an emergency or urgent care service was delivered to a patient, captured in EHR encounter records and claims as the from-date of service. Critical for claims adjudication, timely filing validation, episode grouping, and aligning emergency encounters to member eligibility periods in enrollment and claims data systems.

emergency severityemerg_sev

Coded field (emerg_sev) in ED encounter records capturing triage acuity level, typically mapped to ESI levels 1-5 per the Emergency Severity Index. Used in EHR, claims, and hospital billing systems to drive resource allocation decisions, reimbursement rates, and quality reporting metrics.

emergency sexemerg_sex

The patient's biological sex recorded at the time of an emergency department encounter. Used in ED clinical documentation for sex-specific clinical protocols, dosing calculations, diagnostic interpretation, and demographic reporting required for public health and quality measurement programs.

emergency sourceemerg_src

Field (emerg_src) in ED encounter and claims records identifying how a patient arrived or was referred to emergency services, such as walk-in, ambulance, transfer, or referral. Populated in EHR admission records and UB-04 claim fields to support utilization management and population health analytics.

PreviousPage 227 of 806Next