some invalid data in opensrp database event in profile json object

[imukunzi]

Affected App or Server Version

v.1.6.10

What kind of support do you need?

There is invalid data in event profile json object, we want to analyze these data, from the excel data captured in March during testing phase hivrisk contains mixed values, These baseEntiryId can help 81341a9d-c91e-4561-a98c-4939ea77164d | a15ed7bc-af7e-435a-af1b-91c63e9178b1 | 56be1ce3-3dc1-46b4-963c-5861ace933f4 We want to use data from database and value need to be harmonized.

==>2022-05-31
There is some invalid data on Symptoms and followup event data for some rows in database we have have number where we are expecting text. On the same shared data baseEntityId 7f3b062a-e622-4485-83a4-1457e6837d7f Physical symptoms column.

What is the acceptance criteria for your support request?

Harmonized profile data
Harmonized Physical Symptoms data

Relevant Information

No response

[SebaMutuku]

@imukunzi can we have a call with you to see how this is happening?
Can we also get some screen recording or screenshots.

[AngelaKabari]

@junaidwarsivd find a screenshot of this issue here

[dubdabasoduba]

@imukunzi Please share the queries you are running to flatten the data.

[imukunzi]

@dubdabasoduba here are queries
============ profile =====================
select id,json->>'baseEntityId' as baseentityid,trim(both '[""]' from json->'obs'->1->>'humanReadableValues') as "educationlevel",trim(both '[""]' from json->'obs'->2->>'humanReadableValues') as "catchmentarea",trim(both '[""]' from json->'obs'->3->>'humanReadableValues') as "maritalstatus",trim(both '[""]' from json->'obs'->4->>'humanReadableValues') as "occupation",trim(both '[""]' from json->'obs'->5->>'values') as "hiv_risk",trim(both '[""]' from json->'obs'->6->>'humanReadableValues') as "lmpknown",trim(both '[""]' from json->'obs'->7->>'values') as "lmpknowndate",trim(both '[""]' from json->'obs'->23->>'values') as "gestationalage",trim(both '[""]' from json->'obs'->24->>'values') as "gravida",trim(both '[""]' from json->'obs'->25->>'values') as "previouspregnancies",trim(both '[""]' from json->'obs'->26->>'humanReadableValues') as "miscouriage",trim(both '[""]' from json->'obs'->27->>'values') as "livebirths",trim(both '[""]' from json->'obs'->28->>'humanReadableValues') as "last_birth_preterm",trim(both '[""]' from json->'obs'->29->>'values') as "parity",trim(both '[""]' from json->'obs'->30->>'values') as "c_section",trim(both '[""]' from json->'obs'->31->>'values') as "newborndied",trim(both '[""]' from json->'obs'->32->>'values') as "childrenalive",trim(both '[""]' from json->'obs'->35->>'values') as "datelastborn",trim(both '[""]' from json->'obs'->36->>'humanReadableValues') as "lastbornstatus",trim(both '[""]' from json->'obs'->37->>'humanReadableValues') as "prev_preg_complication",trim(both '[""]' from json->'obs'->38->>'values') as "preeclampsiarisk",trim(both '[""]' from json->'obs'->39->>'values') as "gdmrisk",trim(both '[""]' from json->'obs'->40->>'humanReadableValues') as "healthconditions",trim(both '[""]' from json->'obs'->42->>'values') as "hivpositive",trim(both '[""]' from json->'obs'->43->>'humanReadableValues') as "alergies",trim(both '[""]' from json->'obs'->44->>'humanReadableValues') as "surgies",trim(both '[""]' from json->'obs'->45->>'humanReadableValues') as "tt_immunisation",trim(both '[""]' from json->'obs'->49->>'humanReadableValues') as "medications",trim(both '[""]' from json->'obs'->57->>'humanReadableValues') as "partnerhivpositive" from core.event where json->'eventType'='"Profile"' order by id desc;

===========symptoms=================
SELECT id,json->'type' as type_,json->'eventType' as event_type,btrim(json->'obs'->0->>'values','"[]"') as "physical_symptoms",btrim(json->'obs'->1->'values'->>0,'"[]"') as other_symptoms,btrim(json->'obs'->2->'values'->>0,'"[]"') as ipv_signs_symptoms,json->'obs'->3->'values'->>0 as ipv_suspect from core.event where json->'eventType'='"Symptoms and Follow-up"' order by id desc;

