Dear Partners,
Please note that the differences between the packages shared below and those of Q4 are merely related with query syntax for performance optimization, and not modifications in the query semantic whatsoever.
Please feel free to contact us in case you have any questions.
Best Regards
Valério João
HIS Team Lead
Global Programs for Research and Training, Maputo
University of California, San Francisco
Dear Partners,
As per CDC’s orientation, we have reverted the changes on indicators TX_NEW and TX_CURR to the solution provided on Q4.
Please find attached updated packages:
· PEPFAR_MER2_1_Report_Openmrs_v192_09012018.zip for OpenMRS v1.9.2
· PEPFAR_MER2_1_Report_Openmrs_v1115_09012018.zip for OpenMRS v1.11.5
Regards,

From: Hamilton Paulo Isaias Matuquiha
Sent: Thursday, January 4, 2018 9:04 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>; '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' <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' <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>; '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>
Subject: RE: Q1 Updates for Reporting Tool - PEPFAR MER report
Dear Partners,
Please consider updated packages for Q1 Reports:
· PEPFAR_MER2_1_Report_Openmrs_v192_03012018.zip for OpenMRS v1.9.2
· PEPFAR_MER2_1_Report_Openmrs_v1115_03012018.zip for OpenMRS v1.11.5
We have fixed the issue that was showing ZERO for TX_NEW.
Regards,

From: Hamilton Paulo Isaias Matuquiha
Sent: Friday, December 22, 2017 8:46 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>; '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>; '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>
Subject: Q1 Updates for Reporting Tool - PEPFAR MER report
Dear Partners,
Please find attached the packages for Q1 Reports.
Instructions for installation and execution are as follows:
(1) Create a backup of your database (for security reasons)
(2) Restore the dump in attachment:
(2.1) PEPFAR_MER2_1_Report_Openmrs_v192_191217.zip for OpenMRS v1.9.2
(2.2) PEPFAR_MER2_1_Report_Openmrs_v1115_221217.zip for OpenMRS v1.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
Best Regards,

