Skip to main content

Event-based record linkage in health and aged care services data: a methodological innovation

Abstract

Background

The interface between acute hospital care and residential aged care has long been recognised as an important issue in aged care services research in Australia. However, existing national data provide very poor information on the movements of clients between the two sectors. Nevertheless, there are national data sets which separately contain data on individuals' hospital episodes and stays in residential aged care, so that linking the two data sets–if feasible–would provide a valuable resource for examining relationships between the two sectors. As neither name nor common person identifiers are available on the data sets, other information needs to be used to link events relating to inter-sector movement.

Methods

Event-based matching using limited demographic data in conjunction with event dates to match events in two data sets provides a possible method for linking related events. The authors develop a statistical model for examining the likely prevalence of false matches, and consequently the number of true matches, among achieved matches when using anonymous event-based record linkage to identify transition events.

Results

Theoretical analysis shows that for event-based matching the prevalence of false matches among achieved matches (a) declines as the events of interest become rarer, (b) declines as the number of matches increases, and (c) increases with the size of the population within which matching is taking place. The method also facilitates the examination of the trade-off between false matches and missed matches when relaxing or tightening linkage criteria.

Conclusion

Event-based record linkage is a method for linking related transition events using event dates and basic demographic variables (other than name or person identifier). The likely extent of false links among achieved links depends on the two event rates, the match rate and population size. Knowing these, it is possible to gauge whether, for a particular study, event-based linkage could provide a useful tool for examining movements. Analysis shows that there is a range of circumstances in which event-based record linkage could be applied to two event-level databases to generate a linked database useful for transition analysis.

Background

In Australia, hospital use increases with age, both in terms of numbers of visits and days in hospital, and it is roughly estimated that around 3% of hospital separations for older people (65+) involve transfers to residential aged care [13]. On the other hand, perhaps as many as 50% of residential aged care admissions come from hospital. In addition, many aged care residents have periods in hospital and about 5% of residential aged care periods end with the resident being discharged to hospital [4].

The interface between acute hospital care and residential aged care has long been recognised as an important issue in aged care services research in Australia [5, 6]. The policy significance of cross-sector movement was brought to the fore in 2001 with the establishment by the Australian Health Ministers' Advisory Council of the Care of Older Australians Working Group (COAWG) (reformed as the Health Care of Older Australians Standing Committee in 2005) 'in recognition of the need to improve the interface between acute hospital care, community care and residential aged care to ensure that older people receive the most appropriate care' [7]. Between 2002 and 2004 COAWG sponsored a research program which led to the release of a number of reports looking into different aspects of the interface [814].

Despite general recognition of the importance of the relationship between the sectors, existing national data provide very poor information on the movements of clients between the residential and acute care sectors. However, there are national data sets based on information collected primarily for administrative purposes which separately contain data on hospital episodes and residential aged care use, so that linking the two data sets–if feasible–would provide a valuable resource for examining relationships between the two sectors.

Record linkage is a powerful tool for combining information and extending the utility of data sets beyond their individual boundaries. It is a technique that has been successfully employed in a range of fields to exploit currently available data to address a range of issues [1520]. In addition, there is an emerging recognition that data linkage between existing data sets greatly facilitates investigations into many issues for which it is very difficult and/or expensive to obtain purpose-specific data [21, 22].

Two methods are typically used when trying to match people's information on one data set with their data on another: name-based matching (often probabilistic) or matching using a unique person identifier [2326], with data handling protocols being used to protect confidentiality and privacy [27, 28]. In the current case, the absence of both name and a common person identifier on both of the data sets precludes linking data using either of these approaches. However, a range of other data items is common to both data sets, and so the challenge is to determine whether there is sufficient information on the two data sets to allow reliable record linkage to generate a linked database on individuals who move from hospital to the residential care sector which could then be used for analysis of patterns of movements. Such anonymous record linkage, without access to name information–anonymised or otherwise–or a unique person identifier, has been used successfully before in a number of scenarios [2932]. These studies commonly include matching by date of birth and sex within region, in conjunction with study-specific non-name variables.

In 2001, the Australian Institute of Health and Welfare (AIHW) commenced work on a project aimed at exploring statistically the interface between residential aged care services and the acute hospital sector by linking currently available administrative by-product data. The Institute began by carrying out a feasibility study to trial a data linkage methodology based on event dates and available demographic variables [13]. Results from the feasibility study suggest that this statistical linkage methodology successfully generates a set of linked client records which could be used to examine the relationship between the hospital and residential aged care sectors.

The strategy investigated in the feasibility study linked related events by matching admissions into residential aged care and any hospital stays by permanent aged care residents with a hospital separation using data on birth date, sex, region of usual residence, and hospital separation/residential aged care admission or re-entry event dates. As with other record linkage strategies, the matching process aims to link records for the same person, rather than simply linking people who are similar in a range of demographic variables–as is done in statistical matching [33].

