ETL MPR needs assessments

[sachsk]

Old report : https://reporting.avniproject.org/question/1639-mpr-needs-assessment?start_date=2022-05-01&end_date=2022-05-31

New report: https://reporting.avniproject.org/question/2155-mpr-needs-assessment?start_date=2022-05-01&end_date=2022-05-31

[vinayvenu]

The old and new report numbers do not match.

[sachsk]

Number of Home visits by ASHA worker to all Eligible couples
select count(distinct ind.id) from ihmp.individual ind left outer join ihmp.individual_eligible_couple_needs_assessment enc on enc.individual_id = ind.id left outer join ihmp.individual_eligible_couple enl on enl.individual_id = ind.id where ind."Whether sterilized" notnull and encounter_date_time notnull and enl.program_exit_date_time isnull and ind.is_voided = false and enl.is_voided = false and encounter_date_time::date between '04/01/2022'::date and '06/29/2022'::date ;

Number of Home visits by ASHA worker to all sterilized Eligible couples
`select count(distinct ind.id)
from ihmp.individual ind
left join ihmp.individual_eligible_couple enl on enl.individual_id = ind.id

where ind."Whether sterilized" notnull
-- and encounter_date_time notnull
and enl.program_exit_date_time isnull
and ind.is_voided = false
and enl.is_voided = false
and ind.gender = 'Female'
and ind."Marital status" = 'Currently married'
and extract('years' from age(ind.date_of_birth)) <= 49`