ores.refdata.csa_eligible_currency

Table of Contents

One row per currency a CSA accepts as collateral. ORE lists them under the CSA's EligibleCollaterals, in order; the position keeps that order so a CSA written back to ORE lists them as it read them.

1. Flags

2. Columns

2.1. id

UUID uniquely identifying this row.

Surrogate key for the eligible currency record.

2.2. csa_id

The CSA that accepts the currency.

References the CSAs table. 

ctx.generate_uuid()

2.3. currency_code

The ISO code of the eligible currency.

A CSA lists a currency once. Not checked against the currencies table: like the currency columns of the instrument models, it holds what the ORE document states. 

std::string("EUR")

2.4. position

The currency's place in ORE's list.

Zero-based; two currencies of one CSA never share a position. 

static_cast<int>(idx)

3. SQL

3.1. Flags

3.2. Checks

expression
"position" >= 0

3.3. Indexes

name columns unique current_only where_extra
csa_position csa_id, position true true  

4. Foreign keys

4.1. csa_id

5. C++

5.1. Flags

5.2. Repository

5.3. Domain includes

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

5.4. Entity includes

#include <string>

5.5. Conventions

5.6. Table display

column header
currency_code Currency
position Position
modified_by Modified By
version Version

5.7. Presentation

5.7.1. Detail fields

field label widget type is_key is_required placeholder
currency_code Currency currencyCodeEdit line_edit true true ISO currency code

5.7.2. Columns

enum_name field header type width
CurrencyCode currency_code Currency string 80
Position position Position int 70
Version version Version int 80
ModifiedBy modified_by Modified By string 120
RecordedAt recorded_at Recorded At timestamp 150

6. See also

Emacs 29.3 (Org mode 9.6.15)