Automating the Renal Cell Carcinoma Registry in Singapore: A Case Study on the Integration of the Research Electronic Data Capture System with the Enterprise Data Warehouse.

The renal cell carcinoma registry (RCCR) at the Singapore General Hospital was established in the 1980s. In 2012, the registry transited to a partially automated system using Research Electronic Data Capture (REDCap) and Oracle Business Intelligence Enterprise Edition (OBIEE), which is a platform for retrieval of electronic data from the Electronic Health Intelligence System (eHIntS). A committee was formed of experts from the department of urology and the health services research center, as well as an information technology (IT) team to evaluate the efficacy of the partially automated system. In the 5 years after the new system was implemented, 1,751 cases were recorded in the RCCR. The casefinding completeness increased by 1.9%, the data accuracy rate was 97%, and the efficiency increased by 12%. Strengths of the new system after partial automation were: (1) secure access to the registry via the hospital Web, (2) direct access to REDCap via the electronic medical records system, (3) automated and timely data extraction, and (4) visual presentation of data. On the other hand, we also encountered several challenges in the process of automating the registry, including limited IT support, limited expertise in matching data variables from RCCR and eHIntS, and limited availability and accessibility of eHIntS information for import into REDCap. In summary, despite these challenges, partial automation was achieved with the REDCap/OBIEE system, enhancing efficiency, data security, and data quality.