Re: Q1 Updates for Reporting Tool - PEPFAR MER report

53 views
Skip to first unread message

Valério João

unread,
Jan 10, 2018, 8:54:12 AM1/10/18
to Hamilton Paulo Isaias Matuquiha, 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, 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, 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), Vita, Dominique (Maputo)

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,

 

Hamilton_Mutaquiha

 

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,

 

Hamilton_Mutaquiha

 

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,

 

Hamilton_Mutaquiha

 

Etelvina Mbalane

unread,
Jan 10, 2018, 9:16:01 AM1/10/18
to openmrs-m...@googlegroups.com, Hamilton Paulo Isaias Matuquiha, 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, Horacio Mondlane, Jose Mizela, Leonel Nhambi, Lisete Macaringue, luciom...@ccsaude.org.mz, Manhica, Pinto (Maputo/IHO), Milagre Tovela, Nello Macuacua, Nhantumbo, Cicero (Maputo/IHO), Salimone Nhancume (ICAP Central, Silvia Kelbert, Themos Ntasis, Vaz, Paula (CDC arielglaser.org.mz), Victorino Chavane, Zinobia Machanguana (CCS, 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), Vita, Dominique (Maputo)

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,

 

amilton_Mutaquiha

 

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,

 

amilton_Mutaquiha

 

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,

 

amilton_Mutaquiha

 

--
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.

Etelvina Mbalane

unread,
Jan 10, 2018, 9:25:40 AM1/10/18
to Valério João, Hamilton Paulo Isaias Matuquiha, 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, 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, Alfredo, Charity N. (CDC/CGH/DGHT) (CTR), António Rungo, Carina Benilde, Chehab, Joel C. (CDC/CGH/DGHT), 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), Vita, Dominique (Maputo)

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,

 

amilton_Mutaquiha

 

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,

 

amilton_Mutaquiha

 

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,

 

amilton_Mutaquiha

 

Fernanda Alvim

unread,
Jan 10, 2018, 10:03:37 AM1/10/18
to Etelvina Mbalane, Valério João, Hamilton Paulo Isaias Matuquiha, 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é, 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, Alfredo, Charity N. (CDC/CGH/DGHT) (CTR), António Rungo, Carina Benilde, Chehab, Joel C. (CDC/CGH/DGHT), 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), Vita, Dominique (Maputo)

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?

Thank you so much for your support.

 

Maria Fernanda

Etelvina Mbalane

unread,
Jan 11, 2018, 12:23:00 AM1/11/18
to Etelvina Mbalane, Valério João, Hamilton Paulo Isaias Matuquiha, 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é, 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, Alfredo, Charity N. (CDC/CGH/DGHT) (CTR), António Rungo, Carina Benilde, Chehab, Joel C. (CDC/CGH/DGHT), 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), Vita, Dominique (Maputo)
Fernanda

If this is the version Hamilton sent the response is yes... provided partners who did not provide feedback to the queries do not experience major technical issues

Etelviba




--
Reply all
Reply to author
Forward
0 new messages