|
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 |
|
|