EMR_ENCOUNTERS_TX_OBJECTIVES · 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, GOAL_SEQUENCE_NO → EMR_ENCOUNTERS_TX_GOALS.ENCOUNTER_ID, GOAL_SEQUENCE_NO
GOAL_NUMBER, OBJECTIVE_NUMBER, OBJECTIVE_FREQUENCY → W_OBJECTIVE_FREQUENCY.GOAL_NUMBER, OBJECTIVE_NUMBER, FREQUENCY_NUMBER
GOAL_NUMBER, OBJECTIVE_NUMBER, OBJECTIVE_LEVEL → W_OBJECTIVE_LEVELS.GOAL_NUMBER, OBJECTIVE_NUMBER, LEVEL_NUMBER
GROUPID, PROBLEMNUMBER, OBJECTIVENUMBER → OBJECTIVE.GROUPID, PROBLEMNUMBER, OBJECTIVENUMBER
GOAL_NUMBER, OBJECTIVE_NUMBER → W_OBJECTIVES.GOAL_NUMBER, OBJECTIVE_NUMBER

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	GOAL_SEQUENCE_NO PK	integer	int	no
3	OBJECTIVE_SEQUENCE PK	integer	int	no
4	OBJECTIVE	string	varchar(max)	yes
5	START_DATE	datetime	datetime	yes
6	TARGET_DATE	datetime	datetime	yes
7	OBJECTIVE_PROGRESS	string	char(1)	yes
8	PROGRESS_STATUS_DATE	datetime	datetime	yes
9	GROUPID	integer	smallint	yes
10	PROBLEMNUMBER	integer	smallint	yes
11	OBJECTIVENUMBER	integer	smallint	yes
12	ADDRESSED_ON_NOTE	boolean	bit	yes
13	PROGRESS_SUMMARY	string	varchar(max)	yes
14	ADJUSTED_TARGET_DATE	datetime	datetime	yes
15	GOAL_NUMBER	integer	int	yes
16	OBJECTIVE_NUMBER	integer	int	yes
17	OBJECTIVE_LEVEL	integer	int	yes
18	OBJECTIVE_FREQUENCY	integer	int	yes
19	IS_DELETED	boolean	bit	yes