Back to Articles|Published on October 28, 2026|15 min read

Reliable Context Article

Data Provenance vs Data Lineage vs Audit Trail

Lineage, provenance and audit trails answer three different questions about the same value. Definitions, a worked example, and which rules ask for which.

By Reliable Context Research

Data Provenance vs Data Lineage vs Audit Trail

Summary

  1. 01Data lineage tracks movement and transformation between datasets. Data provenance documents the origin, derivation and responsibility for a specific value. An audit trail records who created, changed or deleted a record, and when.
  2. 02A lineage graph helps locate upstream problems and affected downstream datasets, but does not establish which source document supports a particular value.
  3. 03Provenance supplies the source and supporting passage needed to check a value. An audit trail establishes the history of actions, but does not prove that a new value is correct.
  4. 04A usable chain of custody links provenance, audit entries and downstream lineage with stable identifiers. Each changed value needs its own provenance record so earlier evidence remains available.
  5. 05Life sciences rules pull hardest on audit trails, banking supervision on lineage and reconciliation, and AI regulation on data origin. Organizations subject to more than one need the records connected.
Inside this article
  1. 01The same value, three questions
  2. 02The worked example
  3. 03Data lineage: datasets, jobs and runs
  4. 04Data provenance: source, derivation and responsibility
  5. 05Audit trail: who changed what, and when
  6. 06Where each fails alone
  7. 07Combining them into one chain of custody
  8. 08Regulatory pull: which rule asks for which
  9. 09Comparison table
  10. 10Summary
  11. 11Sources

The same value, three questions

Pick any value a regulated organization acts on: a supplier's certificate expiry date, a counterparty's legal name, a batch's assay result. Three different questions can be asked about it, and they are often confused:

  1. Which datasets and jobs produced the table this value sits in? That is data lineage.
  2. Where did this particular value come from, how was it derived, and who is responsible for it? That is data provenance.
  3. Who created, changed or deleted this record, and when? That is an audit trail.

Each question has its own standards, its own tools and its own regulatory sources. A data catalog that draws lineage graphs does not answer the second question. An audit trail does not answer the first. Provenance records rarely answer the third. The terms overlap at the edges, but treating them as synonyms leads to controls that look complete on a diagram and fail in an inspection.

This article defines each term against a published standard or regulation, follows one fictional value through all three, and sets out where each fails when used alone.

90 daysCertificate expiry warning window in the fictional quality dashboard
2027-05-31Certificate expiry date stored for the fictional supplier Velmar Chemie GmbH

The worked example

Halden Therapeutics AG (a fictional company) keeps a supplier master table. One row describes Velmar Chemie GmbH (also fictional), an approved supplier of an active ingredient. The field of interest is:

TableSupplierFieldValue
supplier_masterVelmar Chemie GmbHgmp_certificate_expiry2027-05-31

A quality dashboard flags suppliers whose certificate expires within 90 days. On 28 October 2026 it shows Velmar as compliant. An inspector asks how Halden knows the date is right. The three disciplines give three different answers.

Data lineage: datasets, jobs and runs

Data lineage is the record of how data moves and is transformed between datasets. NIST's glossary, quoting its Privacy Framework, defines lineage as "the history of processing of a data element, which may include point-to-point data flows and the data actions performed upon the data element" [1]. In practice, enterprise lineage tools work at the level of tables, files and jobs, sometimes columns.

OpenLineage, an open specification for collecting lineage metadata, is a clear example of the model. Its object model has three core entities [2]:

  • A Job is "a process that consumes or produces Datasets."
  • A Run is "an instance of a Job that represents one of its occurrences in time", identified by a runId.
  • A Dataset is "an abstract representation of data", identified by a name within a namespace "derived from its physical location (i.e., db.host.database.schema.table)."

These can be extended with facets, defined as "an atomic piece of metadata identified by its name", attached to runs, jobs or datasets [3].

For Halden, the lineage record says:

ElementValue
Jobbuild_supplier_master
RunrunId 7f3e..., 2026-10-28 02:00 to 02:04 UTC, state COMPLETE
Input datasetserp.vendors, qa.certificates
Output datasetwarehouse.supplier_master

This is useful. It tells an engineer that if qa.certificates was wrong, supplier_master is wrong too, and which run to re-execute. It does not say where the date 2027-05-31 came from before it entered qa.certificates, which document supports it, or who typed it in. Lineage describes the plumbing, not the evidence.

