ATTENDANCE_ACTIVITIES · Accumedic EHI Export Format

01Relates to the patient

ATTENDANCE_DATE + EPISODE_CARE_ID matches ATTENDANCES.ATTENDANCE_DATE + ATTENDANCES.EPISODE_CARE_ID on a row of ATTENDANCES that relates to the patient

Single-patient export: the patient's rows.

02References

ACTIVITY_CODE → ACTIVITIES.ACTIVITY_CODE
APPT_ID → APPOINTMENTS.APPT_ID
ENCOUNTER_ID → EMR_ENCOUNTERS.ENCOUNTER_ID
APPT_PAT_GROUP → APPT_PAT_GROUPS.APPT_PAT_GROUP
ATTENDANCE_DATE, EPISODE_CARE_ID → ATTENDANCES.ATTENDANCE_DATE, EPISODE_CARE_ID

03Columns

#	Column	Type	Source type	Null	Notes
1	ATTENDANCE_DATE PK	datetime	smalldatetime	no
2	EPISODE_CARE_ID PK	integer	int	no
3	ACTIVITY_SEQUENCE PK	integer	int	no
4	ACTIVITY_CODE	string	varchar(15)	yes
5	ACTIVITY_TYPE	integer	int	no
6	START_DATETIME	datetime	datetime	yes
7	END_DATETIME	datetime	datetime	yes
8	BILLABLE	string	char(1)	no
9	ENTRY_DATE	datetime	datetime	no
10	ENTRY_USER_ID	string	varchar(20)	no
11	CHANGE_DATE	datetime	datetime	no
12	CHANGE_USER_ID	string	varchar(20)	no
13	APPT_PAT_GROUP	string	varchar(15)	yes
14	COMMENT	string	varchar(80)	yes
15	APPT_ID	integer	int	yes
16	ENCOUNTER_ID	integer	int	yes