DerivedMetric

close: schema:Observation

A metric computed from fundamentals rather than extracted from a filing. `formula_version` and `input_refs` are what make a published number reproducible: they say which definition was applied and exactly which observations it consumed.

Slots

slot	range		description
`dataco_id`	`string`	required	Certvas entity identifier — a deterministic hash of the LEI where one exists, else a ULID. Stable across rebuilds, which is what lets it be a public, citable identifier.
`period_end`	`date`	required	THE EFFECTIVE DATE — the last day of the fiscal period the value describes. Filtering a backtest on this alone leaks: the number was not knowable until it was published.
`metric_code`	`string`	required	Which metric this is, from the documented metric library.
`metric_value`	`decimal`	optional	The computed metric value.
`formula_version`	`string`	required	Version of the formula applied, so a historical number stays reproducible.
`input_refs`	`string`	optional	References to the exact observations consumed, as a JSON structure.
`observed_at`	`datetime`	required	When Certvas itself observed this value. Never a proxy for publication date.
`source_ref`	`string`	required	URL or document-hash pointer into the immutable raw archive.
`license_class`	`string`	required	License Register ID governing redistribution of THIS row. Per-row rather than per-table because a single table legitimately mixes sources with different terms.
`valid_from`	`date`	required	Start of the interval over which this assertion holds.
`valid_to`	`date`	optional	End of the validity interval; NULL means current. Half-open, so `valid_from <= t < valid_to` selects without double-counting the boundary.