ores.refdata.derivation_kind

Reference data table defining the valid market_series.derivation_kind values: the sentinel OBSERVED (the default case – a directly published tick, no derivation involved) plus a named value per derivation mechanism (IR_CURVE_BOOTSTRAP, CRM_DERIVATION, …). OBSERVED exists so market_series.derivation_kind can stay a required, FK-validated column rather than nullable free text, the same pattern curve_role.NONE already establishes for instrument_code.curve_role. Deliberately generic and not curve-specific: a market_series row whose derivation_kind <> 'OBSERVED' carries a derivation_config_id=/=derivation_config_version pointing at the recipe that produced it (the bootstrap config for IR_CURVE_BOOTSTRAP, the CRM topology config for CRM_DERIVATION), letting any published point answer "was this observed or computed, and by what" without guessing from the source string. Managed by the system tenant, like other refdata code tables.

std::string("DerivationKind")

std::string(faker::word::adjective()) + " Derivation"

std::string(faker::lorem::sentence())

faker::number::integer(1, 100)

drop function if exists ores_refdata_validate_derivation_kind_fn;

#include <string>

#include <string>