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

allergy surgery datealrg_surg_dt

Records the date of a surgical procedure associated with an allergy or adverse reaction event, such as a surgery where an anesthetic or medication allergy was identified. Used to correlate operative events with adverse reaction documentation in the patient's clinical history.

allergy system identifieralrg_sys_id

A unique system-generated key assigned to an allergy record within a clinical or health information system. Enables consistent identification and cross-referencing of adverse reaction records across EHR platforms, data warehouses, and health information exchanges for longitudinal patient care.

allergy targetalrg_tgt

The destination reference entity for an adverse reaction history record in EHR and clinical data systems. Identifies the specific substance, medication class, or environmental agent to which the patient reaction is linked, enabling accurate allergy reconciliation across care settings.

allergy taxonomy codealrg_tax_cd

Classifies an allergy or allergen using a standardized coding taxonomy, such as NDF-RT or SNOMED CT allergen classifications. Enables structured categorization of adverse reactions by substance type, supporting clinical decision support rules, formulary management, and allergy interoperability across systems.

allergy temperaturealrg_temp

Records the patient's body temperature measured at the time of an allergic reaction or adverse event, serving as a clinical vital sign to characterize the severity and physiological response of the reaction. Supports clinical documentation and anaphylaxis severity assessment workflows.

allergy termination datealrg_term_dt

Captures the date an allergy record was inactivated, resolved, or removed from a patient's active adverse reaction list. Used to maintain accurate longitudinal allergy histories, reflecting clinical decisions to retire outdated or incorrect allergy entries in EHR and pharmacy systems.

allergy timealrg_tm

The time-of-day value associated with an adverse reaction history event recorded in EHR or clinical data systems. Used to establish precise temporal context for allergy onset or documentation, supporting clinical event sequencing and pharmacovigilance reporting workflows.

allergy timestampalrg_ts

The combined date and time value capturing when an adverse reaction history record was created, modified, or clinically observed in EHR systems. Critical for auditing allergy documentation changes, ensuring data lineage integrity, and supporting HL7 FHIR AllergyIntolerance resource compliance.

allergy titlealrg_ttl

Stores the formal label or heading assigned to an allergy record, such as a standardized allergen name or reaction category descriptor. Used to display and organize adverse reaction entries within clinical interfaces, patient summaries, and medication safety alerts in EHR systems.

allergy totalalrg_tot

The aggregate sum value associated with adverse reaction history records for a patient in clinical or EHR data systems. Used to quantify cumulative allergy entries, supporting deduplication logic, patient safety dashboards, and quality measure calculations across care episodes.

allergy total countalrg_tot_cnt

Represents the complete aggregate count of documented allergy and adverse reaction records for a patient or within a defined reporting population. Used in clinical analytics, patient risk profiling, and quality reporting to quantify the total adverse reaction burden across care settings.

allergy typealrg_typ

The category classification assigned to an adverse reaction history record in EHR and clinical data systems. Distinguishes between allergy, intolerance, and adverse drug reaction categories per HL7 FHIR AllergyIntolerance standards, driving clinical decision support alerts and formulary screening logic.

allergy unitalrg_unt

The measurement unit associated with a quantified adverse reaction history data point in clinical or EHR systems. Specifies units such as mg/dL or IU/mL for lab-confirmed allergy thresholds, enabling standardized interpretation of sensitivity levels across immunology and pharmacy data pipelines.

allergy updated datealrg_upd_dt

Records the most recent date on which an allergy record was modified, reviewed, or confirmed in the clinical system. Critical for audit trails, data integrity monitoring, and ensuring that adverse reaction information reflects current clinical knowledge during medication ordering and care transitions.

allergy urgencyalrg_urg

Classifies the clinical urgency level associated with an allergic reaction, indicating how quickly intervention is required based on reaction severity, such as anaphylaxis versus mild intolerance. Supports triage prioritization, clinical alerting, and care escalation workflows in EHR and emergency systems.

allergy valuealrg_val

The specific measured or recorded data point within an adverse reaction history entry in EHR or clinical data systems. Captures numeric or coded reaction severity, allergen concentration thresholds, or clinical test results, supporting allergy profiling and drug interaction screening in pharmacy and PBM platforms.

allergy versionalrg_ver

Tracks the version number of an allergy record, incrementing each time the record is updated or modified in the clinical system. Supports audit history, change tracking, and data governance by identifying which iteration of an adverse reaction record is current versus historical.

allergy zipalrg_zip

Stores the postal ZIP code associated with an allergy record, reflecting the patient's residential location or the facility where an adverse reaction was documented. Supports geographic analysis of allergy distributions, environmental trigger research, and regional population health reporting.

anesthesiologist active indicatoranes_actv_ind

A binary flag indicating whether an anesthesiologist is currently active and eligible to practice within a healthcare facility or credentialing system. Used in provider directories, scheduling systems, and surgical team management to control assignment of anesthesia specialists to operative cases.

anesthesiologist active statusanes_actv_sts

Captures the detailed current activity state of an anesthesiologist within a credentialing or workforce management system, such as active, suspended, or on leave. Used to manage anesthesia staffing assignments, maintain accurate provider rosters, and ensure compliance with surgical case coverage requirements.

PreviousPage 49 of 806Next