This page contains additional importing features supported by MedITEX.

 

Insurance Import

It is possible to import insurance companies by providing a spreadsheet with the information described on this section.

An example of this file can be downloaded from the link below. This document contains the insurance information about one insurer.

Click here to download an example of Insurance information import file.

 

The structure of this file is described in the table below: 

	Column name	Column content
1.	IN_NAME	Insurer name (50 characters)
2.	IN_INSURER_NO	Insurer number (30 characters)
3.	IN_ADDRESS	Insurer address (255 characters)
4.	IN_EMAIL	Insurer email (50 characters)
5.	IN_PHONE	Insurer phone (50 characters)
6.	IN_FAX	Insurer fax (50 characters)
7.	IN_COUNTRY	Insurer country (numeric code related to the country) The list of countries and corresponding codes can be downloaded here
8.	IN_CLINIC_ID_NUMBER	Insurer clinic ID number (defined by the clinic itself)
9.	IN_IS_INSURANCE	Insurer / Funder (1 = insurer, 0 = funder)
10.	IN_IS_ECLAIM_BILLING	E-claim billing (1 = yes, 0 = no)

 

Not all fields are required; Required fields are: IN_NAME IN_INSURER_NO IN_IS_ECLAIM_BILLING

 

Demographics Import

It is possible to import patient data by providing a spreadsheet with the information described on this section.

	Name of field (Program)	Name of field (Database)	Data type
1.	Patient ID	PATIENT_ID	VARCHAR(64)
2.	Anonymous ID	ANONYM_ID	VARCHAR(100)
3.	Location	STANDORT_ID	INTEGER
4.	Title	TITEL	VARCHAR(50)
5.	First name	VORNAME	VARCHAR(100)
6.	Surname	NACHNAME	VARCHAR(100)
7.	Surname at birth	GEBURTSNAME	VARCHAR(30)
8.	Marital status	KV_FAMILIENSTAND	VARCHAR(20)
9.	Date of birth	GEBURTSDATUM	DATE
10.	Place of birth	GEBURTSORT	VARCHAR(50)
11.	Province of birth	GEBURTS_BEZIRK	INTEGER
12.	Region of birth	GEBURTS_REGION_ID	INTEGER
13.	Country of birth	GEBURTS_LAND	INTEGER
14.	Nationality	NATIONALITAET_ID	INTEGER
15.	Mother tongue	P_MUTTERSPRACHE	VARCHAR(50)
16.	Note	NOTE	BLOB SUB_TYPE 1 SEGMENT SIZE 80
17.	VIP Patient	VIP	SMALLINT
18.	Person with disability	BEHINDERT	SMALLINT
19.	Identity card ID	PERS_NR	VARCHAR(20)
20.	Country of issue	AUSWEIS_LAND	INTEGER
21.	Emirates ID	P_SOCIAL_SECURITY_NO	VARCHAR(30)
22.	Tax code	P_TAX_CODE	VARCHAR(50)
23.	From abroad	AUSLAND	SMALLINT
24.	Street / no.	STRASSE	VARCHAR(255)
25.	Address supplement	P_ADDRESS_SUPPLEMENT	VARCHAR(128)
26.	Post code	PLZ	VARCHAR(50)
27.	Province	P_ADDRESS_PROVINCE_ID	INTEGER
28.	Region	REGION_ID	INTEGER
29.	Country	LAND	VARCHAR(100)
30.	Phone	TEL_PRIVAT	VARCHAR(50)
31.	Mobile	MOBIL_PRIVAT	VARCHAR(50)
32.	Fax	FAX_PRIVAT	VARCHAR(50)
33.	E-Mail	EMAIL	VARCHAR(100)
34.	Patient's information source	INFORMATION_FROM_ID	INTEGER
35.	Patient's information source: note	INFORMATION_FROM_NOTE	BLOB SUB_TYPE 1 SEGMENT SIZE 80
36.	Billing category	ABRECHNUNGSART	SMALLINT
37.	Main invoice receiver	P_MAIN_INVOICE_RECEIVER_ID	INTEGER
38.	Co-payment	P_INSURANCE_COPAYMENT	VARCHAR(30)
39.	Accounting ID	P_ACCOUNTING_ID	VARCHAR(30)
40.	For external services	P_EXTERN_INVOICE_RECEIVER_ID	INTEGER
41.	Heath insurance	PE_INSURER_ID	INTEGER
42.	Policy group number	KV_VERSICHERUNGS_NR	VARCHAR(30)
43.	Policy group number	P_INSURANCE1_POLICY_GROUP_NO	VARCHAR(30)
44.	Card category	P_INSURANCE1_CARD_CATEGORY	VARCHAR(30)
45.	Insurance status	KV_STATUS	VARCHAR(20)
46.	Policy start date	KV_DT_EINLESEN	TIMESTAMP
47.	Policy expiry date	KV_GUELTIG_BIS	TIMESTAMP
48.	Heath insurance	P_INSURER2_ID	INTEGER
49.	Policy group number	P_INSURANCE2_POLICY_NO	VARCHAR(30)
50.	Policy group number	P_INSURANCE2_POLICY_GROUP_NO	VARCHAR(30)
51.	Card category	P_INSURANCE2_CARD_CATEGORY	VARCHAR(30)
52.	Insurance status	P_INSURANCE2_STATUS	VARCHAR(30)
53.	Policy start date	P_INSURANCE2_START_DT	TIMESTAMP
54.	Policy expiry date	P_INSURANCE2_EXPIRY_DT	TIMESTAMP
55.	Oranisation / institution	P_SPONSOR_ID	INTEGER
56.	Number	P_SPONSORING_NO	VARCHAR(30)
57.	Status	P_SPONSORING_STATUS	VARCHAR(50)
58.	Valid form	P_SPONSORING_DT_VALID_FROM	TIMESTAMP
59.	Valid until	P_SPONSORING_DT_VALID_UNTIL	TIMESTAMP
60.	Sort code	BV_BLZ	INTEGER
61.	Bank	BV_BANK	VARCHAR(128)
62.	Account number	BV_KONTONUMMER	VARCHAR(20)
63.	Employed / occupied	P_IS_WORKING	SMALLINT
64.	Occupation	BERUF	VARCHAR(50)
65.	Supplement	BERUFSZUSATZ	VARCHAR(100)
66.	Employer	ARBEITGEBER	VARCHAR(100)
67.	Phone	TEL_BERUF	VARCHAR(50)
68.	Mobile	MOBIL_BERUF	VARCHAR(50)
69.	Fax	FAX_BERUF	VARCHAR(50)
70.	Employer note	ARBEITGEBERNOTES	BLOB SUB_TYPE 1 SEGMENT SIZE 80
71.	Referrer 1	ZUWEISER_1_ID	INTEGER
72.	Notification	Z1_BENACHRICHTIGUNG	SMALLINT
73.	Referrer 2	ZUWEISER_2_ID	INTEGER
74.	Notification	Z2_BENACHRICHTIGUNG	SMALLINT
75.	Referrer 3	ZUWEISER_3_ID	INTEGER
76.	Notification	Z3_BENACHRICHTIGUNG	SMALLINT
77.	Patient uses the web portal	P_WEBPORTAL_ISUSER	SMALLINT
78.	Account is used together with a partner	P_WEBPORTAL_PARTNERZUGANG	SMALLINT
79.	User name	P_WEBPORTAL_USERNAME	VARCHAR(32)

Back to Import and Export tools

Back to top