FIVNAT Fresh and Cryo Cycles

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 2: Line 2:
 
<tbody>
 
<tbody>
 
<tr height="21">
 
<tr height="21">
−
<td class="xl71" style="text-align: center;" width="64" height="21"><span style="text-decoration: underline;"><strong><span class="font7">Pos</strong></td>
+
<td class="xl71" style="text-align: center;" width="64" height="21"><span style="text-decoration: underline;"><strong><span class="font7">Pos</span></strong></span></td>
−
<td class="xl72" style="text-align: center;" width="181"><span style="text-decoration: underline;"><strong>Field Name</strong></td>
+
<td class="xl72" style="text-align: center;" width="181"><span style="text-decoration: underline;"><strong>Field Name</strong></span></td>
−
<td class="xl73" style="text-align: center;" width="424"><span style="text-decoration: underline;"><strong>Fresh  Cycles Value</strong></td>
+
<td class="xl73" style="text-align: center;" width="424"><span style="text-decoration: underline;"><strong>Fresh  Cycles Value</strong></span></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 134: Line 134:
 
<td class="xl81" width="64">AY</td>
 
<td class="xl81" width="64">AY</td>
 
<td class="xl82" width="181">Spermiogram8</td>
 
<td class="xl82" width="181">Spermiogram8</td>
−
<td >if sperm sample 1 diuagnosis isnt  selected, then 1, otherwise 0</td>
+
<td>if sperm sample 1 diuagnosis isnt  selected, then 1, otherwise 0</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 539: Line 539:
 
<td class="xl81" width="64" height="140">DY</td>
 
<td class="xl81" width="64" height="140">DY</td>
 
<td class="xl91" width="181">transfer_cancelled</td>
 
<td class="xl91" width="181">transfer_cancelled</td>
−
<td >#If no female sample thawing took  place and if therapie is cancled for "Punctur failed"1100 then 1,  if "Fertalization failed" 101 then 2 , if "Cell Devision  failior"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>
+
<td>#If no female sample thawing took  place and if therapie is cancled for "Punctur failed"1100 then 1,  if "Fertalization failed" 101 then 2 , if "Cell Devision  failior"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>
Line 574: Line 574:
 
<td class="xl81" width="64" height="160">EE</td>
 
<td class="xl81" width="64" height="160">EE</td>
 
<td class="xl82" width="181">TreatmentAfterTransfer</td>
 
<td class="xl82" width="181">TreatmentAfterTransfer</td>
−
<td >#If a drug used in the&nbsp; treamtnet is of type:<br /> "Progesterone"then 2<br /> "rechCG" then 4<br /> " Estrogen" then 5<br /> &nbsp;#If a Medication is used within the  lutheal phase, and it doesn&rsquo;t belong to the above conditions then 6.<br /> #if no medication is used then 1<br /> #3?</td>
+
<td>#If a drug used in the&nbsp; treamtnet is of type:<br /> "Progesterone"then 2<br /> "rechCG" then 4<br /> " Estrogen" then 5<br /> &nbsp;#If a Medication is used within the  lutheal phase, and it doesn&rsquo;t belong to the above conditions then 6.<br /> #if no medication is used then 1<br /> #3?</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 649: Line 649:
 
<td class="xl81" width="64" height="60">ET</td>
 
<td class="xl81" width="64" height="60">ET</td>
 
<td class="xl82" width="181">DateOfLastMenstruation</td>
 
<td class="xl82" width="181">DateOfLastMenstruation</td>
−
<td >if it&rsquo;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 is selected  instead</td>
+
<td>if it&rsquo;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 is selected  instead</td>
 
</tr>
 
</tr>
 
<tr height="100">
 
<tr height="100">
 
<td class="xl81" width="64" height="100">EU</td>
 
<td class="xl81" width="64" height="100">EU</td>
 
<td class="xl82" width="181">StimulationType</td>
 
<td class="xl82" width="181">StimulationType</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>
+
<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 height="80">
 
<tr height="80">
Line 809: Line 809:
 
<td height="440">FY</td>
 
<td height="440">FY</td>
 
<td>Preg_Result</td>
 
