layouttitle
schemacustomer

Customer Schema


Data schema to define a customer or legal entity related to a financial product or transaction.

Properties

NameDescriptionTypeEnum
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-
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
AAADAEAE-AJAE-AZAE-DUAE-FUAE-RKAE-SHAE-UQAFAGAIALAMAOAQARASATAUAWAXAZBABBBDBEBFBGBHBIBJBLBMBNBOBQBRBSBTBVBWBYBZCACA-ABCA-BCCA-MBCA-NBCA-NLCA-NSCA-NTCA-NUCA-ONCA-PECA-QCCA-SKCA-YTCCCDCFCGCHCICKCLCMCNCOCRCUCVCWCXCYCZDEDJDKDMDODZECEEEGEHERESETFIFJFKFMFOFRGAGBGDGEGFGGGHGIGLGMGNGPGQGRGSGTGUGWGYHKHMHNHRHTHUIDIEILIMINIOIQIRISITJEJMJOJPKEKGKHKIKMKNKPKRKWKYKZLALBLCLILKLRLSLTLULVLYMAMCMDMEMFMGMHMKMLMMMNMOMPMQMRMSMTMUMVMWMXMYMZNANCNENFNGNINLNONPNRNUNZOMPAPEPFPGPHPKPLPMPNPRPSPTPWPYQAQMQNQOQPQQQRQSQTQUQVQWQXQYQZRERORSRURWSASBSCSDSESGSHSISJSKSLSMSNSOSRSSSTSVSXSYSZTCTDTFTGTHTJTKTLTMTNTOTRTTTVTWTZUAUGUMUSUYUZVAVCVEVGVIVNVUWFWSXAXBXCXDXEXFXGXHXIXJXKXLXMXNXOXPXQXRXSXTXUXVXWXXXYXZYEYTZAZMZWZZ
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
AEDAFNALLAMDANGAOAARSAUDAWGAZNBAMBBDBDTBGNBHDBIFBMDBNDBOBBOVBRLBSDBTNBWPBYNBZDCADCDFCHECHFCHWCLFCLPCNHCNYCOPCOUCRCCUCCUPCVECZKDJFDKKDOPDZDEGPERNETBEURFJDFKPGBPGELGHSGIPGMDGNFGTQGYDHKDHNLHRKHTGHUFIDRILSINRIQDIRRISKJMDJODJPYKESKGSKHRKMFKPWKRWKWDKYDKZTLAKLBPLKRLRDLSLLYDMADMDLMGAMKDMMKMNTMOPMRUMURMVRMWKMXNMXVMYRMZNNADNGNNIONOKNPRNZDOMRPABPENPGKPHPPKRPLNPYGQARRONRSDRUBRWFSARSBDSCRSDGSEKSGDSHPSLLSOSSRDSSPSTNSYPSZLTHBTJSTMTTNDTOPTRYTTDTWDTZSUAHUGXUSDUSNUSSUYIUYUUYWUZSVESVNDVUVWSTXAFXAGXAUXBAXBBXBCXBDXCDXDRXOFXPDXPFXPTXSUXTSXUAXXXYERZARZMW
dbrs_lt
DBRS long term credit ratings
string
aaaaa_haaaa_la_haa_lbbb_hbbbbbb_lbb_hbbbb_lb_hbb_lccc_hcccccc_lcccd
dbrs_st
DBRS short term credit ratings
string
r1_hr1_mr1_lr2_hr2_mr2_lr3r4r5d
fitch_lt
Fitch long term credit ratings
string
aaaaa_plusaaaa_minusa_plusaa_minusbbb_plusbbbbbb_minusbb_plusbbbb_minusb_plusbb_minusccc_pluscccccc_minuscccrdd
fitch_st
Fitch short term credit ratings
string
f1_plusf1f2f3bcrdd
headcount
The number of full time staff.
integer-
internal_rating
Categorization of unrated exposure
string
investmentnon_investment
intra_group
Flag to indicate that this should be considered an intra-group entity.
boolean-
kbra_lt
KBRA long term credit ratings
string
aaaaa_plusaaaa_minusa_plusaa_minusbbb_plusbbbbbb_minusbb_plusbbbb_minusb_plusbb_minusccc_pluscccccc_minuscccd
kbra_st
KBRA short term credit ratings
string
k1_plusk1k2k3bcd
legal_entity_name
The official legal name of the entity.
string-
lei_code
The LEI code for the legal entity (for corporates).
string-
lgd_irb
The loss given default as determined by internal rating-based methods, represented as a number between 0 and 1.
number-
moodys_lt
Moody’s long term credit ratings
string
aaaaa1aa2aa3a1a2a3baa1baa2baa3ba1ba2ba3b1b2b3caa1caa2caa3cac
moodys_st
Moodys short term credit ratings
string
p1p2p3np
nace_code
The EU NACE economic activity classification.
string
A.01.10A.01.11A.01.12A.01.13A.01.14A.01.15A.01.16A.01.19A.01.20A.01.21A.01.22A.01.23A.01.24A.01.25A.01.26A.01.27A.01.28A.01.29A.01.30A.01.40A.01.41A.01.42A.01.43A.01.44A.01.45A.01.46A.01.47A.01.49A.01.50A.01.60A.01.61A.01.62A.01.63A.01.64A.01.70A.02.10A.02.20A.02.30A.02.40A.03.10A.03.11A.03.12A.03.20A.03.21A.03.22B.05.10B.05.20B.06.10B.06.20B.07.10B.07.20B.07.21B.07.29B.08.10B.08.11B.08.12B.08.90B.08.91B.08.92B.08.93B.08.99B.09.10B.09.90C.10.10C.10.11C.10.12C.10.13C.10.20C.10.30C.10.31C.10.32C.10.39C.10.40C.10.41C.10.42C.10.50C.10.51C.10.52C.10.60C.10.61C.10.62C.10.70C.10.71C.10.72C.10.73C.10.80C.10.81C.10.82C.10.83C.10.84C.10.85C.10.86C.10.89C.10.90C.10.91C.10.92C.11.00C.11.01C.11.02C.11.03C.11.04C.11.05C.11.06C.11.07C.12.00C.13.10C.13.20C.13.30C.13.90C.13.91C.13.92C.13.93C.13.94C.13.95C.13.96C.13.99C.14.10C.14.11C.14.12C.14.13C.14.14C.14.19C.14.20C.14.30C.14.31C.14.39C.15.10C.15.11C.15.12C.15.20C.16.10C.16.20C.16.21C.16.22C.16.23C.16.24C.16.29C.17.10C.17.11C.17.12C.17.20C.17.21C.17.22C.17.24C.17.29C.17.30C.18.10C.18.11C.18.12C.18.13C.18.14C.18.20C.19.10C.19.20C.20.10C.20.11C.20.12C.20.13C.20.14C.20.15C.20.16C.20.17C.20.20C.20.30C.20.40C.20.41C.20.42C.20.50C.20.51C.20.52C.20.53C.20.59C.20.60C.21.10C.21.20C.22.10C.22.11C.22.19C.22.20C.22.21C.22.22C.22.23C.22.29C.23.10C.23.11C.23.12C.23.13C.23.14C.23.19C.23.20C.23.30C.23.31C.23.32C.23.40C.23.41C.23.42C.23.43C.23.44C.23.49C.23.50C.23.51C.23.52C.23.60C.23.61C.23.62C.23.63C.23.64C.23.65C.23.69C.23.70C.23.90C.23.91C.23.99C.24.10C.24.20C.24.30C.24.31C.24.32C.24.33C.24.34C.24.40C.24.41C.24.42C.24.43C.24.44C.24.45C.24.46C.24.50C.24.51C.24.52C.24.53C.24.54C.25.10C.25.11C.25.12C.25.20C.25.21C.25.29C.25.30C.25.40C.25.50C.25.60C.25.61C.25.62C.25.70C.25.71C.25.72C.25.73C.25.90C.25.91C.25.92C.25.93C.25.94C.25.99C.26.10C.26.11C.26.12C.26.20C.26.30C.26.40C.26.50C.26.51C.26.52C.26.60C.26.70C.26.80C.27.10C.27.11C.27.12C.27.20C.27.30C.27.31C.27.32C.27.33C.27.40C.27.50C.27.51C.27.52C.27.90C.28.10C.28.11C.28.12C.28.13C.28.14C.28.15C.28.20C.28.21C.28.22C.28.23C.28.24C.28.25C.28.29C.28.30C.28.40C.28.41C.28.49C.28.90C.28.91C.28.92C.28.93C.28.94C.28.95C.28.96C.28.99C.29.10C.29.20C.29.30C.29.31C.29.32C.30.10C.30.11C.30.12C.30.20C.30.30C.30.40C.30.90C.30.91C.30.92C.30.99C.31.00C.31.01C.31.02C.31.03C.31.09C.32.10C.32.11C.32.12C.32.13C.32.20C.32.30C.32.40C.32.50C.32.90C.32.91C.32.99C.33.10C.33.11C.33.12C.33.13C.33.14C.33.15C.33.16C.33.17C.33.19C.33.20D.35.10D.35.11D.35.12D.35.13D.35.14D.35.20D.35.21D.35.22D.35.23D.35.30E.36.00E.37.00E.38.10E.38.11E.38.12E.38.20E.38.21E.38.22E.38.30E.38.31E.38.32E.39.00F.41.10F.41.20F.42.10F.42.11F.42.12F.42.13F.42.20F.42.21F.42.22F.42.90F.42.91F.42.99F.43.10F.43.11F.43.12F.43.13F.43.20F.43.21F.43.22F.43.29F.43.30F.43.31F.43.32F.43.33F.43.34F.43.39F.43.90F.43.91F.43.99G.45.10G.45.11G.45.19G.45.20G.45.30G.45.31G.45.32G.45.40G.46.10G.46.11G.46.12G.46.13G.46.14G.46.15G.46.16G.46.17G.46.18G.46.19G.46.20G.46.21G.46.22G.46.23G.46.24G.46.30G.46.31G.46.32G.46.33G.46.34G.46.35G.46.36G.46.37G.46.38G.46.39G.46.40G.46.41G.46.42G.46.43G.46.44G.46.45G.46.46G.46.47G.46.48G.46.49G.46.50G.46.51G.46.52G.46.60G.46.61G.46.62G.46.63G.46.64G.46.65G.46.66G.46.69G.46.70G.46.71G.46.72G.46.73G.46.74G.46.75G.46.76G.46.77G.46.90G.47.10G.47.11G.47.19G.47.20G.47.21G.47.22G.47.23G.47.24G.47.25G.47.26G.47.29G.47.30G.47.40G.47.41G.47.42G.47.43G.47.50G.47.51G.47.52G.47.53G.47.54G.47.59G.47.60G.47.61G.47.62G.47.63G.47.64G.47.65G.47.70G.47.71G.47.72G.47.73G.47.74G.47.75G.47.76G.47.77G.47.78G.47.79G.47.80G.47.81G.47.82G.47.89G.47.90G.47.91G.47.99H.49.10H.49.20H.49.30H.49.31H.49.32H.49.39H.49.40H.49.41H.49.42H.49.50H.50.10H.50.20H.50.30H.50.40H.51.10H.51.20H.51.21H.51.22H.52.10H.52.20H.52.21H.52.22H.52.23H.52.24H.52.29H.53.10H.53.20I.55.10I.55.20I.55.30I.55.90I.56.10I.56.20I.56.21I.56.29I.56.30J.58.10J.58.11J.58.12J.58.13J.58.14J.58.19J.58.20J.58.21J.58.29J.59.10J.59.11J.59.12J.59.13J.59.14J.59.20J.60.10J.60.20J.61.10J.61.20J.61.30J.61.90J.62.00J.62.01J.62.02J.62.03J.62.09J.63.10J.63.11J.63.12J.63.90J.63.91J.63.99K.64.10K.64.11K.64.19K.64.20K.64.30K.64.90K.64.91K.64.92K.64.99K.65.10K.65.11K.65.12K.65.20K.65.30K.66.10K.66.11K.66.12K.66.19K.66.20K.66.21K.66.22K.66.29K.66.30L.68.10L.68.20L.68.30L.68.31L.68.32M.69.10M.69.20M.70.10M.70.20M.70.21M.70.22M.71.10M.71.11M.71.12M.71.20M.72.10M.72.11M.72.19M.72.20M.73.10M.73.11M.73.12M.73.20M.74.10M.74.20M.74.30M.74.90M.75.00N.77.10N.77.11N.77.12N.77.20N.77.21N.77.22N.77.29N.77.30N.77.31N.77.32N.77.33N.77.34N.77.35N.77.39N.77.40N.78.10N.78.20N.78.30N.79.10N.79.11N.79.12N.79.90N.80.10N.80.20N.80.30N.81.10N.81.20N.81.21N.81.22N.81.29N.81.30N.82.10N.82.11N.82.19N.82.20N.82.30N.82.90N.82.91N.82.92N.82.99O.84.10O.84.11O.84.12O.84.13O.84.20O.84.21O.84.22O.84.23O.84.24O.84.25O.84.30P.85.10P.85.20P.85.30P.85.31P.85.32P.85.40P.85.41P.85.42P.85.50P.85.51P.85.52P.85.53P.85.59P.85.60Q.86.10Q.86.20Q.86.21Q.86.22Q.86.23Q.86.90Q.87.10Q.87.20Q.87.30Q.87.90Q.88.10Q.88.90Q.88.91Q.88.99R.90.00R.90.01R.90.02R.90.03R.90.04R.91.01R.91.02R.91.03R.91.04R.92.00R.93.10R.93.11R.93.12R.93.13R.93.19R.93.20R.93.21R.93.29S.94.10S.94.11S.94.12S.94.20S.94.90S.94.91S.94.92S.94.99S.95.10S.95.11S.95.12S.95.20S.95.21S.95.22S.95.23S.95.24S.95.25S.95.29S.96.00S.96.01S.96.02S.96.03S.96.04S.96.09T.97.00T.98.10T.98.20U.99.00
name
The name of the person or legal entity to be used for display and reference purposes.
string-
national_reporting_code
Unique identifier established by the national reporting system
string-
parent_id
The unique identifier for the ultimate parent of the person or legal entity.
string-
pd_irb
The probability of default as determined by internal rating-based methods, represented as a number between 0 and 1.
number-
relationship
Relationship to parent.
string
branchhead_officejvparentparent_branchparent_subsidiaryparticipationsubsidiary
reporting_relationship
Relationship to reporting entity. See: relationship.
string
branchhead_officejvparentparent_branchparent_subsidiaryparticipationsubsidiary
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
AAADAEAE-AJAE-AZAE-DUAE-FUAE-RKAE-SHAE-UQAFAGAIALAMAOAQARASATAUAWAXAZBABBBDBEBFBGBHBIBJBLBMBNBOBQBRBSBTBVBWBYBZCACA-ABCA-BCCA-MBCA-NBCA-NLCA-NSCA-NTCA-NUCA-ONCA-PECA-QCCA-SKCA-YTCCCDCFCGCHCICKCLCMCNCOCRCUCVCWCXCYCZDEDJDKDMDODZECEEEGEHERESETFIFJFKFMFOFRGAGBGDGEGFGGGHGIGLGMGNGPGQGRGSGTGUGWGYHKHMHNHRHTHUIDIEILIMINIOIQIRISITJEJMJOJPKEKGKHKIKMKNKPKRKWKYKZLALBLCLILKLRLSLTLULVLYMAMCMDMEMFMGMHMKMLMMMNMOMPMQMRMSMTMUMVMWMXMYMZNANCNENFNGNINLNONPNRNUNZOMPAPEPFPGPHPKPLPMPNPRPSPTPWPYQAQMQNQOQPQQQRQSQTQUQVQWQXQYQZRERORSRURWSASBSCSDSESGSHSISJSKSLSMSNSOSRSSSTSVSXSYSZTCTDTFTGTHTJTKTLTMTNTOTRTTTVTWTZUAUGUMUSUYUZVAVCVEVGVIVNVUWFWSXAXBXCXDXEXFXGXHXIXJXKXLXMXNXOXPXQXRXSXTXUXVXWXXXYXZYEYTZAZMZWZZ
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-
sic_code
The UK SIC 2007 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-
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_societyccpcentral_bankcentral_govtcharityciucommunity_charitycorporatecredit_institutioncredit_uniondeposit_brokerexport_credit_agencyfinancialfinancial_holdingfundhedge_fundindividualinsurerintl_orginvestment_firmlocal_authoritymdbmmkt_fundnatural_personotherother_financialother_psepartnershippension_fundpicpmiprivate_equity_fundprivate_fundpromo_fed_home_loanpromo_fed_reservepromotional_lenderpsepublic_corporationqccpreal_estate_fundregional_govtsmesocial_security_fundsovereignsspestate_owned_bankstatutory_boardsupported_smeunincorporated_bizunregulated_financial
version_id
The version identifier of the data such as the firm’s internal batch identifier.
string-
annual_debit_turnover
The annual debit turnover in the business account of the entity. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
clearing_threshold
Status of the clearing threshold as defined in EMIR
string
abovebelow
df_ccp
The pre-funded financial resources of the CCP in accordance with Article 50c of Regulation (EU) No 648/2012
integer-
df_cm
The sum of pre-funded contributions of all clearing members of the QCCP in accordance with Article 50c of Regulation (EU) No 648/2012.
integer-
incurred_cva
The amount of credit valuation adjustements being recognised by the institution as an incurred write-down, calculated without taking into account any offsetting debit value adjustment attributed to the firm’s own credit risk, that has been already excluded from own funds.
integer-
k_ccp
Hypothetical capital of the QCCP in accordance with Article 50c of Regulation (EU) No 648/2012
integer-
product_count
The number of active products/trades this customer has with the firm.
integer-
risk_profile
The evaluation of the customer’s willingness and/or capacity to take on financial risk.
integer-
start_date
The date that the customer first became a customer. YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
status
The status of the relationship with the customer from the firm’s point of view.
string
established