SPEC_GENETIC_CONTRIBUTORS

Description: |
The person that an egg or sperm came from. For embryos, this table stores the egg and sperm sources used to create the embryo.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SPECIMEN_ID | VARCHAR | No |
The unique identifier (.1 item) for the specimen 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 | GEN_CONTRIB_NONPAT_RECORD_ID | NUMERIC | No |
Non-patients who are genetic contributors to the specimen, i.e. have provided the sperm or egg. This will store external donors who don't have a chart in the system.
4 | PAT_ROLE_C_NAME | VARCHAR | No |
Stores whether the genetic contributor for a specimen is the oocyte or sperm contributor.
May contain organization-specific values: No
Category Entries:
Intended Parent
Egg Contributor
Sperm Contributor
Pregnancy Carrier
Mitochondrial DNA Contributor
5 | GAMETE_SOURCE_C_NAME | VARCHAR | No |
The type of genetic contribution. This includes autologous, partner, anonymous donor, and directed donor.
May contain organization-specific values: Yes
Category Entries:
Autologous
Partner
Known Donor
Anonymous Donor
Mixed
Embryo Donor
Oocyte Contributor and Intended Parent
Sperm Contributor and Intended Parent