| Table of Contents |
|---|
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 (
...
DHIS2)
Please see the Credentials page for details.
Timoteo Chaluco (Unlicensed) Two Questions:
...
View file name Desmostrativo Consolidado actualizado.xls height 250 View file name Execucao da GAVI ate 31-12-2017.xlsx height 150 View file name Execucao da GAVI ate 31-12-2017_DDuvane.xlsx height 250
NexLeaf
NexLeaf won't be able to offer an API which exposes raw data prior to the end of June. They'll instead provide an endpoint which, when accessed with the correct credentials, returns an imagine which looks like this.
...
What do you think, Clay Crosby (Unlicensed)? Perhaps a next-step would be for Dércio Duvane and Timoteo Chaluco (Unlicensed) to confirm that reliance on the NexLeaf imagery shown above would be okay.
Trimestral Reports
On a trimestral basis, provinces send to the central level a summary report in word format containing multiple indicators for the HSS Province Performance. This report, Relatório Descritivo de Actividades HSS_Provincias includes the following KPI's per district:
...
| View file | ||||
|---|---|---|---|---|
|
| View file | ||||
|---|---|---|---|---|
|
| View file | ||||
|---|---|---|---|---|
|
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.
| View file | ||||
|---|---|---|---|---|
|
...