More Importing Features

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 14: Line 14:
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p>&nbsp;</p>
+
<p>The following elements should be included in this file:</p>
 +
<table style="margin-left: auto; margin-right: auto;" border="0">
 +
<tbody>
 +
<tr>
 +
<td align="center"><strong>&nbsp;</strong></td>
 +
<td align="center"><strong>&nbsp;Column name</strong></td>
 +
<td align="center"><strong>&nbsp;Column content</strong></td>
 +
</tr>
 +
<tr>
 +
<td align="center">1.</td>
 +
<td style="text-align: left;" align="center">PATIENT_ID</td>
 +
<td style="text-align: left;" align="center">Patient ID number (Integer)</td>
 +
</tr>
 +
<tr>
 +
<td align="center">2.</td>
 +
<td style="text-align: left;" align="center">PARTNER_ID</td>
 +
<td style="text-align: left;" align="center">Partner ID number (Integer)</td>
 +
</tr>
 +
<tr>
 +
<td align="center">3.</td>
 +
<td style="text-align: left;" align="center">GEBURTSDATUM</td>
 +
<td style="text-align: left;" align="center">Patient date of birth (Date)</td>
 +
</tr>
 +
<tr>
 +
<td align="center">4.</td>
 +
<td style="text-align: left;" align="center">NACHNAME</td>
 +
<td style="text-align: left;" align="center">Patient surname (100 characters)</td>
 +
</tr>
 +
<tr>
 +
<td align="center">5.</td>
 +
<td style="text-align: left;" align="center">VORNAME</td>
 +
<td style="text-align: left;" align="center">Patient first name (100 characters)</td>
 +
</tr>
 +
<tr>
 +
<td align="center">6.</td>
 +
<td style="text-align: left;" align="center">GESCHLECHT</td>
 +
<td style="text-align: left;" align="center">Patient gender (1 character - W/M)</td>
 +
</tr>
 +
<tr>
 +
<td align="center">7.</td>
 +
<td style="text-align: left;" align="center">PLZ</td>
 +
<td style="text-align: left;" align="center">Patient address: postal code (50 characters)<br /></td>
 +
</tr>
 +
<tr>
 +
<td align="center">8.</td>
 +
<td style="text-align: left;" align="center">ORT</td>
 +
<td style="text-align: left;" align="center">Patient address: city (50 characters)<br /></td>
 +
</tr>
 +
<tr>
 +
<td align="center">9.</td>
 +
<td style="text-align: left;" align="center">STRASSE</td>
 +
<td style="text-align: left;" align="center">Patient address: street (255 characters)</td>
 +
</tr>
 +
<tr>
 +
<td align="center">10.</td>
 +
<td style="text-align: left;" align="center">TEL_PRIVAT</td>
 +
<td style="text-align: left;" align="center">E-claim billing (1 = yes, 0 = no)&nbsp;</td>
 +
</tr>
 +
</tbody>
 +
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<ul>
 
<ul>
Line 103: Line 162:
 
<ul>
 
<ul>
 
<li>Not all fields are required;</li>
 
<li>Not all fields are required;</li>
−
<li>Required fields are:                      
+
<li>Required fields are:                      
 
<ul>
 
<ul>
 
<li>IN_NAME</li>
 
<li>IN_NAME</li>

Revision as of 15:34, 22 February 2017

This page contains additional importing features supported by MedITEX.

 

Historical patient data import

Please plan enough time for the preparation of the data import as it usually takes several tries to bring all data in required structure.

You need to prepare a list in Excel or CSV format with the following where each line in the import file is one patient.

<tbody> </tbody>
<img src="/images/plus48.png" alt="" width="48" height="48" />

<a href="/images/Insurance.xls">Click here</a> to download an example of Patient demographics import file.

The following elements should be included in this file:

<tbody> </tbody>
   Column name  Column content
1. PATIENT_ID Patient ID number (Integer)
2. PARTNER_ID Partner ID number (Integer)
3. GEBURTSDATUM Patient date of birth (Date)
4. NACHNAME Patient surname (100 characters)
5. VORNAME Patient first name (100 characters)
6. GESCHLECHT Patient gender (1 character - W/M)
7. PLZ Patient address: postal code (50 characters)
8. ORT Patient address: city (50 characters)
9. STRASSE Patient address: street (255 characters)
10. TEL_PRIVAT E-claim billing (1 = yes, 0 = no) 

 

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.

<tbody> </tbody>
<img src="/images/plus48.png" alt="" width="48" height="48" />

<a href="/images/Insurance.xls">Click here</a> to download an example of Insurance information import file.

 

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

<tbody> </tbody>
   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 <a href="/images/Countries.xls">downloaded here</a>
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) 

 

<tbody> </tbody>
<img src="/images/hint129.png" alt="" width="129" height="129" />
  • Not all fields are required;
  • Required fields are:
    • IN_NAME
    • IN_INSURER_NO
    • IN_IS_ECLAIM_BILLING

 

<tbody> </tbody>

<a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a>

 <a href="#top">Back to top</a>