Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt

Use this file to discover all available pages before exploring further.

Download sample file: Trade_Attributes.csv This Trade Attributes file type is identified using the pattern: **/{Trade_Attributes,SA_Trades}*.csv (as specified by trade.attributes.sa.trades.file-pattern). This file is loaded using the Trade_Attributes topic. See the Topic Aliases table for an understanding of the topic aliases associated with each topic.
FieldKeyNullFieldTypeDescriptionExample
AsOfDateYNDate[YYYY-MM-DD]Timestamp (at close of business) for the data.
TradeIdYNStringIf coming from multiple systems may need to prepend source system to the id for uniqueness.“IR_IRSWAP_LIBOR3M”, “EQ_12345677”, etc. –
BookNNStringThe book to map the trade to (must match the node in the Book Hierarchy).
Legal EntityNNStringLegal Entity to map the trade to (must match the node in the Legal Entity Hierarchy).
NotionalNYDoubleNote: This field is not used in calculations. For DRC and RRAO calculations, provide the Notional directly in the DRC Trade or RRAO Trade input files.
NotionalCcyNYStringCurrency of notional. Required whenever notional is provided.
PresentValueNYDoubleNote: This field is not used in calculations. For DRC and Curvature calculations, provide the PresentValue directly in the DRC Trade or Curvature sensitivity files.
PVCcyNYStringCurrency of present value. Required whenever present value is provided.
ResidualRiskNY‘Y’ or ‘N’Deprecated - Applicable to RRAO onlyIndicates trade/position subject to residual risk add-on.
ExoticUnderlyingNY‘Y’ or ‘N’Deprecated - Applicable to RRAO onlyIf yes and residual risk, risk weight = 1% otherwise if residual risk, weight = .1%.
OtherResidualRiskTypeNYStringDeprecated - Applicable to RRAO onlyOptional data - valid if ExoticUnderlying = ‘N’. Suggested valid values are “GAP”, “CORRELATION”,‘BEHAVIORIAL”, “OTHER”.
TradeDateNYDate[YYYY-MM-DD]The date on which the trade took place
Sensitivity Scale CategoryNYStringThe category to use for scaling the SBM sensitivities. This matches the categories in the Sensitivity Scaling configuration file. If unused, or the category doesn’t match, no scaling is applied.Business Day 1
RRAO CategoryNYStringDeprecated - Applicable to RRAO onlyThis field is used as a key for modifying RRAO attributes. It is used for the overrides as part of the multi-jurisdictional support; it is not used directly in calculations.
InclusionNYStringIndicates if the trade should be included (‘Y’) or not by default in the calculations.
Default is ‘Y’
Y, Banking Book, Speculative

RRAO Trades

If the ResidualRisk flag is set, then a row is added to the SaSensitivities store. This row becomes a fact in the SA cube and is used for RRAO calculations.

Stores

The contents of this file are split between the (common) TradeMapping store which maps a trade to book and legal entity (and contains the TradeDate), and the (SA-only) SATradeDescription store which contains SA-specific details of the trade, including Notional, PV, and RRAO details.