EMR_PATIENT_PROTOCOL_ASSESSMENT_SCHEDULE · Accumedic EHI Export Format

01Relates to the patient

PAT_PROTOCOL_ID + DRUG_PROTOCOL_ID matches EMR_PATIENT_DRUG_PROTOCOLS.PAT_PROTOCOL_ID + EMR_PATIENT_DRUG_PROTOCOLS.DRUG_PROTOCOL_ID on a row of EMR_PATIENT_DRUG_PROTOCOLS that relates to the patient

Single-patient export: the patient's rows.

02References

TOOL_ID → ASSESSMENT_TOOLS.TOOL_ID
CREATED_USER_ID → USERS.USER_ID
MODIFIED_USER_ID → USERS.USER_ID
ASSESSMENT_ID → EMR_PATIENT_ASSESSMENTS.ASSESSMENT_ID
PAT_PROTOCOL_ID, DRUG_PROTOCOL_ID → EMR_PATIENT_DRUG_PROTOCOLS.PAT_PROTOCOL_ID, DRUG_PROTOCOL_ID

03Columns

#	Column	Type	Source type	Null	Notes
1	PAT_PROTOCOL_ID PK	integer	int	no
2	DRUG_PROTOCOL_ID PK	integer	int	no
3	TOOL_ID	integer	int	no
4	SCHEDULE_DATE PK	datetime	datetime	no
5	DAY_NO	integer	int	yes
6	ASSESSMENT_ID	integer	int	yes
7	IS_DELETED	boolean	bit	yes
8	IS_DRUG_MONITOR	boolean	bit	yes
9	IS_DOSE_CONTROL	boolean	bit	yes
10	CREATED_DATE	datetime	datetime	yes
11	CREATED_USER_ID	string	varchar(20)	yes
12	MODIFIED_DATE	datetime	datetime	yes
13	MODIFIED_USER_ID	string	varchar(20)	yes
14	MISSED_REASON	string	varchar(100)	yes
15	MODIFIED_DATETIME	datetime	datetime	yes