When linking records four outcomes are possible: a true link, no link (true negative), a false link (false positive) and a missed link (false negative). In the event-based strategy, false links can be caused by several individuals (either leaving hospital or entering residential aged care) having the same demographic data so that unrelated events are erroneously linked. In addition, inconsistencies in the matching data caused by either transcription or reporting discrepancies may cause false links to be made or lead to missing some links [3436].

Using statistical theory, this paper focuses on estimating the extent of false links, and therefore also of true links, among achieved matches due to the non-uniqueness of demographic data. Findings from this analysis are then used to establish under what circumstances an event-based strategy could be useful. When there are inconsistencies in the data used for matching, relaxing the match criteria can result in the identification of previously-missed links. Without comparing the results of a linkage strategy with those from a gold standard it is not possible to gauge the full extent of missed matches. However, by comparing the theoretically estimated numbers of false and true links among matches achieved using linkage criteria of varying degrees of strictness the trade-off between the two can be explored. Such information is very valuable in the common situation where there is no relevant gold standard. Thus, while the theoretical approach by itself cannot provide an estimate of the total number of missed matches for a particular strategy, it provides a practical tool for estimating the gains and losses in moving from one linkage strategy to another, and therefore can assist in developing a preferred linkage strategy. A simple example using the theoretically estimated false match rate to identify a preferred match strategy is given in the Discussion.

As emphasised by Roos and Wajda, 'knowing whether or not a linkage is likely to be feasible is important' [37]. If the number of false matches due to similar individuals having similar events is likely to make up a high proportion of achieved matches where accurate recording of data is assumed, then there is limited value in progressing further with the event-based method to resource-intensive studies which examine empirically the extent of all types of errors. If the proposed method is found to produce an acceptable level of data linkage on the basis of tests derived from statistical theory, then subsequent studies can be used to further determine if and for what purposes the proposed linkage strategy could be used (for example, examining patterns of service use for policy-related research versus clinical research).

It is important to note that linkage studies involving the use of administrative data should only be undertaken with appropriate recognition of ethical and privacy considerations, and with the approval of an ethics committee. If the linkage method outlined in this article is found to be practical for a particular study, then–as for any such linkage studies using data initially gathered for other purposes and so without participant consent for the proposed linkage–agreement and clearance would need to be obtained from a properly constituted ethics committee or ethics review board. In our own work, the authors of this paper also adhere to clearly stated data-handling linkage protocols that protect the privacy of individuals (see, for example, [27] and [28]).

Methods

In the context of the acute care-aged care interface, the purpose of the event-based linkage strategy is to match hospital separations to entries into residential aged care for people who are (a) admitted into residential aged care following a hospital episode, or (b) already permanent aged care residents. Intuitively, among people who usually live in a particular small region we would expect there to be few cases in which a person leaving hospital on a particular day has the same date of birth as someone else of the same sex from that region entering residential aged care on that day. That is, we would expect only a small number of false matches due to identical demographic characteristics. Whether or not such chance matches make up a sizeable proportion of all matches, and therefore affect the utility of the linked data, can be seen by comparing the number of chance (and therefore false) matches with the total number of achieved matches; that is, by estimating a false match rate per hospital separation date (termed the 'false match rate').

Assuming accurate recording of linkage data, the number of false matches among achieved matches can be estimated by considering the probability of a match between a hospital separation and a residential aged care entry purely by chance due to the distribution of birth dates. To make the estimation of the number of false matches tractable for the current application, two simplifying assumptions are made:

  • that birth dates are spread across a selected time interval (of length β days), and

  • that birth dates have a uniform distribution across the selected time interval.

The daily expected number of chance matches C due to coincident birth dates when comparing m hospital separations (for a particular day) with k candidate residential aged care admissions or returns is then estimated by:

C = Estimated number of chance matches

= (Probability of a single hospital separation having the same birth date as a candidate aged care admission or return) × (number of comparisons)

= 1/(Total number of possible birth dates)

× (Number of possibly matching residential aged care entries)

× (Number of hospital separations)

= (1/β) × k × m

For a particular match rate α for hospital separations, the corresponding false match rate F for a particular linkage strategy due to chance matches is estimated as

F = False match rate

= C/(Expected number of matches to m hospital separations)

= C/(α × m)

Prior to matching, neither the numbers of hospital and residential aged care events to be compared nor the number of achieved matches between these events are known. In the absence of such information, the expected numbers of chance matches can be estimated by assuming that hospital separations and entries into residential aged care are independent Poisson processes and then substituting in the relevant expected daily numbers of hospital separations and residential aged care entry events. Furthermore, different strategies for different types of events (for example, different strategies for linking to admissions into residential aged care and for linking to returns to residential care after hospitalisation) can be allowed for by using type-specific daily event rates and match rates for the different types of events.

A maximum for the false match rate F' can be estimated using an anticipated minimum match rate. Therefore, more generally we can estimate the maximum false match rate as

