More Importing Features

Latest revision as of 09:54, 22 August 2023

This page contains additional importing features supported by MedITEX.

Please plan enough time for the preparation of the data import as it usually takes several tries to bring all data in required structure.

Patient demographics import

You need to prepare an import file which is a list in Excel or CSV format where each line is ONE patient.

<a href="/images/Patient_Demographics.xls">Click here</a> to download an example of Patient demographics import file.

The following elements should be included in this file:

	Column name	Column content
1.	PATIENT_ID	Patient ID (64 characters)
2.	PARTNER_ID	Partner ID (64 characters)
3.	DOB	Patient date of birth (Date)
4.	NAME	Patient name (100 characters)
5.	FIRST_NAME	Patient first name (100 characters)
6.	GENDER	Patient gender (1 character - W/M)
7.	POSTCODE	Patient address: postal code (50 characters)
8.	CITY	Patient address: city (50 characters)
9.	STREET	Patient address: street (255 characters)
10.	PHONE	Patient private phone number (50 characters)
11.	LOCATION (CLINIC)	The clinic where the patient is located (250 characters)

Please make sure that your current Patient IDs from your existing data are unique.

Required fields are:

PATIENT ID
DOB
NAME
GENDER (W/M)
PARTNER ID (If couples should be linked)

Cryo storage import

It is mandatory to prepare an import file where each line is ONE straw.

<a href="/images/Cryo_Storage.xls">Click here</a> to download an example of Cryo storage import file.

Before importing, it is important to know that:

The cryo storage dimension must be configured in MedITEX IVF Settings;
Each line is one straw. If you have multiple straws for the same patient, these lines must be duplicated in the file.
The patient demographics must already be imported into the MedITEX Database;
Each line must contain the Patient ID, which is the identification for inserting the cryo information for the correct patient. Important is that Patient ID is unique like already mentioned above;
Type of semen material can be specified in: Native sperm, Prep. Sperm, Tissue, Tissue left, Tissue right, Tissue ambilateral, MESA, MESA left, MESA right, MESA ambilateral, Supernatant, Supernatant left, Supernatant right, Supernatant ambilateral, PESA, TESA, TESE.

The following elements/conditions should be included in the import file:

	Column name	Column content
1.	PATIENT ID	Patient ID number (64 characters)
2.	COLLECTION_DATE	Date of sperm collection/follicle aspiration (Date)
3.	FREEZING_DATE	Date of freezing (Date)
4.	STORAGE_DATE	Date of storage (Date)
5.	NO_OOCYTES	Total number of oocytes (Integer)
6.	IVF_PNs	Number of PNs after IVF (Integer)
7.	ICSI_PNs	Number of PNs after ICSI (Integer)
8.	IVF_EMBs	Number of embryos after IVF (Integer)
9.	ICSI_EMBs	Number of embryos after ICSI (Integer)
10.	OVARIAN_TISSUE	Ovarian tissue cryopreservation (OOC/EMB/PN) (0=No, 1=Yes)
11.	SEMEN_MATERIAL	Type of semen material specification (100 characters)
12.	STRAW_ID	Straw ID (50 characters)
13.	CRYO_TECHNIQUE	Cryo technique used (50 characters)
14.	STORAGE_LOCATION	Storage location description e.g. Container/Tank (128 characters)
15.	STORAGE_DIM1	Storage dimension e.g. Tank level (128 characters)
16.	STORAGE_DIM2	Storage dimension e.g. Canister level (128 characters)
17.	STORAGE_DIM3	Storage dimension e.g. Goblet level (128 characters)
18.	POSITION	Straw position (10 characters)
19.	COLOUR1	First color defining the straw (10 characters)
20.	COLOUR2	Second color defining the straw (10 characters)
21.	CRYOPRESERVED_BY	Staff responsible of the cryopreservation (100 characters)
22.	STORED_BY	Staff responsible of the storage (100 characters)
23.	CONTRACT_NO	Cryo contract number. Used to link the sample with a contract. See below. (100 characters)

Required fields are:

PATIENT_ID
COLLECTION_DATE
FREEZING_DATE
OVARIAN_TISSUE
TYPE_OF_SEMEN_MATERIAL

Cryo contracts

In the case a <a href="/index.php?title=How_to_create_a_new_cryo_contract%3F">cryo contract</a> needs to be imported for the samples, an additional file is required.

This file will contain the different contracts that are available for each patient. Samples are then linked with each contract, using field 23 from the sample specification above.

<a href="/images/Cryo_Contracts.xls">Click here</a> to download an example of Cryo contract import file.

The following elements/conditions should be included in the import file:

	Column name	Column content
1.	PATIENT ID	Patient ID number (64 characters)
2.	CONTRACT_NO	Number of the cryo contract (100 characters)
3.	CONTRACT_START	Date when contract starts (Date)
4.	CONTRACT_EXPIRY	Date when contract expires (Date)
5.	CONTRACT_NAME	Name of the contract (100 characters)
6.	CONTRACT_ACTIVE	If contract is still active or if it is terminated. 1 = Active, 0 = Terminated (Integer)
7.	CONTRACT_NEXT_INVOICE	Date of next invoice (Date)

Before this import can take place, Cryo contracts need to be configured in the system settings: <a href="/index.php?title=MedITEX_IVF_Settings#Cryo_contracts_and_accounting">click here</a> for more information.

Required fields are:

PATIENT_ID
CONTRACT_NO
CONTRACT_START
CONTRACT_NAME

Semen analyses import

An import file should be prepared as a list where each line will represent ONE complete semen analysis.

<a href="/images/Semen_Analysis_Import.xlsx">Click here</a> to download an example of Semen analysus import file.

Before importing, it is important to know that:

The patient demographics must already be imported into the MedITEX Database;
Each line must contain the Patient ID, which is the identification for inserting the semen analysis information for the correct patient. It is important to know that Patient ID must be unique;
The staff must be inserted in the system in order to properly assign them in the appropriate fields of the semen analysis.

The following elements/conditions could be included in the import file:

