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 resultalrg_rslt

Outcome measurement or finding derived from allergy testing, challenge procedures, or adverse reaction evaluations documented in EHR clinical records. Stores structured test results from allergy panels, skin tests, or drug challenges in systems such as Epic and Cerner, linked to the patient's active allergy problem list.

allergy review systemsalrg_ros

Documents which body systems were assessed during an allergy history review in a clinical encounter. Captures structured review of systems data linked to adverse reaction evaluations, supporting clinical decision-making and allergy documentation in EHR workflows.

allergy revisionalrg_rev

The version or iteration number of an allergy record, reflecting updates made to the original documentation such as changes in reaction severity, allergen clarification, or clinical status. Used to track the audit history and data integrity of allergy records over time.

allergy riskalrg_rsk

The assessed danger level associated with a patient's documented allergy, reflecting the potential severity of re-exposure to the allergen. Used in clinical risk stratification, medication safety screening, and care planning to prioritize patients with life-threatening allergy profiles.

allergy routealrg_rte

The pathway through which a patient was exposed to an allergen, such as oral ingestion, inhalation, topical contact, or intravenous administration. Used in allergy documentation to capture exposure mechanism and inform avoidance strategies and safe medication prescribing in the EHR.

allergy scheduled datealrg_sched_dt

The planned date for an allergy-related clinical appointment or procedure, such as allergy testing, immunotherapy initiation, or follow-up evaluation. Used to coordinate care scheduling and track adherence to allergy management plans within clinical workflow systems.

allergy scheduled timealrg_sched_tm

The planned time of day for an allergy-related clinical appointment or procedure, such as allergen immunotherapy or allergy skin testing. Used alongside the scheduled date to manage appointment logistics and ensure proper sequencing of allergy care workflows in the EHR.

allergy scorealrg_scr

Calculated numeric rating derived from clinical algorithms assessing the severity, certainty, or risk level of a patient's adverse reaction record in EHR and population health platforms. Used in risk stratification models, clinical decision support triggers, and quality measure calculations across integrated healthcare data systems.

allergy sequencealrg_seq

Ordered numeric value establishing the processing or display sequence of multiple adverse reaction records within a patient's EHR allergy list. Used in Epic and Cerner to control the order in which allergies are evaluated during clinical decision support checks and rendered in clinical documentation interfaces.

allergy service datealrg_svc_dt

Date on which allergy-related care, testing, or adverse reaction documentation was delivered or recorded within EHR and claims data systems. Critical for longitudinal allergy history analysis, claims adjudication in payer platforms, and reconciling adverse reaction timelines across Epic, Cerner, and pharmacy benefit management systems.

allergy severityalrg_sev

Structured classification indicating the clinical seriousness of an adverse reaction, typically coded as mild, moderate, severe, or life-threatening within EHR allergy modules. Drives clinical decision support alert prioritization in Epic and Cerner, and is used in PBM safety edit logic to flag high-risk medication dispensing events.

allergy sexalrg_sex

The patient's biological sex recorded in association with their allergy history. Used in clinical research, pharmacogenomics, and population health reporting to analyze sex-based differences in allergy prevalence, immune response patterns, and treatment efficacy across patient populations.

allergy sourcealrg_src

Origin reference identifying the system, provider, or data feed from which an adverse reaction record was captured or imported into the EHR allergy module. Used in data quality workflows to differentiate patient-reported, clinician-documented, or interface-sourced allergy entries across Epic, Cerner, and HIE data integration pipelines.

allergy start datealrg_start_dt

Beginning date value marking the onset or first documentation of a patient's adverse reaction within EHR allergy tracking systems. Used in Epic and Cerner to establish allergy history timelines, support longitudinal clinical analysis, and drive date-range filtering in data warehouse queries and population health reporting.

allergy start timealrg_start_tm

Records the precise time of day an allergic reaction began or when an allergy was first documented during a clinical encounter. Used alongside allergy start date to establish a complete temporal record of adverse reaction onset, supporting clinical tracking and pharmacovigilance reporting.

allergy statealrg_st

Captures the U.S. state or Canadian province associated with where an allergy was diagnosed, reported, or the patient was located at time of adverse reaction documentation. Supports geographic analysis of allergy prevalence and facilitates cross-jurisdictional care coordination.

allergy statusalrg_sts

Coded value representing the current clinical state of an adverse reaction record, such as active, inactive, entered-in-error, or resolved, within EHR allergy modules. Used in Epic and Cerner to control clinical decision support alert firing, filter allergy lists at point of care, and reconcile records during medication management workflows.

allergy street addressalrg_st_addr

Records the street-level address associated with an allergy record, typically reflecting the patient's location at the time of adverse reaction reporting or the facility where the allergy was documented. Used for patient contact and care coordination purposes in clinical systems.

allergy strengthalrg_str

Specifies the concentration or dose strength of a drug or substance associated with an adverse reaction record. Critical for pharmacovigilance and clinical decision support, identifying the specific formulation strength that triggered or was present during an allergic reaction event.

allergy subtotalalrg_subtot

Represents an intermediate aggregated count or sum of allergy records within a defined subset or grouping, such as by allergen category or reaction type. Used in clinical reporting and population health analytics to summarize adverse reaction burden across patient cohorts.

PreviousPage 48 of 806Next