l ( λ Hl λ Rl / β ) / l t ( λ Hl α tl ) MathType@MTEF@5@5@+=feaafiart1ev1aaatCvAUfKttLearuWrP9MDH5MBPbIqV92AaeXatLxBI9gBaebbnrfifHhDYfgasaacH8akY=wiFfYdH8Gipec8Eeeu0xXdbba9frFj0=OqFfea0dXdd9vqai=hGuQ8kuc9pgc9s8qqaq=dirpe0xb9q8qiLsFr0=vr0=vr0dc8meaabaqaciaacaGaaeqabaqabeGadaaakeaadaWcgaqaaiabgsMiJoaaqafabaGaeiikaGIaeq4UdW2aaSbaaSqaaiabbIeaijabbYgaSbqabaGccqaH7oaBdaWgaaWcbaGaeeOuaiLaeeiBaWgabeaakiabc+caViabek7aIjabcMcaPaWcbaGaeeiBaWgabeqdcqGHris5aaGcbaWaaabuaeaadaaeqbqaaiabcIcaOiabeU7aSnaaBaaaleaacqqGibascqqGSbaBaeqaaOGaeqySde2aaSbaaSqaaiabbsha0jabbYgaSbqabaGccqGGPaqkaSqaaiabbsha0bqab0GaeyyeIuoaaSqaaiabbYgaSbqab0GaeyyeIuoaaaaaaa@50D9@
l ( λ Hl λ Rl / β ) / l λ Hl ( t α tl ) MathType@MTEF@5@5@+=feaafiart1ev1aaatCvAUfKttLearuWrP9MDH5MBPbIqV92AaeXatLxBI9gBaebbnrfifHhDYfgasaacH8akY=wiFfYdH8Gipec8Eeeu0xXdbba9frFj0=OqFfea0dXdd9vqai=hGuQ8kuc9pgc9s8qqaq=dirpe0xb9q8qiLsFr0=vr0=vr0dc8meaabaqaciaacaGaaeqabaqabeGadaaakeaadaWcgaqaaiabgsMiJoaaqafabaGaeiikaGIaeq4UdW2aaSbaaSqaaiabbIeaijabbYgaSbqabaGccqaH7oaBdaWgaaWcbaGaeeOuaiLaeeiBaWgabeaakiabc+caViabek7aIjabcMcaPaWcbaGaeeiBaWgabeqdcqGHris5aaGcbaWaaabuaeaacqaH7oaBdaWgaaWcbaGaeeisaGKaeeiBaWgabeaakiabcIcaOmaaqafabaGaeqySde2aaSbaaSqaaiabbsha0jabbYgaSbqabaGccqGGPaqkaSqaaiabbsha0bqab0GaeyyeIuoaaSqaaiabbYgaSbqab0GaeyyeIuoaaaaaaa@50D9@

where λHl is the expected daily number of hospital separations of type l (for example, of length l), λ Rl is the expected daily number of candidate residential aged care matches for a hospital episode of type l, and α tl is the minimum expected achieved match rate with residential aged care entries of type t for hospital episodes of type l. The formula could be further generalised by dividing the population into a number of age groups across the age range of interest. The value for F' for a particular linkage strategy can be then derived by substituting in event rates observed in the two separate databases (λHl calculated from the data on hospital episodes, and λRl calculated from the data on residential aged care events) and either anticipated match rates or match rates obtained in a feasibility study. Readers requiring detailed technical information on the methodology and statistical theory are referred to Karmel 2004 [38].

From the above, it can be seen that the false match rate depends both on the numbers of events involved in the match comparisons and on the achieved match rate. Consequently, the final achieved false match rate will vary with the strictness of the data matching requirements being used to identify linked events, both in terms of event dates and demographic data. Examples of different event date matching requirements include: insisting that events can only be considered for matching when the hospital separation date and the aged care entry date match exactly; allowing events a day or two apart to be considered as possible matches; and/or requiring matching on both the start and end dates of the hospital event when matching to returns from leave absences for people already in residential aged care. It may also be possible to either broaden or reduce the geographic region used for matching, or to allow differences in date of birth or sex. Allowing variation in the match data when identifying links changes both the expected numbers of events that could be considered for matching (that is, λHl and λRl) and the number of achieved matches (αtl). Consequently, the above equation can be used to compare a range of matching stratagems that could be applied in different event scenarios or for a range of population sizes.

In practice, when linkage data are recorded consistently on the two data sets being matched, as match criteria are relaxed the match rate increases because of the increase in the number of false matches. However, when there are inconsistencies in the data, relaxing the match strategy (for example, broadening the match region) can lead to identifying previously-missed links. By estimating the number of false matches (as above) in matched data sets derived using different strategies, the trade-off between false matches and matches missed due to inconsistent data can be examined.

Results

Using the maximum false match rate F' to gauge the utility of the event-based linkage, two aspects of the strategy are examined. First, results are presented for the particular case of linking Australian hospital and residential aged care data. The wider utility of an event-based data linkage methodology, when neither name nor person identifier are available, is then examined (see Discussion). In both cases, the integral role of the level of geography used in the linkage process is unambiguous.

Linking hospital and residential aged care data