1.	PATIENT_ID	Patient ID number (Integer)
2.	SAMPLE_ID	Sample ID number (64 caracters)
3.	COLLECTION_DATE	Date of sperm collection (Date) Preferred format: dd.mm.yyyy hh:mm
4.	PURPOSE	Purpose of sample collection (128 characters) 0 = Semen analysis, diagnostics 1 = IVF 2 = ICSI 3 = Insemination 4 = Cryopreservation 5 = Control 6 = IMSI 7 = IVM 8 = Fertility preservation 9 = PICSI 11 = Other A sperm sample can have several collection purposes. If it is the case, the purposes’ ID’s should be separated by a “,”. E.g.: 0,3,8,11
5.	FOR_DONATION	If the sample is marked for donation (Boolean) 0 = No 1 = Yes
6.	COLLECTION_METHOD	Method of sample collection (Integer) 0 = Not specified 1 = antegrade ejaculation 2 = retrograde ejaculation 3 = Cryo sperm 4 = MESA 5 = frozen/thawed MESA 6 = PESA 7 = frozen/thawed PESA 8 = TESE 9 = frozen/thawed TESE 10 = Electrostimulation 11 = Spermatocele 12 = Donor 13 = TESA 14 = frozen/thawed TESA 15 = ESA 16 = frozen/thawed ESA 23 = Micro-TESA 24 = Micro-TESE Please note that only one ID referring to sample collection method should be chosen.
7.	COLLECTION_PLACE	Place of sample collection (Integer) 1 = At home 2 = At clinic
8.	COLLECTION_DIFFICULTIES	Sample collection difficulties (200 characters)
9.	ABS_PERIOD	Abstinence period [days] (Integer)
10.	ANALYSIS_START	Analysis start time (Time) Format: hh:mm:ss
11.	ANALYSED_BY	Username of the staff performing the sperm sample analysis (113 characters) These usernames must be inserted in the system from MedITEX Administration.
12.	APPEARANCE	Sperm sample appearance (128 characters) 0 = Not specified 1 = Normal 2 = Transparent 3 = Flocculent 4 = Yellowish 5 = Hemospermia 6 = Colloidal particles 7 = Colloidal plaque 8 = Debris A sperm sample can have several appearances. If it is the case, the appearances’ ID’s should be separated by a “,”. E.g.: 0,3,5,8
13.	SMELL	Sperm sample smell (Integer) 1 = Typical 2 = Foul 3 = Other
14.	VISCOSITY	Sperm sample viscosity (Integer) 0 = Normal 1 = Increased 2 = Lowered
15.	LIQQUEFACTION_TIME	Sperm sample liquefaction time [minutes] (Integer)
16.	AGGLUTINATION	Sperm agglutination (Boolean) 0 = No 1 = Yes
17.	TREATMENT	Sperm treatment (200 characters)
18.	SCORE	Sperm sample score (10 characters)
19.	NA_VOLUME	Native sperm sample volume in [ml] (Decimal(4,2))
20.	NA_PH	Native sperm sample PH (Decimal(4,2))
21.	NA_CONCENTRATION	Native sperm sample concentration [Mio/ml] (Decimal(5,3))
22.	NA_VITALITY	Native sperm sample vitality [%] (Decimal(5,2))
23.	NA_LEUCOCYTES	Native sperm sample leucocytes [Mio/ml] (Decimal(9,4))
24.	NA_ROUND_CELLS	Native sperm sample round cells [Mio/ml] (Decimal(9,2))
25.	NA_QUANTIFICATION	If native sperm sample quantification is possible (Integer) 1 = Yes 2 = No
26.	NA_PEROXIDASE	Native sperm sample peroxidase-positive cells [10^6/ml] (Decimal(5,2))
27.	NA_IMMUNOBEAD	Native sperm sample immunobead test [% adherent] (Decimal(5,2))
28.	NA_MAR	Native sperm sample MAR test [% adherent] (Decimal(5,2))
29.	NA_MAR_IGG	Native sperm sample MAR test - IgG [%] (Decimal(5,2))
30.	NA_MAR_IGA	Native sperm sample MAR test - IgA [%] (Decimal(5,2))
31.	NA_WHO_AB	Native sperm sample WHO AB [%] (Decimal(5,2))
32.	NA_WHO_C	Native sperm sample WHO C [%] (Decimal(5,2))
33.	NA_WHO_D	Native sperm sample WHO D [%] (Decimal(5,2))
34.	NA_NORMAL_FORMS	Native sperm sample normal forms [%] (Decimal(5,2))
35.	NA_HEAD_DEF	Native sperm sample head defects [%] (Decimal(5,2))
36.	NA_NECK_MID_DEF	Native sperm sample neck and midpiece defects [%] (Decimal(5,2))
37.	NA_TAIL_DEF	Native sperm sample tail defects [%] (Decimal(5,2))
38.	NA_ERC	Native sperm sample excess residual cytoplasm ERC [%] (Decimal(5,2))
39.	NA_MULT_DEF	Native sperm sample multiple defects [%] (Decimal(5,2))
40.	NA_TZI	Native sperm sample teratozoospermia index TZI (Decimal(5,2))
41.	AP_VOLUME	After preparation, sperm sample volume in [ml] (Decimal(4,2))
42.	AP_CONCENTRATION	After preparation, sperm sample concentration [Mio/ml] (Decimal(5,3))
43.	AP_VITALITY	After preparation, sperm sample vitality [%] (Decimal(5,2))
44.	AP_LEUCOCYTES	After preparation, sperm sample leucocytes [Mio/ml] (Decimal(9,4))
45.	AP_ROUND_CELLS	After preparation, sperm sample round cells [Mio/ml] (Decimal(9,2))
46.	AP_QUANTIFICATION	After preparation, if sperm sample quantification is possible (Integer) 0 = Not specified 1 = Yes 2 = No
47.	AP_ICSI	After preparation, if ICSI is possible (Integer) 0 = Not specified 1 = Yes 2 = No This should only be filled if the previous quantification was NOT* possible.*
48.	AP_PEROXIDASE	After preparation, sperm sample peroxidase-positive cells [10^6/ml] (Decimal(5,2))
49	AP_IMMUNOBEAD	After preparation, sperm sample immunobead test [% adherent] (Decimal(5,2))
50.	AP_MAR	After preparation, sperm sample MAR test [% adherent] (Decimal(5,2))
51.	AP_MAR_IGG	After preparation, sperm sample MAR test - IgG [%] (Decimal(5,2))
52.	AP_MAR_IGA	After preparation, sperm sample MAR test - IgA [%] (Decimal(5,2))
53.	AP_WHO_AB	After preparation, sperm sample WHO AB [%] (Decimal(5,2))
54.	AP_WHO_C	After preparation, sperm sample WHO C [%] (Decimal(5,2))
55.	AP_WHO_D	After preparation, sperm sample WHO D [%] (Decimal(5,2))
56.	AP_NORMAL_FORMS	After preparation, sperm sample normal forms [%] (Decimal(5,2))
57.	AP_HEAD_DEF	After preparation, sperm sample head defects [%] (Decimal(5,2))
58.	AP_NECK_MID_DEF	After preparation, sperm sample neck and midpiece defects [%] (Decimal(5,2))
59.	AP_TAIL_DEF	After preparation, sperm sample tail defects [%] (Decimal(5,2))
60.	AP_ERC	After preparation, sperm sample excess residual cytoplasm ERC [%] (Decimal(5,2))
61.	AP_MULT_DEF	After preparation, sperm sample multiple defects [%] (Decimal(5,2))
62.	AP_TZI	After preparation, sperm sample teratozoospermia index TZI (Decimal(5,2))
63.	PREP_DATE	Preparation date of the sperm sample (Date) Preferred format: dd.mm.yyyy hh:mm
64.	PREP_BY	Name of the staff performing the sperm sample analysis (113 characters) This will be properly imported once the staff members are inserted in the system.
65.	PREP_METHOD	Preparation method of the sperm sample (Integer) 1 = None 2 = Density gradient 3 = Swim-up 4 = Wash / centrifugation 5 = Incubation 6 = Glass wool filtration 7 = Migration / sedimentation 8 = Concentration 9 = Unknown 10 = Other 11 = Mechanical 12 = Enzymatical 13 = Density gradient plus swim-up 14 = Pellet resuspended 15 = MACS A maximum of 4 methods can be allowed. In case of more than 1 method, the methods’ ID’s should be separated by a “,”. E.g.: 1,3,5,8
66.	DNA_FRAG	Sperm sample DNA fragmented [%] (Decimal(5,2))
67.	DIAGNOSIS	Sperm sample diagnosis (128 characters) 1 = Normozoospermia 2 = Aspermia 3 = Azoospermia 4 = Azoospermia obstructive 5 = Azoospermia not obstructive 6 = Oligozoospermia 7 = Asthenozoospermia 8 = Teratozoospermia 9= Hyperzoospermia 10 = OAT I 11 = OAT II 12 = OAT III 13 = Cryptozoospermia 14 = Viskopathy 15 = Necrozoospermia 16 = Globozoospermia 17 = Hypospermia 18 = Haematospermia 19 = Pyospermia 20 = Other 21 = Dispermia lieve 22 = Dispermia moderata 23 = Dispermia severa 24 = Necrospermia 25 = Eiaculazione Retrogada 26 = Aneiaculazione 27 = Anorgasmia 28 = Polyzoospermia 34 = Hyperspermia A sperm sample can have several diagnoses. If it is the case, the diagnoses ID’s should be separated by a “,”. E.g.: 1,3,10,18
68.	FINDING	Sperm sample diagnosis finding status (Integer) 1 = Normal 2 = Abnormal
69.	TIME_COLL_USAGE	Time between sperm sample collection and usage (Time) Format: hh:mm:ss
70.	NO_MOT_SPERM_INSEM	Number of motile sperms inseminated [Mio.] (Decimal(9,2))
71.	NOTE	Semen analysis note (500 characters)
72.	VOL_INSEM	Volume inseminated [ml] (Decimal(9,3))
73.	24H_MOT	Sperm sample 24h motility rate[%](Decimal(5,2))

Mandatory fields are:

PATIENT ID
SAMPLE_ID
COLLECTION_DATE

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.

<a href="/images/Insurance.xls">Click here</a> to download an example of Insurance information import file.

The structure of this file is described in the table below:

	Column name	Column content
1.	IN_NAME	Insurer name (50 characters)
2.	IN_INSURER_NO	Insurer number (30 characters)
3.	IN_ADDRESS	Insurer address (255 characters)
4.	IN_EMAIL	Insurer email (50 characters)
5.	IN_PHONE	Insurer phone (50 characters)
6.	IN_FAX	Insurer fax (50 characters)
7.	IN_COUNTRY	Insurer country (numeric code related to the country) The list of countries and corresponding codes can be <a href="/images/Countries.xls">downloaded here</a>
8.	IN_CLINIC_ID_NUMBER	Insurer clinic ID number (defined by the clinic itself)
9.	IN_IS_INSURANCE	Insurer / Funder (1 = insurer, 0 = funder)
10.	IN_IS_ECLAIM_BILLING	E-claim billing (1 = yes, 0 = no)

Not all fields are required;
Required fields are:
- IN_NAME
- IN_INSURER_NO

Referrers Import

An import file which is a list in Excel or CSV format where each line is ONE referrer should be preparred for this purpose.

<a href="/images/ReferrersImport.xlsx">Click here</a> to download an example of Referrers import file.

The structure of this file is described in the table below:

	Column name	Column content
1.	SURNAME	Referrer surname (50 characters)
2.	FIRSTNAME	Referrer first name (50 characters)
3.	TITLE	Referrer title (20 characters)
4.	DOB	Referrer date of birth (Date) Preferred format: dd.mm.yyyy
5.	SPECIALISATION	Referrer specialisation (265 characters)
6.	SALUTATION_AS	Referrer salutation as (Integer) 1: GP 2: JP 3: Male doctor 4: Female doctor 5: MCC
7.	STREET	Referrer address: street and no. (100 characters)
8.	POSTCODE	Referrer address: postcode (8 characters)
9.	CITY	Referrer address: city (50 characters)
10.	PHONE	Referrer phone number (40 characters)
11.	FAX	Referrer fax (40 characters)
12.	EMAIL	Referrer email (100 characters)
13.	REFERRER_CODE	Referrer code (30 characters)
14.	NOTE	Referrer note (500 characters)
15.	ADDRESS_SALUTATION	Referrer salutations of address (200 characters)
16.	LETTER_SALUTATION	Referrer salutations for letter (200 characters)
17.	REFERRER_CLINIC_NAME	Referrer clinic name (100 characters)
18.	REFERRER_CLINIC_CODE	Referrer clinic code (25 characters)

