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
Never Started
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
Concurrent Illness - COVID-19
Cysts
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
COVID-19
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
Category Entries:
Other
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.
36 | OOCYTE_THAW_DATE | DATETIME | No |
The date of the oocyte thaw procedure.
37 | EMBRYO_THAW_DATE | DATETIME | No |
The date of the embryo thaw procedure.
38 | NV_START_REASON_C_C_NAME | NUMERIC | No |
The reason fertility treatment was not started
The category values for this column were already listed for column: CANCEL_REASON_C_NAME
39 | NV_START_REASON_CMT | VARCHAR | No |
Comment for the cycle not started reason