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
Interaction (clinical rule)
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
9 | SVV_STATUS_C_NAME | VARCHAR | No |
Stores the status of the user's latest interaction with this Sign Visit Validation message.
May contain organization-specific values: No
Category Entries:
Viewed
Resolved
Left Unresolved
10 | MAR_CUMULATIVE_DOSE_TEXT | VARCHAR | No |
Stores the MAR short-term cumulative dose warning text the user saw.