ores.refdata.portfolio

UUID uniquely identifying this portfolio.

Surrogate key for the portfolio record.

Party that owns this portfolio.

Set server-side from the authenticated session. Enforced by RLS.

ctx.generate_uuid()

Human-readable name for the portfolio.

e.g., 'Global Rates', 'APAC Credit'.

std::string(faker::company::companyName()) + " Portfolio"

Optional free-text description of the portfolio.

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

Self-referencing FK. NULL indicates a root node.

Links to the parent portfolio in the hierarchy.

std::nullopt

Business unit responsible for management.

References the business_units table.

// Left null: optional FK, and the insert trigger rejects ids that do
// not name an active business unit.
std::nullopt

Portfolio purpose classification.

References purpose_types lookup (Risk, Regulatory, ClientReporting, Internal). Defaults to Risk so a freshly-constructed portfolio (the Add dialog, before the Purpose Type combo's async populate completes) always carries a value the FK-validation trigger accepts.

std::string("Risk")

Currency for P&L/risk aggregation at this node.

ISO 4217 currency code.

// "X-0" is the first code the synthetic currency generator emits: the
// aggregation-currency validation accepts only codes of active
// currencies, and every test tenant inherits the system tenant's
// accumulated active set, which always contains X-0 (every generator
// process starts its counter at zero).
std::string("X-0")

If true, node is purely for on-demand reporting.

Not persisted in trade attribution when virtual.

false

Current lifecycle status (Active, Inactive, Closed). No dedicated lookup table exists yet (unlike book_status) – a fixed three-value list, defaulting to Active for the same reason as purpose_type=/book's =book_status: a freshly-constructed portfolio always carries a value.

std::string("Active")

Self-referencing: a portfolio's own writes recursively bump its parent portfolio's version too (multi-level composite-entity versioning), so that a nested tree's top-level "as of version N" composition sees every descendant's state as of that same instant – not just its immediate children. NULL (root node) safely no-ops: the touch function's row lookup finds nothing for a NULL id and returns without effect, terminating the recursion. See the "Temporal composite entity versioning" architecture doc, "Multi-level composition".