Trauma registry record linkage: methodological approach to benefit from complementary data using the example of the German Pelvic Injury Register and the TraumaRegister DGU®
© Burkhardt et al.; licensee BioMed Central Ltd. 2013
Received: 27 August 2012
Accepted: 27 February 2013
Published: 5 March 2013
In Germany, hospitals can deliver data from patients with pelvic fractures selectively or twofold to two different trauma registries, i.e. the German Pelvic Injury Register (PIR) and the TraumaRegister DGU® (TR). Both registers are anonymous and differ in composition and content. We describe the methodological approach of linking these registries and reidentifying twofold documented patients. The aim of the approach is to create an intersection set that benefit from complementary data of each registry, respectively. Furthermore, the concordance of data entry of some clinical variables entered in both registries was evaluated.
PIR (4,323 patients) and TR (34,134 patients) data from 2004-2009 were linked together by using a specific match code including code of the trauma department, dates of admission and discharge, patient’s age, and sex. Data entry concordance was evaluated using haemoglobin and blood pressure levels at emergency department arrival, Injury Severity Score (ISS), and mortality.
Altogether, 420 patients were identified as documented in both data sets. Linkage rates for the intersection set were 15.7% for PIR and 44.4% for TR. Initial fluid management for different Tile/OTA types of pelvic ring fractures and the patient’s posttraumatic course, including intensive care unit data, were now available for the PIR population. TR is benefiting from clinical use of the Tile/OTA classification and from correlation with the distinct entity “complex pelvic injury.” Data entry verification showed high concordance for the ISS and mortality, whereas initial haemoglobin and blood pressure data showed significant differences, reflecting inconsistency at the data entry level.
Individually, the PIR and the TR reflect a valid source for documenting injured patients, although the data reflect the emphasis of the particular registry. Linking the two registries enabled new insights into care of multiple-trauma patients with pelvic fractures even when linkage rates were poor. Future considerations and development of the registries should be done in close bilateral consultation with the aim of benefiting from complementary data and improving data concordance. It is also conceivable to integrate individual modules, e.g. a pelvic fracture module, into the TR likewise a modular system in the future.
KeywordsTrauma registries Record linkage Data concordance Pelvic fracture Multiple trauma patients
Pelvic fractures generally have a low incidence of 2-3%, whereas in multiple trauma patients it can rise to more than 25% [1–3]. Because of the high energy that causes a pelvic fracture, the mortality rate for these patients is proportionately high, particularly because of associated head, thoracic, and/or abdominal injuries [3–8]. The recent literature shows a mortality rate of 18% for patients with “complex pelvic injuries”, which include all pelvic fractures (acetabulum, pelvic ring, sacrum) with pelvic soft tissue injuries (i.e., open fractures including the Morel-Lavallée lesion, disruption of pelvic vessels including retroperitoneal hematoma, urogenital or hollow viscus injuries and neurologic deficits directly caused by the pelvic fracture) [1, 9, 10]. Regardless of the overall encouraging projections of trauma mortality, this rate remains unacceptably high. Scientific explanations for this stagnation are still controversial. In addition to single and multicenter studies, numerous trauma registries worldwide investigate optimal care of the injured patient, not necessarily just those suffering from pelvic fractures. Some such registries are the Victorian Orthopaedic Trauma Outcomes Registry (VOTOR) in Australia, the Trauma Audit and Research Network (TARN) in the United Kingdom, the National Trauma Registry (NTR) of Canada, and the National Trauma Data Bank (NTDB) in the United States. In Germany, we have a special situation in that we have two such registries: the TraumaRegister DGU® (TR) and the unique Pelvic Injury Register (PIR), which focuses on pelvic ring and acetabular fractures. Both registries are surgical driven and are associated with the German Trauma Society (Deutsche Gesellschaft für Unfallchirurgie, or DGU). Because of the differences in focus and content of TR and PIR, many hospitals deliver data to both registries.
The Pelvic Injury Register (PIR)
Data contribution to the intersection set of the German Pelvic Injury Register and the TraumaRegister DGU ®
German Pelvic Injury Register (PIR)
Intersection set of the PIR and TR
TraumaRegister DGU® (TR)
code of the trauma department, date of the accident, date of admission, date of discharge, birthdate or age, gender, type of pelvic fracture according Tile/OTA classification, complex pelvic trauma (yes/no) etc.
code of the trauma department, date of the accident, date of admission, date of discharge, birthdate or age, gender etc.
BP, HR, SaO2, GCS, intravenous infusions, rescue times etc.
Trauma room/Emergency department
initial hemoglobin, intial BP, PRBC, AIS, ISS, PTS, emergency procedures (i.e. pelvic sling, external fixator, pelvic C-clamp, ORIF etc.) etc.
BP, HR, SaO2, GCS, intravenous infusions, diagnostics (x-ray, CT etc.), blood tests, treatment, hemostasis, blood products etc.
emergency procedures (i.e. pelvic sling, external fixator, pelvic C-clamp, ORIF etc.), in detail definitive ORIF (pelvic ring or acetabular module, children module) etc.
emergency procedures (e.g. laparotomy, craniotomy, external fixator etc.), time management etc.
SAPS II Score, blood tests, blood products, ventilation days, complications (sepsis, MOF etc.) etc.
date of discharge, complications (e.g. neurological deficits, wound infections, implant failure etc.) etc.
date of discharge, AIS, ISS, OPS-codes for treatment, RISC, TRISS etc.
The TraumaRegister DGU® (TR)
The TR was founded in 1993 as a prospective, multicentre, standardized and anonymous documentation of multiple injured trauma patients. Data are collected at four consecutive post-trauma phases from injury to hospital discharge: (i.) pre-hospital phase; (ii.) emergency room/department and initial surgery (until admission to the intensive care unit (ICU)); (iii.) ICU and (iv.) outcome status at discharge and description of injuries and procedures takes place. The registry contains detailed information on demographics, injury pattern, comorbidities, pre- and in-hospital management, time course, relevant laboratory findings including data on transfusion, and outcome of each individual (Table 1). Fluid management is addressed, including records of the infusion volume of crystalloids and colloids started preclinically as well as the blood products transfused during the first 24 hours in hospital. The predominant inclusion criterion is that the injury severity or trauma load requires the patient to stay in the ICU. All injuries are coded using the Abbreviated Injury Scale (AIS). The majority of contributing hospitals are level I trauma centers. In 2009, there were 242 hospitals affiliated with the TR, with an upward trend. The TR is a voluntary register and it is approved by the review board of the German Trauma Society and is in compliance with the institutional requirements. In accordance to the PIR, the TR is a voluntary and anonymous registry that needs no patient consent.
The linkage procedure of the two data bases
To identify identical patients entered in both registries, a data set was prepared containing the data of all hospitals contributing to both registries during the period 2004-2009. The data set of the TR was then reduced to cases with injuries coded within a specific AIS (1998) numerical injury identifier, i.e. 856xxx.x, containing pelvic ring and acetabular fractures . In the next step, the two data sets were limited to cases where specific hospitals contributed to both registries during the same year. The data sets from the registries were then imported via .csv files into SPSS software (SPSS, Chicago, IL, USA). The unique hospital code used in the TR was introduced into the PIR data set, after which a match-code was created containing the hospital code, dates of admission and discharge, and the age and sex of the patient. Before linking the data sets, each set was checked for possible duplicates. After controlling and (if required) deleting duplicates, the match-code was used to link the two data sets and merged the hits in a new file. This new data file contained the variables of both registries for each patient.
Checking for data concordance
The following variables were chosen to investigate the concordance of data entries in the two registries: initial haemoglobin and blood pressure levels on arrival at the emergency department, the ISS, and mortality. Records were considered a match if they were identical (the gold standard). Because of the slightly different methods for coding the ISS within the two registries, however, a discrepancy of ± 9 points was tolerated. Also, we accepted discrepancies of ± 1 g/dl for the haemoglobin level and ± 10 mmHg for blood pressure. We considered that there was no substantial impact on clinical treatment or outcome within these ranges.
Data are presented as the mean and standard deviation for continuous variables and as a percentage for categorical variables. The percentage of exact matches and percentage of matches within the tolerated range are given for each variable. Differences in documentation were compared using Wilcoxon test for continuous variables and Chi2 for categorical variables. Statistics were calculated using SPSS Statistical Software Package Version 19 (SPSS Inc., Chicago, USA). A p value of <0.05 was considered statistically significant.
We started with evaluation of the smaller PIR data set, which for 2004-2009 included 4,323 patients’ records collected by at least 31 participating trauma departments. Notably, not all 31 hospitals shared their data with the TR. Ultimately, we found 3,329 anonymous patients from 19 hospitals of the PIR whose data were potentially registered in both databases. In the TR, the initial 34,134 trauma victims from 242 affiliated hospitals during the same observation period were reduced to the same PIR-affiliated hospitals and were screened for the AIS (1998) numerical injury identifier 856xxx.x, reflecting pelvic ring and acetabular fractures.
Degree of data validation of documented records in the German Pelvic Injury Register and the TraumaRegister DGU ®
Exact match [%]
Criteria for tolerance
ISS [points, mean ± SD]
27 ± 13
27 ± 13
± 9 points
initial BP [mmHg, mean ± SD]
99 ± 19
108 ± 27
± 10 mmHg
initial Hb [g/dl, mean ± SD]
8.6 ± 2.9
9.6 ± 3.1
± 1 g/dl
10% (n = 42)
10% (n = 42)
In multiple trauma patients, the incidence of concomitant pelvic fractures increases up to more than 25% [1–3]. Vice versa, up to 89% of patients sustaining high-energy derived pelvic fractures have at least one associated injury [13, 14]. We developed an approach to find patients whose data had been entered into two anonymous trauma registries. Using this approach we identified 420 multiple trauma patients with concomitant pelvic fractures documented in both the PIR and the TR. Prima facie, the linkage rates for the intersection set of 15.7% in the PIR and 44.4% in the TR appear small, which means that only about one in every six patients with a pelvic fracture enrolled in the PIR fulfilled the TR inclusion criterion of “care in the ICU”. On the other hand, approximately every second patient with a pelvic fracture enrolled in the TR was also documented in the PIR. The reason for this discrepancy is that enrolment is mainly determined by the particular emphasis of each registry and the study populations themselves.
Starting with the PIR, the drop-outs might be explained by the large number of isolated acetabular and benign anterior pelvic ring fractures (type A according to the Tile/OTA classification) caused by low-energy trauma in the very elderly population [7, 10]. Each of these injuries is documented in the PIR but not routinely in the TR because only in rare cases are these patients treated initially as emergency cases in the ICU. Comparing the mean age and the fracture distribution of solely PIR data from Pohlemann et al. with our linked data set, the higher average in age (54.4 years vs. 41.6 years) as well as the higher percentage of type A fractures (42.8% vs. 19.8%) in consequence is found in the PIR . In contrast, the reasons for the even lower drop-outs in the TR are more speculative. Finally, the match code itself could explain the large number of dropouts as there was no tolerance given (e.g. in admission and discharge dates), reflecting an ad hoc deterministic linkage. In contrast to the recently published use of linkage procedures based on encrypted personal identifiers or use of a probabilistic record linkage [15, 16], an extensive hand search of both anonymous data sets might have offered the possibility of isolating patients’ data that were mistakenly omitted from one registry and/or to answer the question of how many persons were missed by our linkage criteria. Because of the huge efforts in time and resources, we waived a thorough hand search. This matter, in fact, represents an explicit limitation of our study.
Published articles have compared administrative databases for hospital reimbursement. Trauma registry databases are available for research on epidemiology, practice variation, and outcome [17, 18]. There have also been inter-registry analyses in the field of trauma [19, 20]. Although the literature is filled with comparisons of these various medical registries, this is the first time that linking data from two clinical trauma registries to create an enlarged data set for each patient has been described. It is also the first time that the benefit of these complementary data has been addressed.
Looking for data validation, we have to address the differences between data completeness and data concordance. Because the ISS and mortality records are directly or indirectly mandatory in both databases, not surprisingly the completion rate was 100% for both parameters in both registries. In contrast, there was a poor completion rate (17%, 73/420) for the initial blood pressure and haemoglobin measurements in the PIR. Usually, this rate is unacceptable compared with the 99% reported in the literature . It should be kept in mind, however, that both parameters are mandatory only for complex pelvic injuries. This appears to be emphasized for the PIR only, reflecting the insistence for vital parameters or the initial haemoglobin level only for complex pelvic injuries. Nevertheless, a high completion rate of the collecting data should be in the interest of each registry, and future data validation schemes must be implemented in the PIR.
The results for data concordance also appear inconsistent. That is, statistics showed no significant differences for the ISS or mortality, but this was not true for the initial blood pressure and haemoglobin measurements. Undoubtedly, the haemoglobin level and hemodynamics of trauma patients influence their outcome and survival. Using only PIR-derived data, Holstein et al. investigated predictors of mortality in patients with pelvic fractures. They found out that the median haemoglobin level of the “survivor group” was 10 g/dl compared with 7 g/dl in the “nonsurvivor group” . Regarding the initial haemoglobin levels of our linkage groups, both mean haemoglobin levels were found to be just between the above-mentioned extremes (8.6 ± 2.9 g/dl from PIR data and 9.6 ± 3.1 g/dl from TR data). Statistics nevertheless showed significant differences, reflecting inconsistency for the data entry level of both clinical parameters. Potential explanations for this inconsistency are numerous (e.g. data entry or coding errors; rounding up or down of numerical values; replicated values during the same treatment period; different error deviations of different haematology analysers or blood pressure-measuring devices).
Finally, by using the defined tolerance levels of these two parameters in the PIR and the TR, we reached the same data entry error rates as in the National Trauma Data Bank (19-76%), although for different records [22–24]. Data quality is still an important challenge for the PIR and the TR. Our results confirmed the need for establishing appropriate validation protocols in the future [24, 25].
Future perspectives and confidentiality concerns
We will also address the use of a unique patient identifier in registers like social security number, which is allowed in some European countries, but not allowed in Germany due to ethical considerations and confidentiality concerns. Such an identifier may considerably help identify a patient across registries, thereby allowing evaluation of the patient’s course through the entire health system. An example is the MEMDoc® module system used in the French hip registry and in other registries that use the social security number even over country borders .
By itself, each trauma registry, i.e. the German Pelvic Injury Register and the TraumaRegister DGU®, reflects a valid source for documenting injured patients in accordance of the emphasis of each registry, respectively. The linkage of these two registries enabled new insights into medical practices for multiple trauma patients with pelvic ring fractures including initial fluid resuscitation and the incidence of traumatic coagulopathy. Inconsistency between clinical PIR and TR data, however, revealed that efforts must be made to ensure high data quality and acceptable population coverage in the future. Present considerations and developments of both registries should take place in close consultation, with the aim of benefiting from complementary data. It is conceivable to integrate individual modules, e.g. a pelvic fracture module, into the TraumaRegister DGU® likewise a modular system. This action would represent a future technical challenge for database programming.
The authors thank the members of the German Pelvic Injury Register  and the TraumaRegister DGU® . Special thanks go to the following trauma departments, which documented in both registries and which data are presented here: BG Trauma Hospital, Ludwigshafen; BG Trauma Hospital, Murnau; University Hospital, Ulm; Charité Virchow Campus, Berlin; Friederikenstift Hospital, Hannover; General Hospital, Augsburg; General Hospital, Dortmund; General Hospital, Biberach; Medical University, Hannover; SKM Hospital, Koblenz; Municipal Hospital, Braunschweig; Municipal Hospital, Karlsruhe; University Hospital, Kiel; University Hospital, Mainz; University Hospital, Freiburg; University Hospital, Jena; University Hospital, Muenster; Municipal Hospital Nuernberg, University Hospital, Homburg.
- Pohlemann T, Tscherne H, Baumgärtel F, Egbers HJ, Euler E, Maurer F, Fell M, Mayr E, Quirini WW, Schlickewei W, Weinberg A: Pelvic fractures: epidemiology, therapy and long-term outcome. Overview of the multicenter study of the Pelvis Study Group. Unfallchirurg. 1996, 99: 160-167.View ArticlePubMedGoogle Scholar
- Giannoudis PV, Grotz MR, Tzioupis C, Dinopoulos H, Wells GE, Bouamra O, Lecky F: Prevalence of Pelvic Fractures, Associated Injuries, and Mortality: The United Kingdom Perspective. J Trauma. 2007, 63: 875-883. 10.1097/01.ta.0000242259.67486.15.View ArticlePubMedGoogle Scholar
- Balogh Z, King KL, Mackay P, McDougall D, Mackenzie S, Evans JA, Lyons T, Deane SA: The epidemiology of pelvic ring fractures: a population-based study. J Trauma. 2007, 63: 1066-1073. 10.1097/TA.0b013e3181589fa4.View ArticlePubMedGoogle Scholar
- Pohlemann T, Bosch U, Gaensslen A, Tscherne H: The Hannover experience in management of pelvic fractures. Clin Orthop Relat Res. 1994, 305: 69-80.View ArticlePubMedGoogle Scholar
- Eastridge BJ, Starr A, Minei JP, O'Keefe GE, Scalea TM: The importance of fracture pattern in guiding therapeutic decision-making in patients with hemorrhagic shock and pelvic ring disruptions. J Trauma. 2002, 53: 446-450. 10.1097/00005373-200209000-00009.View ArticlePubMedGoogle Scholar
- Cothren CC, Osborn PM, Moore EE, Morgan SJ, Johnson JL, Smith WR: Preperitonal pelvic packing for hemodynamically unstable pelvic fractures: a paradigm shift. J Trauma. 2007, 62: 834-839. 10.1097/TA.0b013e31803c7632.View ArticlePubMedGoogle Scholar
- Hauschild O, Strohm PC, Culemann U, Pohlemann T, Suedkamp NP, Koestler W, Schmal H: Mortality in patients with pelvic fractures: results from the German pelvic injury register. J Trauma. 2008, 64: 449-455. 10.1097/TA.0b013e31815982b1.View ArticlePubMedGoogle Scholar
- Holstein JH, Culemann U, Pohlemann T, Working Group Mortality in Pelvic Fracture Patients: What are Predictors of Mortality in Patients with Pelvic Fractures. Clin Orthop Relat Res. 2012, 470: 2090-2097. 10.1007/s11999-012-2276-9.View ArticlePubMedPubMed CentralGoogle Scholar
- Bosch U, Pohlemann T, Haas N, Tscherne H: Classification and management of complex pelvic trauma. Unfallchirurg. 1992, 95: 189-196.PubMedGoogle Scholar
- Pohlemann T, Stengel D, Tosounidis G, Reilmann H, Stuby F, Stöckle U, Seekamp A, Schmal H, Thannheimer A, Holmenschlager F, Gänsslen A, Rommens PM, Fuchs T, Baumgärtel F, Marintschev I, Krischak G, Wunder S, Tscherne H, Culemann U: Survival trends and predictors of mortality in severe pelvic trauma: Estimates from the German Pelvic Trauma Registry Initiative. Injury. 2011, 42: 997-1002. 10.1016/j.injury.2011.03.053.View ArticlePubMedGoogle Scholar
- Tile M: Acute Pelvic Fractures: I. Causation and Classification. J Am Acad Orthop Surg. 1996, 4: 143-151.View ArticlePubMedGoogle Scholar
- Association for the Advancement of Automotive Medicine (AAAM): Manual Abbreviated Injury Scale 1998. 1998, Des Plaines IL: AAAMGoogle Scholar
- Parreira JG, Coimbra R, Rasslan S, Oliveira A, Fregoneze M, Mercadante M: The role of associated injuries on outcome of blunt trauma patients sustaining pelvic fractures. Injury. 2000, 31: 677-682. 10.1016/S0020-1383(00)00074-7.View ArticleGoogle Scholar
- Rommens PM, Hessmann MH: Staged reconstruction of pelvic ring disruption: differences in morbidity, mortality, radiologic results, and functional outcomes between B1, B2/B3, and C-type lesions. J Orthop Trauma. 2002, 16: 92-98. 10.1097/00005131-200202000-00004.View ArticlePubMedGoogle Scholar
- Kajüter H, Batzler WU, Krieg V, Heidinger O, Hense HW: Linkage of secondary data with cancer registry data on the basis of encrypted personal identifiers - results from a pilot study in North Rhine-Westphalia. Gesundheitswesen. 2012, 74: e84-e89.PubMedGoogle Scholar
- Brenner H, Schmidtmann I: Effects of record linkage errors on disease registration. Methods Inf Med. 1998, 37: 69-74.PubMedGoogle Scholar
- McCarthy ML, Shore AD, Serpi T, Gertner M, Demeter L: Comparison of Maryland hospital discharge and trauma registry data. J Trauma. 2005, 58: 154-161. 10.1097/01.TA.0000119690.32257.B0.View ArticlePubMedGoogle Scholar
- Phillips B, Clark DE, Nathens AB, Shiloach M, Freel AC: Comparison of injury patient information from hospitals with records in both the national trauma data bank and the nationwide inpatient sample. J Trauma. 2008, 64: 768-779. 10.1097/TA.0b013e3181620152.View ArticlePubMedGoogle Scholar
- Gräsner JT, Wnent J, Seewald S, Meybohm P, Fischer M, Paffrath T, Wafaisade A, Bein B, Lefering R, German Resuscitation Registry Working Group, Trauma Registry of the German Society for Trauma Surgery (DGU). German Resuscitation Registry Working Group, Trauma Registry of the German Society for Trauma Surgery (DGU): Cardiopulmonary resuscitation traumatic cardiac arrest - there are survivors. An analysis of two national emergency registries. Crit Care. 2011, 15: R276-10.1186/cc10558.View ArticlePubMedPubMed CentralGoogle Scholar
- Schreiber VM, Tarkin IS, Hildebrand F, Darwiche S, Pfeifer R, Chelly J, Giannoudis P, Pape HC: The timing of definitive fixation for major fractures in polytrauma - a matched-pair comparison between a US and European level I centres: analysis of current fracture management practice in polytrauma. Injury. 2011, 42: 650-654. 10.1016/j.injury.2010.07.248.View ArticlePubMedGoogle Scholar
- Datta I, Findlay C, Kortbeek JB, Hameed SM: Evaluation of a regional trauma registry. Can J Surg. 2007, 50: 210-213.PubMedPubMed CentralGoogle Scholar
- American College of Surgeons Committee on Trauma: Subcommittee on Trauma Registry Programs: National trauma Data Bank Report Reference Manual: Background, caveats, and resources. 2003, Chicago, IL, USA: American College of SurgeonsGoogle Scholar
- Hlaing T, Hollister L, Aaland M: Trauma registry data validation: Essential for quality trauma care. J Trauma. 2006, 61: 1400-1407. 10.1097/01.ta.0000195732.64475.87.View ArticlePubMedGoogle Scholar
- Zehtabchi S, Nishijima DK, McKay MP, Mann NC: Trauma registries: history, logistics, limitations, and contributions to emergency medicine research. Acad Emerg Med. 2011, 18: 637-643. 10.1111/j.1553-2712.2011.01083.x.View ArticlePubMedGoogle Scholar
- Moore L, Clark DE: The value of trauma registries. Injury. 2008, 39: 686-695. 10.1016/j.injury.2008.02.023.View ArticlePubMedGoogle Scholar
- Röder C, El-Kerdi A, Eggli S, Aebi M: A centralized total joint replacement registry using web-based technologies. J Bone Joint Surg Am. 2004, 86: 2077-2079.PubMedGoogle Scholar
- AG Becken III: [http://www.dgu-online.de/de/dgu/gruppierungen/ags/becken.jsp/]
- TraumaRegister DGU®: [http://www.traumaregister.de/]
- The pre-publication history for this paper can be accessed here:http://www.biomedcentral.com/1471-2288/13/30/prepub