2018-06-18 Daily Standup

Date

18 Jun 2018

The team feels comfortable with finishing an initial version of the system, complete end to end functionality, by 6/26. The goal is to demo the system to user-representatives like Timoteo Chaluco (Unlicensed) then. We'll then have several days prior to month's end to attempt to incorporate any feedback they provide.
During the testing and development phase, the SQL responsible for creating a materialized view will reside in Superset. Prior to going into production, though, we'll move it into NiFi in order to avoid the overhead of running it every time a user accesses the dashboard.
To help reduce the likelihood of malicious and/or erroneous data getting into the system, we should only process data submitted by known and trusted email addresses.
We have a script used to backup our postgres databases nearly complete. We can use ExecuteStreamCommand to easily have NiFi call it prior to changing any database state, and should plan to do so.
The first spreadsheet in this file contains the first two columns show below. The third column, titled "Description," is how Timoteo said we should interpret the rows.

Organisation unit description	Organisation unit ID	Description
POP - 3.9 perc População Polio/DPT/HepB/VAS/CCV/PVC10	uhAcJkYENXE	We target 3.9% of the population for this vaccine (Polio, DPT, etc.)
POP - 4 perc População BCG/Polio primario/consultas 0-11 meses	sTIec6HXB8U	Polio primario == Polio Zero == A primer dose of the antigen. Regarding the last clause: we target 4 percent of the population to have consultation within the first 11 months of life (post birth).
POP - 4.5 perc População Partos /C.Post-Parto	D1HgqDPmaow	Of the mothers who have given birth, we expect 4.5 percent of them to come to consultation. (We don't use this).

We can ignore most of the rows (percentages) in the aforementioned file by instead focusing on Steps to extract SISMA_DHIS2_EPI Coverage Data.doc