INFERTILITY_CYCLE
Description:
The INFERTILITY_CYCLE table contains information about fertility treatment cycles.

Primary Key
Column Name Ordinal Position
CYCLE_ID 1

Column Information
Name Type Discontinued?
1 CYCLE_ID NUMERIC No
The unique identifier for the fertility treatment cycle record.
2 CYCLE_NAME VARCHAR No
The fertility treatment cycle name.
3 RECORD_STATUS_C_NAME VARCHAR No
Stores the status (hidden, soft-deleted, etc.) of the Fertility cycle record.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
4 TREATMENT_TYPE_C_NAME VARCHAR No
The type of REI (Reproductive Endocrinology and Infertility) treatment the patient underwent. Options include ART (Assisted Reproductive Technology) and non-ART.
May contain organization-specific values: No
Category Entries:
Assisted Reproductive Technologies
Non-Assisted Reproductive Technologies
5 TREATMENT_START_DATE DATETIME No
The start date of the fertility treatment cycle is when the medication to stimulate follicular development is given, the first day of natural menses for unstimulated cycles, or when a patient receives steroids to prepare the endometrium for frozen cycles.
6 CYCLE_OUTCOME_C_NAME VARCHAR No
The outcome of the fertility treatment cycle.
May contain organization-specific values: No
Category Entries:
Pregnancy
No Pregnancy
No Transfer
Canceled
Completed
Cycle Created in Error
7 CYCLE_RESOLUTION_DATE DATETIME No
The outcome date of the fertility treatment cycle.
8 CYCLE_STATUS_C_NAME VARCHAR No
The status of the fertility treatment cycle.
May contain organization-specific values: No
Category Entries:
Active
Planning
Finished
Deleted
9 RECORD_CREATION_DT DATETIME No
The date the record was created.
10 CREATED_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
11 CANCEL_REASON_C_NAME VARCHAR No
The reason the fertility treatment was canceled.
May contain organization-specific values: Yes
Category Entries:
Low Response
High Response
Inadequate Endometrial Response
Concurrent Illness
Psychological
Financial
Family Emergency
Other
12 CANCEL_REASON_CMT VARCHAR No
Comment for the cycle cancellation reason.
13 COMPLICATIONS_CMT VARCHAR No
Comment for the cycle complications field.
14 EGGS_RETRIEVED_NUM INTEGER No
The number of eggs retrieved on the fertility cycle.
15 EGG_RETRIEVAL_DATE DATETIME No
The date the eggs were retrieved.
16 EMBRYO_NO_TRANSFER_RSN_C_NAME VARCHAR No
Reason for why an embryo wasn't transferred for the fertility treatment cycle.
May contain organization-specific values: Yes
Category Entries:
Inability to Obtain Sperm
Risk of Hyperstimulation
Preimplantation Genetic Testing
No Normal Oocytes/Embryos (after PGT results) Available for Future Use
No Normal Oocytes/Embryos (did not utilize PGT) Available for Future Use
Endometrial Receptivity Concerns
Failure to Survive Thaw
Planned Multiple Cycles (Egg/Embryo accumulation) with PGT
Planned Multiple Cycles (Egg/Embryo accumulation) without PGT
Low Ovarian Response
High Ovarian Response
Inadequate Endometrial Response
Concurrent Illness
Withdrawal Only for Personal Reasons
Insufficient Embryos
Intent for Freeze-All, Unspecific
No Embryos of Desired Sex
Thaw for Refreeze, No Intent to Transfer
Other
17 EMBRYO_NO_TRANSFER_RSN_CMT VARCHAR No
Comment for the no transfer reason field.
18 ESET_YN VARCHAR No
Whether the patient chose to do a single embryo transfer for this cycle.
May contain organization-specific values: No
Category Entries:
No
Yes
19 INSEMINATION_DATE DATETIME No
The date of insemination by intrauterine insemination or therapeutic donor insemination.
20 SPERM_COLLECT_METHOD_CMT VARCHAR No
Comment for the sperm collection methods field.
21 TREATMENT_REASONS_CMT VARCHAR No
Comment for the reasons for treatment field.
22 PREV_CYCLE_YN VARCHAR No
Flags if a cycle was documented retroactively. This should not be used to filter cycles for Society for Assisted Reproductive Technology (SART) reporting. This flag does not necessarily imply the department the cycle was created in is not responsible for the cycle's SART reporting.
The category values for this column were already listed for column: ESET_YN
23 CYCLE_LOC_C_NAME VARCHAR No
Location that owns the outcome of the cycle. This location would also be responsible for reporting this cycle to registries.
May contain organization-specific values: Yes
24 CYCLE_LOC_CMT VARCHAR No
Comment for the cycle location field.
25 TREATMENT_PLAN_PAST_DAYS_NUM INTEGER No
Number of days to look prior to the cycle start date to find medications that are relevant to this cycle's treatment.
26 TREATMENT_PLAN_FUTURE_DAYS_NUM INTEGER No
Number of days to look into the future to find medications that are relevant to this cycle's treatment.
27 EMBRYO_TRANSFER_NUMBER INTEGER No
Stores the number of embryos transferred during a cycle.
28 EMBRYO_TRANSFER_PROC_DATE DATETIME No
Stores the date of an embryo transfer for during a cycle.
29 REI_CYCLE_VERSION_C_NAME VARCHAR No
This keeps track of what features were available when the cycle was created, which allows cycles created prior to the feature to exclude that feature. For example, cycles that were created before the embryo transfer documentation was introduced should not show that documentation. This item is only set when the cycle is created, is never updated, and is not directly displayed to end users as it has no clinical significance.
May contain organization-specific values: No
Category Entries:
Initial (Before May 21)
Embryo Transfer, Cryopreservation, More Procedures (August 21)
PGT and Assisted Hatching in Lab Procedures
30 EMBRYO_CRYO_NUM INTEGER No
The number of embryos cryopreserved for a fertility cycle.
31 EGG_CRYO_NUM INTEGER No
The number of eggs cryopreserved for a fertility cycle.
32 SPERM_CRYO_NUM INTEGER No
The number of sperm samples cryopreserved for a fertility cycle.
33 WAS_PLANNING_YN VARCHAR No
This tracks whether the cycle had a status of planning at the time that the cycle was finished or deleted. This is relevant for identifying cycles that were never started and were completed while still in a planning status.
The category values for this column were already listed for column: ESET_YN
34 TRIGGER_DATE DATETIME No
This item stores the planned trigger date for this cycle.
35 CYCLE_TRIGGER_TM DATETIME (UTC) No
This item stores the planned ovulation trigger time for this cycle.