TOXICOLOGY_POTENTIAL_DATES · 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	ACCOUNT PK	string	varchar(12)	no
2	EPISODE_CARE_ID PK	integer	int	no
3	ORDER_ID PK	integer	int	no
4	DOSE_DATE PK	datetime	smalldatetime	no
5	DOSE_SEQUENCE PK	integer	int	no
6	DOSE_GEN PK	integer	int	no
7	DOSE_FORM	integer	int	no
8	DOSE_AMOUNT	decimal	numeric(5,2)	no
9	TAKE_HOME_DAY	boolean	bit	no
10	TAKE_HOME	boolean	bit	no
11	EXCEPTION_DOSE	boolean	bit	no
12	EXCEPTION_USER_ID	string	varchar(20)	yes
13	EXCEPTION_DATE	datetime	datetime	yes
14	DOSE_REFUSED	boolean	bit	yes
15	COMMENTS	string	varchar(1000)	yes
16	ORIG_TAKE_HOME	boolean	bit	yes