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 emergency indicatoremerg_emerg_ind

A flag confirming that an encounter has been classified as a true emergency requiring immediate medical intervention, as distinct from urgent or routine care. Used in claims adjudication to apply appropriate benefit levels, override prior authorization requirements, and support prudent layperson standard determinations.

emergency end dateemerg_end_dt

Date marking the conclusion of an emergency episode, authorization period, or related data record in EHR, claims, or care management systems. Used to define episode duration, close open authorizations, and support retrospective utilization analysis for emergency services.

emergency end timeemerg_end_tm

The precise timestamp marking the conclusion of an emergency department encounter, typically corresponding to patient discharge, transfer, or admission. Used in clinical operations and quality measurement to calculate length of stay, assess door-to-disposition times, and support throughput analytics.

emergency entered byemerg_ent_by

The identifier of the staff member or system responsible for manually entering the emergency encounter data into the healthcare information system. Captured for audit trail purposes to support data quality reviews, compliance investigations, and accountability tracking in ED documentation workflows.

emergency ethnicityemerg_ethn

The patient's self-reported or administratively assigned ethnic background recorded at the time of an emergency encounter. Used in population health analytics, health equity reporting, and quality measure stratification to identify disparities in emergency care access, treatment, and outcomes.

emergency expiration dateemerg_exp_dt

Date after which an emergency-related authorization, coverage provision, or data record is no longer valid within claims adjudication or member enrollment systems. Used to enforce benefit limits, flag stale records, and trigger renewal workflows in managed care and PBM platforms.

emergency external identifieremerg_ext_id

A reference identifier assigned by an external system, partner organization, or upstream data source to uniquely identify an emergency encounter across interoperable platforms. Used in data integration workflows to support record matching, claims crosswalks, and HIE data reconciliation.

emergency faxemerg_fax

The facsimile number designated for transmitting urgent medical documentation during emergency situations. Used in clinical workflows to route time-sensitive patient records, referrals, and treatment authorizations to emergency departments or on-call clinical staff.

emergency feeemerg_fee

The service charge billed for emergency medical care, typically reflected on a claim as an emergency department facility or professional fee. Used in revenue cycle management to capture costs associated with unscheduled, urgent patient encounters and applied to adjudication and reimbursement workflows.

emergency first nameemerg_first_nm

The given name of the emergency contact person designated by a patient or plan member. Used in member enrollment and clinical records to identify and reach a named individual in the event of a medical emergency, accident, or critical care situation requiring family or caregiver notification.

emergency flagemerg_flg

Binary indicator field set to true or 1 when a claim, encounter, or service record is classified as emergency in nature, often derived from place of service code 23, revenue code 045x, or EHR encounter type. Used in claims routing, cost-sharing logic, and utilization dashboards.

emergency frequencyemerg_freq

The dosing interval or recurrence schedule for medications or treatments administered during emergency care episodes. Used in clinical documentation to record how often emergency interventions, such as rescue medications or acute treatments, are to be administered during an urgent care encounter.

emergency full nameemerg_full_nm

The complete name, including first and last name, of the emergency contact person designated by a patient or plan member. Used in member enrollment and clinical records to ensure accurate identification of the individual to be contacted during a medical emergency or critical health event.

emergency genderemerg_gndr

The sex or gender classification of the emergency contact person designated by a patient or plan member. Used in member enrollment and clinical records to support accurate identification and communication with the designated emergency contact during urgent medical situations.

emergency glucoseemerg_gluc

The blood glucose level measured during an emergency clinical encounter. Captured as a critical vital sign in emergency department documentation to assess conditions such as diabetic ketoacidosis, hypoglycemia, or hyperglycemia requiring immediate intervention and treatment decisions.

emergency group numberemerg_grp_nbr

The insurance group identifier associated with a patient's health plan coverage at the time of an emergency encounter. Used in claims processing and eligibility verification to link the patient's emergency visit to the correct group health plan for adjudication and reimbursement.

emergency hemoglobinemerg_hgb

The hemoglobin concentration measured from a blood sample collected during an emergency clinical encounter. Captured as a critical lab value in emergency department documentation to assess conditions such as acute anemia, hemorrhage, or oxygen-carrying capacity requiring immediate clinical intervention.

emergency history present illnessemerg_hpi

The narrative description of a patient's current medical complaint and symptom progression at the time of an emergency encounter. Documented by the treating clinician in the emergency department to capture onset, duration, severity, and context of the presenting condition for clinical decision-making and coding.

emergency identifieremerg_id

Unique alphanumeric key assigned to an emergency encounter or related record in an EHR, claims, or care management system, enabling record linkage across platforms. Used by data engineers for deduplication, encounter matching, and building longitudinal ED utilization datasets.

emergency indexemerg_idx

Positional or sequential number assigned to an emergency encounter within a series of records for a patient or claim batch in EHR and claims processing systems. Used for array-based data structures, record ordering, and multi-visit episode construction in analytical pipelines.

PreviousPage 224 of 806Next