<td>Preg_Result</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<br /> &nbsp;the miscarriage (in  cycle&gt;pregnancy)&nbsp; and the time  between the <br /> cilinical pregnancy detection date and the miscarage date is between <br /> 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 &gt;0 and <span class="font8">intertwine<span class="font0"> =0 then 4<br /> <br /> when cases 1,2 ,3 and 4 are not satisfied, and extertwine &gt;0 and <span class="font8">intertwine<span class="font0"> &gt;0 then 5 <br /> <br /> when previouse cases are not satisfied and induced abortion is set for at  least one of <br /> the embryos then 6<br /> <br /> if all previouse cases are not satisfied, then 7</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<br /> &nbsp;the miscarriage (in  cycle&gt;pregnancy)&nbsp; and the time  between the <br /> cilinical pregnancy detection date and the miscarage date is between <br /> 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 &gt;0 and <span class="font8">intertwine<span class="font0"> =0 then 4<br /> <br /> when cases 1,2 ,3 and 4 are not satisfied, and extertwine &gt;0 and <span class="font8">intertwine<span class="font0"> &gt;0 then 5 <br /> <br /> when previouse cases are not satisfied and induced abortion is set for at  least one of <br /> the embryos then 6<br /> <br /> if all previouse cases are not satisfied, then 7</span></span></span></span></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 834: Line 834:
 
<td class="xl81" width="64">GC</td>
 
<td class="xl81" width="64">GC</td>
 
<td class="xl91" width="181">PREG_PATHOL01</td>
 
<td class="xl91" width="181">PREG_PATHOL01</td>
−
<td >rd$ss_koml_ab_.. If complication  name is ?? Then 1 , otherwise 0</td>
+
<td>rd$ss_koml_ab_.. If complication  name is ?? Then 1 , otherwise 0</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 979: Line 979:
 
<td>HE</td>
 
<td>HE</td>
 
<td>Baby_Baby1_MalfoDescribe</td>
 
<td>Baby_Baby1_MalfoDescribe</td>
−
<td >icd10 description of baby 1  maformation condition (number 1) in therapie &gt; kultur&gt; birth</td>
+
<td>icd10 description of baby 1  maformation condition (number 1) in therapie &gt; kultur&gt; birth</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 1,064: Line 1,064:
 
<td>HV</td>
 
<td>HV</td>
 
<td>EdorexCoupleId</td>
 
<td>EdorexCoupleId</td>
−
<td >"" empty string</td>
+
<td>"" empty string</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>

Revision as of 14:02, 13 August 2015

<tbody> </tbody>
Pos Field Name Fresh Cycles Value
A reserved empty
AA IVF_DELIV_NB In) Female medical history > basic >
      Right below previouse treatments group(red line) >
      Gravida #
AB IVF_EUP_NB In) Female medical history > basic >
       Right below previouse treatments group(red line) >
       Ectopic #
AC ParticularFemalePathology01 In) Medical history female> Basic >
      Sterility factors>(if "none" is selected then 1, otherwise 0)  
AD ParticularFemalePathology02 In) Medical history female> Basic >Sterility factors
      (if "EndometriosisIorII" is selected then 1, otherwise 0)
AE ParticularFemalePathology03 In) Medical history female> Basic >Sterility factors>
      (if "EndometriosisIIIorIV" is selected then 1, otherwise 0)
AF ParticularFemalePathology04 In) Medical history female> Basic >Sterility factors>
      (if "TubePathology" is selected then 1, otherwise 0)
AG ParticularFemalePathology05 In) Medical history female> Basic >Sterility factors>
      (if "WombFibrosis" is selected then 1, otherwise 0)
AH ParticularFemalePathology06 In) Medical history female> Basic >Sterility factors>
      (if "MalformationOfTheWomb" is selected then 1, otherwise 0)
AI ParticularFemalePathology07 In) Medical history female> Basic >Sterility factors>
      (if "ChronicAnovulationPCOS" is selected then 1, otherwise 0)
AJ ParticularFemalePathology08 In) Medical history female> Basic >Sterility factors>
      (if "HypogonadotropicOvarianInsufficienc yWHOIII" is selected
     then 1, otherwise 0)
AK ParticularFemalePathology09 In) Medical history female> Basic >Sterility factors>
      (if "HypogonadotropicOvarianInsufficienc yWHOI" is selected
      then 1, otherwise 0)
AL ParticularFemalePathology10 In) Medical history female> Basic >Sterility factors>
      (if "MalignantChangeOfTheFemaleFenitalTract" is selected then 1, otherwise 0)
