Data Processing
Data Editing
The data collection system is composed by two databases:
- A temporary database, which contains data collected and transferred each day during the round.
- A reference database, which contains all data of Ouagadougou Health and Demographic Surveillance System, in which is transferred the data of the temporary database to the end of each round.
Note: The temporary database is emptied at the end of the round for a new round. Thus, the data processing takes place in two ways:
First: When collecting data with PDAs or tablets and theirs transfers by Wi-Fi, data consistency and plausibility are controlled by verification rules in the mobile application and in the database. In addition to these verifications, the data from the temporary database undergo validation. This validation is performed each week and produces a validation report for the data collection team. After the validation, if the error is due to an error in the data collection, the field worker equipped with his PDA or tablet go back to the field to revisit and correct this error. At the end of this correction, the field worker makes again the transfer of data through the wireless access points on the server.
If the error is due to data inconsistencies that might not be directly related to an error in data collection, the case is remanded to the scientific team of the main database that could resolve the inconsistency directly in the database or could with supervisors perform a thorough investigation in order to correct the error.
Second: At the end of the round, the data from the temporary database are automatically transferred into the reference database by a transfer program. After the success of this transfer, further validation is performed on the data in the database to ensure data consistency and plausibility. This still produces a validation report for the data collection team. And the same process of error correction is taken.
Other Processing
At the end of all data processing, Macro files are generated by the IT team for statisticians, who do some consistency checks. If inconsistencies are identified, they are given to the manager of the main database for correction. For the corrections, the field back is often necessary to correct certain inconsistencies.
Documentation in PDF
Download DDI
