> ## 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.

# ES_SCENARIO_FX_RATES

The **ES\_SCENARIO\_FX\_RATES** table contains vector fields. In databases that do not natively support vectors, the vector fields are stored as separate columns.

## ES\_SCENARIO\_FX\_RATES Table Fields

<Tabs>
  <Tab title="Non-Native Vector Support">
    | Column Name        | Type    | Not Null | Cube Field | Description                                                                                                                                                                                                                                                                                                                     |
    | ------------------ | ------- | -------- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
    | DATA\_SET          | STRING  | Y        |            | The data set to which the entry belongs. The following different values are possible:“Full Set Current”: data for the last 12 months, “Reduced Set Stressed”: data with the reduced set of risk factors for the 12-month stress period, “Reduced Set Current”: data with the reduced set of risk factors for the last 12 months |
    | RISK\_CLASS        | STRING  | Y        |            | The risk class, which will be one of the following:GIRR, CSR, Equity, Commodity, FX, allin                                                                                                                                                                                                                                      |
    | LIQUIDITY\_HORIZON | INTEGER | Y        |            | The Liquidity Horizon in days: 10, 20, 40, 60 or 120                                                                                                                                                                                                                                                                            |
    | BASE\_CCY          | STRING  | Y        |            | The left side of the currency pair                                                                                                                                                                                                                                                                                              |
    | COUNTER\_CCY       | STRING  | Y        |            | The right side of the currency pair                                                                                                                                                                                                                                                                                             |
    | AS\_OF\_DATE       | DATE    | Y        |            | Timestamp (at close of business) for the data                                                                                                                                                                                                                                                                                   |
  </Tab>

  <Tab title="Native Vector Support">
    | Column Name        | Type          | Not Null | Cube Field | Description                                                                                                                                                                                                                                                                                                                     |
    | ------------------ | ------------- | -------- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
    | DATA\_SET          | STRING        | Y        |            | The data set to which the entry belongs. The following different values are possible:“Full Set Current”: data for the last 12 months, “Reduced Set Stressed”: data with the reduced set of risk factors for the 12-month stress period, “Reduced Set Current”: data with the reduced set of risk factors for the last 12 months |
    | RISK\_CLASS        | STRING        | Y        |            | The risk class, which will be one of the following:GIRR, CSR, Equity, Commodity, FX, allin                                                                                                                                                                                                                                      |
    | LIQUIDITY\_HORIZON | INTEGER       | Y        |            | The Liquidity Horizon in days: 10, 20, 40, 60 or 120                                                                                                                                                                                                                                                                            |
    | BASE\_CCY          | STRING        | Y        |            | The left side of the currency pair                                                                                                                                                                                                                                                                                              |
    | COUNTER\_CCY       | STRING        | Y        |            | The right side of the currency pair                                                                                                                                                                                                                                                                                             |
    | FX\_RATE           | ARRAY(DOUBLE) | Y        |            | The vector of FX rates between the two currencies. The vector is indexed by the same scenarios as the corresponding IMA ES PV vector.                                                                                                                                                                                           |
    | AS\_OF\_DATE       | DATE          | Y        |            | Timestamp (at close of business) for the data                                                                                                                                                                                                                                                                                   |
  </Tab>
</Tabs>

## ES\_SCENARIO\_FX\_RATES Unique Key

<Tabs>
  <Tab title="Non-Native Vector Support">
    | Columns            |
    | ------------------ |
    | VECTOR\_INDEX      |
    | DATA\_SET          |
    | RISK\_CLASS        |
    | LIQUIDITY\_HORIZON |
    | BASE\_CCY          |
    | COUNTER\_CCY       |
    | AS\_OF\_DATE       |
  </Tab>

  <Tab title="Native Vector Support">
    No vector table is required when the database natively supports aggregation on vector types.
  </Tab>
</Tabs>

## Outgoing Joins

<Tabs>
  <Tab title="Non-Native Vector Support">
    | Target Table                                              | Source Columns                                                                                        | Target Columns                                                                                        |
    | --------------------------------------------------------- | ----------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------- |
    | [ES\_SCENARIO\_FX\_RATES\_VECTOR](./es_scenario_fx_rates) | DATA\_SET<br />RISK\_CLASS<br />LIQUIDITY\_HORIZON<br />BASE\_CCY<br />COUNTER\_CCY<br />AS\_OF\_DATE | DATA\_SET<br />RISK\_CLASS<br />LIQUIDITY\_HORIZON<br />BASE\_CCY<br />COUNTER\_CCY<br />AS\_OF\_DATE |
  </Tab>

  <Tab title="Native Vector Support">
    There are no outgoing joins.
  </Tab>
</Tabs>