search

mozaude / MozART_ETL

collaboration with IPs and INS for improving MozART submission quality
0 stars 1 forks source link

Pregnant Men in CCS #8

Open orrinft opened 5 years ago

orrinft commented 5 years ago

CCS has over 100,000 pregnant men. See their response below:

_We have been looking at the issue and we concluded that, the problem came on the transformation process. We ran queries at the HF and in the Mozart-Mysql Database, the result was zero for both. However, we think that the issue comes when we are loading data from Mozart-Mysql database to Mozart-Access database using the ESF DATABASE MIGRATION TOOLS. The access database template is considering all "null" values to "true" in the the table where the columns data type is boolean.

When we run the access script that you shared (the script above) and change the condition "t_adulto.gravida = true" to "tadulto.aborto = true" the results are the same, that confirms the issue is in the mysql to access transformation process. Please see the document attached

We need to update the CCS pregnant men in the National Dataset

orrinft commented 5 years ago

@TimoteoSimone recommendation: Confirm whether the pregnancy variable is wrong or the gender. Please summarize separately the two variables: gender and pregnancy by partner. This would allow us to find patterns specifically for the partners concerned (CCS and EGPAF) compared to the other partners.