URINE_TESTS · 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	TEST_DATE PK	datetime	smalldatetime	no
4	SEQUENCE_NO PK	integer	int	no
5	ENTRY_USER_ID	string	varchar(20)	no
6	ENTRY_DATE	datetime	datetime	no
7	CHANGE_USER_ID	string	varchar(20)	no
8	CHANGE_DATE	datetime	datetime	no
9	DATE_PERFORMED	datetime	datetime	yes
10	DATE_RETURNED	datetime	datetime	yes
11	COMMENTS	string	varchar(1000)	yes
12	TEST_STATUS	integer	int	yes
13	DATE_COLLECTED	datetime	datetime	yes
14	OFFICE_LOCATION	string	varchar(20)	yes
15	LAB_ORDER_NUMBER	string	varchar(20)	yes
16	LAB_ID	string	varchar(40)	yes
17	TOX_SCHEDULE_ID	integer	int	yes
18	BAC_VALUE	decimal	numeric(4,3)	yes
19	TEST_TYPE PK	integer	int	no
20	DATE_REFUSED	datetime	datetime	yes
21	REFUSED_USER_ID	string	varchar(20)	yes
22	COLLECTED_USER_ID	string	varchar(20)	yes
23	CANCELLED_USER_ID	string	varchar(20)	yes
24	DATE_CANCELLED	datetime	datetime	yes