EMR_ENCOUNTERS_TX_PLAN · 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	TX_PLAN_NAME	string	varchar(50)	no
3	START_DATE	datetime	datetime	yes
4	COMPLETION_DATE	datetime	datetime	yes
5	NEXT_REVIEW_DATE	datetime	datetime	yes
6	COMMENTS	string	varchar(max)	yes
7	IS_DELETED	boolean	bit	yes
8	DATE_REVIEWED	datetime	datetime	yes
9	CREATED_USER_ID	string	varchar(20)	yes
10	CREATED_DATE	datetime	datetime	yes
11	MODIFIED_USER_ID	string	varchar(20)	yes
12	MODIFIED_DATE	datetime	datetime	yes
13	LAST_TX_PLAN	boolean	bit	yes
14	TX_TYPE	integer	int	yes
15	REVIEW_DAYS	integer	int	yes
16	TX_UPDATE_REASON	string	varchar(350)	yes