For the D&B Project:
Ignore iprstrat_IPR-ValueFactor_sample_2007-2020.csv.gz
Ingest: iprstrat_IPR-ValueFactor_backfile_2007_01-2021_04.csv.gz - this full backfile includes all history up until the most recent valuation slice as of 2021-04-30.
Monthly updates: In the future, they will upload deltas since historical data remain unchanged (until there is a new valuation version).
For dunsification, please see match logic file. Note that the primary_ISIN needs to go through ISO code substitutions.
Data Dictionary as of 05/12/2021:
ISO Code Substitutions:
For Match Logic, please see the latest file on:
To match the data,
add a new field called ISIN_country and populate this field by extracting the first two chars of the primary_ISIN field
add a new field called ISIN_countryISOAlpha2Code and populate this field by using ISO code substitution on top of ISIN_country (e.g. if ISIN_Country = ‘PR’, then ISIN_countryISOAlpha2Code = ‘US’)
Match Input fields explanation:
name → name
country → countryISOAlpha2Code
if country = null, use ISIN_countryISOAlpha2Code → countryISOAlpha2Code
town_or_address → addressLocality
Acceptance rules (to be confirmed with D&B)
Accept all confidence code >=7
If ConfidenceCode <7, accept matches where matchGrade has the following pattern A*
Apply '1' AcceptanceIndicator to all above conditions
Add Comment