Counterparties

Download sample file: Counterparties.csv

This Counterparties file type is identified using the pattern: **Counterparties*.csv (as specified by counterpartiesFilePattern). This file is loaded using the Counterparties topic. See the Topic Aliases table for an understanding of the topic aliases associated with each topic.

For information on the glob patterns used and how to customize them, see note on File name patterns

Field Key Null FieldType Description Example
AsOfDate Y N String with format ‘YYYY-MM-DD’ Indicates the date of the file. See Note on AsOfDate.
CounterpartyId Y N String Counterparty identifier. Used as a foreign key when counterparty is referenced. “HSBC Group”, “EBRD”
CounterpartyName N Y String Full counterparty name. “HSBC Holdings PLC”, “European Bank for Reconstruction and Development”
Rating N Y String Rating of the counterparty. “AAA”, “BB”
Sector N Y String Sector of the counterparty.
CountryOfAddress N Y String Country where the counterparty is located, in the form of a unique three-letter country identifier code.
CountryOfRisk N Y String Country the risk of counterparty can be attributed to, in the form of a unique three-letter country identifier code.