==============physical exam==============
SELECT id,json->'baseEntityId' as basebaseentityid,json->'eventType' as event_type,btrim(json->'obs'->0->>'values','"[]"') as "Height",btrim(json->'obs'->1->>'humanReadableValues','"[]"') as "pregest_weight_unknown",btrim(json->'obs'->2->>'values','"[]"') as "current_weight",btrim(json->'obs'->4->>'values','"[]"') as "bmi",btrim(json->'obs'->5->>'values','"[]"') as "gdm_risk",btrim(json->'obs'->6->>'values','"[]"') as "weight_cat",btrim(json->'obs'->7->>'values','"[]"') as "exp_gain",btrim(json->'obs'->8->>'values','"[]"') as "weight_gain_duration",btrim(json->'obs'->9->>'values','"[]"') as "weight_gain",btrim(json->'obs'->10->>'values','"[]"') as "tot_weight_gain",btrim(json->'obs'->11->>'values','"[]"') as "height_cat",btrim(json->'obs'->12->>'values','"[]"') as "bp_systonic",btrim(json->'obs'->13->>'values','"[]"') as "bp_diatolic",btrim(json->'obs'->14->>'values','"[]"') as "hypertension",btrim(json->'obs'->15->>'values','"[]"') as "severe_hypertension",btrim(json->'obs'->16->>'values','"[]"') as "sever_preeclampsia",btrim(json->'obs'->17->>'values','"[]"') as "preeclampsia",btrim(json->'obs'->18->>'values','"[]"') as "body_temp",btrim(json->'obs'->19->>'values','"[]"') as "pulse_rate",btrim(json->'obs'->20->>'humanReadableValues','"[]"') as "pallor",btrim(json->'obs'->21->>'values','"[]"') as "anaemic",btrim(json->'obs'->23->>'values','"[]"') as "muac_value",btrim(json->'obs'->24->>'humanReadableValues','"[]"') as "respiratory_exam",btrim(json->'obs'->25->>'humanReadableValues','"[]"') as "cardiac_exam",btrim(json->'obs'->26->>'humanReadableValues','"[]"') as "breast_exam",btrim(json->'obs'->27->>'humanReadableValues','"[]"') as "abdominal_exam",btrim(json->'obs'->28->>'humanReadableValues','"[]"') as "pervic_exam",btrim(json->'obs'->30->>'humanReadableValues','"[]"') as "cervical_exam",btrim(json->'obs'->31->>'values','"[]"') as "toaster26_hidden",btrim(json->'obs'->32->>'humanReadableValues','"[]"') as "oedema",btrim(json->'obs'->35->>'values','"[]"') as "sfh",btrim(json->'obs'->37->>'humanReadableValues','"[]"') as "fetal_heartbeat",btrim(json->'obs'->39->>'values','"[]"') as "preeclampsia_risk",btrim(json->'obs'->40->>'humanReadableValues','"[]"') as "fetus_position" from core.event where json->'eventType'='"Physical Exam"' order by id desc;

[imukunzi]

SELECT id,json->'baseEntityId' as basebaseentityid,json->'eventType' as event_type,btrim(json->'obs'->4->>'values','"[]"') as "hiv_positive",btrim(json->'obs'->10->>'values','"[]"') as "syphilis_positive",btrim(json->'obs'->16->>'values','"[]"') as "hemoglobine",btrim(json->'obs'->17->>'values','"[]"') as "aneamic" from core.event where json->'eventType'='"Tests"' order by id desc;

[imukunzi]

Remider to add visit/contact number in event json object.

[junaidwarsivd]

hi @imukunzi please apply this querry for the "profile "
select id,
json ->> 'baseEntityId' as baseentityid,
jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "educ_level")') as value ,
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "educ_level")') -> 0 ->> 'humanReadableValues') as "educationlevel",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "marital_status")') -> 0 ->> 'humanReadableValues') as "maritalstatus",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "occupation")') -> 0 ->> 'humanReadableValues') as "occupation",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "hiv_risk")') -> 0 ->> 'values') as "hiv_risk",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "lmp_known")') -> 0 ->> 'humanReadableValues') as "lmpknown",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "lmp_known_date")') -> 0 ->> 'values') as "lmpknowndate",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "gest_age_openmrs")') -> 0 ->> 'values') as "gestationalage",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "gravida")') -> 0 ->> 'values') as "gravida",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "previous_pregnancies")') -> 0 ->> 'values') as "previouspregnancies",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "miscarriages_abortions")') -> 0 ->> 'values') as "miscouriage",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "live_births")') -> 0 ->> 'values') as "livebirths",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "last_live_birth_preterm")') -> 0 ->> 'humanReadableValues') as "last_birth_preterm",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "parity")') -> 0 ->> 'values') as "parity",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "c_sections")') -> 0 ->> 'values') as "c_section",
trim(both '[""]' from json -> 'obs' -> 2 ->> 'humanReadableValues') as "catchmentarea",
trim(both '[""]' from json -> 'obs' -> 31 ->> 'values') as "newborndied",
trim(both '[""]' from json -> 'obs' -> 32 ->> 'values') as "childrenalive",
trim(both '[""]' from json -> 'obs' -> 35 ->> 'values') as "datelastborn",
trim(both '[""]' from json -> 'obs' -> 36 ->> 'humanReadableValues') as "lastbornstatus",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "prev_preg_comps")') -> 0 ->> 'humanReadableValues') as "prev_preg_complication",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "preeclampsia_risk")') -> 0 ->> 'values') as "preeclampsiarisk",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "gdm_risk")') -> 0 ->> 'values') as "gdmrisk",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "health_conditions")') -> 0 ->> 'humanReadableValues') as "healthconditions",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "hiv_positive")') -> 0 ->> 'values') as "hivpositive",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "allergies")') -> 0 ->> 'humanReadableValues') as "alergies",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "surgeries")') -> 0 ->> 'humanReadableValues') as "surgeries",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "tt_immun_status")') -> 0 ->> 'humanReadableValues') as "tt_immunisation",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "medications")') -> 0 ->> 'humanReadableValues') as "medications",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "partner_hiv_positive")') -> 0 ->> 'values') as "partnerhivpositive"
from core.event trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "partner_hiv_positive")') -> 0 ->> 'values') as "partnerhivpositive"
where json -> 'eventType' = '"Profile"'
order by id desc;

