Background: In Germany there is currently no health reporting on cross-sectoral care patterns in the context of an emergency department care treatment. The INDEED project (Utilization and trans-sectoral patterns of care for patients admitted to emergency departments in Germany) collects routine data from 16 emergency departments, which are later merged with outpatient billing data from 2014 to 2017 on an individual level.
Aim: The methodological challenges in planning of the internal merging of routine clinical and administrative data from emergency departments in Germany up to the final data extraction are presented together with possible solution approaches.
Methods: Data were selected in an iterative process according to the research questions, medical relevance, and assumed data availability. After a preparatory phase to clarify formalities (including data protection, ethics), review test data and correct if necessary, the encrypted and pseudonymous data extraction was performed.
Results: Data from the 16 cooperating emergency departments came mostly from the emergency department and hospital information systems. There was considerable heterogeneity in the data. Not all variables were available in every emergency department because, for example, they were not standardized and digitally available or the extraction effort was judged to be too high.
Conclusion: Relevant data from emergency departments are stored in different structures and in several IT systems. Thus, the creation of a harmonized data set requires considerable resources on the part of the hospital as well as the data processing unit. This needs to be generously calculated for future projects