[SNCU Support] Move reports to ETL

[nupoorkhandelwal]

Support ticket - https://avni.freshdesk.com/a/tickets/2294

• [ ] Update all the following reports to use ETL and remove error if any -

https://docs.google.com/spreadsheets/d/15U3mOkcVjHhXlr318uj8DRQNzC6mBOTf-GEPf9SLfTM/edit#gid=1150649020

[nupoorkhandelwal]

Estimates - Since this a card on which reword of checking and fixing the reports is being done, remaining estimate is 3-4 hrs approx

[AchalaBelokar]

• [ ] Children milestone report old report

new report

[AchalaBelokar]

[ ] Cohort wise report

• Month6_status_normal is mismatch with old one by 1
• Month12_status_exited
• there are other mismatch also -

[AchalaBelokar]

• [ ] Immunisation of Children no mismatch

[AchalaBelokar]

• [ ] KMC Care

[BEULAHEVANJALIN]

Aggregate:

• [x] Child Death
• [x] Child growth monitoring
• [x] Child growth monitoring 7 months to 5 years
• [x] Child - Morbidity Status Within 0-59 Days
• [x] Children milestone report
• [x] Cohort wise report
• [x] Growth Monitoring (nutritional status)
• [x] Immunisation of Children
• [x] KMC Care
• [x] Newborn care
• [x] Registration Form based reports
• [x] Registration of children
• [x] SNCU Form based reports
• [ ] Task generated and task completed

Linelists:

• [x] Child - Morbidity Status for Children 0-59 days Linelist
• [x] Child - Program Exit Linelist
• [x] Child PNC Linelist
• [x] Child wise linelist report
• [x] Growth Monitoring(nutritional status) Linelist
• [x] Linelist for child growth monitoring

---

• [x] Linelist for child growth monitoring 7 month to 5 years
• [x] Linelist for fully immunised children
• [x] Linelist for immunisation of children
• [x] Linelist for KMC Care
• [x] Linelist for milestone report
• [x] Linelist for registration form based reports
• [x] Linelist for SNCU form based report
• [ ] Task generated child nutrition

[BEULAHEVANJALIN]

Generic queries: https://gist.github.com/BEULAHEVANJALIN/7a2d6ad2514bc99954b1ff8013bc080e

[nupoorkhandelwal]

ETA - 7 days.

[nupoorkhandelwal]

select * from program_enrolment where id in( 122276, 122626); Need to get right address for these individuals.

[Gojo-Taqi]

• For the report KMC care, there is one individual which is giving incorrect value for indicator "No of children with LBW"