EMBRYOLOGY_SPECIMEN

Description:

Contains information about oocyte, embryo, or sperm specimens.

Primary Key

Column Name	Ordinal Position
SPECIMEN_ID	1

Column Information

	Name	Type	Discontinued?
1	SPECIMEN_ID	VARCHAR	No
	The unique identifier (.1 item) for the specimen record.
2	REI_SPEC_STATE_C_NAME	VARCHAR	No
	The state of a specimen in an embryology or andrology lab. This tracks whether a specimen is currently in-culture, frozen, discarded, etc. May contain organization-specific values: No Category Entries: Fresh Thawed Frozen Discarded Transferred to Uterus Completed
3	EMB_SPEC_TYPE_C_NAME	VARCHAR	No
	The type of embryology specimen: oocyte, embryo, or sperm. May contain organization-specific values: No Category Entries: Embryo Oocyte Sperm
4	EMB_SPEC_RECEIVE_CULTURE_DAY	INTEGER	No
	This item stores the number of culture days that have occurred for the specimen when it was received in the lab.
5	EMB_SPEC_EXT_RETRIEVAL_DATE	DATETIME	No
	This item stores the date on which the oocyte retrieval occurred for the given embryology specimen.
6	EMB_SPEC_EXTERNAL_FREEZE_DATE	DATETIME	No
	This item stores the date on which the embryology specimen was frozen.
7	EMB_SPEC_EXTERNAL_COMMENTS	VARCHAR	No
	This item stores relevant comments associated with the embryology specimen that came from an external lab.