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.