Hi Hamilton,
We are going to re-run the queries to check the impact however it would be useful to know what changes were included on this “final” version.
I remember that we tested the queries last week and Aristides shared our findings but I am not sure how did we moved from that version to the current ones…
Melhores Cumprimentos/Best Regards,
Elísio Freitas | Health Information Systems Advisor, Strategic Information Department
59200 Beijo da Mulata Road, Sommerchield II | Maputo, Moçambique
O: 258 21 24 11 00 ext. 59381 | M: 258 84 30 57 697 | efre...@fhi360.org
| www.fhi360.org | FHI
360 Facebook

From: Baltazar Chilundo <Baltazar...@columbia.org.mz>
Sent: segunda-feira, 2 de julho de 2018 13:37
To: Hamilton Paulo Isaias Matuquiha <hamilton....@ucglobalprograms.org>; Abdul Remane Cassamo <acas...@pedaids.org>; Alberto Munenda <alberto...@columbia.org.mz>; Antonio Barros Lourenco <alou...@pedaids.org>; Aristides Nhanala <anha...@fhi360.org>;
Arnaldo Nhabanga <anha...@pedaids.org>; 'Botomo Ngongo Michel' <bmi...@pedaids.org>; 'Celio Vilichane' <cvili...@usaid.gov>; Colaco Nhongo <colaco...@ccsaude.org.mz>; Edias Jambaia <ediasj...@columbia.org.mz>; Elisio Freitas <efre...@fhi360.org>;
Elizabeth Oliveras <eoli...@fhi360.org>; Eurico José <euric...@fgh.org.mz>; Fernanda Alvin <fernand...@fgh.org.mz>; Horacio Mondlane <HMon...@fhi360.org>; Jose Mizela <JoseM...@columbia.org.mz>; Leonel Nhambi <Leonel...@jhpiego.org>; Lisete
Macaringue <Lisete.M...@jhpiego.org>; luciom...@ccsaude.org.mz; 'Manhica, Pinto (Maputo/IHO)' <pman...@usaid.gov>; Milagre Tovela <mto...@arielglaser.org.mz>; Nello Macuacua <nmac...@arielglaser.org.mz>; 'Nhantumbo, Cicero (Maputo/IHO)' <cnhan...@usaid.gov>;
openmrs-m...@googlegroups.com; Salimone Nhancume <Salimone...@columbia.org.mz>; Silvia Kelbert <Silvia....@jhpiego.org>; Themos Ntasis <themos...@fgh.org.mz>; 'Vaz, Paula (CDC arielglaser.org.mz)' <pv...@arielglaser.org.mz>; Victorino Chavane
<vcha...@arielglaser.org.mz>; Zinobia Machanguana (CCS <zinobiama...@ccsaude.org.mz>
Cc: 'Alfredo, Charity N. (CDC/CGH/DGHT) (CTR)' <ho...@cdc.gov>; António Rungo <Antoni...@ucglobalprograms.org>; Carina Benilde <carina....@ucglobalprograms.org>; Cc: 'Oladapo, Keydra (CDC/CGH/DGHT)' <co...@cdc.gov>; 'Chehab, Joel C. (CDC/CGH/DGHT)'
<uv...@cdc.gov>; Etelvina Mbalane <Etelvina...@ucglobalprograms.org>; Euclides Mabota <Euclide...@ucglobalprograms.org>; fferreira <ffer...@usaid.gov>; 'Hill, Charlotte (CDC state.gov)' <Hil...@state.gov>; Isabel Sathane <Isabel....@ucglobalprograms.org>;
Jan Flowers <jfl...@uw.edu>; 'Marilena Urso' <xl...@cdc.gov>; 'Mikusova, Silva (CDC pedaids.org)' <smik...@pedaids.org>; 'Nhaguiombe, Herminio Gregorio (CDC/CGH/DGHT)' <yz...@cdc.gov>; 'Quenissone Amburete' <qamb...@pedaids.org>; 'Simone, Timoteo (CDC/CGH/DGHT)'
<nm...@cdc.gov>; Valério João <Valeri...@ucglobalprograms.org>; 'Vita, Dominique (Maputo)' <Vi...@state.gov>; Amrita Varajidás da Costa <amrita...@ucglobalprograms.org>; Cox, Alex U. (CDC/CGH/DGHT) <vf...@cdc.gov>; Manhica, Pinto (Maputo/IHO) <pman...@usaid.gov>;
Anjos, Matias (CDC/CGH/DGHT) <nl...@cdc.gov>; 'Simone, Timoteo (CDC/CGH/DGHT)' <nm...@cdc.gov>; Jan Flowers <jfl...@uw.edu>; Shade, Starley <Starle...@ucsf.edu>; Zamudio-Haas, Sophia <Sophia.Za...@ucsf.edu>
Subject: RE: FY2018 Q3 Updates for Reporting Tool
Dear Hamilton
We have run this new query and we are deeply concerned with the output it is giving. There might be something wrong on it. Please see the following table.
|
|
TX_CURR |
||
|
US |
Reportado Q2FY18 |
Querie dia 26 de Junho |
Nova Querie dia 29 de Junho |
|
US1 |
513 |
612 |
478 |
|
US2 |
1,871 |
2,077 |
1,689 |
|
US3 |
3,796 |
4,501 |
3,528 |
|
US4 |
6,197 |
7,192 |
6,094 |
Note that the reporting period has started.
Baltazar G. Chilundo (MD, PhD, PHS)
Strategic Information Unit Manager
ICAP at Columbia University
Mozambique
Rua Francisco Matange, 234, Maputo
Office: +258 21315170
Mobile: +258 843158350
Skype: baltazar_chilundo
Icap.columbia.edu
From: Hamilton Paulo Isaias Matuquiha <hamilton....@ucglobalprograms.org>
Sent: Monday, July 2, 2018 9:20 AM
To: Abdul Remane Cassamo <acas...@pedaids.org>; Alberto Munenda <alberto...@columbia.org.mz>; Antonio Barros Lourenco <alou...@pedaids.org>;
Aristides Nhanala <anha...@fhi360.org>; Arnaldo Nhabanga <anha...@pedaids.org>; Baltazar Chilundo <Baltazar...@columbia.org.mz>;
'Botomo Ngongo Michel' <bmi...@pedaids.org>; 'Celio Vilichane' <cvili...@usaid.gov>; Colaco Nhongo <colaco...@ccsaude.org.mz>;
Edias Jambaia <ediasj...@columbia.org.mz>; Elisio Freitas <efre...@fhi360.org>; Elizabeth Oliveras <eoli...@fhi360.org>;
Eurico José <euric...@fgh.org.mz>; Fernanda Alvin <fernand...@fgh.org.mz>; Horacio Mondlane <HMon...@fhi360.org>;
Jose Mizela <JoseM...@columbia.org.mz>; Leonel Nhambi <Leonel...@jhpiego.org>; Lisete Macaringue <Lisete.M...@jhpiego.org>;
luciom...@ccsaude.org.mz; 'Manhica, Pinto (Maputo/IHO)' <pman...@usaid.gov>; Milagre Tovela <mto...@arielglaser.org.mz>;
Nello Macuacua <nmac...@arielglaser.org.mz>; 'Nhantumbo, Cicero (Maputo/IHO)' <cnhan...@usaid.gov>;
openmrs-m...@googlegroups.com; Salimone Nhancume <Salimone...@columbia.org.mz>; Silvia Kelbert <Silvia....@jhpiego.org>;
Themos Ntasis <themos...@fgh.org.mz>; 'Vaz, Paula (CDC arielglaser.org.mz)' <pv...@arielglaser.org.mz>; Victorino Chavane <vcha...@arielglaser.org.mz>;
Zinobia Machanguana (CCS <zinobiama...@ccsaude.org.mz>
Cc: 'Alfredo, Charity N. (CDC/CGH/DGHT) (CTR)' <ho...@cdc.gov>; António Rungo <Antoni...@ucglobalprograms.org>; Carina Benilde <carina....@ucglobalprograms.org>;
Cc: 'Oladapo, Keydra (CDC/CGH/DGHT)' <co...@cdc.gov>; 'Chehab, Joel C. (CDC/CGH/DGHT)' <uv...@cdc.gov>; Etelvina Mbalane <Etelvina...@ucglobalprograms.org>;
Euclides Mabota <Euclide...@ucglobalprograms.org>; 'Ferreira Ferreira' <ffer...@usaid.gov>; 'Hill, Charlotte (CDC state.gov)' <Hil...@state.gov>;
Isabel Sathane <Isabel....@ucglobalprograms.org>; Jan Flowers <jfl...@uw.edu>; 'Marilena Urso' <xl...@cdc.gov>; 'Mikusova, Silva
(CDC pedaids.org)' <smik...@pedaids.org>; 'Nhaguiombe, Herminio Gregorio (CDC/CGH/DGHT)' <yz...@cdc.gov>; 'Quenissone Amburete' <qamb...@pedaids.org>;
'Simone, Timoteo (CDC/CGH/DGHT)' <nm...@cdc.gov>; Valério João <Valeri...@ucglobalprograms.org>; 'Vita, Dominique (Maputo)' <Vi...@state.gov>;
Amrita Varajidás da Costa <amrita...@ucglobalprograms.org>; Cox, Alex U. (CDC/CGH/DGHT) <vf...@cdc.gov>; Manhica, Pinto (Maputo/IHO) <pman...@usaid.gov>;
Anjos, Matias (CDC/CGH/DGHT) <nl...@cdc.gov>; 'Simone, Timoteo (CDC/CGH/DGHT)' <nm...@cdc.gov>; Jan Flowers <jfl...@uw.edu>; Shade, Starley <Starle...@ucsf.edu>;
Zamudio-Haas, Sophia <Sophia.Za...@ucsf.edu>
Subject: FY2018 Q3 Updates for Reporting Tool
Dear Partners,
Please find attached the packages for Q3 Reporting period.
Regards,
Hamilton Mutaquiha
HIS Developer
Global Programs for Research and Training
University of California, San Francisco
Maputo