ETL Not Populating entire Growth Monitoring Decision Concept Columns (Weight/Height Status) in Reporting Views

[poojaharmalkar]

Issue:
Organization Name: JSSCP (Production)

I have selected decision concepts of encounter 'Growth Monitoring' that I want as columns in the reporting views. which are 'Weight for age Status','Height for age Status' and 'Weight for Height Status'.

Although all individual with Growth Monitoring have these data in the corresponding encounter(Since 2021), but in actual very few individual are shown with data for these columns in ETL for table 'individual_phulwari_growth_monitoring'.

Steps to Produce

• Select the Required column for the the reporting views from Growth monitoring Decision Rule.
• Run below query for delete the ETL
• select delete_etl_metadata_for_schema('$impl_schema', '$impl_db_user', '$impl_db_owner');
• After the process is done check value in corresponding columns in 'individual_phulwari_growth_monitoring'

Actual Result
In 'individual_phulwari_growth_monitoring' table very few encounter shows the data in 'Weight for age Status','Height for age Status' and 'Weight for Height Status columns.

Expected Result
The system is capturing the data in Decision concept 'Weight for age Status','Height for age Status' and 'Weight for Height Status' for very long time. So the data should be populated in most of the Growth Monitoring encounter.

Screenshot for reference

Below is the query for actual count of occurance of (Height for age Status)

select enc.observations ->> '60566bc3-018b-409a-82fc-a5d7a2a3e144', count(*)
from program_encounter enc
where enc.encounter_type_id = 81
and enc.observations ->> '60566bc3-018b-409a-82fc-a5d7a2a3e144' is not null
group by 1;

Few encounter with Data in 'Weight for age Status','Height for age Status' and 'Weight for Height Status' columns

Most of the rows with no data in 'Weight for age Status','Height for age Status' and 'Weight for Height Status' columns