See also the page on Exchange Rate data governance within the Data Governance directory
Exchange rates are conversion rates set between two currencies, published in Reuters website, identified by a RIC code (*) and daily uploaded to Solvay systems. The rate is usually ECB (European Central Bank) rate.
*RIC code: A Reuters Instrument Code, or RIC, is a ticker-like code used by Thomson Reuters to identify financial instruments and indices. The codes are used for looking up information on various Thomson Reuters financial information systems.
Exchange rate data in the Data Lake is composed of 1 table view:
Project Space: prj-data-pricing-dev
See how this entity relates to the others in the pricing data model here.
View ID: prj-data-pricing-dev.DataOcean.V_DIM_exchange_rate
| fullname | mode | type | description |
|---|---|---|---|
| exchange_rate_key | STRING | ||
| source_system_id | STRING | ||
| effective_date | DATE | ||
| from_currency | STRING | ||
| to_currency | STRING | ||
| exchange_rate | FLOAT | ||
| ratio_for_from_currency | FLOAT | ||
| ratio_for_to_currency | FLOAT | ||
| exchange_rate_type | STRING | ||
| exchange_rate_type_usage | STRING | ||
| system_id | STRING | ||
| inserted_date | TIMESTAMP | ||
| updated_date | TIMESTAMP | ||
| delete_flag | BOOLEAN |
-