Tutorials › Propensity Score Matching and Instrumental Variables › Describing Data Sources and Record Linkage

Reporting Observational Comparative Studies · Tutorial 650 of 699

Describing Data Sources and Record Linkage

Learn to describe where observational data came from, how records were linked, and what evidence supports the accuracy and coverage of the resulting data.

Intermediate 12 min read

What You'll Learn

  • Distinguish a database’s name, custodian, provenance, and intended collection purpose.
  • Describe source coverage, calendar periods, and important limits on who or what is represented.
  • Report coding systems and how codes or algorithms were selected and applied.
  • Explain linkage methods, identifiers, thresholds, and handling of uncertain links.
  • Calculate and interpret linkage rates and validation measures with their denominators.
  • Use RECORD guidance to report routine-data sources without implying that linkage guarantees validity.

Why Data Provenance Matters

A comparative analysis can be calculated correctly and still be difficult to assess if readers cannot tell where its records came from or how those records were assembled. A source name alone is not enough: a hospital record system, insurance claims database, and disease registry may cover different people, periods, and events, even when they contain similarly named variables. When information from multiple sources is linked, readers also need to know how the linkage was performed and what evidence supports its accuracy.

For routinely collected health data, the RECORD guidance extends STROBE reporting recommendations with attention to data sources, access, coding, linkage, and validation. The aim is not to provide an inventory of every technical detail. It is to report enough for a reader to understand the data’s origins and limitations, judge the relevance of the sources to the study question, and assess whether the linkage process could have introduced error.

Definition: Data provenance describes where data originated, who collected or maintained them, why and how they were collected, and the transformations or transfers that produced the version used in an analysis. Record linkage is the process of determining which records in one or more data sources refer to the same person, organization, or other entity.

Describe Each Source, Not Just Its Name

For each source, report its name and the organization responsible for maintaining it, where that information can be shared. Identify the type of source—for example, administrative claims, an electronic health record system, a laboratory information system, or a registry—and explain its primary collection purpose. A source designed for billing, care delivery, or surveillance may record the same clinical event differently because it was created for a different operational purpose.

Describe the source’s relevant coverage: the geography, participating facilities or organizations, population or service setting represented, and calendar period covered. Distinguish the database’s overall coverage from the records available to the analysis. Report material gaps, such as nonparticipating facilities, changes in participation over time, or populations whose care may occur outside the source. These are descriptions of what the source can capture, not conclusions about who qualifies for the analysis.

Explain the provenance of the analysis data as well as the original source. State how the data were obtained or accessed, such as through a data custodian or a secure research environment, and describe major processing steps relevant to interpreting the records. If a source is updated, say which version or extraction period was used when available. Report the source’s collection purpose even if it seems obvious: a claims database’s records, for example, are generated in a reimbursement context, not necessarily to create a complete clinical history.

Worked Example: Describing Two Routine Data Sources

Suppose a hypothetical study uses outpatient records from a regional health network and a national pharmacy claims database. The network contains records from 12 participating clinics from 2016 through 2022. The claims database covers reimbursed prescriptions for members of participating insurance plans during the same period. The two sources are linked using encrypted person identifiers.

A useful description would name both sources and their custodians, state the clinic and insurance-plan coverage, and give the calendar period used. It would explain that the network records were created for clinical care and that the claims records were generated through reimbursement. It would also state that the claims source does not necessarily capture prescriptions paid for outside participating plans, while the network does not necessarily capture care received outside its clinics.

The description should not say that either source represents all regional patients or all medication use: the stated coverage does not support those claims. Nor should it imply that an encrypted identifier guarantees a correct match. The sources and their limitations are reported here; decisions about which individuals enter an analytic cohort are a separate matter.

Coding Systems and Operational Definitions

Routine data often represent diagnoses, procedures, medications, or other events using codes. Report the coding system and version where relevant, the time period for which it applied, and how the codes were selected. If an analysis uses a published code list, cite or otherwise identify it. If investigators created or modified a list, describe the process and provide the list or an accessible supplement when permitted. Explain whether codes were used to identify a recorded event, a service, or a classification; the presence of a code does not automatically establish that a clinical condition was confirmed.