Data provenance: source, derivation and responsibility

Data provenance is the documented origin and history of a specific piece of data, including who was responsible for it. The W3C PROV Data Model, a W3C Recommendation of 30 April 2013, defines provenance as "a record that describes the people, institutions, entities, and activities involved in producing, influencing, or delivering a piece of data or a thing" [4]. NIST's glossary gives a security-oriented definition: "the chronology of the origin, development, ownership, location, and changes to a system or system component and associated data" [5].

PROV-DM has three core types [4]:

  • An entity is "a physical, digital, conceptual, or other kind of thing with some fixed aspects".
  • An activity is "something that occurs over a period of time and acts upon or with entities".
  • An agent is "something that bears some form of responsibility for an activity taking place, for the existence of an entity, or for another agent's activity".

They are connected by relations including generation, usage, derivation ("a transformation of an entity into another, an update of an entity resulting in a new one, or the construction of a new entity based on a pre-existing entity"), attribution ("the ascribing of an entity to an agent") and association.

For Halden, the provenance of the value is:

PROV elementInstance
Entity (the value)gmp_certificate_expiry = 2027-05-31 for Velmar Chemie GmbH
Entity (the source)GMP certificate no. DE-XX-2025-0193 (fictional), issued by a national competent authority, PDF, page 1
ActivityExtraction of the "valid until" date, 2026-02-10
AgentQA reviewer qa.ito, acting on behalf of Halden's Quality Unit
Relationsvalue wasDerivedFrom certificate; value wasGeneratedBy extraction; extraction wasAssociatedWith qa.ito
EvidenceVerbatim text "valid until 31.05.2027", page and position on the page

This answers the inspector's question directly: the date comes from a specific certificate, read on a specific day by a named person, with the passage that supports it. The live article on minimum data provenance requirements sets out which of these fields are needed for a value to be defensible.

Provenance has a limit too. It records how the value came to be what it is. On its own, it does not show whether anyone later overwrote the field without updating the provenance record.

Lineage localizes impact across systems. Provenance justifies a value. The audit trail proves the history of actions on a record. None of the three substitutes for another.

Audit trail: who changed what, and when

An audit trail is a chronological record of actions on a system or record. NIST defines it as "a chronological record that reconstructs and examines the sequence of activities surrounding or leading to a specific operation, procedure, or event in a security-relevant transaction from inception to final result" [6].

In regulated life sciences, the audit trail has a specific legal content. In the United States, 21 CFR 11.10(e) requires persons using closed systems for electronic records to use "secure, computer-generated, time-stamped audit trails to independently record the date and time of operator entries and actions that create, modify, or delete electronic records", adds that "record changes shall not obscure previously recorded information", and requires the audit trail to be retained at least as long as the records it covers and to be available for FDA review and copying [7].

In the EU, Annex 11 to the GMP guidelines (computerised systems), clause 9, states that "consideration should be given, based on a risk assessment, to building into the system the creation of a record of all GMP-relevant changes and deletions (a system generated 'audit trail')", that for a change or deletion of GMP-relevant data "the reason should be documented", and that audit trails "need to be available and convertible to a generally intelligible form and regularly reviewed" [8]. The Commission's EudraLex Volume 4 page lists this January 2011 revision as the current Annex 11 [9]. A revised Annex 11 went to stakeholder consultation from 7 July to 7 October 2025 and had not been adopted when this article was checked on 28 October 2026 [10].

Outside life sciences, NIST SP 800-53 Rev. 5 control AU-3 asks that audit records establish what type of event occurred, when and where it occurred, its source and outcome, and the identity of individuals or entities associated with it [11].

For Halden, the audit trail on the field shows:

Timestamp (UTC)UserActionOld valueNew valueReason
2025-06-03 14:12qa.itocreate(none)2026-05-31Initial approval
2026-02-10 09:47qa.itomodify2026-05-312027-05-31New certificate received

This proves that the change happened, who made it, when, and that the earlier value is still visible, as 11.10(e) requires. It does not prove the new value is right. "New certificate received" is a reason, not evidence: the audit trail does not contain the certificate, or the passage that supports 2027-05-31.

See also the glossary entry for audit trail.

