exam_oocyte

Morphological findings obtained by microscopy of a human oocyte.

Morphological findings obtained by microscopy of a human oocyte.

Purpose. To record structured observations of a human oocyte.

Source

ModelLegRole
openEHR-EHR-CLUSTER.exam_oocyte.v1openEHRdefines this table

Columns

ColumnTypeNullDescriptionSource
iduuid primary keynoPrimary key.
maturity_of_cumulus_oocyte_complex
maturity_of_cumulus_oocyte_complex_code
maturity_of_cumulus_oocyte_complex_system
maturity_of_cumulus_oocyte_complex_valueset_id
coded text
text, text, text, text
yesMaturity of cumulus-oocyte complex/items[at0028]
oocyte_maturation_stage
oocyte_maturation_stage_code
oocyte_maturation_stage_system
oocyte_maturation_stage_valueset_id
coded text
text, text, text, text
yesOocyte maturation stage/items[at0035]
oocyte_size_coded_text
oocyte_size_coded_text_code
oocyte_size_coded_text_system
oocyte_size_coded_text_valueset_id
oocyte_size_quantity_magnitude
oocyte_size_quantity_units
coded text
text, text, text, text, numeric, text
yesOocyte size/items[at0039]
oocyte_shape
oocyte_shape_code
oocyte_shape_system
oocyte_shape_valueset_id
coded text
text, text, text, text
yesOocyte shape/items[at0040]
cytoplasmic_morphology
cytoplasmic_morphology_code
cytoplasmic_morphology_system
cytoplasmic_morphology_valueset_id
coded text
text, text, text, text
yesCytoplasmic morphology/items[at0041]
zona_pellucida_thickness
zona_pellucida_thickness_code
zona_pellucida_thickness_system
zona_pellucida_thickness_valueset_id
coded text
text, text, text, text
yesZona pellucida thickness/items[at0042]
perivitelline_space_size_coded_text
perivitelline_space_size_coded_text_code
perivitelline_space_size_coded_text_system
perivitelline_space_size_coded_text_valueset_id
perivitelline_space_size_quantity_magnitude
perivitelline_space_size_quantity_units
coded text
text, text, text, text, numeric, text
yesPerivitelline space size/items[at0043]
perivitelline_space_morphology
perivitelline_space_morphology_code
perivitelline_space_morphology_system
perivitelline_space_morphology_valueset_id
coded text
text, text, text, text
yesPerivitelline space morphology/items[at0078]
first_polar_body_morphology
first_polar_body_morphology_code
first_polar_body_morphology_system
first_polar_body_morphology_valueset_id
coded text
text, text, text, text
yesFirst polar body morphology/items[at0044]
metaphase_spindle_size
metaphase_spindle_size_code
metaphase_spindle_size_system
metaphase_spindle_size_valueset_id
coded text
text, text, text, text
yesMetaphase spindle size/items[at0045]
metaphase_spindle_location
metaphase_spindle_location_code
metaphase_spindle_location_system
metaphase_spindle_location_valueset_id
coded text
text, text, text, text
yesMetaphase spindle location/items[at0083]
other_morphological_featurestextyesOther morphological features/items[at0046]
morphology_grade
morphology_grade_code
morphology_grade_system
morphology_grade_valueset_id
coded text
text, text, text, text
yesMorphology grade/items[at0077]

Constraints

