INFERTILITY_CYCLE_LINKS

Description: |
The INFERTILITY_CYCLE_LINKS table contains information about patients participating in a fertility treatment cycle.
The INFERTILITY_CYCLE_LINKS table is not able to safely export all of its columns without potentially compromising the other patients that are attached to the infertility treatment cycle. We created the view V_EHI_ICF_CYCLE_PATIENTS_DATA to filter the INFERTILITY_CYCLE_LINKS data based on the extracted patient's roles (e.g., sperm donor, intended parent) on the infertility treatment cycle. See view on more information on how data is filtered.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CYCLE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CYCLE_ID | NUMERIC | No |
The unique identifier for the fertility treatment cycle record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | PAT_ROLE_C_NAME | VARCHAR | No |
The role of the patient in the fertility treatment cycle.
May contain organization-specific values: No
Category Entries:
Intended Parent
Egg Contributor
Sperm Contributor
Pregnancy Carrier
Mitochondrial DNA Contributor
4 | PAT_ANON_YN | VARCHAR | No |
The patient should be anonymous from other patients in this fertility treatment cycle (ex. egg donor).
May contain organization-specific values: No
Category Entries:
No
Yes
5 | LINKED_PAT_ID | VARCHAR | No |
The patient ID of a patient involved in a fertility treatment cycle.