|
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 |
CM_PHY_OWNER_ID |
VARCHAR |
No |
|
|
|
| The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect. |
|
|
| 4 |
ALL_OWNER_PAT_ID |
VARCHAR |
No |
|
|
|
| Stores all the patients who are previous, current, or future owners of a given specimen (embryo, oocyte, or sperm). |
|
|
| 5 |
ALL_OWNER_COMMENTS |
VARCHAR |
No |
|
|
|
| Comments associated with the owner of the specimen. |
|
|
| 6 |
ALL_OWN_START_INST_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| Stores the UTC instant the owner started their ownership over a particular specimen. |
|
|
| 7 |
ALL_OWN_END_INST_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| Stores the UTC instant the owner ended their ownership over a particular specimen. |
|
|
| 8 |
PREV_SPEC_REI_SPEC_STATE_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the state of the specimen (in-culture, frozen, discarded, etc.) at the instant ownership changes from active to previous for a given specimen. |
| May contain organization-specific values: No |
| Category Entries: |
| Fresh |
| Thawed |
| Frozen |
| Discarded |
| Transferred to Uterus |
| Depleted |
|
|
| 9 |
PREV_SPEC_EMB_SPEC_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| The type of embryology specimen (oocyte, embryo, or sperm) at the instant ownership changes from active to previous for a given specimen. |
| May contain organization-specific values: No |
| Category Entries: |
| Embryo |
| Oocyte |
| Sperm |
|
|
| 10 |
PREV_SPEC_CULT_DAY |
INTEGER |
No |
|
|
|
| Stores the latest number of culture days that have occurred for the specimen when it was received in the lab at the instant ownership changes from active to previous for a given specimen. |
|
|
| 11 |
PREV_EXT_RTRVL_DATE |
DATETIME |
No |
|
|
|
| Stores the last documented date on which the oocyte retrieval occurred since the instant their ownership had expired. |
|
|
| 12 |
PREV_EXT_FREEZE_DATE |
DATETIME |
No |
|
|
|
| Stores the last documented date on which the specimen was frozen since the instant their ownership had expired. |
|
|
| 13 |
PREV_SPEC_EXT_CMTS |
VARCHAR |
No |
|
|
|
| Stores the last documented comments associated with the embryology specimen that came from an external lab. |
|
|
| 14 |
PREV_OOCYTE_PAT_ID |
VARCHAR |
No |
|
|
|
| Stores the last patient record ID who was an oocyte contributor to the specimen at the end of an owner's period of ownership. |
|
|
| 15 |
PREV_OOCYTE_RECORD_ID |
NUMERIC |
No |
|
|
|
| Stores the last non-patient record ID who was an oocyte contributor to the specimen at the end of an owner's period of ownership. |
|
|
| 16 |
PREV_EGG_GAMETE_SOURCE_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the last type of genetic contribution of the oocyte contributor. 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 |
|
|
| 17 |
PREV_SPERM_PAT_ID |
VARCHAR |
No |
|
|
|
| Stores the last patient record ID who was a sperm contributor to the specimen at the end of an owner's period of ownership. |
|
|
| 18 |
PREV_SPERM_RECORD_ID |
NUMERIC |
No |
|
|
|
| Stores the last non-patient record ID who was a sperm contributor to the specimen at the end of an owner's period of ownership. |
|
|
| 19 |
PREV_SPERM_GAMETE_SOURCE_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the last type of genetic contribution of the sperm contributor. This includes autologous, partner, anonymous donor, and directed donor. |
| The category values for this column were already listed for column: PREV_EGG_GAMETE_SOURCE_C_NAME |
|
|