AM ParticularFemalePathology11 In) Medical history female> Basic >Sterility factors>
      (if "ReappearingMiscarriage" is selected then 1, otherwise 0)
AN ParticularFemalePathology12 In) Medical history female> Basic >Sterility factors>
      (if "ThyroidDisease" is selected then 1, otherwise 0)
AO ParticularFemalePathology13 In) Medical history female> Basic >Sterility factors>
      (if "DiabetesMellitusIorII" is selected then 1, otherwise 0)
AP ParticularFemalePathology14 In) Medical history female> Basic >Sterility factors>
      (if "BreastCancer" is selected then 1, otherwise 0)
AQ ParticularFemalePathology15 In) Medical history female> Basic >Sterility factors>
      (if its non of the above and the free text is filled then 1 otherwise 0)
AR Spermiogram1 In) Cycle>cultur>treatment sperm (any of the first 2 added and used)>sperm analysis>diagnosis
     (If "Normozoospermia" is selected then 1 otherwise 0 )
AS Spermiogram2 In) Cycle>cultur>treatment sperm(any of the first 2 added and used)>sperm analysis>diagnosis
     (If "Oligozoospermia" is selected then 1 otherwise 0 )
AT Spermiogram3 In) Cycle>cultur>treatment sperm(any of the first 2 added and used)>sperm analysis>diagnosis
      (If "Asthenozoospermia" is selected then 1 otherwise 0 )
AU Spermiogram4 In) Cycle>cultur>treatment sperm(any of the first 2 added and used)>sperm analysis>diagnosis
      (If "Teratozoospermia" is selected then 1 otherwise 0 )
AV Spermiogram5 In) Cycle>cultur>treatment sperm(any of the first 2 added and used)> sperm analysis>diagnosis
      (If "Azoospermia" is selected then 1 otherwise 0 )
AW Spermiogram6 In) Cycle>cultur>treatment sperm(any of the first 2 added and used)>sperm analysis>diagnosis
     (If "Kryptozoospermia" is selected then 1 otherwise 0 )
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 In) 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 In) Female medical history > basic >
       unprotected intercorse since > year
BJ IVF_INDICATION01 In) Cycle information > main indikation (if "Tubal" is selected then 1, otherwise 0)
BK IVF_INDICATION02 In) Cycle information > main indikation (if "AnovulationDysovulationPCOSyndrome" is selected then 1, otherwise 0)
BL IVF_INDICATION03 In) Cycle information > main indikation (if "Endometriosis" is selected then 1, otherwise 0)
BM IVF_INDICATION04 In) Cycle information > main indikation (if "MaleInfertility" is selected then 1, otherwise 0)
BN IVF_INDICATION05 In) Cycle information > main indikation (if "ImmunologicalInfertilityMale" is selected then 1, otherwise 0)
BO IVF_INDICATION06 In) Cycle information > main indikation (if "DonorSperm" is selected then 1, otherwise 0)
BP IVF_INDICATION07 In) Cycle information > main indikation (if "UnexplainedInfertility" is selected then 1, otherwise 0)
BQ IVF_INDICATION08 In) Cycle information > main indikation (if "GeneticalCauseOfTheInfertility" is selected then 1, otherwise 0)
BR IVF_INDICATION09 In) Cycle information > main indikation (if "PGD" is selected then 1, otherwise 0)
BS IVF_INDICATION10 In) Cycle information > main indikation (if "Hepatitis" is selected then 1, otherwise 0)
BT IVF_INDICATION11 In) Cycle information > main indikation (if "HIV" is selected then 1, otherwise 0)
BU IVF_INDICATION12 In) Cycle information > main indikation (if non of the above is selected then 1, otherwise 0)
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 In) Cycle > overview > medication ( smallest value out of stimulation-drugs dates)
CB Protocol In) Cycle > Overview >  Protocole ( Short Agonist=1, Long Agonist=2,Natural Cycle/ Modified Natural Cycle=4  ,0 for not selected, otherwise = 3)
CC GnRHAgonist In) Cycle> Overview > Medication (if a medikation of type "Gonatropin" exists then 1, otherwise 0)  (from t_medik_bereich)
CD GnRHAntagonist In) Cycle> Overview > Medication (if a medikation of type "CC" exists then 1, otherwise 0)
CE stimul_follic_growth1 no stimulation drug is selected = 1, stimulation select =0
CF stimul_follic_growth2 In) Cycle> Overview > Medication (if a medikation of type "GNRH-Antagonist" exists then 1, otherwise 0)
CG stimul_follic_growth3 In) Cycle> Overview > Medication (if a medikation of type "Pille" exists then 1, otherwise 0)
CH stimul_follic_growth4 In) Cycle> Overview > Medication (if a medikation of type "Pramedikation" exists then 1, otherwise 0)
CI stimul_follic_growth5 In) Cycle> Overview > Medication (if a medikation of type "Dauermedikation" exists then 1, otherwise 0)
CJ stimul_follic_growth6 In) Cycle> Overview > Medication (if a medikation of type "GNRH-Agonist" exists then 1, otherwise 0)
CK stimul_follic_growth7 0 const
CL stimul_follic_growth8 In) Cycle>overview>cycle details (If stimulation date exists, and type does not belong to the above cases, then 1 otherwise 0)
CM stimul_failure IF cycle is canceled (by right clicking on the event, Cancel before treatment), then 1, otherwise 0. In cycle overview.
CN stimul_failure_reason 1 if cycle was cancled, 0 if cycle is still active
CO OPU_Date In) Cycle > Aspiration > Aspiration date
CP OPU_OOCYTES_COLLECTED Cycke > aspiration > OOCytes collected
CQ FERT_TECHNIQUE In) Cycle > Overview >
                      if a treatment name exists in square brackates is IVF, then 1
 if treatment is ivf/icsi then 3
