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

#	Column	Type	Source type	Null
1	TX_PLAN_ID	integer	int	no
2	TX_PLAN_NAME	string	varchar(50)	yes
3	ACCOUNT	string	varchar(12)	yes
4	PROVIDER_CODE	string	varchar(20)	yes
5	PROGRAM_CODE	string	varchar(15)	yes
6	START_DATE	datetime	datetime	yes
7	COMPLETION_DATE	datetime	datetime	yes
8	NEXT_REVIEW_DATE	datetime	datetime	yes
9	COMMENTS	string	varchar(4000)	yes
10	IS_DELETED	boolean	bit	yes
11	CREATED_USER_ID	string	varchar(20)	yes
12	CREATED_DATE	datetime	datetime	yes
13	MODIFIED_USER_ID	string	varchar(20)	yes
14	MODIFIED_DATE	datetime	datetime	yes
15	ENCOUNTER_ID	integer	int	no