TY - JOUR
T1 - Electronic primary dental care records in research
T2 - A case study of validation and quality assurance strategies
AU - Wanyonyi, Kristina L.
AU - Radford, David R.
AU - Gallagher, Jennifer E.
PY - 2019/7
Y1 - 2019/7
N2 - Background: In dentistry, the use of electronic patient records for research is underexplored. The aim of this paper is to describe a case study process of obtaining research data (sociodemographic, clinical and workforce) from electronic primary care dental records, and outlining data cleaning and validation strategies. This study was undertaken at the University of Portsmouth Dental Academy (UPDA), which is a centre of education, training and provision of state funded services (National Health Services). UPDA's electronic patient management system is R4/Clinical +. This is a widely used system in general dental practices in the UK. Method: A two-phase process, involving first Pilot and second Main data extraction were undertaken. Using System Query Language (SQL), data extracts containing variables related to patients’ demography, socio-economic status and dental care received were generated. A data cleaning and validation exercise followed, using a combination of techniques including Maletic and Marcus's (2000) general framework for data cleaning and Rahm and Haido's (2010) principles of data cleaning. Results: The findings of the case study support the use of a two-phase data extraction process. The data validation processes highlighted the need for both manual and analytical strategies when cleaning these data. Finally, the process demonstrated that electronic dental records can be validated and used for epidemiological and heath service research. The potential to generalise findings is great due to the large number of records. There are, however, limitations to the data which need to be considered, relating to quality (data input), database structure and interpretation of data codes. Conclusion: Electronic dental records are useful in health service research, epidemiological studies and skill mix research. Researchers should work closely with clinicians, managers and software developers to ensure that the data generated are accurate, valid and generalisable. Following data extraction the researchers need to adapt stringent validation and data cleaning strategies to guarantee that the extracted electronic data are accurate.
AB - Background: In dentistry, the use of electronic patient records for research is underexplored. The aim of this paper is to describe a case study process of obtaining research data (sociodemographic, clinical and workforce) from electronic primary care dental records, and outlining data cleaning and validation strategies. This study was undertaken at the University of Portsmouth Dental Academy (UPDA), which is a centre of education, training and provision of state funded services (National Health Services). UPDA's electronic patient management system is R4/Clinical +. This is a widely used system in general dental practices in the UK. Method: A two-phase process, involving first Pilot and second Main data extraction were undertaken. Using System Query Language (SQL), data extracts containing variables related to patients’ demography, socio-economic status and dental care received were generated. A data cleaning and validation exercise followed, using a combination of techniques including Maletic and Marcus's (2000) general framework for data cleaning and Rahm and Haido's (2010) principles of data cleaning. Results: The findings of the case study support the use of a two-phase data extraction process. The data validation processes highlighted the need for both manual and analytical strategies when cleaning these data. Finally, the process demonstrated that electronic dental records can be validated and used for epidemiological and heath service research. The potential to generalise findings is great due to the large number of records. There are, however, limitations to the data which need to be considered, relating to quality (data input), database structure and interpretation of data codes. Conclusion: Electronic dental records are useful in health service research, epidemiological studies and skill mix research. Researchers should work closely with clinicians, managers and software developers to ensure that the data generated are accurate, valid and generalisable. Following data extraction the researchers need to adapt stringent validation and data cleaning strategies to guarantee that the extracted electronic data are accurate.
KW - Clinical research
KW - Dental informatics
KW - Dental research
KW - Electronic dental records
KW - Electronic health records
KW - Health service research
KW - Primary dental care
UR - http://www.scopus.com/inward/record.url?scp=85064894469&partnerID=8YFLogxK
U2 - 10.1016/j.ijmedinf.2019.04.007
DO - 10.1016/j.ijmedinf.2019.04.007
M3 - Article
C2 - 31128836
AN - SCOPUS:85064894469
SN - 1386-5056
VL - 127
SP - 88
EP - 94
JO - International Journal of Medical Informatics
JF - International Journal of Medical Informatics
ER -