| layout | title |
|---|---|
| schema | guarantor |
Guarantor Schema
Data schema to define a guarantor for a security.
Properties
| Name | Description | Type | Enum |
|---|---|---|---|
| id | The unique identifier for the record within the firm. | string | - |
| date | The observation or value date for the data in this object. Formatted as YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601. | string | - |
| address_city | City, town or village. | string | - |
| address_county | The county or administrative region (e.g. NUTS code) for an entity’s address. | string | - |
| address_street | Street address for the Entity. | string | - |
| bankruptcy_date | The date the bankruptcy proceedings were initiated. Formatted as YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601. | string | - |
| bankruptcy_type | The bankruptcy chapter of the borrower. | string | chapter_11, chapter_12, chapter_13, chapter_7, chapter_9, court_administration, insolvency, other, |
| birr_curve_id | The ID of the curve containing historical Borrower Internal Risk Ratings (BIRR) for this entity. The curve must be of type ‘risk_rating’. | string | - |
| birr_id | 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. | string | - |
| boe_industry_code | Bank of England industry code. | string | - |
| boe_sector_code | Bank of England sector code. | string | - |
| count | Describes the number of entities represented by this record. eg. joint customers should have a count > 1. | integer | - |
| country_code | Two-letter country code as defined according to ISO 3166-1 plus ISO allowed, user-assignable codes (AA, QM to QZ, XA to XZ, and ZZ). | string | AA, AD, AE, AE-AJ, AE-AZ, AE-DU, AE-FU, AE-RK, AE-SH, AE-UQ, AF, AG, AI, AL, AM, AO, AQ, AR, AS, AT, AU, AW, AX, AZ, BA, BB, BD, BE, BF, BG, BH, BI, BJ, BL, BM, BN, BO, BQ, BR, BS, BT, BV, BW, BY, BZ, CA, CA-AB, CA-BC, CA-MB, CA-NB, CA-NL, CA-NS, CA-NT, CA-NU, CA-ON, CA-PE, CA-QC, CA-SK, CA-YT, CC, CD, CF, CG, CH, CI, CK, CL, CM, CN, CO, CR, CU, CV, CW, CX, CY, CZ, DE, DJ, DK, DM, DO, DZ, EC, EE, EG, EH, ER, ES, ET, FI, FJ, FK, FM, FO, FR, GA, GB, GD, GE, GF, GG, GH, GI, GL, GM, GN, GP, GQ, GR, GS, GT, GU, GW, GY, HK, HM, HN, HR, HT, HU, ID, IE, IL, IM, IN, IO, IQ, IR, IS, IT, JE, JM, JO, JP, KE, KG, KH, KI, KM, KN, KP, KR, KW, KY, KZ, LA, LB, LC, LI, LK, LR, LS, LT, LU, LV, LY, MA, MC, MD, ME, MF, MG, MH, MK, ML, MM, MN, MO, MP, MQ, MR, MS, MT, MU, MV, MW, MX, MY, MZ, NA, NC, NE, NF, NG, NI, NL, NO, NP, NR, NU, NZ, OM, PA, PE, PF, PG, PH, PK, PL, PM, PN, PR, PS, PT, PW, PY, QA, QM, QN, QO, QP, QQ, QR, QS, QT, QU, QV, QW, QX, QY, QZ, RE, RO, RS, RU, RW, SA, SB, SC, SD, SE, SG, SH, SI, SJ, SK, SL, SM, SN, SO, SR, SS, ST, SV, SX, SY, SZ, TC, TD, TF, TG, TH, TJ, TK, TL, TM, TN, TO, TR, TT, TV, TW, TZ, UA, UG, UM, US, US-AK, US-AL, US-AR, US-AZ, US-CA, US-CO, US-CT, US-DC, US-DE, US-FL, US-GA, US-HI, US-IA, US-ID, US-IL, US-IN, US-KS, US-KY, US-LA, US-MA, US-MD, US-ME, US-MI, US-MN, US-MO, US-MS, US-MT, US-NC, US-ND, US-NE, US-NH, US-NJ, US-NM, US-NV, US-NY, US-OH, US-OK, US-OR, US-PA, US-RI, US-SC, US-SD, US-TN, US-TX, US-UT, US-VA, US-VT, US-WA, US-WI, US-WV, US-WY, UY, UZ, VA, VC, VE, VG, VI, VN, VU, WF, WS, XA, XB, XC, XD, XE, XF, XG, XH, XI, XJ, XK, XL, XM, XN, XO, XP, XQ, XR, XS, XT, XU, XV, XW, XX, XY, XZ, YE, YT, ZA, ZM, ZW, ZZ, |
| cqs_irb | The credit quality step for internal ratings based approach. | integer | - |
| cqs_standardised | The credit quality step for standardised approach. | integer | - |
| credit_impaired | Flag to determine if the entity credit quality is impaired. | boolean | - |
| currency_code | Currency in accordance with ISO 4217 standards plus CNH for practical considerations. | string | AED, AFN, ALL, AMD, ANG, AOA, ARS, AUD, AWG, AZN, BAM, BBD, BDT, BGN, BHD, BIF, BMD, BND, BOB, BOV, BRL, BSD, BTN, BWP, BYN, BZD, CAD, CDF, CHE, CHF, CHW, CLF, CLP, CNH, CNY, COP, COU, CRC, CUC, CUP, CVE, CZK, DJF, DKK, DOP, DZD, EGP, ERN, ETB, EUR, FJD, FKP, GBP, GEL, GHS, GIP, GMD, GNF, GTQ, GYD, HKD, HNL, HRK, HTG, HUF, IDR, ILS, INR, IQD, IRR, ISK, JMD, JOD, JPY, KES, KGS, KHR, KMF, KPW, KRW, KWD, KYD, KZT, LAK, LBP, LKR, LRD, LSL, LYD, MAD, MDL, MGA, MKD, MMK, MNT, MOP, MRU, MUR, MVR, MWK, MXN, MXV, MYR, MZN, NAD, NGN, NIO, NOK, NPR, NZD, OMR, PAB, PEN, PGK, PHP, PKR, PLN, PYG, QAR, RON, RSD, RUB, RWF, SAR, SBD, SCR, SDG, SEK, SGD, SHP, SLE, SLL, SOS, SRD, SSP, STN, SYP, SZL, THB, TJS, TMT, TND, TOP, TRY, TTD, TWD, TZS, UAH, UGX, USD, USN, USS, UYI, UYU, UYW, UZS, VED, VES, VND, VUV, WST, XAD, XAF, XAG, XAU, XBA, XBB, XBC, XBD, XCD, XCG, XDR, XOF, XPD, XPF, XPT, XSU, XTS, XUA, XXX, YER, ZAR, ZMW, ZWG, |
| dbrs_lt | DBRS long term credit ratings | string | aaa, aa_h, aa, aa_l, a_h, a, a_l, bbb_h, bbb, bbb_l, bb_h, bb, bb_l, b_h, b, b_l, ccc_h, ccc, ccc_l, cc, c, d, |
| dbrs_st | DBRS short term credit ratings | string | r1_h, r1_m, r1_l, r2_h, r2_m, r2_l, r3, r4, r5, d, |
| established_date | The effective date from which the investee’s business age is determined. Formatted as YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601. | string | - |
| financials_date | The as of date of the financial information. Also see [accounts_payable], [accounts_receivable], [capital_exp], [cash_securities], [curr_assets], [curr_liabilities], [depr_amort], [fixed_assets], [interest_expense], [inventory], [long_term_debt], [long_term_debt_maturity_amount], [net_income], [net_sales], [operating_income], [retained_earnings], [short_term_debt], [tangible_assets], [total_assets], [total_liabilities] Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information. | string | - |
| fitch_lt | Fitch long term credit ratings | string | aaa, aa_plus, aa, aa_minus, a_plus, a, a_minus, bbb_plus, bbb, bbb_minus, bb_plus, bb, bb_minus, b_plus, b, b_minus, ccc_plus, ccc, ccc_minus, cc, c, rd, d, |
| fitch_st | Fitch short term credit ratings | string | f1_plus, f1, f2, f3, b, c, rd, d, |
| head_office_id | The unique identifier for the head office of the legal entity. | string | - |
| headcount | The number of full time staff. | integer | - |
| internal_rating | Categorization of unrated exposure | string | investment, non_investment, |
| intra_group | Flag to indicate that this should be considered an intra-group entity. | boolean | - |
| joint_customer_ids | The list of customers for this joint liability facility | array | - |
| kbra_lt | KBRA long term credit ratings | string | aaa, aa_plus, aa, aa_minus, a_plus, a, a_minus, bbb_plus, bbb, bbb_minus, bb_plus, bb, bb_minus, b_plus, b, b_minus, ccc_plus, ccc, ccc_minus, cc, c, d, |
| kbra_st | KBRA short term credit ratings | string | k1_plus, k1, k2, k3, b, c, d, |
| legal_entity_name | The official legal name of the entity. | string | - |
| legal_form | The type of business entity as defined in the EU national legal system | string | AT102, AT103, AT201, AT202, AT203, AT401, AT501, AT603, AT604, AT605, AT607, AT610, AT611, AT612, AT613, BE000, BE002, BE003, BE006, BE008, BE011, BE012, BE013, BE014, BE015, BE017, BE019, BE020, BE021, BE025, BE026, BE028, BE029, BE051, BE060, BE070, BE107, BE108, BE114, BE117, BE121, BE124, BE125, BE127, BE129, BE151, BE200, BE206, BE208, BE211, BE212, BE213, BE214, BE215, BE217, BE218, BE225, BE301, BE302, BE303, BE310, BE320, BE325, BE330, BE340, BE350, BE400, BE411, BE412, BE413, BE414, BE415, BE416, BE417, BE418, BE419, BE420, BE422, BE506, BE508, BE511, BE512, BE513, BE514, BE515, BE560, BE610, BE612, BE616, BE617, BE651, BE702, BE706, BE716, BE721, BG101, BG102, BG103, BG104, BG105, BG106, BG107, BG108, BG109, BG1539, BG462, BG466, BG472, BG501, BG999, CY102, CY103, CY109, CY111, CY113, CY114, CY116, CY117, CZ111, CZ112, CZ113, CZ115, CZ116, CZ117, CZ118, CZ121, CZ141, CZ145, CZ151, CZ152, CZ161, CZ205, CZ301, CZ313, CZ325, CZ326, CZ331, CZ332, CZ352, CZ353, CZ361, CZ381, CZ391, CZ521, CZ541, CZ601, CZ641, CZ661, CZ703, CZ704, CZ705, CZ706, CZ707, CZ708, CZ711, CZ715, CZ721, CZ722, CZ723, CZ731, CZ732, CZ733, CZ734, CZ736, CZ741, CZ745, CZ751, CZ761, CZ771, CZ801, CZ804, CZ805, CZ901, CZ907, CZ908, CZ921, CZ922, CZ937, CZ938, CZ950, CZ960, CZ961, DE101, DE102, DE103, DE105, DE108, DE109, DE110, DE111, DE201, DE202, DE206, DE207, DE301, DE401, DE501, DE502, DE503, DE504, DE505, DE507, DE601, DE602, DE701, DK100, DK110, DK115, DK130, DK140, DK150, DK151, DK152, DK20, DK230, DK235, DK240, DK245, DK250, DK260, DK270, DK280, DK285, DK30, DK40, DK45, DK50, DK60, DK70, DK80, DK81, DK90, DK95, EE101, EE102, EE201, EE202, EE203, EE204, EE205, EE206, EE207, EE208, ESC04, ESC05, ESC06, ESC07, ESC08, ESC09, ESC10, ESC11, ESC12, ESC13, ESC14, ESC16, ESC17, ESC19, ESC20, ESC21, ESC25, ESC30, ESC31, ESC32, ESC33, ESC34, EU100, EU200, EU300, EU400, FI10, FI11, FI12, FI13, FI16, FI17, FI19, FI20, FI21, FI22, FI23, FI24, FI25, FI26, FI27, FI28, FI29, FI30, FI31, FI32, FI33, FI35, FI39, FI40, FI41, FI42, FI43, FI44, FI45, FI46, FI47, FI48, FI49, FI50, FI60, FI61, FI62, FI63, FI64, FI65, FI99, FR0000, FR001, FR002, FR003, FR004, FR005, FR006, FR007, FR008, FR009, FR013, FR015, FR017, FR018, FR020, FR021, FR022, FR024, FR025, FR026, FR027, FR028, FR029, FR030, FR031, FR032, FR033, FR034, FR035, FR036, FR037, FR038, FR039, FR040, FR041, FR042, FR043, FR044, FR045, FR047, FR049, FR050, FR051, FR052, FR053, FR054, FR055, FR056, FR057, FR058, FR059, FR060, FR061, FR062, FR063, FR064, FR065, FR066, FR2120, FR2210, FR2220, FR2310, FR2320, FR2385, FR2400, FR2700, FR2900, FR3110, FR3120, FR3205, FR3210, FR3220, FR3290, FR4110, FR4120, FR4130, FR4140, FR4150, FR4160, FR5191, FR5192, FR5193, FR5194, FR5195, FR5196, FR5202, FR5203, FR5306, FR5307, FR5308, FR5309, FR5310, FR5370, FR5385, FR5410, FR5415, FR5422, FR5426, FR5430, FR5431, FR5432, FR5442, FR5443, FR5451, FR5453, FR5454, FR5455, FR5458, FR5459, FR5460, FR5470, FR5485, FR5498, FR5499, FR5505, FR5510, FR5515, FR5520, FR5522, FR5525, FR5530, FR5531, FR5532, FR5542, FR5543, FR5546, FR5547, FR5548, FR5551, FR5552, FR5553, FR5554, FR5555, FR5558, FR5559, FR5560, FR5570, FR5585, FR5599, FR5605, FR5610, FR5615, FR5620, FR5622, FR5625, FR5630, FR5631, FR5632, FR5642, FR5643, FR5646, FR5647, FR5648, FR5651, FR5652, FR5653, FR5654, FR5655, FR5658, FR5659, FR5660, FR5670, FR5685, FR5699, FR5710, FR5720, FR5770, FR5785, FR6100, FR6220, FR6316, FR6317, FR6318, FR6411, FR6511, FR6521, FR6532, FR6533, FR6534, FR6535, FR6536, FR6537, FR6538, FR6539, FR6540, FR6541, FR6542, FR6543, FR6544, FR6551, FR6554, FR6558, FR6560, FR6561, FR6562, FR6563, FR6564, FR6565, FR6566, FR6567, FR6568, FR6569, FR6571, FR6572, FR6573, FR6574, FR6575, FR6576, FR6577, FR6578, FR6585, FR6588, FR6589, FR6595, FR6596, FR6597, FR6598, FR6599, FR6901, FR7111, FR7112, FR7113, FR7120, FR7150, FR7160, FR7171, FR7172, FR7179, FR7190, FR7210, FR7220, FR7225, FR7229, FR7230, FR7312, FR7313, FR7314, FR7321, FR7322, FR7323, FR7331, FR7340, FR7341, FR7342, FR7343, FR7344, FR7345, FR7346, FR7347, FR7348, FR7349, FR7351, FR7352, FR7353, FR7354, FR7355, FR7356, FR7357, FR7361, FR7362, FR7363, FR7364, FR7365, FR7366, FR7367, FR7371, FR7372, FR7373, FR7378, FR7379, FR7381, FR7382, FR7383, FR7384, FR7385, FR7389, FR7410, FR7430, FR7450, FR7470, FR7490, FR8110, FR8120, FR8130, FR8140, FR8150, FR8160, FR8170, FR8190, FR8210, FR8250, FR8290, FR8310, FR8311, FR8410, FR8420, FR8450, FR8470, FR8490, FR8510, FR8520, FR9110, FR9150, FR9210, FR9220, FR9221, FR9222, FR9223, FR9224, FR9230, FR9240, FR9260, FR9300, FR9900, FR9970, GB100, GB200, GB300, GB400, GB500, GB600, GR901, GR902, GR903, GR904, GR905, GR906, GR907, GR908, GR909, GR910, GR911, GR912, GR913, GR999, HR01, HR02, HR03, HR04, HR06, HR07, HR08, HR09, HR10, HR13, HR14, HR15, HR16, HR17, HR20, HR21, HR22, HR23, HR25, HR26, HR27, HR28, HR29, HR32, HR34, HR35, HR37, HR38, HR39, HR42, HR44, HR45, HR47, HR48, HR49, HR51, HR52, HR53, HR55, HR57, HR59, HR60, HR62, HU113, HU114, HU116, HU117, HU121, HU122, HU123, HU124, HU129, HU131, HU133, HU135, HU141, HU142, HU311, HU312, HU321, HU322, HU325, HU327, HU328, HU371, HU372, HU373, HU511, HU517, HU524, HU529, HU541, HU549, HU551, HU552, HU555, HU556, HU557, HU558, HU561, HU566, HU567, HU568, HU569, HU572, HU573, HU575, HU576, HU581, HU582, HU583, HU736, HU915, HU916, HU999, IE01, IE02, IE03, IE04, IE05, IE06, IE07, IE08, IE11, IE12, IE13, IE14, IE15, IE16, IT101, IT201, IT301, IT401, IT402, IT501, IT601, IT701, IT702, IT703, IT801, IT902, IT903, IT999, LT101, LT102, LT103, LT104, LT105, LT106, LT107, LT108, LT109, LT110, LT111, LT201, LT202, LT203, LT204, LT205, LT206, LT207, LT208, LT209, LT210, LT211, LT212, LT213, LT214, LT215, LT216, LT301, LU03, LU04, LU05, LU06, LU07, LU08, LU09, LU10, LU11, LU12, LU13, LU15, LU16, LU17, LU18, LU19, LU20, LU21, LU22, LU26, LU27, LU32, LU33, LU34, LU35, LU36, LU37, LU38, LU39, LV101, LV103, LV104, LV105, LV106, LV107, LV108, LV109, LV110, LV111, LV301, LV303, LV401, LV402, LV403, LV404, LV405, LV406, LV701, LV801, LV802, LV803, LV804, LV805, LV806, LV807, LV808, LV809, LV810, LV903, MT020, MT021, MT030, MT032, MT033, MT034, MT040, MT050, MT060, MT070, MT080, NL101, NL102, NL201, NL202, NL203, NL204, NL205, NL206, NL207, NL302, NL303, NL304, NL401, NL402, NL501, PLA019, PLA044, PLA070, PLA085, PLA099, PLA115, PLA116, PLA117, PLA118, PLA120, PLA121, PLA124, PLA126, PLA132, PLA134, PLA140, PLA146, PLA148, PLA177, PLA180, PLA403, PLA409, PLA428, PLB050, PLB055, PLB060, PLB133, PLB137, PLB138, PLB141, PLB147, PLB381, PLB401, PLB429, PLC049, PLD049, PLE049, PT111, PT121, PT122, PT131, PT141, PT151, PT161, PT171, PT181, PT182, PT211, PT221, PT231, PT311, PT312, PT321, PT331, PT411, PT711, PT901, RO101, RO102, RO103, RO104, RO105, RO107, RO108, RO110, RO111, RO114, RO115, RO116, RO117, RO121, RO122, RW100, RW200, RW300, RW400, RW500, RW600, SE21, SE22, SE31, SE41, SE42, SE49, SE51, SE53, SE54, SE61, SE62, SE63, SE71, SE72, SE81, SE82, SE83, SE84, SE87, SE88, SE91, SE92, SE93, SE94, SE95, SE98, SI101, SI102, SI103, SI104, SI105, SI108, SI112, SI113, SI201, SI210, SI211, SI213, SI300, SI301, SI302, SI303, SI304, SI305, SI306, SI307, SI308, SI309, SI310, SI311, SI313, SI315, SI316, SI318, SI319, SI321, SI322, SI351, SI352, SI354, SI355, SI357, SI358, SI359, SI360, SI361, SI362, SI401, SI402, SI403, SI404, SI405, SI406, SI407, SI451, SI452, SI453, SI458, SI702, SI703, SI704, SI708, SI713, SI715, SI719, SI799, SI804, SI899, SK111, SK112, SK113, SK117, SK118, SK119, SK120, SK121, SK125, SK141, SK205, SK271, SK272, SK273, SK301, SK311, SK312, SK321, SK331, SK333, SK381, SK382, SK383, SK434, SK445, SK701, SK711, SK721, SK741, SK745, SK751, SK801, SK803, SK911, SK921, SKN01, SPFUND, |
| lei_code | The LEI code for the legal entity (for corporates). | string | - |
| lgd_irb | 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. | number | - |
| moodys_lt | Moody’s long term credit ratings | string | aaa, aa1, aa2, aa3, a1, a2, a3, baa1, baa2, baa3, ba1, ba2, ba3, b1, b2, b3, caa1, caa2, caa3, ca, c, |
| moodys_st | Moodys short term credit ratings | string | p1, p2, p3, np, |
| nace_code | The EU NACE economic activity classification. | string | A.01.10, A.01.11, A.01.12, A.01.13, A.01.14, A.01.15, A.01.16, A.01.19, A.01.20, A.01.21, A.01.22, A.01.23, A.01.24, A.01.25, A.01.26, A.01.27, A.01.28, A.01.29, A.01.30, A.01.40, A.01.41, A.01.42, A.01.43, A.01.44, A.01.45, A.01.46, A.01.47, A.01.48, A.01.49, A.01.50, A.01.60, A.01.61, A.01.62, A.01.63, A.01.64, A.01.70, A.02.10, A.02.20, A.02.30, A.02.40, A.03.10, A.03.11, A.03.12, A.03.20, A.03.21, A.03.22, A.03.30, B.05.10, B.05.20, B.06.10, B.06.20, B.07.10, B.07.20, B.07.21, B.07.29, B.08.10, B.08.11, B.08.12, B.08.90, B.08.91, B.08.92, B.08.93, B.08.99, B.09.10, B.09.90, C.10.10, C.10.11, C.10.12, C.10.13, C.10.20, C.10.30, C.10.31, C.10.32, C.10.39, C.10.40, C.10.41, C.10.42, C.10.50, C.10.51, C.10.52, C.10.60, C.10.61, C.10.62, C.10.70, C.10.71, C.10.72, C.10.73, C.10.80, C.10.81, C.10.82, C.10.83, C.10.84, C.10.85, C.10.86, C.10.89, C.10.90, C.10.91, C.10.92, C.11.00, C.11.01, C.11.02, C.11.03, C.11.04, C.11.05, C.11.06, C.11.07, C.12.00, C.13.10, C.13.20, C.13.30, C.13.90, C.13.91, C.13.92, C.13.93, C.13.94, C.13.95, C.13.96, C.13.99, C.14.10, C.14.11, C.14.12, C.14.13, C.14.14, C.14.19, C.14.20, C.14.21, C.14.22, C.14.23, C.14.24, C.14.29, C.14.30, C.14.31, C.14.39, C.15.10, C.15.11, C.15.12, C.15.20, C.16.10, C.16.11, C.16.12, C.16.20, C.16.21, C.16.22, C.16.23, C.16.24, C.16.25, C.16.26, C.16.27, C.16.28, C.16.29, C.17.10, C.17.11, C.17.12, C.17.20, C.17.21, C.17.22, C.17.23, C.17.24, C.17.25, C.17.29, C.18.10, C.18.11, C.18.12, C.18.13, C.18.14, C.18.20, C.19.10, C.19.20, C.20.10, C.20.11, C.20.12, C.20.13, C.20.14, C.20.15, C.20.16, C.20.17, C.20.20, C.20.30, C.20.40, C.20.41, C.20.42, C.20.50, C.20.51, C.20.52, C.20.53, C.20.59, C.20.60, C.21.10, C.21.20, C.22.10, C.22.11, C.22.12, C.22.19, C.22.20, C.22.21, C.22.22, C.22.23, C.22.24, C.22.25, C.22.26, C.22.29, C.23.10, C.23.11, C.23.12, C.23.13, C.23.14, C.23.15, C.23.19, C.23.20, C.23.30, C.23.31, C.23.32, C.23.40, C.23.41, C.23.42, C.23.43, C.23.44, C.23.45, C.23.49, C.23.50, C.23.51, C.23.52, C.23.60, C.23.61, C.23.62, C.23.63, C.23.64, C.23.65, C.23.66, C.23.69, C.23.70, C.23.90, C.23.91, C.23.99, C.24.10, C.24.20, C.24.30, C.24.31, C.24.32, C.24.33, C.24.34, C.24.40, C.24.41, C.24.42, C.24.43, C.24.44, C.24.45, C.24.46, C.24.50, C.24.51, C.24.52, C.24.53, C.24.54, C.25.10, C.25.11, C.25.12, C.25.20, C.25.21, C.25.22, C.25.29, C.25.30, C.25.40, C.25.50, C.25.51, C.25.52, C.25.53, C.25.60, C.25.61, C.25.62, C.25.63, C.25.70, C.25.71, C.25.72, C.25.73, C.25.90, C.25.91, C.25.92, C.25.93, C.25.94, C.25.99, C.26.10, C.26.11, C.26.12, C.26.20, C.26.30, C.26.40, C.26.50, C.26.51, C.26.52, C.26.60, C.26.70, C.26.80, C.27.10, C.27.11, C.27.12, C.27.20, C.27.30, C.27.31, C.27.32, C.27.33, C.27.40, C.27.50, C.27.51, C.27.52, C.27.90, C.28.10, C.28.11, C.28.12, C.28.13, C.28.14, C.28.15, C.28.20, C.28.21, C.28.22, C.28.23, C.28.24, C.28.25, C.28.29, C.28.30, C.28.40, C.28.41, C.28.42, C.28.49, C.28.90, C.28.91, C.28.92, C.28.93, C.28.94, C.28.95, C.28.96, C.28.97, C.28.99, C.29.10, C.29.20, C.29.30, C.29.31, C.29.32, C.30.10, C.30.11, C.30.12, C.30.13, C.30.20, C.30.30, C.30.31, C.30.32, C.30.40, C.30.90, C.30.91, C.30.92, C.30.99, C.31.00, C.31.01, C.31.02, C.31.03, C.31.09, C.32.10, C.32.11, C.32.12, C.32.13, C.32.20, C.32.30, C.32.40, C.32.50, C.32.90, C.32.91, C.32.99, C.33.10, C.33.11, C.33.12, C.33.13, C.33.14, C.33.15, C.33.16, C.33.17, C.33.18, C.33.19, C.33.20, D.35.10, D.35.11, D.35.12, D.35.13, D.35.14, D.35.15, D.35.16, D.35.20, D.35.21, D.35.22, D.35.23, D.35.24, D.35.30, D.35.40, E.36.00, E.37.00, E.38.10, E.38.11, E.38.12, E.38.20, E.38.21, E.38.22, E.38.23, E.38.30, E.38.31, E.38.32, E.38.33, E.39.00, F.41.00, F.41.10, F.41.20, F.42.10, F.42.11, F.42.12, F.42.13, F.42.20, F.42.21, F.42.22, F.42.90, F.42.91, F.42.99, F.43.10, F.43.11, F.43.12, F.43.13, F.43.20, F.43.21, F.43.22, F.43.23, F.43.24, F.43.29, F.43.30, F.43.31, F.43.32, F.43.33, F.43.34, F.43.35, F.43.39, F.43.40, F.43.41, F.43.42, F.43.50, F.43.60, F.43.90, F.43.91, F.43.99, G.45.10, G.45.11, G.45.19, G.45.20, G.45.30, G.45.31, G.45.32, G.45.40, G.46.10, G.46.11, G.46.12, G.46.13, G.46.14, G.46.15, G.46.16, G.46.17, G.46.18, G.46.19, G.46.20, G.46.21, G.46.22, G.46.23, G.46.24, G.46.30, G.46.31, G.46.32, G.46.33, G.46.34, G.46.35, G.46.36, G.46.37, G.46.38, G.46.39, G.46.40, G.46.41, G.46.42, G.46.43, G.46.44, G.46.45, G.46.46, G.46.47, G.46.48, G.46.49, G.46.50, G.46.51, G.46.52, G.46.60, G.46.61, G.46.62, G.46.63, G.46.64, G.46.65, G.46.66, G.46.69, G.46.70, G.46.71, G.46.72, G.46.73, G.46.74, G.46.75, G.46.76, G.46.77, G.46.80, G.46.81, G.46.82, G.46.83, G.46.84, G.46.85, G.46.86, G.46.87, G.46.89, G.46.90, G.47.10, G.47.11, G.47.12, G.47.19, G.47.20, G.47.21, G.47.22, G.47.23, G.47.24, G.47.25, G.47.26, G.47.27, G.47.29, G.47.30, G.47.40, G.47.41, G.47.42, G.47.43, G.47.50, G.47.51, G.47.52, G.47.53, G.47.54, G.47.55, G.47.59, G.47.60, G.47.61, G.47.62, G.47.63, G.47.64, G.47.65, G.47.69, G.47.70, G.47.71, G.47.72, G.47.73, G.47.74, G.47.75, G.47.76, G.47.77, G.47.78, G.47.79, G.47.80, G.47.81, G.47.82, G.47.83, G.47.89, G.47.90, G.47.91, G.47.92, G.47.99, H.49.10, H.49.11, H.49.12, H.49.20, H.49.30, H.49.31, H.49.32, H.49.33, H.49.34, H.49.39, H.49.40, H.49.41, H.49.42, H.49.50, H.50.10, H.50.20, H.50.30, H.50.40, H.51.10, H.51.20, H.51.21, H.51.22, H.52.10, H.52.20, H.52.21, H.52.22, H.52.23, H.52.24, H.52.25, H.52.26, H.52.29, H.52.30, H.52.31, H.52.32, H.53.10, H.53.20, H.53.30, I.55.10, I.55.20, I.55.30, I.55.40, I.55.90, I.56.10, I.56.11, I.56.12, I.56.20, I.56.21, I.56.22, I.56.29, I.56.30, I.56.40, J.58.10, J.58.11, J.58.12, J.58.13, J.58.14, J.58.19, J.58.20, J.58.21, J.58.29, J.59.10, J.59.11, J.59.12, J.59.13, J.59.14, J.59.20, J.60.10, J.60.20, J.60.30, J.60.31, J.60.39, J.61.10, J.61.20, J.61.30, J.61.90, J.62.00, J.62.01, J.62.02, J.62.03, J.62.09, J.63.10, J.63.11, J.63.12, J.63.90, J.63.91, J.63.99, K.61.10, K.61.20, K.61.90, K.62.10, K.62.20, K.62.90, K.63.10, K.63.90, K.63.91, K.63.92, K.64.10, K.64.11, K.64.19, K.64.20, K.64.30, K.64.90, K.64.91, K.64.92, K.64.99, K.65.10, K.65.11, K.65.12, K.65.20, K.65.30, K.66.10, K.66.11, K.66.12, K.66.19, K.66.20, K.66.21, K.66.22, K.66.29, K.66.30, L.64.10, L.64.11, L.64.19, L.64.20, L.64.21, L.64.22, L.64.30, L.64.31, L.64.32, L.64.90, L.64.91, L.64.92, L.64.99, L.65.10, L.65.11, L.65.12, L.65.20, L.65.30, L.66.10, L.66.11, L.66.12, L.66.19, L.66.20, L.66.21, L.66.22, L.66.29, L.66.30, L.68.10, L.68.20, L.68.30, L.68.31, L.68.32, M.68.10, M.68.11, M.68.12, M.68.20, M.68.30, M.68.31, M.68.32, M.69.10, M.69.20, M.70.10, M.70.20, M.70.21, M.70.22, M.71.10, M.71.11, M.71.12, M.71.20, M.72.10, M.72.11, M.72.19, M.72.20, M.73.10, M.73.11, M.73.12, M.73.20, M.74.10, M.74.20, M.74.30, M.74.90, M.75.00, N.69.10, N.69.20, N.70.10, N.70.20, N.71.10, N.71.11, N.71.12, N.71.20, N.72.10, N.72.20, N.73.10, N.73.11, N.73.12, N.73.20, N.73.30, N.74.10, N.74.11, N.74.12, N.74.13, N.74.14, N.74.20, N.74.30, N.74.90, N.74.91, N.74.99, N.75.00, N.77.10, N.77.11, N.77.12, N.77.20, N.77.21, N.77.22, N.77.29, N.77.30, N.77.31, N.77.32, N.77.33, N.77.34, N.77.35, N.77.39, N.77.40, N.78.10, N.78.20, N.78.30, N.79.10, N.79.11, N.79.12, N.79.90, N.80.10, N.80.20, N.80.30, N.81.10, N.81.20, N.81.21, N.81.22, N.81.29, N.81.30, N.82.10, N.82.11, N.82.19, N.82.20, N.82.30, N.82.90, N.82.91, N.82.92, N.82.99, O.77.10, O.77.11, O.77.12, O.77.20, O.77.21, O.77.22, O.77.30, O.77.31, O.77.32, O.77.33, O.77.34, O.77.35, O.77.39, O.77.40, O.77.50, O.77.51, O.77.52, O.78.10, O.78.20, O.79.10, O.79.11, O.79.12, O.79.90, O.80.00, O.80.01, O.80.09, O.80.10, O.80.20, O.80.30, O.81.10, O.81.20, O.81.21, O.81.22, O.81.23, O.81.30, O.82.10, O.82.20, O.82.30, O.82.40, O.82.90, O.82.91, O.82.92, O.82.99, O.84.10, O.84.11, O.84.12, O.84.13, O.84.20, O.84.21, O.84.22, O.84.23, O.84.24, O.84.25, O.84.30, P.84.10, P.84.11, P.84.12, P.84.13, P.84.20, P.84.21, P.84.22, P.84.23, P.84.24, P.84.25, P.84.30, P.85.10, P.85.20, P.85.30, P.85.31, P.85.32, P.85.40, P.85.41, P.85.42, P.85.50, P.85.51, P.85.52, P.85.53, P.85.59, P.85.60, Q.85.10, Q.85.20, Q.85.30, Q.85.31, Q.85.32, Q.85.33, Q.85.40, Q.85.50, Q.85.51, Q.85.52, Q.85.53, Q.85.59, Q.85.60, Q.85.61, Q.85.69, Q.86.10, Q.86.20, Q.86.21, Q.86.22, Q.86.23, Q.86.90, Q.87.10, Q.87.20, Q.87.30, Q.87.90, Q.88.10, Q.88.90, Q.88.91, Q.88.99, R.86.10, R.86.20, R.86.21, R.86.22, R.86.23, R.86.90, R.86.91, R.86.92, R.86.93, R.86.94, R.86.95, R.86.96, R.86.97, R.86.99, R.87.10, R.87.20, R.87.30, R.87.90, R.87.91, R.87.99, R.88.10, R.88.90, R.88.91, R.88.99, R.90.00, R.90.01, R.90.02, R.90.03, R.90.04, R.91.01, R.91.02, R.91.03, R.91.04, R.92.00, R.93.10, R.93.11, R.93.12, R.93.13, R.93.19, R.93.20, R.93.21, R.93.29, S.90.00, S.90.10, S.90.11, S.90.12, S.90.13, S.90.20, S.90.30, S.90.31, S.90.39, S.91.10, S.91.11, S.91.12, S.91.20, S.91.21, S.91.22, S.91.30, S.91.40, S.91.41, S.91.42, S.92.00, S.93.10, S.93.11, S.93.12, S.93.13, S.93.19, S.93.20, S.93.21, S.93.29, S.94.10, S.94.11, S.94.12, S.94.20, S.94.90, S.94.91, S.94.92, S.94.99, S.95.10, S.95.11, S.95.12, S.95.20, S.95.21, S.95.22, S.95.23, S.95.24, S.95.25, S.95.29, S.96.00, S.96.01, S.96.02, S.96.03, S.96.04, S.96.09, T.94.10, T.94.11, T.94.12, T.94.20, T.94.90, T.94.91, T.94.92, T.94.99, T.95.10, T.95.20, T.95.21, T.95.22, T.95.23, T.95.24, T.95.25, T.95.29, T.95.30, T.95.31, T.95.32, T.95.40, T.96.00, T.96.10, T.96.20, T.96.21, T.96.22, T.96.23, T.96.30, T.96.40, T.96.90, T.96.91, T.96.99, T.97.00, T.98.10, T.98.20, U.97.00, U.98.10, U.98.20, U.99.00, V.99.00, |
| naics_code | North American Industry Classification System - NAICS Code | integer | - |
| name | The name of the person or legal entity to be used for display and reference purposes. | string | - |
| national_id | The unique identifier of the counterparty as established by the national authority, reported alongside the national identifier type | string | - |
| national_id_type | The type of counterparty as established by the national authority, reported alongside the national identifier | string | abn, acn, afm, alv, asf, bin, bl, bn, br, bulstat, cbcid, cc, cciaa, ceg, cf, chrty, cib, cik, cin, cn, cnpj, cnum, coe, cr, crn, cro, cui, cuit, cvr, dav, ddv, drcor, dsfn, ein, embs, fb, fin, finma, fl, fon, fsa, fsc, fsr, ft, gem, gg, gov, ibd, ico, id, ident, if, imo, inn, inv, ipf, jar, jib, k, koz, krs, kvk, lae, mat, mb, mbs, mom, nbr, nbr_entty, ncb_entty, nid, nif, nip, nis, nit, nite, notap, npwp, nsa_entty, nsi_entty, nzbn, ogrn, oib, ole, ond, org, other, pan, pf, pib, ps, rci, rcs, reg_id, regon, rfc, rg, rn, rna, rnc, rob, rsin, ruc, rut, sbn, se, sira, siren, tan, tax, tic, tin, tor, tpin, trd_rgstr, trd_rgstr_entty, trn, ucits, uic, uid, utr, vat, vkn, y, zvr, |
| national_reporting_code | Unique identifier established by the national reporting system | string | - |
| parent_id | The unique identifier for the immediate parent of the person or legal entity. | string | - |
| pd_irb | 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. | number | - |
| pd_irb_ec | 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. | number | - |
| postal_code | The post (zip) code in which the entity is domiciled. | string | - |
| relationship | Relationship to parent. | string | branch, head_office, jv, parent, parent_branch, parent_subsidiary, participation, subsidiary, |
| reporting_relationship | Relationship to reporting entity. See: relationship. | string | branch, head_office, jv, parent, parent_branch, parent_subsidiary, participation, subsidiary, |
| riad_code | RIAD code is the unique counterparty identifier for all counterparties when reported from the NCBs to the ECB; | string | - |
| risk_country_code | Two-letter country code as defined according to ISO 3166-1 plus ISO allowed, user-assignable codes (AA, QM to QZ, XA to XZ, and ZZ). | string | AA, AD, AE, AE-AJ, AE-AZ, AE-DU, AE-FU, AE-RK, AE-SH, AE-UQ, AF, AG, AI, AL, AM, AO, AQ, AR, AS, AT, AU, AW, AX, AZ, BA, BB, BD, BE, BF, BG, BH, BI, BJ, BL, BM, BN, BO, BQ, BR, BS, BT, BV, BW, BY, BZ, CA, CA-AB, CA-BC, CA-MB, CA-NB, CA-NL, CA-NS, CA-NT, CA-NU, CA-ON, CA-PE, CA-QC, CA-SK, CA-YT, CC, CD, CF, CG, CH, CI, CK, CL, CM, CN, CO, CR, CU, CV, CW, CX, CY, CZ, DE, DJ, DK, DM, DO, DZ, EC, EE, EG, EH, ER, ES, ET, FI, FJ, FK, FM, FO, FR, GA, GB, GD, GE, GF, GG, GH, GI, GL, GM, GN, GP, GQ, GR, GS, GT, GU, GW, GY, HK, HM, HN, HR, HT, HU, ID, IE, IL, IM, IN, IO, IQ, IR, IS, IT, JE, JM, JO, JP, KE, KG, KH, KI, KM, KN, KP, KR, KW, KY, KZ, LA, LB, LC, LI, LK, LR, LS, LT, LU, LV, LY, MA, MC, MD, ME, MF, MG, MH, MK, ML, MM, MN, MO, MP, MQ, MR, MS, MT, MU, MV, MW, MX, MY, MZ, NA, NC, NE, NF, NG, NI, NL, NO, NP, NR, NU, NZ, OM, PA, PE, PF, PG, PH, PK, PL, PM, PN, PR, PS, PT, PW, PY, QA, QM, QN, QO, QP, QQ, QR, QS, QT, QU, QV, QW, QX, QY, QZ, RE, RO, RS, RU, RW, SA, SB, SC, SD, SE, SG, SH, SI, SJ, SK, SL, SM, SN, SO, SR, SS, ST, SV, SX, SY, SZ, TC, TD, TF, TG, TH, TJ, TK, TL, TM, TN, TO, TR, TT, TV, TW, TZ, UA, UG, UM, US, US-AK, US-AL, US-AR, US-AZ, US-CA, US-CO, US-CT, US-DC, US-DE, US-FL, US-GA, US-HI, US-IA, US-ID, US-IL, US-IN, US-KS, US-KY, US-LA, US-MA, US-MD, US-ME, US-MI, US-MN, US-MO, US-MS, US-MT, US-NC, US-ND, US-NE, US-NH, US-NJ, US-NM, US-NV, US-NY, US-OH, US-OK, US-OR, US-PA, US-RI, US-SC, US-SD, US-TN, US-TX, US-UT, US-VA, US-VT, US-WA, US-WI, US-WV, US-WY, UY, UZ, VA, VC, VE, VG, VI, VN, VU, WF, WS, XA, XB, XC, XD, XE, XF, XG, XH, XI, XJ, XK, XL, XM, XN, XO, XP, XQ, XR, XS, XT, XU, XV, XW, XX, XY, XZ, YE, YT, ZA, ZM, ZW, ZZ, |
| risk_group_id | The unique identifier for the group representing a single risk entity where no relationship of control exists | string | - |
| risk_group_id_2 | The secondary identifier for the secondary group representing a single risk entity where no relationship of control exists | string | - |
| scra | Grade calculated using the Basel Standardised Credit Risk Assessment | string | a, a_plus, b, c, |
| sic_code | Standard Industrial Classification (SIC) system. The applicable reference depends on jurisdiction. | integer | - |
| snp_lt | S&P long term credit ratings | string | aaa, aa_plus, aa, aa_minus, a_plus, a, a_minus, bbb_plus, bbb, bbb_minus, bb_plus, bb, bb_minus, b_plus, b, b_minus, ccc_plus, ccc, ccc_minus, cc, c, d, |
| snp_st | S&P short term credit ratings | string | a1, a2, a3, b, c, d, |
| source | 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 | string | - |
| ssic_code | The Singaporean standard industry and sector classification. | integer | - |
| total_assets | The annual balance sheet total of the entity as at the last accounting reference date. | integer | - |
| turnover | The annual turnover of the entity as at the last accounting reference date. | integer | - |
| type | The designated financial or legal entity category this person or legal entity falls under | string | building_society, ccp, central_bank, central_govt, charity, ciu, community_charity, corporate, credit_institution, credit_union, deposit_broker, export_credit_agency, federal_credit_union, financial, financial_holding, fund, hedge_fund, housing_coop, individual, insurer, intl_org, investment_firm, local_authority, mdb, medium_sme, micro_sme, mmkt_fund, national_bank, natural_person, non_member_bank, other, other_financial, other_pse, partnership, pension_fund, pic, pmi, private_equity_fund, private_fund, promo_fed_home_loan, promo_fed_reserve, promotional_lender, property_spe, pse, public_corporation, qccp, real_estate_fund, regional_govt, small_sme, sme, social_housing_entity, social_security_fund, sovereign, sspe, state_credit_union, state_member_bank, state_owned_bank, statutory_board, supported_sme, unincorp_inv_fund, unincorporated_biz, unregulated_financial, |
| ultimate_parent_id | The unique identifier for the ultimate parent of the person or legal entity. | string | - |
| version_id | The version identifier of the data such as the firm’s internal batch identifier. | string | - |