check ((maturity_of_cumulus_oocyte_complex_code is null and maturity_of_cumulus_oocyte_complex_system is null and maturity_of_cumulus_oocyte_complex_valueset_id is null) or (maturity_of_cumulus_oocyte_complex is not null and maturity_of_cumulus_oocyte_complex_code is not null and maturity_of_cumulus_oocyte_complex_system is not null and maturity_of_cumulus_oocyte_complex_valueset_id is not null))
check ((oocyte_maturation_stage_code is null and oocyte_maturation_stage_system is null and oocyte_maturation_stage_valueset_id is null) or (oocyte_maturation_stage is not null and oocyte_maturation_stage_code is not null and oocyte_maturation_stage_system is not null and oocyte_maturation_stage_valueset_id is not null))
check ((oocyte_size_coded_text_code is null and oocyte_size_coded_text_system is null and oocyte_size_coded_text_valueset_id is null) or (oocyte_size_coded_text is not null and oocyte_size_coded_text_code is not null and oocyte_size_coded_text_system is not null and oocyte_size_coded_text_valueset_id is not null))
check ((oocyte_size_quantity_magnitude is null and oocyte_size_quantity_units is null) or (oocyte_size_quantity_magnitude is not null and oocyte_size_quantity_units is not null))
check (oocyte_size_quantity_magnitude is null or (oocyte_size_quantity_units = 'um' and oocyte_size_quantity_magnitude >= 0))
check (num_nonnulls(oocyte_size_coded_text, oocyte_size_quantity_magnitude) <= 1)
check ((oocyte_shape_code is null and oocyte_shape_system is null and oocyte_shape_valueset_id is null) or (oocyte_shape is not null and oocyte_shape_code is not null and oocyte_shape_system is not null and oocyte_shape_valueset_id is not null))
check ((cytoplasmic_morphology_code is null and cytoplasmic_morphology_system is null and cytoplasmic_morphology_valueset_id is null) or (cytoplasmic_morphology is not null and cytoplasmic_morphology_code is not null and cytoplasmic_morphology_system is not null and cytoplasmic_morphology_valueset_id is not null))
check ((zona_pellucida_thickness_code is null and zona_pellucida_thickness_system is null and zona_pellucida_thickness_valueset_id is null) or (zona_pellucida_thickness is not null and zona_pellucida_thickness_code is not null and zona_pellucida_thickness_system is not null and zona_pellucida_thickness_valueset_id is not null))
check ((perivitelline_space_size_coded_text_code is null and perivitelline_space_size_coded_text_system is null and perivitelline_space_size_coded_text_valueset_id is null) or (perivitelline_space_size_coded_text is not null and perivitelline_space_size_coded_text_code is not null and perivitelline_space_size_coded_text_system is not null and perivitelline_space_size_coded_text_valueset_id is not null))
check ((perivitelline_space_size_quantity_magnitude is null and perivitelline_space_size_quantity_units is null) or (perivitelline_space_size_quantity_magnitude is not null and perivitelline_space_size_quantity_units is not null))
check (num_nonnulls(perivitelline_space_size_coded_text, perivitelline_space_size_quantity_magnitude) <= 1)
check ((perivitelline_space_morphology_code is null and perivitelline_space_morphology_system is null and perivitelline_space_morphology_valueset_id is null) or (perivitelline_space_morphology is not null and perivitelline_space_morphology_code is not null and perivitelline_space_morphology_system is not null and perivitelline_space_morphology_valueset_id is not null))
check ((first_polar_body_morphology_code is null and first_polar_body_morphology_system is null and first_polar_body_morphology_valueset_id is null) or (first_polar_body_morphology is not null and first_polar_body_morphology_code is not null and first_polar_body_morphology_system is not null and first_polar_body_morphology_valueset_id is not null))
check ((metaphase_spindle_size_code is null and metaphase_spindle_size_system is null and metaphase_spindle_size_valueset_id is null) or (metaphase_spindle_size is not null and metaphase_spindle_size_code is not null and metaphase_spindle_size_system is not null and metaphase_spindle_size_valueset_id is not null))
check ((metaphase_spindle_location_code is null and metaphase_spindle_location_system is null and metaphase_spindle_location_valueset_id is null) or (metaphase_spindle_location is not null and metaphase_spindle_location_code is not null and metaphase_spindle_location_system is not null and metaphase_spindle_location_valueset_id is not null))
check ((morphology_grade_code is null and morphology_grade_system is null and morphology_grade_valueset_id is null) or (morphology_grade is not null and morphology_grade_code is not null and morphology_grade_system is not null and morphology_grade_valueset_id is not null))

References

ColumnsTargetOn delete
maturity_of_cumulus_oocyte_complex_valueset_id, maturity_of_cumulus_oocyte_complex_code, maturity_of_cumulus_oocyte_complex_system, maturity_of_cumulus_oocyte_complexvalueset_coderestrict
oocyte_maturation_stage_valueset_id, oocyte_maturation_stage_code, oocyte_maturation_stage_system, oocyte_maturation_stagevalueset_coderestrict
oocyte_size_coded_text_valueset_id, oocyte_size_coded_text_code, oocyte_size_coded_text_system, oocyte_size_coded_textvalueset_coderestrict
oocyte_shape_valueset_id, oocyte_shape_code, oocyte_shape_system, oocyte_shapevalueset_coderestrict
cytoplasmic_morphology_valueset_id, cytoplasmic_morphology_code, cytoplasmic_morphology_system, cytoplasmic_morphologyvalueset_coderestrict
zona_pellucida_thickness_valueset_id, zona_pellucida_thickness_code, zona_pellucida_thickness_system, zona_pellucida_thicknessvalueset_coderestrict
perivitelline_space_size_coded_text_valueset_id, perivitelline_space_size_coded_text_code, perivitelline_space_size_coded_text_system, perivitelline_space_size_coded_textvalueset_coderestrict
perivitelline_space_morphology_valueset_id, perivitelline_space_morphology_code, perivitelline_space_morphology_system, perivitelline_space_morphologyvalueset_coderestrict
first_polar_body_morphology_valueset_id, first_polar_body_morphology_code, first_polar_body_morphology_system, first_polar_body_morphologyvalueset_coderestrict
metaphase_spindle_size_valueset_id, metaphase_spindle_size_code, metaphase_spindle_size_system, metaphase_spindle_sizevalueset_coderestrict
metaphase_spindle_location_valueset_id, metaphase_spindle_location_code, metaphase_spindle_location_system, metaphase_spindle_locationvalueset_coderestrict
morphology_grade_valueset_id, morphology_grade_code, morphology_grade_system, morphology_gradevalueset_coderestrict

Referenced by

Value sets

Value setCodes
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/cytoplasmic_morphology7
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/first_polar_body_morphology5
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/maturity_of_cumulus_oocyte_complex4
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/metaphase_spindle_location2
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/metaphase_spindle_size3
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/oocyte_maturation_stage3
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/oocyte_shape2
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/oocyte_size3
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/perivitelline_space_morphology2
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/perivitelline_space_size3
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/zona_pellucida_thickness3