Article Contents
Overview
The Mappings file provides the cross-references needed to align Hatched Analytics data with external platforms and naming conventions. It ensures that tickers and KPIs in our reports can be consistently linked to third-party identifiers.
Mappings are available in the SUPPLEMENTAL schema in Snowflake and in the corresponding S3 bucket.
If you require mappings to other platforms or data vendors, please contact us and we can extend the file to include the relevant identifiers.
Structure
The file contains 19 columns, grouped as follows:
Group | Name | Type |
Hatched Identifiers | Ticker | Varchar |
ㅤ | KPINAME | Varchar |
Classifiers/ Meta Data | REPORTINGCYCLE | Varchar |
ㅤ | KPITYPE | Varchar |
ㅤ | NUMBERTYPE | Varchar |
ㅤ | CURRENCYCYMBOL | Varchar |
ㅤ | SCALE | Varchar |
ㅤ | KPISTATUS | Varchar |
ㅤ | RANKING | Number |
ㅤ | KPIPREFIX | Varchar |
ㅤ | TRUE_KPI | Boolean |
Visible Alpha Code | VA_TICKER | Varchar |
ㅤ | VA_ID | Varchar |
ㅤ | VA_KPI | Varchar |
ㅤ | VA_COMMENT | Varchar |
Bloomberg Codes | TICKER_BBG | Varchar |
ㅤ | BBG_KPI | Varchar |
ㅤ | BBG_KPI_SEGMENT | Varchar |
ㅤ | BBG_FACTOR | Float |
Made with Bullet