Three types of entry events into residential aged care are considered as candidates for matching to hospital separations: new admissions into residential aged care, episodes of hospital leave (where the resident goes to hospital for a period) and episodes of social leave (where the resident goes to stay with family or friends for a period, during which time they could have an episode in hospital). In 2001–02 in Australia, there were around 900,000 hospital episodes for people aged 65 and over that involved at least one night in hospital and that did not end in either a transfer within the hospital system or death. In the same year there were 91,000 admissions into residential aged care (95% of which were for people aged 65 and over), 70,000 episodes of hospital leave and 54,000 episodes of social leave.

Using daily event rates derived from available hospital morbidity and residential aged care databases (for people aged 65 and over), in conjunction with match rates obtained in the initial feasibility study [13], estimates of the maximum false match rate for a number of event-based linkage strategies were derived. In addition, to gauge the effect of the assumption concerning distribution of birth dates, estimates were derived for two extreme birth date distributions. The results are presented in Table 1.

Table 1 Linking hospital and residential aged care events: estimated maximum false match rate for several event-based strategies

Table 1 shows the effects of both relaxing and further constraining a linkage strategy. For example, allowing hospital episodes to match to residential aged care admissions up to two days later increases considerably the number of candidates for matching and so leads to an increase in the estimated maximum false match rate (2.7% compared with 1.7% within a population of 10,000). On the other hand, constraining the strategy by insisting on exact period matching before accepting a match between a hospital episode and a residential aged care hospital leave event results in a reduction of the estimated maximum false match rate (1.2% compared with 1.7% within a population of 10,000). In addition, not allowing links to social leave events also reduces the false match rate as it excludes links that are more likely than others to be erroneous.

For most of the estimates presented in Table 1, birth dates are assumed to be spread across just 15 years. Because this is a much greater concentration of birth dates than actually happens for those aged over 65, this assumption leads to over-estimation of the number of chance matches and therefore the corresponding false match rate. To gauge the importance of the assumption concerning birth dates, the maximum false match rate was also derived assuming that ages are spread uniformly over 30 years results. This results in insufficient concentration of birthdates for the more common age groups, and so leads to an under-estimation of the maximum false match rate. For a population of 10,000, these two extreme birth date distributions give estimated maximum false match rates of 1.68% and 0.84%, respectively (using the base linkage strategy as described in Table 1). If the actual birth date distribution could be used, the maximum false match rate would be between these two estimates: using a more realistic distribution of birth dates results in an estimated false maximum match rate of 1.10% (based on uniform birth date distributions within six 5-year age groups). Therefore, using just a 15-year range for birth dates provides a conservative (high) estimate of the maximum false match rate, so that decisions based on such estimates would lead to cautious recommendations on the use of an event-base matching strategy rather than possibly inappropriate use of the approach.

Noting that the number of events available for matching is simply the product of the event rate and the population size, manipulation of the formula for the false match rate shows that there is a linear relationship between the size of the population within which matching is taking place and the estimated maximum false match rate. For example, in the simplest case where one type of hospital separation is being linked to one type of residential aged care entry, the estimated maximum false match rate can also be written as:

where r is the daily rate (per 1,000 people in the region within which matching is taking place) at which the candidate residential aged care entry event occurs and P is the size of the population in 1,000's (α and β as before). This relationship is evident in both in Figure 1 and Table 1. The utility of the event-based strategy therefore depends on both the event rates and the size of the population within which matching is being considered. If the available geographic information is such that matching can take place within sufficiently small regions so that the numbers of events being compared are small, then the false match rate can be minimised.

Figure 1
figure 1

The effect of population size on the estimated maximum false match rate.

Estimation assumes:

• 22 years of birth dates, uniform distribution (compromise distribution).

• single-date (exact end-date) matching only of separations to residential aged care admissions.

• exact period matching to residential aged care hospital leave.

Calculations use national average hospital separation rates (2000–01) and residential aged care admission and residential aged care leave rates (2001–02) [38]. Estimates take into account the distribution of hospital episodes by length of stay.

When linking Australian hospital morbidity data and residential aged care data the smallest region available for the matching process is postcode area. At the time of the Australian census in 2001, at least 98% of people aged 65 and over lived in postcodes with fewer than 5,000 older women and 5,000 older men. Figure 1 shows that for such small populations, the false match rate would be well under 1% for a range of event-based linkage strategies. If matching requirements are relaxed so that only the first three digits of a postcode are needed to establish a match, census data show that for the resulting larger regions, in 2001, 92% of older women and 98% of older men lived in regions with fewer than 15,000 older people of the same sex; all such regions had fewer than 30,000 people of the same sex. Consequently, using three digit postcode areas and constraining the matching strategy as in Figure 1, the false match rate would be below 1% for a large majority of regions, and under 1.5% for all regions. Such an approach allows matches to be made between records when there are only slight differences in reported postcode. Differences between postcodes for valid matches could be due to either data entry errors in the last digit or to people reporting different but physically close postcodes in the two data collections.

Discussion

