EMR_MAR_SCHEDULES · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

PAT_PROTOCOL_ID, DRUG_PROTOCOL_ID → EMR_PATIENT_DRUG_PROTOCOLS.PAT_PROTOCOL_ID, DRUG_PROTOCOL_ID
ACCOUNT, EPISODE_CARE_ID → PAT_PROGRAMS.ACCOUNT, EPISODE_CARE_ID
ADMIN_STATUS → EMR_MAR_STATUS_CODES.ADMIN_STATUS
MEDICATION_ID, ACCOUNT → EMR_PATIENT_MEDICATIONS.MEDICATION_ID, ACCOUNT

#	Column	Type	Source type	Null
1	MEDICATION_ID PK	integer	int	no
2	ACCOUNT PK	string	varchar(12)	no
3	SCHEDULED_DATE PK	datetime	datetime	no
4	ADMIN_STATUS	string	varchar(1)	yes
5	ADMIN_STATUS_DATE	datetime	datetime	yes
6	ADMIN_STATUS_USER_ID	string	varchar(20)	yes
7	COMMENTS	string	varchar(500)	yes
8	SIGNED_DATE	datetime	datetime	yes
9	SIGNED_USER_ID	string	varchar(20)	yes
10	CREATED_DATE	datetime	datetime	yes
11	CREATED_USER_ID	string	varchar(20)	yes
12	CHANGE_DATE	datetime	datetime	yes
13	CHANGE_USER_ID	string	varchar(20)	yes
14	EPISODE_CARE_ID	integer	int	yes
15	PROMPT_VALUE	string	varchar(350)	yes
16	PROMPT	string	varchar(100)	yes
17	PAT_PROTOCOL_ID	integer	int	yes
18	DRUG_PROTOCOL_ID	integer	int	yes
19	DAY_NO	integer	int	yes
20	EFFICACY	boolean	bit	yes