EMR_PATIENT_ASSESSMENTS · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT; or 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.

02References

SCORE_DLA_ICD10_SI_SEQ → EMR_V_DLA_ICD10_SI_CROSSWALK.SEQUENCE_NO
INCOMPLETE_REASON_ID → V_ASSESSMENT_TOOL_INCOMPLETE_REASONS.INCOMPLETE_REASON_ID
SCORE_DLA_MGAF_SEQ → EMR_V_DLA_MGAF_CROSSWALK.SEQUENCE_NO
TOOL_ID → ASSESSMENT_TOOLS.TOOL_ID

03Columns

#	Column	Type	Source type	Null	Notes
1	ASSESSMENT_ID PK	integer	int	no
2	TOOL_ID	integer	int	no
3	ACCOUNT	string	varchar(12)	no
4	EPISODE_CARE_ID	integer	int	no
5	ENCOUNTER_ID	integer	int	yes
6	ENTRY_DATE	datetime	datetime	no
7	ENTRY_USER_ID	string	varchar(20)	no
8	CHANGE_DATE	datetime	datetime	yes
9	CHANGE_USER_ID	string	varchar(20)	yes
10	SCORE_TOTAL	integer	int	yes
11	SCORE_INTERPRETATION	string	varchar(max)	yes
12	IS_DELETED	boolean	bit	yes
13	INCOMPLETE_REASON_ID	integer	int	yes
14	SCORE_AVG	decimal	decimal(5,1)	yes
15	SCORE_AVG_DESC	string	varchar(max)	yes
16	SCORE_DLA_MGAF	decimal	decimal(7,1)	yes
17	SCORE_DLA_MGAF_SEQ	integer	int	yes
18	SCORE_DLA_ICD10_SI_SEQ	integer	int	yes