Content Comparison

SELV

SELV is a legacy version of OpenLMIS maintained by VillageReach. As such, the SELV-Dashboard will be able to directly connect to its database. Please see the Credentials page for connectivity details.

A somewhat dated ERD diagram may be found here. Note that a table called facility_visits_report exists within the database but, because it's not used by OpenLMIS directly, does not appear in the ERD diagram. It's populated by an ETL script run daily and is one of very few tables from with VillageReach's internal Tableau reports pull data. Due to the size of the facility_visits_report table, it may be preferable to draw data from  with the source (OLTP) tables instead.

SELV includes the following form, which seems to offer everything necessary to report on stockout days: 

...

Open Questions

Q: If possible, Christine Lenihan or Timoteo Chaluco (Unlicensed), will you please edit the above table such that each value in the left column has a corresponding one in the right column?

Q: The existing Excel dashboard includes the province of “Inhambane” on the Dados_Stock sheet. I don’t see Inhambane in SELV, though. Can you please confirm whether it exists in SELV and, if not, where its information comes from?




SIS-MA (DHIS-2)

Please see the Credentials page for details.
Timoteo Chaluco (Unlicensed) Which  Two Questions:

1. Can you create a step by step walk through of how you get the information from DHIS2 and show where you paste it into the dashboard? This will allow us to match the reports to the API.
2. Which API endpoints do we get the data values from for each vaccine? From going through the DHIS2 API documentation, to get national coverage per vaccine, we need to query the dataValueSets JSON endpoint with dataSet ID, period and organization unit ID. How do we know which parameters to use because querying all the data Elements and organization units provide a long list on the facility level?
   
   e-SISTAFE

The file to be used for the dashboard is the "Execucao da GAVI ate 31-12-2017.xlsx" - Further updates to be provided

...

SMT

The SMT is a static Excel tool provided by the WHO for province level stock management. We can consider it an immutable data sources.

...