- Research article
- Open Access
- Open Peer Review
Measuring care trajectories using health administrative databases: a population-based investigation of transitions from emergency to acute care
BMC Health Services Research volume 16, Article number: 565 (2016)
A patient’s trajectory through the healthcare system affects resource use and outcomes. Data fields in population-based administrative health databases are potentially valuable resources for constructing care trajectories for entire populations, provided they can capture patient transitions between healthcare services. This study describes patient transitions from the emergency department (ED) to other healthcare settings, and ascertains whether the discharge disposition field recorded in the ED data was a reliable source of patient transition information from the emergency to the acute care settings.
Administrative health databases from the province of Saskatchewan, Canada (population 1.1 million) were used to identify patients with at least one ED visit to provincial teaching hospitals (n = 5) between April 1, 2006 and March 31, 2012. Discharge disposition from ED was described using frequencies and percentages; and it includes categories such as home, transfer to other facilities, and died. The kappa statistic with 95 % confidence intervals (95 % CIs) was used to measure agreement between the discharge disposition field in the ED data and hospital admission records.
We identified N = 1,062,861 visits for 371,480 patients to EDs over the six-year study period. Three-quarters of the discharges were to home, 16.1 % were to acute care in the same facility in which the ED was located, and 1.6 % resulted in a patient transfer to a different acute care facility. Agreement between the discharge disposition field in the ED data and hospital admission records was good when the emergency and acute care departments were in the same facility (κ = 0.77, 95 % CI 0.77, 0.77). For transfers to a different acute care facility, agreement was only fair (κ = 0.36, 95 % CI 0.35, 0.36).
The majority of patients who attended EDs did not transition to another healthcare setting. For those who transitioned to acute care, accuracy of the discharge disposition field depended on whether the two services were provided in the same facility. Using the hospital data as reference, we conclude that the discharge disposition field in the ED data is not reliable for measuring transitions from ED to acute care.
A patient’s care trajectory , the patient’s sequence of contacts with care providers, is important to study because it is expected to affect resource use  and healthcare outcomes [3, 4]. However, there are no standard methods of constructing care trajectories. Population-based administrative health databases are potentially valuable resources for constructing care trajectories for entire populations, provided they can completely capture patient transitions between healthcare services. Incomplete capture of transitions between services will result in inaccurate calculations of healthcare outcomes such as costs, and this could have negative consequences for planning and allocation of healthcare resources .
Generally, a patient’s contacts with the healthcare system are kept in separate administrative health databases; including, for example, hospital records, physician billing claims, and emergency department (ED) data . Some of these databases include data fields that define a patient’s previous and subsequent healthcare contacts. For example, the ED data contains fields that indicate the mode of arrival to and the discharge disposition from the department. These two data fields could be used to identify whether a patient utilized paramedic services prior to arriving in the ED and thereafter got admitted to inpatient acute care. Thus, it is conceivable that patient care trajectory spanning paramedic, ED, and inpatient acute care services can be constructed using data fields recorded in the ED database alone. Although this innovative use of data fields will eliminate the need for linking the ambulance, ED, and hospital data, the accuracy of data fields for capturing patient transitions between services are largely unknown.
Previous studies have focused on the overall quality of individual administrative health databases , and examined their utility for capturing patient data in single healthcare settings . Only a few studies have compared multiple databases across settings, either by evaluating the accuracy of record linkage process for such data sources as ambulance, ED, and hospital , or by examining the completeness of integrated data sets to describe the patient’s journey through the healthcare system . No study, to the best of our knowledge, has described the accuracy of data fields for capturing patient transition information between healthcare services.
This study investigated whether the discharge disposition field recorded in the ED data was a reliable source of patient transition information from the emergency to the acute care settings. Specifically, the objectives were to: (a) describe patient transitions from the ED to all other healthcare settings, and (b) estimate agreement between the discharge disposition field in the ED data and hospital admission records for capturing transitions from the emergency to the acute care settings. The ED often serves as the starting point for the receipt of services in the care trajectory, particularly among patients without a regular source of primary care . ED encounters may require admission to hospital; one of the most expensive care settings. Thus, the ED and hospital are two of the most important healthcare services in describing patient care trajectories.
ED data were obtained from all teaching hospitals (n = 5) in the province of Saskatchewan, Canada, which has a population of approximately 1.1 million . This province, like other Canadian provinces, has a system of universal healthcare, which means that virtually all residents of the province are eligible for health insurance coverage. Only non-residents and individuals such as inmates in federal penitentiaries and members of the armed forces are not covered under the provincial insurance program. The teaching hospitals are located in Saskatoon and Regina Qu’Appelle health regions, two of 12 health regions in the province and the only regions that contain major urban centres (population > 200,000 in each centre). Three EDs started capturing patient data in electronic records in April 1, 2002, and by April 1, 2006 all five EDs were doing so. This study focused on the following fields of the electronic ED data: location, visit and discharge dates, and discharge disposition. Discharge disposition provides information on where the patient goes after treatment in the ED, and includes home, transfer to other facilities, left without being seen, and died. The relevant categories for describing transitions between ED and acute care were admitted to the acute care hospital in which the ED was located and transferred for admission to an acute care hospital in a different facility.
Electronic hospital discharge abstracts and population registry files were also used to conduct the research. A hospital discharge abstract is completed when a patient is discharged from an acute care facility. Hospital discharge data are available for all inpatient hospitalizations in the province. For this study, the relevant fields of the hospital discharge abstracts were the mode of entry to the hospital and the admission dates.
The population registry file contains demographic information, such as date of birth and residence location. It also captures dates of health insurance coverage.
All healthcare databases can be linked via a unique, anonymized personal health identification number. Data were accessed and analyzed at the provincial Health Quality Council in accordance with a standing data sharing agreement between the organization and the provincial ministry of health. Ethics approval for the research was received from the University of Saskatchewan Biomedical Research Ethics Board.
The study adopted a population-based retrospective cohort design, which comprised all provincially insured individuals who had at least one visit to any of the five EDs between 2006/07 and 2011/12 fiscal years (a fiscal year extends from April 1 to March 31).
Patient characteristics selected for investigation were based on the Andersen healthcare utilization model , and included predisposing factors of age group (0–19, 20–39, 40–59, 60–79, 80+) and sex (male, female), and enabling factors of residence location (urban, rural) and health region affiliation (Saskatoon, Regina Qu’Appelle). Urban residents were those whose postal codes were in a census metropolitan or agglomeration area (i.e., 10,000+ population). All variables were measured as of the date of ED visit.
To achieve the first study objective, the ED visit discharge dispositions were described using frequencies and percentages. To achieve the second objective, agreement between the discharge disposition field in the ED data and hospital admission records in capturing patient transitions between the two services was estimated using the kappa statistic (κ) ; 95 % confidence intervals (CIs) were also computed. The κ statistic has been used in previous studies to measure agreement between administrative health databases [14, 15]. We selected κ statistic as the measure of agreement because our variable of interest is binary (i.e., whether or not patient transitions from emergency care to acute care were recorded in both the ED and hospital databases) . The value of κ is 1 when perfect agreement exists between two sources, 0 when agreement is equal to that expected assuming independence, and negative when agreement is less than expected by chance . The interpretation of agreement adopted here is: poor (κ < 0.20), fair (κ = 0.20 to 0.39), moderate (κ = 0.40 to 0.59), good (κ = 0.60 to 0.79), and very good (κ = 0.80 to 1.00) . When measuring agreement, we linked patient transitions from ED to acute care by matching hospital admissions which occurred on the same day as the ED discharge; as well as allowing up to 3 days between ED discharge date and hospital admission date in a sensitivity analysis . Patient transitions between ED and acute care were assessed where the ED and the acute care hospital were in the same facility, as well as where the ED and the admitting acute care hospital were not in the same facility. Analyses were stratified by fiscal year and ED location.
Percentages (95 % CIs) were used to describe the differences between cohort members whose transition information was and was not missing. A patient’s transition information was considered missing if the ED discharge disposition indicated that the patient was admitted to an acute care hospital either in the same facility as the ED or in a different facility but the patient’s admission information was not recorded in the hospital discharge abstracts.
A total of 383,860 patients had at least one visit to an ED in the province’s teaching hospitals between 2006/07 and 2011/12 fiscal years. Of this number, 12,380 (3.2 %) patients did not have provincial insurance coverage (e.g., were not residents of the province) and were therefore excluded. Thus, the study cohort was comprised of 371,480 patients (96.8 %) with a total of 1,062,861 ED visits over the study period.
Table 1 summarizes the discharge dispositions for all ED visits by the study cohort members. Three-quarters of ED visits resulted in a discharge to the patient’s home, while 16.1 % resulted in admission to the acute care hospital in which the ED was located, and 1.6 % resulted in a transfer for admission to an acute care in a different facility.
The contingency table statistics used to calculate the overall agreement between the ED data and hospital records are summarized in Table 2. Of the 170,584 visits recorded in the ED data with a discharge disposition of admitted to the acute care hospital in which the ED was located (Table 1), only 143,633 of these visits were found in the hospital discharge abstracts with the same admission date as the ED discharge date (cell A in the upper half of Table 2). Similarly, of the 16,951 visits recorded in the ED data with a discharge disposition of transferred for admission to an acute care hospital in a different facility (Table 1), only 6,633 of these visits were found in the hospital discharge abstracts with the same admission date as the ED discharge date (cell A in the lower half of Table 2).
Table 3 provides the results for the assessment of patient transitions from ED to acute care settings, stratified by fiscal year. For the case where patients were admitted to acute care in the same facility in which the ED was located, the overall agreement between the ED and hospital records was good (κ = 0.77, 95 % CI = 0.77, 0.77). The agreement between the two data sources was lowest (κ = 0.55, 95 % CI = 0.54, 0.55) in 2006/07 fiscal year and increased steadily to the highest value (κ = 0.94, 95 % CI = 0.94, 0.94) in 2011/12 fiscal year. For ED discharges to acute care in a different facility, the overall agreement was only fair (κ = 0.36, 95 % CI = 0.35, 0.36); agreement varied by fiscal year, reaching its peak (κ = 0.40, 95 % CI = 0.39, 0.42) in 2009/10.
The level of agreement between ED and hospital records also varied across facilities (Fig. 1); with κ estimates ranging from good (i.e., κ = 0.68 for ED #5) to very good (i.e., κ = 0.87 for ED #4).
In the sensitivity analysis, when a lag of up to three days between ED discharge and hospital admission dates was allowed, agreement increased slightly both for admissions to acute care in the same facility in which the ED was located (from κ = 0.77 to κ = 0.80), and for transfers to an acute care hospital located in a different facility (from κ = 0.36 to κ = 0.43).
Table 4 compares the characteristics of cohort members whose transition information was and was not missing. Those whose information was missing from the ED to the acute care in which the ED was located had a total of 3,601 ED visits over the study period; and they were younger (62.8 % vs 38.6 % in the 20 to 59 years age group) and were more likely to be male (59.4 % vs 50.6 %) than those whose information was not missing. No major differences were observed between the two groups in terms of residence location and health region affiliation. Similarly, patients whose transition information was missing when they were transferred from the ED to an acute care in a different facility had a total of 1,218 ED visits over the study period; and were younger (64.1 % vs 43.3 % in the 20 to 59 years age group), and with more representation of males (61.9 % vs 49.7 %) than those whose information was not missing.
The vast majority of patients who visited EDs in Saskatchewan’s teaching hospitals during the study period did not transition to other healthcare services; they were discharged home. Although the accuracy of the ED discharge to home information could not be ascertained within our study, our estimate of 74.9 % of ED visits being discharged home is consistent with another Canadian study which found 73.8 % of ED visits being discharged home during a similar time period . Similarly, our results for discharges to acute care were quite similar to those recorded in the National Ambulatory Care Reporting System (NACRS) for Canada , especially for visits transferred for admission to an acute care in a different facility (average of 1.6 % over our study period versus an average of 1.1 % in NACRS over the same period). We found higher rates for admissions to the acute care hospital in which the ED was located than the NACRS data (16.1 % vs 9.4 %), and this might have occurred because ED visit rates reported in NACRS exclude scheduled visits.
The overall agreement between the discharge disposition field in the ED data and hospital admission records in capturing transitions from the ED to the acute care hospital in which the ED was located was good; a high proportion of all ED visits recorded as being discharged to an acute care hospital located within the same facility were identified in the hospital records as being admitted on the same date. We also noted a steady improvement in agreement between the two data sources over time. This may be an indication of improvements in data quality over time.
Among ED visits transferred to an acute care hospital located in a different facility, agreement between the discharge disposition field in the ED data and hospital admission records was only fair. Thus, a high proportion of all ED visits recorded as being discharged to an acute care hospital located in a different facility were not identified in the hospital records as being admitted to the facility on the same date. Also, the measure of agreement did not improve consistently over time for this category of ED discharges. The highest agreement was observed in 2009/10 fiscal year, and may be associated with a major outbreak of H1N1 flu virus in Canada . A high level of inter-facility collaboration between the EDs and acute care hospitals likely occurred during this period.
Patient transition information between the ED and acute care were more likely to be missing at some ED locations than others. ED numbers 1 and 2 are located in the Regina Qu’Appelle health region whilst the other three EDs are located in Saskatoon health region. Although the data used in this study has been anonymized and harmonized by Saskatchewan eHealth, two separate information systems were used by the health regions for collecting the ED data. However, there was no clear influence of the difference in the information system on the results; since the EDs with the highest and lowest agreement were both located in the same health region. One of the EDs in Saskatoon health region was located in the biggest teaching hospital in the province and serves as the main trauma center for the province.
Allowing for up to three days between the ED discharge date and hospital admission date in a sensitivity analysis resulted in some improvement in agreement between the two data sources. The possibility of lags between ED discharge and hospital inpatient admission for the same episode of care was reported by a previous study . Nonetheless, the overall agreement between the two data sources for ED visits discharged to an acute care hospital in a different facility remained low.
The low level of agreement between the discharge disposition field in the ED data and hospital admission records, particularly for ED visits discharged to acute care in a different facility, have implications for using data fields to construct care trajectories. Although the use of existing data fields is a simple approach than linking multiple databases to construct care trajectories, our findings indicate that these data fields could result in incomplete capture of patient transitions.
One potential reason for the low agreement between the discharge disposition field in the ED data and hospital admission records for ED discharges to acute care in a different facility is data entry errors. Peabody et al.  found inaccuracies in the coding of primary and secondary diagnosis in administrative data; similar coding errors might exist in the ED data with regards to the coding of the discharge disposition field. Another possible reason may be that patients did not reach the hospital to which they were being transferred, either due to death in the case of severely ill patients or a decision to seek care elsewhere. Further investigations, including chart reviews, could explore cause(s) of the low agreement between the two data sources in capturing patient transitions.
We were unable to evaluate the accuracy of discharge dispositions with regards to ED discharges to other types of care setting (i.e., non-acute care) because we did not have access to any linkable data sources containing these healthcare services. This study could be expanded to include healthcare utilizations prior to the arrival in ED such as ambulance services. By linking ambulance services, ED, and hospital data, future studies would be able to concurrently assess the accuracy of both the mode of entry and discharge disposition fields recorded in the ED data.
In summary, the majority of patients who attended EDs during the study period did not transition to another healthcare setting. For those who transitioned to acute care, accuracy of the discharge disposition field depended on whether the two services were provided in the same facility. The discharge disposition field was more accurate in capturing transitions that occurred in the same facility than those that occurred between different facilities. Using the hospital data as reference, we conclude that the discharge disposition field recorded in the ED data did not capture the complete information on patient transitions to acute care services. Therefore, studies of patient care trajectories intended to describe transitions from the ED to acute care should not rely exclusively on the discharge disposition field, but rather be conducted by linking patient-specific records across the two care settings.
National ambulatory care reporting system
Le Meur N, Gao F, Bayat S. Mining care trajectories using health administrative information systems: the use of state sequence analysis to assess disparities in prenatal care consumption. BMC Health Serv Res. 2015;15(1):1–10.
Peltola M, Juntunen M, Häkkinen U, Rosenqvist G, Seppälä TT, Sund R. A methodological approach for register-based evaluation of cost and outcomes in health care. Ann Med. 2011;43(Suppl 1(January)):S4–S13.
Adeyemi S, Demir E, Chaussalet T. Towards an evidence-based decision making healthcare system management: Modelling patient pathways to improve clinical outcomes. Decis Support Syst. 2013;55(1):117–25.
Elliss-Brookes L, McPhail S, Ives A, et al. Routes to diagnosis for cancer - determining the patient journey using multiple routine data sets. Br J Cancer. 2012;107(8):1220–6.
Jay N, Nuemi G, Gadreau M, Quantin C. A data mining approach for grouping and analyzing trajectories of care using claim data: the example of breast cancer. BMC Med Inform Decis Mak. 2013;13:130.
Roos LL, Gupta S, Soodeen R-A, Jebamani L. Data quality in an information-rich environment: Canada as an example. Can J Aging / La Rev Can du Vieil. 2005;24(S1):153–70.
Jacke CO, Kalder M, Wagner U, Albert U-S. Valid comparisons and decisions based on clinical registers and population based cohort studies: assessing the accuracy, completeness and epidemiological relevance of a breast cancer query database. BMC Res Notes. 2012;5(1):700.
Crilly J, O’Dwyer J, O’Dwyer M. Linking ambulance, emergency department and hospital admissions data: understanding the emergency journey. Med J Aust. 2011;194(4):S34–7.
Wong A, Kozan E, Sinnott M, Spencer L, Eley R. Tracking the patient journey by combining multiple hospital database systems. Aust Health Rev. 2014;38(3):332–6.
McHale P, Wood S, Hughes K, Bellis MA, Demnitz U, Wyke S. Who uses emergency departments inappropriately and when - a national cross-sectional study using a monitoring data system. BMC Med. 2013;11:258.
Statistics Canada, Population and dwelling counts for Canada, provinces and territories, 2011 and 2006 censuses, Ottawa, ON. Available at: http://www12.statcan.gc.ca/census-recensement/2011/dp-pd/hlt-fst/pd-pl/Table-Tableau.cfm?LANG=Eng&T=101&S=50&O=A (2012). Accessed 14 Sep 2014.
Andersen RM. Revisiting the behavioral model and access to medical care: does it matter? J Health Soc Behav. 1995;36(1):1–10.
Cohen J. A coefficient of agreement for nominal scales. Educ Psychol Meas. 1960;20(1):37–46.
Chen G, Faris P, Hemmelgarn B, Walker RL, Quan H. Measuring agreement of administrative data with chart data using prevalence unadjusted and adjusted kappa. BMC Med Res Methodol. 2009;9:5.
Turner D, Hildebrand KJ, Fradette K, Latosinsky S. Same question, different data source, different answers? Data source agreement for surgical procedures on women with breast cancer. Heal Policy. 2007;3(1):46–54.
Hallgren KA. Computing inter-rater reliability for observational data: an overview and tutorial. Tutor Quant Methods Psychol. 2012;8(1):23–34.
Warrens MJ. Cohen’s kappa is a weighted average. Stat Methodol. 2011;8(6):473–84.
Doupe M, Kozyrskyj A, Soodeen R-A, Derksen S, Burchill C, Huq S. An initial analysis of emergency departments and urgent care in Winnipeg, Winnipeg, MB. 2008. Available at: http://mchp-appserv.cpe.umanitoba.ca/reference/EDFull.pdf. Accessed 13 Oct 2014.
Canadian Institute for Health Information, The impact of the H1N1 pandemic on Canadian hospitals, Ottawa, ON. 2010. Available at: https://secure.cihi.ca/estore/productSeries.htm?pc=PCC545. Accessed 20 Aug 2014.
Rolland E. Comparing Telehealth and NACRS Influenza Activity to Fluwatch Surveillance Using EARS-X. Adv Dis Surveill. 2007;4:189.
Peabody J, Luck J, Jain S. Assessing the accuracy of administrative data in health information systems. Med Care. 2004;42(11):1066–72.
This study is based in part on de-identified data provided by the Saskatchewan Ministry of Health, Regina Qu’Appelle Regional Health Authority, and Saskatoon Regional Health Authority. The interpretations and conclusions contained herein do not necessarily represent those of the Government of Saskatchewan, Saskatchewan Ministry of Health, Regina Qu’Appelle Regional Health Authority Region, or Saskatoon Regional Health Authority.
This study was supported in part by funding from the Centennial Chair Program at the University of Saskatchewan to LML. JPK was supported by a Graduate Studentship from Research Manitoba.
Availability of data and materials
All data used in this study are protected under the privacy policies of the Data Stewards of Saskatchewan health administrative data and Saskatchewan Health Quality Council. Signed confidentiality agreements prevent us from sharing the data.
JPK, LML, JQ, and GFT conceived the study and participated in its design. XEW and MO conducted the data extraction and data manipulation. JPK carried out the statistical analyses and summarized the results. JPK and LML drafted the manuscript. All authors read and approved the final manuscript.
The authors declare that they have no competing interests.
Consent for publication
Ethics approval and consent to participate
All information was made anonymous according to data protection regulations and our study was approved by the University of Saskatchewan Biomedical Research Ethics Board (Bio 11–35). The need for consent to participate is deemed unnecessary since anonymized patient-level data was used in the study.
About this article
Cite this article
Kuwornu, J.P., Lix, L.M., Quail, J.M. et al. Measuring care trajectories using health administrative databases: a population-based investigation of transitions from emergency to acute care. BMC Health Serv Res 16, 565 (2016) doi:10.1186/s12913-016-1775-x
- Data linkage
- Emergency department
- Healthcare trajectory
- Hospital records