FIVNAT Fresh and Cryo Cycles
From MedITEX - Wiki
(Difference between revisions)
                                                
            | Line 7: | Line 7: | ||
| </tr> | </tr> | ||
| <tr> | <tr> | ||
| − | <td | + | <td>A</td> | 
| − | <td | + | <td>reserved</td> | 
| <td>empty</td> | <td>empty</td> | ||
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AA</td> | 
| − | <td  | + | <td>IVF_DELIV_NB</td> | 
| − | <td  | + | <td>female medical history > basic > Right below previouse   treatments group(red line) gravida number</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AB</td> | 
| − | <td  | + | <td>IVF_EUP_NB</td> | 
| − | <td  | + | <td>female medical history > basic > Right below previouse   treatments group(red line) ectopics number</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AC</td> | 
| − | <td  | + | <td>ParticularFemalePathology01</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AD</td> | 
| − | <td  | + | <td>ParticularFemalePathology02</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AE</td> | 
| − | <td  | + | <td>ParticularFemalePathology03</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AF</td> | 
| − | <td  | + | <td>ParticularFemalePathology04</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AG</td> | 
| − | <td  | + | <td>ParticularFemalePathology05</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AH</td> | 
| − | <td  | + | <td>ParticularFemalePathology06</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AI</td> | 
| − | <td  | + | <td>ParticularFemalePathology07</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AJ</td> | 
| − | <td  | + | <td>ParticularFemalePathology08</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AK</td> | 
| − | <td  | + | <td>ParticularFemalePathology09</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AL</td> | 
| − | <td  | + | <td>ParticularFemalePathology10</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AM</td> | 
| − | <td  | + | <td>ParticularFemalePathology11</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AN</td> | 
| − | <td  | + | <td>ParticularFemalePathology12</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AO</td> | 
| − | <td  | + | <td>ParticularFemalePathology13</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AP</td> | 
| − | <td  | + | <td>ParticularFemalePathology14</td> | 
| − | <td  | + | <td>Medical history female>stirility factors   (rd$hauptindikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AQ</td> | 
| − | <td  | + | <td>ParticularFemalePathology15</td> | 
| − | <td  | + | <td>if its non of the above and the free text is filled then   "1" otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AR</td> | 
| − | <td  | + | <td>Spermiogram1</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AS</td> | 
| − | <td  | + | <td>Spermiogram2</td> | 
| − | <td  | + | <td>rd$andro_diagnose , if 6 is selected then 1 otherwise 0(in   sperm analysis>diagnosis)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AT</td> | 
| − | <td  | + | <td>Spermiogram3</td> | 
| − | <td  | + | <td>rd$andro_diagnose , if 7 is selected then 1 otherwise 0(in   sperm analysis>diagnosis)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AU</td> | 
| − | <td  | + | <td>Spermiogram4</td> | 
| − | <td  | + | <td>rd$andro_diagnose , if 8 is selected then 1 otherwise 0(in   sperm analysis>diagnosis)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AV</td> | 
| − | <td  | + | <td>Spermiogram5</td> | 
| − | <td  | + | <td>rd$andro_diagnose , if 3 is selected then 1 otherwise 0(in   sperm analysis>diagnosis)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AW</td> | 
| − | <td  | + | <td>Spermiogram6</td> | 
| − | <td  | + | <td>rd$andro_diagnose , if 13 is selected then 1 otherwise 0(in   sperm analysis>diagnosis)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AX</td> | 
| − | <td  | + | <td>Spermiogram7</td> | 
| − | <td  | + | <td>if diagnosis isnt one of the above, then 0, otherwise, 1</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AY</td> | 
| − | <td  | + | <td>Spermiogram8</td> | 
| − | <td  | + | <td>if sperm sample 1 diuagnosis isnt selected, then 1, otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>AZ</td> | 
| − | <td  | + | <td>Pathol_Other_Male1</td> | 
| − | <td  | + | <td>same as female AB,AC… but with Male medical history >   general> fetility imparement factors (rd$androl_indikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>B</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>empty</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BA</td> | 
| − | <td  | + | <td>Pathol_Other_Male2</td> | 
| − | <td  | + | <td>same as female AB,AC… but with Male medical history >   general> fetility imparement factors</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BB</td> | 
| − | <td  | + | <td>Pathol_Other_Male3</td> | 
| − | <td  | + | <td>same as female AB,AC… but with Male medical history >   general> fetility imparement factors</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BC</td> | 
| − | <td  | + | <td>Pathol_Other_Male4</td> | 
| − | <td  | + | <td>If male medical history > general > chromosom analysis   is 3 then this value is 1 (rd$chromosomenanalyse)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BD</td> | 
| − | <td  | + | <td>Pathol_Other_Male5</td> | 
| − | <td  | + | <td>same as bc but for --->general Cftr -carrier  - rd$cftrtrigger (if its 2 then 1)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BE</td> | 
| − | <td  | + | <td>Pathol_Other_Male6</td> | 
| − | <td  | + | <td>same as AZ for males</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BF</td> | 
| − | <td  | + | <td>Pathol_Other_Male7</td> | 
| − | <td  | + | <td>same as female AB,AC… but with Male medical history >   general> fetility imparement factors (rd$androl_indikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BG</td> | 
| − | <td  | + | <td>Pathol_Other_Male8</td> | 
| − | <td  | + | <td>same as female AB,AC… but with Male medical history >   general> fetility imparement factors (rd$androl_indikation)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BH</td> | 
| − | <td  | + | <td>Pathol_Other_Male9</td> | 
| − | <td  | + | <td>if non of the above and text field is filled, then 1</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BI</td> | 
| − | <td  | + | <td>INFERT_START_YEAR</td> | 
| − | <td  | + | <td>female medical history > basic > unprotected intercorse   since > year</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BJ</td> | 
| − | <td  | + | <td>IVF_INDICATION01</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)100</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BK</td> | 
| − | <td  | + | <td>IVF_INDICATION02</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)101</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BL</td> | 
| − | <td  | + | <td>IVF_INDICATION03</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)102</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BM</td> | 
| − | <td  | + | <td>IVF_INDICATION04</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)103</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BN</td> | 
| − | <td  | + | <td>IVF_INDICATION05</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)104</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BO</td> | 
| − | <td  | + | <td>IVF_INDICATION06</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)105</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BP</td> | 
| − | <td  | + | <td>IVF_INDICATION07</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)106</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BQ</td> | 
| − | <td  | + | <td>IVF_INDICATION08</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)107</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BR</td> | 
| − | <td  | + | <td>IVF_INDICATION09</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)108</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BS</td> | 
| − | <td  | + | <td>IVF_INDICATION10</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)109</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BT</td> | 
| − | <td  | + | <td>IVF_INDICATION11</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)110</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BU</td> | 
| − | <td  | + | <td>IVF_INDICATION12</td> | 
| − | <td  | + | <td>Cycle information > main indikation (rd$hauptindikation)111</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BV</td> | 
| − | <td  | + | <td>Import_Date</td> | 
| − | <td  | + | <td>"" empty string</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BW</td> | 
| − | <td  | + | <td>OOCYTES_IMPORT</td> | 
| − | <td  | + | <td>0  const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BX</td> | 
| − | <td  | + | <td>ZYGOTES_IMPORT</td> | 
| − | <td  | + | <td>0  const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BY</td> | 
| − | <td  | + | <td>EMBRYOS_IMPORT</td> | 
| − | <td  | + | <td>0  const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>BZ</td> | 
| − | <td  | + | <td>Cycle_fert_techn_plan</td> | 
| − | <td  | + | <td>planned cycle 1 ,2 3</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>C</td> | 
| − | <td  | + | <td>FIVNATID</td> | 
| − | <td  | + | <td>empty</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CA</td> | 
| − | <td  | + | <td>stimul_start_date</td> | 
| − | <td  | + | <td>First stimulation drug date(cycle > over view >   medication > smallest stimulation drug date)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CB</td> | 
| − | <td  | + | <td>Protocol</td> | 
| − | <td  | + | <td>cycle information> stimulation   protocole(rd$stimulation_protocole)100=1,101=2,102=4,else and not null =   3  ,0 for null</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CC</td> | 
| − | <td  | + | <td>GnRHAgonist</td> | 
| − | <td  | + | <td>if a medikation of type =6 (from t_medik_bereich) then 1   otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CD</td> | 
| − | <td  | + | <td>GnRHAntagonist</td> | 
| − | <td  | + | <td>if a medikation of type =7 (from t_medik_bereich) then 1   otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CE</td> | 
| − | <td  | + | <td>stimul_follic_growth1</td> | 
| − | <td  | + | <td>no stimulation drug is selected = 1, stimulation select =0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CF</td> | 
| − | <td  | + | <td>stimul_follic_growth2</td> | 
| − | <td  | + | <td>if a medikation of type =5 (from t_medik_bereich) then 1   otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CG</td> | 
| − | <td  | + | <td>stimul_follic_growth3</td> | 
| − | <td  | + | <td>if a medikation of type =3 (from t_medik_bereich) then 1   otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CH</td> | 
| − | <td  | + | <td>stimul_follic_growth4</td> | 
| − | <td  | + | <td>if a medikation of type =2 (from t_medik_bereich) then 1   otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CI</td> | 
| − | <td  | + | <td>stimul_follic_growth5</td> | 
| − | <td  | + | <td>if a medikation of type =1 (from t_medik_bereich) then 1   otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CJ</td> | 
| − | <td  | + | <td>stimul_follic_growth6</td> | 
| − | <td  | + | <td>if a medikation of type =4 (from t_medik_bereich) then 1   otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CK</td> | 
| − | <td  | + | <td>stimul_follic_growth7</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CL</td> | 
| − | <td  | + | <td>stimul_follic_growth8</td> | 
| − | <td  | + | <td>if stimulation date exists, and type does not belong to the   above cases, then 1 otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CM</td> | 
| − | <td  | + | <td>stimul_failure</td> | 
| − | <td  | + | <td>if cycle is canceled, then 1, otherwise 0. In cycle overview,   right click on the event, Cancel before treatment.</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CN</td> | 
| − | <td  | + | <td>stimul_failure_reason</td> | 
| − | <td  | + | <td>1 if cycle was cancled, 0 if cycle is still active</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CO</td> | 
| − | <td  | + | <td>OPU_Date</td> | 
| − | <td  | + | <td>cycle information > aspiration date</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CP</td> | 
| − | <td  | + | <td>OPU_OOCYTES_COLLECTED</td> | 
| − | <td  | + | <td>oocytes collected in aspiration</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CQ</td> | 
| − | <td  | + | <td>FERT_TECHNIQUE</td> | 
| − | <td  | + | <td>ferilation technique( can be 1,2,3,4,0)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CR</td> | 
| − | <td  | + | <td>OPU_OOCYTES_M2</td> | 
| − | <td  | + | <td>Kulture M2 cells count</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CS</td> | 
| − | <td  | + | <td>OPU_OOCYTES_M1</td> | 
| − | <td  | + | <td>Kulture M1cells count</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CT</td> | 
| − | <td  | + | <td>OPU_OOCYTES_GV</td> | 
| − | <td  | + | <td>Kulture GV cells count</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CU</td> | 
| − | <td  | + | <td>OriginOfSperm_OriginOfSperm1</td> | 
| − | <td  | + | <td>if one of the first two sperm samples used in the cycle is not   donated then 1, otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CV</td> | 
| − | <td  | + | <td>OriginOfSperm_OriginOfSperm2</td> | 
| − | <td  | + | <td>if one of the first two sperm samples used in the cycle is   donated then 1, otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CW</td> | 
| − | <td  | + | <td>OriginOfSperm_OriginOfSperm21</td> | 
| − | <td  | + | <td>if one of the first two sperm samples used in the cycle is   thawed then 1, otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CX</td> | 
| − | <td  | + | <td>OriginOfSperm_OriginOfSperm22</td> | 
| − | <td  | + | <td>if one of the first two sperm samples used in the cycle is not   thawed then 1, otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CY</td> | 
| − | <td  | + | <td>OriginOfSperm_OriginOfSperm31</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>CZ</td> | 
| − | <td  | + | <td>OriginOfSperm_OriginOfSperm32</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>D</td> | 
| − | <td  | + | <td>CenterID</td> | 
| − | <td  | + | <td>Clinic ID in settings > Clinic</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DA</td> | 
| − | <td  | + | <td>OriginOfSperm_OriginOfSperm33</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DB</td> | 
| − | <td  | + | <td>OriginOfSperm_OriginOfSperm34</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DC</td> | 
| − | <td  | + | <td>OPU_INSEM_OOCYTES</td> | 
| − | <td  | + | <td>The total number of OOCtyes inseminated with ivf or   icsi(kultur)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DD</td> | 
| − | <td  | + | <td>CryopreservationOfOocytes_Oocytes_Slowfreezing_Nb</td> | 
| − | <td  | + | <td>number of thawed oocytes that were perserved by slowfreezing</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DE</td> | 
| − | <td  | + | <td>CryopreservationOfOocytes_Oocytes_Vitrification_Nb</td> | 
| − | <td  | + | <td>number of thawed oocytes that were perserved by vitrification</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DF</td> | 
| − | <td  | + | <td>NBOocytesDestroyed</td> | 
| − | <td  | + | <td>Lost oocytes from thawed/fresh(kultur)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DG</td> | 
| − | <td  | + | <td>Day1_nonfert_Nb</td> | 
| − | <td  | + | <td>total number of day1 fresh oocytes that have no treatment on   day 1 or 2</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DH</td> | 
| − | <td  | + | <td>Day1_zygotes1PN_Nb</td> | 
| − | <td  | + | <td>total number of fresh 1pn cells avaalable within day 1 in the   cycle</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DI</td> | 
| − | <td  | + | <td>Day1_zygotes2PN_Nb</td> | 
| − | <td  | + | <td>total number of fresh 2pn cells avaalable within day 1 in the   cycle</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DJ</td> | 
| − | <td  | + | <td>Day1_zygotes3PN_Nb</td> | 
| − | <td  | + | <td>total number of fresh 3pn cells avaalable within day 1 in the   cycle</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DK</td> | 
| − | <td  | + | <td>NbOfZygotesCryopreser_zygotes_Slowfreezing_Nb</td> | 
| − | <td  | + | <td>number of thawed PNs that were perserved by slowfreezing</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DL</td> | 
| − | <td  | + | <td>NbOfZygotesCryopreser_zygotes_Vitrification_Nb</td> | 
| − | <td  | + | <td>number of thawed PNs that were perserved by vitrification</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DM</td> | 
| − | <td  | + | <td>NbZygotesleftinculture</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DN</td> | 
| − | <td  | + | <td>NbZygotesDestroyed</td> | 
| − | <td  | + | <td>number of pns destroyed.    coalesce(SEIVFLOST,0) + coalesce(SEIVFLOSTPNAT,0) +   coalesce(SEICSILOST,0) + coalesce(SEICSILOSTPNAT,0))<br /></td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DO</td> | 
| − | <td  | + | <td>TotalNbEmbryos_day2</td> | 
| − | <td  | + | <td>total fresh embryos within day 2 of cultur</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DP</td> | 
| − | <td  | + | <td>CryopreservationOfEmbryos_embryos_Slowfreezing_Nb</td> | 
| − | <td  | + | <td>number of thawed embryos that were perserved by slowfreezing</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DQ</td> | 
| − | <td  | + | <td>CryopreservationOfEmbryos_embryos_Vitrification_Nb</td> | 
| − | <td  | + | <td>number of thawed embryos that were perserved by vitrification</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DR</td> | 
| − | <td  | + | <td>ReasonForEmbryoCryo</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DS</td> | 
| − | <td  | + | <td>EMBR_INTRA_VAG_NB</td> | 
| − | <td  | + | <td>No. intrauterine in (cycle>pregnancy > No. intrauterine)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DT</td> | 
| − | <td  | + | <td>EMBR_DESTR_NB</td> | 
| − | <td  | + | <td>icsi and ivf embryos lost(in kultur)??</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DU</td> | 
| − | <td  | + | <td>EMBR_DESTR_REASON</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DV</td> | 
| − | <td  | + | <td>EMBR_RESEARCH_NB</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DW</td> | 
| − | <td  | + | <td>EMBR_RESEARCH_REASON</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DX</td> | 
| − | <td  | + | <td>TRANSFER</td> | 
| − | <td  | + | <td>if a cell transfer occurs in cultur, then 1, otherwise 0 </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DY</td> | 
| − | <td  | + | <td>transfer_cancelled</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>DZ</td> | 
| − | <td  | + | <td>ZygotesTransferred_IVF_NB</td> | 
| − | <td  | + | <td>total transferred ivf 2pns(ideal+nideal)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>E</td> | 
| − | <td  | + | <td>SubCenterID</td> | 
| − | <td  | + | <td>PRN in settings> Clinic</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EA</td> | 
| − | <td  | + | <td>ZygotesTransferred_ICSI_NB</td> | 
| − | <td  | + | <td>total transferred icsi 2pns(ideal+nideal)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EB</td> | 
| − | <td  | + | <td>EmbryosTransfer_IVF_NB</td> | 
| − | <td  | + | <td>total transferred ivf embryos(ideal+nideal)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EC</td> | 
| − | <td  | + | <td>EmbryosTransfer_ICSI_NB</td> | 
| − | <td  | + | <td>total transferred icsi embryos(ideal+nideal)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>ED</td> | 
| − | <td  | + | <td>Transfer_DATE</td> | 
| − | <td  | + | <td>main transfer date in(cycle > transfer > "date of   transfer" )</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EE</td> | 
| − | <td  | + | <td>TreatmentAfterTransfer</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EF</td> | 
| − | <td  | + | <td>TRANSF_COMPLIC_YES_NO</td> | 
| − | <td  | + | <td>if transfer complications are selected then 1, otherwise 0.</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EG</td> | 
| − | <td  | + | <td>TRANSF_COMPLIC_HOSP</td> | 
| − | <td  | + | <td>if "main complication" in (cycle>transfer) is 5   then1, if 6 then 2 otherwise 0(from rd$trans_complication)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EH</td> | 
| − | <td  | + | <td>TRANSF_COMPLIC_HOSP_CRYO</td> | 
| − | <td  | + | <td>if "main complication" in (cycle>transfer) is 7   or 14  then 1 otherwise 0 (from   rd$trans_complication)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EI</td> | 
| − | <td  | + | <td>TRANSF_COMPLIC_OTHER1</td> | 
| − | <td  | + | <td>8 (in female cycle>transfer > complications)from rd$   trans_complication </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EJ</td> | 
| − | <td  | + | <td>TRANSF_COMPLIC_OTHER2</td> | 
| − | <td  | + | <td>9 (in female cycle>transfer > complications)from rd$   trans_complication </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EK</td> | 
| − | <td  | + | <td>TRANSF_COMPLIC_OTHER3</td> | 
| − | <td  | + | <td>10 (in female cycle>transfer > complications)from rd$   trans_complication </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EL</td> | 
| − | <td  | + | <td>TRANSF_COMPLIC_OTHER4</td> | 
| − | <td  | + | <td>11 (in female cycle>transfer > complications)from rd$   trans_complication </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EM</td> | 
| − | <td  | + | <td>TRANSF_COMPLIC_OTHER5</td> | 
| − | <td  | + | <td>12 (in female cycle>transfer > complications)from rd$   trans_complication </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EN</td> | 
| − | <td  | + | <td>TRANSF_COMPLIC_OTHER6</td> | 
| − | <td  | + | <td>13 (in female cycle>transfer > complications)from rd$   trans_complication </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EO</td> | 
| − | <td  | + | <td>TRANSF_COMPLIC_OTHER7</td> | 
| − | <td  | + | <td>14 (in female cycle>transfer > complications)from rd$   trans_complication </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EP</td> | 
| − | <td  | + | <td>CYCLE_RESULT</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EQ</td> | 
| − | <td  | + | <td>ThawingOf1</td> | 
| − | <td  | + | <td>if PNs were thawed then 1 , otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>ER</td> | 
| − | <td  | + | <td>ThawingOf2</td> | 
| − | <td  | + | <td>if embryos were thawed then 1 , otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>ES</td> | 
| − | <td  | + | <td>ThawingOf3</td> | 
| − | <td  | + | <td>if oocytes were thawed then 1 , otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>ET</td> | 
| − | <td  | + | <td>DateOfLastMenstruation</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EU</td> | 
| − | <td  | + | <td>StimulationType</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EV</td> | 
| − | <td  | + | <td>OocytesCryoAnotherCenter</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EW</td> | 
| − | <td  | + | <td>ZygotesCryoAnotherCenter</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EX</td> | 
| − | <td  | + | <td>EmbryosCryoAnotherCenter</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EY</td> | 
| − | <td  | + | <td>DateOfThawing</td> | 
| − | <td  | + | <td>First female thawings date within the treatment</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>EZ</td> | 
| − | <td  | + | <td>NumberOfZygotesThawed</td> | 
| − | <td  | + | <td>total number of pns</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>F</td> | 
| − | <td  | + | <td>DynelyticsCoupleID</td> | 
| − | <td  | + | <td>Couple ID</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FA</td> | 
| − | <td  | + | <td>NumberOfzygotessurvived</td> | 
| − | <td  | + | <td>total surviving thawed pns</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FB</td> | 
| − | <td  | + | <td>Zygotes_Cryopreserved_Nb</td> | 
| − | <td  | + | <td>total cryoperserved pns within this therapie</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FC</td> | 
| − | <td  | + | <td>NumberOfEmbryosThawed</td> | 
| − | <td  | + | <td>total number of thawed embryos</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FD</td> | 
| − | <td  | + | <td>EMBR_DESTR_THAWING</td> | 
| − | <td  | + | <td>total Atrratic or lost embryos from thawing in this therapie(I   therapie >cryo thawing >atr/lost emb)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FE</td> | 
| − | <td  | + | <td>Embryos_Cryopreserved_Nb</td> | 
| − | <td  | + | <td>total number of cryoperserved embryos</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FF</td> | 
| − | <td  | + | <td>ReasonForEmbryoreCryo</td> | 
| − | <td  | + | <td>     #       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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FG</td> | 
| − | <td  | + | <td>NumberOfOOcytesThawed</td> | 
| − | <td  | + | <td>total number of thawed oocytes</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FH</td> | 
| − | <td  | + | <td>NumberOfsurvivingOOcytesThawed</td> | 
| − | <td  | + | <td>total number of surviving thawed oocytes</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FI</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>"     "(empty   string)    </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FJ</td> | 
| − | <td  | + | <td>destructionkind</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FK</td> | 
| − | <td  | + | <td>destructionOf1</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FL</td> | 
| − | <td  | + | <td>destructionOf2</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FM</td> | 
| − | <td  | + | <td>destructionOf3</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FN</td> | 
| − | <td  | + | <td>DateOfdestruct</td> | 
| − | <td  | + | <td>Null const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FO</td> | 
| − | <td  | + | <td>EMBR_DESTR_REASON_destruction</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FP</td> | 
| − | <td  | + | <td>ReasonForDestrOocytes</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FQ</td> | 
| − | <td  | + | <td>ReasonForDestrZygotes</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FR</td> | 
| − | <td  | + | <td>NBOocytesTransported</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FS</td> | 
| − | <td  | + | <td>NBZygotesTransported</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FT</td> | 
| − | <td  | + | <td>PREG_ECHOGRAPHY</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FU</td> | 
| − | <td  | + | <td>PREG_GEST_SACS_NB</td> | 
| − | <td  | + | <td>no. intrauterine + no.extrauterine,  in (cycle>pregnancy > No.   intrauterine&no.extrauterine)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FV</td> | 
| − | <td  | + | <td>PREG_FETUS_12w_NB</td> | 
| − | <td  | + | <td>no. intrauterine + no.extrauterine,  in (cycle>pregnancy > No.   intrauterine&no.extrauterine)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FW</td> | 
| − | <td  | + | <td>PREG_FETUS_REMOV_YES_NO</td> | 
| − | <td  | + | <td>if induced abortion is applied to at least one fetus, the 1,   otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FX</td> | 
| − | <td  | + | <td>PREG_FETUS_REMOV_NB</td> | 
| − | <td  | + | <td>total number of induced abortion fetusis.</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FY</td> | 
| − | <td  | + | <td>Preg_Result</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>FZ</td> | 
| − | <td  | + | <td>PREG_ABORT_DATE</td> | 
| − | <td  | + | <td>First abortion date</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>G</td> | 
| − | <td  | + | <td>BIRTHDATE_MAN</td> | 
| − | <td  | + | <td>Male Birthdate</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GA</td> | 
| − | <td  | + | <td>PREG_ABORT_DESCRIBE</td> | 
| − | <td  | + | <td>indications of abortion in Cycle>pregnacy> aborted   fetuses > indication of abortion(tinabort)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GB</td> | 
| − | <td  | + | <td>PREG_PATHOL_YES_NO</td> | 
| − | <td  | + | <td>if pregnancy complications exist then 1, otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GC</td> | 
| − | <td  | + | <td>PREG_PATHOL01</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GD</td> | 
| − | <td  | + | <td>PREG_PATHOL02</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GE</td> | 
| − | <td  | + | <td>PREG_PATHOL03</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GF</td> | 
| − | <td  | + | <td>PREG_PATHOL04</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GG</td> | 
| − | <td  | + | <td>PREG_PATHOL05</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GH</td> | 
| − | <td  | + | <td>PREG_PATHOL06</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GI</td> | 
| − | <td  | + | <td>PREG_PATHOL07</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GJ</td> | 
| − | <td  | + | <td>PREG_PATHOL08</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GK</td> | 
| − | <td  | + | <td>PREG_PATHOL09</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GL</td> | 
| − | <td  | + | <td>PREG_PATHOL10</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GM</td> | 
| − | <td  | + | <td>PREG_PATHOL11</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GN</td> | 
| − | <td  | + | <td>PREG_PATHOL12</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GO</td> | 
| − | <td  | + | <td>PREG_PATHOL13</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GP</td> | 
| − | <td  | + | <td>PREG_PATHOL14</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GQ</td> | 
| − | <td  | + | <td>PREG_PATHOL15</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GR</td> | 
| − | <td  | + | <td>PREG_PATHOL16</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GS</td> | 
| − | <td  | + | <td>PREG_PATHOL17</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GT</td> | 
| − | <td  | + | <td>PREG_PATHOL18</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GU</td> | 
| − | <td  | + | <td>PREG_PATHOL19</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GV</td> | 
| − | <td  | + | <td>PREG_PATHOL20</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GW</td> | 
| − | <td  | + | <td>PREG_PATHOL21</td> | 
| − | <td  | + | <td>rd$ss_koml_ab_.. If complication name is ?? Then 1 , otherwise   0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GX</td> | 
| − | <td  | + | <td>DELIV_MODE</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GY</td> | 
| − | <td  | + | <td>DELIV_DATE</td> | 
| − | <td  | + | <td>in cycle> birth> date of delivary , select the first   avaaille delivary date for the babies.</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>GZ</td> | 
| − | <td  | + | <td>DELIV_BABY_NB</td> | 
| − | <td  | + | <td>number of babies born, in cycle>birth overview>children</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>H</td> | 
| − | <td  | + | <td>BIRTHDATE_WOMAN</td> | 
| − | <td  | + | <td>Female Birthdate</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HA</td> | 
| − | <td  | + | <td>Baby_Baby1_BirthWeight</td> | 
| − | <td  | + | <td>first baby birth weight</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HB</td> | 
| − | <td  | + | <td>Baby_Baby2_BirthWeight</td> | 
| − | <td  | + | <td>second baby birth weight</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HC</td> | 
| − | <td  | + | <td>Baby_Baby3_BirthWeight</td> | 
| − | <td  | + | <td>third baby birth weight</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HD</td> | 
| − | <td  | + | <td>Baby_Baby4_BirthWeight</td> | 
| − | <td  | + | <td>fourth baby birth weight</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HE</td> | 
| − | <td  | + | <td>Baby_Baby1_MalfoDescribe</td> | 
| − | <td  | + | <td>icd10 description of baby 1 maformation condition (number 1)   in therapie > kultur> birth</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HF</td> | 
| − | <td  | + | <td>Baby_Baby2_MalfoDescribe</td> | 
| − | <td  | + | <td>icd10 description of baby 1 maformation condition (number 1)   in therapie > kultur> birth</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HG</td> | 
| − | <td  | + | <td>Baby_Baby3_MalfoDescribe</td> | 
| − | <td  | + | <td>icd10 description of baby 2 maformation condition (number 1)   in therapie > kultur> birth</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HH</td> | 
| − | <td  | + | <td>Baby_Baby4_MalfoDescribe</td> | 
| − | <td  | + | <td>icd10 description of baby 3 maformation condition (number 1)   in therapie > kultur> birth</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HI</td> | 
| − | <td  | + | <td>Baby_Baby1_Malformation</td> | 
| − | <td  | + | <td>if baby 1 has a congenital malformation registered in   cycle>birth> congenital malformation, then 1, otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HJ</td> | 
| − | <td  | + | <td>Baby_Baby2_Malformation</td> | 
| − | <td  | + | <td>if baby 2 has a congenital malformation registered in   cycle>birth> congenital malformation, then 1, otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HK</td> | 
| − | <td  | + | <td>Baby_Baby3_Malformation</td> | 
| − | <td  | + | <td>if baby 3 has a congenital malformation registered in   cycle>birth> congenital malformation, then 1, otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HL</td> | 
| − | <td  | + | <td>Baby_Baby4_Malformation</td> | 
| − | <td  | + | <td>if baby 4 has a congenital malformation registered in   cycle>birth> congenital malformation, then 1, otherwise 0</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HM</td> | 
| − | <td  | + | <td>Baby_Baby1_Sex</td> | 
| − | <td  | + | <td>baby 1 sex, 2 male 3 female(0 for not recorded or male-female)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HN</td> | 
| − | <td  | + | <td>Baby_Baby2_Sex</td> | 
| − | <td  | + | <td>baby 2 sex, 2 male 3 female(0 for not recorded or male-female)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HO</td> | 
| − | <td  | + | <td>Baby_Baby3_Sex</td> | 
| − | <td  | + | <td>baby 3 sex, 2 male 3 female(0 for not recorded or male-female)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HP</td> | 
| − | <td  | + | <td>Baby_Baby4_Sex</td> | 
| − | <td  | + | <td>baby 4 sex, 2 male 3 female(0 for not recorded or male-female)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HQ</td> | 
| − | <td  | + | <td>Baby_Baby1_Statusdischarge</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HR</td> | 
| − | <td  | + | <td>Baby_Baby2_Statusdischarge</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HS</td> | 
| − | <td  | + | <td>Baby_Baby3_Statusdischarge</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HT</td> | 
| − | <td  | + | <td>Baby_Baby4_Statusdischarge</td> | 
| − | <td  | + | <td>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> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HU</td> | 
| − | <td  | + | <td>NBEmbryosTransported</td> | 
| − | <td  | + | <td>0 const</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HV</td> | 
| − | <td  | + | <td>EdorexCoupleId</td> | 
| − | <td  | + | <td>"" empty string</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HW</td> | 
| − | <td  | + | <td>DataCorrection</td> | 
| − | <td  | + | <td>"" empty string</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HX</td> | 
| − | <td  | + | <td>ReasonForEmbryoCryoOtherDesc</td> | 
| − | <td  | + | <td>"" empty string</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>HY</td> | 
| − | <td  | + | <td>TreatmentAfterTransferOtherDesc</td> | 
| − | <td  | + | <td>"" empty string</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>I</td> | 
| − | <td  | + | <td>LIVING_IN</td> | 
| − | <td  | + | <td>Female Country(in demographics)</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>J</td> | 
| − | <td  | + | <td>LIVING_IN_CH</td> | 
| − | <td  | + | <td>1 for living in CH, 0 for not living in CH</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>K</td> | 
| − | <td  | + | <td>CycleKind</td> | 
| − | <td  | + | <td>if thawing exists then 1, if not then 2</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>L</td> | 
| − | <td  | + | <td>YEAR_DECLAR_FIVNAT</td> | 
| − | <td  | + | <td>start date of cycle or aspiration date</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>M</td> | 
| − | <td  | + | <td>CycleStatus</td> | 
| − | <td  | + | <td>empty string ''</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>N</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>empty string ''</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>O</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>empty string ''</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>P</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>empty string ''</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>Q</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>empty string ''</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>R</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>empty string ''</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>S</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>empty string ''</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>T</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>empty string ''</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>U</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>empty string ''</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>V</td> | 
| − | <td  | + | <td>reserved</td> | 
| − | <td  | + | <td>empty string ''</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>W</td> | 
| − | <td  | + | <td>INFERT_FEM_KIND</td> | 
| − | <td  | + | <td>infertility type _ Female (female medical history >   Fertility > Infertility type): 1=primary , 2 =secondary 99 = other) </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>X</td> | 
| − | <td  | + | <td>INFERT_MAN_KIND</td> | 
| − | <td  | + | <td>infertility type _ Male (male medical history > General   > Infertility type) : 1=primary , 2 =secondary 99 = other) </td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>Y</td> | 
| − | <td  | + | <td>IVF_DECLARED_ATTEMPT_NB</td> | 
| − | <td  | + | <td>female medical history > basic > previouse treatments   group > number of ivf-icsi treatments +    current therapie number</td> | 
| </tr> | </tr> | ||
| − | <tr  | + | <tr> | 
| − | <td  | + | <td>Z</td> | 
| − | <td  | + | <td>IVF_ABORT_NB</td> | 
| − | <td  | + | <td>female medical history > basic > Right below previouse   treatments group(red line) abort number</td> | 
| </tr> | </tr> | ||
| </tbody> | </tbody> | ||
| </table> | </table> | ||
Revision as of 11:57, 24 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 |