When a definition depends on an algorithm rather than a single code, describe the parts that affect interpretation—for example, whether one or multiple records were required, whether code position mattered, and how the algorithm treated conflicting records. Do not substitute a broad statement such as “standard diagnostic codes were used” for the system, version, and operational choices a reader would need to understand the definition. This reporting is about how source data were represented and interpreted, not a substitute for describing the study’s later analytical decisions.

Worked Example: Reporting a Coded Event Definition

Imagine a hypothetical analysis that identifies a recorded diagnosis using a specified set of diagnosis codes in a hospital discharge database. The codes follow a named national modification of an international classification, version 10, as implemented during the database’s 2018–2021 reporting period. The definition requires at least one qualifying code in any diagnosis position.

A transparent report names the classification and version, gives the codes or a reproducible reference to the complete list, states the database and relevant period, and says that any diagnosis position qualifies. It should not describe the result as a clinically confirmed diagnosis unless that claim is supported by an appropriate validation process. A reader can then distinguish the operational definition—records meeting the code rule—from the underlying clinical state the study aims to represent.

If the source changed coding systems during the period, the report should explain which versions applied and how the code lists were mapped or otherwise handled. Without that detail, an apparent change in recorded diagnoses could reflect a coding transition rather than a change in the underlying frequency of disease.

Explain How Records Were Linked

For linked data, describe which sources were linked, the unit being matched, the identifiers or identifier classes used, and whether linkage was deterministic, probabilistic, or a combination. Deterministic linkage applies specified rules to identifiers, such as exact agreement on a unique identifier. Probabilistic linkage combines evidence across identifiers that may be incomplete or inconsistent, assigning scores or probabilities to candidate pairs and applying a decision rule. State the main rules or decision thresholds and how ambiguous or conflicting candidates were handled.

Report who performed the linkage and where, to the extent possible without compromising privacy or security. Explain whether identifiers were encrypted, transformed, or handled by a trusted third party, and what information was returned to the analysts. Privacy-preserving linkage can reduce exposure of direct identifiers, but it does not by itself establish that the links are accurate. Also state the denominator used for any linkage rate: for example, the number of records submitted for linkage, rather than an unspecified “study population.”

Worked Example: Calculating and Interpreting a Linkage Rate

A hypothetical project submits 10,000 records from a clinic database for linkage to a claims source. The linkage procedure returns a unique accepted match for 9,200 records; 800 receive no accepted match. Define the linkage rate as the number of submitted records with an accepted match divided by the number submitted.

$$ \text{Linkage rate}=\frac{9{,}200}{10{,}000}=0.92=92.0\%. $$

Thus, 92.0% of the submitted clinic records received an accepted match under the stated procedure, and 8.0% did not. This rate describes the procedure’s yield for this denominator. It does not show that 92.0% of accepted links are correct, nor that the unmatched records are otherwise similar to the matched records. Assessing correctness requires validation evidence; assessing differences between linked and unlinked records requires information about those records.

Validation Evidence: What Was Checked?

Validation asks whether source definitions or linkage decisions correspond adequately to a more credible reference for the intended purpose. Report what was checked, how the reference was established, who performed the review if relevant, and the results with clear denominators. For linkage, reference labels might come from manual review of records using information unavailable to the linkage algorithm. For coded definitions, the reference might be a clinical review or another appropriate source. A validation result applies to the definition and population that were checked; it is not automatically evidence of accuracy in every setting or period.

For binary linkage decisions, a validation sample with a reference classification can be summarized using four counts: true matches accepted by the procedure, nonmatches accepted, true matches rejected, and nonmatches rejected. Sensitivity is the proportion of reference true matches accepted; positive predictive value is the proportion of accepted links that are true matches. Specificity is the proportion of reference nonmatches rejected. These measures answer different questions, so “linkage accuracy” without a measure and denominator is ambiguous.

Worked Example: Interpreting a Linkage Validation Sample

In a hypothetical validation exercise, reviewers compare 200 candidate pair decisions with a reference classification. They identify 100 true matches and 100 true nonmatches. The procedure accepts 90 of the true matches and incorrectly accepts 10 nonmatches; it rejects the other 10 true matches and 90 true nonmatches.

Reference classificationAccepted as a matchRejected as a matchTotal
True match9010100
True nonmatch1090100
Total100100200

Sensitivity is \(90/100=90.0\%\): among reference true matches in this validation sample, 90.0% were accepted. Positive predictive value is \(90/100=90.0\%\): among accepted links in this sample, 90.0% were true matches. Specificity is \(90/100=90.0\%\): among reference nonmatches, 90.0% were rejected. Each interpretation names its denominator.

