EMR_PATIENT_ALLERGIES · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT; or ENCOUNTER_ID matches EMR_ENCOUNTERS.ENCOUNTER_ID on a row of EMR_ENCOUNTERS that relates to the patient

Single-patient export: the patient's rows.

#	Column	Type	Source type	Null
1	PAT_ALLERGY_ID PK	integer	int	no
2	ACCOUNT	string	varchar(12)	no
3	CONCEPT_ID	string	varchar(20)	yes
4	COMPOSITE_ID	string	varchar(20)	yes
5	CONCEPT_TYPEID	string	varchar(10)	yes
6	ALLERGY_NAME	string	varchar(100)	yes
7	ALLERGY_TYPE	string	varchar(50)	yes
8	NOTES	string	varchar(100)	yes
9	SEVERITY	string	varchar(20)	yes
10	SOURCE	string	varchar(20)	yes
11	IS_ACTIVE	boolean	bit	yes
12	CREATED_DATE	datetime	datetime	yes
13	CREATED_USER_ID	string	varchar(20)	yes
14	IS_DELETED	boolean	bit	yes
15	MODIFIED_DATE	datetime	datetime	yes
16	MODIFIED_USER	string	varchar(20)	yes
17	NDCID	string	varchar(max)	yes
18	REACTION	string	varchar(max)	yes
19	ONSET_DATE	datetime	datetime	yes
20	RCOPIA_ID	string	varchar(20)	yes
21	RXNORM_VERSION	string	varchar(20)	yes
22	DIAG_CODE	string	varchar(8)	yes
23	DRUG_ID	string	varchar(12)	yes
24	ACTOR_ID	string	varchar(100)	yes
25	ENCOUNTER_ID	integer	int	yes
26	FDB_GROUP_ID	string	varchar(20)	yes
27	STATUS	string	varchar(20)	yes
28	ALLERGY_SOURCE	string	varchar(50)	yes
29	REACTION_SNOMED	string	varchar(18)	yes
30	SEVERITY_SNOMED	string	varchar(18)	yes
31	FDB_INGREDIENT_ID	string	varchar(10)	yes
32	INGREDIENT_RXNORM_ID	string	varchar(10)	yes
33	INGREDIENT_RXNORM_TYPE	string	varchar(3)	yes