More Importing Features
From MedITEX - Wiki
(Difference between revisions)
| Line 8: | Line 8: | ||
<tbody> | <tbody> | ||
<tr> | <tr> | ||
| − | <td align="center"><strong> | + | <td align="center"><strong> </strong></td> |
| + | <td align="center"><strong> Column name</strong></td> | ||
<td align="center"><strong> Column content</strong></td> | <td align="center"><strong> Column content</strong></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center">1.</td> | <td align="center">1.</td> | ||
| + | <td align="center">IN_NAME</td> | ||
<td align="center">Insurer name (50 characters)</td> | <td 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 align="center">Insurer number (30 characters)</td> | <td 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 align="center">Insurer address (255 characters)</td> | <td 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 align="center">Insurer email (50 characters)</td> | <td 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 align="center">Insurer phone (50 characters)</td> | <td 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 align="center">Insurer fax (50 characters)</td> | <td 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 align="center"><span>Insurer country (numeric code of a country)</span> | <td align="center"><span>Insurer country (numeric code of a country)</span> | ||
<table border="0"> | <table border="0"> | ||
| Line 50: | Line 58: | ||
<tr> | <tr> | ||
<td align="center">8.</td> | <td align="center">8.</td> | ||
| + | <td align="center">IN_CLINIC_ID_NUMBER</td> | ||
<td align="center">Insurer clinic ID number (defined by clinic itself)</td> | <td 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_INSSURANCE</td> | ||
<td align="center">Insurer / Funder (1 = insurer, 0 = funder)</td> | <td 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 align="center">E-claim billing (1 = yes, 0 = no) </td> | <td align="center">E-claim billing (1 = yes, 0 = no) </td> | ||
</tr> | </tr> | ||
| Line 63: | Line 74: | ||
</table> | </table> | ||
<p style="text-align: center;"> </p> | <p style="text-align: center;"> </p> | ||
| − | <p> An example can be downloaded from the link below. This document contains Insurence information about one insurer from Brazil (numeric code for this country is "25") that is in E-claims.</p> | + | <table style="margin-left: auto; margin-right: auto;" border="0"> |
| + | <tbody> | ||
| + | <tr> | ||
| + | <td><img src="/images/hint48.png" alt="" width="48" height="48" /></td> | ||
| + | <td> | ||
| + | <ul> | ||
| + | <li>Not all fields are required</li> | ||
| + | <li>Required fields are:</li> | ||
| + | </ul> | ||
| + | </td> | ||
| + | </tr> | ||
| + | </tbody> | ||
| + | </table> | ||
| + | <p style="text-align: center;"> </p> | ||
| + | <p>An example of this file can be downloaded from the link below. This document contains Insurence information about one insurer from Brazil (numeric code for this country is "25") that is in E-claims.</p> | ||
<table style="margin-left: auto; margin-right: auto;" border="0"> | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
<tbody> | <tbody> | ||
Revision as of 15:26, 10 June 2014
This page contains additional importing features supported by MedITEX.
Insurance information Import
File format used for importing Insurance information is Excel.
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)
|
||
| 8. | IN_CLINIC_ID_NUMBER | Insurer clinic ID number (defined by clinic itself) | ||
| 9. | IN_IS_INSSURANCE | Insurer / Funder (1 = insurer, 0 = funder) | ||
| 10. | IN_IS_ECLAIM_BILLING | E-claim billing (1 = yes, 0 = no) |
| <img src="/images/hint48.png" alt="" width="48" height="48" /> |
|
An example of this file can be downloaded from the link below. This document contains Insurence information about one insurer from Brazil (numeric code for this country is "25") that is in E-claims.
| <img src="/images/plus48.png" alt="" width="48" height="48" /> | <a href="/images/Insurance.xls">Insurance information import file.</a> |
|
<a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a> |
<a href="#top">Back to top</a> |