FIVNAT Import Cycles
From MedITEX - Wiki
(Difference between revisions)
| Line 1: | Line 1: | ||
| − | 1 | + | <table border="0" cellspacing="0" cellpadding="0" width="2233"> |
| + | <colgroup><col width="80"></col> <col width="363"></col> <col width="1790"></col> </colgroup> | ||
| + | <tbody> | ||
| + | <tr height="40"> | ||
| + | <td class="xl66" width="80" height="40">Pos</td> | ||
| + | <td class="xl65" width="363">Spaltenname</td> | ||
| + | <td class="xl64" width="1790">Fresh Cycles</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">A</span></td> | ||
| + | <td class="xl63"><span class="font5">reserved</span></td> | ||
| + | <td class="xl63">empty</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AA</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_DELIV_NB</span></td> | ||
| + | <td class="xl63">female medical history > basic > Right below previouse treatments group(red line) gravida number</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AB</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_EUP_NB</span></td> | ||
| + | <td class="xl63">female medical history > basic > Right below previouse treatments group(red line) ectopics number</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AC</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology01</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AD</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology02</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AE</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology03</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AF</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology04</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AG</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology05</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AH</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology06</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AI</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology07</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AJ</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology08</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AK</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology09</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AL</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology10</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AM</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology11</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AN</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology12</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AO</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology13</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AP</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology14</span></td> | ||
| + | <td class="xl63">Medical history female>stirility factors (rd$hauptindikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AQ</span></td> | ||
| + | <td class="xl63"><span class="font5">ParticularFemalePathology15</span></td> | ||
| + | <td class="xl63">if its non of the above and the free text is filled then "1" otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AR</span></td> | ||
| + | <td class="xl63">Spermiogram1</td> | ||
| + | <td class="xl63">rd$andro_diagnose , for any of the 2 sperm samples used, if 1 is selected then 1 otherwise 0(in cycle>cultur>treatment sperm>sperm analysis>diagnosis)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AS</span></td> | ||
| + | <td class="xl63"><span class="font5">Spermiogram2</span></td> | ||
| + | <td class="xl63">rd$andro_diagnose , if 6 is selected then 1 otherwise 0(in sperm analysis>diagnosis)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AT</span></td> | ||
| + | <td class="xl63"><span class="font5">Spermiogram3</span></td> | ||
| + | <td class="xl63">rd$andro_diagnose , if 7 is selected then 1 otherwise 0(in sperm analysis>diagnosis)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AU</span></td> | ||
| + | <td class="xl63"><span class="font5">Spermiogram4</span></td> | ||
| + | <td class="xl63">rd$andro_diagnose , if 8 is selected then 1 otherwise 0(in sperm analysis>diagnosis)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AV</span></td> | ||
| + | <td class="xl63"><span class="font5">Spermiogram5</span></td> | ||
| + | <td class="xl63">rd$andro_diagnose , if 3 is selected then 1 otherwise 0(in sperm analysis>diagnosis)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AW</span></td> | ||
| + | <td class="xl63"><span class="font5">Spermiogram6</span></td> | ||
| + | <td class="xl63">rd$andro_diagnose , if 13 is selected then 1 otherwise 0(in sperm analysis>diagnosis)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AX</span></td> | ||
| + | <td class="xl63"><span class="font5">Spermiogram7</span></td> | ||
| + | <td class="xl63">if diagnosis isnt one of the above, then 0, otherwise, 1</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AY</span></td> | ||
| + | <td class="xl63">Spermiogram8</td> | ||
| + | <td class="xl63">if sperm sample 1 diuagnosis isnt selected, then 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">AZ</span></td> | ||
| + | <td class="xl63"><span class="font5">Pathol_Other_Male1</span></td> | ||
| + | <td class="xl63">same as female AB,AC… but with Male medical history > general> fetility imparement factors (rd$androl_indikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">B</span></td> | ||
| + | <td class="xl63"><span class="font5">reserved</span></td> | ||
| + | <td class="xl63">empty</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BA</span></td> | ||
| + | <td class="xl63"><span class="font5">Pathol_Other_Male2</span></td> | ||
| + | <td class="xl63">same as female AB,AC… but with Male medical history > general> fetility imparement factors</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BB</span></td> | ||
| + | <td class="xl63"><span class="font5">Pathol_Other_Male3</span></td> | ||
| + | <td class="xl63">same as female AB,AC… but with Male medical history > general> fetility imparement factors</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BC</span></td> | ||
| + | <td class="xl63"><span class="font5">Pathol_Other_Male4</span></td> | ||
| + | <td class="xl63">If male medical history > general > chromosom analysis is 3 then this value is 1 (rd$chromosomenanalyse)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BD</span></td> | ||
| + | <td class="xl63"><span class="font5">Pathol_Other_Male5</span></td> | ||
| + | <td class="xl63">same as bc but for --->general Cftr -carrier - rd$cftrtrigger (if its 2 then 1)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BE</span></td> | ||
| + | <td class="xl63"><span class="font5">Pathol_Other_Male6</span></td> | ||
| + | <td class="xl63">same as AZ for males</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BF</span></td> | ||
| + | <td class="xl63"><span class="font5">Pathol_Other_Male7</span></td> | ||
| + | <td class="xl63">same as female AB,AC… but with Male medical history > general> fetility imparement factors (rd$androl_indikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BG</span></td> | ||
| + | <td class="xl63"><span class="font5">Pathol_Other_Male8</span></td> | ||
| + | <td class="xl63">same as female AB,AC… but with Male medical history > general> fetility imparement factors (rd$androl_indikation)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BH</span></td> | ||
| + | <td class="xl63"><span class="font5">Pathol_Other_Male9</span></td> | ||
| + | <td class="xl63">if non of the above and text field is filled, then 1</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BI</span></td> | ||
| + | <td class="xl63"><span class="font5">INFERT_START_YEAR</span></td> | ||
| + | <td class="xl63">female medical history > basic > unprotected intercorse since > year</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BJ</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION01</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)100</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BK</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION02</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)101</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BL</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION03</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)102</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BM</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION04</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)103</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BN</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION05</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)104</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BO</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION06</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)105</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BP</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION07</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)106</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BQ</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION08</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)107</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BR</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION09</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)108</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BS</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION10</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)109</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BT</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION11</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)110</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BU</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_INDICATION12</span></td> | ||
| + | <td class="xl63">Cycle information > main indikation (rd$hauptindikation)111</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BV</span></td> | ||
| + | <td class="xl63"><span class="font5">Import_Date</span></td> | ||
| + | <td class="xl63">"" empty string</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BW</span></td> | ||
| + | <td class="xl63">OOCYTES_IMPORT</td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BX</span></td> | ||
| + | <td class="xl63"><span class="font5">ZYGOTES_IMPORT</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BY</span></td> | ||
| + | <td class="xl63"><span class="font5">EMBRYOS_IMPORT</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">BZ</span></td> | ||
| + | <td class="xl63"><span class="font5">Cycle_fert_techn_plan</span></td> | ||
| + | <td class="xl63">planned cycle 1 ,2 3</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">C</span></td> | ||
| + | <td class="xl63"><span class="font5">FIVNATID</span></td> | ||
| + | <td class="xl63">empty</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CA</span></td> | ||
| + | <td class="xl63"><span class="font5">stimul_start_date</span></td> | ||
| + | <td class="xl63">First stimulation drug date(cycle > over view > medication > smallest stimulation drug date)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CB</span></td> | ||
| + | <td class="xl63"><span class="font5">Protocol</span></td> | ||
| + | <td class="xl63">cycle information> stimulation protocole(rd$stimulation_protocole)100=1,101=2,102=4,else and not null = 3 ,0 for null</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CC</span></td> | ||
| + | <td class="xl63"><span class="font5">GnRHAgonist</span></td> | ||
| + | <td class="xl63">if a medikation of type =6 (from t_medik_bereich) then 1 otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CD</span></td> | ||
| + | <td class="xl63"><span class="font5">GnRHAntagonist</span></td> | ||
| + | <td class="xl63">if a medikation of type =7 (from t_medik_bereich) then 1 otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CE</span></td> | ||
| + | <td class="xl63">stimul_follic_growth1</td> | ||
| + | <td class="xl63">no stimulation drug is selected = 1, stimulation select =0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CF</span></td> | ||
| + | <td class="xl63"><span class="font5">stimul_follic_growth2</span></td> | ||
| + | <td class="xl63">if a medikation of type =5 (from t_medik_bereich) then 1 otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CG</span></td> | ||
| + | <td class="xl63"><span class="font5">stimul_follic_growth3</span></td> | ||
| + | <td class="xl63">if a medikation of type =3 (from t_medik_bereich) then 1 otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CH</span></td> | ||
| + | <td class="xl63"><span class="font5">stimul_follic_growth4</span></td> | ||
| + | <td class="xl63">if a medikation of type =2 (from t_medik_bereich) then 1 otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CI</span></td> | ||
| + | <td class="xl63"><span class="font5">stimul_follic_growth5</span></td> | ||
| + | <td class="xl63">if a medikation of type =1 (from t_medik_bereich) then 1 otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CJ</span></td> | ||
| + | <td class="xl63"><span class="font5">stimul_follic_growth6</span></td> | ||
| + | <td class="xl63">if a medikation of type =4 (from t_medik_bereich) then 1 otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CK</span></td> | ||
| + | <td class="xl63"><span class="font5">stimul_follic_growth7</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CL</span></td> | ||
| + | <td class="xl63"><span class="font5">stimul_follic_growth8</span></td> | ||
| + | <td class="xl63">if stimulation date exists, and type does not belong to the above cases, then 1 otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CM</span></td> | ||
| + | <td class="xl63">stimul_failure</td> | ||
| + | <td class="xl63">if cycle is canceled, then 1, otherwise 0. In cycle overview, right click on the event, Cancel before treatment.</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CN</span></td> | ||
| + | <td class="xl63"><span class="font5">stimul_failure_reason</span></td> | ||
| + | <td class="xl63">1 if cycle was cancled, 0 if cycle is still active</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CO</span></td> | ||
| + | <td class="xl63">OPU_Date</td> | ||
| + | <td class="xl63">cycle information > aspiration date</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CP</span></td> | ||
| + | <td class="xl63"><span class="font5">OPU_OOCYTES_COLLECTED</span></td> | ||
| + | <td class="xl63">oocytes collected in aspiration</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CQ</span></td> | ||
| + | <td class="xl63"><span class="font5">FERT_TECHNIQUE</span></td> | ||
| + | <td class="xl63">ferilation technique( can be 1,2,3,4,0)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CR</span></td> | ||
| + | <td class="xl63"><span class="font5">OPU_OOCYTES_M2</span></td> | ||
| + | <td class="xl63">Kulture M2 cells count</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CS</span></td> | ||
| + | <td class="xl63"><span class="font5">OPU_OOCYTES_M1</span></td> | ||
| + | <td class="xl63">Kulture M1cells count</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CT</span></td> | ||
| + | <td class="xl63"><span class="font5">OPU_OOCYTES_GV</span></td> | ||
| + | <td class="xl63">Kulture GV cells count</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CU</span></td> | ||
| + | <td class="xl63"><span class="font5">OriginOfSperm_OriginOfSperm1</span></td> | ||
| + | <td class="xl63">if one of the first two sperm samples used in the cycle is not donated then 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CV</span></td> | ||
| + | <td class="xl63"><span class="font5">OriginOfSperm_OriginOfSperm2</span></td> | ||
| + | <td class="xl63">if one of the first two sperm samples used in the cycle is donated then 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CW</span></td> | ||
| + | <td class="xl63"><span class="font5">OriginOfSperm_OriginOfSperm21</span></td> | ||
| + | <td class="xl63">if one of the first two sperm samples used in the cycle is thawed then 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CX</span></td> | ||
| + | <td class="xl63"><span class="font5">OriginOfSperm_OriginOfSperm22</span></td> | ||
| + | <td class="xl63">if one of the first two sperm samples used in the cycle is not thawed then 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CY</span></td> | ||
| + | <td class="xl63"><span class="font5">OriginOfSperm_OriginOfSperm31</span></td> | ||
| + | <td class="xl63">if one of the first two sperm samples used in the cycle have the values of for gewinungsart-id: 1 or 2 then 1 otherwise 0 (t_spermangewinnug)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">CZ</span></td> | ||
| + | <td class="xl63"><span class="font5">OriginOfSperm_OriginOfSperm32</span></td> | ||
| + | <td class="xl63">if one of the first two sperm samples used in the cycle have the values of for gewinungsart-id: 4,5,6,7 then 1 , otherwise 0 (t_spermangewinnug)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">D</span></td> | ||
| + | <td class="xl63"><span class="font5">CenterID</span></td> | ||
| + | <td class="xl63">Clinic ID in settings > Clinic</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DA</span></td> | ||
| + | <td class="xl63"><span class="font5">OriginOfSperm_OriginOfSperm33</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DB</span></td> | ||
| + | <td class="xl63"><span class="font5">OriginOfSperm_OriginOfSperm34</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DC</span></td> | ||
| + | <td class="xl63"><span class="font5">OPU_INSEM_OOCYTES</span></td> | ||
| + | <td class="xl63">The total number of OOCtyes inseminated with ivf or icsi(kultur)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DD</span></td> | ||
| + | <td class="xl63">CryopreservationOfOocytes_Oocytes_Slowfreezing_Nb</td> | ||
| + | <td class="xl63">number of thawed oocytes that were perserved by slowfreezing</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DE</span></td> | ||
| + | <td class="xl63">CryopreservationOfOocytes_Oocytes_Vitrification_Nb</td> | ||
| + | <td class="xl63">number of thawed oocytes that were perserved by vitrification</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DF</span></td> | ||
| + | <td class="xl63">NBOocytesDestroyed</td> | ||
| + | <td class="xl63">Lost oocytes from thawed/fresh(kultur)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DG</span></td> | ||
| + | <td class="xl63">Day1_nonfert_Nb</td> | ||
| + | <td class="xl63">total number of day1 fresh oocytes that have no treatment on day 1 or 2</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DH</span></td> | ||
| + | <td class="xl63"><span class="font5">Day1_zygotes1PN_Nb</span></td> | ||
| + | <td class="xl63">total number of fresh 1pn cells avaalable within day 1 in the cycle</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DI</span></td> | ||
| + | <td class="xl63"><span class="font5">Day1_zygotes2PN_Nb</span></td> | ||
| + | <td class="xl63">total number of fresh 2pn cells avaalable within day 1 in the cycle</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DJ</span></td> | ||
| + | <td class="xl63"><span class="font5">Day1_zygotes3PN_Nb</span></td> | ||
| + | <td class="xl63">total number of fresh 3pn cells avaalable within day 1 in the cycle</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DK</span></td> | ||
| + | <td class="xl63">NbOfZygotesCryopreser_zygotes_Slowfreezing_Nb</td> | ||
| + | <td class="xl63">number of thawed PNs that were perserved by slowfreezing</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DL</span></td> | ||
| + | <td class="xl63">NbOfZygotesCryopreser_zygotes_Vitrification_Nb</td> | ||
| + | <td class="xl63">number of thawed PNs that were perserved by vitrification</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DM</span></td> | ||
| + | <td class="xl63"><span class="font5">NbZygotesleftinculture</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DN</span></td> | ||
| + | <td class="xl63">NbZygotesDestroyed</td> | ||
| + | <td class="xl63">number of pns destroyed. coalesce(SEIVFLOST,0) + coalesce(SEIVFLOSTPNAT,0) + coalesce(SEICSILOST,0) + coalesce(SEICSILOSTPNAT,0))<br /></td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DO</span></td> | ||
| + | <td class="xl63">TotalNbEmbryos_day2</td> | ||
| + | <td class="xl63">total fresh embryos within day 2 of cultur</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DP</span></td> | ||
| + | <td class="xl63">CryopreservationOfEmbryos_embryos_Slowfreezing_Nb</td> | ||
| + | <td class="xl63">number of thawed embryos that were perserved by slowfreezing</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DQ</span></td> | ||
| + | <td class="xl63">CryopreservationOfEmbryos_embryos_Vitrification_Nb</td> | ||
| + | <td class="xl63">number of thawed embryos that were perserved by vitrification</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DR</span></td> | ||
| + | <td class="xl63">ReasonForEmbryoCryo</td> | ||
| + | <td class="xl63">If the database is:<br /> #Italian:<br /> for the kultur QM field's 'Motivo della crioconservazione' values, the corresponding number will be set: <br /> 'Sindrome da iperstimolazione ovarica' then 1<br /> 'Malattia concomitante' then 2<br /> 'Emorragia' then 3<br /> 'Rischio di gravidanza multipla' then 4<br /> 'Stenosi cervicale' then 5<br /> 'Causa imprevista' then 6<br /> 'Altro' then 7<br /> #German:<br /> for the kultur QM field's 'Grund für Embryo-Kryokonservierung' values, the corresponding number will be set: <br /> 'OHSS' then 1<br /> 'Begleiterkrankungen' then 2<br /> 'Blutungen' then 3<br /> 'Vermeidung von Mehrlingen' then 4<br /> 'Not-Kryokonservierung' then 5<br /> 'Sonstige' then 6<br /> 'Keine' then 7</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DS</span></td> | ||
| + | <td class="xl63"><span class="font5">EMBR_INTRA_VAG_NB</span></td> | ||
| + | <td class="xl63">No. intrauterine in (cycle>pregnancy > No. intrauterine)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DT</span></td> | ||
| + | <td class="xl63">EMBR_DESTR_NB</td> | ||
| + | <td class="xl63">icsi and ivf embryos lost(in kultur)??</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DU</span></td> | ||
| + | <td class="xl63"><span class="font5">EMBR_DESTR_REASON</span></td> | ||
| + | <td class="xl63">If the database is of the following language, the corresponidng number value for the specified cultur QM field/value will be set: <br /> <br /> #Italian<br /> 'Motivo della distruzione'= 'Arresto evoluzione' then 1<br /> 'Motivo della distruzione' = 'Potenziale sviluppo molto basso' then 2<br /> 'Motivo della distruzione'= 'Volontà della coppia' then 3<br /> 'Motivo della distruzione'= 'Altri motivia' then 4<br /> <br /> #German<br /> 'Grund für Embryoverwerfung' = 'Entwicklungsstop' then 1<br /> 'Grund für Embryoverwerfung'= 'Sehr niedriges Entwicklungspotenzial' then 2<br /> 'Grund für Embryoverwerfung' = 'Entscheidung des Paares' then 3<br /> 'Grund für Embryoverwerfung' = 'Sonstige Gründe' then 4<br /></td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DV</span></td> | ||
| + | <td class="xl63">EMBR_RESEARCH_NB</td> | ||
| + | <td class="xl63">total embryos frozen for research(of the first 4 frozen female samples in the cycle), in therapie>????????? Check and check field name"kg3.kg_zur_forschung_frei"</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DW</span></td> | ||
| + | <td class="xl63"><span class="font5">EMBR_RESEARCH_REASON</span></td> | ||
| + | <td class="xl63">same location as the above field(dv)<br /> if the research reason select for ANY of the first 4 frozen female samples (from rd$research_reason) is =1 then 1, if 2, then 2, if 3 then 3 (in the corresponding order) otherwise, 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DX</span></td> | ||
| + | <td class="xl63"><span class="font5">TRANSFER</span></td> | ||
| + | <td class="xl63">if a cell transfer occurs in cultur, then 1, otherwise 0 </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DY</span></td> | ||
| + | <td class="xl63"><span class="font5">transfer_cancelled</span></td> | ||
| + | <td class="xl63">if no female sample thawing took place and if therapie is cancled for 100 then 1, if 101 then 2 , if 102 or 103 then 3 , if not of the above and not 0 nor 1 then 5 , if non of the above, then 0<br /> #If female thawing took place and the therapie was cancled THEN if cancelation is for 3 then 1, if non of the above then 0 (From rd$abbrucht_t)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">DZ</span></td> | ||
| + | <td class="xl63"><span class="font5">ZygotesTransferred_IVF_NB</span></td> | ||
| + | <td class="xl63">total transferred ivf 2pns(ideal+nideal)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">E</span></td> | ||
| + | <td class="xl63"><span class="font5">SubCenterID</span></td> | ||
| + | <td class="xl63">PRN in settings> Clinic</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EA</span></td> | ||
| + | <td class="xl63"><span class="font5">ZygotesTransferred_ICSI_NB</span></td> | ||
| + | <td class="xl63">total transferred icsi 2pns(ideal+nideal)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EB</span></td> | ||
| + | <td class="xl63"><span class="font5">EmbryosTransfer_IVF_NB</span></td> | ||
| + | <td class="xl63">total transferred ivf embryos(ideal+nideal)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EC</span></td> | ||
| + | <td class="xl63"><span class="font5">EmbryosTransfer_ICSI_NB</span></td> | ||
| + | <td class="xl63">total transferred icsi embryos(ideal+nideal)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">ED</span></td> | ||
| + | <td class="xl63"><span class="font5">Transfer_DATE</span></td> | ||
| + | <td class="xl63">main transfer date in(cycle > transfer > "date of transfer" )</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EE</span></td> | ||
| + | <td class="xl63">TreatmentAfterTransfer</td> | ||
| + | <td class="xl63">if drug type used for treamtnet is in 12 , 10 , 9(from rd$medikamente) then 2,4,5 in the corresponding order<br /> if non of the above, then ???????? (check)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EF</span></td> | ||
| + | <td class="xl63"><span class="font5">TRANSF_COMPLIC_YES_NO</span></td> | ||
| + | <td class="xl63">if transfer complications are selected then 1, otherwise 0.</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EG</span></td> | ||
| + | <td class="xl63">TRANSF_COMPLIC_HOSP</td> | ||
| + | <td class="xl63">if "main complication" in (cycle>transfer) is 5 then1, if 6 then 2 otherwise 0(from rd$trans_complication)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EH</span></td> | ||
| + | <td class="xl63">TRANSF_COMPLIC_HOSP_CRYO</td> | ||
| + | <td class="xl63">if "main complication" in (cycle>transfer) is 7 or 14 then 1 otherwise 0 (from rd$trans_complication)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EI</span></td> | ||
| + | <td class="xl63">TRANSF_COMPLIC_OTHER1</td> | ||
| + | <td class="xl63">8 (in female cycle>transfer > complications)from rd$ trans_complication </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EJ</span></td> | ||
| + | <td class="xl63"><span class="font5">TRANSF_COMPLIC_OTHER2</span></td> | ||
| + | <td class="xl63">9 (in female cycle>transfer > complications)from rd$ trans_complication </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EK</span></td> | ||
| + | <td class="xl63"><span class="font5">TRANSF_COMPLIC_OTHER3</span></td> | ||
| + | <td class="xl63">10 (in female cycle>transfer > complications)from rd$ trans_complication </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EL</span></td> | ||
| + | <td class="xl63"><span class="font5">TRANSF_COMPLIC_OTHER4</span></td> | ||
| + | <td class="xl63">11 (in female cycle>transfer > complications)from rd$ trans_complication </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EM</span></td> | ||
| + | <td class="xl63"><span class="font5">TRANSF_COMPLIC_OTHER5</span></td> | ||
| + | <td class="xl63">12 (in female cycle>transfer > complications)from rd$ trans_complication </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EN</span></td> | ||
| + | <td class="xl63"><span class="font5">TRANSF_COMPLIC_OTHER6</span></td> | ||
| + | <td class="xl63">13 (in female cycle>transfer > complications)from rd$ trans_complication </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EO</span></td> | ||
| + | <td class="xl63"><span class="font5">TRANSF_COMPLIC_OTHER7</span></td> | ||
| + | <td class="xl63">14 (in female cycle>transfer > complications)from rd$ trans_complication </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EP</span></td> | ||
| + | <td class="xl63">CYCLE_RESULT</td> | ||
| + | <td class="xl63">if no pregnancy exisits in pregnacy tab(cycle>pregnancy) then 1<br /> if positive pg test is checked, then 2<br /> if clinical pregnacy is checked, then 3<br /> if the cyclke is not cancled from the overview tab, then 4<br /> if you have treated oocytes with ivf or icsi, but no 2pns out of them and 2pns from ivf + 2pns from icsi =0 then 6(in kultur> oocytes treated wuith ivf+oocytes treated with icsi > 0)<br /> (in kultur> oocytes treated wuith ivf+oocytes treated with icsi > 0) and number of total embryos is 0<br /> if cycle is not cancled in cultur then 8<br /> otherwise 9<br /></td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EQ</span></td> | ||
| + | <td class="xl63"><span class="font5">ThawingOf1</span></td> | ||
| + | <td class="xl63">if PNs were thawed then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">ER</span></td> | ||
| + | <td class="xl63"><span class="font5">ThawingOf2</span></td> | ||
| + | <td class="xl63">if embryos were thawed then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">ES</span></td> | ||
| + | <td class="xl63"><span class="font5">ThawingOf3</span></td> | ||
| + | <td class="xl63">if oocytes were thawed then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">ET</span></td> | ||
| + | <td class="xl63">DateOfLastMenstruation</td> | ||
| + | <td class="xl63">if it’s a normal cycle then the the selected value is the aspiration date of the cycle, if aspiration is not a part of this cycle, then the date of the stimulation start</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EU</span></td> | ||
| + | <td class="xl63">StimulationType</td> | ||
| + | <td class="xl63">if planned stimulation is 2 then 1<br /> if its not 2 and there is a stimulatio drug applied in the cycle then 2<br /> if is not 2 and a drug from external stimulation group is selected, then 1, otherwise 0??</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EV</span></td> | ||
| + | <td class="xl63"><span class="font5">OocytesCryoAnotherCenter</span></td> | ||
| + | <td class="xl63">if some thawed oocytes are received from anouther center (calculated when the frozen sample has a "registered clinic of origon")then 2 , if oocytes are only from the current clinic then 1, if no oocytes are thawed then 0 </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EW</span></td> | ||
| + | <td class="xl63"><span class="font5">ZygotesCryoAnotherCenter</span></td> | ||
| + | <td class="xl63">total thawed PNs received from anouther center (calculated when the frozen sample has a "registered clinic of origon")then 2 , if pns are only from the current clinic then 1, if no pns are thawed then 0 </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EX</span></td> | ||
| + | <td class="xl63"><span class="font5">EmbryosCryoAnotherCenter</span></td> | ||
| + | <td class="xl63">total thawed Embryos received from anouther center (calculated when the frozen sample has a "registered clinic of origon")then 2 , if embryos are only from the current clinic then 1, if no embryos are thawed then 0 </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EY</span></td> | ||
| + | <td class="xl63"><span class="font5">DateOfThawing</span></td> | ||
| + | <td class="xl63">First female thawings date within the treatment</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">EZ</span></td> | ||
| + | <td class="xl63"><span class="font5">NumberOfZygotesThawed</span></td> | ||
| + | <td class="xl63">total number of pns</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">F</span></td> | ||
| + | <td class="xl63"><span class="font5">DynelyticsCoupleID</span></td> | ||
| + | <td class="xl63">Couple ID</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FA</span></td> | ||
| + | <td class="xl63"><span class="font5">NumberOfzygotessurvived</span></td> | ||
| + | <td class="xl63">total surviving thawed pns</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FB</span></td> | ||
| + | <td class="xl63">Zygotes_Cryopreserved_Nb</td> | ||
| + | <td class="xl63">total cryoperserved pns within this therapie</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FC</span></td> | ||
| + | <td class="xl63"><span class="font5">NumberOfEmbryosThawed</span></td> | ||
| + | <td class="xl63">total number of thawed embryos</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FD</span></td> | ||
| + | <td class="xl63">EMBR_DESTR_THAWING</td> | ||
| + | <td class="xl63">total Atrratic or lost embryos from thawing in this therapie(I therapie >cryo thawing >atr/lost emb)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FE</span></td> | ||
| + | <td class="xl63"><span class="font5">Embryos_Cryopreserved_Nb</span></td> | ||
| + | <td class="xl63">total number of cryoperserved embryos</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FF</span></td> | ||
| + | <td class="xl63"><span class="font5">ReasonForEmbryoreCryo</span></td> | ||
| + | <td class="xl63"> # when the database language code is Italian then <br /> when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Sindrome da iperstimolazione ovarica' then 1<br /> when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Malattia concomitante' then 2<br /> when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Emorragia' then 3<br /> when the value of the qm field 'Motivo della crioconservazione' in kultur == 'Rischio di gravidanza multipla' then 4<br /> when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Stenosi cervicale' then 5<br /> when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Causa imprevista' then 6<br /> when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Altro' then 7<br /> otherwise then 8 <br /> # when the database language code is German then <br /> when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'OHSS' then 1<br /> when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'Begleiterkrankungen' then 2<br /> when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'Blutungen' then 3<br /> when the value of the qm field 'Grund für Embryo-Kryokonservierung' ='Vermeidung von Mehrlingen' then 4<br /> when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'Not-Kryokonservierung' then 5<br /> when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'Sonstige' then 6<br /> when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'Keine' then 7<br /> otherwise 8 </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FG</span></td> | ||
| + | <td class="xl63"><span class="font5">NumberOfOOcytesThawed</span></td> | ||
| + | <td class="xl63">total number of thawed oocytes</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FH</span></td> | ||
| + | <td class="xl63"><span class="font5">NumberOfsurvivingOOcytesThawed</span></td> | ||
| + | <td class="xl63">total number of surviving thawed oocytes</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FI</span></td> | ||
| + | <td class="xl63">reserved</td> | ||
| + | <td class="xl63">" "(empty string) </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FJ</span></td> | ||
| + | <td class="xl63"><span class="font5">destructionkind</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FK</span></td> | ||
| + | <td class="xl63">destructionOf1</td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FL</span></td> | ||
| + | <td class="xl63"><span class="font5">destructionOf2</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FM</span></td> | ||
| + | <td class="xl63"><span class="font5">destructionOf3</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FN</span></td> | ||
| + | <td class="xl63"><span class="font5">DateOfdestruct</span></td> | ||
| + | <td class="xl63">Null const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FO</span></td> | ||
| + | <td class="xl63">EMBR_DESTR_REASON_destruction</td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FP</span></td> | ||
| + | <td class="xl63">ReasonForDestrOocytes</td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FQ</span></td> | ||
| + | <td class="xl63"><span class="font5">ReasonForDestrZygotes</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FR</span></td> | ||
| + | <td class="xl63"><span class="font5">NBOocytesTransported</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FS</span></td> | ||
| + | <td class="xl63"><span class="font5">NBZygotesTransported</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FT</span></td> | ||
| + | <td class="xl63">PREG_ECHOGRAPHY</td> | ||
| + | <td class="xl63">if in 'female>cycle >pregnancy>aminoic activity'<br /> the values of no.intertwin extertwine is more than 0 then 2<br /> if an embryo exists then3 , if both are not present then 0 </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FU</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_GEST_SACS_NB</span></td> | ||
| + | <td class="xl63">no. intrauterine + no.extrauterine, in (cycle>pregnancy > No. intrauterine&no.extrauterine)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FV</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_FETUS_12w_NB</span></td> | ||
| + | <td class="xl63">no. intrauterine + no.extrauterine, in (cycle>pregnancy > No. intrauterine&no.extrauterine)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FW</span></td> | ||
| + | <td class="xl63">PREG_FETUS_REMOV_YES_NO</td> | ||
| + | <td class="xl63">if induced abortion is applied to at least one fetus, the 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FX</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_FETUS_REMOV_NB</span></td> | ||
| + | <td class="xl63">total number of induced abortion fetusis.</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FY</span></td> | ||
| + | <td class="xl63">Preg_Result</td> | ||
| + | <td class="xl63">when at least one baby has a birth date, then 1<br /> <br /> when a miscarriage takes place for an embryo and a date is set for the miscarriage (in cycle>pregnancy) and the time between the cilinical pregnancy detection date and the miscarage date is between 3-6 months(for all embryos), then 3<br /> <br /> when a miscarriage is set for an embryo(with the case 3 conditions unsatisfied) then 2<br /> <br /> when cases 1,2 and 3 are not satisfied, and extertwine >0 and intertwine =0 then 4<br /> <br /> when cases 1,2 ,3 and 4 are not satisfied, and extertwine >0 and intertwine >0 then 5 <br /> <br /> when previouse cases are not satisfied and induced abortion is set for at least one of the embryos then 6<br /> <br /> if all previouse cases are not satisfied, then 7</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">FZ</span></td> | ||
| + | <td class="xl63">PREG_ABORT_DATE</td> | ||
| + | <td class="xl63">First abortion date</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">G</span></td> | ||
| + | <td class="xl63"><span class="font5">BIRTHDATE_MAN</span></td> | ||
| + | <td class="xl63">Male Birthdate</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GA</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_ABORT_DESCRIBE</span></td> | ||
| + | <td class="xl63">indications of abortion in Cycle>pregnacy> aborted fetuses > indication of abortion(tinabort)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GB</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL_YES_NO</span></td> | ||
| + | <td class="xl63">if pregnancy complications exist then 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GC</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL01</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GD</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL02</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GE</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL03</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GF</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL04</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GG</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL05</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GH</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL06</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GI</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL07</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GJ</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL08</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GK</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL09</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GL</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL10</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GM</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL11</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GN</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL12</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GO</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL13</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GP</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL14</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GQ</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL15</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GR</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL16</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GS</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL17</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GT</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL18</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GU</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL19</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GV</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL20</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GW</span></td> | ||
| + | <td class="xl63"><span class="font5">PREG_PATHOL21</span></td> | ||
| + | <td class="xl63">rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GX</span></td> | ||
| + | <td class="xl63"><span class="font5">DELIV_MODE</span></td> | ||
| + | <td class="xl63">if one of the kids have a deliviry method of ??? Then 1, etc , from the table : rd$tentbendungsart , in cycle> birth>delivary method</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GY</span></td> | ||
| + | <td class="xl63"><span class="font5">DELIV_DATE</span></td> | ||
| + | <td class="xl63">in cycle> birth> date of delivary , select the first avaaille delivary date for the babies.</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">GZ</span></td> | ||
| + | <td class="xl63">DELIV_BABY_NB</td> | ||
| + | <td class="xl63">number of babies born, in cycle>birth overview>children</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">H</span></td> | ||
| + | <td class="xl63"><span class="font5">BIRTHDATE_WOMAN</span></td> | ||
| + | <td class="xl63">Female Birthdate</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HA</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby1_BirthWeight</span></td> | ||
| + | <td class="xl63">first baby birth weight</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HB</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby2_BirthWeight</span></td> | ||
| + | <td class="xl63">second baby birth weight</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HC</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby3_BirthWeight</span></td> | ||
| + | <td class="xl63">third baby birth weight</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HD</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby4_BirthWeight</span></td> | ||
| + | <td class="xl63">fourth baby birth weight</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HE</span></td> | ||
| + | <td class="xl63">Baby_Baby1_MalfoDescribe</td> | ||
| + | <td class="xl63">icd10 description of baby 1 maformation condition (number 1) in therapie > kultur> birth</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HF</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby2_MalfoDescribe</span></td> | ||
| + | <td class="xl63">icd10 description of baby 1 maformation condition (number 1) in therapie > kultur> birth</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HG</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby3_MalfoDescribe</span></td> | ||
| + | <td class="xl63">icd10 description of baby 2 maformation condition (number 1) in therapie > kultur> birth</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HH</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby4_MalfoDescribe</span></td> | ||
| + | <td class="xl63">icd10 description of baby 3 maformation condition (number 1) in therapie > kultur> birth</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HI</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby1_Malformation</span></td> | ||
| + | <td class="xl63">if baby 1 has a congenital malformation registered in cycle>birth> congenital malformation, then 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HJ</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby2_Malformation</span></td> | ||
| + | <td class="xl63">if baby 2 has a congenital malformation registered in cycle>birth> congenital malformation, then 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HK</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby3_Malformation</span></td> | ||
| + | <td class="xl63">if baby 3 has a congenital malformation registered in cycle>birth> congenital malformation, then 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HL</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby4_Malformation</span></td> | ||
| + | <td class="xl63">if baby 4 has a congenital malformation registered in cycle>birth> congenital malformation, then 1, otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HM</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby1_Sex</span></td> | ||
| + | <td class="xl63">baby 1 sex, 2 male 3 female(0 for not recorded or male-female)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HN</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby2_Sex</span></td> | ||
| + | <td class="xl63">baby 2 sex, 2 male 3 female(0 for not recorded or male-female)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HO</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby3_Sex</span></td> | ||
| + | <td class="xl63">baby 3 sex, 2 male 3 female(0 for not recorded or male-female)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HP</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby4_Sex</span></td> | ||
| + | <td class="xl63">baby 4 sex, 2 male 3 female(0 for not recorded or male-female)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HQ</span></td> | ||
| + | <td class="xl63">Baby_Baby1_Statusdischarge</td> | ||
| + | <td class="xl63">Child number 1: from:rd$kind_zustand, if congenital information = 0 and has not postpardum death date, and has no parental death date and status is 2 THEN 2 <br /> #If status if 4 then 3<br /> #if the baby has a postpadum death date, and a birth date:<br /> --#if the baby died within 6 days from birth then 4<br /> --#if the baby died after more than or equal 7 days and less than or equal 28 days then 5<br /> #if the baby has no registered death date in postpardum and parental death dates fields, and he/she has a congenital malformation value registered, then 6<br /> #otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HR</span></td> | ||
| + | <td class="xl63">Baby_Baby2_Statusdischarge</td> | ||
| + | <td class="xl63">Child number 2: from:rd$kind_zustand, if congenital information = 0 and has not postpardum death date, and has no parental death date and status is 2 THEN 2 <br /> #If status if 4 then 3<br /> #if the baby has a postpadum death date, and a birth date:<br /> --#if the baby died within 6 days from birth then 4<br /> --#if the baby died after more than or equal 7 days and less than or equal 28 days then 5<br /> #if the baby has no registered death date in postpardum and parental death dates fields, and he/she has a congenital malformation value registered, then 6<br /> #otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HS</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby3_Statusdischarge</span></td> | ||
| + | <td class="xl63">Child number 3: from:rd$kind_zustand, if congenital information = 0 and has not postpardum death date, and has no parental death date and status is 2 THEN 2 <br /> #If status if 4 then 3<br /> #if the baby has a postpadum death date, and a birth date:<br /> --#if the baby died within 6 days from birth then 4<br /> --#if the baby died after more than or equal 7 days and less than or equal 28 days then 5<br /> #if the baby has no registered death date in postpardum and parental death dates fields, and he/she has a congenital malformation value registered, then 6<br /> #otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HT</span></td> | ||
| + | <td class="xl63"><span class="font5">Baby_Baby4_Statusdischarge</span></td> | ||
| + | <td class="xl63">Child number 4: from:rd$kind_zustand, if congenital information = 0 and has not postpardum death date, and has no parental death date and status is 2 THEN 2 <br /> #If status if 4 then 3<br /> #if the baby has a postpadum death date, and a birth date:<br /> --#if the baby died within 6 days from birth then 4<br /> --#if the baby died after more than or equal 7 days and less than or equal 28 days then 5<br /> #if the baby has no registered death date in postpardum and parental death dates fields, and he/she has a congenital malformation value registered, then 6<br /> #otherwise 0</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HU</span></td> | ||
| + | <td class="xl63"><span class="font5">NBEmbryosTransported</span></td> | ||
| + | <td class="xl63">0 const</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HV</span></td> | ||
| + | <td class="xl63">EdorexCoupleId</td> | ||
| + | <td class="xl63">"" empty string</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HW</span></td> | ||
| + | <td class="xl63"><span class="font5">DataCorrection</span></td> | ||
| + | <td class="xl63">"" empty string</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HX</span></td> | ||
| + | <td class="xl63"><span class="font5">ReasonForEmbryoCryoOtherDesc</span></td> | ||
| + | <td class="xl63">"" empty string</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">HY</span></td> | ||
| + | <td class="xl63"><span class="font5">TreatmentAfterTransferOtherDesc</span></td> | ||
| + | <td class="xl63">"" empty string</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">I</span></td> | ||
| + | <td class="xl63"><span class="font5">LIVING_IN</span></td> | ||
| + | <td class="xl63">Female Country(in demographics)</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">J</span></td> | ||
| + | <td class="xl63"><span class="font5">LIVING_IN_CH</span></td> | ||
| + | <td class="xl63">1 for living in CH, 0 for not living in CH</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">K</span></td> | ||
| + | <td class="xl63"><span class="font5">CycleKind</span></td> | ||
| + | <td class="xl63">if thawing exists then 1, if not then 2</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">L</span></td> | ||
| + | <td class="xl63"><span class="font5">YEAR_DECLAR_FIVNAT</span></td> | ||
| + | <td class="xl63">start date of cycle or aspiration date</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">M</span></td> | ||
| + | <td class="xl63"><span class="font5">CycleStatus</span></td> | ||
| + | <td class="xl63">empty string ''</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">N</span></td> | ||
| + | <td class="xl63"><span class="font5">reserved</span></td> | ||
| + | <td class="xl63">empty string ''</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">O</span></td> | ||
| + | <td class="xl63">reserved</td> | ||
| + | <td class="xl63">empty string ''</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">P</span></td> | ||
| + | <td class="xl63"><span class="font5">reserved</span></td> | ||
| + | <td class="xl63">empty string ''</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">Q</span></td> | ||
| + | <td class="xl63"><span class="font5">reserved</span></td> | ||
| + | <td class="xl63">empty string ''</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">R</span></td> | ||
| + | <td class="xl63"><span class="font5">reserved</span></td> | ||
| + | <td class="xl63">empty string ''</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">S</span></td> | ||
| + | <td class="xl63"><span class="font5">reserved</span></td> | ||
| + | <td class="xl63">empty string ''</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">T</span></td> | ||
| + | <td class="xl63"><span class="font5">reserved</span></td> | ||
| + | <td class="xl63">empty string ''</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">U</span></td> | ||
| + | <td class="xl63"><span class="font5">reserved</span></td> | ||
| + | <td class="xl63">empty string ''</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">V</span></td> | ||
| + | <td class="xl63"><span class="font5">reserved</span></td> | ||
| + | <td class="xl63">empty string ''</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">W</span></td> | ||
| + | <td class="xl63"><span class="font5">INFERT_FEM_KIND</span></td> | ||
| + | <td class="xl63">infertility type _ Female (female medical history > Fertility > Infertility type): 1=primary , 2 =secondary 99 = other) </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">X</span></td> | ||
| + | <td class="xl63"><span class="font5">INFERT_MAN_KIND</span></td> | ||
| + | <td class="xl63">infertility type _ Male (male medical history > General > Infertility type) : 1=primary , 2 =secondary 99 = other) </td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">Y</span></td> | ||
| + | <td class="xl63">IVF_DECLARED_ATTEMPT_NB</td> | ||
| + | <td class="xl63">female medical history > basic > previouse treatments group > number of ivf-icsi treatments + current therapie number</td> | ||
| + | </tr> | ||
| + | <tr height="20"> | ||
| + | <td class="xl63" height="20"><span class="font6">Z</span></td> | ||
| + | <td class="xl63"><span class="font5">IVF_ABORT_NB</span></td> | ||
| + | <td class="xl63">female medical history > basic > Right below previouse treatments group(red line) abort number</td> | ||
| + | </tr> | ||
| + | </tbody> | ||
| + | </table> | ||
Revision as of 15:49, 23 July 2015
| Pos | Spaltenname | Fresh Cycles |
| A | reserved | empty |
| AA | IVF_DELIV_NB | female medical history > basic > Right below previouse treatments group(red line) gravida number |
| AB | IVF_EUP_NB | female medical history > basic > Right below previouse treatments group(red line) ectopics number |
| AC | ParticularFemalePathology01 | Medical history female>stirility factors (rd$hauptindikation) |
| AD | ParticularFemalePathology02 | Medical history female>stirility factors (rd$hauptindikation) |
| AE | ParticularFemalePathology03 | Medical history female>stirility factors (rd$hauptindikation) |
| AF | ParticularFemalePathology04 | Medical history female>stirility factors (rd$hauptindikation) |
| AG | ParticularFemalePathology05 | Medical history female>stirility factors (rd$hauptindikation) |
| AH | ParticularFemalePathology06 | Medical history female>stirility factors (rd$hauptindikation) |
| AI | ParticularFemalePathology07 | Medical history female>stirility factors (rd$hauptindikation) |
| AJ | ParticularFemalePathology08 | Medical history female>stirility factors (rd$hauptindikation) |
| AK | ParticularFemalePathology09 | Medical history female>stirility factors (rd$hauptindikation) |
| AL | ParticularFemalePathology10 | Medical history female>stirility factors (rd$hauptindikation) |
| AM | ParticularFemalePathology11 | Medical history female>stirility factors (rd$hauptindikation) |
| AN | ParticularFemalePathology12 | Medical history female>stirility factors (rd$hauptindikation) |
| AO | ParticularFemalePathology13 | Medical history female>stirility factors (rd$hauptindikation) |
| AP | ParticularFemalePathology14 | Medical history female>stirility factors (rd$hauptindikation) |
| AQ | ParticularFemalePathology15 | if its non of the above and the free text is filled then "1" otherwise 0 |
| AR | Spermiogram1 | rd$andro_diagnose , for any of the 2 sperm samples used, if 1 is selected then 1 otherwise 0(in cycle>cultur>treatment sperm>sperm analysis>diagnosis) |
| AS | Spermiogram2 | rd$andro_diagnose , if 6 is selected then 1 otherwise 0(in sperm analysis>diagnosis) |
| AT | Spermiogram3 | rd$andro_diagnose , if 7 is selected then 1 otherwise 0(in sperm analysis>diagnosis) |
| AU | Spermiogram4 | rd$andro_diagnose , if 8 is selected then 1 otherwise 0(in sperm analysis>diagnosis) |
| AV | Spermiogram5 | rd$andro_diagnose , if 3 is selected then 1 otherwise 0(in sperm analysis>diagnosis) |
| AW | Spermiogram6 | rd$andro_diagnose , if 13 is selected then 1 otherwise 0(in sperm analysis>diagnosis) |
| AX | Spermiogram7 | if diagnosis isnt one of the above, then 0, otherwise, 1 |
| AY | Spermiogram8 | if sperm sample 1 diuagnosis isnt selected, then 1, otherwise 0 |
| AZ | Pathol_Other_Male1 | same as female AB,AC… but with Male medical history > general> fetility imparement factors (rd$androl_indikation) |
| B | reserved | empty |
| BA | Pathol_Other_Male2 | same as female AB,AC… but with Male medical history > general> fetility imparement factors |
| BB | Pathol_Other_Male3 | same as female AB,AC… but with Male medical history > general> fetility imparement factors |
| BC | Pathol_Other_Male4 | If male medical history > general > chromosom analysis is 3 then this value is 1 (rd$chromosomenanalyse) |
| BD | Pathol_Other_Male5 | same as bc but for --->general Cftr -carrier - rd$cftrtrigger (if its 2 then 1) |
| BE | Pathol_Other_Male6 | same as AZ for males |
| BF | Pathol_Other_Male7 | same as female AB,AC… but with Male medical history > general> fetility imparement factors (rd$androl_indikation) |
| BG | Pathol_Other_Male8 | same as female AB,AC… but with Male medical history > general> fetility imparement factors (rd$androl_indikation) |
| BH | Pathol_Other_Male9 | if non of the above and text field is filled, then 1 |
| BI | INFERT_START_YEAR | female medical history > basic > unprotected intercorse since > year |
| BJ | IVF_INDICATION01 | Cycle information > main indikation (rd$hauptindikation)100 |
| BK | IVF_INDICATION02 | Cycle information > main indikation (rd$hauptindikation)101 |
| BL | IVF_INDICATION03 | Cycle information > main indikation (rd$hauptindikation)102 |
| BM | IVF_INDICATION04 | Cycle information > main indikation (rd$hauptindikation)103 |
| BN | IVF_INDICATION05 | Cycle information > main indikation (rd$hauptindikation)104 |
| BO | IVF_INDICATION06 | Cycle information > main indikation (rd$hauptindikation)105 |
| BP | IVF_INDICATION07 | Cycle information > main indikation (rd$hauptindikation)106 |
| BQ | IVF_INDICATION08 | Cycle information > main indikation (rd$hauptindikation)107 |
| BR | IVF_INDICATION09 | Cycle information > main indikation (rd$hauptindikation)108 |
| BS | IVF_INDICATION10 | Cycle information > main indikation (rd$hauptindikation)109 |
| BT | IVF_INDICATION11 | Cycle information > main indikation (rd$hauptindikation)110 |
| BU | IVF_INDICATION12 | Cycle information > main indikation (rd$hauptindikation)111 |
| BV | Import_Date | "" empty string |
| BW | OOCYTES_IMPORT | 0 const |
| BX | ZYGOTES_IMPORT | 0 const |
| BY | EMBRYOS_IMPORT | 0 const |
| BZ | Cycle_fert_techn_plan | planned cycle 1 ,2 3 |
| C | FIVNATID | empty |
| CA | stimul_start_date | First stimulation drug date(cycle > over view > medication > smallest stimulation drug date) |
| CB | Protocol | cycle information> stimulation protocole(rd$stimulation_protocole)100=1,101=2,102=4,else and not null = 3 ,0 for null |
| CC | GnRHAgonist | if a medikation of type =6 (from t_medik_bereich) then 1 otherwise 0 |
| CD | GnRHAntagonist | if a medikation of type =7 (from t_medik_bereich) then 1 otherwise 0 |
| CE | stimul_follic_growth1 | no stimulation drug is selected = 1, stimulation select =0 |
| CF | stimul_follic_growth2 | if a medikation of type =5 (from t_medik_bereich) then 1 otherwise 0 |
| CG | stimul_follic_growth3 | if a medikation of type =3 (from t_medik_bereich) then 1 otherwise 0 |
| CH | stimul_follic_growth4 | if a medikation of type =2 (from t_medik_bereich) then 1 otherwise 0 |
| CI | stimul_follic_growth5 | if a medikation of type =1 (from t_medik_bereich) then 1 otherwise 0 |
| CJ | stimul_follic_growth6 | if a medikation of type =4 (from t_medik_bereich) then 1 otherwise 0 |
| CK | stimul_follic_growth7 | 0 const |
| CL | stimul_follic_growth8 | if stimulation date exists, and type does not belong to the above cases, then 1 otherwise 0 |
| CM | stimul_failure | if cycle is canceled, then 1, otherwise 0. In cycle overview, right click on the event, Cancel before treatment. |
| CN | stimul_failure_reason | 1 if cycle was cancled, 0 if cycle is still active |
| CO | OPU_Date | cycle information > aspiration date |
| CP | OPU_OOCYTES_COLLECTED | oocytes collected in aspiration |
| CQ | FERT_TECHNIQUE | ferilation technique( can be 1,2,3,4,0) |
| CR | OPU_OOCYTES_M2 | Kulture M2 cells count |
| CS | OPU_OOCYTES_M1 | Kulture M1cells count |
| CT | OPU_OOCYTES_GV | Kulture GV cells count |
| CU | OriginOfSperm_OriginOfSperm1 | if one of the first two sperm samples used in the cycle is not donated then 1, otherwise 0 |
| CV | OriginOfSperm_OriginOfSperm2 | if one of the first two sperm samples used in the cycle is donated then 1, otherwise 0 |
| CW | OriginOfSperm_OriginOfSperm21 | if one of the first two sperm samples used in the cycle is thawed then 1, otherwise 0 |
| CX | OriginOfSperm_OriginOfSperm22 | if one of the first two sperm samples used in the cycle is not thawed then 1, otherwise 0 |
| CY | OriginOfSperm_OriginOfSperm31 | if one of the first two sperm samples used in the cycle have the values of for gewinungsart-id: 1 or 2 then 1 otherwise 0 (t_spermangewinnug) |
| CZ | OriginOfSperm_OriginOfSperm32 | if one of the first two sperm samples used in the cycle have the values of for gewinungsart-id: 4,5,6,7 then 1 , otherwise 0 (t_spermangewinnug) |
| D | CenterID | Clinic ID in settings > Clinic |
| DA | OriginOfSperm_OriginOfSperm33 | 0 const |
| DB | OriginOfSperm_OriginOfSperm34 | 0 const |
| DC | OPU_INSEM_OOCYTES | The total number of OOCtyes inseminated with ivf or icsi(kultur) |
| DD | CryopreservationOfOocytes_Oocytes_Slowfreezing_Nb | number of thawed oocytes that were perserved by slowfreezing |
| DE | CryopreservationOfOocytes_Oocytes_Vitrification_Nb | number of thawed oocytes that were perserved by vitrification |
| DF | NBOocytesDestroyed | Lost oocytes from thawed/fresh(kultur) |
| DG | Day1_nonfert_Nb | total number of day1 fresh oocytes that have no treatment on day 1 or 2 |
| DH | Day1_zygotes1PN_Nb | total number of fresh 1pn cells avaalable within day 1 in the cycle |
| DI | Day1_zygotes2PN_Nb | total number of fresh 2pn cells avaalable within day 1 in the cycle |
| DJ | Day1_zygotes3PN_Nb | total number of fresh 3pn cells avaalable within day 1 in the cycle |
| DK | NbOfZygotesCryopreser_zygotes_Slowfreezing_Nb | number of thawed PNs that were perserved by slowfreezing |
| DL | NbOfZygotesCryopreser_zygotes_Vitrification_Nb | number of thawed PNs that were perserved by vitrification |
| DM | NbZygotesleftinculture | 0 const |
| DN | NbZygotesDestroyed | number of pns destroyed. coalesce(SEIVFLOST,0) + coalesce(SEIVFLOSTPNAT,0) + coalesce(SEICSILOST,0) + coalesce(SEICSILOSTPNAT,0)) |
| DO | TotalNbEmbryos_day2 | total fresh embryos within day 2 of cultur |
| DP | CryopreservationOfEmbryos_embryos_Slowfreezing_Nb | number of thawed embryos that were perserved by slowfreezing |
| DQ | CryopreservationOfEmbryos_embryos_Vitrification_Nb | number of thawed embryos that were perserved by vitrification |
| DR | ReasonForEmbryoCryo | If the database is: #Italian: for the kultur QM field's 'Motivo della crioconservazione' values, the corresponding number will be set: 'Sindrome da iperstimolazione ovarica' then 1 'Malattia concomitante' then 2 'Emorragia' then 3 'Rischio di gravidanza multipla' then 4 'Stenosi cervicale' then 5 'Causa imprevista' then 6 'Altro' then 7 #German: for the kultur QM field's 'Grund für Embryo-Kryokonservierung' values, the corresponding number will be set: 'OHSS' then 1 'Begleiterkrankungen' then 2 'Blutungen' then 3 'Vermeidung von Mehrlingen' then 4 'Not-Kryokonservierung' then 5 'Sonstige' then 6 'Keine' then 7 |
| DS | EMBR_INTRA_VAG_NB | No. intrauterine in (cycle>pregnancy > No. intrauterine) |
| DT | EMBR_DESTR_NB | icsi and ivf embryos lost(in kultur)?? |
| DU | EMBR_DESTR_REASON | If the database is of the following language, the corresponidng number value for the specified cultur QM field/value will be set: #Italian 'Motivo della distruzione'= 'Arresto evoluzione' then 1 'Motivo della distruzione' = 'Potenziale sviluppo molto basso' then 2 'Motivo della distruzione'= 'Volontà della coppia' then 3 'Motivo della distruzione'= 'Altri motivia' then 4 #German 'Grund für Embryoverwerfung' = 'Entwicklungsstop' then 1 'Grund für Embryoverwerfung'= 'Sehr niedriges Entwicklungspotenzial' then 2 'Grund für Embryoverwerfung' = 'Entscheidung des Paares' then 3 'Grund für Embryoverwerfung' = 'Sonstige Gründe' then 4 |
| DV | EMBR_RESEARCH_NB | total embryos frozen for research(of the first 4 frozen female samples in the cycle), in therapie>????????? Check and check field name"kg3.kg_zur_forschung_frei" |
| DW | EMBR_RESEARCH_REASON | same location as the above field(dv) if the research reason select for ANY of the first 4 frozen female samples (from rd$research_reason) is =1 then 1, if 2, then 2, if 3 then 3 (in the corresponding order) otherwise, 0 |
| DX | TRANSFER | if a cell transfer occurs in cultur, then 1, otherwise 0 |
| DY | transfer_cancelled | if no female sample thawing took place and if therapie is cancled for 100 then 1, if 101 then 2 , if 102 or 103 then 3 , if not of the above and not 0 nor 1 then 5 , if non of the above, then 0 #If female thawing took place and the therapie was cancled THEN if cancelation is for 3 then 1, if non of the above then 0 (From rd$abbrucht_t) |
| DZ | ZygotesTransferred_IVF_NB | total transferred ivf 2pns(ideal+nideal) |
| E | SubCenterID | PRN in settings> Clinic |
| EA | ZygotesTransferred_ICSI_NB | total transferred icsi 2pns(ideal+nideal) |
| EB | EmbryosTransfer_IVF_NB | total transferred ivf embryos(ideal+nideal) |
| EC | EmbryosTransfer_ICSI_NB | total transferred icsi embryos(ideal+nideal) |
| ED | Transfer_DATE | main transfer date in(cycle > transfer > "date of transfer" ) |
| EE | TreatmentAfterTransfer | if drug type used for treamtnet is in 12 , 10 , 9(from rd$medikamente) then 2,4,5 in the corresponding order if non of the above, then ???????? (check) |
| EF | TRANSF_COMPLIC_YES_NO | if transfer complications are selected then 1, otherwise 0. |
| EG | TRANSF_COMPLIC_HOSP | if "main complication" in (cycle>transfer) is 5 then1, if 6 then 2 otherwise 0(from rd$trans_complication) |
| EH | TRANSF_COMPLIC_HOSP_CRYO | if "main complication" in (cycle>transfer) is 7 or 14 then 1 otherwise 0 (from rd$trans_complication) |
| EI | TRANSF_COMPLIC_OTHER1 | 8 (in female cycle>transfer > complications)from rd$ trans_complication |
| EJ | TRANSF_COMPLIC_OTHER2 | 9 (in female cycle>transfer > complications)from rd$ trans_complication |
| EK | TRANSF_COMPLIC_OTHER3 | 10 (in female cycle>transfer > complications)from rd$ trans_complication |
| EL | TRANSF_COMPLIC_OTHER4 | 11 (in female cycle>transfer > complications)from rd$ trans_complication |
| EM | TRANSF_COMPLIC_OTHER5 | 12 (in female cycle>transfer > complications)from rd$ trans_complication |
| EN | TRANSF_COMPLIC_OTHER6 | 13 (in female cycle>transfer > complications)from rd$ trans_complication |
| EO | TRANSF_COMPLIC_OTHER7 | 14 (in female cycle>transfer > complications)from rd$ trans_complication |
| EP | CYCLE_RESULT | if no pregnancy exisits in pregnacy tab(cycle>pregnancy) then 1 if positive pg test is checked, then 2 if clinical pregnacy is checked, then 3 if the cyclke is not cancled from the overview tab, then 4 if you have treated oocytes with ivf or icsi, but no 2pns out of them and 2pns from ivf + 2pns from icsi =0 then 6(in kultur> oocytes treated wuith ivf+oocytes treated with icsi > 0) (in kultur> oocytes treated wuith ivf+oocytes treated with icsi > 0) and number of total embryos is 0 if cycle is not cancled in cultur then 8 otherwise 9 |
| EQ | ThawingOf1 | if PNs were thawed then 1 , otherwise 0 |
| ER | ThawingOf2 | if embryos were thawed then 1 , otherwise 0 |
| ES | ThawingOf3 | if oocytes were thawed then 1 , otherwise 0 |
| ET | DateOfLastMenstruation | if it’s a normal cycle then the the selected value is the aspiration date of the cycle, if aspiration is not a part of this cycle, then the date of the stimulation start |
| EU | StimulationType | if planned stimulation is 2 then 1 if its not 2 and there is a stimulatio drug applied in the cycle then 2 if is not 2 and a drug from external stimulation group is selected, then 1, otherwise 0?? |
| EV | OocytesCryoAnotherCenter | if some thawed oocytes are received from anouther center (calculated when the frozen sample has a "registered clinic of origon")then 2 , if oocytes are only from the current clinic then 1, if no oocytes are thawed then 0 |
| EW | ZygotesCryoAnotherCenter | total thawed PNs received from anouther center (calculated when the frozen sample has a "registered clinic of origon")then 2 , if pns are only from the current clinic then 1, if no pns are thawed then 0 |
| EX | EmbryosCryoAnotherCenter | total thawed Embryos received from anouther center (calculated when the frozen sample has a "registered clinic of origon")then 2 , if embryos are only from the current clinic then 1, if no embryos are thawed then 0 |
| EY | DateOfThawing | First female thawings date within the treatment |
| EZ | NumberOfZygotesThawed | total number of pns |
| F | DynelyticsCoupleID | Couple ID |
| FA | NumberOfzygotessurvived | total surviving thawed pns |
| FB | Zygotes_Cryopreserved_Nb | total cryoperserved pns within this therapie |
| FC | NumberOfEmbryosThawed | total number of thawed embryos |
| FD | EMBR_DESTR_THAWING | total Atrratic or lost embryos from thawing in this therapie(I therapie >cryo thawing >atr/lost emb) |
| FE | Embryos_Cryopreserved_Nb | total number of cryoperserved embryos |
| FF | ReasonForEmbryoreCryo | # when the database language code is Italian then when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Sindrome da iperstimolazione ovarica' then 1 when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Malattia concomitante' then 2 when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Emorragia' then 3 when the value of the qm field 'Motivo della crioconservazione' in kultur == 'Rischio di gravidanza multipla' then 4 when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Stenosi cervicale' then 5 when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Causa imprevista' then 6 when the value of the qm field 'Motivo della crioconservazione' in kultur = 'Altro' then 7 otherwise then 8 # when the database language code is German then when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'OHSS' then 1 when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'Begleiterkrankungen' then 2 when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'Blutungen' then 3 when the value of the qm field 'Grund für Embryo-Kryokonservierung' ='Vermeidung von Mehrlingen' then 4 when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'Not-Kryokonservierung' then 5 when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'Sonstige' then 6 when the value of the qm field 'Grund für Embryo-Kryokonservierung' = 'Keine' then 7 otherwise 8 |
| FG | NumberOfOOcytesThawed | total number of thawed oocytes |
| FH | NumberOfsurvivingOOcytesThawed | total number of surviving thawed oocytes |
| FI | reserved | " "(empty string) |
| FJ | destructionkind | 0 const |
| FK | destructionOf1 | 0 const |
| FL | destructionOf2 | 0 const |
| FM | destructionOf3 | 0 const |
| FN | DateOfdestruct | Null const |
| FO | EMBR_DESTR_REASON_destruction | 0 const |
| FP | ReasonForDestrOocytes | 0 const |
| FQ | ReasonForDestrZygotes | 0 const |
| FR | NBOocytesTransported | 0 const |
| FS | NBZygotesTransported | 0 const |
| FT | PREG_ECHOGRAPHY | if in 'female>cycle >pregnancy>aminoic activity' the values of no.intertwin extertwine is more than 0 then 2 if an embryo exists then3 , if both are not present then 0 |
| FU | PREG_GEST_SACS_NB | no. intrauterine + no.extrauterine, in (cycle>pregnancy > No. intrauterine&no.extrauterine) |
| FV | PREG_FETUS_12w_NB | no. intrauterine + no.extrauterine, in (cycle>pregnancy > No. intrauterine&no.extrauterine) |
| FW | PREG_FETUS_REMOV_YES_NO | if induced abortion is applied to at least one fetus, the 1, otherwise 0 |
| FX | PREG_FETUS_REMOV_NB | total number of induced abortion fetusis. |
| FY | Preg_Result | when at least one baby has a birth date, then 1 when a miscarriage takes place for an embryo and a date is set for the miscarriage (in cycle>pregnancy) and the time between the cilinical pregnancy detection date and the miscarage date is between 3-6 months(for all embryos), then 3 when a miscarriage is set for an embryo(with the case 3 conditions unsatisfied) then 2 when cases 1,2 and 3 are not satisfied, and extertwine >0 and intertwine =0 then 4 when cases 1,2 ,3 and 4 are not satisfied, and extertwine >0 and intertwine >0 then 5 when previouse cases are not satisfied and induced abortion is set for at least one of the embryos then 6 if all previouse cases are not satisfied, then 7 |
| FZ | PREG_ABORT_DATE | First abortion date |
| G | BIRTHDATE_MAN | Male Birthdate |
| GA | PREG_ABORT_DESCRIBE | indications of abortion in Cycle>pregnacy> aborted fetuses > indication of abortion(tinabort) |
| GB | PREG_PATHOL_YES_NO | if pregnancy complications exist then 1, otherwise 0 |
| GC | PREG_PATHOL01 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GD | PREG_PATHOL02 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GE | PREG_PATHOL03 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GF | PREG_PATHOL04 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GG | PREG_PATHOL05 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GH | PREG_PATHOL06 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GI | PREG_PATHOL07 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GJ | PREG_PATHOL08 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GK | PREG_PATHOL09 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GL | PREG_PATHOL10 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GM | PREG_PATHOL11 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GN | PREG_PATHOL12 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GO | PREG_PATHOL13 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GP | PREG_PATHOL14 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GQ | PREG_PATHOL15 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GR | PREG_PATHOL16 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GS | PREG_PATHOL17 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GT | PREG_PATHOL18 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GU | PREG_PATHOL19 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GV | PREG_PATHOL20 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GW | PREG_PATHOL21 | rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise 0 |
| GX | DELIV_MODE | if one of the kids have a deliviry method of ??? Then 1, etc , from the table : rd$tentbendungsart , in cycle> birth>delivary method |
| GY | DELIV_DATE | in cycle> birth> date of delivary , select the first avaaille delivary date for the babies. |
| GZ | DELIV_BABY_NB | number of babies born, in cycle>birth overview>children |
| H | BIRTHDATE_WOMAN | Female Birthdate |
| HA | Baby_Baby1_BirthWeight | first baby birth weight |
| HB | Baby_Baby2_BirthWeight | second baby birth weight |
| HC | Baby_Baby3_BirthWeight | third baby birth weight |
| HD | Baby_Baby4_BirthWeight | fourth baby birth weight |
| HE | Baby_Baby1_MalfoDescribe | icd10 description of baby 1 maformation condition (number 1) in therapie > kultur> birth |
| HF | Baby_Baby2_MalfoDescribe | icd10 description of baby 1 maformation condition (number 1) in therapie > kultur> birth |
| HG | Baby_Baby3_MalfoDescribe | icd10 description of baby 2 maformation condition (number 1) in therapie > kultur> birth |
| HH | Baby_Baby4_MalfoDescribe | icd10 description of baby 3 maformation condition (number 1) in therapie > kultur> birth |
| HI | Baby_Baby1_Malformation | if baby 1 has a congenital malformation registered in cycle>birth> congenital malformation, then 1, otherwise 0 |
| HJ | Baby_Baby2_Malformation | if baby 2 has a congenital malformation registered in cycle>birth> congenital malformation, then 1, otherwise 0 |
| HK | Baby_Baby3_Malformation | if baby 3 has a congenital malformation registered in cycle>birth> congenital malformation, then 1, otherwise 0 |
| HL | Baby_Baby4_Malformation | if baby 4 has a congenital malformation registered in cycle>birth> congenital malformation, then 1, otherwise 0 |
| HM | Baby_Baby1_Sex | baby 1 sex, 2 male 3 female(0 for not recorded or male-female) |
| HN | Baby_Baby2_Sex | baby 2 sex, 2 male 3 female(0 for not recorded or male-female) |
| HO | Baby_Baby3_Sex | baby 3 sex, 2 male 3 female(0 for not recorded or male-female) |
| HP | Baby_Baby4_Sex | baby 4 sex, 2 male 3 female(0 for not recorded or male-female) |
| HQ | Baby_Baby1_Statusdischarge | Child number 1: from:rd$kind_zustand, if congenital information = 0 and has not postpardum death date, and has no parental death date and status is 2 THEN 2 #If status if 4 then 3 #if the baby has a postpadum death date, and a birth date: --#if the baby died within 6 days from birth then 4 --#if the baby died after more than or equal 7 days and less than or equal 28 days then 5 #if the baby has no registered death date in postpardum and parental death dates fields, and he/she has a congenital malformation value registered, then 6 #otherwise 0 |
| HR | Baby_Baby2_Statusdischarge | Child number 2: from:rd$kind_zustand, if congenital information = 0 and has not postpardum death date, and has no parental death date and status is 2 THEN 2 #If status if 4 then 3 #if the baby has a postpadum death date, and a birth date: --#if the baby died within 6 days from birth then 4 --#if the baby died after more than or equal 7 days and less than or equal 28 days then 5 #if the baby has no registered death date in postpardum and parental death dates fields, and he/she has a congenital malformation value registered, then 6 #otherwise 0 |
| HS | Baby_Baby3_Statusdischarge | Child number 3: from:rd$kind_zustand, if congenital information = 0 and has not postpardum death date, and has no parental death date and status is 2 THEN 2 #If status if 4 then 3 #if the baby has a postpadum death date, and a birth date: --#if the baby died within 6 days from birth then 4 --#if the baby died after more than or equal 7 days and less than or equal 28 days then 5 #if the baby has no registered death date in postpardum and parental death dates fields, and he/she has a congenital malformation value registered, then 6 #otherwise 0 |
| HT | Baby_Baby4_Statusdischarge | Child number 4: from:rd$kind_zustand, if congenital information = 0 and has not postpardum death date, and has no parental death date and status is 2 THEN 2 #If status if 4 then 3 #if the baby has a postpadum death date, and a birth date: --#if the baby died within 6 days from birth then 4 --#if the baby died after more than or equal 7 days and less than or equal 28 days then 5 #if the baby has no registered death date in postpardum and parental death dates fields, and he/she has a congenital malformation value registered, then 6 #otherwise 0 |
| HU | NBEmbryosTransported | 0 const |
| HV | EdorexCoupleId | "" empty string |
| HW | DataCorrection | "" empty string |
| HX | ReasonForEmbryoCryoOtherDesc | "" empty string |
| HY | TreatmentAfterTransferOtherDesc | "" empty string |
| I | LIVING_IN | Female Country(in demographics) |
| J | LIVING_IN_CH | 1 for living in CH, 0 for not living in CH |
| K | CycleKind | if thawing exists then 1, if not then 2 |
| L | YEAR_DECLAR_FIVNAT | start date of cycle or aspiration date |
| M | CycleStatus | empty string |
| N | reserved | empty string |
| O | reserved | empty string |
| P | reserved | empty string |
| Q | reserved | empty string |
| R | reserved | empty string |
| S | reserved | empty string |
| T | reserved | empty string |
| U | reserved | empty string |
| V | reserved | empty string |
| W | INFERT_FEM_KIND | infertility type _ Female (female medical history > Fertility > Infertility type): 1=primary , 2 =secondary 99 = other) |
| X | INFERT_MAN_KIND | infertility type _ Male (male medical history > General > Infertility type) : 1=primary , 2 =secondary 99 = other) |
| Y | IVF_DECLARED_ATTEMPT_NB | female medical history > basic > previouse treatments group > number of ivf-icsi treatments + current therapie number |
| Z | IVF_ABORT_NB | female medical history > basic > Right below previouse treatments group(red line) abort number |