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_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
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_LOC_NAME VARCHAR No
The name of the revenue location.
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
24 LOG_HM_ACTION_C_NAME VARCHAR No
This is the Health Maintenance action to be logged.
May contain organization-specific values: No
Category Entries:
HM Completion
HM Postpone
HM Discontinue
HM Remove Postpone
HM Edit Frequency
HM Topic Ordered
Other: Completion
Other: No Longer Recommended
Other: No Action Taken
Other: Action Taken, Still Outstanding
Other: Relevant Visit Scheduled
Feedback Provided
25 LOG_HMT_PPN_RSN_C_NAME VARCHAR No
This is the postpone reason for the logged Health Maintenance action.
May contain organization-specific values: Yes
26 LOG_HM_TYPE_C_NAME VARCHAR No
This is the manual completion reason for the logged Health Maintenance action.
May contain organization-specific values: Yes
Category Entries:
Done
27 LOG_HM_EDIT_RSN_C_NAME VARCHAR No
This is the edited topic reason for the logged stored Health Maintenance action.
May contain organization-specific values: Yes
28 LOG_HM_COMP_TYPE_C_NAME VARCHAR No
This is the completion type for the logged Health Maintenance action.
May contain organization-specific values: No
Category Entries:
Procedure or Medication Order
Result Component
Immunization
Problem List
Hospital Diagnosis
Encounter Diagnosis
LOS Code
E/M Code
Surgical History
Patient SDE
Note SDE
Encounter SDE
Manual Completion
External Procedure
External Immunization
External LOS
Registry Metric