layouttitle
schemaaccount

Account Extended Schema


Extended account schema containing all jurisdiction-specific extensions.

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-
acc_fv_change_before_taxes
Accumulated change in fair value before taxes.
integer-
accounting_treatment
The accounting treatment in accordance with IAS/IFRS9 accounting principles.
string
amortised_costavailable_for_salecb_or_demanddeed_in_lieufv_mandatorilyfv_ocifv_thru_pnlheld_for_hedgeheld_for_investheld_for_invest_fvoheld_for_saleheld_for_tradingheld_to_maturityloans_and_recsntnd_cost_basedntnd_fv_equityntnd_fv_plother_gaaptrading_gaap
accrued_interest
The accrued interest since the last payment date and due at the next payment date. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
arrears_balance
The balance of the capital amount that is considered to be in arrears (for overdrafts/credit cards). Monetary type represented as a naturally positive integer number of cents/pence.
integer-
asset_liability
Is the data an asset, a liability, or equity on the firm’s balance sheet?
string
assetequityliabilityocipnl
balance
The contractual balance on the date and in the currency given. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
base_rate
The base rate represents the basis of the rate on the balance at the given date as agreed in the terms of the account.
string
FDTRUKBRBASEZERO
behavioral_curve_id
The unique identifier for the behavioral curve used by the financial institution.
string-
behavioral_end_date
Behavioral end date (as opposed to contractual). YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601
string-
break_dates
Dates where this contract can be broken (by either party). Formatted as YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
array-
call_dates
Dates where this contract can be called (by the customer). Formatted as YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
array-
capital_tier
The capital tiers based on own funds requirements.
string
add_tier_1anc_tier_2anc_tier_3at1_grandfatheredbas_tier_2bas_tier_3ce_tier_1cet1_grandfatheredt2_grandfatheredtier_1tier_2tier_3
ccf
The credit conversion factor that indicates the proportion of the undrawn amount that would be drawn down on default.
number-
commission
Commission percentage to be added onto interest rate of the product to calculate the credit spread at inception of receiving the deposit.
integer-
cost_center_code
The organizational unit or sub-unit to which costs/profits are booked.
string-
count
Describes the number of accounts aggregated into a single row.
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-YTCCCDCFCGCHCICKCLCMCNCOCRCUCVCWCXCYCZDEDJDKDMDODZECEEEGEHERESETFIFJFKFMFOFRGAGBGDGEGFGGGHGIGLGMGNGPGQGRGSGTGUGWGYHKHMHNHRHTHUIDIEILIMINIOIQIRISITJEJMJOJPKEKGKHKIKMKNKPKRKWKYKZLALBLCLILKLRLSLTLULVLYMAMCMDMEMFMGMHMKMLMMMNMOMPMQMRMSMTMUMVMWMXMYMZNANCNENFNGNINLNONPNRNUNZOMPAPEPFPGPHPKPLPMPNPRPSPTPWPYQAQMQNQOQPQQQRQSQTQUQVQWQXQYQZRERORSRURWSASBSCSDSESGSHSISJSKSLSMSNSOSRSSSTSVSXSYSZTCTDTFTGTHTJTKTLTMTNTOTRTTTVTWTZUAUGUMUSUS-AKUS-ALUS-ARUS-AZUS-CAUS-COUS-CTUS-DCUS-DEUS-FLUS-GAUS-HIUS-IAUS-IDUS-ILUS-INUS-KSUS-KYUS-LAUS-MAUS-MDUS-MEUS-MIUS-MNUS-MOUS-MSUS-MTUS-NCUS-NDUS-NEUS-NHUS-NJUS-NMUS-NVUS-NYUS-OHUS-OKUS-ORUS-PAUS-RIUS-SCUS-SDUS-TNUS-TXUS-UTUS-VAUS-VTUS-WAUS-WIUS-WVUS-WYUYUZVAVCVEVGVIVNVUWFWSXAXBXCXDXEXFXGXHXIXJXKXLXMXNXOXPXQXRXSXTXUXVXWXXXYXZYEYTZAZMZWZZ
cr_approach
Specifies the approved credit risk rwa calculation approach to be applied to the exposure.
string
airbeif_fbeif_lteif_mbafirbsec_erbasec_sasec_sa_ltstd
cum_write_offs
The portion of the loan which has been written off.
integer-
currency_code
Currency in accordance with ISO 4217 standards plus CNH for practical considerations.
string
AEDAFNALLAMDANGAOAARSAUDAWGAZNBAMBBDBDTBGNBHDBIFBMDBNDBOBBOVBRLBSDBTNBWPBYNBZDCADCDFCHECHFCHWCLFCLPCNHCNYCOPCOUCRCCUCCUPCVECZKDJFDKKDOPDZDEGPERNETBEURFJDFKPGBPGELGHSGIPGMDGNFGTQGYDHKDHNLHRKHTGHUFIDRILSINRIQDIRRISKJMDJODJPYKESKGSKHRKMFKPWKRWKWDKYDKZTLAKLBPLKRLRDLSLLYDMADMDLMGAMKDMMKMNTMOPMRUMURMVRMWKMXNMXVMYRMZNNADNGNNIONOKNPRNZDOMRPABPENPGKPHPPKRPLNPYGQARRONRSDRUBRWFSARSBDSCRSDGSEKSGDSHPSLESLLSOSSRDSSPSTNSYPSZLTHBTJSTMTTNDTOPTRYTTDTWDTZSUAHUGXUSDUSNUSSUYIUYUUYWUZSVEDVESVNDVUVWSTXADXAFXAGXAUXBAXBBXBCXBDXCDXCGXDRXOFXPDXPFXPTXSUXTSXUAXXXYERZARZMWZWG
customer_id
The unique identifier used by the financial institution to identify the customer that owns the account.
string-
day_count_convention
The methodology for calculating the number of days between two dates. It is used to calculate the amount of accrued interest or the present value.
string
act_360act_365act_actstd_30_360std_30_365
default_date
Date of default.
string-
ead
The EAD field allows users to input monetary exposure-at-default values across the loan’s lifecycle. Upon default, this field must be updated to reflect the final realised EAD value — that is, the actual exposure outstanding at the moment of default.
integer-
ead_irb_ec
The expected gross dollar exposure for each facility upon a borrower’s default as determined by internal ratings-based approach. This value is used in economic capital calculations.
integer-
economic_loss
The definition of loss, used in estimating Loss Given Default for the reporting segment. When measuring economic loss, as opposed to accounting loss
integer-
encumbrance_amount
The amount of the account that is encumbered by potential future commitments or legal liabilities. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
encumbrance_type
The type of the encumbrance causing the encumbrance_amount.
string
covered_bondderivativenoneotherrepo
end_date
The end or maturity date of the account. Format should be YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601
string-
facility_id
The code assigned by the financial institution to identify a facility.
string-
first_arrears_date
The first date on which this account was in arrears.
string-
first_payment_date
The first payment date for interest payments.
string-
forbearance_date
The date on which the first forbearance measure was granted to this product. Format should be YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601
string-
fraud_loss
The total value of accounting losses incurred by the Financial Institution due to fraudulent activities within the reporting segment.
integer-
frr_id
The internal facility risk rating assigned to a facility based on its specific risk characteristics, including collateral and seniority.
string-
fvh_level
Fair value hierarchy category according to IFRS 13.93 (b)
integer-
guarantee_amount
The amount of the account that is guaranteed under a Government Deposit Guarantee Scheme. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
guarantee_scheme
The Government Deposit Scheme scheme under which the guarantee_amount is guaranteed.
string
be_pfbg_difca_cdiccy_dpscz_difde_edbde_edode_edwdk_gdfiee_dgses_fgdfi_dgffr_fdggb_fscsgr_dgshk_dpshr_dihu_ndifie_dgsit_fitdlt_vilu_fgdllv_dgfmt_dcsnl_dgspl_bfgpt_fgdro_fgdbse_ndosi_dgssk_dpfus_fdic
impairment_amount
The impairment amount is the allowance set aside by the firm that accounts for the event that the asset becomes impaired in the future.
integer-
impairment_date
The date upon which the product became considered impaired. Format should be YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601
string-
impairment_status
The recognition stage for the impairment/expected credit loss of the product.
string
doubtfulin_litigationlossnon_performingnormalperformingpre_litigationstage_1stage_1_doubtfulstage_1_lossstage_1_normalstage_1_substandardstage_1_watchstage_2stage_2_doubtfulstage_2_lossstage_2_normalstage_2_substandardstage_2_watchstage_3stage_3_doubtfulstage_3_lossstage_3_normalstage_3_substandardstage_3_watchsubstandardwatch
impairment_type
The loss event resulting in the impairment of the loan.
string
collectiveindividualwrite_off
insolvency_rank
The insolvency ranking as per the national legal framework of the reporting institution.
integer-
int_reset_freq
The adjustable rate periodic interest reset period. Denominated in whole multiples of the interest_repayment_frequency. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
interest_repayment_frequency
Repayment frequency of the interest.
string
dailyweeklybi_weeklymonthlybi_monthlyquarterlysemi_annuallyannuallyat_maturitybienniallysesquiennially
last_drawdown_date
The last date on which a drawdown was made on this account (overdraft).
string-
last_payment_date
The final payment date for interest payments, often coincides with end_date.
string-
last_recovery_date
Date of most recent recovery in the reporting quarter.
string-
last_write_off_date
Date of Financial Institution’s most recent Write Off in the reporting quarter.
string-
ledger_code
The internal ledger code or line item name.
string-
lgd_floored
The final LGD value after the relevant floors have been applied. To be used in the IRB RWA calculations.
number-
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-
lgd_irb_ec
The loss given 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-
limit_amount
The minimum balance the customer can go overdrawn in their account.
integer-
min_interest_repayment
The minimum interest on outstanding balance and fees that customers are due to repay.
integer-
min_principal_repayment
The minimum principal balance that customers are due to repay.
integer-
minimum_balance
Indicates the minimum balance of each account within the aggregate. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
minimum_balance_eur
Indicates the minimum balance, in Euros, of each account within the aggregate. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
mna_id
The unique identifier of the Master Netting Agreement the account falls under. Typically used where a legally enforceable right to offset exists and where the reporting entity intends to settle on a net basis.
string-
mtd_deposits
Month to date amount deposited within the account as a naturally positive integer number of cents/pence.
integer-
mtd_interest_paid
Month to date interest added to account as a naturally positive integer number of cents/pence.
integer-
mtd_withdrawals
Month to date amount withdrawn from the account as a naturally positive integer number of cents/pence.
integer-
next_payment_date
The next date at which interest will be paid or accrued_interest balance returned to zero.
string-
next_repricing_date
The date on which the interest rate of the account will be re-calculated. YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
next_withdrawal_date
The next date at which customer is allowed to withdraw money from this account.
string-
on_balance_sheet
Is the account or deposit reported on the balance sheet of the financial institution?
boolean-
orig_credit_score
The credit score of the customer at origination of the product using a commercially available credit bureau score.
integer-
orig_limit_amount
The original line of credit amount that was granted at the origination of the facility
integer-
parent_facility_id
The parent code assigned by the financial institution to identify a facility.
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-
prev_payment_date
The most recent previous date at which interest was paid or accrued_interest balance returned to zero.
string-
product_name
The name of the product as given by the financial institution to be used for display and reference purposes.
string-
provision_amount
The amount of reserves that is provisioned by the financial institution to cover the potential loss on the loan. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
purpose
The purpose for which the account was created or is being used.
string
adj_syn_inv_decon_subsadj_syn_inv_own_sharesadj_syn_mtg_def_insadj_syn_nonsig_inv_finadj_syn_other_inv_finadminannual_bonus_accrualsbenefit_in_kindcapital_gain_taxcapital_reservecash_managementcf_hedgecf_hedge_reclassci_serviceclearingcollateralcommitmentscomputer_and_it_costcomputer_peripheralcomputer_softwarecorporation_taxcredit_card_feecritical_servicecurrent_account_feecustodydealing_rev_crdealing_rev_dbt_issuedealing_rev_debtdealing_rev_depositsdealing_rev_derivdealing_rev_deriv_comdealing_rev_deriv_equdealing_rev_deriv_fxdealing_rev_deriv_intdealing_rev_deriv_nsedealing_rev_deriv_othdealing_rev_dr_com_ecodealing_rev_dr_equ_ecodealing_rev_dr_fx_ecodealing_rev_dr_int_ecodealing_rev_dr_nse_ecodealing_rev_dr_oth_ecodealing_rev_equitydealing_rev_fxdealing_rev_fx_nsedealing_rev_irdealing_rev_loandealing_rev_non_findealing_rev_oth_finandealing_rev_secdealing_rev_sec_nsedealing_rev_shortdealing_revenueded_fut_profded_fut_prof_temp_diffdefined_benefitdepositderivative_feedgs_contributiondiv_from_cisdiv_from_money_mktdividenddonationemployeeemployee_stock_optionescrowfeesfinefirm_operating_expensesfirm_operationsfurniturefut_proffut_prof_temp_difffxgeneral_credit_riskgoodwillinsurance_feeint_on_assetint_on_bond_and_frnint_on_bridging_loanint_on_credit_cardint_on_debt_issuedint_on_depositint_on_deriv_hedgeint_on_derivativeint_on_ecgd_lendingint_on_finance_leasingint_on_liabilityint_on_loan_and_advint_on_money_mktint_on_mortgageint_on_sftint_unallocatedintangibleintangible_leaseinterestintra_group_feeinv_in_subsidiaryinvestment_banking_feeinvestment_prop_leaseinvestment_propertyipsit_outsourcinglandloan_and_advance_feemachinerymanufactured_dividendmortgage_feemsrmtg_ins_nonconformmtg_insuranceni_contributionnol_carrybacknon_life_ins_premiumnot_fut_profoccupancy_costoperationaloperational_escrowoperational_excessoth_tax_excl_temp_diffotherother_expenditureother_fs_feeother_non_fs_feeother_social_contribother_staff_costother_staff_removerdraft_feeown_propertypensionppeprime_brokeragepropertyproperty_leasepv_future_spread_increc_unidentified_cptyreclass_taxrecoveryredundancy_pymtreferencereg_lossregular_wagesreleaserentres_fund_contributionrestructuringretained_earningsrevaluationrevaluation_reclassrevenue_reserveshare_planshare_premiumstaffsystemtaxtelecom_equipmentthird_party_interestunderwriting_feeunsecured_loan_feevehiclewrite_off
rate
The full interest rate applied to the account balance in percentage terms. Note that this therefore includes the base_rate (ie. not the spread).
number-
rate_type
Describes the type of interest rate applied to the account.
string
combinedfixedpreferentialtrackervariable
recourse
Whether there is recourse on a loan. Recourse on a loan refers to terms in the mortgage contract that give the owner of the note the right to pursue additional claims against the borrower beyond possession of the property. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14M for more information.
string
fullnonepartial
regulatory_book
The type of portfolio in which the instrument is held.
string
banking_booktrading_book
reporting_entity_name
The name of the reporting legal entity for display purposes.
string-
reporting_id
The internal ID for the legal entity under which the account is being reported.
string-
resolution_date
Date of resolution of the defaulted facility.
string-
review_date
The currently scheduled review date for Counterparty exposure. This date should be set in the future. Formatted as YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
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
AAADAEAE-AJAE-AZAE-DUAE-FUAE-RKAE-SHAE-UQAFAGAIALAMAOAQARASATAUAWAXAZBABBBDBEBFBGBHBIBJBLBMBNBOBQBRBSBTBVBWBYBZCACA-ABCA-BCCA-MBCA-NBCA-NLCA-NSCA-NTCA-NUCA-ONCA-PECA-QCCA-SKCA-YTCCCDCFCGCHCICKCLCMCNCOCRCUCVCWCXCYCZDEDJDKDMDODZECEEEGEHERESETFIFJFKFMFOFRGAGBGDGEGFGGGHGIGLGMGNGPGQGRGSGTGUGWGYHKHMHNHRHTHUIDIEILIMINIOIQIRISITJEJMJOJPKEKGKHKIKMKNKPKRKWKYKZLALBLCLILKLRLSLTLULVLYMAMCMDMEMFMGMHMKMLMMMNMOMPMQMRMSMTMUMVMWMXMYMZNANCNENFNGNINLNONPNRNUNZOMPAPEPFPGPHPKPLPMPNPRPSPTPWPYQAQMQNQOQPQQQRQSQTQUQVQWQXQYQZRERORSRURWSASBSCSDSESGSHSISJSKSLSMSNSOSRSSSTSVSXSYSZTCTDTFTGTHTJTKTLTMTNTOTRTTTVTWTZUAUGUMUSUS-AKUS-ALUS-ARUS-AZUS-CAUS-COUS-CTUS-DCUS-DEUS-FLUS-GAUS-HIUS-IAUS-IDUS-ILUS-INUS-KSUS-KYUS-LAUS-MAUS-MDUS-MEUS-MIUS-MNUS-MOUS-MSUS-MTUS-NCUS-NDUS-NEUS-NHUS-NJUS-NMUS-NVUS-NYUS-OHUS-OKUS-ORUS-PAUS-RIUS-SCUS-SDUS-TNUS-TXUS-UTUS-VAUS-VTUS-WAUS-WIUS-WVUS-WYUYUZVAVCVEVGVIVNVUWFWSXAXBXCXDXEXFXGXHXIXJXKXLXMXNXOXPXQXRXSXTXUXVXWXXXYXZYEYTZAZMZWZZ
risk_weight_std
The standardised approach risk weight represented as a decimal/float such that 1.5% is 0.015.
number-
rollover_date
A particular predetermined date at which an account is rolled-over.
string-
seniority
The seniority of the security in the event of sale or bankruptcy of the issuer.
string
mezzaninepari_passusenior_securedsenior_unsecuredsubordinated_securedsubordinated_unsecured
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-
start_date
The timestamp that the trade or financial product commences. YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
status
Describes if the Account is active or been cancelled.
string
activeauditedcancelledcancelled_payout_agreedotherpendingtransactionalunaudited
trade_date
The timestamp that the trade or financial product terms are agreed. YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
type
This is the type of the account with regards to common regulatory classifications.
string
accrualsamortisationbondscallcdcredit_cardcurrentcurrent_iodebt_securities_issueddeferreddeferred_taxdepreciationexpensefinancial_leaseincomeintangibleinternet_onlyiraisaisa_currentisa_current_ioisa_ioisa_time_depositisa_time_deposit_ioloans_and_advancesmoney_marketnon_deferrednon_productotherother_financial_liabprepaid_cardprepaymentsprovisionreserveretail_bondssavingssavings_iosuspensetangiblethird_party_savingstime_deposittime_deposit_iovaluation_allowancevostro
uk_funding_type
Funding type calculated according to BIPRU 12.5/12.6
string
ab
undrawn_provision_amount
The amount of reserves that is provisioned by the financial institution to cover the potential loss on the undrawn portion of a loan. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
version_id
The version identifier of the data such as the firm’s internal batch identifier.
string-
withdrawal_penalty
This is the penalty incurred by the customer for an early withdrawal on this account. An early withdrawal is defined as a withdrawal prior to the next_withdrawal_date. Monetary type represented as a naturally positive integer number of cents/pence.
integer-