Add children due and stock needed reports [LMH]

[rowo]

Summary

Client today decided this is the top priority for the period before March 13. So we'll need to work on what we can as the frontend gets defined in the next few days. @rkodev has mentioned starting with the schema redesign.

Known (about 80% signed off I think) They are good with Marvel workflow

• Reports will be needed for both the CHA and CHSS users. The difference would be the CHSS can select which villages they want to filter by whereas the CHA user would have only their village default-filtered.
• Report 1 = Need to generate a list of all children due for a vaccine (i.e. not the monthly household visit) — in a particular community (for the CHA app) or user-selected set of communities in a supervisor area (for the CHSS app); on a user-selected date (today or a date in the future).
• Report 2 = Need to generate a list of vaccine doses due for each antigen — in a particular community (for the CHA app) or user-selected set of communities in a supervisor area (for the CHSS app); on a user-selected date (today or a date in the future). Aggregate doses for each antigen when user selects multiple communities.
• Notes on logic
  • Calculation assumes no vaccines are given in the period from now to the future date and no new children will be registered.
  • Service expiration dates are valid — meaning if a child is or will become eligible and then the eligibility expires before user-defined date, then that child is not included in the count

Unknown This is signed off and labels updated to what they want.

• Workflow is still not signed off on. Round 2 designs are on Marvel, which proposes replacing Job Aid with a page that links to three reports, moving the existing charts on job aids to a button.
• Labels and name of reports is not signed off

Similar functionality in other projects

• WCARO may have a simplified version of this where tapping a chart would show the list of children due for vaccines for CHWs. (So there would be no step to select a date and no supervisor app so no option to select a village.)

[rkodev]

@rowo can I get the icon for the reports?

[rowo]

@rkodev you can use the same icon from Job Aids

[rkodev]

done

[rowo]

@rkodev Recommended edits to 5 Mar release:

@AnnieMungai I only looked at the CHA view. Can you look at the CHSS as well?

Eligible children report

• I'm did not explore checking the logic on if the right kids are calculated as due in the reports on future dates, but @AnnieMungai if you can discuss with @rkodev see if that's doable please try. I will say there is a flaw since when I choose a very far date like 4 Sep, the same 11 kids are due with the same vaccines that should have expired. Maybe those things aren't actually set to expire because of the back entry?
• The design just listed out each vaccine as an item so that's what the client is expecting, but this should be okay and maybe it's nicer to see all the individual items. So no change needed here.
• The kids need last name here I think even though it's listed in the family below
• The rows don't currently go to the profile like they should, but I assume that's known

Doses needed report

• Can we show only the total number be here? These vaccines are actually the same item no matter which number for the child they are. So the total is the main thing to look at.
• Can the vaccines be ordered consistently easily?
• Is there an easy way to get the data into a simple table? I was hoping this would be quicker but it's a bit hard to read.

Community pull down

• The CHA should not have the "All communities" choice, just their community selected by default. If they have multiple communities they should be able to choose between those. I think if we don't want to add logic to this to handle CHAs with multiple communities, that would be better than having an "All Community"option show up for everyone.

Data selector

• Is the selector that is DD three-character-month YYYY not available easily?

Report home

• The reports tab should be highlighted when the tab is active

[AnnieMungai]

App Version 0.0.3 (6th March) Eligible children report – CHSS Acc. Was able to see all the CHAs reports by selecting the CHA under the CHSS.

• [ ] Children still have one displayed.
• [x] Same eligible children remain even with a date in the future.
• [ ] After registering a home visit and updating a child’s record on immunizations, they are not reflecting on the report. Used today’s date and a future date.
• [ ] @rowo Question: After how long is the report updated once a home visit is done and vaccines updated on the child's record? Will it have to wait until the CHA sync's data with CHSS or the server?

Doses needed report- CHSS Acc Was able to see all the CHAs reports by selecting the CHA under the CHSS.

• [ ] Computation remains unchanged even when looking at a future date.
• [ ] Is there a way to order the vaccines based on the time they are given? E.g. Birth vaccines, followed by 6 weeks, then 10 weeks etc.
• [ ] Reports tab is not active even when on the reports.
• [ ] @rowo Questions for thought: Where do the records that a CHSS registers go? I would assume they would be assigned to the CHA responsible for the village the family registered come from. This is not currently the case as all the records under CHSS remain under CHSS. What happens for home visits? Does the CHSS go for home visits?
• [x] @rowo Will this pointer lead to the child's profile?

[rkodev]

@rowo @AnnieMungai

I'm did not explore checking the logic on if the right kids are calculated as due in the reports on future dates, but @AnnieMungai if you can discuss with @rkodev see if that's doable please try. I will say there is a flaw since when I choose a very far date like 4 Sep, the same 11 kids are due with the same vaccines that should have expired. Maybe those things aren't actually set to expire because of the back entry?

1. Initially, the report would list all the children who are due for a vaccine by that date, regardless of whether the vaccine is expired but only if the child is eligible, the reasoning was that this is a planning report but I have adjusted the report to respect the expiry date as well. 2. The report currently filters by expiry but most of the vaccines have a 2 yr window, apart from OPV 0, to expire yet the filter is capped at 6 months. The differences are thus not very visible. https://github.com/OpenSRP/opensrp-client-chw/blob/master/opensrp-chw/src/lmh/assets/vaccines.json We can adjust this window period to more than 2 yrs

The design just listed out each vaccine as an item so that's what the client is expecting, but this should be okay and maybe it's nicer to see all the individual items. So no change needed here. Left this as is

The kids need last name here I think even though it's listed in the family below Bug has been resolved

The rows don't currently go to the profile as they should, but I assume that's known Feature has been added

Can we show only the total number be here? These vaccines are actually the same item no matter which numbers for the child they are. So the total is the main thing to look at. Done, grouped all vaccines regardless of the doses

Can the vaccines be ordered consistently easily? I have ordered the content with first due date

Is there an easy way to get the data into a simple table? I was hoping this would be quicker but it's a bit hard to read. Done minor improvements on the report

The CHA should not have the "All communities" choice, just their community selected by default. If they have multiple communities they should be able to choose between those. I think if we don't want to add logic to this to handle CHAs with multiple communities, that would be better than having an "All Community" option show up for everyone. we can work on this later as discussed

Is the selector that is DD three-character-month YYYY not available easily? later release

Ann response

Same eligible children remain even with a date in the future. addressed above After registering a home visit and updating a child’s record on immunizations, they are not reflecting on the report. Used today’s date and a future date. resolved

Computation remains unchanged even when looking at a future date. same issue with expiry duration

Is there a way to order the vaccines based on the time they are given? E.g. Birth vaccines, followed by 6 weeks, then 10 weeks etc. done Reports tab is not active even when on the reports. Resolved

@rowo Will this pointer lead to the child's profile? Resolved