Not all fields are required;
Mandatory fields are:
- SURNAME
- FIRSTNAME
- REFERRER_CODE

Historical Notes Import

An import file which is a list in Excel or CSV format where each line is ONE historical note should be preparred for this purpose.

<a href="/images/History_Notes.xls">Click here</a> to download an example of Referrers import file.

The following elements should be included in this file:

	Column name	Column content
1.	PATIENT_ID	Patient ID (64 characters)
2.	START	Start date (Date)
3.	END	End date (Date)
4.	BY	Username of the staff member that should be linked (31 characters)
5.	STATUS	Status (Integer) 0 or emtpy = No status 1 = Normal 2 = Abnormal
6.	ALERT	Alert (Integer) An entry set as Alert will pop-up when the patient is opened. 0 or emtpy = Not an alert 1 = Alert
7.	CONFIDENTIAL	Confidential (Integer) An entry set as Confidential can only be visible/editable by staff that have access to seeing confidential entries. This setting is set by administrators per user. 0 or emtpy = Not confidential 1 = Confidential Confidential entries can ONLY be set for AREA = 9.
8.	AREA	Area where the historical note is visible (Integer) 9 = Medical history section 10 = Demographics section 11 = Examinations section
9.	NAME	Name of the entry related with the AREA above (50 characters)
10.	NOTE	Text that should be displayed in this note. (unlimited)
11.	APPROVAL	Approval status (Integer) Emtpy = no status 0 = Attention 1 = Approved
12.	ATTENTION	Username of the staff member that should be linked as attention (31 characters) Can be emtpy, but should only be filled when APPROVAL = 0.
13.	COMMENT	Text that can be inserted as part of the approval (255 characters)

Not all fields are required;
Mandatory fields are:
- PATIENT_ID
- START
- AREA
- NAME

<a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a>

More Importing Features

From MedITEX - Wiki

Latest revision as of 09:54, 22 August 2023

Contents

Patient demographics import

Cryo storage import

Cryo contracts

Semen analyses import

Insurance Import

Referrers Import

Historical Notes Import

@@ Line 1: / Line 1: @@
+<p>&nbsp;</p>
 <p>This page contains additional importing features supported by <strong>MedITEX</strong>.</p>
+<p>Please plan enough time for the preparation of the data import as it  usually takes several tries to bring all data in required structure.</p>
 <p>&nbsp;</p>
-<h2>Insurance Import</h2>
+<h2>Patient demographics import</h2>
-<p>It is possible to import insurance companies by providing a spreadsheet with the information described on this section.</p>
+<p>You need to prepare an import file which is a list in Excel or CSV format where each line is ONE patient.</p>
-<p>An example of this file can be downloaded from the link below. This document contains the insurance information about one insurer.</p>
 <table style="margin-left: auto; margin-right: auto;" border="0">
 <tbody>
@@ Line 9: / Line 10: @@
 <td><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
 <td>
-<p><a href="/images/Insurance.xls">Click here</a>&nbsp;to download an example of&nbsp;Insurance information import file.</p>
+<p><a href="/images/Patient_Demographics.xls">Click here</a>&nbsp;to download an example of Patient demographics import file.</p>
 </td>
 </tr>
@@ Line 15: / Line 16: @@
 </table>
 <p>&nbsp;</p>
-<p>The structure of this file is described in the table below:&nbsp;</p>
+<p>The following elements should be included in this file:</p>
 <table style="margin-left: auto; margin-right: auto;" border="0">
 <tbody>
@@ Line 25: / Line 26: @@
 <tr>
 <td align="center">1.</td>
-<td style="text-align: left;" align="center">IN_NAME</td>
+<td style="text-align: left;" align="center">PATIENT_ID<br /></td>
-<td style="text-align: left;" align="center">Insurer name (50 characters)</td>
+<td style="text-align: left;" align="center">Patient ID (64 characters)</td>
 </tr>
 <tr>
 <td align="center">2.</td>
-<td style="text-align: left;" align="center">IN_INSURER_NO</td>
+<td style="text-align: left;" align="center">PARTNER_ID<br /></td>
-<td style="text-align: left;" align="center">Insurer number (30 characters)</td>
+<td style="text-align: left;" align="center">Partner ID (64 characters)</td>
 </tr>
 <tr>
 <td align="center">3.</td>
-<td style="text-align: left;" align="center">IN_ADDRESS</td>
+<td style="text-align: left;" align="center">DOB</td>
-<td style="text-align: left;" align="center">Insurer address (255 characters)</td>
+<td style="text-align: left;" align="center">Patient date of birth (Date)</td>
 </tr>
 <tr>
 <td align="center">4.</td>
-<td style="text-align: left;" align="center">IN_EMAIL</td>
+<td style="text-align: left;" align="center">NAME</td>
-<td style="text-align: left;" align="center">Insurer email (50 characters)</td>
+<td style="text-align: left;" align="center">Patient name (100 characters)</td>
 </tr>
 <tr>
 <td align="center">5.</td>
-<td style="text-align: left;" align="center">IN_PHONE</td>
+<td style="text-align: left;" align="center">FIRST_NAME<br /></td>
-<td style="text-align: left;" align="center">Insurer phone (50 characters)</td>
+<td style="text-align: left;" align="center">Patient first name (100 characters)</td>
 </tr>
 <tr>
 <td align="center">6.</td>
-<td style="text-align: left;" align="center">IN_FAX</td>
+<td style="text-align: left;" align="center">GENDER</td>
-<td style="text-align: left;" align="center">Insurer fax (50 characters)</td>
+<td style="text-align: left;" align="center">Patient gender (1 character - W/M)</td>
 </tr>
 <tr>
 <td align="center">7.</td>
-<td style="text-align: left;" align="center">IN_COUNTRY</td>
+<td style="text-align: left;" align="center">POSTCODE</td>
-<td style="text-align: left;" align="center">
+<td style="text-align: left;" align="center">Patient address: postal code (50 characters)<br /></td>
-<p><span>Insurer country (numeric code related to the country)</span></p>
-<p>The list of countries and corresponding codes&nbsp;can be <a href="/images/Countries.xls">downloaded here</a></p>
-</td>
 </tr>
 <tr>
 <td align="center">8.</td>
-<td style="text-align: left;" align="center">IN_CLINIC_ID_NUMBER</td>
+<td style="text-align: left;" align="center">CITY</td>
-<td style="text-align: left;" align="center">Insurer clinic ID number (defined by the clinic itself)</td>
+<td style="text-align: left;" align="center">Patient address: city (50 characters)<br /></td>
 </tr>
 <tr>
 <td align="center">9.</td>
-<td style="text-align: left;" align="center">IN_IS_INSURANCE</td>
+<td style="text-align: left;" align="center">STREET<br /></td>
-<td style="text-align: left;" align="center">Insurer / Funder (1 = insurer, 0 = funder)</td>
+<td style="text-align: left;" align="center">Patient address: street (255 characters)</td>
 </tr>
 <tr>
 <td align="center">10.</td>
-<td style="text-align: left;" align="center">IN_IS_ECLAIM_BILLING</td>
+<td style="text-align: left;" align="center">PHONE</td>
-<td style="text-align: left;" align="center">E-claim billing (1 = yes, 0 = no)&nbsp;</td>
+<td style="text-align: left;" align="center">Patient private phone number (50 characters)<br /></td>
+</tr>
+<tr>
+<td align="center">11.</td>
+<td style="text-align: left;" align="center">LOCATION (CLINIC)</td>
+<td style="text-align: left;" align="center">The clinic where the patient is located (250 characters)</td>
 </tr>
 </tbody>
 </table>
-<p style="text-align: center;">&nbsp;</p>
+<p>&nbsp;</p>
+<p>Please make sure that your current <strong>Patient IDs from your existing data are <span style="text-decoration: underline;">unique</span>.</strong></p>
 <table style="margin-left: auto; margin-right: auto;" border="0">
 <tbody>
@@ Line 84: / Line 88: @@
 <td><img src="/images/hint129.png" alt="" width="129" height="129" /></td>
 <td>
+<p>Required fields are:</p>
 <ul>
-<li>Not all fields are required;</li>
+<li>PATIENT ID</li>
-<li>Required fields are:
+<li>DOB</li>
-<ul>
+<li>NAME</li>
-<li>IN_NAME</li>
+<li>GENDER (W/M)</li>
-<li>IN_INSURER_NO</li>
+<li>PARTNER ID (If couples should be linked)</li>
-<li>IN_IS_ECLAIM_BILLING</li>
-</ul>
-</li>
 </ul>
 </td>
@@ Line 98: / Line 100: @@
 </tbody>
 </table>
-<p style="text-align: left;">&nbsp;</p>
+<p>&nbsp;</p>
-<h2>Demographics Import</h2>
+<h2>Cryo storage 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 mandatory to prepare an import file where each line is ONE straw.</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">
+<table style="margin-left: auto; margin-right: auto;" border="0">
 <tbody>
