ores.analytics.pricing_model_product_parameter

Table of Contents

Stores model parameters, engine parameters, and global parameters as normalised rows for granular diffing. Product-scoped parameters have pricing_model_product_id set; global parameters have it NULL with parameter_scope = 'global'.

Flags

Primary key

UUID uniquely identifying this parameter row.

Surrogate key for the parameter.

Natural keys

Columns

pricing_model_config_id

Parent pricing model configuration.

Soft FK to ores_analytics_pricing_model_configs_tbl. Always set. 

ctx.generate_uuid()

pricing_model_product_id

Parent product mapping, if product-scoped.

Soft FK to ores_analytics_pricing_model_products_tbl. NULL for global parameters. 

std::nullopt

parameter_scope

Scope of the parameter.

One of: 'model', 'engine', 'global'. 

std::string("model")

parameter_name

Parameter name.

Examples: 'Calibration', 'Reversion', 'sy', 'ContinueOnCalibrationError'. 

std::string("Reversion")

parameter_value

Parameter value as text.

All values stored as text. Examples: '0.03', 'Bootstrap', 'Y', '1.0,2.0,3.0'. 

std::string("0.03")

SQL

Flags

C++

Flags

Repository

Domain includes

#include <chrono>
#include <optional>
#include <string>
#include <boost/uuid/uuid.hpp>

Entity includes

#include <string>
#include "sqlgen/Timestamp.hpp"
#include "sqlgen/PrimaryKey.hpp"

Conventions

Qt

Detail fields

field label widget type is_key is_required placeholder
parameter_scope Scope parameterScopeCombo static_combo   true  
parameter_name Name parameterNameEdit line_edit true true Parameter name (e.g. Calibration, Reversion, sy)
parameter_value Value parameterValueEdit line_edit   true Parameter value (e.g. Bootstrap, 0.03, Y)

Columns (Qt model)

enum_name field header type width
ParameterScope parameter_scope Scope string 80
ParameterName parameter_name Name string 200
ParameterValue parameter_value Value string 200
Version version Version int 70
ModifiedBy modified_by Modified By string 120
RecordedAt recorded_at Recorded At timestamp 150

Custom repository methods

See also

Emacs 29.1 (Org mode 9.6.6)