Schema reference / Tables / view MDX source

exam_embryo

Morphological findings obtained by microscopy of the human cleavage-stage embryo.

Purpose. To record structured observations about a human cleavage-stage embryo.

Source

Model	Leg	Role
`openEHR-EHR-CLUSTER.exam_embryo.v1`	openEHR	defines this table

Columns

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`number_of_cells`	`integer`	yes	Number of cells	`/items[at0028]`
`fragmentation_coded_text` `fragmentation_coded_text_code` `fragmentation_coded_text_system` `fragmentation_coded_text_valueset_id` `fragmentation_proportion_numerator` `fragmentation_proportion_denominator`	coded text `text`, `text`, `text`, `text`, `numeric`, `numeric`	yes	Fragmentation	`/items[at0030]`
`blastomere_size` `blastomere_size_code` `blastomere_size_system` `blastomere_size_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Blastomere size	`/items[at0035]`
`nucleation` `nucleation_code` `nucleation_system` `nucleation_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Nucleation	`/items[at0038]`
`cytoplasmic_morphology`	`text`	yes	Cytoplasmic morphology	`/items[at0042]`
`spatial_distribution_of_cells`	`text`	yes	Spatial distribution of cells	`/items[at0043]`
`compaction` `compaction_code` `compaction_system` `compaction_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Compaction	`/items[at0044]`
`other_morphological_features`	`text`	yes	Other morphological features	`/items[at0049]`
`morphology_grade` `morphology_grade_code` `morphology_grade_system` `morphology_grade_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Morphology grade	`/items[at0055]`

Constraints

check ((fragmentation_coded_text_code is null and fragmentation_coded_text_system is null and fragmentation_coded_text_valueset_id is null) or (fragmentation_coded_text is not null and fragmentation_coded_text_code is not null and fragmentation_coded_text_system is not null and fragmentation_coded_text_valueset_id is not null))
check ((fragmentation_proportion_numerator is null and fragmentation_proportion_denominator is null) or (fragmentation_proportion_numerator is not null and fragmentation_proportion_denominator is not null))
check (fragmentation_proportion_denominator is null or fragmentation_proportion_denominator <> 0)
check (fragmentation_proportion_denominator is null or fragmentation_proportion_denominator = 100)
check (num_nonnulls(fragmentation_coded_text, fragmentation_proportion_numerator) <= 1)
check ((blastomere_size_code is null and blastomere_size_system is null and blastomere_size_valueset_id is null) or (blastomere_size is not null and blastomere_size_code is not null and blastomere_size_system is not null and blastomere_size_valueset_id is not null))
check ((nucleation_code is null and nucleation_system is null and nucleation_valueset_id is null) or (nucleation is not null and nucleation_code is not null and nucleation_system is not null and nucleation_valueset_id is not null))
check ((compaction_code is null and compaction_system is null and compaction_valueset_id is null) or (compaction is not null and compaction_code is not null and compaction_system is not null and compaction_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

Columns	Target	On delete
`fragmentation_coded_text_valueset_id, fragmentation_coded_text_code, fragmentation_coded_text_system, fragmentation_coded_text`	`valueset_code`	restrict
`blastomere_size_valueset_id, blastomere_size_code, blastomere_size_system, blastomere_size`	`valueset_code`	restrict
`nucleation_valueset_id, nucleation_code, nucleation_system, nucleation`	`valueset_code`	restrict
`compaction_valueset_id, compaction_code, compaction_system, compaction`	`valueset_code`	restrict
`morphology_grade_valueset_id, morphology_grade_code, morphology_grade_system, morphology_grade`	`valueset_code`	restrict

Referenced by

embryo_assessment_morphological_findings via exam_embryo_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-CLUSTER.exam_embryo.v1/blastomere_size`	4
`org.openehr::openEHR-EHR-CLUSTER.exam_embryo.v1/compaction`	4
`org.openehr::openEHR-EHR-CLUSTER.exam_embryo.v1/fragmentation`	4
`org.openehr::openEHR-EHR-CLUSTER.exam_embryo.v1/nucleation`	5