if treatment is icsi then : if tivm is 1 then 4, if not 1 then 2
CR OPU_OOCYTES_M2 in) Cycle > Kultur >  M2 cells count????
CS OPU_OOCYTES_M1 Kulture M1cells count
CT OPU_OOCYTES_GV Kulture GV cells count
CU OriginOfSperm_OriginOfSperm1 In) Cycle> Kultur> if one of the first two sperm samples used in the cycle is not donated then 1, otherwise 0
CV OriginOfSperm_OriginOfSperm2 In) Cycle> Kultur> if one of the first two sperm samples used in the cycle is donated then 1, otherwise 0
CW OriginOfSperm_OriginOfSperm21 In) Cycle> Kultur> if one of the first two sperm samples used in the cycle is thawed then 1, otherwise 0
CX OriginOfSperm_OriginOfSperm22 In) Cycle> Kultur> if one of the first two sperm samples used in the cycle is not thawed then 1, otherwise 0
CY OriginOfSperm_OriginOfSperm31 In) Cycle> Kultur> 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 In) Cycle> Kultur> 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 In) settings > Clinic > Clinic ID
DA OriginOfSperm_OriginOfSperm33 0 const
DB OriginOfSperm_OriginOfSperm34 0 const
DC OPU_INSEM_OOCYTES  In) Cycle > Kultur >Treatment >From Fol Aspiration > IVF + ICSI
      The total number of OOCtyes inseminated with ivf or icsi(kultur).
