Migrating a Well-Established Longitudinal Cohort Database From Oracle SQL to Research Electronic Data Entry (REDCap): Data Management Research and Design Study

BACKGROUND: Providing user-friendly electronic data collection tools for large multicenter studies is key for obtaining high-quality research data. Research Electronic Data Capture (REDCap) is a software solution developed for setting up research databases with integrated graphical user interfaces for electronic data entry. The Swiss Mother and Child HIV Cohort Study (MoCHiV) is a longitudinal cohort study with around 2 million data entries dating back to the early 1980s. Until 2022, data collection in MoCHiV was paper-based. OBJECTIVE: The objective of this study was to provide a user-friendly graphical interface for electronic data entry for physicians and study nurses reporting MoCHiV data. METHODS: MoCHiV collects information on obstetric events among women living with HIV and children born to mothers living with HIV. Until 2022, MoCHiV data were stored in an Oracle SQL relational database. In this project, R and REDCap were used to develop an electronic data entry platform for MoCHiV with migration of already collected data. RESULTS: The key steps for providing an electronic data entry option for MoCHiV were (1) design, (2) data cleaning and formatting, (3) migration and compliance, and (4) add-on features. In the first step, the database structure was defined in REDCap, including the specification of primary and foreign keys, definition of study variables, and the hierarchy of questions (termed "branching logic"). In the second step, data stored in Oracle were cleaned and formatted to adhere to the defined database structure. Systematic data checks ensured compliance to all branching logic and levels of categorical variables. REDCap-specific variables and numbering of repeated events for enabling a relational data structure in REDCap were generated using R. In the third step, data were imported to REDCap and then systematically compared to the original data. In the last step, add-on features, such as data access groups, redirections, and summary reports, were integrated to facilitate data entry in the multicenter MoCHiV study. CONCLUSIONS: By combining different software tools-Oracle SQL, R, and REDCap-and building a systematic pipeline for data cleaning, formatting, and comparing, we were able to migrate a multicenter longitudinal cohort study from Oracle SQL to REDCap. REDCap offers a flexible way for developing customized study designs, even in the case of longitudinal studies with different study arms (ie, obstetric events, women, and mother-child pairs). However, REDCap does not offer built-in tools for preprocessing large data sets before data import. Additional software is needed (eg, R) for data formatting and cleaning to achieve the predefined REDCap data structure

Pregnancy and delivery outcomes of HIV infected women in Switzerland 2003-2008

Objective: Rates of vertical HIV transmission between mother and child are low, allowing many HIV positive women to have children with near impunity. In this study, data from the Swiss Mother and Child HIV Cohort Study were used to describe maternal characteristics and their association with pregnancy outcomes in HIV positive women. Study design: HIV positive women were followed prospectively during their pregnancies and deliveries by anonymous questionnaires between January 2003 and October 2008. Adverse pregnancy outcomes included preterm delivery, preeclampsia and gestational diabetes mellitus. Results: This study included 266 HIV positive women, of which 67 (25.2%) were first diagnosed with HIV during pregnancy. Thirty percent (n=80) of the women had pregnancy complications after 24weeks of gestation. Preterm delivery was noted in 72 (27%) patients. Other complications included preeclampsia (n=7; 2.6%) and gestational diabetes (n=7; 2.6%). Older maternal age was the only risk factor associated with adverse pregnancy outcomes (adjusted odds ratio: 1.06, 95% confidence interval 1.01-1.12, P=0.02). Conclusions: HIV positive women, especially with advanced maternal age, have high-risk pregnancies and should be monitored as in an interdisciplinary setting. The preponderance of initial HIV diagnosis during pregnancy confirms the importance of HIV screening in pregnant wome

Viral suppression and retention in HIV care during the postpartum period among women living with HIV: a longitudinal multicenter cohort study

BACKGROUND: Low rates of postnatal retention in HIV care and viral suppression have been reported in women living with HIV (WLWH) despite viral suppression at delivery. At the same time, postpartum follow-up is of crucial importance in light of the increasing support offered in many resource-rich countries including Switzerland to WLWH choosing to breastfeed their infant, if optimal scenario criteria are met. METHODS: We longitudinally investigated retention in HIV care, viral suppression, and infant follow-up in a prospective multicentre HIV cohort study of WLWH in the optimal scenario who had a live birth between January 2000 and December 2018. Risk factors for adverse outcomes in the first year postpartum were assessed using logistic and proportional hazard models. FINDINGS: Overall, WLWH were retained in HIV care for at least six months after 94.2% of the deliveries (694/737). Late start of combination antiretroviral therapy (cART) during the third trimester was found to be the main risk factor for failure of retention in HIV care (crude odds ratio [OR] 3.91; 95% confidence interval [CI], 1.50-10.22; p = 0.005). Among mothers on cART until at least one year after delivery, 4.4% (26/591) experienced viral failure, with illicit drugs use being the most important risk factor (hazard ratio [HR], 13.2; 95% CI, 2.35-73.6; p = 0.003). The main risk factors for not following the recommendations regarding infant follow-up was maternal depression (OR, 3.52; 95% CI, 1.18-10.52; p = 0.024). INTERPRETATION: Although the results are reassuring, several modifiable risk factors for adverse postpartum outcome, such as late treatment initiation and depression, were identified. These factors should be addressed in HIV care of all WLWH, especially those opting to breastfeed in resource-rich countries. FUNDING: This study has been financed within the framework of the Swiss HIV Cohort Study, supported by the Swiss National Science Foundation (grant #201369), by SHCS project 850 and by the SHCS research foundation

Guidelines for the Management of HIV Infection in Pregnant Women and the Prevention of Mother-to-Child Transmission of HIV

The prevalence of HIV infection amongst women giving birth in England and Wales has increased every year since 1990. Results from the Unlinked Anonymous Surveys of infection in pregnancy, show that in 2003, the prevalence reached one in 180 (0.56%) in inner London, one in 271 in outer London (0.37%) and one in 1,282 (0.08%) in the rest of England [1]. The majority of these women are from sub-Saharan Africa. The Department of Health policy of recommending an HIV test to every pregnant woman [2] has resulted in an increase in the proportion of these women who are aware of their diagnosis prior to delivery (more than 80% in London in 2001) and a decrease in the absolute number of infants infected in the UK [3]