EMR_PATIENT_IMMUNIZATION · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

#	Column	Type	Source type	Null
1	IMMUNIZATION_ID PK	integer	int	no
2	ACCOUNT	string	varchar(12)	no
3	VACCINE_ID	integer	int	yes
4	VACCINE_DATE	datetime	datetime	yes
5	DUE_DATE	datetime	datetime	yes
6	EXPIRY_DATE	datetime	datetime	yes
7	ADMIN_SITE	string	varchar(5)	yes
8	LOT	string	varchar(20)	yes
9	COMMENTS	string	varchar(100)	yes
10	USER_ID	string	varchar(20)	no
11	CREATED_DATE	datetime	datetime	no
12	IS_DELETED	boolean	bit	no
13	REFUSED	boolean	bit	yes
14	REFUSAL_REASON	string	varchar(100)	yes
15	ADVERSE_REACTION	string	varchar(100)	yes
16	ADMIN_AMOUNT	decimal	decimal(10,2)	yes
17	ADMIN_UNITS	string	varchar(20)	yes
18	CVX_CODE	integer	int	yes
19	ADMIN_METHOD	string	varchar(5)	yes
20	PROC_CODE	string	varchar(20)	yes
21	CODING_METHOD	string	varchar(5)	yes
22	MVX_CODE	string	varchar(10)	yes
23	ORDERED_BY_PROV	string	varchar(20)	yes
24	ADMINISTERING_PROV	string	varchar(20)	yes
25	FINANCIAL_CLASS	string	varchar(10)	yes
26	CONSENT_EFFECTIVE_DATE	datetime	datetime	yes
27	ADMIN_STATUS	string	varchar(2)	yes
28	INFORMATION_SOURCE	string	varchar(6)	yes
29	REFUSAL_CODE	string	varchar(6)	yes
30	EVIDENCE_IMMUNITY	boolean	bit	yes
31	CONSENT_TO_SHARE	boolean	bit	yes
32	EVIDENCE_IMMUNITY_REASON	string	varchar(max)	yes