Figure 01
The fictional supplier field audit trail
  1. 2025-06-03Initial approval2026-05-31

    At 14:12 UTC, qa.ito creates the field with an expiry date of 2026-05-31 and the reason Initial approval.

  2. 2026-02-10New certificate received2027-05-31

    At 09:47 UTC, qa.ito changes the expiry date from 2026-05-31 to 2027-05-31 with the reason New certificate received.

Where each fails alone

The three records fail in different ways. Each failure below is a realistic outcome for Halden's dashboard.

ScenarioLineage aloneProvenance aloneAudit trail alone
The certificate was misread (2027 typed for 2026)Shows the value came from qa.certificates; cannot detect the errorPoints to the certificate and passage; a reviewer can compare and find the errorShows qa.ito changed it on 2026-02-10; cannot detect the error
Someone later edits the field directly in the warehouseRun history may show nothing unusualProvenance still points to the certificate and now disagrees with the stored value, but only if someone compares themRecords the edit, the user and the time (if the warehouse table is audited)
An upstream job silently drops Velmar's rowShows which run and which input changedNo provenance for a value that no longer existsShows a deletion only if the deletion happened in an audited system
The inspector asks "why do you believe this date?"Cannot answerAnswers with source, passage, date read and responsible personAnswers who and when, not why
The inspector asks "has this ever been changed?"Cannot answer at value levelAnswers only if each version has its own provenance recordAnswers directly

The pattern is consistent. Lineage localizes impact across systems. Provenance justifies a value. The audit trail proves the history of actions on a record. None of the three substitutes for another.

Combining them into one chain of custody

Chain of custody, a term from evidence handling, is the documented sequence of who held an item and what was done to it from collection to presentation (glossary: chain of custody). For a data value, a usable chain of custody needs all three records, linked by stable identifiers:

  1. Value-level provenance as the anchor: the value, its source document, the supporting passage, the activity that extracted or computed it, and the responsible agent.
  2. Audit trail entries that reference the same value or record identifier, so each change can be matched to the provenance of the new value. Annex 11's "reason should be documented" becomes much stronger when the reason is a pointer to a provenance record rather than free text.
  3. Lineage that carries the value's identifier, or at least its record identifier, through downstream jobs, so that a value displayed on a dashboard can be traced back to the provenance record that justifies it.

In the Halden example, a combined record would let the inspector start from the dashboard tile, follow lineage to the supplier_master row, read the audit trail entry of 2026-02-10, and open the provenance record that points to page 1 of the certificate with the quoted text. Each hop uses a different system, but the identifiers connect them.

Two design points make the combination work in practice. First, provenance must be versioned with the value: when the audit trail records a change, the new value needs its own provenance record; overwriting the old one destroys the history. Second, identifiers must be stable across systems: a lineage graph keyed on table names and an audit trail keyed on row IDs cannot be joined to a provenance store keyed on something else.

Figure 02
Link the records into a chain of custody
  1. 01Anchor the value in provenance

    Record the value, source document, supporting passage, extraction or computation activity, and responsible agent.

  2. 02Link each change to its provenance

    Reference the same value or record identifier in audit entries so each change can be matched to the provenance of the new value.

  3. 03Carry identifiers downstream

    Carry the value or record identifier through downstream jobs so the dashboard value can be traced to the provenance that justifies it.

Version provenance with the value and keep identifiers stable across systems.

Overwriting the old provenance destroys history; incompatible identifiers prevent the records from being joined.

Regulatory pull: which rule asks for which

Regulations rarely use the words "lineage" and "provenance", but their requirements map onto them. The table cites only provisions quoted above or in the linked sources; it is a reading aid, not legal advice.

Rule (jurisdiction)What it asks forLineageProvenanceAudit trail
21 CFR 11.10(e) (US, FDA)Secure, computer-generated, time-stamped audit trails of entries and actions that create, modify or delete records; changes must not obscure prior valuesPrimary
EU GMP Annex 11, clause 9 (EU)Risk-based system-generated record of GMP-relevant changes and deletions; reason documented; regularly reviewedPartly (the reason)Primary
NIST SP 800-53 Rev. 5, AU-3 (US federal systems)Audit records establish event type, time, place, source, outcome and identitiesPrimary
BCBS 239, Principle 3 (international banking)Risk data reconciled with sources, including accounting data; a "dictionary" of concepts; supervisors expect banks to "document and explain all of their risk data aggregation processes"PrimaryPartly (reconciliation to sources)
EU AI Act, Article 10(2)(b) (EU)Data governance covering "data collection processes and the origin of data, and in the case of personal data, the original purpose of the data collection" for high-risk AI training, validation and testing dataPartlyPrimary