Please Note : change these trim(both '[""]' from json -> 'obs' -> 2 ->> 'humanReadableValues') as "catchmentarea",
trim(both '[""]' from json -> 'obs' -> 31 ->> 'values') as "newborndied",
trim(both '[""]' from json -> 'obs' -> 32 ->> 'values') as "childrenalive",
trim(both '[""]' from json -> 'obs' -> 35 ->> 'values') as "datelastborn",
trim(both '[""]' from json -> 'obs' -> 36 ->> 'humanReadableValues') as "lastbornstatus",
to
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[*] ? (@.formSubmissionField == "FORM field NAME ")') -> 0 ->> 'values') as "RELEVANT COLUMN"

updating the rest of the querries as well in this thread cc @AngelaKabari @dubdabasoduba

[junaidwarsivd]

@imukunzi please apply this querry for the symptoms :
SELECT id,
json -> 'type' as type_,
json -> 'eventType' as event_type,
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "phys_symptoms")') -> 0 ->> 'values') as "physical_symptoms",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "other_symptoms")') -> 0 ->> 'values') as "other_symptoms",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "ipv_signs_symptoms")') -> 0 ->> 'values') as "ipv_signs_symptoms",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "ipv_suspect")') -> 0 ->> 'values') as "ipv_suspect"
from core.event
where json -> 'eventType' = '"Symptoms and Follow-up"'
order by id desc;

[junaidwarsivd]

@imukunzi please apply this querry for physical exams:

SELECT id,
json -> 'baseEntityId' as basebaseentityid,
json -> 'eventType' as event_type,
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "height")') -> 0 ->> 'values') as "Height",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "pregest_weight_unknown")') -> 0 ->> 'humanReadableValues') as "pregest_weight_unknown",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "current_weight")') -> 0 ->> 'values') as "current_weight",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "bmi")') -> 0 ->> 'values') as "bmi",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "gdm_risk")') -> 0 ->> 'values') as "gdm_risk",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "weight_cat")') -> 0 ->> 'values') as "weight_cat",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "exp_weight_gain")') -> 0 ->> 'values') as "exp_gain",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "weight_gain_duration")') -> 0 ->> 'values') as "weight_gain_duration",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "weight_gain")') -> 0 ->> 'values') as "weight_gain",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "tot_weight_gain")') -> 0 ->> 'values') as "tot_weight_gain",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "height_cat")') -> 0 ->> 'values') as "height_cat",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "bp_systolic")') -> 0 ->> 'values') as "bp_systonic",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "bp_diastolic")') -> 0 ->> 'values') as "bp_diatolic",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "hypertension")') -> 0 ->> 'values') as "hypertension",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "severe_hypertension")') -> 0 ->> 'values') as "severe_hypertension",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "severe_preeclampsia")') -> 0 ->> 'values') as "severe_preeclampsia",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "preeclampsia")') -> 0 ->> 'values') as "preeclampsia",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "body_temp")') -> 0 ->> 'values') as "body_temp",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "pulse_rate")') -> 0 ->> 'values') as "pulse_rate",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "pallor")') -> 0 ->> 'humanReadableValues') as "pallor",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "anaemic")') -> 0 ->> 'values') as "anaemic",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "muac_value")') -> 0 ->> 'values') as "muac_value",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "respiratory_exam")') -> 0 ->> 'humanReadableValues') as "respiratory_exam",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "cardiac_exam")') -> 0 ->> 'humanReadableValues') as "cardiac_exam",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "breast_exam")') -> 0 ->> 'humanReadableValues') as "breast_exam",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "abdominal_exam")') -> 0 ->> 'humanReadableValues') as "abdominal_exam",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "pelvic_exam")') -> 0 ->> 'humanReadableValues') as "pelvic_exam",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "cervical_exam")') -> 0 ->> 'humanReadableValues') as "cervical_exam",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "toaster26_hidden")') -> 0 ->> 'values') as "toaster26_hidden",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "oedema")') -> 0 ->> 'humanReadableValues') as "oedema",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "sfh")') -> 0 ->> 'values') as "sfh",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "fetal_heartbeat")') -> 0 ->> 'humanReadableValues') as "fetal_heartbeat",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "preeclampsia_risk")') -> 0 ->> 'values') as "preeclampsia_risk",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "fetal_presentation")') -> 0 ->> 'humanReadableValues') as "fetus_position"
from core.event
where json -> 'eventType' = '"Physical Exam"'
order by id desc;

[junaidwarsivd]

@imukunzi please apply this querry for TESTS
SELECT id,
json -> 'baseEntityId' as basebaseentityid,
json -> 'eventType' as event_type,
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "hiv_positive")') -> 0 ->> 'values') as "hiv_positive",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "syphilis_positive")') -> 0 ->> 'values') as "syphilis_positive",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "anaemic")') -> 0 ->> 'values') as "aneamic",
trim(both '[""]' from jsonb_path_query_array(json -> 'obs', '$[] ? (@.formSubmissionField == "hb_result")') -> 0 ->> 'values') as "hemoglobine",
from core.event
where json -> 'eventType' = '"Tests"'
order by id desc;

[junaidwarsivd]

