Market Risk Accelerator Reference Guide v2.0.0Counterparties
Download sample file: Counterparties.csv
File pattern match
The pattern match for the Counterparties file is **Counterparties*.csv
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. |