MMT_REPLENISH_ORDERS · Accumedic EHI Export Format

01Relates to the patient

reference data (no patient link)

Single-patient export: not included (not referenced by patient records).

#	Column	Type	Source type	Null
1	RO_ID PK	integer	int	no
2	SEND_OFFICE_LOCATION	string	varchar(20)	no
3	RECEIVE_OFFICE_LOCATION	string	varchar(20)	no
4	RO_STATUS	integer	int	no
5	NARC_REQ_NO	string	varchar(10)	yes
6	ENTRY_DATE	datetime	datetime	no
7	ENTRY_USER_ID	string	varchar(20)	no
8	CHANGE_DATE	datetime	datetime	no
9	CHANGE_USER_ID	string	varchar(20)	no
10	FILLED_DATE	datetime	datetime	yes
11	FILLED_USER_ID	string	varchar(20)	yes
12	INSPECT_DATE	datetime	datetime	yes
13	INSPECT_USER_ID	string	varchar(20)	yes
14	PICKUP_DATE	datetime	datetime	yes
15	PICKUP_USER_ID	string	varchar(20)	yes
16	RECEIVE_DATE	datetime	datetime	yes
17	RECEIVE_USER_ID	string	varchar(20)	yes
18	CANCEL_DATE	datetime	datetime	yes
19	CANCEL_USER_ID	string	varchar(20)	yes
20	CONFIRMED	boolean	bit	yes
21	SEND_DATE	datetime	datetime	yes
22	SEND_USER_ID	string	varchar(20)	yes