-<tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">&nbsp;START</td>
+<td><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Nam <span class="SpellE">of</span> <span class="SpellE">field</span> (<span class="SpellE">Program</span>)</span></p>
+<p><a href="/images/Cryo_Storage.xls">Click here</a>&nbsp;to download an example of Cryo storage import file.</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;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+</table>
-<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>
+<p>&nbsp;</p>
-</td>
+<p>Before importing, it is important to know that:</p>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<ul>
-<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>
+<li>The cryo storage dimension must be configured in MedITEX IVF Settings;</li>
-</td>
+<li>Each line is one straw. If you have multiple straws for the same patient, these lines must be duplicated in the file.</li>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<li>The patient demographics must already be imported into the MedITEX Database;</li>
-<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>
+<li>Each line must contain the Patient ID, which is the identification for inserting the cryo information for the correct patient. Important is that Patient ID is unique like already mentioned above;</li>
-</td>
+<li>Type of semen material can be specified in: <strong>Native sperm, Prep. Sperm, Tissue, Tissue left, Tissue right, Tissue ambilateral, MESA, MESA left, MESA right, MESA ambilateral, Supernatant, Supernatant left, Supernatant right, Supernatant ambilateral, PESA, TESA, TESE.</strong></li>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+</ul>
-<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>
+<p>The following elements/conditions should be included in the import file:</p>
-</td>
+<table style="margin-left: auto; margin-right: auto;" border="0">
+<tbody>
+<tr>
+<td align="center"><strong>&nbsp;</strong></td>
+<td align="center"><strong>&nbsp;Column name</strong></td>
+<td align="center"><strong>&nbsp;Column content</strong></td>
 </tr>