Sources for the table: 21 CFR 11.10; Annex 11; NIST SP 800-53 Rev. 5; BCBS 239, paragraphs 36, 37 and 39; Regulation (EU) 2024/1689, Article 10. The AI Act's high-risk requirements apply from 2 December 2027 for Annex III systems and 2 August 2028 for Annex I systems, as amended by Regulation (EU) 2026/1744.

Life sciences rules pull hardest on audit trails; banking supervision pulls on lineage and reconciliation; AI regulation pulls on the origin of data. An organization subject to more than one needs all three records and the identifiers that connect them.

Comparison table

Data lineageData provenanceAudit trail
Question answeredWhich datasets and jobs fed this one?Where did this value come from, how was it derived, who is responsible?Who did what to this record, and when?
Typical unitDataset, table, column, job runIndividual value or assertionRecord or field, per action
Reference modelOpenLineage (runs, jobs, datasets, facets)W3C PROV-DM (entities, activities, agents)21 CFR 11.10(e), Annex 11 clause 9, NIST AU-3
Captured byOrchestrators, query parsers, lineage collectorsExtraction and curation processes, at the moment a value is assertedThe system of record, on every create, modify or delete
Answers "is it right?"NoGives the evidence to checkNo
Answers "has it changed?"Only at dataset levelOnly if each version has its own recordYes
Main useImpact analysis, debugging, change managementDefending a value, citing a source, resolving conflictsAccountability, inspection, detecting unauthorized change
Typical gapStops at the edge of the data platformNot linked to later editsRecords actions, not evidence

Summary

Lineage, provenance and audit trail are three answers to three questions. A catalog's lineage graph tells you which pipelines to check. A provenance record tells you why a value is believed. An audit trail tells you who touched it. A value is defensible only when the three are kept together and joined by identifiers that do not change from one system to the next.

A system of record that keeps a cited, dated source behind every value and preserves every prior value is one way to hold all three together; that is the property Reliable Context is designed around.

Sources

  1. W3C, PROV-DM: The PROV Data Model (Recommendation, 30 April 2013): definition of provenance; entity, activity, agent; derivation and attribution.
  2. OpenLineage, Object model: definitions of Job, Run, Dataset and dataset naming.
  3. OpenLineage, Facets and extensibility: definition of a facet.
  4. NIST CSRC glossary, "lineage": lineage definition (from the NIST Privacy Framework).
  5. NIST CSRC glossary, "provenance": provenance definition (from SP 800-53 Rev. 5 and others).
  6. NIST CSRC glossary, "audit trail": audit trail definition.
  7. 21 CFR 11.10, Controls for closed systems (eCFR): paragraph (e) audit trail requirement.
  8. EudraLex Volume 4, Annex 11: Computerised Systems (revision January 2011): clause 9, audit trails.
  9. European Commission, EudraLex Volume 4 index: lists the January 2011 revision of Annex 11.
  10. European Commission, Stakeholders' consultation on EudraLex Volume 4: Chapter 4, Annex 11 and new Annex 22: consultation 7 July to 7 October 2025.
  11. NIST SP 800-53 Rev. 5, Security and Privacy Controls: control AU-3, content of audit records.
  12. Basel Committee, Principles for effective risk data aggregation and risk reporting (BCBS 239), January 2013: Principle 3, paragraphs 36, 37 and 39.
  13. Regulation (EU) 2024/1689 (AI Act): Article 10(2)(b).
  14. Regulation (EU) 2026/1744 (Digital Omnibus on AI): application dates for high-risk requirements.
External Sources (11)

Published by

Reliable Context Research

Reliable Context is a system of record for organizations that fuse private and public information and must defend every value they act on: one canonical record per real thing, ambiguity shown rather than hidden, and provenance behind every value.

Our product · Evidence and editorial standards · Contact

Request access

Editorial note

Researched and written by Reliable Context Research with AI-assisted research tools; sources are cited inline and checked before publication. Report an error: https://reliablecontext.com/corrections.