MMT_TH_BOTTLES_LOG · 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	TH_BOTTLE_ID	integer	bigint	no
2	ACCOUNT	string	varchar(12)	no
3	EPISODE_CARE_ID	integer	int	no
4	ORDER_ID	integer	int	no
5	DOSE_DATE	datetime	smalldatetime	no
6	DOSE_SEQUENCE	integer	int	no
7	DOSE_LINE_NO	integer	int	no
8	RETURN_TYPE	integer	int	yes
9	RETURN_DATE	datetime	datetime	yes
10	RETURN_USER_ID	string	varchar(20)	yes
11	RETURN_QUANTITY	integer	int	yes
12	ENTRY_DATE	datetime	datetime	no
13	ENTRY_USER_ID	string	varchar(20)	no
14	CHANGE_DATE	datetime	datetime	no
15	CHANGE_USER_ID	string	varchar(20)	no