@imukunzi please use this querry for the contact/Visit number
SELECT id,
json -> 'baseEntityId' as basebaseentityid,
json -> 'eventType' as event_type,
json as json,
json -> 'details' -> 'Contact' as contact
from core.event
where json -> 'eventType' = '"Contact Visit"'
order by id desc;

[imukunzi]

@junaidwarsivd @dubdabasoduba @AngelaKabari
I couldn't use these queries as they have errors except the last one for visit number. As for this last query, is not responding to our request, a mother will attend 8 visits/contacts meaning we will have 8 json objects for physical exam for example, having visit number in these objects will help to differentiate these objects of one mother.

[junaidwarsivd]

hi @imukunzi seems like the querries added as a comment got some special characters ignored, you can test the querries from the attached word document

querries.odt

requirement for the Contact visit is noted will be updating that in a while
cc @AngelaKabari @dubdabasoduba

[imukunzi]

Hi @junaidwarsivd @AngelaKabari @dubdabasoduba well received, Let me use the queries and I share feedback.

[junaidwarsivd]

hi @imukunzi we've gone through adding contact visit number in other events such as profile, tests etc requirement, at this point there are no similar ids that can be related to those events via queries so as a workaround we are going to the add the contact visit number while those events are being generated in the client app, we will be sharing PR as soon as we add Conact Visit attribute in contact json cc @AngelaKabari , @dubdabasoduba

[junaidwarsivd]

hi @imukunzi contact number has been added in the events here is the PR for the changes
#872

you will be able to find contact_number under details section of the events i've attached the event json sample for the reference

