layouttitle
schemaguarantor

Guarantor Schema


Data schema to define a guarantor for a security.

Properties

NameDescriptionTypeEnum
id
The unique identifier for the person or legal entity within the financial institution.
string-
date
YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
address_city
City, town or village.
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
Data schema to define a guarantor for a security.
string
AFAXALDZASADAOAIAQAGARAMAWAUATAZBSBHBDBBBYBEBZBJBMBTBOBQBABWBVBRIOBNBGBFBICVKHCMCAKYCFTDCLCNCXCCCOKMCGCDCKCRCIHRCUCWCYCZDKDJDMDOECEGSVGQEREEETFKFOFJFIFRGFPFTFGAGMGEDEGHGIGRGLGDGPGUGTGGGNGWGYHTHMVAHNHKHUISINIDIRIQIEIMILITJMJPJEJOKZKEKIKPKRKWKGLALVLBLSLRLYLILTLUMOMKMGMWMYMVMLMTMHMQMRMUYTMXFMMDMCMNMEMSMAMZMMNANRNPNLNCNZNINENGNUNFMPNOOMPKPWPSPAPGPYPEPHPNPLPTPRQARERORURWBLSHKNLCMFPMVCWSSMSTSASNRSSCSLSGSXSKSISBSOZAGSSSESLKSDSRSJSZSECHSYTWTJTZTHTLTGTKTOTTTNTRTMTCTVUGUAAEGBUSUMUYUZVUVEVNVGVIWFEHYEZMZWAAQMQNQOQPQQQRQSQTQUQVQWQXQYQZXAXBXCXDXEXFXGXHXIXJXKXLXMXNXOXPXQXRXSXTXUXVXWXXXYXZZZ
credit_impaired
Flag to determine if the entity credit quality is impaired.
boolean-
cqs_standardised
The credit quality step for standardised approach.
integer-
cqs_irb
The credit quality step for internal ratings based approach.
integer-
fitch_lt
Fitch long term credit ratings
string
aaaaa_plusaaaa_minusa_plusaa_minusbbb_plusbbbbbb_minusbb_plusbbbb_minusb_plusbb_minusccc_pluscccccc_minuscccd
fitch_st
Fitch short term credit ratings
string
f1_plusf1f2f3bcd
intra_group
Flag to indicate that this should be considered an intra-group entity.
boolean-
lei_code
The LEI code for the legal entity (for corporates).
string-
legal_entity_name
The official legal name of the entity.
string-
moodys_lt
Moody’s long term credit ratings
string
aaaaa1aa2aa3a1a2a3baa1baa2baa3ba1ba2ba3b1b2b3caa1caa2caa3cac
moodys_st
Moodys short term credit ratings
string
p1p2p3np
name
The name of the person or legal entity to be used for display and reference purposes.
string-
parent_id
The unique identifier for the ultimate parent of the person or legal entity.
string-
relationship
Relationship to parent.
string
jvbranchsubsidiaryparenthead_officeparent_subsidiaryparent_branch
reporting_relationship
Relationship to reporting entity. See: relationship.
string
jvbranchsubsidiaryparenthead_officeparent_subsidiaryparent_branch
risk_group_id
The unique identifier for the group representing a single risk entity where no relationship of control exists
string-
risk_country_code
Data schema to define a guarantor for a security.
string
AFAXALDZASADAOAIAQAGARAMAWAUATAZBSBHBDBBBYBEBZBJBMBTBOBQBABWBVBRIOBNBGBFBICVKHCMCAKYCFTDCLCNCXCCCOKMCGCDCKCRCIHRCUCWCYCZDKDJDMDOECEGSVGQEREEETFKFOFJFIFRGFPFTFGAGMGEDEGHGIGRGLGDGPGUGTGGGNGWGYHTHMVAHNHKHUISINIDIRIQIEIMILITJMJPJEJOKZKEKIKPKRKWKGLALVLBLSLRLYLILTLUMOMKMGMWMYMVMLMTMHMQMRMUYTMXFMMDMCMNMEMSMAMZMMNANRNPNLNCNZNINENGNUNFMPNOOMPKPWPSPAPGPYPEPHPNPLPTPRQARERORURWBLSHKNLCMFPMVCWSSMSTSASNRSSCSLSGSXSKSISBSOZAGSSSESLKSDSRSJSZSECHSYTWTJTZTHTLTGTKTOTTTNTRTMTCTVUGUAAEGBUSUMUYUZVUVEVNVGVIWFEHYEZMZWAAQMQNQOQPQQQRQSQTQUQVQWQXQYQZXAXBXCXDXEXFXGXHXIXJXKXLXMXNXOXPXQXRXSXTXUXVXWXXXYXZZZ
sic_code
The UK SIC 2007 standard industry and sector classification.
integer-
ssic_code
The Singaporean standard industry and sector classification.
integer-
snp_lt
S&P long term credit ratings
string
aaaaa_plusaaaa_minusa_plusaa_minusbbb_plusbbbbbb_minusbb_plusbbbb_minusb_plusbb_minusccc_pluscccccc_minuscccd
snp_st
S&P short term credit ratings
string
a1a2a3bcd
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-
type
The designated financial or legal entity category this person or legal entity falls under
string
individualnatural_personpartnershipcorporatesmesupported_smecredit_unioncharitycommunity_charityfinancialcredit_institutionpromotional_lenderstate_owned_bankinvestment_firmmmkt_fundpension_funddeposit_brokerinsurerfinancial_holdingother_financialpsecentral_govtregional_govtlocal_authoritystatutory_boardother_psesovereignintl_orgcentral_bankmdbsspeciupicccpqccpother
version_id
The version identifier of the data such as the firm’s internal batch identifier.
string-
national_reporting_code
Unique identifier established by the national reporting system
string-