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

02References

DOSE_DATE, DOSE_SEQUENCE, DOSE_GEN, ACCOUNT, EPISODE_CARE_ID, ORDER_ID → MMT_ORDER_DETAILS.DOSE_DATE, DOSE_SEQUENCE, DOSE_GEN, ACCOUNT, EPISODE_CARE_ID, ORDER_ID
PMO_PK → POS_MOD_OVERRIDES.PMO_PK
ACCOUNT, EPISODE_CARE_ID, TEST_DATE, TEST_TYPE, SEQUENCE_NO → URINE_TESTS.ACCOUNT, EPISODE_CARE_ID, TEST_DATE, TEST_TYPE, SEQUENCE_NO
ACCOUNT → PATIENTS.ACCOUNT
DEPT_CODE → DEPARTMENTS.DEPT_CODE
ENCOUNTER → ENCOUNTERS.ENCOUNTER
ACCOUNT, EPISODE_CARE_ID → PAT_PROGRAMS.ACCOUNT, EPISODE_CARE_ID
LICENSE_PLATE → LICENSE_PLATES.LICENSE_PLATE
OFFICE_LOCATION → LOCATIONS.OFFICE_LOCATION
NON_BILLABLE_REASON → NON_BILLABLE_REASONS.NON_BILLABLE_REASON
APPT_PAT_GROUP → APPT_PAT_GROUPS.APPT_PAT_GROUP
PAYMENT_TYPE → V_PAYMENT_TYPES.PAYMENT_TYPE
INSURANCE_ID, COMPANY_CODE → INSURANCE_POLICIES.INSURANCE_ID, COMPANY_CODE
PROGRAM_CODE → PROGRAM_CODES.PROGRAM_CODE
PROVIDER_CODE → PROVIDERS.PROVIDER_CODE
REF_PROV_CODE → REFERRING_PROVIDERS.REF_PROV_CODE
REFERRAL_DESTINATION → REFERRAL_DESTINATIONS.REFERRAL_DESTINATION
REFERRAL_SOURCE → REFERRAL_SOURCES.REFERRAL_SOURCE
RESOURCE_ID → RESOURCES.RESOURCE_ID
TRANSPORT → TRANSPORTS.TRANSPORT
ACCOUNT, EPISODE_CARE_ID, TEST_DATE → URINE_TESTS.ACCOUNT, EPISODE_CARE_ID, TEST_DATE

03Columns

