| Table of Contents |
|---|
...
Note that, as shown below, the collection of productgroupname members returned by the above query is a superset of the products listed in column C of Dados_Stock in the existing Excel dashboard.
| Column C of Dados_Stock | D:20 - D28 in Dashboard_Indicators_List | productgroupname Values Return by the Above OpenLMIS Query |
|---|---|---|
| BCG | BCG | BCG |
| Polio | OPV | Polio |
| PCV | PCV | PCV10 or PCV13 or PCV |
| DPT | DPT | Pentavalent |
| Sarampo * | ||
| Rotavirus | RV Rotarix | RV Rotarix |
| IPV | IPV | IPV |
| VAT | VAT | VAT |
| HPV | ||
| Sarampo 2 MSD * | ||
| Diluente Sarampo | ||
| Diluente Sarampo 2 MSD | ||
| Diluente BCG | ||
| Measles | ||
| VAS (Measles) |
* OpenLMIS treats "Sarampo" and "Sarampo 2 MSD" as two separate antigens. It really shouldn't though - they both refer to an antigen called "MR" (which stands for Measles and Rubella.) Although the SELV+ Dashboard currently references "Sarampo," it should instead just list "MR" (which, again, should represent a combination of OpenLMIS' "Sarampo" and "Sarampo 2 MSD".
The above table includes several items which appear in OpenLMIS but not the original version of the SELV+ Dashboard. These items do not need to appear in the new version of the SELV+ dashboard either.
The existing Excel dashboard includes the province of “Inhambane” on the Dados_Stock sheet. This is an experimental province which does not exist in OpenLMIS, and which need not exist in future versions of the SELV+ dashboard until it's introduced into OpenLMIS.
Question for Dércio Duvane: As shown in the picture below, OpenLMIS invites users to enter "Number of Stockout Days." Why, then, do most of the rows in Excel's Indicator List related to SELV say "SELV will give us the stocks. A separately calculation will be necessary to determine stock out?" During our last check-in, we discussed the fact that the MoH will potentially want to define There was discussion at one point that the MoH wanted to define 1 "stockout" event within the SELV+ Dashboard as 5 consecutive days without stock. Is this different from what users are entering into OpenLMIS? Depending on how people use this field in OpenLMIS, and because OpenLMIS exclusively collects data with a monthly level of granularity, it may not be possible to produce statistics that are congruent with the MoH's definition of stockout. Please clarify.
. This is no longer the case. The SELV+ dashboard can therefore draw its stockout values directly from the OpenLMIS form shown below.
The MoH would like the Dashboard to display the number of days which current stock levels are projected to last. Timoteo Chaluco (Unlicensed) will provide guidance about how to calculate this.
SIS-MA (DHIS2)
Please see the Credentials page for details.
Timoteo Chaluco (Unlicensed) Two Questions:
...
The source of this data is currently unknown. Dércio Duvane will research it.
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 name MOZ_SMT_2018 JAN.xlsx height 250
...