EMR_ENCOUNTERS_TX_GOALS · 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.

ENCOUNTER_ID → EMR_ENCOUNTERS.ENCOUNTER_ID
GROUPID, PROBLEMNUMBER, GOALNUMBER → GOAL.GROUPID, PROBLEMNUMBER, GOALNUMBER
GOAL_NUMBER → W_GOALS.GOAL_NUMBER
GOAL_TYPE → EMR_V_GOAL_TYPES.GOAL_TYPE
ASSESSMENT_ENCOUNTER_ID, NEED_SEQUENCE_NO → EMR_ENCOUNTERS_ASSESSED_NEEDS.ENCOUNTER_ID, SEQUENCE_NO
CLIENT_PROGRESS_RATING → EMR_V_CLIENT_PROGRESS_RATING.RATING
SEVERITY → EMR_V_TX_SEVERITY.SEVERITY

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	GOAL_SEQUENCE_NO PK	integer	int	no
3	GOAL	string	varchar(max)	yes
4	DATE_IDENTIFIED	datetime	datetime	yes
5	TARGET_DATE	datetime	datetime	yes
6	GOAL_PROGRESS	string	char(1)	yes
7	PROGRESS_STATUS_DATE	datetime	datetime	yes
8	PROGRESS_SUMMARY	string	varchar(max)	yes
9	TX_GOALS_REVIEWED	boolean	bit	yes
10	DESIRED_OUTCOMES	string	varchar(max)	yes
11	STRENGTHS_SKILLS	string	varchar(max)	yes
12	SUPPORTS_RESOURCES	string	varchar(max)	yes
13	BARRIERS	string	varchar(max)	yes
14	PATIENT_PRIORITIES_FOR_TREATMENT	string	varchar(max)	yes
15	GROUPID	integer	smallint	yes
16	PROBLEMNUMBER	integer	smallint	yes
17	GOALNUMBER	integer	smallint	yes
18	CLIENT_RESPONSE	string	varchar(max)	yes
19	ASSESSMENT_ENCOUNTER_ID	integer	int	yes
20	NEED_SEQUENCE_NO	integer	int	yes
21	GOAL_TYPE	string	char(1)	yes
22	ADJUSTED_TARGET_DATE	datetime	datetime	yes
23	GOAL_NUMBER	integer	int	yes
24	CLIENT_PROGRESS_RATING	integer	int	yes
25	SEVERITY	integer	int	yes
26	IS_DELETED	boolean	bit	yes
27	ASSESSED_NEED	string	varchar(500)	yes
28	NOTED	boolean	bit	yes
29	SEQUENCE_NO	integer	int	no