|
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 |
|
|