The source_row table
One publisher source line exactly as retrieved, imported or not. It is what makes every number auditable back to the file it came from, and what makes a non-import visible instead of silent.
Fields#
| field | type | required | example | meaning |
|---|---|---|---|---|
id |
uuid | yes | The row's own identifier. Consumers address a factor by its slug, not by this. | |
release_id |
uuid | yes | The release this value was published in. | |
artifact |
text | yes | 'Base_Carbone_V23.6.csv', 'IOT_2019_pxp/impacts/M.txt' | |
row_index |
integer | yes | position in the artifact; reproducible | |
raw |
jsonb | yes | verbatim, every field, no coercion | |
content_hash |
text | yes | 'ch1-' per-line silent-edit detector | |
ingest_status |
text | yes | ingested / skipped_* / failed | |
skip_reason |
text |
Referenced by#
emission_factor_value.source_row_id.
Notes#
A line that was deliberately not imported is archived too, with ingest_status and a machine-readable skip_reason: an unconvertible unit basis, a structural zero, a row owned by another library. emission_factor_value.source_row_id is the link back.