Implementing a script to improve the quality of the Brazilian Disease Surveillance Data System using record linkage
Introduction The National Disease Surveillance Data System (SINAN) is the main tool used by tuberculosis control programs to measure control actions and disease incidence rates in Brazil. Therefore, data quality is essential to support health surveillance and management. Objectives and Approach T...
| Main Authors: | , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Swansea University
2018-09-01
|
| Series: | International Journal of Population Data Science |
| Online Access: | https://ijpds.org/article/view/977 |
| _version_ | 1797430396432941056 |
|---|---|
| author | Rejane Sobrino Marli Souza Gisele Oliveira Luis Carlos Guillen Claudia Coeli Valeria Saraceni |
| author_facet | Rejane Sobrino Marli Souza Gisele Oliveira Luis Carlos Guillen Claudia Coeli Valeria Saraceni |
| author_sort | Rejane Sobrino |
| collection | DOAJ |
| description | Introduction
The National Disease Surveillance Data System (SINAN) is the main tool used by tuberculosis control programs to measure control actions and disease incidence rates in Brazil. Therefore, data quality is essential to support health surveillance and management.
Objectives and Approach
The aim of this study was to propose an algorithm for the qualification of the variables type of entry, treatment outcome, HIV test, HIV/AIDS co-infection and diabetes comorbidity.
We conduct a probabilistic record linkage between three databases of the city of Rio de Janeiro: SINAN-Tuberculosis, 2004-2012; the Mortality Information System (SIM), 2009-2013; and AIDS unified database, until 2012 (SINAN-AIDS, SIM registries that AIDS was the basic cause of death, drug distribution and laboratory databases). The criteria for qualifying the variables were based on technical guidelines, published by the Brazilian Ministry of Health. We implemented a script using Structured Query Language.
Results
The script had 103 rules. There was an 115% increase in the treatment output classified as "dropout" due to a decrease in: i) the number of records with patient transference but that they were not followed by another health care unit; output treatment classified as "ignored"/missing values; records with treatment output classified as "cure" before the end of the treatment. There was a 28% decrease in the number of records with treatment output classified as "death due to tuberculosis" and a 64% increase in those classified as "death due to other causes". There was a 2.4% increase in the number of records with diabetes as a comorbidity, a 5.3% increase in the number of registries with HIV-positive test and a 8.7% increase in TB-HIV/AIDS co-infection.
Conclusion/Implications
Linking databases is an important strategy for retrieving information from other systems to improve the quality of information to support decision making for TB control. |
| first_indexed | 2024-03-09T09:26:58Z |
| format | Article |
| id | doaj.art-656a5f65307446889ea0daf2254f664c |
| institution | Directory Open Access Journal |
| issn | 2399-4908 |
| language | English |
| last_indexed | 2024-03-09T09:26:58Z |
| publishDate | 2018-09-01 |
| publisher | Swansea University |
| record_format | Article |
| series | International Journal of Population Data Science |
| spelling | doaj.art-656a5f65307446889ea0daf2254f664c2023-12-02T05:43:58ZengSwansea UniversityInternational Journal of Population Data Science2399-49082018-09-013410.23889/ijpds.v3i4.977977Implementing a script to improve the quality of the Brazilian Disease Surveillance Data System using record linkageRejane Sobrino0Marli Souza1Gisele Oliveira2Luis Carlos Guillen3Claudia Coeli4Valeria Saraceni5UFRJUFRJFIOCRUZUFRJUFRJSecretaria Municipal de Saúde - Rio de JaneiroIntroduction The National Disease Surveillance Data System (SINAN) is the main tool used by tuberculosis control programs to measure control actions and disease incidence rates in Brazil. Therefore, data quality is essential to support health surveillance and management. Objectives and Approach The aim of this study was to propose an algorithm for the qualification of the variables type of entry, treatment outcome, HIV test, HIV/AIDS co-infection and diabetes comorbidity. We conduct a probabilistic record linkage between three databases of the city of Rio de Janeiro: SINAN-Tuberculosis, 2004-2012; the Mortality Information System (SIM), 2009-2013; and AIDS unified database, until 2012 (SINAN-AIDS, SIM registries that AIDS was the basic cause of death, drug distribution and laboratory databases). The criteria for qualifying the variables were based on technical guidelines, published by the Brazilian Ministry of Health. We implemented a script using Structured Query Language. Results The script had 103 rules. There was an 115% increase in the treatment output classified as "dropout" due to a decrease in: i) the number of records with patient transference but that they were not followed by another health care unit; output treatment classified as "ignored"/missing values; records with treatment output classified as "cure" before the end of the treatment. There was a 28% decrease in the number of records with treatment output classified as "death due to tuberculosis" and a 64% increase in those classified as "death due to other causes". There was a 2.4% increase in the number of records with diabetes as a comorbidity, a 5.3% increase in the number of registries with HIV-positive test and a 8.7% increase in TB-HIV/AIDS co-infection. Conclusion/Implications Linking databases is an important strategy for retrieving information from other systems to improve the quality of information to support decision making for TB control.https://ijpds.org/article/view/977 |
| spellingShingle | Rejane Sobrino Marli Souza Gisele Oliveira Luis Carlos Guillen Claudia Coeli Valeria Saraceni Implementing a script to improve the quality of the Brazilian Disease Surveillance Data System using record linkage International Journal of Population Data Science |
| title | Implementing a script to improve the quality of the Brazilian Disease Surveillance Data System using record linkage |
| title_full | Implementing a script to improve the quality of the Brazilian Disease Surveillance Data System using record linkage |
| title_fullStr | Implementing a script to improve the quality of the Brazilian Disease Surveillance Data System using record linkage |
| title_full_unstemmed | Implementing a script to improve the quality of the Brazilian Disease Surveillance Data System using record linkage |
| title_short | Implementing a script to improve the quality of the Brazilian Disease Surveillance Data System using record linkage |
| title_sort | implementing a script to improve the quality of the brazilian disease surveillance data system using record linkage |
| url | https://ijpds.org/article/view/977 |
| work_keys_str_mv | AT rejanesobrino implementingascripttoimprovethequalityofthebraziliandiseasesurveillancedatasystemusingrecordlinkage AT marlisouza implementingascripttoimprovethequalityofthebraziliandiseasesurveillancedatasystemusingrecordlinkage AT giseleoliveira implementingascripttoimprovethequalityofthebraziliandiseasesurveillancedatasystemusingrecordlinkage AT luiscarlosguillen implementingascripttoimprovethequalityofthebraziliandiseasesurveillancedatasystemusingrecordlinkage AT claudiacoeli implementingascripttoimprovethequalityofthebraziliandiseasesurveillancedatasystemusingrecordlinkage AT valeriasaraceni implementingascripttoimprovethequalityofthebraziliandiseasesurveillancedatasystemusingrecordlinkage |