ALT_HISTORY_2
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 ALT_CSN_ID NUMERIC No
A unique serial number for this contact. This number is unique across all alerts in the system.
3 FILTEROUT_REASON_C_NAME VARCHAR No
Save the reason that the medication warning is filtered.
May contain organization-specific values: No
Category Entries:
Previously overridden - releasing orders
User Marked To Be Filtered
4 TPN_VOL_INFUSED NUMERIC No
It is possible to calculate warnings for total parenteral nutrition (TPN) based on the total volume present in the bag or the volume based upon how much the patient will actually receive. If the volume to be infused to the patient is being calculated, then this item will store the volume to be infused at the time that a TPN alert fired. If the warning is based on the volume in the TPN bag, then this item will not be set.
5 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.
6 CRIT_DOSE_POPUP_YN VARCHAR No
Indicates whether or not a dose warning was saved from the critical dose warning popup.
May contain organization-specific values: No
Category Entries:
No
Yes
7 HARD_STOP_YN VARCHAR No
Indicates whether or not a warning is a hard stop.
The category values for this column were already listed for column: CRIT_DOSE_POPUP_YN
8 DRUGSTUDY_SEVERITY_C_NAME VARCHAR No
Stores the severity of a drug-study warning that is shown in the medication warnings popup.
May contain organization-specific values: Yes
Category Entries:
Investigational med interaction
Potential study disqualification
Risk to investigational medication efficacy
9 NBA_ACTION_UTC_DTTM DATETIME (UTC) No
The instant of an next best action event.
10 NBA_USER_ID VARCHAR No
The user correlated with this next best action event.
11 NBA_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 NBA_DEPARTMENT_ID NUMERIC No
The department correlated with this next best action event.
13 NBA_RESULT_C_NAME VARCHAR No
The result of this next best action event.
May contain organization-specific values: No
Category Entries:
Accepted
In Progress
Deferred
Declined
Viewed
14 NBA_DFR_REASON_C_NAME VARCHAR No
The defer reason correlated with this next best action event.
May contain organization-specific values: Yes
15 NBA_DFR_DAYS_NUM INTEGER No
The defer days correlated with this next best action event.
16 NBA_DEC_REASON_C_NAME VARCHAR No
The decline reason correlated with this next best action event.
May contain organization-specific values: Yes
17 NBA_COMM_ID VARCHAR No
The contact correlated with this next best action event.
18 NBA_BUSINESS_SEG_ID NUMERIC No
The next best action was performed in this business segment.
19 NBA_ACTION_DTTM DATETIME (Local) No
The instant of a next best action event in local time.
20 MYC_TICKLER_AUDIT_CSN_ID NUMERIC No
The CSN of the RCH record containing the auditing data of the tickler sent for this alert.
21 BPA_ADDL_FACTORS_TEXT VARCHAR No
Snapshot of data relevant to the evaluation of the advisory, in the format of plain text.
22 BPA_ADDL_FACTORS_UTC_DTTM DATETIME (UTC) No
The instant that the additional contributing factors text (I ALT 2200) was created.
23 ALRGY_FROM_OUTSIDE_SRC_YN VARCHAR No
This column only applies to ALTs that represent drug-allergy warnings. For all other types of ALTs, this column will be blank. This column indicates whether or not an allergy comes from reconciled data. If the allergy does come from outside data, it will contain the value Yes. If the allergy does not come from outside data, it will contain the value No. Additionally, this column will be blank for any warnings that fired before the system was keeping track of this.
The category values for this column were already listed for column: CRIT_DOSE_POPUP_YN