Identifying a common data dictionary across colorectal cancer outcome registries: A mapping exercise to identify opportunities for data dictionary harmonisation

Eur J Surg Oncol. 2024 Feb;50(2):107937. doi: 10.1016/j.ejso.2023.107937. Epub 2023 Dec 29.

Abstract

Importance: The development of colorectal cancer outcome registries internationally has been organic, with differing datasets, data definitions and infrastructure across registries which has limited data pooling and international comparison. Currently there is no comprehensive data dictionary identified as a standard. This study is part of an international collaboration that aims to identify areas of data capture and usage which may be optimised to improve understanding of colorectal cancer outcomes.

Objective: This study aimed to compare and identify commonalities and areas of difference across major colorectal cancer registries. We sought to establish datasets comprising of mutually collected common fields, and a combined comprehensive dataset of all collected fields across major registries to aid in establishing a future colorectal cancer registry database standard.

Design and methods: This mixed qualitative and quantitative study compared data dictionaries from three major colorectal cancer outcome registries: Bowel Cancer Outcomes Registry (BCOR) (Australia and New Zealand), National Bowel Cancer Audit (NBOCA) (United Kingdom) and Dutch ColoRectal Audit (DCRA) (Netherlands). Registries were compared and analysed thematically, and a common dataset and combined comprehensive dataset were developed. These generated datasets were compared to data dictionaries from Sweden (SCRCR), Denmark (DCCG), Argentina (BNCCR-A) and the USA (NAACCR and ACS NSQIP). Fields were assessed against prominent quality indicator metrics from the literature and current case-use.

Results: We developed a combined comprehensive dataset of 225 fields under seven domains: demographic, pre-operative, operative, post-operative, pathology, neoadjuvant therapy, adjuvant therapy, and follow up/recurrence. A common dataset was developed comprising 38 overlapping fields, showing a low degree of mutually collected data, especially in preoperative, post operative and adjuvant therapy domains. The BNCCR-A, SCRCR and DCCG databases all contained a high percentage of common dataset fields. Fields were poorly comparable when viewed form current quality indicator metrics.

Conclusion: This study mapped data dictionaries of prominent colorectal cancer registries and highlighted areas of commonality and difference The developed common field dataset provides a foundation for registries to benchmark themselves and work towards harmonisation of data dictionaries. This has the potential to enable meaningful large-scale international outcomes research.

Keywords: Audit; Colorectal cancer; Core dataset; Data dictionary; Dataset; Metadata; PROMS; Quality indicators; Registry.

MeSH terms

  • Colorectal Neoplasms* / surgery
  • Colorectal Neoplasms* / therapy
  • Data Collection
  • Humans
  • Netherlands
  • Registries
  • United Kingdom