EMR_PROBLEMS_LIST · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

#	Column	Type	Source type	Null
1	PROBLEM_ID PK	integer	int	no
2	ACCOUNT	string	varchar(12)	no
3	PROBLEM_PRIORITY	integer	smallint	yes
4	START_DATE	datetime	datetime	yes
5	RESOLVED_DATE	datetime	datetime	yes
6	USER_ID	string	varchar(20)	yes
7	CREATED_DATE	datetime	datetime	yes
8	MODIFIED_USERID	string	varchar(20)	yes
9	MODIFIED_DATETIME	datetime	datetime	yes
10	PROBLEM_DESCRIPTION	string	varchar(max)	yes
11	SEVERITY	string	varchar(max)	yes
12	DURATION	string	varchar(max)	yes
13	DIAG_CODE	string	varchar(8)	yes
14	CATEGORY	string	varchar(50)	yes
15	IS_DELETED	boolean	bit	yes
16	RCOPIA_ID	string	varchar(12)	yes
17	SNOMED_VERSION	string	varchar(40)	yes
18	CONCEPT_ID	string	varchar(20)	yes
19	ACTOR_ID	string	varchar(100)	yes
20	PROBLEM_STATUS	string	varchar(15)	yes
21	STATUS	string	varchar(20)	yes
22	SOURCE	string	varchar(20)	yes