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.