The above results provide information on scenarios for which the event-based linkage strategy could be useful for a particular application–that is, for linking Australian hospital and residential aged care records. However, this theoretical approach can also be used to examine more generally the parameters within which such a linkage strategy could prove useful. In particular, it can allow investigations into the relationships between the false match rate, the rate at which events happen, the achieved (or anticipated) match rate, and the population size within matching is taking place. It can also be used to identify preferred matching strategies when data inconsistencies could lead to missed matches.

For transition systems, movements can be viewed either from the point of view of the source sector (hospital in the current application) or from the point of view of the receiving sector (residential aged care). Consequently, exit events and their match rates in the source sector are related to entry events and their match rates in the receiving sector. As a result, the false match rate can be expressed in two ways. For example, in the simplest case where one type of exit event (any hospital separation in the above analysis) is being linked to one type of entry event (any residential aged care entry), the maximum false match rate can be estimated as either

or alternatively as

F'= ρ × P/βa

where

r is the daily rate (per 1,000 people) at which the candidate entry event occurs

ρ is the daily rate (per 1,000 people) at which the candidate exit event occurs

α is the rate of exit events matching

a is the rate of entry events matching

P is the size of the population (in 1,000's), and

β is the total number of possible birth dates.

The impact on the false match rate of both event rates and match rates is illustrated in Figure 2 (in terms of the match rate for the exit events and the daily rate of the possibly-related entry events). From both the above equations and Figure 2 a number of points are clear:

Figure 2
figure 2

The estimated maximum false match rate given observed event and match rates: The estimated maximum false match rate among achieved matches as a function of the match rate among the initial exit events and the occurrence rate of the possibly-related entry events, for two population sizes.

  • the false match rate declines as the event rate diminishes, that is, as events become rarer;

  • the false match rate declines as the number of matches increases; and

  • the false match rate increases with population size (as seen before).

In the analysis of movement from hospital into residential aged care presented in Table 1, the daily event rates are 1.2 hospital separations per day per 1,000 people in the population and 0.2 residential aged care entries per day per 1,000 people, with an anticipated match rate of between 5% and 10% for hospital separations which corresponds to a match rate of between 21% and 43% of all residential aged care entry events. These rates place this scenario just above the lowest line (entry event rate of 0.1 per 1,000) on Figure 2. The graphs show clearly that by using some basic information about the transitions, it is possible to measure the likely extent of false matches among achieved matches, and thereby to gauge whether event-based linkage could provide a useful tool for examining movement.

If linkage data are highly accurate, the achieved match rate is affected primarily by the number of false matches, with the number of identified true matches remaining largely unaffected by changes in the linkage strategy. However, in practice true links are either missed or identified depending on the quality of the linkage data. Consequently, the number of achieved matches varies with the precision of the match strategy due to changing numbers of both false and missed matches. For example, a person's four digit postcode may differ in the last digit on the two data sets so that using complete postcode to match would lead to missing the match while using up to the first three digits would allow the match to be identified. On the other hand, using the region defined by the first three digits of postcode would lead to more false matches than using the smaller four digit postcode area. Such differences in match rates are readily observed when developing a linkage strategy (for example, see [13] p15). When two data sets have been linked using a number of strategies that allow different degrees of latitude in the match variables, the estimated false match rate (derived as above) and corresponding true match rate (or positive predictive value) can be used to gauge whether relaxing linkage requirements results in identifying enough previously-missed links to outweigh the additional false links.

Figure 3 illustrates the use of the estimated false match rate for examining the trade-off between false and true links in three linkage strategies. In this example, the match rate of entry events increases from 11% when using relatively small match regions (5,000 people) to 28% when using medium-sized match regions (70,000 people). It then rises up to 37% when using large match regions (500,000 people). These figures are similar to those observed in the initial feasibility study for the event-based matching method when matching hospital separations for women aged 65 and over to residential aged care admissions within the person's postcode of usual residence, Statistical Local Area of usual residence and State of usual residence, respectively [13]. In this example, using the small match region results in very few false links–estimated at just 0.7%. However, comparison with the matches obtained based on the larger regions shows that, while very accurate, using the small regions results in missing a large number of matches. By increasing the match region to 70,000 it is estimated that among the new matches true matches outnumber false matches by 16 to one, with the number of true matches more than doubling while the false match rate remains below 5%. On the other hand, changing from medium to large match regions (500,000) adds more than twice as many false matches as true matches (an estimated 1,285 versus 515) resulting in a false match rate of 20% among the achieved matches.

Figure 3
figure 3

Example examining the relationship between false links and true links for different linkage strategies. Figure 3 shows the estimated number of false matches and true matches among achieved matches for links of exit events happening at a rate of 1.2 per day (per 1,000 people) to 20,000 entry events occurring over a year, and demonstrates the change in the entry event match rate as the size of the match region is varied.

In this example, using the theoretical analysis to estimate the number of false matches, the researcher could see that the increase in matches observed when going from the small to medium-sized match regions was driven by the identification of previously-missed matches, while the substantial increase in matches observed when going from the medium to large match regions was largely the result of false matches. Depending on the accuracy requirements of the study, the researcher could then decide either to use the linkage strategy based on the medium-sized match region, or to test other region sizes for matching. This example illustrates the value in knowing whether increases in match rates are likely to be the result of false matches or the identification of missed matches.

Conclusion

From a policy perspective, knowledge of the relationship between hospital and residential aged care is vital for the optimal care of older people. While, in Australia, considerable data are available on both sectors separately, the problem is to determine whether the two corresponding data sets can be reliably linked–thereby generating a linked database which could be used for analysis of patterns of movements–even though neither name nor a common person identifier are available on both data sets. Analysis of the event-based linkage strategy presented in this paper demonstrates that such linkage is possible: estimates indicate that the linkage strategy results in an acceptably low prevalence of false matches, and so can be used to derive a data set useful for investigating the hospital-residential aged care interface.

A key factor determining whether or not the strategy could be used is the number of candidate matches being considered for an exit event: if this is too high the probability of chance matches becomes too great and the false match rate increases accordingly. A further consideration is the likelihood of missing links due to variations in reporting data items. For event-based strategies the number of candidate matches is driven by both the rate at which events occur and the size of the population within which matches are to be made. By appropriate choice of the population groups used for linkage and/or the strictness of the matching stratagem, the number of chance matches can be kept to an acceptably low level without increasing unduly the number of missed links so that the linked data set could be useful for many types of analyses.

There is an increasing policy emphasis on looking at service provision from a whole-of-person viewpoint, with a longitudinal perspective being preferred. Therefore, the ability to examine transitions between services becomes key for policy-relevant research. As a consequence, capacity to link program-specific data sets takes on added significance. Analysis in this paper shows that in a wide range of situations linkage of transition events across data sets is possible even if name or person identifiers are not available.

Whether the linked data set derived using the event-based strategy is sufficiently complete to allow examination of flows as well as patterns of movements depends largely on the quality and compatibility of the linkage variables. This paper has outlined a theoretical approach that allows the estimation of the false match rate in a proposed linkage strategy and as a consequence examination, to some extent, of the trade-off between false and missed matches–an issue faced by many linkage strategies. The methods in this paper provide researchers with tools that can help them firstly to decide whether event-based linkage could be useful, and secondly to identify preferred match criteria once matching between two specific data sets is being undertaken. The overall relationship between false and missed links in the context of movements of linking hospital to residential aged care data will be explored in a subsequent study that compares the event-based linkage strategy with a full name-based linkage.

Abbreviations

AIHW:

Australian Institute of Health and Welfare

COAWG:

Care of Older Australians Working Group

HCOASC:

Health Care of Older Australians Standing Committee.

References

  1. Gibson D: The interface between hospital and residential aged care. Australian Health Review. 2002, 25: 132-135.

    Article  PubMed  Google Scholar 

  2. AIHW: Australian hospital statistics 2001-02. 2003, Canberra, AIHW, [http://www.aihw.gov.au/publications/index.cfm/title/8881]

    Google Scholar 

  3. AIHW: Australian hospital statistics 2004-05. 2006, Canberra, AIHW, [http://www.aihw.gov.au/publications/index.cfm/title/10305]

    Google Scholar 

  4. AIHW: Residential aged care in Australia 2004-05: a statistical overview. 2006, Canberra, AIHW, [http://www.aihw.gov.au/publications/index.cfm/title/10303]

    Google Scholar 

  5. Duckett SJ: Aged care symposium: overview. Australian Health Review. 2002, 25: 130-131.

    CAS  PubMed  Google Scholar 

  6. Renwick M, Gillett S, Liu Z: Long stay older patients in acute hospitals: are they bed blockers. Aust Health Rev. 1992, 15 (3): 284-298.

    CAS  PubMed  Google Scholar 

  7. Department of Health and Ageing: Health Care of Older Australians Standing Committee (HCOASC). 2006, Canberra, DoHA, [http://www.health.gov.au/internet/wcms/publishing.nsf/content/health-hco%20asc.htm#research]

    Google Scholar 

  8. Howe AL, Rosewarne R, Opie J: Mapping of services at the interfaces of acute and aged care. 2002, Canberra, COAWG, [http://www.health.gov.au/internet/wcms/publishing.nsf/Content/health-minconf.htm/FILE/1a_execsum.pdf]

    Google Scholar 

  9. Gray L, Dorevitch M, Smith R, Black K, Ibrahim J, Virgona M: Service provision for older people in the acute - aged care system. 2002, Canberra, COAWG, [http://www.health.gov.au/internet/wcms/publishing.nsf/Content/health-minconf.htm/FILE/1bfinalreport.pdf]

    Google Scholar 

  10. ACEMA (Aged Care Evaluation and Management Advisors): Examination of length of stay for older persons in acute and sub-acute sectors. 2002, Canberra, COAWG, [http://www.health.gov.au/internet/wcms/publishing.nsf/Content/health-min%20conf.htm/$FILE/pr2report.pdf]

    Google Scholar 

  11. Grimmer K, May E, Arbon P, Wilkinson D, Dawson A, Peoples C, Clifford J, Kindness H, Barras S, Martin T: Review of assessment & transition practices in public hospitals project 2002. 2003, Canberra, COAWG, [http://www.health.gov.au/internet/wcms/publishing.nsf/Content/665F2ED12A7D4331CA2572B3000C4483/$File/Assessment%20and%20Transition%20Practices%20Cover.pdf]

    Google Scholar 

  12. Siggins Miller: Unnecessary and avoidable hospital admissions for older people: A report to the Department of Health and Ageing. 2003, Canberra, COAWG, [http://www.health.gov.au/internet/wcms/publishing.nsf/Content/665F2ED12A7D4331CA2572B3000C4483/$File/Avoidable%20Admissions%20Report%20Final.pdf]

    Google Scholar 

  13. AIHW: Interface between hospital and residential aged care: feasibility study on linking hospital morbidity and residential aged care data. 2003, Canberra, AIHW, [http://www.aihw.gov.au/publications/index.cfm/title/9246]

    Google Scholar 

  14. Clinical Epidemiology and Health Services Evaluation Unit Melbourne Health: Best practice approaches to minimise functional decline in the older person across the acute, sub-acute and residential aged care settings. 2004, Melbourne, Victorian Government Department of Human Services

    Google Scholar 

  15. Roos NP, Black C, Roos LL, Frohlich N, DeCoster C, Mustard C, Brownell MD, Shanahan M, Fergusson P, Toll F, Carriere KC, Burchill C, fransoo R, MacWilliam L, Bogdanovic B, Friesen D: Managing health services: how the Population Health Information System (POPULIS) works for policymakers. Medical Care. 1999, 37: JS27-41. 10.1097/00005650-199906001-00007.

    Article  CAS  PubMed  Google Scholar 

  16. Goldacre MJ, Wotton CJ, Seagroatt V, Yeates D: Cancer following hip and knee arthroplasty: record linkage study. British Journal of Cancer. 2005, 92: 1298-1301. 10.1038/sj.bjc.6602511.

    Article  CAS  PubMed  PubMed Central  Google Scholar 

  17. Mitchell L, Roos NP, Shapiro E: Patterns in home care use in Manitoba. Can J Aging. 2005, 24 (Suppl 1): 59-68.

    Article  PubMed  Google Scholar 

  18. Brook EL, Rosman DL, Holman CDJ, Trutwein B: Summary report: research outputs project, WA Data Linkage Unit (1995-2003). 2005, Perth, Department of Health Western Australia

    Google Scholar 

  19. Williams TA, Dobb GJ, Finn JC, Knuiman M, Lee KY, Geelhoed E, Webb SA: Data linkage enables evaluation of long-term survival after intensive care. Anaesth Intensive Care. 2006, 34 (3): 307-315.

    Article  CAS  PubMed  Google Scholar 

  20. Hall SE, Holman CDJ, Finn J, Semmens JB: Improving the evidence base for promoting quality and equity of surgical care using population-based linkage of administrative health records. International Journal for Quality in Health Care. 2005, 17: 415-420. 10.1093/intqhc/mzi052.

    Article  PubMed  Google Scholar 

  21. Goldacre M, Kurina L, Yeates D, Seagroatt V, Gill L: Use of large medical databases to study associations between diseases. QJM. 2000, 93 (10): 669-675. 10.1093/qjmed/93.10.669.

    Article  CAS  PubMed  Google Scholar 

  22. National Community Services Information Management Group: Statistical data linkage in community services data collections: a report prepared by the Statistical Linkage Key Working Group. 2004, Canberra, AIHW

    Google Scholar 

  23. Chamberlayne R, Green B, Barer ML, Hertzman C, Lawrence WJ, Sheps SB: Creating a population-based linked health database: a new resource for health services research. Can J Public Health. 1998, 89 (4): 270-273.

    Article  CAS  PubMed  PubMed Central  Google Scholar 

  24. Gill LE: OX-LINK: The Oxford Medical Record Linkage System. Proceedings of an International Workshop and Exposition on Record Linkage Techniques: 1997; Arlington Virginia. Edited by: National Research Council. 1997, , National Academy Press, 15-33. [http://books.nap.edu/openbook.php?record_id=6491&page=13]

    Google Scholar 

  25. Zigmond DS, Ye Z, Ettner SL, Li H: Linking hospital discharge and death records-accuracy and sources of bias. Journal of Clinical Epidemiology. 2004, 57: 21-29. 10.1016/S0895-4356(03)00250-6.

    Article  Google Scholar 

  26. Delgado CEF, Scott KG: Comparison of referral rates for preschool children at risk for disabilities using information obtained from birth certificate records. The Journal of Special Education. 2006, 40: 28-38. 10.1177/00224669060400010301. [http://proquest.umi.com/pqdweb?did=1034213791&sid=1&Fmt=4&clientId=56202&RQT=309&VName=PQD]

    Article  Google Scholar 

  27. Kelman CW, Bass AJ, Holman CDJ: Research use of linked health data-a best practice protocol. Aust N Z J Public Health. 2002, 26 (3): 251-255. 10.1111/j.1467-842X.2002.tb00682.x.

    Article  CAS  PubMed  Google Scholar 

  28. AIHW: Data linkage and protecting privacy: a protocol for linking between two or more data sets held within the Australian Institute of Health and Welfare. 2006, Canberra, AIHW, [http://www.aihw.gov.au/dataonline/aihw_privacy_protection_protocols_data_linkage.pdf]

    Google Scholar 

  29. Bernillon P, Lievre L, Pillonel J, Laporte A, Costagliola D, The Clinical Epidemiology Group from Centres d’Information et de Soins de l’Immunodéficience Humaine (CISIH): Record-linkage between two anonymous databases for a capture-recapture estimation of underreporting of AIDS cases: France 1990–1993. International Journal of Epidemiology. 2000, 29: 168-174. 10.1093/ije/29.1.168.

    Article  CAS  PubMed  Google Scholar 

  30. Woods K, Karrison T, Koshy M, Patel A, et al: Hospital utilization patterns and costs for adult sickle cell patients in Illinois. Public Health Rep. 1997, 112 (1): 44-51.

    CAS  PubMed  PubMed Central  Google Scholar 

  31. Blakely T, Woodward A, Salmond C: Anonymous linkage of New Zealand mortality and Census data. Australian and New Zealand Journal of Public Health. 2000, 24: 92-95. 10.1111/j.1467-842X.2000.tb00732.x.

    Article  CAS  PubMed  Google Scholar 

  32. Newgard CD: Validation of probabilistic linkage to match de-identified ambulance records to a state trauma registry. Academic Emergency Medicine. 2005, 13: 69-75. 10.1197/j.aem.2005.07.029.

    Article  PubMed  Google Scholar 

  33. Moriarity CL, Scheuren F: Statistical matching: pitfalls of current procedures. Proceedings of the Annual Meeting of the American Statistical Association: August 5-9, 2001; Atlanta Georgia. 2001, , American Statistical Association, [http://www.amstat.org/meetings/jsm/2001/index.cfm?fuseaction=abstract_de%20tails&abstractid=300591]

    Google Scholar 

  34. Muse AG, Mikl J, Smith PF: Evaluating the quality of anonymous record linkage using deterministic procedures with the New York State AIDS Registry and a hospital discharge file. Statistics in Medicine. 1995, 14: 499-509. 10.1002/sim.4780140511.

    Article  CAS  PubMed  Google Scholar 

  35. Health Results Team for Information Management: Reabstraction study of the Ontario case costing facilities for fiscal years 2002/2003 and 2003/2004. 2005, Ontario, Canadian Institute for Health Information, [http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=GR_1107_E]

    Google Scholar 

  36. Li B, Quan H, Fong A, Lu M: Assessing record linkage between health care and vital statistics databases using deterministic methods. BMC Health Services Research. 2006, 6: 48-10.1186/1472-6963-6-48.

    Article  PubMed  PubMed Central  Google Scholar 

  37. Roos LL, Wajda A: Record linkage strategies. Part I: Estimating information and evaluating approaches. Methods of Information in Medicine. 1991, 30: 117-123.

    Article  CAS  PubMed  Google Scholar 

  38. Karmel R: Linking hospital morbidity and residential aged care data: examining matching due to chance. 2004, Canberra, AIHW, [http://www.aihw.gov.au/publications/index.cfm/title/10065]

    Google Scholar 

Pre-publication history

Download references

Acknowledgements

The authors acknowledge the valuable comments made by Dr Terry Neeman and Greg Griffiths concerning the statistical processes underlying the matching strategy being investigated. Evon Bowler undertook data analysis in the early stages of this project and Dr Peter Braun provided data extracts on residential aged care.

Residential aged care data were provided by the Australian Department of Health and Ageing and hospital data by the Australian state and territory governments.

This study was funded by the Australian Institute of Health and Welfare.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Rosemary Karmel.

Additional information

Competing interests

The author(s) declare that they have no competing interests.

Authors' contributions

RK investigated and developed the event-based matching method. DG designed and developed the event-based matching method to link related events for individuals without requiring name or a person identifier, and gave final approval for the article as published.

Rosemary Karmel and Diane Gibson contributed equally to this work.

Authors’ original submitted files for images

Below are the links to the authors’ original submitted files for images.

Authors’ original file for figure 1

Authors’ original file for figure 2

Authors’ original file for figure 3

Rights and permissions

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.

Reprints and permissions

About this article

Cite this article

Karmel, R., Gibson, D. Event-based record linkage in health and aged care services data: a methodological innovation. BMC Health Serv Res 7, 154 (2007). https://doi.org/10.1186/1472-6963-7-154

Download citation

  • Received:

  • Accepted:

  • Published:

  • DOI: https://doi.org/10.1186/1472-6963-7-154

Keywords