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 indicatoremerg_ind

Boolean or coded field signaling whether a healthcare encounter qualifies as an emergency under plan benefit rules, sourced from EHR admission type codes or claims condition codes. Drives cost-sharing calculations, network waiver logic, and CMS emergency services reporting in managed care systems.

emergency instructionemerg_instr

Structured or free-text guidance associated with an emergency encounter or patient record, such as allergy alerts, DNR orders, or triage protocols stored in EHR clinical decision support systems. Referenced during patient intake and used in care plan documentation and provider notification workflows.

emergency keyemerg_key

The unique surrogate or lookup key assigned to an emergency encounter or emergency contact record within a healthcare data system. Used as a primary reference value to join, retrieve, and track emergency-related data across clinical, claims, and member enrollment system tables.

emergency labelemerg_lbl

The human-readable display text associated with an emergency encounter type, triage category, or emergency contact record. Used in clinical and administrative systems to present standardized descriptive labels for emergency classifications, alert levels, or contact designations in user interfaces and reports.

emergency languageemerg_lang

The preferred spoken or written language of the emergency contact person designated by a patient or member. Used in member enrollment and clinical records to ensure appropriate language services and interpreter support are arranged when contacting the designated individual during a medical emergency.

emergency last nameemerg_last_nm

The family surname of the emergency contact person designated by a patient or plan member. Used in member enrollment and clinical records to accurately identify the individual to be notified during a medical emergency, critical care event, or situation requiring next-of-kin or caregiver communication.

emergency legal nameemerg_legal_nm

The officially registered legal name of the emergency contact person designated by a patient or plan member. Used in member enrollment and clinical records to ensure formal identification accuracy when documenting or contacting a designated individual during a medical emergency or legal healthcare situation.

emergency levelemerg_lvl

Coded classification representing the clinical severity or triage priority of an emergency encounter, often mapped to ESI triage levels 1–5 or CMS evaluation and management codes 99281–99285 in EHR and claims systems. Used for acuity-based staffing, reimbursement tiering, and quality benchmarking.

emergency license numberemerg_lic_nbr

The professional state or national license identifier for a clinician or facility providing emergency medical services. Used in credentialing, claims processing, and provider enrollment to verify that emergency care was delivered by a licensed practitioner or accredited emergency care facility.

emergency marital statusemerg_mar_sts

The marital or relationship status of the emergency contact person designated by a patient or plan member. Used in member enrollment records to provide contextual information about the contact's relationship to the patient, supporting accurate communication and next-of-kin determinations during emergency situations.

emergency master identifieremerg_mstr_id

The enterprise master patient or contact identifier assigned to an emergency record across integrated healthcare systems. Used in master patient index workflows to uniquely and consistently identify an emergency contact or emergency encounter across multiple clinical, administrative, and claims platforms.

emergency maximumemerg_max

The upper allowable limit for a clinical measurement, dosage, or cost threshold associated with an emergency encounter. Used in clinical decision support and claims adjudication to enforce safety thresholds, benefit limits, or treatment caps applicable to emergency department services and interventions.

emergency medical record numberemerg_mrn

The unique medical record number assigned to a patient at the time of an emergency encounter within a facility's EHR system. Used to link emergency department visit documentation, lab results, imaging, and clinical notes to the correct patient record for continuity of care and claims billing.

emergency middle nameemerg_mid_nm

The middle name or initial of a patient or emergency contact person recorded during an emergency department encounter. Used to accurately identify individuals when first and last names alone may be insufficient to distinguish between patients with similar names in clinical systems.

emergency minimumemerg_min

The lower threshold value established for an emergency care clinical or operational metric, such as a vital sign range, staffing level, or resource quantity. Used in emergency department protocols to trigger alerts or escalation workflows when observed values fall below acceptable safety thresholds.

emergency mobileemerg_mob

The mobile phone number associated with a patient or emergency contact to be reached during an emergency department visit or urgent care episode. Used to facilitate rapid communication between clinical staff, patients, and designated contacts when immediate notification is required during a medical emergency.

emergency modified byemerg_mod_by

The unique identifier of the system user who last updated an emergency department encounter record. Used in audit trail tracking to maintain data integrity, support compliance requirements, and attribute record changes to specific clinical or administrative staff during emergency care documentation.

emergency modified dateemerg_mod_dt

Timestamp recording the most recent update to an emergency or urgent care service record within EHR, claims, or care management systems. Used by data engineers to detect record changes, manage ETL incremental loads, and ensure downstream data warehouse tables reflect the latest emergency encounter modifications.

emergency modified timeemerg_mod_tm

The timestamp recording when an emergency department encounter record was most recently updated in the clinical system. Used in audit logging to track the sequence of documentation changes, support compliance reviews, and ensure accurate version history for emergency care records.

emergency nameemerg_nm

Standardized display label assigned to an emergency or urgent care service type within EHR, claims, or provider directory systems. Used by data engineers to map service descriptions across source systems, populate reference tables, and support reporting dashboards that categorize emergency encounter types by name.

PreviousPage 225 of 806Next