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="339" height="2507">
+
 
<tbody>
+
TABEL HERE
<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;START</td>
+
<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;">Nam <span class="SpellE">of</span> <span class="SpellE">field</span> (<span class="SpellE">Program</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: 0.0001pt; line-height: normal; text-align: left;"><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> (Database)</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;">Data type</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 1; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">1.</span></p>
+
</td>
+
<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;">Patient ID</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;">PATIENT_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;">VARCHAR(64)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 2; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">2.</span></p>
+
</td>
+
<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;">Anonymous ID</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;">ANONYM_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;">VARCHAR(100)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 3; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">3.</span></p>
+
</td>
+
<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;">Location</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;">STANDORT_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 style="mso-yfti-irow: 4; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">4.</span></p>
+
</td>
+
<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;">Title</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;">TITEL</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 style="mso-yfti-irow: 5; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">5.</span></p>
+
</td>
+
<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;">First <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;">VORNAME</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(100)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 6; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">6.</span></p>
+
</td>
+
<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 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;">Surname</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;">&nbsp;</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;">NACHNAME</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(100)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 7; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">7.</span></p>
+
</td>
+
<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 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;">Surname</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;"> at <span class="SpellE">birth</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;">GEBURTSNAME</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 8; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">8.</span></p>
+
</td>
+
<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 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;">Marital</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">status</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;">KV_FAMILIENSTAND</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(20)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 9; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">9.</span></p>
+
</td>
+
<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;">Date <span class="SpellE">of</span> <span class="SpellE">birth</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;">GEBURTSDATUM</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;">DATE</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 10; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">10.</span></p>
+
</td>
+
<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;">Place <span class="SpellE">of</span> <span class="SpellE">birth</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;">GEBURTSORT</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 style="mso-yfti-irow: 11; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">11.</span></p>
+
</td>
+
<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 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;">Province</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">of</span> <span class="SpellE">birth</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;">GEBURTS_BEZIRK</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 style="mso-yfti-irow: 12; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">12.</span></p>
+
</td>
+
<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;">Region <span class="SpellE">of</span> <span class="SpellE">birth</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;">GEBURTS_REGION_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 style="mso-yfti-irow: 13; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">13.</span></p>
+
</td>
+
<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;">Country <span class="SpellE">of</span> <span class="SpellE">birth</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;">GEBURTS_LAND</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 style="mso-yfti-irow: 14; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">14.</span></p>
+
</td>
+
<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 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;">Nationality</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;">&nbsp;</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;">NATIONALITAET_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 style="mso-yfti-irow: 15; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">15.</span></p>
+
</td>
+
<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;">Mother <span class="SpellE">tongue</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_MUTTERSPRACHE</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 style="mso-yfti-irow: 16; height: 16.5pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 16.5pt;" width="25" valign="bottom">
+
<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;">16.</span></p>
+
</td>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 16.5pt;" 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;">Note</span></p>
+
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 16.5pt;" 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;">NOTE</span></p>
+
</td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 16.5pt;" 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 style="mso-yfti-irow: 17; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">17.</span></p>
+
</td>
+
<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;">VIP Patient</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;">VIP</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 style="mso-yfti-irow: 18; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">18.</span></p>
+
</td>
+
<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;">Person <span class="SpellE">with</span> <span class="SpellE">disability</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;">BEHINDERT</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 style="mso-yfti-irow: 19; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">19.</span></p>
+
</td>
+
<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;">Identity <span class="SpellE">card</span> ID</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;">PERS_NR</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(20)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 20; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">20.</span></p>
+
</td>
+
<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;">Country <span class="SpellE">of</span> <span class="SpellE">issue</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;">AUSWEIS_LAND</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 style="mso-yfti-irow: 21; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">21.</span></p>
+
</td>
+
<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;">Emirates ID</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_SOCIAL_SECURITY_NO</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 22; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">22.</span></p>
+
</td>
+
<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 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;">Tax</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">code</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_TAX_CODE</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 style="mso-yfti-irow: 23; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">23.</span></p>
+
</td>
+
<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 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;">From</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">abroad</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;">AUSLAND</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 style="mso-yfti-irow: 24; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">24.</span></p>
+
</td>
+
<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;">Street / <span class="SpellE">no</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;">STRASSE</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(255)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 25; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">25.</span></p>
+
</td>
+
<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 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;">Address</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">supplement</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_ADDRESS_SUPPLEMENT</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(128)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 26; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">26.</span></p>
+
</td>
+
<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;">Post <span class="SpellE">code</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;">PLZ</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 style="mso-yfti-irow: 27; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">27.</span></p>
+
</td>
+
<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 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;">Province</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 style="mso-spacerun: yes;">&nbsp; </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_ADDRESS_PROVINCE_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 style="mso-yfti-irow: 28; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">28.</span></p>
+
</td>
+
<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;">Region<span style="mso-spacerun: yes;">&nbsp; </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;">REGION_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 style="mso-yfti-irow: 29; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">29.</span></p>
+
</td>
+
<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;">Country<span style="mso-spacerun: yes;">&nbsp; </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;">LAND</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(100)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 30; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">30.</span></p>
+
</td>
+
<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;">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_PRIVAT</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 style="mso-yfti-irow: 31; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">31.</span></p>
+
</td>
+
<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;">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_PRIVAT</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 style="mso-yfti-irow: 32; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">32.</span></p>
+
</td>
+
<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;">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_PRIVAT</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 style="mso-yfti-irow: 33; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">33.</span></p>
+
</td>
+
<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;">E-Mail</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;">EMAIL</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(100)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 34; height: 21.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 21.75pt;" width="25" valign="bottom">
+
<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;">34.</span></p>
+
</td>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 21.75pt;" width="247">
+
<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;">Patient's</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">information</span> <span class="SpellE">source</span></span></p>
+
</td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 21.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;">INFORMATION_FROM_ID</span></p>
+
</td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 21.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 style="mso-yfti-irow: 35; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">35.</span></p>
+
</td>
+
<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 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;">Patient's</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">information</span> <span class="SpellE">source</span>: <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;">INFORMATION_FROM_NOTE</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 style="mso-yfti-irow: 36; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">36.</span></p>
+
</td>
+
<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 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;">Billing</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">category</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;">ABRECHNUNGSART</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 style="mso-yfti-irow: 37; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">37.</span></p>
+
</td>
+
<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;">Main <span class="SpellE">invoice</span> <span class="SpellE">receiver</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_MAIN_INVOICE_RECEIVER_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 style="mso-yfti-irow: 38; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">38.</span></p>
+
</td>
+
<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;">Co-<span class="SpellE">payment</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_INSURANCE_COPAYMENT</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 39; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">39.</span></p>
+
</td>
+
<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;">Accounting ID</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_ACCOUNTING_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;">VARCHAR(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 40; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">40.</span></p>
+
</td>
+
<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 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;">For</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">external</span> <span class="SpellE">services</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_EXTERN_INVOICE_RECEIVER_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 style="mso-yfti-irow: 41; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">41.</span></p>
+
</td>
+
<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;">Heath <span class="SpellE">insurance</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;">PE_INSURER_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 style="mso-yfti-irow: 42; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">42.</span></p>
+
</td>
+
<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 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;">Policy</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">group</span> <span class="SpellE">number</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;">KV_VERSICHERUNGS_NR</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 43; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">43.</span></p>
+
</td>
+
<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 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;">Policy</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">group</span> <span class="SpellE">number</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_INSURANCE1_POLICY_GROUP_NO</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 44; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">44.</span></p>
+
</td>
+
<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;">Card <span class="SpellE">category</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_INSURANCE1_CARD_CATEGORY</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 45; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">45.</span></p>
+
</td>
+
<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;">Insurance <span class="SpellE">status</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;">KV_STATUS</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(20)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 46; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">46.</span></p>
+
</td>
+
<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 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;">Policy</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">start</span> <span class="SpellE">date</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;">KV_DT_EINLESEN</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;">TIMESTAMP</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 47; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">47.</span></p>
+
</td>
+
<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 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;">Policy</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">expiry</span> <span class="SpellE">date</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;">KV_GUELTIG_BIS</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;">TIMESTAMP</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 48; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">48.</span></p>
+
</td>
+
<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;">Heath <span class="SpellE">insurance</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_INSURER2_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 style="mso-yfti-irow: 49; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">49.</span></p>
+
</td>
+
<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 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;">Policy</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">group</span> <span class="SpellE">number</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_INSURANCE2_POLICY_NO</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 50; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">50.</span></p>
+
</td>
+
<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 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;">Policy</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">group</span> <span class="SpellE">number</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_INSURANCE2_POLICY_GROUP_NO</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 51; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">51.</span></p>
+
</td>
+
<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;">Card <span class="SpellE">category</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_INSURANCE2_CARD_CATEGORY</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 52; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">52.</span></p>
+
</td>
+
<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;">Insurance <span class="SpellE">status</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_INSURANCE2_STATUS</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 53; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">53.</span></p>
+
</td>
+
<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 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;">Policy</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">start</span> <span class="SpellE">date</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_INSURANCE2_START_DT</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;">TIMESTAMP</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 54; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">54.</span></p>
+
</td>
+
<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 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;">Policy</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">expiry</span> <span class="SpellE">date</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_INSURANCE2_EXPIRY_DT</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;">TIMESTAMP</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 55; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">55.</span></p>
+
</td>
+
<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 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;">Oranisation</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">institution</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_SPONSOR_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 style="mso-yfti-irow: 56; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">56.</span></p>
+
</td>
+
<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 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;">Number</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;">&nbsp;</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_SPONSORING_NO</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(30)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 57; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">57.</span></p>
+
</td>
+
<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;">Status</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_SPONSORING_STATUS</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 style="mso-yfti-irow: 58; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">58.</span></p>
+
</td>
+
<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;">Valid form</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_SPONSORING_DT_VALID_FROM</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;">TIMESTAMP</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 59; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">59.</span></p>
+
</td>
+
<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;">Valid <span class="SpellE">until</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_SPONSORING_DT_VALID_UNTIL</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;">TIMESTAMP</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 60; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">60.</span></p>
+
</td>
+
<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 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;">Sort</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">code</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;">BV_BLZ</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 style="mso-yfti-irow: 61; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">61.</span></p>
+
</td>
+
<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;">Bank</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;">BV_BANK</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(128)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 62; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">62.</span></p>
+
</td>
+
<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;">Account <span class="SpellE">number</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;">BV_KONTONUMMER</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(20)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 63; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">63.</span></p>
+
</td>
+
<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 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;">Employed</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">occupied</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_IS_WORKING</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 style="mso-yfti-irow: 64; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">64.</span></p>
+
</td>
+
<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 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;">Occupation</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;">&nbsp;</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;">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 style="mso-yfti-irow: 65; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">65.</span></p>
+
</td>
+
<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;">Supplement</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;">BERUFSZUSATZ</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(100)</span></p>
+
</td>
+
</tr>
+
<tr style="mso-yfti-irow: 66; height: 15.75pt;">
+
<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+
<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;">66.</span></p>
+
</td>
+
<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 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;">&nbsp;</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;">ARBEITGEBER</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(100)</span></p>
+
</td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+
</tr>
+
<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>
+
<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+
<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+
<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">END</td>
+
</tr>
+
</tbody>
+
</table>
+
 
<table style="float: right;" border="0">
 
<table style="float: right;" border="0">
 
<tbody>
 
<tbody>

Revision as of 17:14, 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.

TABEL HERE

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