SERVICES · Accumedic EHI Export Format

01Relates to the patient

reference data (no patient link)

Single-patient export: included in full (reference data).

02References

COPS_SERVICE_NAME → SERVICES.SERVICE_NAME
SERVICE_CLASS → SERVICE_CLASSES.SERVICE_CLASS
COMPANY_CODE → PAYORS.COMPANY_CODE
PROVIDER_CODE → PROVIDERS.PROVIDER_CODE
APG_CODE → APG_CODES.APG_CODE
DOSE_FORM → MMT_DOSE_FORMS.DOSE_FORM
FACILITY_TYPE_CODE → V_FACILITY_TYPES.FACILITY_TYPE_CODE
OFFICE_LOCATION → LOCATIONS.OFFICE_LOCATION
POS_CODE → V_PLACE_OF_SERVICE.POS_CODE
PROGRAM_CODE → PROGRAM_CODES.PROGRAM_CODE
REV_CODE → REV_CODES.REV_CODE
MEDICAID_SPECIALTY_CODE → V_MM_CLINIC_SPECIALTY.MEDICAID_SPECIALTY_CODE
TAXONOMY_CODE → TAXONOMY_CODES.TAXONOMY_CODE

03Columns

#	Column	Type	Source type	Null
1	SERVICE_NAME PK	string	varchar(40)	no
2	CATEGORY	string	varchar(4)	yes
3	OFFICE_LOCATION	string	varchar(20)	yes
4	APPOINTMENT_LEN	integer	int	yes
5	NUM_FOLLOWUPS	integer	int	yes
6	RESOURCE_ID	string	varchar(30)	yes
7	APPT_CLASS	string	varchar(15)	yes
8	RECALL_Y_N	string	char(1)	yes
9	RECALL_DAYS	integer	int	yes
10	MEDICAID_SPECIALTY_CODE	string	varchar(3)	yes
11	MC_COVERED	string	char(1)	no
12	PROVIDER_CODE	string	varchar(20)	yes
13	BILLABLE	string	char(1)	no
14	SERVICE_ACTIVE	string	char(1)	yes
15	CLAIM_FORM_B	string	char(1)	yes
16	MMIS_COPS	string	char(1)	yes
17	COPS_SERVICE_NAME	string	varchar(40)	yes
18	PAYROLL_FLAG	string	char(1)	yes
19	SERVICE_CLASS	string	varchar(15)	yes
20	BILL_LAST_PAYOR	string	char(1)	yes
21	REV_CODE	string	varchar(5)	yes
22	PROGRAM_CODE	string	varchar(15)	yes
23	ADJUST_IF_COPS	string	char(1)	yes
24	ALWAYS_ADJUST	string	char(1)	yes
25	CLAIM_TYPE	string	char(1)	yes
26	REF_PROV_REQUIRED	string	char(1)	yes
27	REF_PROV_HANDLING	integer	int	yes
28	USE_PROGRAM_PROVIDER	string	char(1)	yes
29	TAXONOMY_CODE	string	varchar(10)	yes
30	UNIT_MINUTES	integer	int	yes
31	ROUNDING_POINT	string	char(1)	yes
32	POS_CODE	string	varchar(2)	yes
33	RULES_ONLY	string	char(1)	yes
34	COMPANY_CODE	string	varchar(20)	yes
35	APG	string	char(1)	yes
36	MASTER_TEMPLATE_NAME	string	varchar(50)	yes
37	INPATIENT	string	char(1)	yes
38	FACILITY_TYPE_CODE	string	varchar(2)	yes
39	REQUIRE_ACC_DATE	string	char(1)	yes
40	RECON_REBILL_CPT_ICD	string	char(1)	yes
41	NOTES	string	text	yes
42	APG_CODE	string	varchar(4)	yes
43	SPEND_DOWN	string	char(1)	yes
44	REQUIRE_NOTE	string	char(1)	yes
45	SERVICE_TYPE	integer	int	yes
46	BILL_PROV_SUPV_PROV	string	char(1)	yes
47	MAX_LEAVE_DAYS	integer	int	yes
48	UNIT_MIN_DAILY_MAX	integer	int	yes
49	MIN_MINUTES	integer	int	yes
50	BILLABLE_ON_DISCHARGE	boolean	bit	yes
51	MMT_WEEKLY_BILLING	boolean	bit	yes
52	MIN_GROUP_MEMBERS	integer	int	yes
53	MAX_GROUP_MEMBERS	integer	int	yes
54	MIN_MMT_BILL_DAYS	integer	int	yes
55	MAX_MMT_BILL_DAYS	integer	int	yes
56	DOSE_FORM	integer	int	yes
57	MMT_SERVICE	boolean	bit	yes
58	MMT_BILL_ANNIV_DAY	boolean	bit	yes
59	DOSE_AMOUNT	decimal	numeric(5,2)	yes
60	DOSE_AMOUNT_MAX	decimal	numeric(5,2)	yes
61	MMT_BILL_EVERY_DAY	boolean	bit	yes
62	ACTIVITY_CODE	string	varchar(15)	yes
63	USE_ACTIVITY	string	char(1)	yes
64	ACTIVITY_MINUTES	integer	int	yes
65	MMT_MULTIPLY_TH_UNITS	boolean	bit	yes
66	MMT_APPEND_CLINIC_DAYS	boolean	bit	yes
67	MMT_PROMPT_MED_APPT	boolean	bit	yes
68	SVC_WEIGHT	string	varchar(10)	yes
69	APPT_REMINDER	boolean	bit	yes
70	CLIA	boolean	bit	yes
71	THERAPY_WAIVER	boolean	bit	yes
72	ALLOW_ZERO_CHARGE	boolean	bit	yes
73	CLAIM_FREQUENCY	string	char(1)	yes
74	PROC_ACTIVE	string	char(1)	yes