ALT_HISTORY_3
Description:
This table contains general history information for each type of medication warning or advisory. Since each warning could be triggered in different activities at different times, it contains general warning information for each time the warning was triggered. This table is an extension of ALT_HISTORY table.

Primary Key
Column Name Ordinal Position
ALT_CSN_ID 1

Column Information
Name Type Discontinued?
1 ALT_ID NUMERIC No
The unique identifier for the med alert record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 ALT_CSN_ID NUMERIC No
A unique serial number for this contact. This number is unique across all alerts in the system.
5 VIGILANCE_SEVERITY_C_NAME VARCHAR No
This column contains the severity level provided by Vigilance Santé.
May contain organization-specific values: No
Category Entries:
Avoid completely
Avoid if possible
Use with caution
6 VIGILANCE_WARNING_TYPE_C_NAME VARCHAR No
This column contains the specific type of warning provided by Vigilance Santé.
May contain organization-specific values: No
Category Entries:
Age-related warning (high age)
Age-related warning (low age)
Ingredient duplication
Therapeutic duplication
Disulfiram effect
Interaction
Blood donation
Renal failure precautions
Breastfeeding
Diagnosis warning
Pregnancy
Allergy
Cross-allergy
Latex allergy
Dose
Dose not validated
Dose - used different information
Smoking
Atypical association
Cumulative anticholinergic effects
Cumulative kalemia
Cumulative nephrotoxicity
Cumulative CNS depressant effects
Cumulative serotonin toxicity
7 AVOIDANCE_LEVEL_C_NAME VARCHAR No
The avoidance level assigned to warning, such as contraindicated or should be avoided.
May contain organization-specific values: No
Category Entries:
Contraindicated
Avoid
None
8 INFORMATIONAL_YN VARCHAR No
This stores whether a medication warning is informational.
May contain organization-specific values: No
Category Entries:
No
Yes