More Importing Features

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
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 102: Line 102:
 
<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>
  
−
TABEL HERE
+
<table border="0" cellspacing="0" cellpadding="0" width="736">
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p><strong>Name of field (Program)</strong></p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p><strong>Name of field (Database)</strong></p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p><strong>Data type</strong></p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>1.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Patient ID</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>PATIENT_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(64)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>2.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Anonymous ID</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>ANONYM_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(100)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>3.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Location</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>STANDORT_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>4.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Title</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>TITEL</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>5.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>First name</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>VORNAME</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(100)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>6.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Surname</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>NACHNAME</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(100)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>7.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Surname at birth</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>GEBURTSNAME</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>8.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Marital status</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>KV_FAMILIENSTAND</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(20)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>9.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Date of birth</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>GEBURTSDATUM</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>DATE</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>10.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Place of birth</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>GEBURTSORT</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>11.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Province of birth</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>GEBURTS_BEZIRK</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>12.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Region of birth</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>GEBURTS_REGION_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>13.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Country of birth</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>GEBURTS_LAND</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>14.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Nationality</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>NATIONALITAET_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>15.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Mother tongue</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_MUTTERSPRACHE</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>16.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Note</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>NOTE</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>BLOB SUB_TYPE 1    SEGMENT SIZE 80</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>17.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>VIP Patient</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>VIP</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>SMALLINT</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>18.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Person with    disability</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>BEHINDERT</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>SMALLINT</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>19.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Identity card ID</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>PERS_NR</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(20)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>20.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Country of issue</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>AUSWEIS_LAND</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>21.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Emirates ID</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_SOCIAL_SECURITY_NO</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>22.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Tax code</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_TAX_CODE</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>23.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>From abroad</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>AUSLAND</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>SMALLINT</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>24.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Street / no.</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>STRASSE</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(255)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>25.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Address supplement</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_ADDRESS_SUPPLEMENT</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(128)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>26.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Post code</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>PLZ</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>27.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Province  </p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_ADDRESS_PROVINCE_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>28.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Region  </p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>REGION_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>29.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Country  </p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>LAND</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(100)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>30.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Phone</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>TEL_PRIVAT</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>31.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Mobile</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>MOBIL_PRIVAT</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>32.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Fax</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>FAX_PRIVAT</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>33.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>E-Mail</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>EMAIL</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(100)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>34.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Patient's    information source</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>INFORMATION_FROM_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>35.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Patient's    information source: note</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>INFORMATION_FROM_NOTE</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>BLOB SUB_TYPE 1    SEGMENT SIZE 80</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>36.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Billing category</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>ABRECHNUNGSART</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>SMALLINT</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>37.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Main invoice    receiver</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_MAIN_INVOICE_RECEIVER_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>38.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Co-payment</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_INSURANCE_COPAYMENT</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>39.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Accounting ID</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_ACCOUNTING_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>40.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>For external services</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_EXTERN_INVOICE_RECEIVER_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>41.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Heath insurance</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>PE_INSURER_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>42.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Policy group number</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>KV_VERSICHERUNGS_NR</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>43.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Policy group number</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_INSURANCE1_POLICY_GROUP_NO</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>44.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Card category</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_INSURANCE1_CARD_CATEGORY</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>45.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Insurance status</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>KV_STATUS</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(20)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>46.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Policy start date</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>KV_DT_EINLESEN</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>TIMESTAMP</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>47.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Policy expiry date</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>KV_GUELTIG_BIS</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>TIMESTAMP</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>48.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Heath insurance</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_INSURER2_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>49.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Policy group number</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_INSURANCE2_POLICY_NO</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>50.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Policy group number</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_INSURANCE2_POLICY_GROUP_NO</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>51.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Card category</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_INSURANCE2_CARD_CATEGORY</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>52.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Insurance status</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_INSURANCE2_STATUS</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>53.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Policy start date</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_INSURANCE2_START_DT</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>TIMESTAMP</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>54.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Policy expiry date</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_INSURANCE2_EXPIRY_DT</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>TIMESTAMP</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>55.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Oranisation /    institution</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_SPONSOR_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>56.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Number</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_SPONSORING_NO</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(30)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>57.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Status</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_SPONSORING_STATUS</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>58.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Valid form</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_SPONSORING_DT_VALID_FROM</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>TIMESTAMP</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>59.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Valid until</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_SPONSORING_DT_VALID_UNTIL</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>TIMESTAMP</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>60.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Sort code</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>BV_BLZ</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>61.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Bank</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>BV_BANK</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(128)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>62.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Account number</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>BV_KONTONUMMER</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(20)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>63.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Employed / occupied</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_IS_WORKING</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>SMALLINT</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>64.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Occupation</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>BERUF</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>65.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Supplement</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>BERUFSZUSATZ</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(100)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>66.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Employer</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>ARBEITGEBER</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(100)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>67.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Phone</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>TEL_BERUF</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>68.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Mobile</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>MOBIL_BERUF</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>69.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Fax</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>FAX_BERUF</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(50)</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>70.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Employer note</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>ARBEITGEBERNOTES</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>BLOB SUB_TYPE 1    SEGMENT SIZE 80</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>71.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Referrer 1</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>ZUWEISER_1_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>72.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Notification</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>Z1_BENACHRICHTIGUNG</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>SMALLINT</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>73.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Referrer 2</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>ZUWEISER_2_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>74.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Notification</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>Z2_BENACHRICHTIGUNG</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>SMALLINT</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>75.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Referrer 3</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>ZUWEISER_3_ID</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>INTEGER</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>76.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Notification</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>Z3_BENACHRICHTIGUNG</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>SMALLINT</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>77.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Patient uses the    web portal</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_WEBPORTAL_ISUSER</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>SMALLINT</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>78.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>Account is used    together with a partner</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_WEBPORTAL_PARTNERZUGANG</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>SMALLINT</p></td>
 +
  </tr>
 +
  <tr>
 +
    <td width="25" nowrap="nowrap" valign="bottom"><p>79.</p></td>
 +
    <td width="255" nowrap="nowrap" valign="bottom"><p>User name</p></td>
 +
    <td width="233" nowrap="nowrap" valign="bottom"><p>P_WEBPORTAL_USERNAME</p></td>
 +
    <td width="223" nowrap="nowrap" valign="bottom"><p>VARCHAR(32)</p></td>
 +
  </tr>
 +
</table>
  
 
<table style="float: right;" border="0">
 
<table style="float: right;" border="0">

Revision as of 18:24, 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.

<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

 

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.

E-Mail

EMAIL

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)
<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>