HIS-based Kaplan-Meier plots - a single source approach for documenting and reusing routine survival information
© Breil et al; licensee BioMed Central Ltd. 2011
Received: 12 August 2010
Accepted: 16 February 2011
Published: 16 February 2011
Survival or outcome information is important for clinical routine as well as for clinical research and should be collected completely, timely and precisely. This information is relevant for multiple usages including quality control, clinical trials, observational studies and epidemiological registries. However, the local hospital information system (HIS) does not support this documentation and therefore this data has to generated by paper based or spreadsheet methods which can result in redundantly documented data. Therefore we investigated, whether integrating the follow-up documentation of different departments in the HIS and reusing it for survival analysis can enable the physician to obtain survival curves in a timely manner and to avoid redundant documentation.
We analysed the current follow-up process of oncological patients in two departments (urology, haematology) with respect to different documentation forms. We developed a concept for comprehensive survival documentation based on a generic data model and implemented a follow-up form within the HIS of the University Hospital Muenster which is suitable for a secondary use of these data. We designed a query to extract the relevant data from the HIS and implemented Kaplan-Meier plots based on these data. To re-use this data sufficient data quality is needed. We measured completeness of forms with respect to all tumour cases in the clinic and completeness of documented items per form as incomplete information can bias results of the survival analysis.
Based on the form analysis we discovered differences and concordances between both departments. We identified 52 attributes from which 13 were common (e.g. procedures and diagnosis dates) and were used for the generic data model. The electronic follow-up form was integrated in the clinical workflow. Survival data was also retrospectively entered in order to perform survival and quality analyses on a comprehensive data set. Physicians are now able to generate timely Kaplan-Meier plots on current data. We analysed 1029 follow-up forms of 965 patients with survival information between 1992 and 2010. Completeness of forms was 60.2%, completeness of items ranges between 94.3% and 98.5%. Median overall survival time was 16.4 years; median event-free survival time was 7.7 years.
It is feasible to integrate survival information into routine HIS documentation such that Kaplan-Meier plots can be generated directly and in a timely manner.
Accurate survival or outcome information is important for many clinical studies, clinical routine and epidemiology. The standard method for estimating survival is the Kaplan-Meier plot (KM-plot)  with high relevance in medical research. Particularly in oncology the Kaplan-Meier technique is used to compare survival information between different therapy strategies or stages of the disease . Survival time and follow-up status are used to compute an estimate of a survival curve for censored data.
In the German healthcare system a distinction can be made between the routine documentation which is commonly performed in hospital information systems or still paper based and the research documentation mainly performed in electronic data capture systems (EDC) or on paper based case report forms (CRF). There are several systems in healthcare resulting in separate documentation of medical routine, research and quality management data. In the context of clinical studies survival information is currently captured on paper based CRF and occasionally on electronic CRF (eCRF), but generally separated from HIS. However, some patients already have at least a basic electronic medical record . Currently survival analysis is not possible within the HIS as the required data is not available. A problem of these external databases consists in the resulting difficult multiple usage of information. Data from a single patient can be relevant for several studies (e.g. therapy study, biomarker discovery study, epidemiological studies) in addition to clinical routine. Redundant documentation is common but inefficient regarding a resource limited setting and carries the danger of inconsistent information. In this setting it would be attractive to use health data outside of direct care delivery. A secondary use of documented data for research and quality management  may be of potential benefit for those physicians who already use electronic documentation . For instance, the idea of the REUSE project implies that clinical data should be based in the electronic health record (EHR) independent from the context, in which data is captured . The secondary use of clinical data has enormous potential for improving quality of care [7, 8].
Furthermore, there is heterogeneity in the required follow-up documentation depending on the disease and the department in which the data is obtained. Physicians need further information to interpret the status in combination with clinical data. Also, the parameter values for the follow-up status may be different between oncological diseases. Therefore, an efficient implementation should be based on a generic data model which is suitable for several diseases.
Studies of health services research, epidemiological studies and phase III/IV studies often consist of a high number of cases resulting in laborious documentation and high data management costs. Using routine documentation may reduce the documentation workload and reduce costs. To reach these goals the respective source data have to be "accurate, legible, contemporaneous, original, attributable, complete and consistent" .
However, data quality of follow-up documentation is often unsatisfactory  and requires adaption before it can be used for research. The follow-up documentation needs to be complete to obtain meaningful KM-plots as incomplete information can bias the analysis of the results . One strategy to increase completeness and achieve higher data quality is to use an electronic documentation tool [12, 13]. This approach could be extended to use the HIS for clinical and research documentation which would also result in high data quality . Commercial HIS usually cover only events during hospitalisation so there is a need for a special follow-up module to allow the survival documentation for inpatients and outpatients.
With respect to clinical quality management it is important to obtain timely KM-plots of all patients and not just from those in clinical studies. Thus, it would be desirable to integrate the follow-up documentation into clinical routine and document it in the EHR within the HIS. Using this method, it will be made available for all treating physicians and clinical research projects can be combined with routine documentation by reusing the EHR .
Is it feasible to design a follow-up documentation system in the HIS which is suitable for several oncological diseases and provides a secondary use of data?
Is it possible to extract survival information from routine HIS documentation so that physicians can obtain KM-plots in a timely manner?
What level of data quality can be achieved with respect to completeness of forms and completeness of items per form?
We analysed the current follow-up documentation process in the urology and haematology department at the University Hospital Muenster. Physicians were interviewed to identify weak points and requirements during the follow-up appointments.
During the form analysis we investigated the attributes which characterise the overall survival (OS) and the event-free survival (EFS). We compared follow-up documentation of two tumours regarding type, complexity and concordances.
Concept, data model and implementation
We developed a concept for comprehensive survival documentation based on a generic data model which is described in the CDISC Operational Data Model (ODM v1.3.1.)  using SNOMED CT V3 Codes . Based on this concept an electronic survival form was implemented within the local HIS containing specialised parts for leukaemia and for prostate cancer. We used the integrated tools of the HIS (ORBIS® from Agfa Healthcare)  to create a form which contains all relevant survival data for KM-plots and integrated it into the clinical workflow.
Data export and survival analysis
We created a report of the HIS form to extract follow-up information (initial diagnosis date, initial therapy date, date of last contact, status at the last contact, etc.) from the HIS and to transfer pseudonymized data sets to statistical programs. This report was integrated in the HIS in such a way that it can be used by the physicians to view summarized data of their patients in the HIS or to export pseudonymized survival data as comma separated values (CSV). Survival analyses were implemented in R (version 2.10.1) and for the KM-plots we used the "survfit function" of the R survival library . Differences between subgroups of patients were assessed using log-rank test, implemented in the "survdiff function". A batch script was written to execute the R survival function in such a way that survival curves and data quality information are directly accessible in a PDF-file.
Analysing data quality
We analysed completeness to describe data quality according to Chan et al . Therefore, we designed a report to query missing and incomplete forms. Based on these export data, completeness of forms (reference: all prostate cancer patients in urology) and completeness of documented items per form were analysed.
The study was performed in compliance with the World Medical Association Declaration of Helsinki on Ethical Principles for Medical Research Involving Human Subjects. HIS data access was approved by the responsible data protection officer, only de-identified data items were exported.
Process analysis of the paper based follow-up documentation
Follow-up documentation was paper based for AML patients in haematology and spreadsheet based for prostate cancer patients in urology. In both departments, forms were completed when patients were appointed to follow-up examinations. If the patient lacked a follow-up date the treating physicians could obtain the information from general practitioners, from the epidemiology cancer registry or from the registration office (in case of fatality). For statistical analysis and survival curves the follow-up documentation was entered manually into spreadsheets or statistical programs which were then used to generate KM-plots.
Results of the form analysis
Status values in the department of haematology and urology
Status in the haematology department (AML)
Status in the urology department (prostate cancer)
Complete remission unconfirmed
Death of AML
Death of prostate cancer
Death independent from AML
Death independent from prostate cancer
Death of unknown cause
Death of unknown cause
Concept and data model
In routine documentation the follow-up form should be completed for every cancer patient in the respective department. Patients with prostate cancer or leukaemia have regular follow-up examination and during those visits the survival information is documented. If patients do not appear the information has to be collected from the current practitioner. In this case physicians and study nurses enquire relevant information from general practitioners as well as the registration office (if there is a fatality reported) and enter this information into the system. We also added the attribute "source" so that the documenting physician can document the enquired institution. In this manner information from outpatients can be also documented. In addition to this generic form, disease and department specific attributes can be documented in specific form components which were provided for prostate cancer and leukaemia. To analyse the feasibility of KM-plots based on structured HIS data the form was integrated in the clinical workflow in the urology department and during a short time frame data from follow-up patients was documented. To achieve a high number of cases which allow for comprehensive analyses and to reuse previously existing survival data from paper based records or spreadsheet files in the urology department this information was retrospectively transferred to the HIS. In the haematology department up until now the electronic follow-up documentation was only used in a pilot installation with relatively few patients. Therefore, the following analyses are based on urology data. In our approach we provide one form per follow-up date so that each patient has several forms during the course of his disease. The current survival status is always taken from the most current form.
The documented survival data were extracted from the EHR and analysed with the statistic software R. We considered a follow-up period from 03.06.1992 to 31.05.2010 in which patients where documented and completed follow-up forms also retrospectively to obtain a relevant data basis for the KM-plots. In total follow-up forms were entered from 23rd February to 01st July 2010 for 1029 patients; 223 of them were completed in the routine documentation process, 806 were entered retrospectively. Using the R survival library we implemented survival analyses and KM-plots based on exported CSV-data. First we removed all duplicated forms from all patients and kept only the data from the most current form. Observation time was defined on basis of therapy start date and follow-up date, overall survival and event-free survival were computed concerning the following status encodings (table 2). We created data frames for the EFS and OS for the patient collective as well as data frames for grouped analyses. Prostate cancer patients were divided into two groups. KM-plots with numbers at risk were generated from all four data frames. The complete R code can be found in the supplement (see Additional file 2).
Survival information of patients in the urology department
Department of urology
Analysis of overall survival
Analysis of event-free survival
Number of patients
Survival information available
Median survival time (years)
Probability of 5-year survival (percent)
Probability of 10-year survival (percent)
Total number of events
We wrote a batch script to automate the process from the export file to the final PDF with the KM-plots. During several discussions with health professionals we discovered that there are patients for whom no accurate date of relapse or freedom of relapse can be specified. To handle this, the generic data model was adapted to allow for imprecise inputs (e.g. Oct. 2008, 2007).
Completeness of survival data
Therapy start date
All three available
To analyse the acceptance of the electronic forms we measured how many patients with prostate cancer diagnosis already have an electronic follow-up form. For the analysis of the completeness of forms, we considered patients with a main diagnosis of prostate cancer from 01.01.2009 to 31.12.2009 in the department of urology. We chose this time range because patients with recent diagnoses are currently not appointed to follow-up examination and could bias the result. In total 115 of the 191 patients have at least one follow-up form with survival information so that completeness of forms is 60.2%.
With our implementation it is now possible to generate KM-plots from routine data. After exporting follow-up data sets in a pseudonymized format from the HIS the physician can start the batch script with the R survival functions to obtain a resulting PDF-file with the KM-plots. Both actions can be done by physicians within a minute and therefore it is a feasible method to get timely curves from the current data. Up to now, this procedure was not possible for physicians because data from routine documentation has to be transferred into statistical programs for survival analyses to be performed. The idea to enhance the primary information system is not a new one. Previously, in 1996, Balas et al. state that "to manage care and improve quality, primary care computer systems should incorporate these effective information services" . However, the implementation of single source systems as described by Kush et al.  is still rare. During our literature search, we failed to find similar approaches of integrating this kind of follow-up documentation in the HIS in such a way that timely survival curves can be generated. Ene-Iordache et al. analysed regulatory-compliant eCRF  and Embi et al. identified in 2009 a lack of tools for clinical research activities . By using electronic point-of-care documentation to generate KM-plots clinical research activities can be supported and the integrated documentation contributes to the single source approach.
Data Quality Aspects
The measured data quality, especially the completeness of documented items per form, was high but most of information was transferred from retrospective data collections (paper based documentation and spreadsheets). The completeness of the electronic forms in the HIS (retrospective and current documentation) was only 60.2% so we assume that there are still patients with missing or paper based documentation. However, to analyse the completeness of forms more data is needed. Further analyses will show the differences in completeness of forms between the retrospective collection and the routine documentation. Chan et al. reviewed data quality in EHRs of recent studies and reported that data completeness varied substantially across studies and that even in the same organisation the amount of missing data is varying . To measure follow-up completeness Clark et al. introduced the ratio of the total observed person-time of follow-up as a percentage of the potential time of follow-up in a study . Therefore we measured follow-up completeness of C = 76.9% using this approach for all prostate cancer patients who underwent radical prostatectomy in the urology department.
The follow-up documentation is heterogeneous and therefore the implementation in a local HIS is complex and time consuming. There is currently no possibility to reuse captured routine data in electronic study documentation systems and therefore the advantages of HIS based documentation are limited. Especially studies with a high number of study cases (e.g. epidemiological studies, phase IV studies) are attractive for data re-use. The follow-up documentation is usually scheduled in defined intervals (depending on the disease). The HIS-based approach adds the functionality to notify the treating physicians of required documentation activities. We plan to integrate work lists which show all patients without a follow-up form in the last year. This approach could be extended by an automated creation of forms in the HIS related to the follow-up intervals. Survival information in the HIS can be re-used for physician letters. Our approach of follow-up documentation is generic and we intend to extend it to other departments and diseases. If the follow-up information is available for many patients it can also be used for patient recruitment for clinical trials [25–28] as attributes like survival status are now documented in a structured way within the HIS and can be used as inclusion or exclusion criteria.
In a short time frame 223 cases were documented during routine documentation which indicates a good clinical acceptance. In addition 806 cases were completed retrospectively in order to have the entire follow-up documentation electronically available showing the need for HIS based follow-up documentation. Structured documentation of follow-up items should therefore be a standard functionality in HIS.
Different follow-up forms can be united in a comprehensive module which is suitable for oncological diseases. The integration in the local HIS is feasible and provides possibilities to reuse this information for quality control and clinical research (single source) by generating timely survival curves from routine data.
acute myeloid leukaemia
Clinical Data Interchange Standards Consortium
case report form
electronic case report form
comma separated values
electronic data capture
electronic health record
hospital information system
Operational data model
portable document format
prostate specific antigen
- SNOMED CT:
Systematized Nomenclature of Medicine - Clinical Terms
Regina Weis supported retrospective data collection.
Kathleen O'Hagan supported English writing.
- Kaplan EL, Meier P: Nonparametric estimation from incomplete observations. Journal of the American Statistical Association. 53: 457-481. 10.2307/2281868.
- Yang I, Sughrue ME, Rutkowski MJ, Kaur R, Ivan ME, Aranda D, Barani IJ, Parsa AT: Craniopharyngioma: a comparison of tumor control with various treatment strategies. Neurosurg Focus. 2010, 28 (4): E5-10.3171/2010.1.FOCUS09307.View ArticlePubMedGoogle Scholar
- Jha AK, DesRoches CM, Campbell EG, Donelan K, Rao SR, Ferris TG, Shields A, Rosenbaum S, Blumenthal D: Use of electronic health records in U.S. hospitals. N Engl J Med. 2009, 360 (16): 1628-38. 10.1056/NEJMsa0900592.View ArticlePubMedGoogle Scholar
- Safran C, Bloomrosen M, Hammond WE, Labkoff S, Markel-Fox S, Tang PC, Detmer DE, Expert Panel: Toward a national framework for the secondary use of health data: an American Medical Informatics Association White Paper. J Am Med Inform Assoc. 2007, 14 (1): 1-9. 10.1197/jamia.M2273.View ArticlePubMedPubMed CentralGoogle Scholar
- Hersh WR: Adding value to the electronic health record through secondary use of data for quality assurance, research, and surveillance. Am J Manag Care. 2007, 13 (6 Part 1): 277-8.PubMedGoogle Scholar
- El Fadly A, Lucas N, Rance B, Verplancke P, Lastic PY, Daniel C: The REUSE project: EHR as single datasource for biomedical research. Stud Health Technol Inform. 2010, 160 (Pt 2): 1324-8.PubMedGoogle Scholar
- Elkin PL, Trusko BE, Koppel R, Speroff T, Mohrer D, Sakji S, Gurewitz I, Tuttle M, Brown SH: Secondary use of clinical data. Stud Health Technol Inform. 2010, 155: 14-29.PubMedGoogle Scholar
- Einbinder JS, Bates DW: Leveraging information technology to improve quality and safety. Yearb Med Inform. 2007, 22-9.Google Scholar
- Ohmann C, Kuchinke W: Future developments of medical informatics from the viewpoint of networked clinical research. Interoperability and integration. Methods Inf Med. 2009, 48 (1): 45-54.PubMedGoogle Scholar
- Forster M, Bailey C, Brinkhof MW, Graber C, Boulle A, Spohr M, Balestre E, May M, Keiser O, Jahn A, Egger M, ART-LINC collaboration of International Epidemiological Databases to Evaluate AIDS: Electronic medical record systems, data quality and loss to follow-up: survey of antiretroviral therapy programmes in resource-limited settings. Bull World Health Organ. 2008, 86 (12): 939-47. 10.2471/BLT.07.049908.View ArticlePubMedPubMed CentralGoogle Scholar
- Clark TG, Altman DG, De Stavola BL: Quantification of the completeness of follow-up. Lancet. 2002, 359 (9314): 1309-10. 10.1016/S0140-6736(02)08272-7.View ArticlePubMedGoogle Scholar
- Ammenwerth E, Mansmann U, Iller C, Eichstädter R: Factors affecting and affected by user acceptance of computer-based nursing documentation: results of a two-year study. J Am Med Inform Assoc. 2003, 10 (1): 69-84. 10.1197/jamia.M1118.View ArticlePubMedPubMed CentralGoogle Scholar
- Bürkle T, Beisig A, Ganslmayer M, Prokosch HU: A randomized controlled trial to evaluate an electronic scoring tool in the ICU. Stud Health Technol Inform. 2008, 136: 279-84.PubMedGoogle Scholar
- Breil B, Semjonow A, Dugas M: HIS-based electronic documentation can significantly reduce the time from biopsy to final report for prostate tumours and supports quality management as well as clinical research. BMC Med Inform Decis Mak. 2009, 20: 9-5.Google Scholar
- Prokosch HU, Ganslandt T: Perspectives for medical informatics. Reusing the electronic medical record for clinical research. Methods Inf Med. 2009, 48 (1): 38-44.PubMedGoogle Scholar
- Clinical Data Interchange Standards Consortium (CDISC). [http://www.cdisc.org/odm]
- International Health Terminology Standards Development Organisation (IHTSDO). [http://www.ihtsdo.org/snomed-ct/]
- Agfa Healthcare. [http://www.agfa.com/en/he/home.jsp]
- R: A language and environment for statistical computing. [http://www.R-project.org]
- Chan KS, Fowles JB, Weiner JP: Electronic Health Records and Reliability and Validity of Quality Measures: A Review of the Literature. Med Care Res Rev. 2010Google Scholar
- Balas EA, Austin SM, Mitchell JA, Ewigman BG, Bopp KD, Brown GD: The clinical value of computerized information services. A review of 98 randomized clinical trials. Arch Fam Med. 1996, 5 (5): 271-8. 10.1001/archfami.5.5.271.View ArticlePubMedGoogle Scholar
- Kush R, Alschuler L, Ruggeri R, Cassells S, Gupta N, Bain L, Claise K, Shah M, Nahm M: Implementing Single Source: the STARBRITE proof-of-concept study. J Am Med Inform Assoc. 2007, 14 (5): 662-73. 10.1197/jamia.M2157.View ArticlePubMedPubMed CentralGoogle Scholar
- Ene-Iordache B, Carminati S, Antiga L, Rubis N, Ruggenenti P, Remuzzi G, Remuzzi A: Developing regulatory-compliant electronic case report forms for clinical trials: experience with the demand trial. J Am Med Inform Assoc. 2009, 16 (3): 404-8. 10.1197/jamia.M2787.View ArticlePubMedPubMed CentralGoogle Scholar
- Embi PJ, Payne PR: Clinical research informatics: challenges, opportunities and definition for an emerging domain. J Am Med Inform Assoc. 2009, 16 (3): 316-27. 10.1197/jamia.M3005.View ArticlePubMedPubMed CentralGoogle Scholar
- Dugas M, Lange M, Berdel WE, Müller-Tidow C: Workflow to improve patient recruitment for clinical trials within hospital information systems - a case-study. Trials. 2008, 11: 9-2.Google Scholar
- Dugas M, Amler S, Lange M, Gerss J, Breil B, Köpcke W: Estimation of patient accrual rates in clinical trials based on routine data from hospital information systems. Methods Inf Med. 2009, 48 (3): 263-6.View ArticlePubMedGoogle Scholar
- Sinha G: Electronic health records help recruit trial participants and track drug safety. J Natl Cancer Inst. 2008, 100 (6): 384-5. 10.1093/jnci/djn070.View ArticlePubMedGoogle Scholar
- Dugas M, Lange M, Müller-Tidow C, Kirchhof P, Prokosch HU: Using routine data from hospital information systems to facilitate recruitment in clinical research. Clinical Trials. 2010, 7 (2): 183-9. 10.1177/1740774510363013.View ArticlePubMedGoogle Scholar
- The pre-publication history for this paper can be accessed here:http://www.biomedcentral.com/1472-6947/11/11/prepub
This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/2.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.