fetal_biometry

Ultrasound and Doppler measurements of the dimensions of an embryo or fetus.

Ultrasound and Doppler measurements of the dimensions of an embryo or fetus.

Purpose. To record ultrasound and doppler measurements of an embryo or fetus in utero.

Source

ModelLegRole
openEHR-EHR-OBSERVATION.fetal_biometry.v1openEHRdefines this table

Columns

ColumnTypeNullDescriptionSource
iduuid primary keynoPrimary key.
form_iduuidformnoThe form this entry was recorded on.
form_block_iduuidyesThe block within the form, when the entry is bound to one.
crown_rump_length_crl_magnitude
crown_rump_length_crl_units
quantity
numeric, text
yesCrown-rump length (CRL)/data[at0001]/events[at0002]/data[at0003]/items[at0004]
biparietal_diameter_bpd_magnitude
biparietal_diameter_bpd_units
quantity
numeric, text
yesBiparietal diameter (BPD)/data[at0001]/events[at0002]/data[at0003]/items[at0006]
occipito_frontal_diameter_ofd_magnitude
occipito_frontal_diameter_ofd_units
quantity
numeric, text
yesOccipito-frontal diameter (OFD)/data[at0001]/events[at0002]/data[at0003]/items[at0007]
head_circumference_hc_magnitude
head_circumference_hc_units
quantity
numeric, text
yesHead circumference (HC)/data[at0001]/events[at0002]/data[at0003]/items[at0008]
trans_cerebellar_diameter_tcd_magnitude
trans_cerebellar_diameter_tcd_units
quantity
numeric, text
yesTrans-cerebellar diameter (TCD)/data[at0001]/events[at0002]/data[at0003]/items[at0009]
interocular_distance_iod_magnitude
interocular_distance_iod_units
quantity
numeric, text
yesInterocular distance (IOD)/data[at0001]/events[at0002]/data[at0003]/items[at0010]
binocular_distance_bod_magnitude
binocular_distance_bod_units
quantity
numeric, text
yesBinocular distance (BOD)/data[at0001]/events[at0002]/data[at0003]/items[at0011]
abdominal_circumference_ac_magnitude
abdominal_circumference_ac_units
quantity
numeric, text
yesAbdominal circumference (AC)/data[at0001]/events[at0002]/data[at0003]/items[at0012]
femur_length_fl_magnitude
femur_length_fl_units
quantity
numeric, text
yesFemur length (FL)/data[at0001]/events[at0002]/data[at0003]/items[at0013]
humeral_length_hl_magnitude
humeral_length_hl_units
quantity
numeric, text
yesHumeral length (HL)/data[at0001]/events[at0002]/data[at0003]/items[at0014]
commenttextyesComment/data[at0001]/events[at0002]/data[at0003]/items[at0015]
bpd_method
bpd_method_code
bpd_method_system
bpd_method_valueset_id
coded text
text, text, text, text
yesBPD method/protocol[at0016]/items[at0017]

Constraints

