RE: FY2018 Q2 Updates for Reporting Tool (test version)
Elizabeth Oliveras
One additional request. In the current format, all indicators (semi-annual and quarterly) are in one report. Would it be possible to split these into two reports—one for quarterly and one for semi-annual indicators? While we can run the full report twice (once for each period), this may lead to errors if the wrong version of a particular indicator is mistakenly used. Having a specific report for each time period would minimize potential errors and would still allow partners to run the queries for a different period if they would like to do that.
Many thanks for your consideration.
Best E
From: Aristides Nhanala
Sent: Sunday, April 1, 2018 12:40 PM
To: Hamilton Paulo Isaias Matuquiha <hamilton....@ucglobalprograms.org>; Alberto Munenda <alberto...@columbia.org.mz>; Antonio Barros Lourenco <alou...@pedaids.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 (ICAP Central <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 (ICAP Central <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>; '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>; Rein, Maria (CDC/CGH/DGHT) <zs...@cdc.gov>
Subject: RE: FY2018 Q2 Updates for Reporting Tool (test version)
Thanks.
AN
From: Hamilton Paulo Isaias Matuquiha <hamilton....@ucglobalprograms.org>
Sent: Sunday, April 01, 2018 12:38 PM
To: Aristides Nhanala <anha...@fhi360.org>; Alberto Munenda <alberto...@columbia.org.mz>; Antonio Barros Lourenco <alou...@pedaids.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 (ICAP Central <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 (ICAP Central <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>;
'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>; Rein, Maria (CDC/CGH/DGHT) <zs...@cdc.gov>
Subject: Re: FY2018 Q2 Updates for Reporting Tool (test version)
Hi,
Thanks for the screenshots.
We will wok on aligning to these layouts and send updated report.
Regards,
Hamilton
Obter o Outlook para iOS
From: Aristides Nhanala <anha...@fhi360.org>
Sent: Sunday, April 1, 2018 12:29:19 PM
To: Hamilton Paulo Isaias Matuquiha; Alberto Munenda; Antonio Barros Lourenco; Arnaldo Nhabanga; 'Baltazar Chilundo'; 'Botomo Ngongo Michel'; 'Celio Vilichane'; Colaco Nhongo; Edias Jambaia (ICAP Central; Elisio Freitas; Elizabeth Oliveras; Eurico José;
Fernanda Alvin; Horacio Mondlane; 'Jose Mizela'; Leonel Nhambi; Lisete Macaringue;
luciom...@ccsaude.org.mz; 'Manhica, Pinto (Maputo/IHO)'; Milagre Tovela; Nello Macuacua; 'Nhantumbo, Cicero (Maputo/IHO)';
openmrs-m...@googlegroups.com; Salimone Nhancume (ICAP Central; Silvia Kelbert; Themos Ntasis; 'Vaz, Paula (CDC arielglaser.org.mz)'; Victorino Chavane; Zinobia Machanguana (CCS; Fernanda Alvin
Cc: 'Alfredo, Charity N. (CDC/CGH/DGHT) (CTR)'; António Rungo; Carina Benilde; 'Chehab, Joel C. (CDC/CGH/DGHT)'; Etelvina Mbalane; Euclides Mabota; fferreira; 'Hill, Charlotte (CDC state.gov)'; Isabel Sathane; Jan Flowers; 'Marilena Urso'; 'Mikusova,
Silva (CDC pedaids.org)'; 'Nhaguiombe, Herminio Gregorio (CDC/CGH/DGHT)'; 'Quenissone Amburete'; 'Simone, Timoteo (CDC/CGH/DGHT)'; Valério João; 'Vita, Dominique (Maputo)'; Rein, Maria (CDC/CGH/DGHT)
Subject: RE: FY2018 Q2 Updates for Reporting Tool (test version)
Hi Dears,
TX_TB also needs to be reviewed in align MER requirements. Please review the screenshots below for both numerator (reduce and collapse the number of categories) and denominator ( This need deep review since it not disaggregated by “Specimen Sent” :
Regards
AN
From: Aristides Nhanala
Sent: Sunday, April 01, 2018 11:43 AM
To: Hamilton Paulo Isaias Matuquiha <hamilton....@ucglobalprograms.org>; Alberto Munenda <Alberto...@columbia.org.mz>; Antonio
Barros Lourenco <alou...@pedaids.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 (ICAP Central <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 (ICAP Central <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>; Fernanda Alvin <fernand...@fgh.org.mz>
Cc: 'Alfredo, Charity N. (CDC/CGH/DGHT) (CTR)' <ho...@cdc.gov>; António Rungo <Antoni...@ucglobalprograms.org>; Carina Benilde <carina....@ucglobalprograms.org>;
'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>; Rein, Maria (CDC/CGH/DGHT) <zs...@cdc.gov>
Subject: RE: FY2018 Q2 Updates for Reporting Tool (test version)
Dear Colleagues,
DATIM is now released and TB_PREV is not aligned to what is required for reporting in current queries. Below is the screen:
Can you please align ?
AN
From: Hamilton Paulo Isaias Matuquiha <hamilton....@ucglobalprograms.org>
Sent: Saturday, March 24, 2018 2:54 AM
To: 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 (ICAP Central <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 (ICAP Central <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>; Fernanda Alvin <fernand...@fgh.org.mz>
Cc: 'Alfredo, Charity N. (CDC/CGH/DGHT) (CTR)' <ho...@cdc.gov>; António Rungo <Antoni...@ucglobalprograms.org>; Carina Benilde <carina....@ucglobalprograms.org>;
'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>; Rein, Maria (CDC/CGH/DGHT) <zs...@cdc.gov>
Subject: FY2018 Q2 Updates for Reporting Tool (test version)
Dear partners,
Please find attached the update package for Q2 indicators. Following the instructions:
(1) Create a backup of your database (for security reasons)
(2) Restore the dump in attachment:
- PEPFAR_MER2_1_Report_Openmrs_v192_23032018.sql for OpenMRS 1.9.2
- PEPFAR_MER2_1_Report_Openmrs_v1115_23032018.sql for openMRS 1.11.5
(3) Go to OpenMRS menu Reporting > (Available Reports) PEPFAR MER 2.1 REPORT
(4) Provide the necessary parameters and click on Request Report
Feedback should be provided to UCSF by Monday, March 26th COB.
In case of technical support needed, please contact: help...@esaude.org, esaude/slack or "Euclides Mabota" <Euclide...@ucglobalprograms.org>