MMT_THERAPEUTIC_GUIDANCE · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

DOSE_DATE, DOSE_SEQUENCE, DOSE_GEN, ACCOUNT, EPISODE_CARE_ID, ORDER_ID → MMT_ORDER_DETAILS.DOSE_DATE, DOSE_SEQUENCE, DOSE_GEN, ACCOUNT, EPISODE_CARE_ID, ORDER_ID

#	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	TG_USER_ID	string	varchar(20)	yes
8	TG_START_DATETIME	datetime	datetime	yes
9	TG_DATETIME	datetime	datetime	yes
10	TG_TH_PICKUP	boolean	bit	yes
11	TG_TH_LOCKBOX	boolean	bit	yes
12	TG_SIDE_EFFECTS	boolean	bit	yes
13	TG_MISSED_DOSES	boolean	bit	yes
14	TG_WITHDRAWAL	boolean	bit	yes
15	TG_INGESTION	boolean	bit	yes
16	TG_INGESTION_NONE	boolean	bit	yes
17	TG_INGESTION_MILD	boolean	bit	yes
18	TG_INGESTION_SEVERE	boolean	bit	yes
19	TG_OBSERVATION	string	varchar(1000)	yes
20	TG_OBS_SIDE_EFFECTS	string	varchar(1000)	yes
21	TG_OBS_MISSED_DOSES	string	varchar(1000)	yes
22	TG_OBS_WITHDRAWAL	string	varchar(1000)	yes