If the validation sample deliberately included equal numbers of true matches and nonmatches, as in this example, its positive predictive value may not represent the value in a linkage setting where true matches are much less common. The report should explain how the sample was selected and avoid treating a validation result as universally applicable.

A Practical Reporting Sequence

A compact, reproducible account can be built by working through the following sequence. The sequence separates the origin and properties of each source from the linkage and the evidence used to assess it.

1
Name and identify each source.
Give the source name, custodian or responsible organization, source type, access route when relevant, and the version or extraction period used.
2
Describe purpose and coverage.
State why the data were originally collected, the relevant organizations, geography and period covered, and known gaps that affect interpretation.
3
Make coding choices understandable.
Name applicable coding systems and versions; identify code lists, algorithms, and material rules used to represent events.
4
Document the linkage procedure.
Identify the sources and unit linked, method, identifiers or identifier classes, decision rules, treatment of uncertain links, and the denominator for reported rates.
5
Report validation and limitations.
Describe the reference or review process, sample, measures, and results. State what the evidence does and does not establish.

Diagnostics, Alternatives, and Limitations

Several warning signs indicate that a source or linkage description is too thin: a source is identified only by a familiar acronym; coverage is described as “national” without saying which people or organizations contribute; codes are called “standard” without a system or version; or a linkage rate is reported without its denominator. Another warning sign is reporting only a high linkage rate as evidence of correct linkage. A procedure can link many records and still accept false matches, or achieve a low false-match rate while missing many true matches.

The appropriate linkage approach depends on the identifiers available and the risks of errors. Exact deterministic linkage may be straightforward when a reliable unique identifier is shared, but exact agreement rules can miss genuine matches when identifiers are missing or inconsistent. Probabilistic linkage can use partial agreement across fields, but depends on specified scoring and decision rules and may leave uncertain pairs unresolved. A hybrid may apply deterministic rules to clear cases and probabilistic rules to the remainder. These are alternatives in method, not guarantees of quality: report the method actually used and evidence relevant to its performance.

Single-source analyses avoid cross-source matching errors, but a single database can still have incomplete coverage, measurement limitations, or coding errors. Linked data can add information and broaden observed histories, but can also introduce false matches, missed matches, and selection into the linked subset. RECORD-style reporting makes these issues visible; it cannot repair them. Validation may be infeasible, unavailable, or limited to a small sample, and results may not transport across populations, time periods, or coding changes. State those limits rather than implying certainty.

A useful justification for reporting both linkage yield and validation evidence follows directly from their definitions. The linkage rate uses all records submitted as its denominator, whereas positive predictive value uses only accepted links. Since these denominators differ, a high value for the first ratio does not mathematically determine the second. The two quantities answer separate questions—how often the procedure returns a link, and how often its accepted links are correct—and should not be used interchangeably.

Key takeaway: A source description should let readers trace data to their origins and understand the population and events they can represent. A linkage description should make the method, denominator, and validation evidence explicit. Neither source names nor linkage rates alone establish data validity.

Check Your Understanding

Answer each question, then compare your reasoning with the solutions.

  1. A report names a hospital database but gives no information about which hospitals contribute or why records are collected. What important provenance details are missing?
  2. A project submits 4,000 records for linkage and accepts 3,600 matches. Calculate the linkage rate and state precisely what it means.
  3. Why does a linkage rate not establish the positive predictive value of accepted links?
  4. A validation sample has 80 reference true matches, of which the procedure accepts 72. Calculate sensitivity and interpret it.
  5. What should a report give when an event is identified using a code list or algorithm?

Solutions. (1) It should identify the contributing facilities and relevant period or geographic coverage, name the custodian if available, and explain the database’s collection purpose. (2) \(3{,}600/4{,}000=0.900=90.0\%\); 90.0% of submitted records received an accepted match under that procedure. It does not describe correctness. (3) The linkage rate’s denominator is all records submitted, whereas positive predictive value’s denominator is accepted links; the former does not reveal how many accepted links are false. (4) Sensitivity is \(72/80=0.900=90.0\%\); 90.0% of reference true matches in that validation sample were accepted. (5) Name the coding system and version, identify the codes or provide a reproducible code list, and describe material algorithm rules and the relevant source period.

Clinical Biostats