EOW_MED_ALG_INT
Description:
This table reflects the medical data in the In Basket Messages (EOW) master file. Stores a variety of details regarding medications and allergies.

Primary Key
Column Name Ordinal Position
MSG_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 MSG_ID VARCHAR No
The unique identifier for the task record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 MEDALT_ERX_ID NUMERIC No
Stores the Interaction details. The drugs (ERX) ID.
4 MEDALT_TYP_C_NAME VARCHAR No
Stores the Interaction details. The type of Interaction.
May contain organization-specific values: Yes
Category Entries:
Drug-Drug
Drug-Allergy (Active and Inactive Ingredients)
Drug-Food
Drug-Alcohol
Duplicate Therapy
Dose
IV Compatibility
Drug-Disease
Drug-Lab
Duplicate Medication Order
Pregnancy
Lactation
Drug-Allergy (Inactive Ingredient)
Fluid/Nutrition
Age/Sex
Geriatric
Pediatric
Contraindication
Renal Impairment
Pregnancy Related
Pharmacogenetics
Error while checking interactions
OurPractice Advisory
Drug-Study
Indications
Duplicate S&H Procedure Context
Clinical Rule
Monitoring
5 MEDALT_DES VARCHAR No
Stores the Interaction details. Interaction description.
6 MEDALT_ELG_ID NUMERIC No
Stores the Interaction details. The allergen (ELG) ID.
7 MEDALT_ELG_ID_ALLERGEN_NAME VARCHAR No
The name of the allergen record.
8 MEDALT_LPL_ID NUMERIC No
Stores the Interaction details. The allergy (LPL) ID.
9 MEDALT_LVL_C_NAME VARCHAR No
Stores the Interaction details. The Interaction level.
May contain organization-specific values: Yes
10 MEDALT_OVRDRSN_C_NAME VARCHAR No
Stores the Interaction details. The override reason at an individual interaction level.
May contain organization-specific values: Yes
11 MEDALT_OVRDCMT VARCHAR No
Stores the Interaction details. The override comment at an Individual interaction level.
12 MEDALT_ORD_ID NUMERIC No
Stores the Interaction details. The interaction medications order ID.
13 INACT_INGRED_C_NAME VARCHAR No
It indicates the inactive ingredient drug-allergy status.
May contain organization-specific values: No
Category Entries:
Inactive Ingredient Drug-Allergy
not yet Reviewed Inactive Ingredient Drug-Allergy