End Fund Changes: Split of the End Fund Dashboard

[samkanga]

Akros would like to split the existing MDA Lite Dashboard into STC MDA Reporting and SCH MDA Reporting. See below a sample mock up of their presentation.

Below are the differences between the two dashboards:

STC MDA Reporting

• This dashboard should only use values for when STH is selected for the question What NTD was treated? on the CDD Supervisor Daily Summary form.
• Supervisor Distributed column should be a total of Albendazole_received + Mebendezole_received which comes from the Tablet Accountability Form.
• Returned to supervisor should be a total of Albendazole_returned + Mebendazole_returned which comes from the Tablet Accountability Form.
• The column name Administered on the Drug Distribution section should change to Total Administered.
• Add two columns before Total Administered column. The two columns will read ALB administered and MBZ administered. The Total Administered = ALB administered + MBZ administered.

SCH MDA Reporting

• This dashboard should only use values for when SCH is captured for the question What NTD was treated? on the CDD Supervisor Daily Summary form.
• Do not include ages 1-4 to the Male and Female count.
• Do not include ages 1-4 to Total Males and Total Female.
• Remove Albendazole_returned and Mebendazole_returned values on the Drug Distribution table so that Supervisor Distributed will be PZQ_received+PZQ_top_up`.
• The administered column under drug distribution table, should be renamed PZQ Administered.
• The value for Returned to Supervisor will be gotten from PZQ_returned.

[samkanga]

@ciremusyoka could you help with estimation of the LoE for the above proposed changes. Let's not start work on this until we get a go ahead.

[ciremusyoka]

@moshthepitt my thought is:
On the DWH views my thought is we modify the existing views to include bothSTC reports and SCH reports instead of spiting each view into two. E.g for drugs_administered we have STC_drugs_administered and SCH_drugs_administered.

[moshthepitt]

@ciremusyoka sounds like a good approach. I think that the resourcing for this issue should consider that the great majority of this work will be done at the database level. The web app will just be displaying what its given. So for an ETA we need to answer primarily: what needs to be changed in the DB views already existing? How much time will that take? The web app part thereafter should just be a day or so.