TOXICOLOGY_SCHEDULES · 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	TOX_SCHEDULE_ID PK	integer	int	no
2	ACCOUNT	string	varchar(12)	no
3	EPISODE_CARE_ID	integer	int	no
4	PROVIDER_CODE	string	varchar(20)	yes
5	START_DATE	datetime	datetime	no
6	END_DATE	datetime	datetime	no
7	LAB_ID	string	varchar(40)	no
8	TEST_GROUP_NAME	string	varchar(100)	no
9	TEST_TYPE	integer	int	no
10	IS_RANDOM	boolean	bit	no
11	TEST_FREQ	integer	int	yes
12	TEST_PER	integer	int	yes
13	DOW_SUNDAY	boolean	bit	yes
14	DOW_MONDAY	boolean	bit	yes
15	DOW_TUESDAY	boolean	bit	yes
16	DOW_WEDNESDAY	boolean	bit	yes
17	DOW_THURSDAY	boolean	bit	yes
18	DOW_FRIDAY	boolean	bit	yes
19	DOW_SATURDAY	boolean	bit	yes
20	DOM_EVERY	integer	int	yes
21	DOM_DAY_OF_WEEK	integer	int	yes
22	CTL_WEEK_SPACING	integer	int	yes
23	BILL_TYPE	integer	int	yes
24	IS_DELETED	boolean	bit	yes
25	IS_VOIDED	boolean	bit	yes
26	OFFICE_LOCATION	string	varchar(20)	yes
27	ORDERING_PHYSICIAN	string	varchar(20)	yes