#	Column	Type	Source type	Null	Notes
1	APPT_ID PK	integer	int	no
2	APPT_DATE	datetime	datetime	no
3	ACCOUNT	string	varchar(12)	yes
4	PROVIDER_CODE	string	varchar(20)	no
5	RESOURCE_ID	string	varchar(30)	yes
6	APPT_CONFIRMED	string	char(1)	yes
7	OFFICE_LOCATION	string	varchar(20)	no
8	REF_PROV_CODE	string	varchar(20)	yes
9	NEW_PATIENT	string	char(1)	yes
10	COMMENT_TEXT	string	varchar(500)	yes
11	APPT_STATUS	string	char(1)	no
12	DURATION	integer	int	yes
13	ENCOUNTER	integer	int	yes
14	REFERRAL_NUMBER	string	varchar(15)	yes
15	AUTHORIZATION_NUMBER	string	varchar(40)	yes
16	AUTH_COMPANY_CODE	string	varchar(20)	yes
17	AUTH_LINE_NO	integer	int	yes
18	APPT_CLASS	string	varchar(15)	yes
19	DO_NOT_CANCEL	string	char(1)	yes
20	BILLABLE	string	char(1)	yes
21	AMOUNT_PAID	decimal	decimal(19,4)	yes
22	INVOICE	integer	int	yes
23	PAYMENT_TYPE	integer	int	yes
24	CHECK_NO	string	varchar(20)	yes
25	ENTRY_DATE	datetime	datetime	no
26	ENTRY_USER_ID	string	varchar(20)	no
27	CHANGE_DATE	datetime	datetime	no
28	CHANGE_USER_ID	string	varchar(20)	no
29	COPAY	decimal	decimal(19,4)	yes
30	CANCELLED_BY	string	char(1)	yes
31	IN_USE_BY	string	varchar(51)	yes
32	DOC_COMPLETE	string	char(1)	yes
33	ALARM_ENABLED	string	char(1)	yes
34	ALARM_ADVANCE	integer	int	yes
35	ORIGIN_ADDR1	string	varchar(30)	yes
36	ORIGIN_ADDR2	string	varchar(30)	yes
37	ORIGIN_CITY	string	varchar(27)	yes
38	ORIGIN_STATE	string	varchar(2)	yes
39	ORIGIN_ZIP	string	varchar(10)	yes
40	ORIGIN_PHONE	string	varchar(20)	yes
41	DEST_ADDR1	string	varchar(30)	yes
42	DEST_ADDR2	string	varchar(30)	yes
43	DEST_CITY	string	varchar(27)	yes
44	DEST_STATE	string	varchar(2)	yes
45	DEST_ZIP	string	varchar(10)	yes
46	DEST_PHONE	string	varchar(20)	yes
47	PICKUP_DATETIME	datetime	datetime	yes
48	COMPANY_CODE	string	varchar(20)	yes
49	INSURANCE_ID	string	varchar(25)	yes
50	APPT_PAT_GROUP	string	varchar(15)	yes
51	AUTH_REQ	string	char(1)	yes
52	RECEIPT_NUMBER	integer	int	yes
53	RECEIPT_DATE	datetime	datetime	yes
54	ORIGIN_JOB	integer	int	yes
55	DEST_JOB	integer	int	yes
56	PROGRAM_CODE	string	varchar(15)	yes
57	ARRIVAL_DATETIME	datetime	datetime	yes
58	START_DATETIME	datetime	datetime	yes
59	REFERRAL_DESTINATION	string	varchar(30)	yes
60	TRANSPORT	string	varchar(30)	yes
61	REFERRAL_SOURCE	string	varchar(30)	yes
62	LICENSE_PLATE	string	varchar(10)	yes
63	EVENT_DESCRIPTION	string	varchar(80)	yes
64	EVENT_CLASS	string	varchar(15)	yes
65	APPT_DELETED	string	char(1)	yes	Y = the appointment was deleted in the application. Deleted records are included in exports.
66	APPT_TYPE	integer	int	yes
67	CLAIM_MESSAGES	string	varchar(240)	yes
68	UNITS	decimal	numeric(10,2)	yes
69	NUM_COLLATERALS	integer	int	yes
70	NUM_ATTENDEES	integer	int	yes
71	DIRECT_DEPOSIT_NO	string	varchar(30)	yes
72	END_DATETIME	datetime	datetime	yes
73	CONFIRM_USER_ID	string	varchar(20)	yes
74	CONFIRM_DATE	datetime	datetime	yes
75	REF_LINE_NO	integer	int	yes
76	ENCOUNTER_ID	integer	int	yes
77	NON_BILLABLE_REASON	string	varchar(10)	yes
78	REFERRAL_REQ	string	char(1)	yes
79	SOURCE_APPT_ID	integer	int	yes
80	DEST_APPT_ID	integer	int	yes
81	RECEIPT_USER_ID	string	varchar(20)	yes
82	RECUR_APPT_ID	integer	int	yes
83	GROUP_APPT_ID	integer	int	yes
84	ATTENDED_GROUP	string	char(1)	yes
85	SESSION_ID	integer	int	yes
86	SESSION_CODE	string	varchar(40)	yes
87	DEPT_CODE	string	varchar(15)	yes
88	EVENT_NOTES	string	varchar(600)	yes
89	HOLD_CLAIM	string	char(1)	yes
90	LANGUAGE_INCENTIVE	string	char(1)	yes
91	EPISODE_CARE_ID	integer	int	yes
92	EXCHANGE_ID	string	varchar(240)	yes
93	EXCHANGE_CHANGE_DATE	datetime	datetime	yes
94	DISASTER_RECOVERY	string	char(1)	yes
95	FROM_EXCHANGE	boolean	bit	yes
96	EXCHANGE_APPT_TYPE	integer	int	yes
97	TEST_DATE	datetime	smalldatetime	yes
98	ORDER_ID	integer	int	yes
99	DOSE_DATE	datetime	smalldatetime	yes
100	DOSE_SEQUENCE	integer	int	yes
101	DOSE_GEN	integer	int	yes
102	SEQUENCE_NO	integer	int	yes
103	TEST_TYPE	integer	int	yes
104	BAC_VALUE	decimal	numeric(4,3)	yes
105	BAC_DATETIME	datetime	datetime	yes
106	BAC_USER_ID	string	varchar(20)	yes
107	ARRIVAL_USER_ID	string	varchar(20)	yes
108	ATTENDANCE_DATE	datetime	smalldatetime	yes
109	ACTIVITY_SEQUENCE	integer	int	yes
110	LOCK_PROCS	boolean	bit	yes
111	RESCHEDULED_FROM	integer	int	yes
112	NOTE_STATUS	integer	int	yes
113	PMO_PK	integer	int	yes
114	COUNTY	string	varchar(30)	yes
115	INTERPRETER_INCENTIVE	boolean	bit	yes
116	STATUS_NOTE	string	varchar(150)	yes