The synthetic lineage reconstruction table
A reported result is easier to review when the input version, operation, key, validation, and downstream use remain visible together.
| ID | Input object and version | Transformation | Key or grain | Output object | Validation and use |
|---|---|---|---|---|---|
| L-01 | Event snapshot E-2026-08-31 | Filter event_type = qualified | One event ID; unique check passed | Eligible-event table V1 | Row count reconciled to snapshot; routing report |
| L-02 | CRM account snapshot A-2026-08-31 | Normalize country and segment | Account ID; duplicate check pending | Account-segment table V2 | Held until duplicate review; territory view |
| L-03 | Invoice lines I-2026-08-31 | Join to product map P-17 | Product key; many-to-one expected | Revenue-by-line table V3 | Join cardinality passed; PVM bridge |
| L-04 | Usage events U-2026-08-31 | Aggregate by account and 14-day window | Account ID and window end | Activation cohort V1 | Window cutoff recorded; activation analysis |
| L-05 | Manual exception sheet X-2026-09-01 | Add approved exclusion | Account ID; manual owner named | Admitted-cohort V2 | Rule change logged; dashboard refresh |
| L-06 | Late event file E-late-09-02 | Backfill prior snapshot | Event ID; version supersedes V1 | Reissued result V2 | Prior result invalidated; review reopened |
Swipe or scroll horizontally if the table is wider than your screen.
Reference & Evidence
Source: Author's synthetic lineage table grounded in World Wide Web Consortium (2013) PROV-DM. The provenance vocabulary is source-bounded; all objects, versions, operations, keys, values, and dispositions are illustrative.
Each line is a claim from the register this journal publishes against, resolved from the register at build time.
- A "Provenance is information about entities, activities, and people involved in producing a piece of data or thing", used to assess its quality, reliability or trustworthiness W3C. (2013). PROV-DM The PROV Data Model captured 2026-09-06 ·
W3C13-C1 - A The model is organised in six components, among them "derivations of entities from entities", alongside generation, usage, association and attribution W3C. (2013). PROV-DM The PROV Data Model captured 2026-09-06 ·
W3C13-C3 - A Provenance is input to a judgement, not a warrant: information "which can be used to form assessments about its quality, reliability or trustworthiness". It certifies nothing W3C. (2013). PROV-DM The PROV Data Model captured 2026-09-06 ·
W3C13-C5 - B Data lineage is a trace from a declared output or decision back through inputs, transformations, joins, filters, aggregations, and versions Author framework grounded in W3C13-C1 to W3C13-C4 ·
R03-OWN-C1 - B A lineage record must declare input and output dataset versions, operation, timestamp, owner or process, and the decision or field that consumes the output Author framework ·
R03-OWN-C3 - B A snapshot is a time-bounded observation and must not be silently treated as the same thing as an event stream or current table Author data rule ·
R03-OWN-C4 - B The synthetic lineage table contains six illustrative edges and no production dataset, customer record, or observed business result Author synthetic object ·
R03-OWN-C8 - B A lineage review should preserve the input, operation, output, validation, exception, and downstream-use fields together Author operating framework ·
R03-OWN-C9
Grades: A, verified against the printed page of the primary source · B, primary source, text layer only · C, authoritative secondary · D, reported.
Related exhibits
-
The synthetic provenance register
From the essay What is data provenance? The context behind a number
-
What does data lineage mean?
From the essay What is data lineage? The transformations behind a result
-
The synthetic statistical-inference review
From the essay What is statistical conclusion validity? A significant result can still be wrong