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 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 class="MsoNormalTable" style="width: 627.0pt; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 3.5pt 0cm 3.5pt;" border="0" cellspacing="0" cellpadding="0" width="704" height="2160">
+
<table class="MsoNormalTable" style="width: 627.0pt; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 3.5pt 0cm 3.5pt;" border="0" cellspacing="0" cellpadding="0" width="339" height="2507">
 
<tbody>
 
<tbody>
 
<tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">&nbsp;</td>
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">&nbsp;START</td>
 
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
 
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Name <span class="SpellE">of</span> <span class="SpellE">field</span> (<span class="SpellE">Program</span>)</span></p>
+
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Nam <span class="SpellE">of</span> <span class="SpellE">field</span> (<span class="SpellE">Program</span>)</span></p>
 
</td>
 
</td>
 
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
 
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
Line 1,040: Line 1,040:
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 67; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 67; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">67.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Phone</span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">TEL_BERUF</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">VARCHAR(50)</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 68; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 68; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">68.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Mobile</span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">MOBIL_BERUF</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">VARCHAR(50)</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 69; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 69; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">69.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Fax</span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">FAX_BERUF</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">VARCHAR(50)</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 70; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 70; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">70.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span class="SpellE"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Employer</span></span><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;"> <span class="SpellE">note</span></span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">ARBEITGEBERNOTES</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">BLOB SUB_TYPE 1 SEGMENT SIZE 80</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 71; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 71; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">71.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span class="SpellE"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Referrer</span></span><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;"> 1</span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">ZUWEISER_1_ID</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">INTEGER</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 72; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 72; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">72.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span class="SpellE"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Notification</span></span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Z1_BENACHRICHTIGUNG</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">SMALLINT</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 73; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 73; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">73.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span class="SpellE"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Referrer</span></span><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;"> 2</span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">ZUWEISER_2_ID</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">INTEGER</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 74; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 74; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">74.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span class="SpellE"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Notification</span></span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Z2_BENACHRICHTIGUNG</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">SMALLINT</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 75; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 75; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">75.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span class="SpellE"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Referrer</span></span><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;"> 3</span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">ZUWEISER_3_ID</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">INTEGER</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 76; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 76; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">76.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span class="SpellE"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Notification</span></span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Z3_BENACHRICHTIGUNG</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">SMALLINT</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 77; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 77; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">77.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Patient <span class="SpellE">uses</span> <span class="SpellE">the</span> web <span class="SpellE">portal</span></span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_WEBPORTAL_ISUSER</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">SMALLINT</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 78; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 78; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">78.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Account <span class="SpellE">is</span> <span class="SpellE">used</span> <span class="SpellE">together</span> <span class="SpellE">with</span> a <span class="SpellE">partner</span></span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_WEBPORTAL_PARTNERZUGANG</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">SMALLINT</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
<tr style="mso-yfti-irow: 79; mso-yfti-lastrow: yes; height: 15.75pt;">
 
<tr style="mso-yfti-irow: 79; mso-yfti-lastrow: yes; height: 15.75pt;">
−
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">79.</span></p>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
−
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
−
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">END</td>
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">User <span class="SpellE">name</span></span></p>
+
−
</td>
+
−
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_WEBPORTAL_USERNAME</span></p>
+
−
</td>
+
−
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+
−
<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">VARCHAR(32)</span></p>
+
−
</td>
+
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>

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

<tbody> </tbody>
 START

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