Versions Compared

Old Version 4

changes.mady.by.user Helena Mak

Saved on

compared with

New Version 5

changes.mady.by.user Helena Mak

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • add a new field called ISIN_country and populate this field:

    • If primary_ISIN = ‘Unlisted’ or null, then ISIN_country = null

    • Else ISIN_Country = first two chars of primary_ISIN

  • add a new field called countryISOAlpha2Code

    • If country = null, countryISOAlpha2Code = ISO code substitution on top of ISIN_country field (e.g. if ISIN_Country = ‘PR’, then countryISOAlpha2Code = ‘US’)

      • Please note that certain country codes will not exist - these are old country codes like CS or SU. If you can’t find a substitution, then countryISOAlpha2Code = null.

    • Else countryISOAlpha2Code = ISO code substition on top of country field (e.g. if ISIN_Country = ‘VG’, then countryISOAlpha2Code = ‘GB’)

    • Please note that certain country codes will not exist - these are old country codes like CS or SU. If you can’t find a substitution, then countryISOAlpha2Code = null.


Match Input fields explanation:

...