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 noteemerg_nt

Free-text or structured annotation associated with an emergency or urgent care service record in EHR, care management, or claims platforms. Contains clinician observations, triage findings, or processing remarks. Data engineers use this field for NLP pipelines, audit trails, and supplemental documentation in emergency encounter datasets.

emergency numberemerg_nbr

Numeric reference value assigned to an emergency or urgent care service record, such as an encounter sequence identifier or service line count within EHR, claims, or dispatch systems. Used by data engineers to uniquely reference emergency events, join records across tables, and validate service line completeness in encounter data.

emergency onset dateemerg_onset_dt

The date on which a patient's symptoms or condition first began prior to or during an emergency department visit. Used by clinicians to assess severity, determine appropriate triage level, and support accurate ICD diagnosis coding when documenting the clinical timeline of an acute emergency episode.

emergency oxygen saturationemerg_o2sat

The measured peripheral oxygen saturation level, expressed as a percentage, recorded as a vital sign during an emergency department encounter. Used to assess respiratory status, guide clinical decision-making, and monitor patient response to treatment interventions such as supplemental oxygen therapy in emergency care settings.

emergency paid amountemerg_pd_amt

The actual dollar amount remitted by a payer or patient toward an emergency department claim or service. Used in claims adjudication and revenue cycle management to reconcile billed charges against payments received for emergency care encounters and support financial reporting for acute care services.

emergency paid dateemerg_pd_dt

The date on which payment was received or posted for an emergency department claim or service. Used in revenue cycle management to track claim reimbursement timelines, measure payer performance, and reconcile accounts receivable balances associated with emergency care billing transactions.

emergency parentemerg_prnt

Foreign key or hierarchical reference linking an emergency or urgent care service record to its superior entity, such as a parent encounter, facility, or organizational unit within EHR or claims systems. Used by data engineers to traverse hierarchical data models, aggregate child records, and maintain referential integrity in emergency data pipelines.

emergency percentageemerg_pct

Calculated ratio representing a proportional value associated with an emergency or urgent care service, such as cost-share percentage, utilization rate, or acuity distribution within claims, PBM, or analytics platforms. Used by data engineers to populate rate tables, validate financial calculations, and support emergency utilization trend reporting.

emergency periodemerg_prd

Defined time span associated with an emergency or urgent care service, such as a coverage period, public health emergency declaration window, or observation stay duration within EHR, claims, or member enrollment systems. Used by data engineers to filter records, apply date range logic, and align emergency encounters to reporting periods.

emergency phoneemerg_ph

Telephone contact number recorded for an emergency or urgent care service entity, such as an ED department line, on-call provider number, or emergency contact within EHR, provider master, or member enrollment systems. Used by data engineers to populate provider directory records, validate contact data, and support care coordination workflows.

emergency planemerg_pln

The documented clinical treatment strategy or care plan established by the treating provider during an emergency department encounter. Captures intended interventions, follow-up instructions, referrals, and discharge planning details used to guide ongoing care and coordinate handoffs following an acute emergency visit.

emergency policy numberemerg_pol_nbr

The unique identifier assigned to an insurance policy associated with a patient's emergency department visit. Used during eligibility verification and claims adjudication to link emergency care services to the correct health plan coverage and ensure accurate billing to the appropriate payer for acute care reimbursement.

emergency preferred nameemerg_pref_nm

The name by which a patient prefers to be addressed during an emergency department encounter, which may differ from their legal name. Used to support patient-centered communication, improve patient experience, and ensure clinical staff appropriately address patients during high-stress emergency care situations.

emergency priceemerg_prc

The billed or contracted charge amount associated with an emergency department service, procedure, or encounter. Used in healthcare revenue cycle management to establish expected reimbursement, support price transparency requirements, and calculate patient cost-sharing responsibilities for emergency care services rendered.

emergency primary indicatoremerg_prim_ind

A flag identifying whether a diagnosis, insurance coverage, or clinical record is the primary designation within an emergency department encounter. Used to distinguish principal diagnoses from secondary conditions and identify the primary payer responsible for reimbursement of emergency care services during claims processing.

emergency priorityemerg_prty

Ordinal ranking indicating the urgency or processing importance assigned to an emergency or urgent care service record within EHR triage systems, claims adjudication platforms, or care management workflows. Maps to triage acuity scales such as ESI or CTAS. Used by data engineers to sort, route, and prioritize emergency encounter records in data pipelines.

emergency procedure dateemerg_proc_dt

The date on which a clinical procedure or intervention was performed during an emergency department encounter. Used in claims billing and clinical documentation to establish the service date for CPT-coded procedures, support medical necessity determinations, and ensure accurate sequencing of emergency care events in the patient record.

emergency pulseemerg_pulse

The heart rate measurement, expressed in beats per minute, recorded as a vital sign during an emergency department encounter. Used by clinical staff to assess cardiovascular status, determine triage acuity level, and monitor hemodynamic stability in patients presenting with acute medical conditions requiring emergency care.

emergency quantityemerg_qty

Numeric count or volume value associated with an emergency or urgent care service, representing units of service, supply quantities, or procedure counts within EHR, claims, or pharmacy systems. Used by data engineers to validate service line totals, detect billing anomalies, and support utilization analysis in emergency encounter datasets.

emergency raceemerg_race

The racial identification of a patient recorded during an emergency department encounter, collected in accordance with federal and state reporting standards. Used to support health equity analysis, meet regulatory reporting requirements, and identify disparities in emergency care access, treatment patterns, and outcomes across patient populations.

PreviousPage 226 of 806Next