DD CryopreservationOfOocytes_Oocytes_Slowfreezing_Nb  In) Cycle > Kultur > number of thawed oocytes that were perserved by slowfreezing
DE CryopreservationOfOocytes_Oocytes_Vitrification_Nb In) Cycle > Kultur > number of thawed oocytes that were perserved by vitrification
DF NBOocytesDestroyed In)
(Cycle > Kultur > OOCytes (Atr.) )+(Cycle > Kultur > Treatment (Atretic.))
DG Day1_nonfert_Nb In) Cycle > Kultur > Graphical Representation > total number of day1 fresh oocytes that have no treatment on day 1 or 2
DH Day1_zygotes1PN_Nb In) Cycle > Kultur > Graphical Representation > total number of fresh 1pn cells available within day 1 in the cycle
DI Day1_zygotes2PN_Nb In) Cycle > Kultur > Graphical Representation > total number of fresh 2pn cells available within day 1 in the cycle
DJ Day1_zygotes3PN_Nb In) Cycle > Kultur > Graphical Representation > total number of fresh 3pn cells available within day 1 in the cycle
DK NbOfZygotesCryopreser_zygotes_Slowfreezing_Nb  In) Cycle > Kultur > number of thawed PNs that were perserved by slowfreezing
DL NbOfZygotesCryopreser_zygotes_Vitrification_Nb  In) Cycle > Kultur >  number of thawed PNs that were perserved by vitrification
DM NbZygotesleftinculture 0 const
DN NbZygotesDestroyed number of pns destroyed.
In) Cycle>Kultur > 2 PM Selection >
(2 PN from IVF: Discarded from fresh + Discarded from thawing)
+
(2 PN from ICSI: Discarded from fresh + Discarded from thawing)
DO TotalNbEmbryos_day2 In) Cycle > Kultur > Graphical Representation > total fresh embryos within day 2 of cultur
DP CryopreservationOfEmbryos_embryos_Slowfreezing_Nb In) Cycle > Kultur > Number of thawed embryos that were perserved by slowfreezing
DQ CryopreservationOfEmbryos_embryos_Vitrification_Nb In) Cycle > Kultur > number of thawed embryos that were perserved by vitrification
DR ReasonForEmbryoCryo If the database is:
#Italian:
for the cultur QM field's 'Motivo della crioconservazione' values, the corresponding number value 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
QM 'Motivo della distruzione'= 'Arresto evoluzione' then 1
QM 'Motivo della distruzione' = 'Potenziale sviluppo molto basso' then 2
QM 'Motivo della distruzione'= 'Volontà della coppia' then 3
QM 'Motivo della distruzione'= 'Altri motivia' then 4

#German
QM 'Grund für Embryoverwerfung' = 'Entwicklungsstop' then 1
QM 'Grund für Embryoverwerfung'= 'Sehr niedriges Entwicklungspotenzial' then 2
QM 'Grund für Embryoverwerfung' = 'Entscheidung des Paares' then 3
QM '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 In) Cycle> 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 "Punctur failed"1100 then 1, if "Fertalization failed" 101 then 2 , if "Cell Devision failior"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 In) Therapie > Transfer > total transferred ivf 2pns(ideal+nideal)
E SubCenterID PRN in settings> Clinic
EA ZygotesTransferred_ICSI_NB In) Therapie > Transfer > total transferred icsi 2pns(ideal+nideal)
EB EmbryosTransfer_IVF_NB In) Therapie > Transfer > total transferred ivf embryos(ideal+nideal)
EC EmbryosTransfer_ICSI_NB In) Therapie > Transfer > total transferred icsi embryos(ideal+nideal)
ED Transfer_DATE In) Cycle > transfer > "date of transfer" 
EE TreatmentAfterTransfer #If a drug used in the  treamtnet is of type:
"Progesterone"then 2
"rechCG" then 4
" Estrogen" then 5
 #If a Medication is used within the lutheal phase, and it doesn’t belong to the above conditions then 6.
#if no medication is used then 1
#3?
EF TRANSF_COMPLIC_YES_NO In) Cycle > Transfer > 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 in female cycle>transfer > complications > if the following value is selected as a complication "ambulantOhss" then 1 otherwise 0 
EJ TRANSF_COMPLIC_OTHER2 in female cycle>transfer > complications > if the following value is selected as a complication "peritonitis" then 1 otherwise 0 
EK TRANSF_COMPLIC_OTHER3 in female cycle>transfer > complications > if the following value is selected as a complication "hemoperitoneum" then 1 otherwise 0
EL TRANSF_COMPLIC_OTHER4 in female cycle>transfer > complications > if the following value is
selected as a complication "mentalSickness" then 1 otherwise 0 
EM TRANSF_COMPLIC_OTHER5 in female cycle>transfer > complications > if the following value is
selected as a complication "thromboembolism" then 1 otherwise 0 
EN TRANSF_COMPLIC_OTHER6 in female cycle>transfer > complications > if the following value is
selected as a complication "adnexalTorsion" then 1 otherwise 0 
EO TRANSF_COMPLIC_OTHER7 in female cycle>transfer > complications > if the following value is
selected as a complication "other" then 1 otherwise 0 
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 In) Cycle > Kultur > Thawing , if PNs were thawed then 1 , otherwise 0
ER ThawingOf2 In) Cycle > Kultur > Thawing , if embryos were thawed then 1 , otherwise 0
ES ThawingOf3 In) Cycle > Kultur > Thawing , 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 is selected instead
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