More Importing Features

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 57: Line 57:
 
<td style="text-align: left;" align="center">IN_COUNTRY</td>
 
<td style="text-align: left;" align="center">IN_COUNTRY</td>
 
<td style="text-align: left;" align="center">
 
<td style="text-align: left;" align="center">
<p><span>Insurer country (numeric code of a country)</span></p>
+
<p><span>Insurer country (numeric code related to the country)</span></p>
<p><span><img src="/images/plus48.png" alt="" width="48" height="48" />&nbsp;<a href="/images/Countries.xls">The list of countries and corresponding codes</a></span></p>
+
<p>The list of countries and corresponding codes&nbsp;can be <a href="/images/Countries.xls">downloaded here</a></p>
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 64: Line 64:
 
<td align="center">8.</td>
 
<td align="center">8.</td>
 
<td style="text-align: left;" align="center">IN_CLINIC_ID_NUMBER</td>
 
<td style="text-align: left;" align="center">IN_CLINIC_ID_NUMBER</td>
<td style="text-align: left;" align="center">Insurer clinic ID number (defined by clinic itself)</td>
+
<td style="text-align: left;" align="center">Insurer clinic ID number (defined by the clinic itself)</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 82: Line 82:
 
<tbody>
 
<tbody>
 
<tr>
 
<tr>
<td><img src="/images/hint129.png" alt="" width="129" height="129" /></td>
+
<td><img src="/images/hint48.png" alt="" width="48" height="48" /></td>
 
<td>
 
<td>
 
<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>
Line 98: Line 98:
 
</tbody>
 
</tbody>
 
</table>
 
</table>
<p style="text-align: center;">&nbsp;</p>
+
<p style="text-align: left;">&nbsp;</p>
<p>&nbsp;</p>
+
<p style="text-align: center;">&nbsp;</p>
+
 
<table style="float: right;" border="0">
 
<table style="float: right;" border="0">
 
<tbody>
 
<tbody>

Revision as of 08:17, 11 June 2014

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 Insurance information about one insurer from Brazil (numeric code for this country is 25) which is in E-claims.

<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/hint48.png" alt="" width="48" height="48" />
  • 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>