-<tr style="mso-yfti-irow: 2; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">1.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">2.</span></p>
+<td style="text-align: left;" align="center">PATIENT ID<br /></td>
-</td>
+<td style="text-align: left;" align="center">Patient ID number (64 characters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">2.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">3.</span></p>
+<td style="text-align: left;" align="center">COLLECTION_DATE<br /></td>
-</td>
+<td style="text-align: left;" align="center">Date of sperm collection/follicle aspiration (Date)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">3.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">4.</span></p>
+<td style="text-align: left;" align="center">FREEZING_DATE<br /></td>
-</td>
+<td style="text-align: left;" align="center">Date of freezing (Date)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">4.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">5.</span></p>
+<td style="text-align: left;" align="center">STORAGE_DATE<br /></td>
-</td>
+<td style="text-align: left;" align="center">Date of storage (Date)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">5.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">6.</span></p>
+<td style="text-align: left;" align="center">NO_OOCYTES<br /></td>
-</td>
+<td style="text-align: left;" align="center">Total number of oocytes (Integer)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">6.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">7.</span></p>
+<td style="text-align: left;" align="center">IVF_PNs<br /></td>
-</td>
+<td style="text-align: left;" align="center">Number of PNs after IVF (Integer)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">7.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">8.</span></p>
+<td style="text-align: left;" align="center">ICSI_PNs<br /></td>
-</td>
+<td style="text-align: left;" align="center">Number of PNs after ICSI (Integer)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">8.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">9.</span></p>
+<td style="text-align: left;" align="center">IVF_EMBs<br /></td>
-</td>
+<td style="text-align: left;" align="center">Number of embryos after IVF (Integer)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">9.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">10.</span></p>
+<td style="text-align: left;" align="center">ICSI_EMBs<br /></td>
-</td>
+<td style="text-align: left;" align="center">Number of embryos after ICSI (Integer)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">10.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">11.</span></p>
+<td style="text-align: left;" align="center">OVARIAN_TISSUE<br /></td>
-</td>
+<td style="text-align: left;" align="center">Ovarian tissue cryopreservation (OOC/EMB/PN) (0=No, 1=Yes)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">11.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">12.</span></p>
+<td style="text-align: left;" align="center">SEMEN_MATERIAL</td>
-</td>
+<td style="text-align: left;" align="center">Type of semen material specification (100 characters)&nbsp; <br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">12.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">13.</span></p>
+<td style="text-align: left;" align="center">STRAW_ID</td>
-</td>
+<td style="text-align: left;" align="center">Straw ID (50 characters)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">13.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">14.</span></p>
+<td style="text-align: left;" align="center">CRYO_TECHNIQUE</td>
-</td>
+<td style="text-align: left;" align="center">Cryo technique used (50 characters)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">14. <br /></td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">15.</span></p>
+<td style="text-align: left;" align="center">STORAGE_LOCATION<br /></td>
-</td>
+<td style="text-align: left;" align="center">Storage location description e.g. Container/Tank (128 characters)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 16.5pt;" width="25" valign="bottom">
+<td align="center">15.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">16.</span></p>
+<td style="text-align: left;" align="center">STORAGE_DIM1<br /></td>
-</td>
+<td style="text-align: left;" align="center">Storage dimension e.g. Tank level (128 characters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">16. <br /></td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">17.</span></p>
+<td style="text-align: left;" align="center">STORAGE_DIM2<br /></td>
-</td>
+<td style="text-align: left;" align="center">Storage dimension e.g. Canister level (128 characters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">17.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">18.</span></p>
+<td style="text-align: left;" align="center">STORAGE_DIM3<br /></td>
-</td>
+<td style="text-align: left;" align="center">Storage dimension e.g. Goblet level (128 characters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">18.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">19.</span></p>
+<td style="text-align: left;" align="center">POSITION</td>
-</td>
+<td style="text-align: left;" align="center">Straw position (10 characters)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">19.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">20.</span></p>
+<td style="text-align: left;" align="center">COLOUR1</td>
-</td>
+<td style="text-align: left;" align="center">First color defining the straw (10 characters)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">20.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">21.</span></p>
+<td style="text-align: left;" align="center">COLOUR2</td>
-</td>
+<td style="text-align: left;" align="center">Second color defining the straw (10 characters)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">21.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">22.</span></p>
+<td style="text-align: left;" align="center">CRYOPRESERVED_BY</td>
-</td>
+<td style="text-align: left;" align="center">Staff responsible of the cryopreservation (100 characters)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">22.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">23.</span></p>
+<td style="text-align: left;" align="center">STORED_BY</td>
-</td>
+<td style="text-align: left;" align="center">Staff responsible of the storage (100 characters)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">23.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">24.</span></p>
+<td style="text-align: left;" align="center">CONTRACT_NO</td>
-</td>
+<td style="text-align: left;" align="center">Cryo contract number. Used to link the sample with a contract. See below. (100 characters)</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;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+</table>
-<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>
+<ul>
-</td>
+</ul>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<table style="margin-left: auto; margin-right: auto;" border="0">
-<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>
+<tbody>
-</td>
+<tr>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<td><img src="/images/hint129.png" alt="" width="129" height="129" /></td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_ADDRESS_SUPPLEMENT</span></p>
+<td>
-</td>
+<p>Required fields are:</p>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<ul>
-<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>
+<li>PATIENT_ID</li>
+<li>COLLECTION_DATE</li>
+<li>FREEZING_DATE</li>
+<li>OVARIAN_TISSUE</li>
+<li>TYPE_OF_SEMEN_MATERIAL</li>
+</ul>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 26; height: 15.75pt;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+</table>
-<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>
+<h3>Cryo contracts</h3>
-</td>
+<p>In the case a <a href="/index.php?title=How_to_create_a_new_cryo_contract%3F">cryo contract</a> needs to be imported for the samples, an additional file is required.</p>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>This file will contain the different contracts that are available for each patient. Samples are then linked with each contract, using field 23 from the sample specification above.</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Post <span class="SpellE">code</span></span></p>
+<table style="margin-left: auto; margin-right: auto;" border="0">
-</td>
+<tbody>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<tr>
-<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><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
-</td>
+<td>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<p><a href="/images/Cryo_Contracts.xls">Click here</a>&nbsp;to download an example of Cryo contract import file.</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">VARCHAR(50)</span></p>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 27; height: 15.75pt;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+</table>
-<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>
+<p>&nbsp;</p>
-</td>
+<p>The following elements/conditions should be included in the import file:</p>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<table style="margin-left: auto; margin-right: auto;" border="0">
-<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>
+<tbody>
-</td>
+<tr>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<td align="center"><strong>&nbsp;</strong></td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_ADDRESS_PROVINCE_ID</span></p>
+<td align="center"><strong>&nbsp;Column name</strong></td>
-</td>
+<td align="center"><strong>&nbsp;Column content</strong></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">1.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">28.</span></p>
+<td style="text-align: left;" align="center">PATIENT ID<br /></td>
-</td>
+<td style="text-align: left;" align="center">Patient ID number (64 characters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">2.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">29.</span></p>
+<td style="text-align: left;" align="center">CONTRACT_NO<br /></td>
-</td>
+<td style="text-align: left;" align="center">Number of the cryo contract (100 characters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">3.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">30.</span></p>
+<td style="text-align: left;" align="center">CONTRACT_START<br /></td>
-</td>
+<td style="text-align: left;" align="center">Date when contract starts (Date)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">4.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">31.</span></p>
+<td style="text-align: left;" align="center">CONTRACT_EXPIRY<br /></td>
-</td>
+<td style="text-align: left;" align="center">Date when contract expires (Date)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">5.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">32.</span></p>
+<td style="text-align: left;" align="center">CONTRACT_NAME<br /></td>
-</td>
+<td style="text-align: left;" align="center">Name of the contract (100 characters)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">6.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">33.</span></p>
+<td style="text-align: left;" align="center">CONTRACT_ACTIVE<br /></td>
-</td>
+<td style="text-align: left;" align="center">If contract is still active or if it is terminated. 1 = Active, 0 = Terminated (Integer)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 21.75pt;" width="25" valign="bottom">
+<td align="center">7.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">34.</span></p>
+<td style="text-align: left;" align="center">CONTRACT_NEXT_INVOICE<br /></td>
-</td>
+<td style="text-align: left;" align="center">Date of next invoice (Date)<br /></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;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+</table>
-<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>
+<p>&nbsp;</p>
-</td>
+<table style="margin-left: auto; margin-right: auto;" border="0">
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<tbody>
-<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>
+<tr>
-</td>
+<td><img src="/images/hint129.png" alt="" width="129" height="129" /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">INFORMATION_FROM_NOTE</span></p>
+<p>Before this import can take place, Cryo contracts need to be configured in the system settings: <a href="/index.php?title=MedITEX_IVF_Settings#Cryo_contracts_and_accounting">click here</a> for more information.</p>
-</td>
+<p>Required fields are:</p>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<ul>
-<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>
+<li>PATIENT_ID</li>
+<li>CONTRACT_NO</li>
+<li>CONTRACT_START</li>
+<li>CONTRACT_NAME</li>
+</ul>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 36; height: 15.75pt;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+</table>
-<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>
+<p>&nbsp;</p>
-</td>
+<h2>Semen analyses import</h2>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>An import file should be prepared as a list where each line will represent ONE complete semen analysis.</p>
-<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>
+<table style="margin-left: auto; margin-right: auto;" border="0">
-</td>
+<tbody>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<tr>
-<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><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
-</td>
+<td>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<p><a href="/images/Semen_Analysis_Import.xlsx">Click here</a>&nbsp;to download an example of Semen analysus import file.</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">SMALLINT</span></p>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 37; height: 15.75pt;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+</table>
-<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>
+<p>&nbsp;</p>
-</td>
+<p>Before importing, it is important to know that:</p>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<ul>
-<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>
+<li>The patient demographics must already be imported into the MedITEX Database;</li>
-</td>
+<li>Each line must contain the Patient ID, which is the identification  for inserting the semen analysis information for the correct patient. It is important to know that Patient ID must be unique;</li>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<li>The staff must be inserted in the system in order to properly assign them in the appropriate fields of the semen analysis.</li>
-<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>
+</ul>
-</td>
+<p>The following elements/conditions could be included in the import file:</p>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<table border="0">
-<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>
+<tbody>
-</td>
+<tr>
+<td>1.</td>
+<td>PATIENT_ID</td>
+<td>Patient ID number (Integer)</td>
 </tr>
-<tr style="mso-yfti-irow: 38; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>2.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">38.</span></p>
+<td>SAMPLE_ID</td>
-</td>
+<td>Sample ID number (64 caracters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>3.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">39.</span></p>
+<td>COLLECTION_DATE</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Date of sperm collection (Date)</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Accounting ID</span></p>
+<em><span style="text-decoration: underline;">Preferred format:</span> dd.mm.yyyy hh:mm</em></td>
-</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>4.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">40.</span></p>
+<td>PURPOSE</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Purpose of sample collection (128 characters)</p>
-<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>
+<p>0 = Semen analysis, diagnostics</p>
-</td>
+<p>1 = IVF</p>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<p>2 = ICSI</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_EXTERN_INVOICE_RECEIVER_ID</span></p>
+<p>3 = Insemination</p>
-</td>
+<p>4 = Cryopreservation</p>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<p>5 = Control</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">INTEGER</span></p>
+<p>6 = IMSI</p>
-</td>
+<p>7 = IVM</p>
+<p>8 = Fertility preservation</p>
+<p>9 = PICSI</p>
+<p>11 = Other</p>
+<p>&nbsp;</p>
+<p><em>A sperm sample can have several collection purposes. If it is the case, the purposes&rsquo; ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</em></p>
+<em> <strong>E.g.:</strong> 0,3,8,11</em></td>
 </tr>
-<tr style="mso-yfti-irow: 41; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>5.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">41.</span></p>
+<td>FOR_DONATION</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>If the sample is marked for donation (Boolean)</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Heath <span class="SpellE">insurance</span></span></p>
+<p>0 = No</p>
-</td>
+= Yes</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>6.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">42.</span></p>
+<td>COLLECTION_METHOD</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Method of sample collection (Integer)</p>
-<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>
+<p>0 = Not specified</p>
-</td>
+<p>1 = antegrade ejaculation</p>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<p>2 = retrograde ejaculation</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">KV_VERSICHERUNGS_NR</span></p>
+<p>3 = Cryo sperm</p>
-</td>
+<p>4 = MESA</p>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<p>5 = frozen/thawed MESA</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">VARCHAR(30)</span></p>
+<p>6 = PESA</p>
-</td>
+<p>7 = frozen/thawed PESA</p>
+<p>8 = TESE</p>
+<p>9 = frozen/thawed TESE</p>
+<p>10 = Electrostimulation</p>
+<p>11 = Spermatocele</p>
+<p>12 = Donor</p>
+<p>13 = TESA</p>
+<p>14 = frozen/thawed TESA</p>
+<p>15 = ESA</p>
+<p>16 = frozen/thawed ESA</p>
+<p>23 = Micro-TESA</p>
+<p>24 = Micro-TESE</p>
+<p>&nbsp;</p>
+<em>Please note that only one ID referring to sample collection method should be chosen.</em></td>
 </tr>
-<tr style="mso-yfti-irow: 43; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>7.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">43.</span></p>
+<td>COLLECTION_PLACE</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Place of sample collection (Integer)</p>
-<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>
+<p>1 = At home</p>
-</td>
+= At clinic</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>8.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">44.</span></p>
+<td>COLLECTION_DIFFICULTIES</td>
-</td>
+<td>Sample collection difficulties (200 characters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>9.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">45.</span></p>
+<td>ABS_PERIOD</td>
-</td>
+<td>Abstinence period [days] (Integer)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>10.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">46.</span></p>
+<td>ANALYSIS_START</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Analysis start time (Time)</p>
-<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>
+<p><em><span style="text-decoration: underline;">Format:</span> hh:mm:ss</em></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>11.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">47.</span></p>
+<td>ANALYSED_BY</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Username of the staff performing the sperm sample analysis (113 characters)</p>
-<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>
+<p>&nbsp;</p>
-</td>
+<em>These usernames must be inserted in the system from MedITEX Administration.<br /></em></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>12.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">48.</span></p>
+<td>APPEARANCE</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Sperm sample appearance (128 characters)</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Heath <span class="SpellE">insurance</span></span></p>
+<p>0 = Not specified</p>
-</td>
+<p>1 = Normal</p>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<p>2 = Transparent</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_INSURER2_ID</span></p>
+<p>3 = Flocculent</p>
-</td>
+<p>4 = Yellowish</p>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<p>5 = Hemospermia</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">INTEGER</span></p>
+<p>6 = Colloidal particles</p>
-</td>
+<p>7 = Colloidal plaque</p>
+<p>8 = Debris</p>
+<p>&nbsp;</p>
+<p><em>A sperm sample can have several appearances.</em></p>
+<p><em>If it is the case, the appearances&rsquo; ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</em></p>
+<em> <strong>E.g.:</strong> 0,3,5,8</em></td>
 </tr>
-<tr style="mso-yfti-irow: 49; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>13.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">49.</span></p>
+<td>SMELL</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Sperm sample smell (Integer)</p>
-<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>
+<p>1 = Typical</p>
-</td>
+<p>2 = Foul</p>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+= Other</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>14.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">50.</span></p>
+<td>VISCOSITY</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Sperm sample viscosity (Integer)</p>
-<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>
+<p>0 = Normal</p>
-</td>
+<p>1 = Increased</p>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+= Lowered</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>15.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">51.</span></p>
+<td>LIQQUEFACTION_TIME</td>
-</td>
+<td>Sperm sample liquefaction time [minutes] (Integer)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>16.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">52.</span></p>
+<td>AGGLUTINATION</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Sperm agglutination (Boolean)</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">Insurance <span class="SpellE">status</span></span></p>
+<p>0 = No</p>
-</td>
+= Yes</td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+</tr>
-<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>
+<tr>
-</td>
+<td>17.</td>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<td>TREATMENT</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">VARCHAR(30)</span></p>
+<td>Sperm treatment (200 characters)</td>
+</tr>
+<tr>
+<td>18.</td>
+<td>SCORE</td>
+<td>Sperm sample score (10 characters)</td>
+</tr>
+<tr>
+<td>19.</td>
+<td>NA_VOLUME</td>
+<td>Native sperm sample volume in [ml] (Decimal(4,2))</td>
+</tr>
+<tr>
+<td>20.</td>
+<td>NA_PH</td>
+<td>Native sperm sample PH (Decimal(4,2))</td>
+</tr>
+<tr>
+<td>21.</td>
+<td>NA_CONCENTRATION</td>
+<td>Native sperm sample&nbsp;concentration [Mio/ml] (Decimal(5,3))</td>
+</tr>
+<tr>
+<td>22.</td>
+<td>NA_VITALITY</td>
+<td>Native sperm sample&nbsp;vitality [%] (Decimal(5,2))</td>
+</tr>
+<tr>
+<td>23.</td>
+<td>NA_LEUCOCYTES</td>
+<td>Native sperm sample&nbsp;leucocytes [Mio/ml] (Decimal(9,4))</td>
+</tr>
+<tr>
+<td>24.</td>
+<td>NA_ROUND_CELLS</td>
+<td>Native sperm sample&nbsp;round cells [Mio/ml] (Decimal(9,2))</td>
+</tr>
+<tr>
+<td>25.</td>
+<td>NA_QUANTIFICATION</td>
+<td>
+<p>If native sperm sample&nbsp;quantification is possible (Integer)</p>
+<p>1 = Yes</p>
+= No</td>
+</tr>
+<tr>
+<td>26.</td>
+<td>NA_PEROXIDASE</td>
+<td>Native sperm sample&nbsp;peroxidase-positive cells [10^6/ml] (Decimal(5,2))&nbsp;</td>
+</tr>
+<tr>
+<td>27.</td>
+<td>NA_IMMUNOBEAD</td>
+<td>Native sperm sample&nbsp;immunobead test [% adherent] (Decimal(5,2))</td>
+</tr>
+<tr>
+<td>28.</td>
+<td>NA_MAR</td>
+<td>Native sperm sample&nbsp;MAR test [% adherent] (Decimal(5,2))</td>
+</tr>
+<tr>
+<td>29.</td>
+<td>NA_MAR_IGG</td>
+<td>Native sperm sample&nbsp;MAR test - IgG [%] (Decimal(5,2))</td>
+</tr>
+<tr>
+<td>30.</td>
+<td>NA_MAR_IGA</td>
+<td>Native sperm sample&nbsp;MAR test - IgA [%] (Decimal(5,2))</td>
+</tr>
+<tr>
+<td>31.</td>
+<td>NA_WHO_AB</td>
+<td>Native sperm sample&nbsp;WHO AB [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>32.</td>
+<td>NA_WHO_C</td>
+<td>Native sperm sample&nbsp;WHO C [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>33.</td>
+<td>NA_WHO_D</td>
+<td>Native sperm sample&nbsp;WHO D [%] (Decimal(5,2))&nbsp;</td>
+</tr>
+<tr>
+<td>34.</td>
+<td>NA_NORMAL_FORMS</td>
+<td>Native sperm sample&nbsp;normal forms [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>35.</td>
+<td>NA_HEAD_DEF</td>
+<td>Native sperm sample&nbsp;head defects [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>36.</td>
+<td>NA_NECK_MID_DEF</td>
+<td>Native sperm sample&nbsp;&nbsp;neck and midpiece defects [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>37.</td>
+<td>NA_TAIL_DEF</td>
+<td>Native sperm sample&nbsp;&nbsp;tail defects [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>38.</td>
+<td>NA_ERC</td>
+<td>Native sperm sample&nbsp;excess residual cytoplasm ERC [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>39.</td>
+<td>NA_MULT_DEF</td>
+<td>Native sperm sample&nbsp;multiple defects [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>40.</td>
+<td>NA_TZI</td>
+<td>Native sperm sample&nbsp;teratozoospermia index TZI (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>41.</td>
+<td>AP_VOLUME</td>
+<td>After preparation, sperm sample volume in [ml] (Decimal(4,2))<br /></td>
+</tr>
+<tr>
+<td>42.</td>
+<td>AP_CONCENTRATION</td>
+<td>After preparation, sperm sample&nbsp;concentration [Mio/ml] (Decimal(5,3))<br /></td>
+</tr>
+<tr>
+<td>
+<p>43.</p>
 </td>
+<td>AP_VITALITY</td>
+<td>After preparation, sperm sample vitality [%] (Decimal(5,2))<br /></td>
 </tr>
-<tr style="mso-yfti-irow: 53; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>44.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">53.</span></p>
+<td>AP_LEUCOCYTES</td>
-</td>
+<td>After preparation, sperm sample&nbsp;leucocytes [Mio/ml] (Decimal(9,4))<br /></td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+</tr>
-<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>
+<tr>
-</td>
+<td>45.</td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<td>AP_ROUND_CELLS</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_INSURANCE2_START_DT</span></p>
+<td>After preparation, sperm sample&nbsp;round cells [Mio/ml] (Decimal(9,2))<br /></td>
-</td>
+</tr>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<tr>
-<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>46.</td>
+<td>AP_QUANTIFICATION</td>
+<td>
+<p>After preparation, if sperm sample&nbsp;quantification is possible (Integer)</p>
+<p>0 = Not specified</p>
+<p>1 = Yes</p>
+= No<br /></td>
+</tr>
+<tr>
+<td>47.</td>
+<td>AP_ICSI</td>
+<td>
+<p>After preparation, if ICSI is possible (Integer)</p>
+<p>0 = Not specified</p>
+<p>1 = Yes</p>
+<p>2 = No</p>
+<p>&nbsp;</p>
+<em>This should only be filled if the previous quantification was <strong>NOT </strong>possible.</em><br /></td>
+</tr>
+<tr>
+<td>48.</td>
+<td>AP_PEROXIDASE</td>
+<td>After preparation, sperm sample peroxidase-positive cells [10^6/ml] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>49</td>
+<td>AP_IMMUNOBEAD</td>
+<td>After preparation, sperm sample&nbsp;immunobead test [% adherent] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>50.</td>
+<td>AP_MAR</td>
+<td>After preparation, sperm sample&nbsp;MAR test [% adherent] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>51.</td>
+<td>AP_MAR_IGG</td>
+<td>After preparation, sperm sample&nbsp;MAR test - IgG [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>52.</td>
+<td>AP_MAR_IGA</td>
+<td>After preparation, sperm sample&nbsp;MAR test - IgA [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>53.</td>
+<td>AP_WHO_AB</td>
+<td>After preparation, sperm sample&nbsp;WHO AB [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>54.</td>
+<td>AP_WHO_C</td>
+<td>After preparation, sperm sample&nbsp;WHO C [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>55.</td>
+<td>AP_WHO_D</td>
+<td>After preparation, sperm sample&nbsp;WHO D [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>56.</td>
+<td>AP_NORMAL_FORMS</td>
+<td>After preparation, sperm sample&nbsp;normal forms [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>57.</td>
+<td>AP_HEAD_DEF</td>
+<td>After preparation, sperm sample&nbsp;head defects [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>58.</td>
+<td>AP_NECK_MID_DEF</td>
+<td>After preparation, sperm sample&nbsp;neck and midpiece defects [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>
+<p>59.</p>
 </td>
+<td>AP_TAIL_DEF</td>
+<td>After preparation, sperm sample&nbsp;tail defects [%] (Decimal(5,2))<br /></td>
 </tr>
-<tr style="mso-yfti-irow: 54; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>60.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">54.</span></p>
+<td>AP_ERC</td>
-</td>
+<td>After preparation, sperm sample&nbsp;excess residual cytoplasm ERC [%] (Decimal(5,2))<br /></td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+</tr>
-<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>
+<tr>
-</td>
+<td>61.</td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<td>AP_MULT_DEF</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_INSURANCE2_EXPIRY_DT</span></p>
+<td>After preparation, sperm sample&nbsp;multiple defects [%] (Decimal(5,2))<br /></td>
-</td>
+</tr>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<tr>
-<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>62.</td>
+<td>AP_TZI</td>
+<td>After preparation, sperm sample&nbsp;teratozoospermia index TZI (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>63.</td>
+<td>PREP_DATE</td>
+<td>
+<p>Preparation date of the sperm sample&nbsp;(Date)</p>
+<p><em><span style="text-decoration: underline;">Preferred format:</span>&nbsp;dd.mm.yyyy hh:mm</em></p>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 55; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>64.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">55.</span></p>
+<td>PREP_BY</td>
-</td>
+<td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Name of the staff performing the sperm sample analysis (113 characters)</p>
-<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>
+<p>&nbsp;</p>
-</td>
+<em>This will be properly imported once the staff members are inserted in the system.</em><br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+</tr>
-<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>
+<tr>
-</td>
+<td>65.</td>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<td>PREP_METHOD</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">INTEGER</span></p>
+<td>
+<p>Preparation method of the sperm sample&nbsp;(Integer)</p>
+<p>1 = None</p>
+<p>2 = Density gradient</p>
+<p>3 = Swim-up</p>
+<p>4 = Wash / centrifugation</p>
+<p>5 = Incubation</p>
+<p>6 = Glass wool filtration</p>
+<p>7 = Migration / sedimentation</p>
+<p>8 = Concentration</p>
+<p>9 = Unknown</p>
+<p>10 = Other</p>
+<p>11 = Mechanical</p>
+<p>12 = Enzymatical</p>
+<p>13 = Density gradient plus swim-up</p>
+<p>14 = Pellet resuspended</p>
+<p>15 = MACS</p>
+<p>&nbsp;</p>
+<p><em>A maximum of 4 methods can be allowed.</em></p>
+<p><em>In case of more than 1 method, the methods&rsquo; ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</em></p>
+<em><strong> E.g.:</strong> 1,3,5,8</em><br /></td>
+</tr>
+<tr>
+<td>66.</td>
+<td>DNA_FRAG</td>
+<td>Sperm sample DNA fragmented [%] (Decimal(5,2))<br /></td>
+</tr>
+<tr>
+<td>67.</td>
+<td>DIAGNOSIS</td>
+<td>
+<p>Sperm sample diagnosis (128 characters)</p>
+<p>1 = Normozoospermia</p>
+<p>2 = Aspermia</p>
+<p>3 = Azoospermia</p>
+<p>4 = Azoospermia obstructive</p>
+<p>5 = Azoospermia not obstructive</p>
+<p>6 = Oligozoospermia</p>
+<p>7 = Asthenozoospermia</p>
+<p>8 = Teratozoospermia</p>
+<p>9= Hyperzoospermia</p>
+<p>10 = OAT I</p>
+<p>11 = OAT II</p>
+<p>12 = OAT III</p>
+<p>13 = Cryptozoospermia</p>
+<p>14 = Viskopathy</p>
+<p>15 = Necrozoospermia</p>
+<p>16 = Globozoospermia</p>
+<p>17 = Hypospermia</p>
+<p>18 = Haematospermia</p>
+<p>19 = Pyospermia</p>
+<p>20 = Other</p>
+<p>21 = Dispermia lieve</p>
+<p>22 = Dispermia moderata</p>
+<p>23 = Dispermia severa</p>
+<p>24 = Necrospermia</p>
+<p>25 = Eiaculazione Retrogada</p>
+<p>26 = Aneiaculazione</p>
+<p>27 = Anorgasmia</p>
+<p>28 = Polyzoospermia</p>
+<p>34 = Hyperspermia</p>
+<p>&nbsp;</p>
+<p><em>A sperm sample can have several diagnoses.</em></p>
+<p><em>If it is the case, the diagnoses ID&rsquo;s should be separated by a &ldquo;,&rdquo;.</em></p>
+<em><strong> E.g.:</strong> 1,3,10,18</em></td>
+</tr>
+<tr>
+<td>68.</td>
+<td>FINDING</td>
+<td>
+<p>Sperm sample diagnosis finding status (Integer)</p>
+<p>1 = Normal</p>
+= Abnormal<br /></td>
+</tr>
+<tr>
+<td>69.</td>
+<td>TIME_COLL_USAGE</td>
+<td>
+<p>Time between sperm sample collection and usage (Time)</p>
+<p><em><span style="text-decoration: underline;">Format:</span> hh:mm:ss</em></p>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 56; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">56.</span></p>
+<p>70.</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>
+<td>NO_MOT_SPERM_INSEM</td>
+<td>Number of motile sperms inseminated [Mio.] (Decimal(9,2))</td>
 </tr>
-<tr style="mso-yfti-irow: 57; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td>71.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">57.</span></p>
+<td>NOTE</td>
-</td>
+<td>Semen analysis note (500 characters)<br /></td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+</tr>
-<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>
+<tr>
-</td>
+<td>72.</td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<td>VOL_INSEM</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_SPONSORING_STATUS</span></p>
+<td>Volume inseminated [ml] (Decimal(9,3))<br /></td>
-</td>
+</tr>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<tr>
-<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>73.</td>
+<td>24H_MOT</td>
+<td>Sperm sample 24h motility rate[%](Decimal(5,2))<br /></td>
+</tr>
+</tbody>
+</table>
+<p>&nbsp;</p>
+<table style="margin-left: auto; margin-right: auto;" border="0">
+<tbody>
+<tr>
+<td><img src="/images/hint129.png" alt="" width="129" height="129" /></td>
+<td>
+<p>Mandatory fields are:</p>
+<ul>
+<li>PATIENT ID</li>
+<li>SAMPLE_ID</li>
+<li>COLLECTION_DATE</li>
+</ul>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 58; height: 15.75pt;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+</table>
-<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>
+<h2>Insurance Import</h2>
+<p>It is possible to import insurance companies by providing a spreadsheet with the information described on this section.</p>
+<p>An example of this file can be downloaded from the link below. This document contains the insurance information about one insurer.</p>
+<table style="margin-left: auto; margin-right: auto;" border="0">
+<tbody>
+<tr>
+<td><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
+<td>
+<p><a href="/images/Insurance.xls">Click here</a>&nbsp;to download an example of&nbsp;Insurance information import file.</p>
 </td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+</tr>
-<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>
+</tbody>
-</td>
+</table>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<p>&nbsp;</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_SPONSORING_DT_VALID_FROM</span></p>
+<p>The structure of this file is described in the table below:&nbsp;</p>
-</td>
+<table style="margin-left: auto; margin-right: auto;" border="0">
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<tbody>
-<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>
+<tr>
+<td align="center"><strong>&nbsp;</strong></td>
+<td align="center"><strong>&nbsp;Column name</strong></td>
+<td align="center"><strong>&nbsp;Column content</strong></td>
+</tr>
+<tr>
+<td align="center">1.</td>
+<td style="text-align: left;" align="center">IN_NAME</td>
+<td style="text-align: left;" align="center">Insurer name (50 characters)</td>
+</tr>
+<tr>
+<td align="center">2.</td>
+<td style="text-align: left;" align="center">IN_INSURER_NO</td>
+<td style="text-align: left;" align="center">Insurer number (30 characters)</td>
+</tr>
+<tr>
+<td align="center">3.</td>
+<td style="text-align: left;" align="center">IN_ADDRESS</td>
+<td style="text-align: left;" align="center">Insurer address (255 characters)</td>
+</tr>
+<tr>
+<td align="center">4.</td>
+<td style="text-align: left;" align="center">IN_EMAIL</td>
+<td style="text-align: left;" align="center">Insurer email (50 characters)</td>
+</tr>
+<tr>
+<td align="center">5.</td>
+<td style="text-align: left;" align="center">IN_PHONE</td>
+<td style="text-align: left;" align="center">Insurer phone (50 characters)</td>
+</tr>
+<tr>
+<td align="center">6.</td>
+<td style="text-align: left;" align="center">IN_FAX</td>
+<td style="text-align: left;" align="center">Insurer fax (50 characters)</td>
+</tr>
+<tr>
+<td align="center">7.</td>
+<td style="text-align: left;" align="center">IN_COUNTRY</td>
+<td style="text-align: left;" align="center">
+<p><span>Insurer country (numeric code related to the country)</span></p>
+<p>The list of countries and corresponding codes&nbsp;can be <a href="/images/Countries.xls">downloaded here</a></p>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 59; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">8.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">59.</span></p>
+<td style="text-align: left;" align="center">IN_CLINIC_ID_NUMBER</td>
-</td>
+<td style="text-align: left;" align="center">Insurer clinic ID number (defined by the clinic itself)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">9.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">60.</span></p>
+<td style="text-align: left;" align="center">IN_IS_INSURANCE</td>
+<td style="text-align: left;" align="center">Insurer / Funder (1 = insurer, 0 = funder)</td>
+</tr>
+<tr>
+<td align="center">10.</td>
+<td style="text-align: left;" align="center">IN_IS_ECLAIM_BILLING</td>
+<td style="text-align: left;" align="center">E-claim billing (1 = yes, 0 = no)&nbsp;</td>
+</tr>
+</tbody>
+</table>
+<p style="text-align: center;">&nbsp;</p>
+<table style="margin-left: auto; margin-right: auto;" border="0">
+<tbody>
+<tr>
+<td><img src="/images/hint129.png" alt="" width="129" height="129" /></td>
+<td>
+<ul>
+<li>Not all fields are required;</li>
+<li>Required fields are:
+<ul>
+<li>IN_NAME</li>
+<li>IN_INSURER_NO</li>
+</ul>
+</li>
+</ul>
 </td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+</tr>
-<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>
+</tbody>
-</td>
+</table>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<p style="text-align: left;">&nbsp;</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">BV_BLZ</span></p>
+<h2>Referrers Import</h2>
-</td>
+<p>An import file which is a list in Excel or CSV format where each line is ONE referrer should be preparred for this purpose.</p>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<table style="margin-left: auto; margin-right: auto;" border="0">
-<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>
+<tbody>
+<tr>
+<td><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
+<td>
+<p><a href="/images/ReferrersImport.xlsx">Click here</a>&nbsp;to download an example of&nbsp;Referrers import file.</p>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 61; height: 15.75pt;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+</table>
-<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>
+<p>&nbsp;</p>
-</td>
+<p>The structure of this file is described in the table below:&nbsp;</p>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<table style="margin-left: auto; margin-right: auto;" border="0">
-<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>
+<tbody>
-</td>
+<tr>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<td align="center"><strong>&nbsp;</strong></td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">BV_BANK</span></p>
+<td align="center"><strong>&nbsp;Column name</strong></td>
-</td>
+<td align="center"><strong>&nbsp;Column content</strong></td>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+</tr>
-<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>
+<tr>
+<td align="center">1.</td>
+<td style="text-align: left;" align="center">SURNAME</td>
+<td style="text-align: left;" align="center">Referrer surname (50 characters)</td>
+</tr>
+<tr>
+<td align="center">2.</td>
+<td style="text-align: left;" align="center">FIRSTNAME</td>
+<td style="text-align: left;" align="center">Referrer first name (50 characters)</td>
+</tr>
+<tr>
+<td align="center">3.</td>
+<td style="text-align: left;" align="center">TITLE</td>
+<td style="text-align: left;" align="center">Referrer title (20 characters)<br /></td>
+</tr>
+<tr>
+<td align="center">4.</td>
+<td style="text-align: left;" align="center">DOB<br /></td>
+<td style="text-align: left;" align="center">
+<p>Referrer date of birth (Date)</p>
+<p><em>Preferred format:&nbsp;dd.mm.yyyy</em></p>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 62; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">5.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">62.</span></p>
+<td style="text-align: left;" align="center">SPECIALISATION<br /></td>
-</td>
+<td style="text-align: left;" align="center">
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Referrer specialisation (265 characters)</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">6.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">63.</span></p>
+<td style="text-align: left;" align="center">SALUTATION_AS</td>
-</td>
+<td style="text-align: left;" align="center">
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Referrer salutation as (Integer)</p>
-<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>
+<p>1: GP</p>
-</td>
+<p>2: JP</p>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<p>3: Male doctor</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">P_IS_WORKING</span></p>
+<p>4: Female doctor</p>
-</td>
+<p>5: MCC</p>
-<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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">7.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">64.</span></p>
+<td style="text-align: left;" align="center">STREET</td>
-</td>
+<td style="text-align: left;" align="center">
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>Referrer address: street and no. (100 characters)</p>
-<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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+<td align="center">8.</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="mso-ascii-font-family: Calibri; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: Calibri; mso-bidi-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">65.</span></p>
+<td style="text-align: left;" align="center">POSTCODE</td>
-</td>
+<td style="text-align: left;" align="center">Referrer address: postcode (8 characters)</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+</tr>
-<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>
+<tr>
-</td>
+<td align="center">9.</td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<td style="text-align: left;" align="center">CITY</td>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">BERUFSZUSATZ</span></p>
+<td style="text-align: left;" align="center">Referrer address: city (50 characters)</td>
-</td>
+</tr>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<tr>
-<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 align="center">10.</td>
+<td style="text-align: left;" align="center">PHONE</td>
+<td style="text-align: left;" align="center">Referrer phone number (40 characters)</td>
+</tr>
+<tr>
+<td align="center">11.</td>
+<td style="text-align: left;" align="center">FAX</td>
+<td style="text-align: left;" align="center">Referrer fax (40 characters)</td>
+</tr>
+<tr>
+<td align="center">12.</td>
+<td style="text-align: left;" align="center">EMAIL</td>
+<td style="text-align: left;" align="center">Referrer email (100 characters)</td>
+</tr>
+<tr>
+<td align="center">13.</td>
+<td style="text-align: left;" align="center">REFERRER_CODE</td>
+<td style="text-align: left;" align="center">Referrer code (30 characters)</td>
+</tr>
+<tr>
+<td align="center">14.</td>
+<td style="text-align: left;" align="center">NOTE</td>
+<td style="text-align: left;" align="center">Referrer note (500 characters)</td>
+</tr>
+<tr>
+<td align="center">15.</td>
+<td style="text-align: left;" align="center">ADDRESS_SALUTATION</td>
+<td style="text-align: left;" align="center">Referrer salutations of address (200 characters)</td>
+</tr>
+<tr>
+<td align="center">16.</td>
+<td style="text-align: left;" align="center">LETTER_SALUTATION</td>
+<td style="text-align: left;" align="center">Referrer salutations for letter (200 characters)</td>
+</tr>
+<tr>
+<td align="center">17.</td>
+<td style="text-align: left;" align="center">REFERRER_CLINIC_NAME</td>
+<td style="text-align: left;" align="center">Referrer clinic name (100 characters)</td>
+</tr>
+<tr>
+<td align="center">18.</td>
+<td style="text-align: left;" align="center">REFERRER_CLINIC_CODE</td>
+<td style="text-align: left;" align="center">Referrer clinic code (25 characters)</td>
+</tr>
+</tbody>
+</table>
+<p>&nbsp;</p>
+<table style="margin-left: auto; margin-right: auto;" border="0">
+<tbody>
+<tr>
+<td><img src="/images/hint129.png" alt="" width="129" height="129" /></td>
+<td>
+<ul>
+<li>Not all fields are required;</li>
+<li>Mandatory fields are:
+<ul>
+<li>SURNAME</li>
+<li>FIRSTNAME</li>
+<li>REFERRER_CODE</li>
+</ul>
+</li>
+</ul>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 66; height: 15.75pt;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom">
+</table>
-<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>
+<p style="text-align: left;">&nbsp;</p>
-</td>
+<h2>Historical Notes Import</h2>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247">
+<p>An import file which is a list in Excel or CSV format where each line is ONE historical note should be preparred for this purpose.</p>
-<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>
+<table style="margin-left: auto; margin-right: auto;" border="0">
-</td>
+<tbody>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285">
+<tr>
-<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><img src="/images/plus48.png" alt="" width="48" height="48" /></td>
-</td>
+<td>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">
+<p><a href="/images/History_Notes.xls">Click here</a>&nbsp;to download an example of&nbsp;Referrers import file.</p>
-<p class="MsoNormal" style="margin-bottom: .0001pt; line-height: normal;"><span style="font-size: 12.0pt; font-family: &quot;Times New Roman&quot;,serif; mso-fareast-font-family: &quot;Times New Roman&quot;; color: black; mso-ansi-language: DE; mso-fareast-language: DE;">VARCHAR(100)</span></p>
 </td>
 </tr>
-<tr style="mso-yfti-irow: 67; height: 15.75pt;">
+</tbody>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+</table>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<p>&nbsp;</p>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<p>The following elements should be included in this file:</p>
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+<table style="margin-left: auto; margin-right: auto;" border="0">
+<tbody>
+<tr>
+<td align="center"><strong>&nbsp;</strong></td>
+<td align="center"><strong>&nbsp;Column name</strong></td>
+<td align="center"><strong>&nbsp;Column content</strong></td>
 </tr>
-<tr style="mso-yfti-irow: 68; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">1.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">PATIENT_ID<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">Patient ID (64 characters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">2.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">START<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">Start date (Date)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">3.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">END<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">End date (Date)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">4.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">BY<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">Username of the staff member that should be linked (31 characters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">5.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">STATUS<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+<p>Status (Integer)</p>
+<p>0 or emtpy = No status</p>
+<p>1 = Normal</p>
+<p>2 = Abnormal</p>
+<br /></td>
 </tr>
-<tr style="mso-yfti-irow: 73; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">6.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">ALERT<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+<p>Alert (Integer)</p>
+<p>An entry set as Alert will pop-up when the patient is opened.</p>
+<p>0 or emtpy = Not an alert</p>
+<p>1 = Alert</p>
+</td>
 </tr>
-<tr style="mso-yfti-irow: 74; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">7.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">CONFIDENTIAL<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+<p>Confidential (Integer)</p>
+<p>An entry set as Confidential can only be visible/editable by staff that have access to seeing confidential entries. This setting is set by administrators per user.</p>
+<p>0 or emtpy = Not confidential</p>
+<p>1 = Confidential</p>
+<p><em>Confidential entries can ONLY be set for AREA = 9.</em></p>
+</td>
 </tr>
-<tr style="mso-yfti-irow: 75; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">8.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">AREA<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+<p>Area where the historical note is visible (Integer)</p>
+<p>9 = Medical history section</p>
+<p>10 = Demographics section</p>
+<p>11 = Examinations section</p>
+</td>
 </tr>
-<tr style="mso-yfti-irow: 76; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">9.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">NAME<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">Name of the entry related with the AREA above (50 characters)</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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">10.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">NOTE<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">Text that should be displayed in this note. (unlimited)<br /></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;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">11.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">APPROVAL<br /></td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279"></td>
+<p>Approval status (Integer)</p>
+<p>Emtpy = no status</p>
+<p>0 = Attention</p>
+= Approved<br /></td>
 </tr>
-<tr style="mso-yfti-irow: 79; mso-yfti-lastrow: yes; height: 15.75pt;">
+<tr>
-<td style="width: 19.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="25" valign="bottom"></td>
+<td align="center">12.</td>
-<td style="width: 185.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="247"></td>
+<td style="text-align: left;" align="center">ATTENTION</td>
-<td style="width: 214.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="285"></td>
+<td style="text-align: left;" align="center">
-<td style="width: 209.0pt; padding: 0cm 3.5pt 0cm 3.5pt; height: 15.75pt;" width="279">END</td>
+<p>Username of the staff member that should be linked as attention (31 characters)</p>
+<p><em>Can be emtpy, but should only be filled when APPROVAL = 0.</em></p>
+</td>
+</tr>
+<tr>
+<td align="center">13.</td>
+<td style="text-align: left;" align="center">COMMENT</td>
+<td style="text-align: left;" align="center">Text that can be inserted as part of the approval (255 characters)</td>
 </tr>
 </tbody>
 </table>
+<p>&nbsp;</p>
+<table style="margin-left: auto; margin-right: auto;" border="0">
+<tbody>
+<tr>
+<td><img src="/images/hint129.png" alt="" width="129" height="129" /></td>
+<td>
+<ul>
+<li>Not all fields are required;</li>
+<li>Mandatory fields are:
+<ul>
+<li>PATIENT_ID</li>
+<li>START</li>
+<li>AREA</li>
+<li>NAME</li>
+</ul>
+</li>
+</ul>
+</td>
+</tr>
+</tbody>
+</table>
+<p>&nbsp;</p>
+<p>&nbsp;</p>
 <table style="float: right;" border="0">
 <tbody>