MMT_DOSE_IMAGES · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

DOSE_DATE, DOSE_SEQUENCE, DOSE_GEN, DOSE_LINE_NO, ACCOUNT, EPISODE_CARE_ID, ORDER_ID → MMT_DOSE_DETAILS.DOSE_DATE, DOSE_SEQUENCE, DOSE_GEN, DOSE_LINE_NO, ACCOUNT, EPISODE_CARE_ID, ORDER_ID

03Columns

#	Column	Type	Source type	Null	Notes
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_LINE_NO PK	integer	int	no
8	IMAGE_ID PK	integer	int	no
9	IMAGE_DATETIME	datetime	datetime	no
10	ENTRY_USER_ID	string	varchar(20)	no
11	IMAGE_BODY	file	image	no	Stored file; the value is the path of the file under documents/.