More Importing Features
From MedITEX - Wiki
(Difference between revisions)
| Line 1: | Line 1: | ||
<p>This page contains additional importing features supported by <strong>MedITEX</strong>.</p> | <p>This page contains additional importing features supported by <strong>MedITEX</strong>.</p> | ||
<p> </p> | <p> </p> | ||
| − | <h2>Insurance | + | <h2>Insurance Import</h2> |
| − | <p> | + | <p>It is possible to import insurance companies by providing a spreadsheet with the information described on this section.</p> |
| + | <p>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.</p> | ||
| + | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
| + | <tbody> | ||
| + | <tr> | ||
| + | <td><img src="/images/plus48.png" alt="" width="48" height="48" /></td> | ||
| + | <td> | ||
| + | <p><a href="/images/Insurance.xls">Click here</a> to download an example of Insurance information import file.</p> | ||
| + | </td> | ||
| + | </tr> | ||
| + | </tbody> | ||
| + | </table> | ||
| + | <p> </p> | ||
<p>The structure of this file is described in the table below: </p> | <p>The structure of this file is described in the table below: </p> | ||
<table style="margin-left: auto; margin-right: auto;" border="0"> | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
| Line 13: | Line 25: | ||
<tr> | <tr> | ||
<td align="center">1.</td> | <td align="center">1.</td> | ||
| − | <td align="center">IN_NAME</td> | + | <td style="text-align: left;" align="center">IN_NAME</td> |
| − | <td align="center">Insurer name (50 characters)</td> | + | <td style="text-align: left;" align="center">Insurer name (50 characters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">2.</td> | <td align="center">2.</td> | ||
| − | <td align="center">IN_INSURER_NO</td> | + | <td style="text-align: left;" align="center">IN_INSURER_NO</td> |
| − | <td align="center">Insurer number (30 characters)</td> | + | <td style="text-align: left;" align="center">Insurer number (30 characters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">3.</td> | <td align="center">3.</td> | ||
| − | <td align="center">IN_ADDRESS</td> | + | <td style="text-align: left;" align="center">IN_ADDRESS</td> |
| − | <td align="center">Insurer address (255 characters)</td> | + | <td style="text-align: left;" align="center">Insurer address (255 characters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">4.</td> | <td align="center">4.</td> | ||
| − | <td align="center">IN_EMAIL</td> | + | <td style="text-align: left;" align="center">IN_EMAIL</td> |
| − | <td align="center">Insurer email (50 characters)</td> | + | <td style="text-align: left;" align="center">Insurer email (50 characters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">5.</td> | <td align="center">5.</td> | ||
| − | <td align="center">IN_PHONE</td> | + | <td style="text-align: left;" align="center">IN_PHONE</td> |
| − | <td align="center">Insurer phone (50 characters)</td> | + | <td style="text-align: left;" align="center">Insurer phone (50 characters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">6.</td> | <td align="center">6.</td> | ||
| − | <td align="center">IN_FAX</td> | + | <td style="text-align: left;" align="center">IN_FAX</td> |
| − | <td align="center">Insurer fax (50 characters)</td> | + | <td style="text-align: left;" align="center">Insurer fax (50 characters)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">7.</td> | <td align="center">7.</td> | ||
| − | <td align="center">IN_COUNTRY</td> | + | <td style="text-align: left;" align="center">IN_COUNTRY</td> |
| − | <td align="center"><span>Insurer country (numeric code of a country)</span> | + | <td style="text-align: left;" align="center"> |
| − | < | + | <p><span>Insurer country (numeric code of a country)</span></p> |
| − | < | + | <p><span><img src="/images/plus48.png" alt="" width="48" height="48" /> <a href="/images/Countries.xls">The list of countries and corresponding codes</a></span></p> |
| − | < | + | </td> |
| − | + | ||
| − | + | ||
| − | </ | + | |
| − | + | ||
| − | + | ||
| − | + | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">8.</td> | <td align="center">8.</td> | ||
| − | <td align="center">IN_CLINIC_ID_NUMBER</td> | + | <td style="text-align: left;" align="center">IN_CLINIC_ID_NUMBER</td> |
| − | <td align="center">Insurer clinic ID number (defined by clinic itself)</td> | + | <td style="text-align: left;" align="center">Insurer clinic ID number (defined by clinic itself)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">9.</td> | <td align="center">9.</td> | ||
| − | <td align="center">IN_IS_INSURANCE</td> | + | <td style="text-align: left;" align="center">IN_IS_INSURANCE</td> |
| − | <td align="center">Insurer / Funder (1 = insurer, 0 = funder)</td> | + | <td style="text-align: left;" align="center">Insurer / Funder (1 = insurer, 0 = funder)</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">10.</td> | <td align="center">10.</td> | ||
| − | <td align="center">IN_IS_ECLAIM_BILLING</td> | + | <td style="text-align: left;" align="center">IN_IS_ECLAIM_BILLING</td> |
| − | <td align="center">E-claim billing (1 = yes, 0 = no) </td> | + | <td style="text-align: left;" align="center">E-claim billing (1 = yes, 0 = no) </td> |
</tr> | </tr> | ||
</tbody> | </tbody> | ||
| Line 80: | Line 86: | ||
<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 93: | Line 99: | ||
</table> | </table> | ||
<p style="text-align: center;"> </p> | <p style="text-align: center;"> </p> | ||
| − | <p> | + | <p> </p> |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
<p style="text-align: center;"> </p> | <p style="text-align: center;"> </p> | ||
<table style="float: right;" border="0"> | <table style="float: right;" border="0"> | ||
Revision as of 09:13, 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.
| <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:
| 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 of a country) <img src="/images/plus48.png" alt="" width="48" height="48" /> <a href="/images/Countries.xls">The list of countries and corresponding codes</a> |
| 8. | IN_CLINIC_ID_NUMBER | Insurer clinic ID number (defined by clinic itself) |
| 9. | IN_IS_INSURANCE | Insurer / Funder (1 = insurer, 0 = funder) |
| 10. | IN_IS_ECLAIM_BILLING | E-claim billing (1 = yes, 0 = no) |
| <img src="/images/hint129.png" alt="" width="129" height="129" /> |
|
|
<a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a> |
<a href="#top">Back to top</a> |