Opem MRS data dictionary

52 views
Skip to first unread message

MSFOCB-Maputo-Epidemio

unread,
Jan 25, 2018, 5:01:44 AM1/25/18
to openmrs-m...@googlegroups.com

Dear all,

I would like to know if there is available a data dictionary for the Mozambique OpenMRS data base.

MSF is working with DPS Sofala and FHI in Beira city, and we share M&E efforts.

Also, is it possible to include the MSF data manager from Beira Project in this group? His email is msfocb-bei...@brussels.msf.org

Best regards,

 

MSF Logo

Ana W. Torrens  | Mission epidemiologist
Médecins Sans Frontières  | MSFOCB - Mozambique

Av.Tomas Nduda 1489, Maputo

Cell : +258 82 68 13 452

Office: + 258 82 30 93 280
Skype: anatorrens.rio

 

 

Jan Flowers

unread,
Jan 25, 2018, 9:00:03 AM1/25/18
to openmrs-m...@googlegroups.com
We are happy to help. It would help to know a little more detail about what you need. Are you wanting the data model, the concept dictionary, the definitions of the variables in the forms, etc. thanks!  

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

MSFOCB-Maputo-Epidemio

unread,
Jan 25, 2018, 9:57:49 AM1/25/18
to openmrs-m...@googlegroups.com

Hello,

For now I need the definitions of the variables in the forms. Sometimes is not possible to know what the variables stands for based on the variable name and their categories.

Thanks a lot.

Valério João

unread,
Jan 26, 2018, 2:47:43 AM1/26/18
to openmrs-m...@googlegroups.com

Hi Ana,


The forms in OpenMRS eSaude platform were designed to be similar with their corresponding paper based forms as much as possible. The concept behind the variables are equal in both sides, so is the data element dictionary. For example see in attachment the paper form of "FICHA DE SEGUIMENTO DE HIV PARA ADULTOS" with its instructions (kinda dictionary) in page 2, which is equivalent with "ADULTO: SEGUIMENTO" in OpenMRS eSaude platform. Please let me know if this helps.


Cheers

Valério


From: openmrs-m...@googlegroups.com <openmrs-m...@googlegroups.com> on behalf of MSFOCB-Maputo-Epidemio <MSFOCB-Mapu...@brussels.msf.org>
Sent: Thursday, January 25, 2018 4:57:43 PM
To: openmrs-m...@googlegroups.com
Subject: RE: [eSaude] Opem MRS data dictionary
 
FichaSeguimentoAdulto_25FEV11.pdf

MSFOCB-Maputo-Epidemio

unread,
Jan 26, 2018, 2:57:07 AM1/26/18
to openmrs-m...@googlegroups.com

Thanks Valerio!

But I really need the database data dictionary. Is there one available?

The exports from OpenMRS come with variables like “Data Registo” which is not possible to guess which date is, since it can be date of register in HIV pre-ART care or even an automatic date of register in the database. There are many other variables that is not possible to directly link with the paper forms.

If there is a data dictionary available I would like to have. Otherwise I’ll try to clarify with the data manager.

Regards,

Valério João

unread,
Jan 30, 2018, 9:46:19 AM1/30/18
to openmrs-m...@googlegroups.com

Because OpenMRS uses Entity-Attribute-Value model we mostly rely on the concept dictionary to understand the data. You can find the concept dictionary in the Tuple sheet of the attached document or either by querying the Concept Dictionary in OpenMRS system. I did a quick search in the concept dictionary and I couldn't find such a field named “Data Registo”. Can you please inform which table is this field from?


Thanks

Valério


Sent: Friday, January 26, 2018 9:57:01 AM
OpenMRS_SESP_Matching_Table_110420151921.xls

MSFOCB-Maputo-Epidemio

unread,
Jan 30, 2018, 10:27:00 AM1/30/18
to openmrs-m...@googlegroups.com

Thanks for the excel!

Well, it was just an example of one of the variables in one export of CD4 counts we got it in the HC. Don’t worry.

I hope the excel helps, but we also clarify all the detail with FHI team.

Reply all
Reply to author
Forward
0 new messages