More Importing Features
From MedITEX - Wiki
(Difference between revisions)
| Line 86: | 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 101: | Line 101: | ||
<h2>Demographics Import</h2> | <h2>Demographics Import</h2> | ||
<p>It is possible to import patient data by providing a spreadsheet with the information described on this section.</p> | <p>It is possible to import patient data by providing a spreadsheet with the information described on this section.</p> | ||
| − | <table | + | <table border="0" cellspacing="0" cellpadding="0"> |
<tbody> | <tbody> | ||
<tr> | <tr> | ||
<td width="25" valign="bottom"> </td> | <td width="25" valign="bottom"> </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
| − | <p><strong>Name of field (Program)</strong></p> | + | <p style="text-align: left;"><strong>Name of field (Program)</strong></p> |
</td> | </td> | ||
<td width="233" valign="bottom"> | <td width="233" valign="bottom"> | ||
| Line 119: | Line 119: | ||
<p>1.</p> | <p>1.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Patient ID</p> | <p>Patient ID</p> | ||
</td> | </td> | ||
| Line 133: | Line 133: | ||
<p>2.</p> | <p>2.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Anonymous ID</p> | <p>Anonymous ID</p> | ||
</td> | </td> | ||
| Line 147: | Line 147: | ||
<p>3.</p> | <p>3.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Location</p> | <p>Location</p> | ||
</td> | </td> | ||
| Line 161: | Line 161: | ||
<p>4.</p> | <p>4.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Title</p> | <p>Title</p> | ||
</td> | </td> | ||
| Line 175: | Line 175: | ||
<p>5.</p> | <p>5.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>First name</p> | <p>First name</p> | ||
</td> | </td> | ||
| Line 189: | Line 189: | ||
<p>6.</p> | <p>6.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Surname</p> | <p>Surname</p> | ||
</td> | </td> | ||
| Line 203: | Line 203: | ||
<p>7.</p> | <p>7.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Surname at birth</p> | <p>Surname at birth</p> | ||
</td> | </td> | ||
| Line 217: | Line 217: | ||
<p>8.</p> | <p>8.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Marital status</p> | <p>Marital status</p> | ||
</td> | </td> | ||
| Line 231: | Line 231: | ||
<p>9.</p> | <p>9.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Date of birth</p> | <p>Date of birth</p> | ||
</td> | </td> | ||
| Line 245: | Line 245: | ||
<p>10.</p> | <p>10.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Place of birth</p> | <p>Place of birth</p> | ||
</td> | </td> | ||
| Line 259: | Line 259: | ||
<p>11.</p> | <p>11.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Province of birth</p> | <p>Province of birth</p> | ||
</td> | </td> | ||
| Line 273: | Line 273: | ||
<p>12.</p> | <p>12.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Region of birth</p> | <p>Region of birth</p> | ||
</td> | </td> | ||
| Line 287: | Line 287: | ||
<p>13.</p> | <p>13.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Country of birth</p> | <p>Country of birth</p> | ||
</td> | </td> | ||
| Line 301: | Line 301: | ||
<p>14.</p> | <p>14.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Nationality</p> | <p>Nationality</p> | ||
</td> | </td> | ||
| Line 315: | Line 315: | ||
<p>15.</p> | <p>15.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Mother tongue</p> | <p>Mother tongue</p> | ||
</td> | </td> | ||
| Line 329: | Line 329: | ||
<p>16.</p> | <p>16.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Note</p> | <p>Note</p> | ||
</td> | </td> | ||
| Line 343: | Line 343: | ||
<p>17.</p> | <p>17.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>VIP Patient</p> | <p>VIP Patient</p> | ||
</td> | </td> | ||
| Line 357: | Line 357: | ||
<p>18.</p> | <p>18.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Person with disability</p> | <p>Person with disability</p> | ||
</td> | </td> | ||
| Line 371: | Line 371: | ||
<p>19.</p> | <p>19.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Identity card ID</p> | <p>Identity card ID</p> | ||
</td> | </td> | ||
| Line 385: | Line 385: | ||
<p>20.</p> | <p>20.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Country of issue</p> | <p>Country of issue</p> | ||
</td> | </td> | ||
| Line 399: | Line 399: | ||
<p>21.</p> | <p>21.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Emirates ID</p> | <p>Emirates ID</p> | ||
</td> | </td> | ||
| Line 413: | Line 413: | ||
<p>22.</p> | <p>22.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Tax code</p> | <p>Tax code</p> | ||
</td> | </td> | ||
| Line 427: | Line 427: | ||
<p>23.</p> | <p>23.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>From abroad</p> | <p>From abroad</p> | ||
</td> | </td> | ||
| Line 441: | Line 441: | ||
<p>24.</p> | <p>24.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Street / no.</p> | <p>Street / no.</p> | ||
</td> | </td> | ||
| Line 455: | Line 455: | ||
<p>25.</p> | <p>25.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Address supplement</p> | <p>Address supplement</p> | ||
</td> | </td> | ||
| Line 469: | Line 469: | ||
<p>26.</p> | <p>26.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Post code</p> | <p>Post code</p> | ||
</td> | </td> | ||
| Line 483: | Line 483: | ||
<p>27.</p> | <p>27.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Province </p> | <p>Province </p> | ||
</td> | </td> | ||
| Line 497: | Line 497: | ||
<p>28.</p> | <p>28.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Region </p> | <p>Region </p> | ||
</td> | </td> | ||
| Line 511: | Line 511: | ||
<p>29.</p> | <p>29.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Country </p> | <p>Country </p> | ||
</td> | </td> | ||
| Line 525: | Line 525: | ||
<p>30.</p> | <p>30.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Phone</p> | <p>Phone</p> | ||
</td> | </td> | ||
| Line 539: | Line 539: | ||
<p>31.</p> | <p>31.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Mobile</p> | <p>Mobile</p> | ||
</td> | </td> | ||
| Line 553: | Line 553: | ||
<p>32.</p> | <p>32.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Fax</p> | <p>Fax</p> | ||
</td> | </td> | ||
| Line 567: | Line 567: | ||
<p>33.</p> | <p>33.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>E-Mail</p> | <p>E-Mail</p> | ||
</td> | </td> | ||
| Line 581: | Line 581: | ||
<p>34.</p> | <p>34.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Patient's information source</p> | <p>Patient's information source</p> | ||
</td> | </td> | ||
| Line 595: | Line 595: | ||
<p>35.</p> | <p>35.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Patient's information source: note</p> | <p>Patient's information source: note</p> | ||
</td> | </td> | ||
| Line 609: | Line 609: | ||
<p>36.</p> | <p>36.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Billing category</p> | <p>Billing category</p> | ||
</td> | </td> | ||
| Line 623: | Line 623: | ||
<p>37.</p> | <p>37.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Main invoice receiver</p> | <p>Main invoice receiver</p> | ||
</td> | </td> | ||
| Line 637: | Line 637: | ||
<p>38.</p> | <p>38.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Co-payment</p> | <p>Co-payment</p> | ||
</td> | </td> | ||
| Line 651: | Line 651: | ||
<p>39.</p> | <p>39.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Accounting ID</p> | <p>Accounting ID</p> | ||
</td> | </td> | ||
| Line 665: | Line 665: | ||
<p>40.</p> | <p>40.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>For external services</p> | <p>For external services</p> | ||
</td> | </td> | ||
| Line 679: | Line 679: | ||
<p>41.</p> | <p>41.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Heath insurance</p> | <p>Heath insurance</p> | ||
</td> | </td> | ||
| Line 693: | Line 693: | ||
<p>42.</p> | <p>42.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Policy group number</p> | <p>Policy group number</p> | ||
</td> | </td> | ||
| Line 707: | Line 707: | ||
<p>43.</p> | <p>43.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Policy group number</p> | <p>Policy group number</p> | ||
</td> | </td> | ||
| Line 721: | Line 721: | ||
<p>44.</p> | <p>44.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Card category</p> | <p>Card category</p> | ||
</td> | </td> | ||
| Line 735: | Line 735: | ||
<p>45.</p> | <p>45.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Insurance status</p> | <p>Insurance status</p> | ||
</td> | </td> | ||
| Line 749: | Line 749: | ||
<p>46.</p> | <p>46.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Policy start date</p> | <p>Policy start date</p> | ||
</td> | </td> | ||
| Line 763: | Line 763: | ||
<p>47.</p> | <p>47.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Policy expiry date</p> | <p>Policy expiry date</p> | ||
</td> | </td> | ||
| Line 777: | Line 777: | ||
<p>48.</p> | <p>48.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Heath insurance</p> | <p>Heath insurance</p> | ||
</td> | </td> | ||
| Line 791: | Line 791: | ||
<p>49.</p> | <p>49.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Policy group number</p> | <p>Policy group number</p> | ||
</td> | </td> | ||
| Line 805: | Line 805: | ||
<p>50.</p> | <p>50.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Policy group number</p> | <p>Policy group number</p> | ||
</td> | </td> | ||
| Line 819: | Line 819: | ||
<p>51.</p> | <p>51.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Card category</p> | <p>Card category</p> | ||
</td> | </td> | ||
| Line 833: | Line 833: | ||
<p>52.</p> | <p>52.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Insurance status</p> | <p>Insurance status</p> | ||
</td> | </td> | ||
| Line 847: | Line 847: | ||
<p>53.</p> | <p>53.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Policy start date</p> | <p>Policy start date</p> | ||
</td> | </td> | ||
| Line 861: | Line 861: | ||
<p>54.</p> | <p>54.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Policy expiry date</p> | <p>Policy expiry date</p> | ||
</td> | </td> | ||
| Line 875: | Line 875: | ||
<p>55.</p> | <p>55.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Oranisation / institution</p> | <p>Oranisation / institution</p> | ||
</td> | </td> | ||
| Line 889: | Line 889: | ||
<p>56.</p> | <p>56.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Number</p> | <p>Number</p> | ||
</td> | </td> | ||
| Line 903: | Line 903: | ||
<p>57.</p> | <p>57.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Status</p> | <p>Status</p> | ||
</td> | </td> | ||
| Line 917: | Line 917: | ||
<p>58.</p> | <p>58.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Valid form</p> | <p>Valid form</p> | ||
</td> | </td> | ||
| Line 931: | Line 931: | ||
<p>59.</p> | <p>59.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Valid until</p> | <p>Valid until</p> | ||
</td> | </td> | ||
| Line 945: | Line 945: | ||
<p>60.</p> | <p>60.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Sort code</p> | <p>Sort code</p> | ||
</td> | </td> | ||
| Line 959: | Line 959: | ||
<p>61.</p> | <p>61.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Bank</p> | <p>Bank</p> | ||
</td> | </td> | ||
| Line 973: | Line 973: | ||
<p>62.</p> | <p>62.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Account number</p> | <p>Account number</p> | ||
</td> | </td> | ||
| Line 987: | Line 987: | ||
<p>63.</p> | <p>63.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Employed / occupied</p> | <p>Employed / occupied</p> | ||
</td> | </td> | ||
| Line 1,001: | Line 1,001: | ||
<p>64.</p> | <p>64.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Occupation</p> | <p>Occupation</p> | ||
</td> | </td> | ||
| Line 1,015: | Line 1,015: | ||
<p>65.</p> | <p>65.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Supplement</p> | <p>Supplement</p> | ||
</td> | </td> | ||
| Line 1,029: | Line 1,029: | ||
<p>66.</p> | <p>66.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Employer</p> | <p>Employer</p> | ||
</td> | </td> | ||
| Line 1,043: | Line 1,043: | ||
<p>67.</p> | <p>67.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Phone</p> | <p>Phone</p> | ||
</td> | </td> | ||
| Line 1,057: | Line 1,057: | ||
<p>68.</p> | <p>68.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Mobile</p> | <p>Mobile</p> | ||
</td> | </td> | ||
| Line 1,071: | Line 1,071: | ||
<p>69.</p> | <p>69.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Fax</p> | <p>Fax</p> | ||
</td> | </td> | ||
| Line 1,085: | Line 1,085: | ||
<p>70.</p> | <p>70.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Employer note</p> | <p>Employer note</p> | ||
</td> | </td> | ||
| Line 1,099: | Line 1,099: | ||
<p>71.</p> | <p>71.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Referrer 1</p> | <p>Referrer 1</p> | ||
</td> | </td> | ||
| Line 1,113: | Line 1,113: | ||
<p>72.</p> | <p>72.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Notification</p> | <p>Notification</p> | ||
</td> | </td> | ||
| Line 1,127: | Line 1,127: | ||
<p>73.</p> | <p>73.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Referrer 2</p> | <p>Referrer 2</p> | ||
</td> | </td> | ||
| Line 1,141: | Line 1,141: | ||
<p>74.</p> | <p>74.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Notification</p> | <p>Notification</p> | ||
</td> | </td> | ||
| Line 1,155: | Line 1,155: | ||
<p>75.</p> | <p>75.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Referrer 3</p> | <p>Referrer 3</p> | ||
</td> | </td> | ||
| Line 1,169: | Line 1,169: | ||
<p>76.</p> | <p>76.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Notification</p> | <p>Notification</p> | ||
</td> | </td> | ||
| Line 1,183: | Line 1,183: | ||
<p>77.</p> | <p>77.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Patient uses the web portal</p> | <p>Patient uses the web portal</p> | ||
</td> | </td> | ||
| Line 1,197: | Line 1,197: | ||
<p>78.</p> | <p>78.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>Account is used together with a partner</p> | <p>Account is used together with a partner</p> | ||
</td> | </td> | ||
| Line 1,211: | Line 1,211: | ||
<p>79.</p> | <p>79.</p> | ||
</td> | </td> | ||
| − | <td | + | <td width="255" valign="bottom"> |
<p>User name</p> | <p>User name</p> | ||
</td> | </td> | ||
Revision as of 16:27, 1 October 2015
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.
| <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 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) |
| <img src="/images/hint129.png" alt="" width="129" height="129" /> |
|
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. |
|
|
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) |
|
<a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a> |
<a href="#top">Back to top</a> |