Counterparty

Store Field Key CanBeNull Type Cube Field Description
AsOfDate Y N Object [AsOfDate] Indicates the date of the file. The files in this document that contain an AsOfDate column will rely on that AsOfDate when loaded into the ActivePivot datastores. For the files that do not specify this column (whether described in this document or not), the AsOfDate is taken from the directory structure – these files should reside in the appropriate folder (usually ./data/20xx-yy-zz/ … /*.csv).
CounterpartyId Y N String [Counterpartyld] The counterparty identifier. Used as a foreign key when counterparty is referenced.

Example: “HSBC Group”, “EBRD”
CounterpartyName N N String [CounterpartyName] The full counterparty name.

Example: “HSBC Holdings PLC”, “European Bank for Reconstruction and Development”
Rating N N String [Ratings] The rating of the counterparty.

Example: “AAA”, “BB”
Sector N N String [Sector] The sector of the counterparty.
CountryOfAddress N N String [CountryOfAddress] The country where the counterparty is located, in the form of a unique three-letter country identifier code.
CountryOfRisk N N String [CountryOfRisk] The country the risk of counterparty can be attributed to, in the form of a unique three-letter country identifier code.