EMR_ENCOUNTERS_UTILIZATION_REVIEW · Accumedic EHI Export Format

01Relates to the patient

ENCOUNTER_ID matches EMR_ENCOUNTERS.ENCOUNTER_ID on a row of EMR_ENCOUNTERS that relates to the patient

Single-patient export: the patient's rows.

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	ADDITIONAL_SERVICE_DETAIL	string	varchar(650)	yes
3	ADDITIONAL_SERVICE_NO	boolean	bit	yes
4	ADDITIONAL_SERVICE_YES	boolean	bit	yes
5	ADMISSION_DATE	datetime	datetime	yes
6	ADVERSE_DETERMINATION	string	varchar(650)	yes
7	CONTINUING_PROGRESS_DETAIL	string	varchar(650)	yes
8	CONTINUING_PROGRESS_NO	boolean	bit	yes
9	CONTINUING_PROGRESS_YES	boolean	bit	yes
10	DATE_OF_UR	datetime	datetime	yes
11	MODIFICATION_INDICATED_DETAIL	string	varchar(650)	yes
12	MODIFICATION_INDICATED_NO	boolean	bit	yes
13	MODIFICATION_INDICATED_YES	boolean	bit	yes
14	PATIENT_MEET_RETENTION_CRITERIA_DETAIL	string	varchar(650)	yes
15	PATIENT_MEET_RETENTION_NO	boolean	bit	yes
16	PATIENT_MEET_RETENTION_YES	boolean	bit	yes
17	PRIMARY1	boolean	bit	yes
18	QUALITY_IMPROVEMENT	string	varchar(650)	yes
19	RECOMMENDATION_SUMMARY_DETAIL	string	varchar(650)	yes
20	SERVICE_IDENTIFIED_NO	boolean	bit	yes
21	SERVICE_IDENTIFIED_YES	boolean	bit	yes
22	SERVICES_IDENTIFIED_DETAIL	string	varchar(650)	yes
23	SIGNIFICANT_OTHER	boolean	bit	yes
24	SUMMARY_OF_EFFECTIVENESS	string	varchar(650)	yes
25	NEXT_REVIEW_DATE	datetime	datetime	yes