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