See also the page on Exchange Rate data governance within the Data Governance directory
Data Object Definition
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.
Data Model
Exchange rate data in the Data Lake is composed of 1 table view:
- V_DIM_exchange_rate
Project Space: prj-data-pricing-dev
See how this entity relates to the others in the pricing data model here.
Additional Info & Comments
More information on Exchange rate data can be found in the Exchange Rates section of the BW P&L reporting wiki.
Data Flow
Tables & Attributes
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 |