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