EMR_PATIENT_STATUS · Accumedic EHI Export Format

01Relates to the patient

APPT_ID matches APPOINTMENTS.APPT_ID on a row of APPOINTMENTS that relates to the patient

Single-patient export: the patient's rows.

#	Column	Type	Source type	Null
1	PAT_STATUS_ID PK	integer	int	no
2	APPT_ID	integer	int	no
3	APPT_DATETIME	datetime	datetime	no
4	PROVIDER_CODE	string	varchar(20)	yes
5	ROOM_ID	integer	smallint	yes
6	ROOMED_TIME	datetime	datetime	yes
7	ROOM_OUT_TIME	datetime	datetime	yes
8	USER_ID	string	varchar(20)	yes
9	CHECK_OUT	boolean	bit	yes
10	PATIENT_ACTIVITY	integer	int	yes