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 Provider Sperm Provider Pregnancy Carrier Mitochondrial DNA Provider
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.