ALLERGY
Description:
The ALLERGY table contains information about the allergies noted in your patients' clinical system records. You would use this table if you wanted to report on the number of patients who are allergic to sulfa drugs, for example. To determine the allergic reaction, link to the ALLERGY_REACTIONS table.

Primary Key
Column Name Ordinal Position
ALLERGY_ID 1

Column Information
Name Type Discontinued?
1 ALLERGY_ID NUMERIC No
The unique ID used to identify the allergy record.
2 ALLERGEN_ID NUMERIC No
The unique ID assigned to the allergen (Agent) record.
3 ALLERGEN_ID_ALLERGEN_NAME VARCHAR No
The name of the allergen record.
4 REACTION VARCHAR No
This column contains the free text reaction comments. The actual reaction category value responses are stored in the ALLERGY_REACTIONS table which is linked via the ALLERGY_ID columns in both tables.
5 DATE_NOTED DATETIME No
The date the patient made it known that they had experienced an allergic reaction in calendar format.
6 ENTRY_USER_ID VARCHAR No
The unique ID of the clinical system user who entered this allergy into the patient’s record. This ID may be encrypted. NOTE: If an allergy record is edited/updated, this will show the most recent change user ID.
7 ENTRY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 SEVERITY_C_NAME VARCHAR No
The allergy type category value, describing the nature or character of the allergy (i.e. systemic, topical, etc.). NOTE: This field refers to the field called "TYPE" in the Allergy module in clinical system.
May contain organization-specific values: Yes
9 ALLERGY_SEVERITY_C_NAME VARCHAR No
This item stores the severity of an allergy.
May contain organization-specific values: No
Category Entries:
High
Medium
Low
10 ALRGY_STATUS_C_NAME VARCHAR No
The status category number for this allergy record. The status can be active or deleted.
May contain organization-specific values: No
Category Entries:
Active
Deleted
11 ALRGY_DLET_RSN_C_NAME VARCHAR No
Stores the reason for deleting an allergy.
May contain organization-specific values: Yes
Category Entries:
Wrong allergy selected
Wrong patient selected
12 ALRGY_DLT_CMT VARCHAR No
This item contains the comment about why an allergy was deleted from a patient's chart.
13 CONTRA_EXP_DT DATETIME No
The date that the contraindication will expire.
14 ALRGY_ENTERED_DTTM DATETIME (Local) No
The date and time the allergy was entered into the patient's record using a calendar format. NOTE: If an allergy record is edited/updated this will show the most recent change.
15 ALLERGY_CERTAINTY_C_NAME VARCHAR No
The certainty that this allergen is a risk to the patient.
May contain organization-specific values: Yes
16 ALLERGY_SOURCE_C_NAME VARCHAR No
The source of information for an allergy.
May contain organization-specific values: Yes
17 ALLERGY_PAT_CSN NUMERIC No
The patient contact corresponding to the patient encounter in which this allergy was edited.
18 ALLERGY_NOTED_DATE_ACCURACY_C_NAME VARCHAR No
The noted date accuracy of an allergy determines the accuracy of the noted date specified in DATE_NOTED. A value of 1-Year indicates that the specific day in the DATE_NOTED column is accurate to the year and not to the specific day. Similarly a value of 2-Month indicates that it is accurate to the month. A value of 3-Exact Date or an empty value indicates that the corresponding value in DATE_NOTED column is accurate to that day.
May contain organization-specific values: No
Category Entries:
Year
Month
Exact Date
19 ALRGY_TRANSMTL_UTC_DTTM DATETIME (UTC) No
This item is used to store the last successful instant of transmittal to an external allergies list. It is currently only used for the SFM PLL drug reactions list in Norway.