check ((crown_rump_length_crl_magnitude is null and crown_rump_length_crl_units is null) or (crown_rump_length_crl_magnitude is not null and crown_rump_length_crl_units is not null))
check (crown_rump_length_crl_magnitude is null or (crown_rump_length_crl_units = 'mm' and crown_rump_length_crl_magnitude >= 0) or (crown_rump_length_crl_units = 'cm' and crown_rump_length_crl_magnitude >= 0) or (crown_rump_length_crl_units = '[in_i]' and crown_rump_length_crl_magnitude >= 0))
check ((biparietal_diameter_bpd_magnitude is null and biparietal_diameter_bpd_units is null) or (biparietal_diameter_bpd_magnitude is not null and biparietal_diameter_bpd_units is not null))
check (biparietal_diameter_bpd_magnitude is null or (biparietal_diameter_bpd_units = 'mm' and biparietal_diameter_bpd_magnitude >= 0) or (biparietal_diameter_bpd_units = 'cm' and biparietal_diameter_bpd_magnitude >= 0) or (biparietal_diameter_bpd_units = '[in_i]' and biparietal_diameter_bpd_magnitude >= 0))
check ((occipito_frontal_diameter_ofd_magnitude is null and occipito_frontal_diameter_ofd_units is null) or (occipito_frontal_diameter_ofd_magnitude is not null and occipito_frontal_diameter_ofd_units is not null))
check (occipito_frontal_diameter_ofd_magnitude is null or (occipito_frontal_diameter_ofd_units = 'mm' and occipito_frontal_diameter_ofd_magnitude >= 0) or (occipito_frontal_diameter_ofd_units = 'cm' and occipito_frontal_diameter_ofd_magnitude >= 0) or (occipito_frontal_diameter_ofd_units = '[in_i]' and occipito_frontal_diameter_ofd_magnitude >= 0))
check ((head_circumference_hc_magnitude is null and head_circumference_hc_units is null) or (head_circumference_hc_magnitude is not null and head_circumference_hc_units is not null))
check (head_circumference_hc_magnitude is null or (head_circumference_hc_units = 'mm' and head_circumference_hc_magnitude >= 0) or (head_circumference_hc_units = 'cm' and head_circumference_hc_magnitude >= 0) or (head_circumference_hc_units = '[in_i]' and head_circumference_hc_magnitude >= 0))
check ((trans_cerebellar_diameter_tcd_magnitude is null and trans_cerebellar_diameter_tcd_units is null) or (trans_cerebellar_diameter_tcd_magnitude is not null and trans_cerebellar_diameter_tcd_units is not null))
check (trans_cerebellar_diameter_tcd_magnitude is null or (trans_cerebellar_diameter_tcd_units = 'mm' and trans_cerebellar_diameter_tcd_magnitude >= 0) or (trans_cerebellar_diameter_tcd_units = 'cm' and trans_cerebellar_diameter_tcd_magnitude >= 0) or (trans_cerebellar_diameter_tcd_units = '[in_i]' and trans_cerebellar_diameter_tcd_magnitude >= 0))
check ((interocular_distance_iod_magnitude is null and interocular_distance_iod_units is null) or (interocular_distance_iod_magnitude is not null and interocular_distance_iod_units is not null))
check (interocular_distance_iod_magnitude is null or (interocular_distance_iod_units = 'mm' and interocular_distance_iod_magnitude >= 0) or (interocular_distance_iod_units = 'cm' and interocular_distance_iod_magnitude >= 0) or (interocular_distance_iod_units = '[in_i]' and interocular_distance_iod_magnitude >= 0))
check ((binocular_distance_bod_magnitude is null and binocular_distance_bod_units is null) or (binocular_distance_bod_magnitude is not null and binocular_distance_bod_units is not null))
check (binocular_distance_bod_magnitude is null or (binocular_distance_bod_units = 'mm' and binocular_distance_bod_magnitude >= 0) or (binocular_distance_bod_units = 'cm' and binocular_distance_bod_magnitude >= 0) or (binocular_distance_bod_units = '[in_i]' and binocular_distance_bod_magnitude >= 0))
check ((abdominal_circumference_ac_magnitude is null and abdominal_circumference_ac_units is null) or (abdominal_circumference_ac_magnitude is not null and abdominal_circumference_ac_units is not null))
check (abdominal_circumference_ac_magnitude is null or (abdominal_circumference_ac_units = 'mm' and abdominal_circumference_ac_magnitude >= 0) or (abdominal_circumference_ac_units = 'cm' and abdominal_circumference_ac_magnitude >= 0) or (abdominal_circumference_ac_units = '[in_i]' and abdominal_circumference_ac_magnitude >= 0))
check ((femur_length_fl_magnitude is null and femur_length_fl_units is null) or (femur_length_fl_magnitude is not null and femur_length_fl_units is not null))
check (femur_length_fl_magnitude is null or (femur_length_fl_units = 'mm' and femur_length_fl_magnitude >= 0) or (femur_length_fl_units = 'cm' and femur_length_fl_magnitude >= 0) or (femur_length_fl_units = '[in_i]' and femur_length_fl_magnitude >= 0))
check ((humeral_length_hl_magnitude is null and humeral_length_hl_units is null) or (humeral_length_hl_magnitude is not null and humeral_length_hl_units is not null))
check (humeral_length_hl_magnitude is null or (humeral_length_hl_units = 'mm' and humeral_length_hl_magnitude >= 0) or (humeral_length_hl_units = 'cm' and humeral_length_hl_magnitude >= 0) or (humeral_length_hl_units = '[in_i]' and humeral_length_hl_magnitude >= 0))
check ((bpd_method_code is null and bpd_method_system is null and bpd_method_valueset_id is null and bpd_method is null) or (bpd_method is not null and bpd_method_code is not null and bpd_method_system is not null and bpd_method_valueset_id is not null))

Unique

References

ColumnsTargetOn delete
form_idformcascade
form_id, form_block_idform_blockcascade
bpd_method_valueset_id, bpd_method_code, bpd_method_system, bpd_methodvalueset_coderestrict

Indexes

Value sets

Value setCodes
org.openehr::openEHR-EHR-OBSERVATION.fetal_biometry.v1/bpd_method2