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 cityalrg_city

Stores the city component of the address associated with an adverse reaction record, typically reflecting the patient's residence or the facility where the allergy encounter occurred. Used in geographic analysis of allergy prevalence, care access patterns, and population health reporting.

allergy classalrg_cls

A classification tier assigned to an adverse reaction history record in EHR and PBM systems, typically denoting the pharmacological or allergen category such as antibiotic class or latex. Used to drive drug allergy cross-sensitivity alerts and formulary exception processing in clinical decision support engines.

allergy codealrg_cd

A standardized classification value assigned to an adverse reaction history record, referencing coding systems such as SNOMED CT, RxNorm, or NDF-RT in EHR platforms. Enables interoperability, clinical decision support triggering, and allergy data exchange across health information systems and care settings.

allergy coinsurance amountalrg_coins_amt

Captures the dollar amount owed by the patient as their coinsurance share of costs for an allergy or adverse reaction encounter, calculated as a percentage of allowed charges after the deductible is met. Used in patient billing and healthcare cost-sharing analysis.

allergy commentalrg_cmt

A free-text notation field within an adverse reaction history record in EHR systems, allowing clinicians to document additional context about an allergy or reaction not captured by structured codes. Used in clinical data pipelines for NLP processing, data quality review, and supplemental allergy documentation.

allergy completed datealrg_cmpl_dt

Records the calendar date on which an allergy-related service, procedure, or clinical workup associated with an adverse reaction episode was fully completed. Used to measure care delivery timelines, close open allergy orders, and support clinical documentation compliance reporting.

allergy confidential indicatoralrg_conf_ind

A binary flag that designates an adverse reaction record as sensitive or confidential, restricting its visibility within the EHR to authorized users only. Commonly applied to allergy records linked to stigmatized conditions, ensuring compliance with patient privacy rights and data access policies.

allergy contactalrg_cntct

The designated communication point associated with a patient's adverse reaction history record in EHR or care management systems, typically referencing a provider, caregiver, or specialist to notify. Used in care coordination workflows to route allergy-related alerts and updates to responsible clinical contacts.

allergy copay amountalrg_cpay_amt

Represents the fixed out-of-pocket dollar amount a patient is required to pay at the time of service for an allergy or adverse reaction encounter, as defined by their health plan benefit structure. Used in patient financial responsibility tracking and claims adjudication reporting.

allergy costalrg_cst

Reflects the total expense associated with diagnosing, treating, or managing an adverse reaction episode, encompassing clinical services, medications, and ancillary costs. Used in healthcare cost accounting, allergy program financial analysis, and population health cost-of-care reporting.

allergy countalrg_cnt

The total number of documented adverse reaction or allergy records associated with a patient, captured in EHR allergy modules and clinical data warehouses. Used in medication safety analytics, clinical decision support systems, and population health platforms to assess patient risk profiles and formulary management.

allergy countryalrg_ctry

Stores the country component of the address linked to an adverse reaction record, typically representing the patient's country of residence or the nation where the allergy encounter occurred. Supports international patient management, epidemiological reporting, and cross-border care coordination workflows.

allergy created byalrg_crtd_by

Identifies the system user, clinician, or staff member who initially entered the adverse reaction record into the clinical system. Provides an essential audit trail for allergy documentation accountability, supporting data integrity reviews and clinical governance compliance requirements.

allergy created datealrg_crtd_dt

The system-generated timestamp indicating when an adverse reaction or allergy record was first entered into the source EHR or clinical data system. Used in ETL pipelines, data reconciliation workflows, and audit log tracking to establish record provenance and support incremental data loading processes.

allergy created timealrg_crtd_tm

Records the precise timestamp at which an adverse reaction record was first entered into the clinical system. Used to establish documentation timeliness, support audit trail requirements, and measure the interval between allergy onset or patient presentation and formal clinical documentation.

allergy creatininealrg_cr

Records the serum creatinine lab value obtained during an adverse reaction encounter, used to assess renal function when evaluating allergic reactions to contrast agents, medications, or substances that may cause nephrotoxic effects. Informs dosing adjustments and treatment safety decisions.

allergy datealrg_dt

The calendar date on which a patient's adverse reaction or allergy was first identified, documented, or onset, as recorded in EHR allergy modules and clinical data repositories. Used in medication safety workflows, clinical decision support engines, and longitudinal patient history analysis across pharmacy and care management systems.

allergy datetimealrg_dttm

The combined date and timestamp recording when an adverse reaction or allergy event was documented in a patient's clinical record. Captured in EHR allergy modules and HL7 FHIR AllergyIntolerance resources, this field supports chronological tracking of allergy history and clinical decision support triggers.

allergy dea numberalrg_dea_nbr

Stores the Drug Enforcement Administration registration number associated with a controlled substance linked to an adverse reaction record. Used to identify and track the specific regulated drug implicated in the allergy or adverse reaction, supporting pharmacovigilance and regulatory compliance documentation.

allergy death datealrg_death_dt

The recorded date of a patient's death as documented within the adverse reaction or allergy history module of an EHR system. Used in clinical data reconciliation, mortality reporting, and to flag inactive allergy records in systems such as Epic, Cerner, and interoperability platforms processing HL7 ADT feeds.

PreviousPage 43 of 806Next