V_EHI_ICF_CYCLE_PATIENTS_DATA

Description:

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. The extracted patient's roles (e.g., sperm donor, intended parent) on the infertility treatment cycle determines the data they are allowed to view about the other patients attached to the cycle. This view filters the full data of the INFERTILITY_CYCLE_LINKS table based on the extracted patient's roles to be safely exported without compromising PHI. All extracted patients should be able to see the type of roles that were a part of a cycle (e.g., there is a sperm provider). Extracted patients with the role of intended parent should be able to see all the name of the known donors and the external donor information. Extracted patients with the role of known donor (a non-anonymous sperm or egg provider but not an intended parent) should be able to see all the names of the other known donors and intended parents but not the external donor information. Extracted patients with the role of anonymous donor should not be able to see any of the names of the other patients on the cycle or the external donor information.

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	LINKED_PAT_ID	VARCHAR	No
	The patient ID of a patient involved in a fertility treatment cycle.
4	PAT_NAME	VARCHAR	No
	The patient’s name in the format Lastname, Firstname MI.
5	IS_EXTRACTED_PAT_YN	VARCHAR	No
	When extracting a patient's cycles, rows marked with 'Y' represent their roles on the cycle. Else if marked 'N' then that row represents another patient attached to the cycle. The extracted patient refers to the LINKED_PAT_ID column.
6	DONOR_DONATION_AGE	INTEGER	No
	The age of the donor at the time of donation of the specimen (sperm or egg).
7	DONOR_DONATION_DATE	DATETIME	No
	The date of donation of the specimen (sperm or egg).
8	DONOR_BANK	VARCHAR	No
	The name of the donation bank the specimen had came from.
9	DONOR_BANK_CMT	VARCHAR	No
	A free text comment for the name of the donation bank.
10	DONOR_GAMETE_ID	VARCHAR	No
	The gamete donor ID (may be assigned by the donation bank).
11	DONOR_RACE	VARCHAR	No
	A patient's race. Multiple races may be associated with this patient. This is represented by a semicolon (;) delimited string. The values in this column come from the TITLE column of the ZC_PATIENT_RACE table.
12	DONOR_RELATIONSHIP_C_NAME	VARCHAR	No
	This column indicates the type of relationship of the external donor to the patient. May contain organization-specific values: Yes Category Entries: Anonymous Directed - Biological Relation Directed - Non-biological Relation Unknown