Dear all
I would like to remind you that you might observe a small decline in TX-New and Tx_Curr numbers when you run this against you back up for Q4.
Remember as discussed in our prep meeting last month we have introduced a filter that identifies duplicate patients within a district
So please expect a small decline
Etelvina
From: "openmrs-m...@googlegroups.com" <openmrs-m...@googlegroups.com> on behalf of Valério João <Valeri...@ucglobalprograms.org>
Reply-To: "openmrs-m...@googlegroups.com" <openmrs-m...@googlegroups.com>
Date: Wednesday, January 10, 2018 at 3:54 PM
To: Hamilton Paulo Isaias Matuquiha <hamilton....@ucglobalprograms.org>, Alberto Munenda <Alberto...@columbia.org.mz>, Antonio Lorenco <alou...@pedaids.org>, Aristides Nhanala <anha...@fhi360.org>, Arnaldo Nhabanga <anha...@pedaids.org>, 'Baltazar Chilundo' <Baltazar...@columbia.org.mz>, Botomo 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>, "Euric...@fgh.org.mz" <euric...@fgh.org.mz>, "Fernanda Alvim Central)" <fernand...@fgh.org.mz>, Horacio Mondlane <HMon...@fhi360.org>, "Jose Mizela Map)" <JoseM...@columbia.org.mz>, Leonel Nhambi <Leonel...@jhpiego.org>, Lisete Macaringue <Lisete.M...@jhpiego.org>, "luciom...@ccsaude.org.mz" <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" <openmrs-m...@googlegroups.com>, "Salimone Nhancume Central)" <Salimone...@columbia.org.mz>, Silvia Kelbert <Silvia....@jhpiego.org>, Themos Ntasis <themos...@fgh.org.mz>, Paula Vaz <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>, Ferreira Ferreira <ffer...@usaid.gov>, "'Hill, Charlotte (CDC state.gov)'" <Hil...@state.gov>, Isabel Sathane <Isabel....@ucglobalprograms.org>, Jan Flowers <jfl...@uw.edu>, "Marilena (CDC/CGH/DGHA)" <xl...@cdc.gov>, Silvia Mikusova <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>, "'Vita, Dominique (Maputo)'" <Vi...@state.gov>
Subject: [eSaude] Re: Q1 Updates for Reporting Tool - PEPFAR MER report
Dear Partners,
Please note that the differences between the packages shared below and those of Q4 are merely related with query syntax for performance optimization, and not modifications in the query semantic whatsoever.
Please feel free to contact us in case you have any questions.
Best Regards
Valério João
HIS Team Lead
Global Programs for Research and Training, Maputo
University of California, San Francisco
From: Hamilton Paulo Isaias Matuquiha
Sent: Tuesday, January 9, 2018 5:24:06 PM
To: Alberto Munenda; Antonio Barros Lourenco; Aristides Nhanala; Arnaldo Nhabanga; 'Baltazar Chilundo'; 'Botomo Ngongo Michel'; 'Celio Vilichane'; Colaco Nhongo; Edias Jambaia (ICAP Central; Elisio Freitas; Elizabeth Oliveras; Eurico José; Fernanda Alvin; 'fernand...@fgh.org.mz'; 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
Cc: 'Alfredo, Charity N. (CDC/CGH/DGHT) (CTR)'; António Rungo; Carina Benilde; 'Chehab, Joel C. (CDC/CGH/DGHT)'; Etelvina Mbalane; Euclides Mabota; 'Ferreira Ferreira'; '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)'
Subject: RE: Q1 Updates for Reporting Tool - PEPFAR MER report
Dear Partners,
As per CDC’s orientation, we have reverted the changes on indicators TX_NEW and TX_CURR to the solution provided on Q4.
Please find attached updated packages:
· PEPFAR_MER2_1_Report_Openmrs_v192_09012018.zip for OpenMRS v1.9.2
· PEPFAR_MER2_1_Report_Openmrs_v1115_09012018.zip for OpenMRS v1.11.5
Regards,

From: Hamilton Paulo Isaias Matuquiha
Sent: Thursday, January 4, 2018 9:04 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>; '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' <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' <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>; '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>
Subject: RE: Q1 Updates for Reporting Tool - PEPFAR MER report
Dear Partners,
Please consider updated packages for Q1 Reports:
· PEPFAR_MER2_1_Report_Openmrs_v192_03012018.zip for OpenMRS v1.9.2
· PEPFAR_MER2_1_Report_Openmrs_v1115_03012018.zip for OpenMRS v1.11.5
We have fixed the issue that was showing ZERO for TX_NEW.
Regards,

From: Hamilton Paulo Isaias Matuquiha
Sent: Friday, December 22, 2017 8:46 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>; '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>; '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>
Subject: Q1 Updates for Reporting Tool - PEPFAR MER report
Dear Partners,
Please find attached the packages for Q1 Reports.
Instructions for installation and execution are as follows:
(1) Create a backup of your database (for security reasons)
(2) Restore the dump in attachment:
(2.1) PEPFAR_MER2_1_Report_Openmrs_v192_191217.zip for OpenMRS v1.9.2
(2.2) PEPFAR_MER2_1_Report_Openmrs_v1115_221217.zip for OpenMRS v1.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
Best Regards,

--
Visit the eSaude website at https://sites.google.com/site/openmrsmozambique/
---
Recebeu esta mensagem porque subscreveu ao grupo "eSaude EPTS Implementadores" do Grupos do Google.
Para anular a subscrição deste grupo e parar de receber emails do mesmo, envie um email para openmrs-mozambi...@googlegroups.com.
Para publicar uma mensagem neste grupo, envie um email para openmrs-m...@googlegroups.com.
Para mais opções, visite https://groups.google.com/d/optout.
Dear all
I would like to remind you that you might observe a small decline in TX-New and Tx_Curr numbers when you run this against your back up for Q4.
Remember, as agreed in our prep meeting last month, we have introduced a filter that identifies duplicate patients within a district.
So please expect a small decline
Etelvina
Etelvina Mbalane
M&E Director
Global Programs for Research and Training (GP)
University of California, San Francisco (UCSF)
Maputo Mozambique
Email: etelvina...@ucglobalprograms.org.
Tel: +258 84 3912942; +258 82 8651200
From: Valério João <Valeri...@ucglobalprograms.org>
Date: Wednesday, January 10, 2018 at 3:54 PM
To: Hamilton Paulo Isaias Matuquiha <hamilton....@ucglobalprograms.org>, Alberto Munenda <Alberto...@columbia.org.mz>, Antonio Lorenco <alou...@pedaids.org>, Aristides Nhanala <anha...@fhi360.org>, Arnaldo Nhabanga <anha...@pedaids.org>,
'Baltazar Chilundo' <Baltazar...@columbia.org.mz>, Botomo 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>, "Euric...@fgh.org.mz" <euric...@fgh.org.mz>, "Fernanda Alvim Central)" <fernand...@fgh.org.mz>, Horacio Mondlane <HMon...@fhi360.org>, "Jose Mizela Map)" <JoseM...@columbia.org.mz>, Leonel Nhambi <Leonel...@jhpiego.org>,
Lisete Macaringue <Lisete.M...@jhpiego.org>, "luciom...@ccsaude.org.mz" <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" <openmrs-m...@googlegroups.com>, "Salimone Nhancume Central)" <Salimone...@columbia.org.mz>, Silvia Kelbert <Silvia....@jhpiego.org>, Themos Ntasis
<themos...@fgh.org.mz>, Paula Vaz <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>, Ferreira Ferreira <ffer...@usaid.gov>, "'Hill, Charlotte (CDC state.gov)'" <Hil...@state.gov>, Isabel Sathane <Isabel....@ucglobalprograms.org>, Jan Flowers <jfl...@uw.edu>, "Marilena (CDC/CGH/DGHA)"
<xl...@cdc.gov>, Silvia Mikusova <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>, "'Vita, Dominique (Maputo)'" <Vi...@state.gov>
Subject: Re: Q1 Updates for Reporting Tool - PEPFAR MER report
Dear Partners,
Please note that the differences between the packages shared below and those of Q4 are merely related with query syntax for performance optimization, and not modifications in the query semantic whatsoever.
Please feel free to contact us in case you have any questions.
Best Regards
Valério João
HIS Team Lead
Global Programs for Research and Training, Maputo
University of California, San Francisco
From: Hamilton Paulo Isaias Matuquiha
Sent: Tuesday, January 9, 2018 5:24:06 PM
To: Alberto Munenda; Antonio Barros Lourenco; Aristides Nhanala; Arnaldo Nhabanga; 'Baltazar Chilundo'; 'Botomo Ngongo Michel'; 'Celio Vilichane'; Colaco Nhongo; Edias Jambaia (ICAP Central; Elisio Freitas; Elizabeth Oliveras; Eurico José; Fernanda Alvin;
'fernand...@fgh.org.mz'; 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
Cc: 'Alfredo, Charity N. (CDC/CGH/DGHT) (CTR)'; António Rungo; Carina Benilde; 'Chehab, Joel C. (CDC/CGH/DGHT)'; Etelvina Mbalane; Euclides Mabota; 'Ferreira Ferreira'; '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)'
Subject: RE: Q1 Updates for Reporting Tool - PEPFAR MER report
Dear Partners,
As per CDC’s orientation, we have reverted the changes on indicators TX_NEW and TX_CURR to the solution provided on Q4.
Please find attached updated packages:
· PEPFAR_MER2_1_Report_Openmrs_v192_09012018.zip for OpenMRS v1.9.2
· PEPFAR_MER2_1_Report_Openmrs_v1115_09012018.zip for OpenMRS v1.11.5
Regards,

From: Hamilton Paulo Isaias Matuquiha
Sent: Thursday, January 4, 2018 9:04 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>; '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' <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' <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>; '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>
Subject: RE: Q1 Updates for Reporting Tool - PEPFAR MER report
Dear Partners,
Please consider updated packages for Q1 Reports:
· PEPFAR_MER2_1_Report_Openmrs_v192_03012018.zip for OpenMRS v1.9.2
· PEPFAR_MER2_1_Report_Openmrs_v1115_03012018.zip for OpenMRS v1.11.5
We have fixed the issue that was showing ZERO for TX_NEW.
Regards,

From: Hamilton Paulo Isaias Matuquiha
Sent: Friday, December 22, 2017 8:46 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>; '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>; '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>
Subject: Q1 Updates for Reporting Tool - PEPFAR MER report
Dear Partners,
Please find attached the packages for Q1 Reports.
Instructions for installation and execution are as follows:
(1) Create a backup of your database (for security reasons)
(2) Restore the dump in attachment:
(2.1) PEPFAR_MER2_1_Report_Openmrs_v192_191217.zip for OpenMRS v1.9.2
(2.2) PEPFAR_MER2_1_Report_Openmrs_v1115_221217.zip for OpenMRS v1.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
Best Regards,

Dear Etelvina,
Thank you very much for sharing this important information with us.
Could you please confirm if the following version will be the last one to report care and treatment indicator’s results for Q1 FY18?
PEPFAR_MER2_1_Report_Openmrs_v192_09012018.zip for OpenMRS v1.9.2
PEPFAR_MER2_1_Report_Openmrs_v1115_09012018.zip for OpenMRS v1.11.5
Thank you so much for your support.
Maria Fernanda
--