ALT_HISTORY

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. To get patient information, link this table to the ALERT table and then link the ALERT table to the PATIENT or PAT_ENC table. To get order related information for each medication warning or advisory, link this table to ALT_ORDINFO. To get specific medication or condition information for each medication warning type, link this table to specific medication warning related tables, such as the ALT_DRUG_ALLERGY table for drug-allergy warnings; the ALT_DRUG_DFALC table for drug-drug, drug-food, and drug-alcohol warnings; the ALT_DRUG_DUPTHERPY and ALT_DRUG_DUPTHYMED tables for duplicate therapy warnings; the ALT_DRUG_IV and ALT_DRUG_IVMED tables for IV warnings; and the ALT_DRUG_PREGNANCY and ALT_DRUG_PREGMED tables for pregnancy warnings.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ALT_CSN_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ALT_ID | NUMERIC | No |
The unique warning ID for each warning. You could link it to ALERT.ALT_ID to get patient and vendor information in table ALERT.
2 | ALT_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of the contact. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple times on one day.
3 | ALT_CSN_ID | NUMERIC | No |
A unique serial number for this contact. This number is unique across all warnings in the system.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | ALT_STATUS_C_NAME | VARCHAR | No |
The status category number for the warning after it was viewed in Hyperspace. This describes any actions the user took on the warning. Link it to ZC_ALT_STATUS.ALT_STATUS_C to get the name, title, and abbreviation information for the warning status.
May contain organization-specific values: No
Category Entries:
Overridden
Removed
Filtered
Canceled
Deferred
Viewed
Held
6 | USER_ID | VARCHAR | No |
The unique ID of the user who triggered the warning. This column is frequently used to link to the CLARITY_EMP table.
7 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | SHOWN_PLACE_C_NAME | VARCHAR | No |
The place where you see the warning. You could link it to ZC_SHOWN_PLACE.SHOWN_PLACE_C to get name, title, and abbreviation for shown place.
May contain organization-specific values: No
Category Entries:
Enter Orders
Verify Orders
Retro-Allergen
Rate Change
Treatment Plan
Resolve Fill Review Prescription Order Flag
Fill Prescription Order
Verify Prescription Order
Prior To Admission
Resume Orders
MAR
Refill Orders
Doc Flowsheets
Handheld MAR
Retro-Diagnosis
Resolve Charging Prescription Order Flag
Pickup Prescription Order
Resolve Clinical Review Prescription Order Flag
Resolve Pending RAR Approval Prescription Order Flag
Transfer Prescription Order
Medication Profile
Mobile Orders
Specimen Collection
Handheld Specimen Collection
Resolve Custom Prescription Order Flag
Resolve Consult Prescription Order Flag
Immunizations
Flu Clinic
Edit Prescription
Resolve Transfer Review Prescription Order Flag
Force Prescription To Dispense
Resolve Insufficient Inventory Prescription Order Flag
Resolve Invalid Request Prescription Order Flag
Resolve APFS Prescription Order Flag
Resolve Invalid Data Prescription Order Flag
Resolve Partial Fill Completion Hold Prescription Order Flag
Resolve Discontinued Prescription Order Flag
Resolve Expired Prescription Order Flag
Reactivate Discontinued Orders
Retro Pregnancy and Lactation
Deferred Medication Warning
Retro Genomic Indicator
Resolve Needs Medication Transition Order Flag
Resolve Waiting for Prior Authorization Prescription Order Flag
Review with Pharmacy/System Interaction Profile
Resolve Medication Warning Review Flag
Reconcile Outside Information
Ambulatory Pharmacy Patient Counseling
Ambulatory Pharmacy Dispensing
Continue Orders
Handheld Brain
Sign Visit
Medications PRMs
Instant Orders
FMK Side by Side
FMK Prescriptions Activity
Rapid Transfusion Blood Card
LDA Avatar
Redispense
Handheld Tech Work List
Handheld Order Inquiry
Lab Specimen Receiving
Lab Case Builder
Lab Case Prep Work List
Lab Grossing
Lab Container Storage
Non-Task Desktop Specimen Collection
One-step Medications
9 | OVERALL_OVR_RSN_C_NAME | VARCHAR | No |
For medication interactions, when you override & accept them, if an overall override reason is given at the bottom of the warning pop-up form, it will be saved here. You could link it to ZC_ALRT_SP_OVR_RSN.ALRT_SP_OVR_RSN_C to get name, title, and abbreviation for the reason.
May contain organization-specific values: Yes
10 | OVERALL_OVR_CMNT | VARCHAR | No |
For medication interactions, when you override & accept the warning pop-up form, if an overall override comment is given at the bottom of the form, it will be saved here. We only extract the first 255 characters.
11 | SPEC_OVR_RSN_C_NAME | VARCHAR | No |
The specific override reason given for an overridden medication interaction. Link to ZC_ALRT_SP_OVR_RSN.ALRT_SP_OVR_RSN_C to get the name, title, and abbreviation for the override reason.
The category values for this column were already listed for column: OVERALL_OVR_RSN_C_NAME
12 | SPEC_OVR_CMNT | VARCHAR | No |
For medication interactions, when you override & accept the warning pop-up form, if a specific override comment is given on the right of the form, it will be saved here. We only extract the first 1000 characters.
13 | IMMUNIZATION_LPL_ID | NUMERIC | No |
The patient’s immunization problem list ID for a specific immunization-allergy interaction.
14 | IMPORTANCE_LVL_C_NAME | VARCHAR | No |
Stores the importance level of a warning, a value that is used to determine which warnings are displayed at the top of the interactions popup. Can be used to compare the importance of different warning types.
May contain organization-specific values: Yes
Category Entries:
Very High
High
Medium
Low
Very Low
15 | PROVIDER_TYPE_C_NAME | VARCHAR | No |
Stores a provider type for the user who triggered the warning.
May contain organization-specific values: Yes
Category Entries:
Resource
Physician
16 | SPECIFIC_DEFR_RSN_C_NAME | VARCHAR | No |
For medication interactions, when you override & accept the warnings pop-up, if the warning is deferred and if a specific deferral reason is given in the defer window of the warning, it will be saved here. You could link it to ZC_SPECIFIC_DEFR_R.SPECIFIC_DEFR_R_C to get the name, title, and abbreviation for the deferral reason.
May contain organization-specific values: Yes
No Entries Defined
17 | DOSING_WEIGHT | NUMERIC | No |
Weight used for dose checking. Always stored in kilograms.
18 | WT_RECORD_DATETIME | DATETIME (Local) | No |
The instant at which the weight was recorded.
19 | WT_SOURCE_C_NAME | VARCHAR | No |
The weight source.
May contain organization-specific values: Yes
Category Entries:
Treatment plan weight
Past measured weight
Most current measured weight (actual)
Ideal body weight
Adjusted body weight
User entered weight
Lean body weight
Dosing weight
Birth Weight
Other
20 | WT_COMMENTS | VARCHAR | No |
Generated comment for weight.
21 | DOSING_HEIGHT | NUMERIC | No |
Height used for dosing warning. Always stored in inches.
22 | HT_RECORD_DATETIME | DATETIME (Local) | No |
The instant at which the height was recorded.
23 | HT_SOURCE_C_NAME | VARCHAR | No |
The height source.
May contain organization-specific values: Yes
Category Entries:
Treatment plan height
Past measured height
Most current measured height (Actual)
User Entry
Other
24 | DOSING_BSA | NUMERIC | No |
The body surface area used for dosing checking. Always stored in m2.
25 | BSA_SOURCE_C_NAME | VARCHAR | No |
The body surface area source.
May contain organization-specific values: Yes
Category Entries:
Treatment plan BSA
Based on weight and height measured in the past
Based on most recent measured weight and height (actual)
User Entry
Based on ideal body weight and current/past measured height
Based on adjusted body weight and current/past measured height
Based on dosing weight and current/past measured height
Based on normalized BSA 1.7m2
Birth weight and current height BSA
Other
26 | BSA_CALC_DETAIL | VARCHAR | No |
The body surface area calculation details with weight, height and recorded instants.
27 | ALERT_ALLERGEN_ID | NUMERIC | No |
The allergen ID of drug-allergy warning.
28 | ALERT_ALLERGEN_ID_ALLERGEN_NAME | VARCHAR | No |
The name of the allergen record.
29 | INACT_INGRED_IND_YN | VARCHAR | No |
It indicates whether the warning is fired because of inactive ingredient.
May contain organization-specific values: No
Category Entries:
No
Yes
30 | ALERT_ROOT_ALLER_ID | NUMERIC | No |
This column stores the allergen ID of the allergen that caused the warning to fire.
31 | ALERT_ROOT_ALLER_ID_ALLERGEN_NAME | VARCHAR | No |
The name of the allergen record.
32 | ALERT_MED_CLASS_ID | NUMERIC | No |
Contains the allergen class of the medication for a cross-sensitive warning.
33 | ALERT_MED_CLASS_ID_ALLERGEN_NAME | VARCHAR | No |
The name of the allergen record.
34 | PATIENT_DEP_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
35 | ALERT_ALLERGY_ID | NUMERIC | No |
The problem list record that contains the allergen for a drug-allergy warning.
36 | CONTACT_NUM | INTEGER | No |
The number of the ALT contacts for the given ALT record.
37 | IS_NONFILTERED_YN | VARCHAR | No |
Indicate whether the warning is non-filtered.
May contain organization-specific values: No
Category Entries:
Yes
No