Data schema to define a person or legal entity.
| Name | Datatype | Description |
|---|---|---|
| date | datetime | The observation or value date for the data in this object. Formatted as YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601. |
| intra_group | boolean ? | Flag to indicate that this should be considered an intra-group entity. |
| naics_code | int(10, 999999) ? | North American Industry Classification System - NAICS Code |
| cqs_irb | int(1, 12) ? | The credit quality step for internal ratings based approach. |
| headcount | int ? | The number of full time staff. |
| total_assets | int ? | The annual balance sheet total of the entity as at the last accounting reference date. |
| source | string ? | The source(s) where this data originated. If more than one source needs to be stored for data lineage, it should be separated by a dash. eg. Source1-Source2 |
| type | The designated financial or legal entity category this person or legal entity falls under |
|
| fitch_lt | Fitch long term credit ratings |
|
| nace_code | The EU NACE economic activity classification. |
|
| kbra_st | KBRA short term credit ratings |
|
| moodys_st | Moodys short term credit ratings |
|
| credit_impaired | boolean ? | Flag to determine if the entity credit quality is impaired. |
| snp_st | S&P short term credit ratings |
|
| pd_irb_ec | double(0.0, 1.0) ? | The probability of default as determined by internal ratings-based approach. Expressed as a percentage between 0 and 1. This value is used in economic capital calculations. |
| birr_curve_id | string ? | The ID of the curve containing historical Borrower Internal Risk Ratings (BIRR) for this entity. The curve must be of type 'risk_rating'. |
| national_reporting_code | string ? | Unique identifier established by the national reporting system |
| id | string | The unique identifier for the record within the firm. |
| count | int(1, *) ? | Describes the number of entities represented by this record. eg. joint customers should have a count > 1. |
| boe_industry_code | string ? | Bank of England industry code. |
| bankruptcy_type | The bankruptcy chapter of the borrower. |
|
| moodys_lt | Moody's long term credit ratings |
|
| risk_group_id_2 | string ? | The secondary identifier for the secondary group representing a single risk entity where no relationship of control exists |
| dbrs_lt | DBRS long term credit ratings |
|
| country_code | The person or entity country of residence. Two-letter country code as defined according to ISO 3166-1. |
|
| fitch_st | Fitch short term credit ratings |
|
| parent_id | string ? | The unique identifier for the ultimate parent of the person or legal entity. |
| name | string ? | The name of the person or legal entity to be used for display and reference purposes. |
| ssic_code | int(0, 99999) ? | The Singaporean standard industry and sector classification. |
| pd_irb | double(0.0, 1.0) ? | The probability of default as determined by internal ratings-based approach. Expressed as a percentage between 0 and 1. This value is used in regulatory capital calculations. |
| risk_country_code | Two-letter country code describing where the risk for the security resides. In accordance with ISO 3166-1 |
|
| internal_rating | Categorization of unrated exposure |
|
| dbrs_st | DBRS short term credit ratings |
|
| kbra_lt | KBRA long term credit ratings |
|
| scra | Grade calculated using the Basel Standardised Credit Risk Assessment |
|
| currency_code | Currency in accordance with ISO 4217. It should be consistent with the figures for turnover and total assets. |
|
| lei_code | string(20, 20) ? | The LEI code for the legal entity (for corporates). |
| birr_id | string ? | The unique identifier of the Borrower Internal Risk Rating (BIRR), representing an internally assigned risk assessment for a customer based on their creditworthiness and financial stability. |
| cqs_standardised | int(1, 17) ? | The credit quality step for standardised approach. |
| relationship | Relationship to parent. |
|
| turnover | int ? | The annual turnover of the entity as at the last accounting reference date. |
| boe_sector_code | string ? | Bank of England sector code. |
| version_id | string ? | The version identifier of the data such as the firm's internal batch identifier. |
| snp_lt | S&P long term credit ratings |
|
| address_city | string ? | City, town or village. |
| lgd_irb | double(0.0, 1.0) ? | The loss given default as determined by internal ratings-based approach. Expressed as a percentage between 0 and 1. This value is used in regulatory capital calculations. |
| sic_code | int(0, 99999) ? | The UK SIC 2007 standard industry and sector classification. |
| reporting_relationship | Relationship to reporting entity. See: relationship. |
|
| postal_code | string ? | The post (zip) code in which the entity is domiciled. |
| risk_group_id | string ? | The unique identifier for the group representing a single risk entity where no relationship of control exists |
| legal_entity_name | string ? | The official legal name of the entity. |