PAT_ACTION_DATES · 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	ACCOUNT PK	string	varchar(12)	no
2	RECALL_DATE	datetime	datetime	yes
3	LAST_STATEMENT_DATE	datetime	datetime	yes
4	LAST_ACTIVITY_DATE	datetime	datetime	yes
5	DATE_FIRST_CONSULTED	datetime	datetime	yes
6	DATE_LAST_SEEN	datetime	datetime	yes
7	RELEASE_OF_INFO_DATE	datetime	datetime	yes
8	RELEASE_OF_INFO_IND	string	char(1)	yes
9	BILLING_NOTE	string	varchar(1000)	yes
10	POSTING_NOTE	string	varchar(1000)	yes
11	INTAKE_DATE	datetime	smalldatetime	yes
12	CROSSOVER_NOTE	string	varchar(1000)	yes
13	SENT_TO_COLLECTION_IND	string	char(1)	yes
14	SENT_TO_COLLECTION_DATE	datetime	datetime	yes
15	LAST_MD_VISIT	datetime	datetime	yes
16	CONSENT_TO_TREATMENT	datetime	datetime	yes
17	ALERT_NOTE	string	varchar(1000)	yes
18	MEDICATION_LAST_UPDATE	datetime	datetime	yes
19	ALLERGY_LAST_UPDATE	datetime	datetime	yes
20	PROBLEMS_LAST_UPDATE	datetime	datetime	yes
21	PRESCRIPTION_LAST_UPDATE	datetime	datetime	yes
22	PAT_NOTE	string	varchar(1000)	yes
23	PAT_REMARKS	string	varchar(1000)	yes
24	PAT_NOTES	string	varchar(1000)	yes