{"_id": "8725735b-956b-4d2c-8c4e-1df6d877d11f", "obs": [], "_rev": "v1", "team": "Bukesa", "type": "Event", "teamId": "ca2d2f3f-573d-4b99-b060-b1ac1bad3104", "details": {"Contact": "Contact 2", "open_test_tasks": "[\"{\\\"key\\\":\\\"accordion_blood_haemoglobin\\\",\\\"openmrs_entity_parent\\\":\\\"\\\",\\\"openmrs_entity\\\":\\\"\\\",\\\"openmrs_entity_id\\\":\\\"\\\",\\\"text\\\":\\\"Blood Haemoglobin test\\\",\\\"accordion_info_text\\\":\\\"Blood haemoglobin testing is necessary for diagnosing anaemia in pregnancy.\\\",\\\"accordion_info_title\\\":\\\"Blood haemoglobin test\\\",\\\"type\\\":\\\"expansion_panel\\\",\\\"content_form\\\":\\\"tests_blood_haemoglobin_sub_form\\\",\\\"container\\\":\\\"anc_test\\\",\\\"relevance\\\":{\\\"rules-engine\\\":{\\\"ex-rules\\\":{\\\"rules-file\\\":\\\"tests_expansion_panel_relevance_rules.yml\\\"}}},\\\"is_visible\\\":true}\",\"{\\\"key\\\":\\\"accordion_urine\\\",\\\"openmrs_entity_parent\\\":\\\"\\\",\\\"openmrs_entity\\\":\\\"\\\",\\\"openmrs_entity_id\\\":\\\"\\\",\\\"text\\\":\\\"Urine test\\\",\\\"accordion_info_text\\\":\\\"A urine test is required at the first contact, last contact in 2nd trimester, and 2nd contact in 3rd trimester OR anytime the woman reports pain during urination (dysuria). A dipstick test is required if the woman has a repeat high BP reading (140\\\\\\/90 or higher). Otherwise, a urine test is optional. The urine test checks for bacterial or other infections that can lead to adverse outcomes for the neonate. The urine dipstick test can check for proteins in the urine, which can be a sign of pre-eclampsia.\\\",\\\"accordion_info_title\\\":\\\"Urine test\\\",\\\"type\\\":\\\"expansion_panel\\\",\\\"content_form\\\":\\\"tests_urine_sub_form\\\",\\\"container\\\":\\\"anc_test\\\",\\\"relevance\\\":{\\\"rules-engine\\\":{\\\"ex-rules\\\":{\\\"rules-file\\\":\\\"tests_expansion_panel_relevance_rules.yml\\\"}}},\\\"is_visible\\\":true}\",\"{\\\"key\\\":\\\"accordion_syphilis\\\",\\\"openmrs_entity_parent\\\":\\\"\\\",\\\"openmrs_entity\\\":\\\"\\\",\\\"openmrs_entity_id\\\":\\\"\\\",\\\"text\\\":\\\"Syphilis test\\\",\\\"accordion_info_text\\\":\\\"A syphilis test is recommended for all pregnant women at the first contact and again at the first contact of 3rd trimester (28 weeks).\\\",\\\"accordion_info_title\\\":\\\"Syphilis test\\\",\\\"type\\\":\\\"expansion_panel\\\",\\\"content_form\\\":\\\"tests_syphilis_sub_form\\\",\\\"container\\\":\\\"anc_test\\\",\\\"relevance\\\":{\\\"rules-engine\\\":{\\\"ex-rules\\\":{\\\"rules-file\\\":\\\"tests_expansion_panel_relevance_rules.yml\\\"}}},\\\"is_visible\\\":true}\",\"{\\\"key\\\":\\\"accordion_hepatitis_b\\\",\\\"openmrs_entity_parent\\\":\\\"\\\",\\\"openmrs_entity\\\":\\\"\\\",\\\"openmrs_entity_id\\\":\\\"\\\",\\\"text\\\":\\\"Hepatitis B test\\\",\\\"accordion_info_text\\\":\\\"In settings where the proportion of HBsAg seroprevalence in the general population is 2% or higher or in settings where there is a national Hep B ANC routine screening program in place, or if the woman is HIV positive, injects drugs, or is a sex worker, then Hep B testing is recommended.\\\",\\\"accordion_info_title\\\":\\\"Hepatitis B test\\\",\\\"type\\\":\\\"expansion_panel\\\",\\\"content_form\\\":\\\"tests_hepatitis_b_sub_form\\\",\\\"container\\\":\\\"anc_test\\\",\\\"relevance\\\":{\\\"rules-engine\\\":{\\\"ex-rules\\\":{\\\"rules-file\\\":\\\"tests_expansion_panel_relevance_rules.yml\\\"}}},\\\"is_visible\\\":true}\",\"{\\\"key\\\":\\\"accordion_hiv\\\",\\\"openmrs_entity_parent\\\":\\\"\\\",\\\"openmrs_entity\\\":\\\"\\\",\\\"openmrs_entity_id\\\":\\\"\\\",\\\"text\\\":\\\"HIV test\\\",\\\"accordion_info_text\\\":\\\"An HIV test is required for all pregnant women at the first contact in pregnancy and again at the first contact of the 3rd trimester (28 weeks), if the HIV prevalence in the pregnant woman population is 5% or higher. A test isnt required if the woman is already confirmed HIV+.\\\",\\\"accordion_info_title\\\":\\\"HIV test\\\",\\\"type\\\":\\\"expansion_panel\\\",\\\"content_form\\\":\\\"tests_hiv_sub_form\\\",\\\"container\\\":\\\"anc_test\\\",\\\"relevance\\\":{\\\"rules-engine\\\":{\\\"ex-rules\\\":{\\\"rules-file\\\":\\\"tests_expansion_panel_relevance_rules.yml\\\"}}},\\\"is_visible\\\":true}\"]", "previous_contacts": "{\"contact_date\":\"2022-05-26\",\"attention_flag_facts\":\"{\\\"ultrasound_date\\\":\\\"26-05-2022\\\",\\\"severe_preeclampsia\\\":\\\"0\\\",\\\"occupation\\\":\\\"[student]\\\",\\\"isRelevant\\\":false,\\\"select_gest_age_edd_lmp_ultrasound\\\":\\\"ultrasound\\\",\\\"pregest_weight\\\":\\\"50\\\",\\\"flu_immun_status\\\":\\\"seasonal_flu_dose_given\\\",\\\"lmp_edd\\\":\\\"02-03-2023\\\",\\\"ultrasound_gest_age_days\\\":\\\"\\\",\\\"fetal_heartbeat_value\\\":\\\"No\\\",\\\"select_gest_age_edd\\\":\\\"ultrasound\\\",\\\"bp_diastolic\\\":\\\"20\\\",\\\"select_gest_age_edd_sfh_ultrasound\\\":\\\"0\\\",\\\"medications\\\":\\\"[none]\\\",\\\"blood_type_test_date_today_hidden\\\":\\\"26-05-2022\\\",\\\"danger_signs\\\":\\\"[danger_none]\\\",\\\"medications_value\\\":\\\"None\\\",\\\"height\\\":\\\"150\\\",\\\"tobacco_user_value\\\":\\\"No\\\",\\\"eat_exercise_counsel\\\":\\\"done\\\",\\\"preeclampsia\\\":\\\"0\\\",\\\"severe_hypertension\\\":\\\"0\\\",\\\"lmp_known_value\\\":\\\"Yes\\\",\\\"toaster26_hidden\\\":\\\"0\\\",\\\"no_of_fetuses\\\":\\\"1\\\",\\\"blood_type_test_date\\\":\\\"26-05-2022\\\",\\\"weight_gain\\\":\\\"0\\\",\\\"other_symptoms_value\\\":\\\"None\\\",\\\"ipv_suspect\\\":\\\"0\\\",\\\"danger_signs_value\\\":\\\"None\\\",\\\"gest_age\\\":\\\"14 weeks 0 days\\\",\\\"ultrasound_ga_hidden\\\":\\\"0\\\",\\\"ultrasound_gest_age_wks\\\":\\\"14\\\",\\\"ultrasound_done_value\\\":\\\"Yes\\\",\\\"tobacco_user\\\":\\\"no\\\",\\\"exp_weight_gain\\\":\\\"11.5 - 16\\\",\\\"pulse_rate\\\":\\\"80\\\",\\\"tt_immun_status\\\":\\\"3_doses\\\",\\\"weight_gain_duration\\\":\\\"0\\\",\\\"family_planning_counsel_value\\\":\\\"Done\\\",\\\"caffeine_intake\\\":\\\"[none]\\\",\\\"flu_immun_status_value\\\":\\\"Fully immunized\\\",\\\"partner_hiv_status_value\\\":\\\"Negative\\\",\\\"phys_symptoms_value\\\":\\\"None\\\",\\\"yes_value\\\":\\\"26-05-2022\\\",\\\"bmi\\\":\\\"22.22\\\",\\\"family_planning_type\\\":\\\"none\\\",\\\"blood_type_test_status\\\":\\\"done_today\\\",\\\"family_planning_type_value\\\":\\\"None\\\",\\\"ultrasound_edd\\\":\\\"24-11-2022\\\",\\\"gest_age_openmrs\\\":\\\"14\\\",\\\"allergies_value\\\":\\\"None\\\",\\\"select_gest_age_edd_all_values\\\":\\\"0\\\",\\\"gdm_risk\\\":\\\"0\\\",\\\"lmp_known_date\\\":\\\"26-05-2022\\\",\\\"ultrasound_date_today_hidden\\\":\\\"0\\\",\\\"hiv_risk\\\":\\\"0\\\",\\\"rh_factor\\\":\\\"positive\\\",\\\"eat_exercise_counsel_value\\\":\\\"Done\\\",\\\"helper\\\":null,\\\"ultrasound_done_date\\\":\\\"26-05-2022\\\",\\\"blood_type_test_status_value\\\":\\\"Done today\\\",\\\"ultrasound_value\\\":\\\"Done earlier\\\",\\\"alcohol_substance_enquiry_value\\\":\\\"No\\\",\\\"edd\\\":\\\"24-11-2022\\\",\\\"phys_symptoms\\\":\\\"[none]\\\",\\\"marital_status_value\\\":\\\"Married or living together\\\",\\\"weight_cat\\\":\\\"Normal Weight\\\",\\\"hiv_positive\\\":\\\"0\\\",\\\"family_planning_counsel\\\":\\\"done\\\",\\\"occupation_value\\\":\\\"Student\\\",\\\"fetal_heartbeat\\\":\\\"no\\\",\\\"bp_systolic\\\":\\\"20\\\",\\\"first_weight\\\":\\\"50\\\",\\\"lmp_ultrasound_gest_age_selection_value\\\":\\\"Using ultrasound\\\",\\\"sfh_edd\\\":\\\"0\\\",\\\"tt_immun_status_value\\\":\\\"Fully immunized\\\",\\\"tot_weight_gain\\\":\\\"30\\\",\\\"current_weight\\\":\\\"80\\\",\\\"lmp_gest_age\\\":\\\"0 weeks 0 days\\\",\\\"lmp_ultrasound_gest_age_selection\\\":\\\"ultrasound\\\",\\\"lmp_known\\\":\\\"yes\\\",\\\"allergies\\\":\\\"[none]\\\",\\\"preeclampsia_risk\\\":\\\"0\\\",\\\"partner_hiv_positive\\\":\\\"0\\\",\\\"alcohol_substance_use\\\":\\\"[none]\\\",\\\"alcohol_substance_use_value\\\":\\\"None\\\",\\\"parity\\\":\\\"0\\\",\\\"partner_hiv_status\\\":\\\"negative\\\",\\\"contact_reason\\\":\\\"first_contact\\\",\\\"ultrasound_gest_age_concept\\\":\\\"0\\\",\\\"educ_level_value\\\":\\\"None\\\",\\\"rh_factor_value\\\":\\\"Positive\\\",\\\"ultrasound_done\\\":\\\"yes\\\",\\\"educ_level\\\":\\\"none\\\",\\\"blood_type\\\":\\\"a\\\",\\\"other_symptoms\\\":\\\"[none]\\\",\\\"anaemic\\\":\\\"0\\\",\\\"sfh_ga_hidden\\\":\\\"0\\\",\\\"no_of_fetuses_hidden\\\":\\\"0\\\",\\\"yes\\\":\\\"[26-05-2022]\\\",\\\"contact_reason_value\\\":\\\"First contact\\\",\\\"ultrasound_gest_age\\\":\\\"14 weeks 0 days\\\",\\\"caffeine_intake_value\\\":\\\"None of the above\\\",\\\"ultrasound\\\":\\\"done_earlier\\\",\\\"marital_status\\\":\\\"married\\\",\\\"previous_pregnancies\\\":\\\"0\\\",\\\"alcohol_substance_enquiry\\\":\\\"no\\\",\\\"blood_type_value\\\":\\\"A\\\",\\\"hypertension\\\":\\\"0\\\",\\\"gravida\\\":\\\"1\\\",\\\"body_temp\\\":\\\"35\\\"}\",\"family_planning_type\":\"none\",\"family_planning_counsel\":\"done\",\"eat_exercise_counsel\":\"done\",\"invisible_required_fields_counselling_and_treatment\":\"[balanced_energy_counsel, balanced_energy_counsel_notdone, referred_hosp_notdone, eat_exercise_counsel_notdone, referred_hosp, increase_energy_counsel_notdone, increase_energy_counsel]\",\"rh_factor\":\"positive\",\"blood_type\":\"a\",\"blood_type_test_date\":\"26-05-2022\",\"blood_type_test_date_today_hidden\":\"26-05-2022\",\"blood_type_test_status\":\"done_today\",\"preeclampsia_risk\":\"0\",\"no_of_fetuses\":\"1\",\"no_of_fetuses_hidden\":\"0\",\"ultrasound_date\":\"26-05-2022\",\"ultrasound_date_today_hidden\":\"0\",\"ultrasound\":\"done_earlier\",\"invisible_required_fields_tests\":\"[ultrasound_notdone, blood_type, blood_type_test_date, rh_factor]\",\"fetal_heartbeat\":\"no\",\"ipv_suspect\":\"0\",\"toaster26_hidden\":\"0\",\"anaemic\":\"0\",\"pulse_rate\":\"80\",\"body_temp\":\"35\",\"preeclampsia\":\"0\",\"severe_preeclampsia\":\"0\",\"severe_hypertension\":\"0\",\"hypertension\":\"0\",\"bp_diastolic\":\"20\",\"bp_systolic\":\"20\",\"tot_weight_gain\":\"30\",\"weight_gain\":\"0\",\"weight_gain_duration\":\"0\",\"exp_weight_gain\":\"11.5 - 16\",\"weight_cat\":\"Normal Weight\",\"gdm_risk\":\"0\",\"bmi\":\"22.22\",\"first_weight\":\"50\",\"current_weight\":\"80\",\"pregest_weight\":\"50\",\"height\":\"150\",\"invisible_required_fields_physical_exam\":\"[fetal_presentation, symp_sev_preeclampsia, fetal_heart_rate_label, cant_record_bp_reason, body_temp_repeat_label, fetal_heart_rate, bp_diastolic_repeat, ipv_subject, fetal_heart_rate_repeat, bp_systolic_repeat_label, pulse_rate_repeat, bp_systolic_repeat, urine_protein, bp_diastolic_repeat_label, pulse_rate_repeat_label, body_temp_repeat, fetal_heart_rate_repeat_label]\",\"other_symptoms\":\"[none]\",\"phys_symptoms\":\"[none]\",\"invisible_required_fields_symptoms_and_follow-up\":\"[other_sym_lbpp, other_sym_vvo, medications, mat_percept_fetal_move]\",\"hiv_risk\":\"0\",\"partner_hiv_positive\":\"0\",\"partner_hiv_status\":\"negative\",\"alcohol_substance_use\":\"[none]\",\"alcohol_substance_enquiry\":\"no\",\"tobacco_user\":\"no\",\"caffeine_intake\":\"[none]\",\"medications\":\"[none]\",\"flu_immun_status\":\"seasonal_flu_dose_given\",\"tt_immun_status\":\"3_doses\",\"hiv_positive\":\"0\",\"allergies\":\"[none]\",\"parity\":\"0\",\"previous_pregnancies\":\"0\",\"gravida\":\"1\",\"edd\":\"24-11-2022\",\"gest_age_openmrs\":\"14\",\"gest_age\":\"14 weeks 0 days\",\"select_gest_age_edd\":\"ultrasound\",\"select_gest_age_edd_sfh_ultrasound\":\"0\",\"select_gest_age_edd_lmp_ultrasound\":\"ultrasound\",\"select_gest_age_edd_all_values\":\"0\",\"lmp_ultrasound_gest_age_selection\":\"ultrasound\",\"sfh_ga_hidden\":\"0\",\"sfh_edd\":\"0\",\"ultrasound_gest_age\":\"14 weeks 0 days\",\"ultrasound_ga_hidden\":\"0\",\"ultrasound_edd\":\"24-11-2022\",\"ultrasound_gest_age_concept\":\"0\",\"ultrasound_gest_age_wks\":\"14\",\"ultrasound_done_date\":\"26-05-2022\",\"yes\":\"[26-05-2022]\",\"yes_value\":\"26-05-2022\",\"ultrasound_done_value\":\"Yes\",\"ultrasound_done\":\"yes\",\"lmp_gest_age\":\"0 weeks 0 days\",\"lmp_edd\":\"02-03-2023\",\"lmp_known_date\":\"26-05-2022\",\"lmp_known_value\":\"Yes\",\"lmp_known\":\"yes\",\"occupation\":\"[student]\",\"marital_status\":\"married\",\"educ_level\":\"none\",\"invisible_required_fields_profile\":\"[lmp_gest_age_selection, ultrasound_gest_age_selection, live_births, hiv_diagnosis_date, c_sections, sfh_gest_age, sfh_ultrasound_gest_age_selection, miscarriages_abortions, c_sections_label, stillbirths, live_births_label, stillbirths_label, miscarriages_abortions_label, sfh_gest_age_selection, prev_preg_comps]\",\"danger_signs\":\"[danger_none]\",\"contact_reason\":\"first_contact\",\"invisible_required_fields_quick_check\":\"[specific_complaint]\",\"contact_schedule\":\"[22, 28, 32, 36, 38, 40, 41]\"}", "form_submission_ids": "[7879be1e-2d8e-4695-9889-ebe9dfdf9b4a, 20a5b6cc-c872-43a7-9ec3-a5279c064641, 5bef900d-e5e1-4873-8ae8-7304571ac01c, 861a904f-065b-4fd9-8ac0-3c71e4ff3ac7, cbe3672e-0d38-4015-ad4e-b9e53514934f, f40285f2-c50c-43de-a588-362dd2cc41d8]", "attention_flag_facts": "{\"ultrasound_date\":\"26-05-2022\",\"severe_preeclampsia\":\"0\",\"occupation\":\"[student]\",\"isRelevant\":false,\"select_gest_age_edd_lmp_ultrasound\":\"ultrasound\",\"pregest_weight\":\"50\",\"flu_immun_status\":\"seasonal_flu_dose_given\",\"lmp_edd\":\"02-03-2023\",\"ultrasound_gest_age_days\":\"\",\"fetal_heartbeat_value\":\"No\",\"select_gest_age_edd\":\"ultrasound\",\"bp_diastolic\":\"20\",\"select_gest_age_edd_sfh_ultrasound\":\"0\",\"medications\":\"[none]\",\"blood_type_test_date_today_hidden\":\"26-05-2022\",\"danger_signs\":\"[danger_none]\",\"medications_value\":\"None\",\"height\":\"150\",\"tobacco_user_value\":\"No\",\"eat_exercise_counsel\":\"done\",\"preeclampsia\":\"0\",\"severe_hypertension\":\"0\",\"lmp_known_value\":\"Yes\",\"toaster26_hidden\":\"0\",\"no_of_fetuses\":\"1\",\"blood_type_test_date\":\"26-05-2022\",\"weight_gain\":\"0\",\"other_symptoms_value\":\"None\",\"ipv_suspect\":\"0\",\"danger_signs_value\":\"None\",\"gest_age\":\"14 weeks 0 days\",\"ultrasound_ga_hidden\":\"0\",\"ultrasound_gest_age_wks\":\"14\",\"ultrasound_done_value\":\"Yes\",\"tobacco_user\":\"no\",\"exp_weight_gain\":\"11.5 - 16\",\"pulse_rate\":\"80\",\"tt_immun_status\":\"3_doses\",\"weight_gain_duration\":\"0\",\"family_planning_counsel_value\":\"Done\",\"caffeine_intake\":\"[none]\",\"flu_immun_status_value\":\"Fully immunized\",\"partner_hiv_status_value\":\"Negative\",\"phys_symptoms_value\":\"None\",\"yes_value\":\"26-05-2022\",\"bmi\":\"22.22\",\"family_planning_type\":\"none\",\"blood_type_test_status\":\"done_today\",\"family_planning_type_value\":\"None\",\"ultrasound_edd\":\"24-11-2022\",\"gest_age_openmrs\":\"14\",\"allergies_value\":\"None\",\"select_gest_age_edd_all_values\":\"0\",\"gdm_risk\":\"0\",\"lmp_known_date\":\"26-05-2022\",\"ultrasound_date_today_hidden\":\"0\",\"hiv_risk\":\"0\",\"rh_factor\":\"positive\",\"eat_exercise_counsel_value\":\"Done\",\"helper\":null,\"ultrasound_done_date\":\"26-05-2022\",\"blood_type_test_status_value\":\"Done today\",\"ultrasound_value\":\"Done earlier\",\"alcohol_substance_enquiry_value\":\"No\",\"edd\":\"24-11-2022\",\"phys_symptoms\":\"[none]\",\"marital_status_value\":\"Married or living together\",\"weight_cat\":\"Normal Weight\",\"hiv_positive\":\"0\",\"family_planning_counsel\":\"done\",\"occupation_value\":\"Student\",\"fetal_heartbeat\":\"no\",\"bp_systolic\":\"20\",\"first_weight\":\"50\",\"lmp_ultrasound_gest_age_selection_value\":\"Using ultrasound\",\"sfh_edd\":\"0\",\"tt_immun_status_value\":\"Fully immunized\",\"tot_weight_gain\":\"30\",\"current_weight\":\"80\",\"lmp_gest_age\":\"0 weeks 0 days\",\"lmp_ultrasound_gest_age_selection\":\"ultrasound\",\"lmp_known\":\"yes\",\"allergies\":\"[none]\",\"preeclampsia_risk\":\"0\",\"partner_hiv_positive\":\"0\",\"alcohol_substance_use\":\"[none]\",\"alcohol_substance_use_value\":\"None\",\"parity\":\"0\",\"partner_hiv_status\":\"negative\",\"contact_reason\":\"first_contact\",\"ultrasound_gest_age_concept\":\"0\",\"educ_level_value\":\"None\",\"rh_factor_value\":\"Positive\",\"ultrasound_done\":\"yes\",\"educ_level\":\"none\",\"blood_type\":\"a\",\"other_symptoms\":\"[none]\",\"anaemic\":\"0\",\"sfh_ga_hidden\":\"0\",\"no_of_fetuses_hidden\":\"0\",\"yes\":\"[26-05-2022]\",\"contact_reason_value\":\"First contact\",\"ultrasound_gest_age\":\"14 weeks 0 days\",\"caffeine_intake_value\":\"None of the above\",\"ultrasound\":\"done_earlier\",\"marital_status\":\"married\",\"previous_pregnancies\":\"0\",\"alcohol_substance_enquiry\":\"no\",\"blood_type_value\":\"A\",\"hypertension\":\"0\",\"gravida\":\"1\",\"body_temp\":\"35\"}"}, "version": 1653574661905, "duration": 0, "eventDate": "2022-05-26T19:17:41.905Z", "eventType": "Contact Visit", "entityType": "contact", "locationId": "44de66fb-e6c6-4bae-92bb-386dfe626eba", "providerId": "demo", "dateCreated": "2022-05-26T14:30:47.032Z", "identifiers": {}, "baseEntityId": "be0bf4e3-18be-4cec-a100-1253b48b8c5a", "serverVersion": 4214, "formSubmissionId": "90d5c7cd-dd2e-43c3-84eb-094e58d69d0c", "clientDatabaseVersion": 3, "clientApplicationVersion": 49}

cc @AngelaKabari @dubdabasoduba

[AngelaKabari]

Innocent has confirmed that the issue has been satisfactorily resolved and can therefore be closed.