layouttitle
readmeHome

logo-fire-red

Financial Regulatory (FIRE) Data Standard


Build Status Project Website Apache 2.0 License Join the chat at https://gitter.im/SuadeLabs/fire Contributor Guidelines

What is the FIRE data standard?

The Financial Regulatory data standard defines a common specification for the transmission of granular data between regulatory systems in finance. Regulatory data refers to the data that underlies regulatory submissions, requirements, calculations and is used for policy, monitoring and supervision purposes.

The FIRE data schemas and code samples are licensed under the Apache 2.0 License which has been chosen for being open, permissive and already widely accepted within the financial sector (think Hadoop, Cassandra, ActiveMQ).

The FIRE data standard is supported by the European Commission, the Open Data Institute and the Open Data Incubator for Europe via the Horizon 2020 funding programme.


Please see the contributing guidelines and guiding principles if you would like to contribute to this project.

Random FIRE Data Generator

Included is a random data generator which will generate data in line with the FIRE schema, but not necessarily realistic. (eg. You might get a loan with a balance of 10 but accrued interest of 1 million)

Testing

You can run tests locally with via ./run_tests.sh or view the CI test results here


layouttitle
readmeHome

logo-fire-red

Financial Regulatory (FIRE) Data Standard


Build Status Project Website Apache 2.0 License Join the chat at https://gitter.im/SuadeLabs/fire Contributor Guidelines

What is the FIRE data standard?

The Financial Regulatory data standard defines a common specification for the transmission of granular data between regulatory systems in finance. Regulatory data refers to the data that underlies regulatory submissions, requirements, calculations and is used for policy, monitoring and supervision purposes.

The FIRE data schemas and code samples are licensed under the Apache 2.0 License which has been chosen for being open, permissive and already widely accepted within the financial sector (think Hadoop, Cassandra, ActiveMQ).

The FIRE data standard is supported by the European Commission, the Open Data Institute and the Open Data Incubator for Europe via the Horizon 2020 funding programme.


Please see the contributing guidelines and guiding principles if you would like to contribute to this project.

Random FIRE Data Generator

Included is a random data generator which will generate data in line with the FIRE schema, but not necessarily realistic. (eg. You might get a loan with a balance of 10 but accrued interest of 1 million)

Testing

You can run tests locally with via ./run_tests.sh or view the CI test results here


layouttitle
readmeIntroduction

General Information

This is an introduction for people new to JSON and Markdown, if you are already familiar with JSON schemas already, move along now, nothing to see here.

Headers

Please make sure all property markdown files in documentation/properties/ folder start with the following header:


--- 
layout:			property
title:			"name of the data item as it appears in the schemas (ie. lowercase)"
schemas:		[a list of schemas where this data_item is used]
---

JSON

JSON is short for “Javascript Object Notation” and defines the format for an “object”. An object in programming terms can be a variable, data structure or a function (basically anything). More commonly, in Object-Oriented programming an object typically refers to an Instance of a Class. That is to say, a specific description of something more general. Like a Goat being an instance of the Class “Animal”.

For our purposes, we can just consider JSON to be the data and a JSON-schema to just define the format for that data, ie. what it needs to look like so the computer can understand where things are when it receives it.

Properties, names and values

A property in JSON notation is a name-value pair and list of properties is what makes up the data in our schemas. What you would normally call a “field” (like interest_rate) is the name of the property and what we might call an attribute is the value of the property.

One property

{"name": value}

List of properties

{"name1": "value1", "name3": "value3", "name2": "value2"}

JSON is just text, so the formatting is purely visual, even the order (see above) does not matter. As things get more complicated however, it is considered best practice to format your JSON to look more human-friendly:

{
  "name1": "value1",
  "name3": "value3",
  "name2": "value2"
}

You can visit: http://jsonprettyprint.com/ to help with this formatting.

JSON-Schema

While any data sent/received in JSON format will always look like the above, we need a way to make sure it is what we are expecting. For this we define a JSON-Schema which basically describes what the JSON formatted data should look like.

Description

What if we want to add a little more information to describe our property? This is where the “description” parameter comes in. We add some curly brackets where the “value” is supposed to be and add a description as so:

{"name": {"description": "A little blurb about this property"} }

or

{
  "name": {
   "description": "A little blurb about this property"
  }
}

Types

Now that we have described our property value, let’s go a step further and narrow it down to a specific type. Is it a number, a word, a list? The “type” parameter allows us to specify exactly this. So now our schema would look something like this:

{
  "name": {
   "description": "A little blurb about this property",
   "type": "number"
  }
}

JSON has 7 standard types that we can use:

A null value means the value is unknown. Note that this is different from an empty or zero field. If the field is empty, undefined or does not exist, then it can simply be omitted (unless it is indicated as being “required” in which case you should provide a suitable default value).

An integer is a number without a fraction or exponent part.

ex 1. 4
ex 2. 26908289076124561671021

A number is a number with or without a fraction or exponent part.

ex 1. 26908289076124561671021
ex 2. 269082.89076124561671021

A string is a list of characters (except “ or \ ) inside “quotes”. You can think of a string as a word. Note that the “word” can also contain numbers (like your national insurance number). But also note that numbers represented as strings need to be converted back to numbers if you want to add or multiply them.

ex 1. “sheep”
ex 2. “AS546NB8”

A boolean is simple true or false flag. Note that the true/false flag is lowercase and not inside “quotes”.

ex 1. true
ex 2. false

If you were wondering, the word boolean comes from a founding father of modern logic, the English mathematician George Boole.

An array is a list of the other types, separated by commas and inside square brackets [ ].

ex 1. [2, 235, 34634, 34]
ex 2. [“sheep”, “sheep_dog”, “fox”]

An object is a JSON object, or in other words, the thing we are defining. So this allows for nesting of objects within objects. This is valid JSON, but adds time and complexity in the decoding/parsing process so generally should be avoided.

{
  "farm_id": "E2G2K3LSJENJ4J3K10H",
  "animals": {
    "goat": 2,
    "sheep": 7,
    "sheep_dog": 1
  },
  "farm_owner": "peter"
}

Restrictions

Once we have given a description, a type and maybe a format for our property value we can implement some sanity checks by applying further restrictions.

Restrictions can come in the form of visual presentation like formats or enums, or they can come in the form of simple quantitative sanity-checks. Both are extremely useful to narrow down the possibilities of what might be considered as “valid data” according to the schema. These restrictions not only ensure that bad data is caught at the most granular level, but it also ensures that common semantics are used to define the same thing. It is the first step towards a harmonised standard. In other words, if a loan currency is US Dollar, let’s agree to call it “USD” instead of “US_Dollar”, “dollar-USA”, “011” or “$US.”

Restrictions can be difficult to implement as you need to consider all potential edge cases. Account balances are generally positive but sometimes can be negative, too. Leveraging widely used ISO or IFRS standards are therefore a great way to ensure you have considered the full spectrum of possible values. It also means that, more often than not, firms will already be familiar with and recording data in line with these standards.

Formats

How would you represent a date value like 31 August 2014?

  • We could make use of a string type: “31 August 2014” but then “Aug 31 2014” would also be valid and we would have trouble ordering our data by date.
  • We could accept an integer type: 31082014 but then 1235 would also be a valid integer. And even if we restricted it to 8-digits, we would have to remember to make sure single digit months have a leading zeros and still this doesn’t tell us if it is 31 August 2014 or 14 February 8013.

You get the idea, sometimes we need more information. This is where the format parameter comes in.

The following is the list of the formats specified in the JSON Schema specification:

The one we use most commonly from this is the “date-time” format and it basically means your dates and timestamps need to be a valid string but also look like this: YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.

So for our example, if this is your schema:

{"animal_birthday": {
  "description": "The recorded birthday for the animal.",
  "type": "string",
  "format": "date-time"
  }
}

then this would be a valid input:

{"animal_birthday": "1995-06-07T13:00:00Z"}

and this would be an invalid input:

{"animal_birthday": "1995-6-7T13:00:00Z"}

Enums

enum is short for enumeration which is short for “a complete, ordered listing of all the items in a collection.” All that means is a list (an array) of possible values our value can have. Enums are typically used with string types to limit the range of possible strings that are considered valid for a property value.

Again, it is important to consider edge cases and hence where relevant, it is advisable to leave an “other” or “none” value so that and edge case can be temporarily mapped to a generic parameter. Particularly, in the case of an open source project, you can envisage enum lists getting longer as the schemas evolve through contributions.

So for example, if this is your schema:

{"animal_type": {
  "description": "The type of animal on the farm.",
  "type": "string",
  "enum": ["sheep", "goat", "cow", "other"]
  }
}

then this would be a valid input:

{"animal_type": "goat"}

and this would be an invalid input:

{"animal_type": "horse"}

More information

The JSON spec can be found here and JSON-schema spec cane be found here.


layouttitle
readmeFAQs

FAQs


Is FIRE a data model for my database?

No. The FIRE Data Format is designed to define the format and definition for the transmission of data rather than the storage of that data. Financial data as a whole does lend itself naturally to a relational data model, but depending on the use-case, FIRE data might be better stored in a non-relational, graph or denormalised form.

Given that FIRE is not a data model recipe, why do you have multiple schemas and relational ids that suggests an underlying relational table design?

There are a few reasons for separating data into “normalised” components:

  • To reduce redundant information and the amount of data going down the wire. If you are transmitting information on customers and products, doing so in multiple schemas will be less data than having customer information repeated as additional fields in every product schema.
  • To remove possibility for errors and inconsistencies in data. Again, if we had customer information fields in our loan schema you could get two loans with the same customer_id but different credit_impaired statuses.
  • By segregating schemas, it also allows entities (like customers or collateral) to be added independently (without a loan, for example). It also allows for transmitting of product data without customer data which can be particularly useful where data protection and security concerns might exist for different confidentiality levels of data.
layouttitle
readmeContributing

Contributing


  1. Create a (free) Github account: https://github.com/join
  2. Start a discussion in the Issue Tracker: https://github.com/SuadeLabs/fire/issues
  3. Make a pull request: https://help.github.com/articles/using-pull-requests/

Contribution Requirements

  1. When adding an attribute to a schema the attribute should be well defined in terms of data type (i.e. integer, string, enum etc.) and the attribute should respect the guiding principles.

  2. For every new attribute there should be a corresponding documentation file.

  3. There should always be a justification and description in the pull request. This should indicate why the attribute should be in the project and/or why this contribution is important.

  4. All files must be valid, i.e. schema files are valid JSON and documentation is in Markdown format.

Keep in mind

Ensure you respect the project’s guiding principles Ensure that you follow the community guidelines: https://suade.org/fire/guidelines.html


layouttitle
readmeGuiding Principles

Guiding principles

The guiding principles are composed of:

Project principles

The FIRE project should be:

Easy to understand

FIRE should be easy to read, understand and explain for non-technical users. The reason for this is that (like any data specification for a complex, regulated industry) FIRE contains a great deal of embedded subject matter expertise needs to be evaluated and updated by specialists in finance, regulatory policy, accounting and law. Similarly, as FIRE will be implemented and used by developers, who may not necessarily have the same level of subject matter expertise, it should not require a great deal of financial or regulatory knowledge to understand the general concepts for use.

Easy to use

FIRE should be easy to implement and should require drastic and fundamental changes to how financial institutions identify, conceptualize, create, store and manage their data. This is why the schemas attributes will look familiar to those associated with traditional relational tables and financial data models. Despite a relational look and feel, as JSON objects, FIRE data can be easily used with NoSQL or Graph databases.

Free, open and collaborative

This should be a given but is unfortunately not very common in the financial industry as enterprise software vendors are keen to create lock-in to their systems and platforms with closed and proprietary data models and formats. As such, FIRE carries an open-source Apache 2.0 License and is publicly accessible on Github for easy integration with other IT systems.

Schema design principles

The FIRE Data schema specifications should respect the following 3 schema design principles. Note that the terms data attributes and schema properties are interchangeably used.

1. Data attributes should always be true

Schema properties (data attributes) should be self-evident truths and not depend on the application for which they will be used. In the same way that your date of birth doesn’t change depending on who’s asking, properties should follow the same philosophy. Practically, this means data should not be dependent on the intended computation, visualisation, report or application. Data should simply represent a labelling of a contract or entity based on purely legal definitions. As such, every pull request requires a corresponding, documented, legal reference, preferably to a currently in-force financial regulation.

2. Data attributes should be atomic

Schema properties should uniquely describe the data. Properties should be fundamental, atomic units of measurement. One property should not be derivable from other properties. Similar to the “flags” problem, schema properties should not have embedded logic. This was often done with legacy systems for performance reasons when databases were fast, CPUs slow and memory expensive, but today, most applications are I/O bound. You may still choose to store secondary or derived data, but this is the concern of the application and its specific goals rather than the underlying fundamental data.

eg. It would be unwise to have a loan balance in original currency and USD. This inevitably leads to data of the form:

balanceoriginal ccyin USD
100EUR120
100USD90
100EUR130

Can you spot the problem?

Better is to just have an original currency and an exchange rate.

3. Data attributes should be consistent

Schema properties should try to avoid logical inconsistencies. In other words, one schema property should not contradict another. This is a common occurrence in legacy systems where schemas were updated without a big picture consideration. This typically manifests itself in the form of flags

eg. There should not be a security type titled “government_bond” and a “issuer-type-is-government” flag.

This might seem ok:

security typeissuer-type-is-govt
government_bondY

This has the potential to create contradictory data of the nature:

security typeissuer-type-is-govt
government_bondN

Better would be:

security typeissuer-type-is-govt
bondY

Even better would be:

security typeissuer type
bondgovernment

Why? Because flags are limiting and can still lead to inconsistencies:

security typeissuer-type-is-govtissuer-type-is-retail
bondYY

layouttitle
readmeFIRE data examples

The following are a few examples of common financial trades.

Individual element examples

Account examples

Current account

{
  "title": "current_account",
  "comment": "current_account",
  "data": {
    "account": [
      {
        "id": "current_account",
        "date": "2017-06-30T14:03:12Z",
        "trade_date": "2012-02-06T09:30:00Z",
        "start_date": "2012-02-07T00:00:00Z",
        "currency_code": "GBP",
        "balance": 30000,
        "accrued_interest": 2500,
        "type": "current",
        "status": "active",
        "on_balance_sheet": true,
        "asset_liability": "liability",
        "customer_id": "C123456"
      }
    ]
  }
}

Current account with guarantee

{
  "title": "current_account_with_guarantee",
  "comment": "current_account_with_guarantee",
  "data": {
    "account": [
      {
        "id": "current_account_with_guarantee",
        "date": "2017-06-30T14:03:12Z",
        "trade_date": "2012-02-06T09:30:00Z",
        "start_date": "2012-02-07T00:00:00Z",
        "currency_code": "GBP",
        "balance": 30000,
        "accrued_interest": 2500,
        "guarantee_scheme": "gb_fscs",
        "guarantee_amount": 8500,
        "type": "current",
        "status": "active",
        "on_balance_sheet": true,
        "asset_liability": "liability",
        "customer_id": "C123456"
      }
    ]
  }
}

Savings account

{
    "title": "savings_account",
    "comment": "savings_account",
    "data": {
        "account": [
            {
                "id": "savings_account",
                "date": "2017-06-30T14:03:12Z",
                "trade_date": "2012-02-06T09:30:00Z",
                "start_date": "2012-02-07T00:00:00Z",
                "currency_code": "GBP",
                "balance": 30000,
                "accrued_interest": 2500,
                "type": "savings",
                "status": "active",
                "on_balance_sheet": true,
                "asset_liability": "liability",
                "customer_id": "C123456"
            }
        ]
    }
}

Savings account with notice

{{#include savings_account_with_notice.json:5:}}

1-year time deposit

{
  "title": "time_deposit_1year",
  "comment": "time_deposit_1year",
  "data": {
    "account": [
      {
        "id": "time_deposit_1year",
        "date": "2017-06-30T14:03:12Z",
        "trade_date": "2012-02-06T09:30:00Z",
        "start_date": "2012-02-07T00:00:00Z",
        "end_date": "2018-06-30T00:00:00Z",
        "currency_code": "GBP",
        "balance": 30000,
        "accrued_interest": 2500,
        "type": "time_deposit",
        "status": "active",
        "on_balance_sheet": true,
        "asset_liability": "liability",
        "customer_id": "C123456"
      }
    ]
  }
}

1-year time deposit with 6-month withdrawal option

{
  "title": "time_deposit_1year_with_6_month_withdrawal_option",
  "comment": "time_deposit_1year_with_6_month_withdrawal_option",
  "data": {
    "account": [
      {
        "id": "time_deposit_1year_with_6_month_withdrawal_option",
        "date": "2017-06-30T14:03:12Z",
        "trade_date": "2012-02-06T09:30:00Z",
        "start_date": "2012-02-07T00:00:00Z",
        "next_withdrawal_date": "2017-12-31T00:00:00Z",
        "end_date": "2018-06-30T00:00:00Z",
        "currency_code": "GBP",
        "balance": 30000,
        "accrued_interest": 2500,
        "type": "time_deposit",
        "status": "active",
        "on_balance_sheet": true,
        "asset_liability": "liability",
        "customer_id": "C123456"
      }
    ]
  }
}

PNL interest income

{
  "title": "pnl_interest_income",
  "comment": "interest_income",
  "data": {
    "account": [
      {
        "id": "interest_income",
        "date": "2017-06-30T14:03:12Z",
        "currency_code": "GBP",
        "balance": 30000,
        "type": "income",
        "asset_liability": "pnl",
        "purpose": "interest",
        "customer_id": "C123456"
      }
    ]
  }
}

PNL salary expenses

{
  "title": "pnl_salary_expenses",
  "comment": "salary_expenses",
  "data": {
    "account": [
      {
        "id": "salary_expenses",
        "date": "2017-06-30T14:03:12Z",
        "currency_code": "GBP",
        "balance": 30000,
        "type": "expense",
        "asset_liability": "pnl",
        "purpose": "regular_wages"
      }
    ]
  }
}

Loan examples

BBL/CBIL

These loans can be represented as a combination of two independent loans.

The first loan is a 25K GBP payable quarterly during 1 year (From Aug 1st, 2020 to Aug 1st, 2021).

{
    "id": "BBL1",
    "date": "2020-08-08T00:00:00+00:00",
    "balance": 2500000,
    "currency_code": "GBP",
    "end_date": "2021-08-01T00:00:00+00:00",
    "interest_repayment_frequency": "quarterly",
    "repayment_frequency": "at_maturity",
    "repayment_type": "interest_only",
    "start_date": "2020-08-01T00:00:00+00:00",
    "trade_date": "2020-05-11T00:00:00+00:00"
}

The second loan is a 25K GBP payable monthly during 5 years (From Aug 1st, 2021 to Aug 1st, 2026).

{
    "id": "BBL2",
    "date": "2020-08-08T00:00:00+00:00",
    "balance": 2500000,
    "currency_code": "GBP",
    "end_date": "2026-08-01T00:00:00+00:00",
    "repayment_frequency": "monthly",
    "repayment_type": "repayment",
    "start_date": "2021-08-01T00:00:00+00:00",
    "trade_date": "2020-05-11T00:00:00+00:00"
}

BBL_1 will create an inflow of 25K GBP, and BBL_2 will create an outflow of 25K GBP on Aug 1st, 2021.

If you are working with reports that separates inflows from outflows, you will get an excess on the inflow and an excess of the outflow.

To eliminate this excess, we can introduce a third loan.

{
    "id": "BBL_netting",
    "date": "2020-08-08T00:00:00+00:00",
    "balance": -2500000,
    "currency_code": "GBP",
    "end_date": "2021-08-01T00:00:00+00:00",
    "repayment_frequency": "at_maturity",
    "repayment_type": "repayment",
    "start_date": "2021-08-01T00:00:00+00:00"
}

Please download the complete examples

Nostro account

Nostro account, of 1000 GBP, held at another credit institution

{{#include nostro_account.json:5:}}

Loan with two customers

A loan example showing what the json looks like for loans with two customers

{{#include_loan_with_2_customers.json:5:}}

Derivative examples

Bermudan swaption

Short USD 1y into 10y receiver swaption exercisable annually with physical settlement

{
  "title": "bermudan_swaption",
  "comment": "usd_bermudan_swaption",
  "data": {
    "derivative": [
      {
        "date": "2019-01-01T00:00:00",
        "id": "usd_bermudan_swaption",
        "asset_class": "ir",
        "type": "swaption",
        "leg_type": "put",
        "position": "short",
        "currency_code": "USD",
        "notional_amount": 10000,
        "strike": 0.02,
        "underlying_index": "USD_LIBOR",
        "underlying_index_tenor": "6m",
        "start_date": "2019-01-01T00:00:00",
        "end_date": "2020-01-01T00:00:00",
        "last_payment_date": "2030-01-01T00:00:00",
        "next_exercise_date": "2020-01-01T00:00:00",
        "underlying_price": 0.02,
        "settlement_type": "physical",
        "mtm_dirty": -5
      }
    ]
  }
}

Bond future

June IMM Bund future (underlying index is the expected CTD on the reporting date)

{
  "title": "bond_future",
  "comment": "Bund June IMM future",
  "data": {
    "derivative": [
      {
        "id": "Bund June IMM future",
        "date": "2019-04-30T00:00:00",
        "asset_class": "ir",
        "type": "future",
        "leg_type": "indexed",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "rate": 125.5,
        "underlying_index": "BUND0829",
        "trade_date": "2019-04-01T00:00:00",
        "start_date": "2019-04-01T00:00:00",
        "end_date": "2019-06-15T00:00:00",
        "last_payment_date": "2029-08-15T00:00:00",
        "settlement_type": "physical",
        "mtm_dirty": -25
      }
    ]
  }
}

Futures on 20-year treasury bond that matures in 2 years

{
  "title": "bond_future2",
  "comment": "T-Bond Mar21 future",
  "data": {
    "derivative": [
      {
        "id": "T-Bond Mar21 future",
        "date": "2019-04-30T00:00:00",
        "asset_class": "ir",
        "type": "future",
        "leg_type": "indexed",
        "currency_code": "USD",
        "notional_amount": 100,
        "trade_date": "2019-04-01T00:00:00",
        "start_date": "2019-04-01T00:00:00",
        "end_date": "2021-03-15T00:00:00",
        "last_payment_date": "2041-03-15T00:00:00",
        "underlying_index": "T-bondMar41",
        "settlement_type": "physical"
      }
    ]
  }
}

Cross-currency swap

Long 10-year forward_starting AUD/EUR cross-currency swap

{
  "title": "xccy_swap",
  "comment": "USD-AUD xccy",
  "data": {
    "derivative": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "AUDUSD_xccy:AUD",
        "deal_id": "AUDUSD_xccy",
        "asset_class": "fx",
        "type": "xccy",
        "leg_type": "fixed",
        "position": "long",
        "currency_code": "AUD",
        "notional_amount": 14000,
        "rate": 0.01,
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2020-02-27T00:00:00",
        "end_date": "2030-02-27T00:00:00",
        "mtm_dirty": 1140
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "AUDUSD_xccy:USD",
        "deal_id": "AUDUSD_xccy",
        "asset_class": "fx",
        "type": "xccy",
        "position": "short",
        "leg_type": "floating",
        "currency_code": "USD",
        "notional_amount": 10000,
        "underlying_index": "USD_LIBOR_BBA",
        "underlying_index_tenor": "3m",
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2020-02-27T00:00:00",
        "end_date": "2030-02-27T00:00:00"
      }
    ],
    "derivative_cash_flow": [
      {
        "id": "1",
        "date": "2020-03-31T00:00:00",
        "derivative_id": "AUDUSD_xccy:AUD",
        "currency_code": "AUD",
        "notional_amount": 14000,
        "reset_date": "2019-02-27T00:00:00",
        "payment_date": "2019-02-27T00:00:00",
        "balance": -14000,
        "purpose": "principal"
      },
      {
        "id": "2",
        "date": "2020-03-31T00:00:00",
        "derivative_id": "AUDUSD_xccy:AUD",
        "currency_code": "AUD",
        "notional_amount": 14000,
        "reset_date": "2029-02-27T00:00:00",
        "payment_date": "2029-02-27T00:00:00",
        "balance": 14000,
        "purpose": "principal"
      },
      {
        "id": "3",
        "date": "2020-03-31T00:00:00",
        "derivative_id": "AUDUSD_xccy:USD",
        "currency_code": "USD",
        "notional_amount": 10000,
        "reset_date": "2019-02-27T00:00:00",
        "payment_date": "2019-02-27T00:00:00",
        "balance": 10000,
        "purpose": "principal"
      },
      {
        "id": "4",
        "date": "2020-03-31T00:00:00",
        "derivative_id": "AUDUSD_xccy:USD",
        "currency_code": "USD",
        "notional_amount": 10000,
        "reset_date": "2029-02-27T00:00:00",
        "payment_date": "2029-02-27T00:00:00",
        "balance": -10000,
        "purpose": "principal"
      },
      {
        "id": "5",
        "date": "2020-03-31T00:00:00",
        "derivative_id": "AUDUSD_xccy:AUD",
        "currency_code": "USD",
        "reset_date": "2020-02-27T00:00:00",
        "payment_date": "2021-02-27T00:00:00",
        "notional_amount": 14000,
        "balance": 140,
        "purpose": "interest"
      },
      {
        "id": "6",
        "date": "2020-03-31T00:00:00",
        "derivative_id": "AUDUSD_xccy:AUD",
        "currency_code": "USD",
        "reset_date": "2028-02-27T00:00:00",
        "payment_date": "2029-02-27T00:00:00",
        "notional_amount": 14000,
        "balance": 140,
        "purpose": "interest"
      },
      {
        "id": "7",
        "date": "2020-03-31T00:00:00",
        "derivative_id": "AUDUSD_xccy:USD",
        "currency_code": "USD",
        "reset_date": "2020-02-27T00:00:00",
        "payment_date": "2020-05-27T00:00:00",
        "notional_amount": 10000,
        "forward_rate": 0.01,
        "balance": -2466,
        "purpose": "interest"
      },
      {
        "id": "8",
        "date": "2020-03-31T00:00:00",
        "derivative_id": "AUDUSD_xccy:USD",
        "currency_code": "USD",
        "reset_date": "2028-11-27T00:00:00",
        "payment_date": "2029-02-27T00:00:00",
        "notional_amount": 10000,
        "forward_rate": 0.02,
        "balance": -5042,
        "purpose": "interest"
      }
    ]
  }
}

Commodity option

Long 100 June21 at-the-money copper put

{
  "title": "commodity_option",
  "comment": "Commodity Option",
  "data": {
    "derivative": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "1",
        "asset_class": "metals",
        "type": "option",
        "leg_type": "put",
        "position": "long",
        "currency_code": "USD",
        "underlying_quantity": 100,
        "strike": 9829,
        "underlying_index": "copper",
        "underlying_price": 9829,
        "trade_date": "2020-02-25T00:00:00",
        "start_date": "2020-02-27T00:00:00",
        "end_date": "2021-06-02T00:00:00",
        "last_exercise_date": "2020-12-05T00:00:00",
        "settlement_type": "physical",
        "mtm_dirty": 193
      }
    ]
  }
}

Credit default swap - Index

Index CDS; CDS on the cdx_na_ig index

{
  "title": "cds_index",
  "comment": "cds_index",
  "data": {
    "derivative": [
      {
        "id": "corp_cds_5y",
        "date": "2019-01-01T00:00:00",
        "asset_class": "cr_index",
        "type": "cds",
        "underlying_security_id": "cdx_na_ig",
        "leg_type": "indexed",
        "position": "short",
        "currency_code": "USD",
        "notional_amount": 100,
        "trade_date": "2018-07-01T00:00:00",
        "start_date": "2018-07-03T00:00:00",
        "end_date": "2023-07-03T00:00:00",
        "rate": 0.005,
        "settlement_type": "cash"
      }
    ],
    "security": [
      {
        "id": "cdx_na_ig",
        "date": "2019-01-01T00:00:00",
        "type": "index",
        "currency_code": "USD",
        "cqs_standardised": 3
      }
    ]
  }
}

Credit default swap - Single name

Single name CDS; reference obligation US corporate bond with July 2028 maturity

{
  "title": "cds_single_name",
  "comment": "cds_single_name",
  "data": {
    "derivative": [
      {
        "id": "corp_cds_5y",
        "date": "2019-01-01T00:00:00",
        "asset_class": "cr_single",
        "type": "cds",
        "underlying_security_id": "Corp_Jul28",
        "leg_type": "indexed",
        "position": "short",
        "currency_code": "USD",
        "notional_amount": 100,
        "trade_date": "2018-07-01T00:00:00",
        "start_date": "2018-07-03T00:00:00",
        "end_date": "2023-07-03T00:00:00",
        "rate": 0.005,
        "settlement_type": "cash"
      }
    ],
    "security": [
      {
        "id": "Corp_Jul28",
        "date": "2019-01-01T00:00:00",
        "type": "bond",
        "underlying_issuer_id": "us_corp",
        "isin_code": "XS1234567890",
        "currency_code": "USD",
        "issue_date": "2018-07-01 00:00:00",
        "maturity_date": "2028-07-01 00:00:00",
        "cqs_standardised": 3
      }
    ],
    "issuer": [
      {
        "id": "us_corp",
        "date": "2019-01-01T00:00:00",
        "type": "corporate",
        "country_code": "US",
        "snp_lt": "a_plus",
        "moodys_lt": "a1"
      }
    ]
  }
}

Equity option

Long 100 1-year 40 call on EquityABC.

{
  "title": "equity_option",
  "comment": "equity_option",
  "data": {
    "derivative": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "1",
        "deal_id": "2",
        "asset_class": "eq_single",
        "type": "option",
        "leg_type": "call",
        "position": "long",
        "currency_code": "USD",
        "underlying_quantity": 100.00,
        "strike": 40.00,
        "underlying_security_id": "EquityABC",
        "underlying_price": 25.00,
        "trade_date": "2020-02-25T00:00:00",
        "start_date": "2020-02-27T00:00:00",
        "end_date": "2021-02-27T00:00:00",
        "last_exercise_date": "2020-12-05T00:00:00",
        "settlement_type": "cash",
        "mtm_dirty": 10
      }
    ],
    "security": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "EquityABC",
        "type": "equity",
        "currency_code": "USD",
        "start_date": "2017-01-01T00:00:00",
        "purpose": "reference"
      }
    ]
  }
}

Equity total return swap

Short 5y EUR total return swap on EquityABC

{
  "title": "equity_total_return_swap",
  "comment": "equity_total_return_swap",
  "data": {
    "derivative": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "eur_equity_trs:equity_leg",
        "deal_id": "eur_equity_trs",
        "asset_class": "eq",
        "type": "vanilla_swap",
        "leg_type": "indexed",
        "position": "short",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "underlying_security_id": "EquityABC",
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2019-02-27T00:00:00",
        "end_date": "2024-02-27T00:00:00",
        "mtm_dirty": 140
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "eur_equity_trs:floating_leg",
        "deal_id": "long_eur_equity_trs",
        "asset_class": "eq",
        "type": "vanilla_swap",
        "leg_type": "floating",
        "position": "long",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "rate": 0.0225,
        "underlying_index": "EURIBOR",
        "underlying_index_tenor": "3m",
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2019-02-27T00:00:00",
        "end_date": "2024-02-27T00:00:00"
      }
    ],
    "security": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "EquityABC",
        "type": "equity",
        "currency_code": "USD",
        "start_date": "2020-03-31T00:00:00",
        "issue_date": "2017-03-01T00:00:00",
        "purpose": "reference"
      }
    ]
  }
}

Forward rate agreement

Short 6x12 USD FRA

{
  "title": "fra_6x12",
  "comment": "6x12-fra",
  "data": {
    "derivative": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "6x12-fra",
        "asset_class": "ir",
        "type": "fra",
        "leg_type": "indexed",
        "position": "short",
        "currency_code": "USD",
        "notional_amount": 10000,
        "underlying_index": "USD_LIBOR",
        "underlying_index_tenor": "6m",
        "trade_date": "2019-11-25T00:00:00",
        "start_date": "2020-05-27T00:00:00",
        "end_date": "2020-11-27T00:00:00",
        "settlement_type": "cash",
        "rate": 0.005,
        "mtm_dirty": -25
      }
    ]
  }
}

FX forward

Short AUDUSD forward

{
    "title": "fx_forward",
    "comment": "fx_forward",
    "data": {
      "derivative": [
        {
          "date": "2019-04-30T00:00:00",
          "id": "audusd_swap:aud",
          "deal_id": "audusd_fx_fwd",
          "asset_class": "fx",
          "type": "forward",
          "leg_type": "fixed",
          "position": "short",
          "currency_code": "AUD",
          "notional_amount": 10000,
          "trade_date": "2019-02-25T00:00:00",
          "start_date": "2019-02-27T00:00:00",
          "end_date": "2020-02-27T00:00:00",
          "mtm_dirty": -2
        },
        {
          "date": "2019-04-30T00:00:00",
          "id": "audusd_swap:usd",
          "deal_id": "audusd_fx_fwd",
          "asset_class": "fx",
          "type": "forward",
          "leg_type": "fixed",
          "position": "long",
          "currency_code": "USD",
          "notional_amount": 10275,
          "trade_date": "2019-02-25T00:00:00",
          "start_date": "2019-02-27T00:00:00",
          "end_date": "2020-02-27T00:00:00"
        }
      ]
    }
  }

FX future

Long June EURCAD future

{
  "title": "fx_future",
  "comment": "EUR CAD Future",
  "data": {
    "derivative": [
      {
        "date": "2019-04-01T00:00:00",
        "id": "eur_cad_future",
        "asset_class": "fx",
        "type": "future",
        "leg_type": "indexed",
        "position": "long",
        "currency_code": "EUR",
        "notional_amount": 100,
        "underlying_currency_code": "CAD",
        "trade_date": "2019-04-01T00:00:00",
        "start_date": "2019-06-15T00:00:00",
        "end_date": "2019-09-15T00:00:00",
        "rate": 1.4,
        "underlying_price": 1.38,
        "settlement_type": "physical",
        "mtm_dirty": -2
      }
    ]
  }
}

FX option

Short USD call YEN put FX option, exercise on Match 2020

{
  "title": "fx_option",
  "comment": "USD-JPY call 130",
  "data": {
    "derivative": [
      {
        "date": "2019-12-31T00:00:00",
        "id": "USDJPY call 130",
        "asset_class": "fx",
        "type": "option",
        "leg_type": "call",
        "position": "short",
        "currency_code": "USD",
        "notional_amount": 100,
        "underlying_currency_code": "JPY",
        "strike": 130,
        "trade_date": "2019-12-01T00:00:00",
        "start_date": "2019-12-05T00:00:00",
        "end_date": "2020-03-05T00:00:00",
        "last_exercise_date": "2020-03-03T00:00:00",
        "underlying_price": 130,
        "mtm_dirty": -2
      }
    ]
  }
}

FX spot

Long EURCAD spot (100 EUR for 140 CAD spot trade)

{
  "title": "fx_spot",
  "comment": "fx_spot",
  "data": {
    "derivative": [
      {
        "date": "2019-04-30T00:00:00",
        "id": "eurcad_spot:eur",
        "deal_id": "eurcad_spot",
        "asset_class": "fx",
        "type": "spot",
        "leg_type": "fixed",
        "position": "long",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "trade_date": "2019-04-30T00:00:00",
        "start_date": "2019-05-02T00:00:00",
        "end_date": "2019-05-02T00:00:00",
        "mtm_dirty": -2
      },
      {
        "date": "2019-04-30T00:00:00",
        "id": "eurcad_spot:cad",
        "deal_id": "eurcad_spot",
        "asset_class": "fx",
        "type": "spot",
        "leg_type": "fixed",
        "position": "short",
        "currency_code": "CAD",
        "notional_amount": 14000,
        "trade_date": "2019-04-30T00:00:00",
        "start_date": "2019-05-02T00:00:00",
        "end_date": "2019-05-02T00:00:00"
      }
    ]
  }
}

FX swap

Short 1-year AUDUSD fx swap. The notional amounts are used to calculate the spot rate (occuring on the start date).

{
  "title": "fx_swap",
  "comment": "fx_swap: this is a legacy mapping. Please refer to fx_foward.",
  "data": {
    "derivative": [
      {
        "date": "2019-04-30T00:00:00",
        "id": "audusd_swap:aud",
        "deal_id": "audusd_swap",
        "asset_class": "fx",
        "type": "vanilla_swap",
        "leg_type": "fixed",
        "position": "short",
        "currency_code": "AUD",
        "notional_amount": 10000,
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2019-02-27T00:00:00",
        "end_date": "2020-02-27T00:00:00",
        "mtm_dirty": -2
      },
      {
        "date": "2019-04-30T00:00:00",
        "id": "audusd_swap:aud",
        "deal_id": "audusd_swap",
        "asset_class": "fx",
        "type": "vanilla_swap",
        "leg_type": "fixed",
        "position": "long",
        "currency_code": "USD",
        "notional_amount": 10275,
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2019-02-27T00:00:00",
        "end_date": "2020-02-27T00:00:00"
      }
    ]
  }
}

Interest rate cap floor

Short 1y collar vs Euribor 3M

{
  "title": "ir_cap_floor",
  "comment": "IR Cap Floor",
  "data": {
    "derivative": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "short_eur_1y_collar:short_cap",
        "deal_id": "short_eur_1y_collar",
        "asset_class": "ir",
        "type": "cap_floor",
        "leg_type": "call",
        "position": "short",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "underlying_index": "EURIBOR",
        "underlying_index_tenor": "3m",
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2019-02-27T00:00:00",
        "end_date": "2020-02-27T00:00:00",
        "next_exercise_date": "2019-05-25T00:00:00",
        "strike": 0.015,
        "underlying_price": 0.01,
        "mtm_dirty": -40
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "short_eur_1y_collar:long_floor",
        "deal_id": "short_eur_1y_collar",
        "asset_class": "ir",
        "type": "cap_floor",
        "leg_type": "put",
        "position": "long",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "underlying_index": "EURIBOR",
        "underlying_index_tenor": "3m",
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2019-02-27T00:00:00",
        "end_date": "2020-02-27T00:00:00",
        "next_exercise_date": "2019-05-25T00:00:00",
        "strike": 0.005,
        "underlying_price": 0.01,
        "mtm_dirty": 110
      }
    ],
    "derivative_cash_flow": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "short_eur_1y_collar:short_cap 2",
        "derivative_id": "short_eur_1y_collar:short_cap",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "leg": "pay",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "balance": 0,
        "reset_date": "2019-05-27T00:00:00",
        "payment_date": "2019-08-27T00:00:00",
        "forward_rate": 0.005
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "short_eur_1y_collar:short_cap 3",
        "derivative_id": "short_eur_1y_collar:short_cap",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "leg": "pay",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "balance": 0,
        "reset_date": "2019-08-27T00:00:00",
        "payment_date": "2019-11-27T00:00:00",
        "forward_rate": 0.01
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "short_eur_1y_collar:short_cap 4",
        "derivative_id": "short_eur_1y_collar:short_cap",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "leg": "pay",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "balance": 0,
        "reset_date": "2019-11-27T00:00:00",
        "payment_date": "2020-02-27T00:00:00",
        "forward_rate": 0.015
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "short_eur_1y_collar:long_floor 2",
        "derivative_id": "short_eur_1y_collar:long_floor",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "leg": "receive",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "balance": 0,
        "reset_date": "2019-05-27T00:00:00",
        "payment_date": "2019-08-27T00:00:00",
        "forward_rate": 0.005
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "short_eur_1y_collar:long_floor 3",
        "derivative_id": "short_eur_1y_collar:long_floor",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "leg": "receive",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "balance": 0,
        "reset_date": "2019-08-27T00:00:00",
        "payment_date": "2019-11-27T00:00:00",
        "forward_rate": 0.01
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "short_eur_1y_collar:long_floor 4",
        "derivative_id": "short_eur_1y_collar:long_floor",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "leg": "receive",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "balance": 0,
        "reset_date": "2019-11-27T00:00:00",
        "payment_date": "2020-02-27T00:00:00",
        "forward_rate": 0.015
      }
    ]
  }
}

Interest rate digital floor

Long EUR 1y 0% digital floor vs Euribor 3M

{
  "title": "ir_digital_floor",
  "comment": "IR Digital Floor",
  "data": {
    "derivative": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "1y digital floor:long floor",
        "deal_id": "1y digital floor",
        "asset_class": "ir",
        "type": "cap_floor",
        "leg_type": "put",
        "position": "long",
        "currency_code": "EUR",
        "notional_amount": 100000,
        "underlying_index": "EURIBOR",
        "underlying_index_tenor": "3m",
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2019-02-27T00:00:00",
        "end_date": "2020-02-27T00:00:00",
        "last_exercise_date": "2019-05-25T00:00:00",
        "strike": 0.0005,
        "mtm_dirty": -40
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "1y digital floor:short floor",
        "deal_id": "1y digital floor",
        "asset_class": "ir",
        "type": "cap_floor",
        "leg_type": "put",
        "position": "short",
        "currency_code": "EUR",
        "notional_amount": 100000,
        "underlying_index": "EURIBOR",
        "underlying_index_tenor": "3m",
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2019-02-27T00:00:00",
        "end_date": "2020-02-27T00:00:00",
        "last_exercise_date": "2019-05-25T00:00:00",
        "strike": -0.0005
      }
    ],
    "derivative_cash_flow": [
      {
        "id": "1y digital floor:long floor_1",
        "derivative_id": "1y digital floor:long floor",
        "date": "2020-03-31T00:00:00",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "currency_code": "EUR",
        "notional_amount": 100000,
        "reset_date": "2019-05-27T00:00:00",
        "payment_date": "2019-08-27T00:00:00",
        "forward_rate": 0.0025
      },
      {
        "id": "1y digital floor:long floor_2",
        "derivative_id": "1y digital floor:long floor",
        "date": "2020-03-31T00:00:00",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "currency_code": "EUR",
        "notional_amount": 100000,
        "reset_date": "2019-08-27T00:00:00",
        "payment_date": "2019-11-27T00:00:00",
        "forward_rate": 0.005
      },
      {
        "id": "1y digital floor:long floor_3",
        "derivative_id": "1y digital floor:long floor",
        "date": "2020-03-31T00:00:00",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "currency_code": "EUR",
        "notional_amount": 100000,
        "reset_date": "2019-11-27T00:00:00",
        "payment_date": "2020-02-27T00:00:00",
        "forward_rate": 0.0075
      },
      {
        "id": "1y digital floor:short floor_1",
        "derivative_id": "1y digital floor:short floor",
        "date": "2020-03-31T00:00:00",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "currency_code": "EUR",
        "notional_amount": 100000,
        "reset_date": "2019-05-27T00:00:00",
        "payment_date": "2019-08-27T00:00:00",
        "forward_rate": 0.0025
      },
      {
        "id": "1y digital floor:short floor_2",
        "derivative_id": "1y digital floor:short floor",
        "date": "2020-03-31T00:00:00",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "currency_code": "EUR",
        "notional_amount": 100000,
        "reset_date": "2019-08-27T00:00:00",
        "payment_date": "2019-11-27T00:00:00",
        "forward_rate": 0.005
      },
      {
        "id": "1y digital floor:short floor_3",
        "derivative_id": "1y digital floor:short floor",
        "date": "2020-03-31T00:00:00",
        "trade_date": "2019-02-25T00:00:00",
        "asset_class": "ir",
        "currency_code": "EUR",
        "notional_amount": 100000,
        "reset_date": "2019-11-27T00:00:00",
        "payment_date": "2020-02-27T00:00:00",
        "forward_rate": 0.0075
      }
    ]
  }
}

Interest rate future

June three-month cash-settled interest rate future.

{
  "title": "ir_future",
  "comment": "ir_future",
  "data": {
    "derivative": [
      {
        "date": "2019-04-30T00:00:00",
        "id": "june_eurodollar_future",
        "asset_class": "ir",
        "type": "future",
        "leg_type": "indexed",
        "position": "long",
        "currency_code": "EUR",
        "notional_amount": 100,
        "underlying_currency_code": "USD",
        "trade_date": "2018-04-01T00:00:00",
        "start_date": "2018-04-01T00:00:00",
        "end_date": "2019-06-01T00:00:00",
        "last_payment_date": "2019-09-01T00:00:00",
        "mtm_dirty": -2,
        "settlement_type": "cash"
      }
    ]
  }
}

Interest rate swap

Long 10y EUR irs vs Euribor 3M, bullet

{
  "title": "interest_rate_swap",
  "comment": "interest_rate_swap",
  "data": {
    "derivative": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "eur_10y_irs_fixed",
        "deal_id": "eur_10y_irs",
        "asset_class": "ir",
        "type": "vanilla_swap",
        "currency_code": "EUR",
        "leg_type": "fixed",
        "position": "long",
        "notional_amount": 10000,
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2019-02-27T00:00:00",
        "end_date": "2029-02-27T00:00:00",
        "rate": 0.01,
        "mtm_dirty": 70
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "eur_10y_irs_floating",
        "deal_id": "long_eur_10y_irs",
        "asset_class": "ir",
        "type": "vanilla_swap",
        "leg_type": "floating",
        "position": "short",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "rate": 0.0025,
        "underlying_index": "EURIBOR",
        "underlying_index_tenor": "3m",
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2019-02-27T00:00:00",
        "end_date": "2029-02-27T00:00:00"
      }
    ]
  }
}

Interest rate swap amortising

Long 2y EUR irs vs Euribor 6M, amortising annually

{
  "title": "interest_rate_swap_amortising",
  "comment": "Interest Rate Swap Amortising",
  "data": {
    "derivative": [
      {
        "id": "eur_10y_irs_fixed",
        "deal_id": "eur_10y_irs",
        "date": "2020-03-31T00:00:00",
        "asset_class": "ir",
        "type": "vanilla_swap",
        "leg_type": "fixed",
        "position": "long",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "trade_date": "2020-01-29T00:00:00",
        "start_date": "2020-01-31T00:00:00",
        "end_date": "2022-01-31T00:00:00",
        "rate": 0.01,
        "mtm_dirty": 70
      },
      {
        "id": "eur_10y_irs_floating",
        "deal_id": "long_eur_10y_irs",
        "date": "2020-03-31T00:00:00",
        "asset_class": "ir",
        "type": "vanilla_swap",
        "leg_type": "floating",
        "position": "short",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "trade_date": "2020-01-29T00:00:00",
        "start_date": "2020-01-31T00:00:00",
        "end_date": "2022-01-31T00:00:00",
        "underlying_index": "EURIBOR",
        "underlying_index_tenor": "6m",
        "rate": 0.0025
      }
    ],
    "derivative_cash_flow": [
      {
        "id": "eur_10y_irs_fixed_1",
        "derivative_id": "eur_10y_irs_fixed",
        "date": "2020-03-31T00:00:00",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "reset_date": "2020-01-31T00:00:00",
        "payment_date": "2021-01-31T00:00:00"
      },
      {
        "id": "eur_10y_irs_fixed_2",
        "derivative_id": "eur_10y_irs_fixed",
        "date": "2020-03-31T00:00:00",
        "currency_code": "EUR",
        "notional_amount": 5000,
        "reset_date": "2021-01-31T00:00:00",
        "payment_date": "2022-01-31T00:00:00"
      },
      {
        "id": "eur_10y_irs_floating_1",
        "derivative_id": "eur_10y_irs_floating",
        "date": "2020-03-31T00:00:00",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "reset_date": "2021-01-31T00:00:00",
        "payment_date": "2021_07_31T00:00:00",
        "forward_rate": 0.0075
      },
      {
        "id": "eur_10y_irs_floating_2",
        "derivative_id": "eur_10y_irs_floating",
        "date": "2020-03-31T00:00:00",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "reset_date": "2021-07-31T00:00:00",
        "payment_date": "2022-01-31T00:00:00",
        "forward_rate": 0.0125
      },
      {
        "id": "eur_10y_irs_floating_3",
        "derivative_id": "eur_10y_irs_floating",
        "date": "2020-03-31T00:00:00",
        "currency_code": "EUR",
        "notional_amount": 5000,
        "reset_date": "2022-01-31T00:00:00",
        "payment_date": "2022-07-31T00:00:00",
        "forward_rate": 0.0175
      },
      {
        "id": "eur_10y_irs_floating_4",
        "derivative_id": "eur_10y_irs_floating",
        "date": "2020-03-31T00:00:00",
        "currency_code": "EUR",
        "notional_amount": 5000,
        "reset_date": "2022-07-31T00:00:00",
        "payment_date": "2023-01-31T00:00:00",
        "forward_rate": 0.0225
      }
    ]
  }
}

Margined netting agreement

Margined netting agreement, collateralised with initial collateral amount and variation margin

{
  "title": "margined_netting_agreement",
  "comment": "Margined Netting Set with collateral. Example trade is an IRS. Agreement schemas contain an MNA (representing the netting set) and a CSA (representing margined status - exchanges of collateral)",
  "data": {
    "derivative": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "eur_10y_irs_fixed",
        "deal_id": "eur_10y_irs",
        "customer_id": "ccp_1",
        "mna_id": "isda_master_agreement",
        "csa_id": "csa_daily_margined",
        "asset_class": "ir",
        "type": "vanilla_swap",
        "leg_type": "fixed",
        "position": "long",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2020-02-27T00:00:00",
        "end_date": "2029-02-27T00:00:00",
        "rate": 0.01,
        "mtm_dirty": 70
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "eur_10y_irs_floating",
        "deal_id": "long_eur_10y_irs",
        "customer_id": "counterparty_1",
        "mna_id": "isda_master_agreement",
        "csa_id": "csa_daily_margined",
        "asset_class": "ir",
        "type": "vanilla_swap",
        "leg_type": "floating",
        "position": "short",
        "currency_code": "EUR",
        "notional_amount": 10000,
        "rate": 0.0025,
        "underlying_index": "EURIBOR",
        "underlying_index_tenor": "3m",
        "trade_date": "2019-02-25T00:00:00",
        "start_date": "2020-02-27T00:00:00",
        "end_date": "2029-02-27T00:00:00"
      }
    ],
    "customer": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "ccp_1",
        "type": "ccp",
        "currency_code": "GBP",
        "country_code": "GB"
      }
    ],
    "agreement": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "isda_master_agreement",
        "type": "isda",
        "base_currency_code": "GBP",
        "incurred_cva": 0,
        "country_code": "GB"
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "csa_daily_margined",
        "type": "isda",
        "base_currency_code": "EUR",
        "credit_support_type": "scsa_isda_2013",
        "margin_frequency": "daily",
        "threshold": 10,
        "minimum_transfer_amount": 5,
        "country_code": "GB"
      }
    ],
    "security": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "vm_eur_received",
        "customer_id": "ccp_1",
        "mna_id": "isda_master_agreement",
        "csa_id": "csa_daily_margined",
        "type": "cash",
        "purpose": "variation_margin",
        "asset_liability": "liability",
        "currency_code": "EUR",
        "notional_amount": 55,
        "balance": 55,
        "trade_date": "2020-03-31T00:00:00",
        "start_date": "2020-03-31T00:00:00"
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "im_bond_posted",
        "customer_id": "ccp_1",
        "mna_id": "isda_master_agreement",
        "csa_id": "csa_daily_margined",
        "type": "bond",
        "issuer_id": "French Republic",
        "isin_code": "XS1234567890",
        "issue_date": "2018-07-01 00:00:00",
        "maturity_date": "2028-07-01 00:00:00",
        "purpose": "independent_collateral_amount",
        "asset_liability": "asset",
        "currency_code": "EUR",
        "notional_amount": 8,
        "mtm_dirty": -10,
        "trade_date": "2020-03-31T00:00:00",
        "start_date": "2020-03-31T00:00:00",
        "cqs_standardised": 1
      }
    ],
    "issuer": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "French Republic",
        "lei_code": "9695006J0AWHMYNZAL19",
        "type": "central_govt",
        "country_code": "FR",
        "snp_lt": "aa_plus",
        "moodys_lt": "aa1"
      }
    ]
  }
}

Swaption

Short USD 1y into 10y payer swaptionwith physical settlement

{{#include swaption.json:5:}}

Unmargined netting agreement

Unmargined netting agreement, collateralised with initial collateral amount

{
    "title": "unmargined_netting_agreement",
    "comment": "Unmargined netting set with collateral. Example trade is an IRS. Agreement schemas contain an MNA (representing the netting set). There is no CSA, therefore there is no margining. However, one can still post Independent Collateral (security schema)",
    "data": {
      "derivative": [
        {
          "date": "2020-03-31T00:00:00",
          "id": "eur_10y_irs_fixed",
          "deal_id": "eur_10y_irs",
          "customer_id": "ccp_1",
          "mna_id": "isda_master_agreement",
          "csa_id": "csa_daily_margined",
          "asset_class": "ir",
          "type": "vanilla_swap",
          "leg_type": "fixed",
          "position": "long",
          "currency_code": "EUR",
          "notional_amount": 10000,
          "trade_date": "2019-02-25T00:00:00",
          "start_date": "2020-02-27T00:00:00",
          "end_date": "2029-02-27T00:00:00",
          "rate": 0.01,
          "mtm_dirty": 70
        },
        {
          "date": "2020-03-31T00:00:00",
          "id": "eur_10y_irs_floating",
          "deal_id": "long_eur_10y_irs",
          "customer_id": "counterparty_1",
          "mna_id": "isda_master_agreement",
          "csa_id": "csa_daily_margined",
          "asset_class": "ir",
          "type": "vanilla_swap",
          "leg_type": "floating",
          "position": "short",
          "currency_code": "EUR",
          "notional_amount": 10000,
          "rate": 0.0025,
          "underlying_index": "EURIBOR",
          "underlying_index_tenor": "3m",
          "trade_date": "2019-02-25T00:00:00",
          "start_date": "2020-02-27T00:00:00",
          "end_date": "2029-02-27T00:00:00"
        }
      ],
      "customer": [
        {
          "date": "2020-03-31T00:00:00",
          "id": "ccp_1",
          "type": "ccp",
          "currency_code": "GBP",
          "country_code": "GB"
        }
      ],
      "agreement": [
        {
          "date": "2020-03-31T00:00:00",
          "id": "isda_master_agreement",
          "type": "isda",
          "base_currency_code": "GBP",
          "incurred_cva": 0,
          "country_code": "GB"
        }
      ],
      "security": [
        {
          "date": "2020-03-31T00:00:00",
          "id": "im_bond_posted",
          "customer_id": "ccp_1",
          "mna_id": "isda_master_agreement",
          "type": "bond",
          "issuer_id": "French Republic",
          "isin_code": "XS1234567890",
          "issue_date": "2018-07-01 00:00:00",
          "maturity_date": "2028-07-01 00:00:00",
          "purpose": "independent_collateral_amount",
          "asset_liability": "asset",
          "currency_code": "EUR",
          "notional_amount": 8,
          "mtm_dirty": -10,
          "trade_date": "2020-03-31T00:00:00",
          "start_date": "2020-03-31T00:00:00",
          "cqs_standardised": 1
        }
      ],
      "issuer": [
        {
          "date": "2020-03-31T00:00:00",
          "id": "French Republic",
          "lei_code": "9695006J0AWHMYNZAL19",
          "type": "central_govt",
          "country_code": "FR",
          "snp_lt": "aa_plus",
          "moodys_lt": "aa1"
        }
      ]
    }
  }

Security examples

Bank guarantee issued

Guarantee of 1000 GBP issued by the bank for a customer

{
  "title": "bank_guarantee_issued",
  "comment": "bank_guarantee",
  "data": {
    "security": [
      {
        "id": "bank_guarantee",
        "date": "2019-01-01T00:00:00",
        "balance": 100000,
        "currency_code": "GBP",
        "asset_liability": "liability",
        "on_balance_sheet": false,
        "type": "financial_guarantee",
        "customer_id": "corp_123_id"
      }
    ]
  }
}

Core equity tier-1 capital

Core equity tier 1 capital of 1000 GBP

{
  "title": "cet_1_capital",
  "comment": "Core Equity Tier one capital",
  "data": {
    "security": [
      {
        "id": "Core Equity Tier one capital",
        "date": "2019-01-01T00:00:00",
        "balance": 100000,
        "currency_code": "GBP",
        "asset_liability": "equity",
        "type": "share",
        "capital_tier": "ce_tier_1",
        "purpose": "share_capital",
        "status": "paid_up"
      }
    ]
  }
}

Cash on-hand

Cash balance representing 1000 GBP.

{
  "title": "cash_on_hand",
  "comment": "cash_on_hand",
  "data": {
    "security": [
      {
        "id": "cash_on_hand",
        "date": "2019-01-01T00:00:00",
        "balance": 100000,
        "currency_code": "GBP",
        "asset_liability": "asset",
        "type": "cash"
      }
    ]
  }
}

Cash receivable

Cash receivable representing a 1000 GBP claim expiring on August 1st 2020 on a security with isin ‘DUMMYISIN123’.

{
  "title": "cash_receivable",
  "comment": "cash_receivable",
  "data": {
    "security": [
      {
        "id": "cash_receivable",
        "date": "2020-07-30T00:00:00",
        "balance": -100000,
        "currency_code": "GBP",
        "asset_liability": "asset",
        "type": "cash",
        "end_date": "2020-08-01T00:00:00+00:00",
        "isin_code": "DUMMYISIN123"
      }
    ]
  }
}

Cash payable

Cash payable representing a 1000 GBP claim expiring on August 1st 2020 on a security with isin ‘DUMMYISIN123’.

{
  "title": "cash_payable",
  "comment": "cash_payable",
  "data": {
    "security": [
      {
        "id": "cash_payable",
        "date": "2020-07-30T00:00:00",
        "balance": 100000,
        "currency_code": "GBP",
        "asset_liability": "liability",
        "type": "cash",
        "end_date": "2020-08-01T00:00:00+00:00",
        "isin_code": "DUMMYISIN123"
      }
    ]
  }
}

Collateral posted to ccp on non-derivatives

Non-derivatives IM posted to a CCP (e.g. RepoClear)

Security has “purpose” = “collateral” which signals it is not linked to derivative transactions.

{
  "title": "security_collateral_posted_ccp_non_deriv",
  "comment": "security_collateral_posted_ccp_non_deriv",
  "data": {
    "agreement": [
      {
        "id": "MNA1",
        "date": "2018-12-31 00:00:00",
        "start_date": "2017-01-31 00:00:00",
        "country_code": "GB",
        "type": "isda"
      }
    ],
    "customer": [
      {
        "id": "customer_ccp",
        "date": "2018-12-31 00:00:00",
        "type": "ccp",
        "country_code": "GB"
      }
    ],
    "security": [
      {
        "id": "collat_cash_posted_50",
        "date": "2018-12-31 00:00:00",
        "trade_date": "2018-12-31 00:00:00",
        "start_date": "2018-12-31 00:00:00",
        "asset_liability": "asset",
        "currency_code": "GBP",
        "balance": 5000,
        "mtm_dirty": 5000,
        "type": "bond",
        "purpose": "collateral",
        "mna_id": "MNA1",
        "customer_id": "customer_ccp"
      }
    ]
  }
}

Initial margin posted

Bond collateral used as initial margin posted

{
  "title": "collateral_initial_margin_bond_posted",
  "comment": "Collateral Initial Margin Bond Posted",
  "data": {
    "security": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "im_posted_bond",
        "customer_id": "credit_insitution",
        "mna_id": "isda_master_agreement",
        "csa_id": "csa_agreement",
        "type": "bond",
        "issuer_id": "French Republic",
        "isin_code": "FR0000571218",
        "issue_date": "1998-03-12T00:00:00",
        "maturity_date": "2025-04-29T00:00:00",
        "purpose": "independent_collateral_amount",
        "asset_liability": "asset",
        "currency_code": "EUR",
        "notional_amount": 100,
        "mtm_dirty": -145,
        "trade_date": "2020-03-31T00:00:00",
        "start_date": "2020-03-31T00:00:00",
        "cqs_standardised": 1
      }
    ],
    "issuer": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "French Republic",
        "lei_code": "9695006J0AWHMYNZAL19",
        "type": "central_govt",
        "country_code": "FR",
        "snp_lt": "aa_plus",
        "moodys_lt": "aa1"
      }
    ],
    "customer": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "credit_insitution",
        "type": "credit_institution",
        "currency_code": "GBP",
        "country_code": "GB"
      }
    ],
    "agreement": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "isda_master_agreement",
        "type": "isda",
        "base_currency_code": "GBP",
        "country_code": "GB"
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "csa_agreement",
        "type": "isda",
        "base_currency_code": "EUR",
        "credit_support_type": "scsa_isda_2013",
        "margin_frequency": "daily",
        "threshold": 10,
        "minimum_transfer_amount": 5,
        "country_code": "GB"
      }
    ]
  }
}

Independent amount received

Bond collateral used as independent amount received

{
  "title": "collateral_independent_amount_bond_received",
  "comment": "Collateral Independent Amount Bond Received",
  "data": {
    "security": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "independent_amount",
        "customer_id": "corporate",
        "mna_id": "master_agreement",
        "type": "bond",
        "issuer_id": "Asian Development Bank",
        "isin_code": "NZADBDT007C4",
        "issue_date": "2017-05-30T00:00:00",
        "maturity_date": "2024-05-30T00:00:00",
        "purpose": "independent_collateral_amount",
        "asset_liability": "liability",
        "currency_code": "NZD",
        "notional_amount": 100,
        "mtm_dirty": 17,
        "trade_date": "2020-03-31T00:00:00",
        "start_date": "2020-03-31T00:00:00",
        "cqs_standardised": 1
      }
    ],
    "issuer": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "Asian Development Bank",
        "lei_code": "549300X0MVH42CY8Q105",
        "type": "mdb",
        "country_code": "PH",
        "snp_lt": "aaa",
        "moodys_lt": "aaa"
      }
    ],
    "customer": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "corporate",
        "type": "corporate",
        "currency_code": "SGD",
        "country_code": "SG"
      }
    ],
    "agreement": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "master_agreement",
        "type": "isda",
        "base_currency_code": "SGD",
        "netting_restriction": "restrictive_covenant",
        "incurred_cva": 10,
        "country_code": "SG"
      }
    ]
  }
}

Reverse repo

Reverse repo transaction with a cash leg of 150 GBP, and a security leg of 140 GBP, starting on June 1st, 2021 and ending on July 1st, 2021. The maturity date on the security leg refers to the maturity of the bond received as collateral.

{
  "title": "rev_repo",
  "comment": "rev_repo",
  "data": {
    "security": [
      {
        "id": "rev_repo_cash_leg",
        "date": "2021-06-15T00:00:00",
        "currency_code": "GBP",
        "end_date": "2021-07-01T00:00:00Z",
	"cqs_standardised": 1,
	"hqla_class": "i",
	"issuer_id": "uk_central_government_id",
        "balance": -15000,
        "movement": "cash",
        "sft_type": "rev_repo",
        "start_date": "2021-06-01T00:00:00Z",
        "type": "bond",
        "trade_date": "2021-06-01T00:00:00Z",
        "asset_liability": "asset"
      },
      {
        "id": "rev_repo_asset_leg",
        "date": "2021-06-15T00:00:00",
        "currency_code": "GBP",
        "end_date": "2021-07-01T00:00:00Z",
	"cqs_standardised": 1,
	"hqla_class": "i",
        "mtm_dirty": 14000,
        "movement": "asset",
        "sft_type": "rev_repo",
        "start_date": "2021-06-01T00:00:00Z",
        "type": "bond",
        "trade_date": "2021-06-01T00:00:00Z",
        "asset_liability": "liability",
        "issuer_id": "uk_central_government_id",
        "maturity_date": "2030-01-01T00:00:00Z"
      }
    ]
  }
}

Repo

Repo transaction with a cash leg of 150 GBP, and a security leg of 140 GBP, starting on June 1st, 2021 and ending on July 1st, 2021. The maturity date on the security leg refers to the maturity of the bond posted as collateral.

{
  "title": "repo",
  "comment": "repo",
  "data": {
    "security": [
      {
        "id": "repo_cash_leg",
        "date": "2021-06-15T00:00:00",
        "currency_code": "GBP",
        "end_date": "2021-07-01T00:00:00Z",
        "balance": 15000,
	"cqs_standardised": 1,
	"hqla_class": "i",
	"issuer_id": "uk_central_government_id",
        "movement": "cash",
        "sft_type": "repo",
        "start_date": "2021-06-01T00:00:00Z",
        "type": "bond",
        "trade_date": "2021-06-01T00:00:00Z",
        "asset_liability": "liability"
      },
      {
        "id": "repo_asset_leg",
        "date": "2021-06-15T00:00:00",
        "currency_code": "GBP",
        "end_date": "2021-07-01T00:00:00Z",
	"cqs_standardised": 1,
	"hqla_class": "i",
        "mtm_dirty": -14000,
        "movement": "asset",
        "sft_type": "repo",
        "start_date": "2021-06-01T00:00:00Z",
        "type": "bond",
        "trade_date": "2021-06-01T00:00:00Z",
        "asset_liability": "asset",
        "issuer_id": "uk_central_government_id",
        "maturity_date": "2030-01-01T00:00:00Z"
      }
    ]
  }
}

Variation margin cash posted

Cash collateral used as variation margin posted

{
  "title": "collateral_variation_margin_cash_posted",
  "comment": "Collateral Variation Margin Cash Posted",
  "data": {
    "security": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "vm_cash_posted",
        "customer_id": "qccp",
        "mna_id": "ccp_master_agreement",
        "csa_id": "ccp_margin_agreement",
        "type": "cash",
        "purpose": "variation_margin",
        "asset_liability": "asset",
        "currency_code": "USD",
        "notional_amount": 25,
        "balance": -25,
        "trade_date": "2020-03-31T00:00:00",
        "start_date": "2020-03-31T00:00:00"
      }
    ],
    "customer": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "qccp",
        "type": "qccp",
        "currency_code": "GBP",
        "country_code": "GB"
      }
    ],
    "agreement": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "ccp_master_agreement",
        "type": "isda",
        "base_currency_code": "GBP",
        "incurred_cva": 0,
        "country_code": "GB"
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "ccp_margin_agreement",
        "type": "isda",
        "base_currency_code": "GBP",
        "credit_support_type": "csa_isda_1995",
        "margin_frequency": "daily_settled",
        "country_code": "GB"
      }
    ]
  }
}

Variation margin cash received

Cash collateral used as variation margin received

{
  "title": "collateral_variation_margin_cash_received",
  "comment": "Collateral Variation Margin Cash Received",
  "data": {
    "security": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "vm_cash_received",
        "customer_id": "qccp",
        "mna_id": "ccp_master_agreement",
        "csa_id": "ccp_margin_agreement",
        "type": "cash",
        "purpose": "variation_margin",
        "asset_liability": "liability",
        "currency_code": "EUR",
        "notional_amount": 100,
        "balance": 100,
        "trade_date": "2020-03-31T00:00:00",
        "start_date": "2020-03-31T00:00:00"
      }
    ],
    "customer": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "qccp",
        "type": "qccp",
        "currency_code": "GBP",
        "country_code": "GB"
      }
    ],
    "agreement": [
      {
        "date": "2020-03-31T00:00:00",
        "id": "ccp_master_agreement",
        "type": "isda",
        "base_currency_code": "GBP",
        "incurred_cva": 0,
        "country_code": "GB"
      },
      {
        "date": "2020-03-31T00:00:00",
        "id": "ccp_margin_agreement",
        "type": "isda",
        "base_currency_code": "GBP",
        "credit_support_type": "csa_isda_1995",
        "margin_frequency": "daily_settled",
        "country_code": "GB"
      }
    ]
  }
}

layouttitle
schemaaccount

Account Schema


An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.

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_demandfv_mandatorilyfv_ocifv_thru_pnlheld_for_hedgeheld_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
assetequityliabilitypnl
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-
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-
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-YTCCCDCFCGCHCICKCLCMCNCOCRCUCVCWCXCYCZDEDJDKDMDODZECEEEGEHERESETFIFJFKFMFOFRGAGBGDGEGFGGGHGIGLGMGNGPGQGRGSGTGUGWGYHKHMHNHRHTHUIDIEILIMINIOIQIRISITJEJMJOJPKEKGKHKIKMKNKPKRKWKYKZLALBLCLILKLRLSLTLULVLYMAMCMDMEMFMGMHMKMLMMMNMOMPMQMRMSMTMUMVMWMXMYMZNANCNENFNGNINLNONPNRNUNZOMPAPEPFPGPHPKPLPMPNPRPSPTPWPYQAQMQNQOQPQQQRQSQTQUQVQWQXQYQZRERORSRURWSASBSCSDSESGSHSISJSKSLSMSNSOSRSSSTSVSXSYSZTCTDTFTGTHTJTKTLTMTNTOTRTTTVTWTZUAUGUMUSUYUZVAVCVEVGVIVNVUWFWSXAXBXCXDXEXFXGXHXIXJXKXLXMXNXOXPXQXRXSXTXUXVXWXXXYXZYEYTZAZMZWZZ
cr_approach
Specifies the approved credit risk rwa calculation approach to be applied to the exposure.
string
airbfirbsec_erbasec_sasec_sa_ltstd
currency_code
Currency in accordance with ISO 4217 standards plus CNH for practical considerations.
string
AEDAFNALLAMDANGAOAARSAUDAWGAZNBAMBBDBDTBGNBHDBIFBMDBNDBOBBOVBRLBSDBTNBWPBYNBZDCADCDFCHECHFCHWCLFCLPCNHCNYCOPCOUCRCCUCCUPCVECZKDJFDKKDOPDZDEGPERNETBEURFJDFKPGBPGELGHSGIPGMDGNFGTQGYDHKDHNLHRKHTGHUFIDRILSINRIQDIRRISKJMDJODJPYKESKGSKHRKMFKPWKRWKWDKYDKZTLAKLBPLKRLRDLSLLYDMADMDLMGAMKDMMKMNTMOPMRUMURMVRMWKMXNMXVMYRMZNNADNGNNIONOKNPRNZDOMRPABPENPGKPHPPKRPLNPYGQARRONRSDRUBRWFSARSBDSCRSDGSEKSGDSHPSLLSOSSRDSSPSTNSYPSZLTHBTJSTMTTNDTOPTRYTTDTWDTZSUAHUGXUSDUSNUSSUYIUYUUYWUZSVESVNDVUVWSTXAFXAGXAUXBAXBBXBCXBDXCDXDRXOFXPDXPFXPTXSUXTSXUAXXXYERZARZMW
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
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-
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-
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_difcy_dpscz_difde_edbde_edode_edwdk_gdfiee_dgses_fgdfi_dgffr_fdggb_fscsgr_dgshr_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-
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-
ledger_code
The internal ledger code or line item name.
string-
limit_amount
The minimum balance the customer can go overdrawn in their account.
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-
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-
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-
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_derivdealing_rev_deriv_nsedealing_rev_fxdealing_rev_fx_nsedealing_rev_irdealing_rev_secdealing_rev_sec_nsedealing_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_bond_and_frnint_on_bridging_loanint_on_credit_cardint_on_depositint_on_deriv_hedgeint_on_derivativeint_on_ecgd_lendingint_on_loan_and_advint_on_money_mktint_on_mortgageint_on_sftint_unallocatedinterestintra_group_feeinv_in_subsidiaryinvestment_banking_feeinvestment_propertyipslandloan_and_advance_feemachinerymanufactured_dividendmortgage_feemtg_ins_nonconformmtg_insuranceni_contributionnon_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_brokeragepropertypv_future_spread_increc_unidentified_cptyreclass_taxrecoveryredundancy_pymtreferencereg_lossregular_wagesreleaserentres_fund_contributionrestructuringretained_earningsrevaluationrevenue_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
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-
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_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-
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
activecancelledcancelled_payout_agreedothertransactional
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
amortisationbondscallcdcredit_cardcurrentcurrent_iodeferreddeferred_taxdepreciationexpenseincomeintangibleinternet_onlyiraisaisa_currentisa_current_ioisa_ioisa_time_depositisa_time_deposit_iomoney_marketnon_deferrednon_productotherprepaid_cardprovisionreserveretail_bondssavingssavings_iosuspensetangiblethird_party_savingstime_deposittime_deposit_iovostro
uk_funding_type
Funding type calculated according to BIPRU 12.5/12.6
string
ab
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-
layouttitle
schemaaccount

Account Schema


An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.

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_demandfv_mandatorilyfv_ocifv_thru_pnlheld_for_hedgeheld_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
assetequityliabilitypnl
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-
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-
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-YTCCCDCFCGCHCICKCLCMCNCOCRCUCVCWCXCYCZDEDJDKDMDODZECEEEGEHERESETFIFJFKFMFOFRGAGBGDGEGFGGGHGIGLGMGNGPGQGRGSGTGUGWGYHKHMHNHRHTHUIDIEILIMINIOIQIRISITJEJMJOJPKEKGKHKIKMKNKPKRKWKYKZLALBLCLILKLRLSLTLULVLYMAMCMDMEMFMGMHMKMLMMMNMOMPMQMRMSMTMUMVMWMXMYMZNANCNENFNGNINLNONPNRNUNZOMPAPEPFPGPHPKPLPMPNPRPSPTPWPYQAQMQNQOQPQQQRQSQTQUQVQWQXQYQZRERORSRURWSASBSCSDSESGSHSISJSKSLSMSNSOSRSSSTSVSXSYSZTCTDTFTGTHTJTKTLTMTNTOTRTTTVTWTZUAUGUMUSUYUZVAVCVEVGVIVNVUWFWSXAXBXCXDXEXFXGXHXIXJXKXLXMXNXOXPXQXRXSXTXUXVXWXXXYXZYEYTZAZMZWZZ
cr_approach
Specifies the approved credit risk rwa calculation approach to be applied to the exposure.
string
airbfirbsec_erbasec_sasec_sa_ltstd
currency_code
Currency in accordance with ISO 4217 standards plus CNH for practical considerations.
string
AEDAFNALLAMDANGAOAARSAUDAWGAZNBAMBBDBDTBGNBHDBIFBMDBNDBOBBOVBRLBSDBTNBWPBYNBZDCADCDFCHECHFCHWCLFCLPCNHCNYCOPCOUCRCCUCCUPCVECZKDJFDKKDOPDZDEGPERNETBEURFJDFKPGBPGELGHSGIPGMDGNFGTQGYDHKDHNLHRKHTGHUFIDRILSINRIQDIRRISKJMDJODJPYKESKGSKHRKMFKPWKRWKWDKYDKZTLAKLBPLKRLRDLSLLYDMADMDLMGAMKDMMKMNTMOPMRUMURMVRMWKMXNMXVMYRMZNNADNGNNIONOKNPRNZDOMRPABPENPGKPHPPKRPLNPYGQARRONRSDRUBRWFSARSBDSCRSDGSEKSGDSHPSLLSOSSRDSSPSTNSYPSZLTHBTJSTMTTNDTOPTRYTTDTWDTZSUAHUGXUSDUSNUSSUYIUYUUYWUZSVESVNDVUVWSTXAFXAGXAUXBAXBBXBCXBDXCDXDRXOFXPDXPFXPTXSUXTSXUAXXXYERZARZMW
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
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-
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-
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_difcy_dpscz_difde_edbde_edode_edwdk_gdfiee_dgses_fgdfi_dgffr_fdggb_fscsgr_dgshr_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-
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-
ledger_code
The internal ledger code or line item name.
string-
limit_amount
The minimum balance the customer can go overdrawn in their account.
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-
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-
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-
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_derivdealing_rev_deriv_nsedealing_rev_fxdealing_rev_fx_nsedealing_rev_irdealing_rev_secdealing_rev_sec_nsedealing_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_bond_and_frnint_on_bridging_loanint_on_credit_cardint_on_depositint_on_deriv_hedgeint_on_derivativeint_on_ecgd_lendingint_on_loan_and_advint_on_money_mktint_on_mortgageint_on_sftint_unallocatedinterestintra_group_feeinv_in_subsidiaryinvestment_banking_feeinvestment_propertyipslandloan_and_advance_feemachinerymanufactured_dividendmortgage_feemtg_ins_nonconformmtg_insuranceni_contributionnon_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_brokeragepropertypv_future_spread_increc_unidentified_cptyreclass_taxrecoveryredundancy_pymtreferencereg_lossregular_wagesreleaserentres_fund_contributionrestructuringretained_earningsrevaluationrevenue_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
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-
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_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-
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
activecancelledcancelled_payout_agreedothertransactional
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
amortisationbondscallcdcredit_cardcurrentcurrent_iodeferreddeferred_taxdepreciationexpenseincomeintangibleinternet_onlyiraisaisa_currentisa_current_ioisa_ioisa_time_depositisa_time_deposit_iomoney_marketnon_deferrednon_productotherprepaid_cardprovisionreserveretail_bondssavingssavings_iosuspensetangiblethird_party_savingstime_deposittime_deposit_iovostro
uk_funding_type
Funding type calculated according to BIPRU 12.5/12.6
string
ab
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-
layouttitle
schemaadjustment

Adjustment Schema


An adjustment represents a modification to a report.

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-
col
The column of the report that this adjustment relates to.
string-
comment
The description or commentary around the adjustment.
string-
contribution_amount
The contribution amount this adjustment should make to the specified report cell. A positive/negative number in minor units (cents/pence).
integer-
contribution_text
The text to use for the adjustment where the reported cell is not a monetary value.
string-
currency_code
Currency in accordance with ISO 4217 standards plus CNH for practical considerations.
string
AEDAFNALLAMDANGAOAARSAUDAWGAZNBAMBBDBDTBGNBHDBIFBMDBNDBOBBOVBRLBSDBTNBWPBYNBZDCADCDFCHECHFCHWCLFCLPCNHCNYCOPCOUCRCCUCCUPCVECZKDJFDKKDOPDZDEGPERNETBEURFJDFKPGBPGELGHSGIPGMDGNFGTQGYDHKDHNLHRKHTGHUFIDRILSINRIQDIRRISKJMDJODJPYKESKGSKHRKMFKPWKRWKWDKYDKZTLAKLBPLKRLRDLSLLYDMADMDLMGAMKDMMKMNTMOPMRUMURMVRMWKMXNMXVMYRMZNNADNGNNIONOKNPRNZDOMRPABPENPGKPHPPKRPLNPYGQARRONRSDRUBRWFSARSBDSCRSDGSEKSGDSHPSLLSOSSRDSSPSTNSYPSZLTHBTJSTMTTNDTOPTRYTTDTWDTZSUAHUGXUSDUSNUSSUYIUYUUYWUZSVESVNDVUVWSTXAFXAGXAUXBAXBBXBCXBDXCDXDRXOFXPDXPFXPTXSUXTSXUAXXXYERZARZMW
page
The page of the report that this adjustment relates to.
string-
report_type
The report that this adjustment relates to.
string-
reporting_entity_name
The name of the reporting legal entity for display purposes.
string-
row
The row of the report that this adjustment relates to.
string-
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-
version_id
The version identifier of the data such as the firm’s internal batch identifier.
string-
layouttitle
schemaagreement

Agreement Schema


An agreement represents the standard terms agreed between two parties.

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-
base_currency_code
Currency in accordance with ISO 4217 standards plus CNH for practical considerations.
string
AEDAFNALLAMDANGAOAARSAUDAWGAZNBAMBBDBDTBGNBHDBIFBMDBNDBOBBOVBRLBSDBTNBWPBYNBZDCADCDFCHECHFCHWCLFCLPCNHCNYCOPCOUCRCCUCCUPCVECZKDJFDKKDOPDZDEGPERNETBEURFJDFKPGBPGELGHSGIPGMDGNFGTQGYDHKDHNLHRKHTGHUFIDRILSINRIQDIRRISKJMDJODJPYKESKGSKHRKMFKPWKRWKWDKYDKZTLAKLBPLKRLRDLSLLYDMADMDLMGAMKDMMKMNTMOPMRUMURMVRMWKMXNMXVMYRMZNNADNGNNIONOKNPRNZDOMRPABPENPGKPHPPKRPLNPYGQARRONRSDRUBRWFSARSBDSCRSDGSEKSGDSHPSLLSOSSRDSSPSTNSYPSZLTHBTJSTMTTNDTOPTRYTTDTWDTZSUAHUGXUSDUSNUSSUYIUYUUYWUZSVESVNDVUVWSTXAFXAGXAUXBAXBBXBCXBDXCDXDRXOFXPDXPFXPTXSUXTSXUAXXXYERZARZMW
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
credit_support_type
The type of credit support document
string
csa_isda_1994csa_isda_1995csd_isda_1995scsa_isda_2013
customer_id
The unique identifier used by the financial institution to identify the counterparty to this agreement.
string-
guarantor_id
The unique identifier used by the financial institution to identify the guarantor of the transactions covered by this agreement.
string-
margin_frequency
Indicates the periodic timescale at which variation margin is exchanged. Cleared derivatives which are daily settled can be flagged as daily_settled.
string
dailydaily_settledweeklybi_weeklymonthly
margin_period_of_risk
Margin period of risk estimated for the transactions covered by the [CSA] agreement
integer-
minimum_transfer_amount
Smallest amount of collateral that can be transferred. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
netting_restriction
populated only if any netting restriction applies, in relation to the nature of the agreement or the enforceability of netting in the jurisdiction of the counterparty, preventing the recognition of the agreement as risk-reducing, pursuant to CRR Articles 295 to 298
string
national_supervisionrestrictive_covenant
number_of_disputes
Indicates the number of disputes threshold to be used in the margin period of risk
integer-
source
The source where this data originated.
string-
start_date
The timestamp that the agreement commences. YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
stay_protocol
Indicates whether a stay protocol has been signed by one or both parties to the agreement.
string
bothcustomerself_signed
threshold
Amount below which collateral is not required. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
type
The type of the master agreement.
string
gmraicma_1992icma_1995icma_2000icma_2011isdaisda_1985isda_1986isda_1987isda_1992isda_2002otherother_gmraother_isda
version_id
The version identifier of the data such as the firm’s internal batch identifier.
string-
layouttitle
schemacollateral

Collateral Schema


Data schema to define collateral (currently can reference loans or accounts).

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-
account_ids
The unique identifier/s for the account/s within the financial institution.
array-
charge
Lender charge on collateral, 1 indicates first charge, 2 second and so on. 0 indicates a combination of charge levels.
integer-
currency_code
Currency in accordance with ISO 4217 standards plus CNH for practical considerations.
string
AEDAFNALLAMDANGAOAARSAUDAWGAZNBAMBBDBDTBGNBHDBIFBMDBNDBOBBOVBRLBSDBTNBWPBYNBZDCADCDFCHECHFCHWCLFCLPCNHCNYCOPCOUCRCCUCCUPCVECZKDJFDKKDOPDZDEGPERNETBEURFJDFKPGBPGELGHSGIPGMDGNFGTQGYDHKDHNLHRKHTGHUFIDRILSINRIQDIRRISKJMDJODJPYKESKGSKHRKMFKPWKRWKWDKYDKZTLAKLBPLKRLRDLSLLYDMADMDLMGAMKDMMKMNTMOPMRUMURMVRMWKMXNMXVMYRMZNNADNGNNIONOKNPRNZDOMRPABPENPGKPHPPKRPLNPYGQARRONRSDRUBRWFSARSBDSCRSDGSEKSGDSHPSLLSOSSRDSSPSTNSYPSZLTHBTJSTMTTNDTOPTRYTTDTWDTZSUAHUGXUSDUSNUSSUYIUYUUYWUZSVESVNDVUVWSTXAFXAGXAUXBAXBBXBCXBDXCDXDRXOFXPDXPFXPTXSUXTSXUAXXXYERZARZMW
encumbrance_amount
The amount of the collateral 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_bondderivativenoneotherreal_estaterepo
end_date
The end date for recognition of the collateral
string-
loan_ids
The unique identifiers for the loans within the financial institution.
array-
regulatory_book
The type of portfolio in which the instrument is held.
string
banking_booktrading_book
security_id
The unique identifier used by the financial institution to identify the security representing collateral.
string-
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 start date for recognition of the collateral
string-
type
The collateral type defines the form of the collateral provided
string
cashcommercial_propertydebenturefarmguaranteeimmovable_propertylife_policymultifamilyotherresidential_propertysecurity
value
The valuation as used by the bank for the collateral on the value_date. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
value_date
The timestamp that the collateral was valued. YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
version_id
The version identifier of the data such as the firm’s internal batch identifier.
string-
vol_adj
The volatility adjustment appropriate to the collateral.
number-
vol_adj_fx
The volatility adjustment appropriate to currency mismatch.
number-
layouttitle
schemacurve

Curve Schema


A Curve represents a series of points on a plot. Typically, interest rates, volatility or forward prices.

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-
currency_code
Currency in accordance with ISO 4217 standards plus CNH for practical considerations.
string
AEDAFNALLAMDANGAOAARSAUDAWGAZNBAMBBDBDTBGNBHDBIFBMDBNDBOBBOVBRLBSDBTNBWPBYNBZDCADCDFCHECHFCHWCLFCLPCNHCNYCOPCOUCRCCUCCUPCVECZKDJFDKKDOPDZDEGPERNETBEURFJDFKPGBPGELGHSGIPGMDGNFGTQGYDHKDHNLHRKHTGHUFIDRILSINRIQDIRRISKJMDJODJPYKESKGSKHRKMFKPWKRWKWDKYDKZTLAKLBPLKRLRDLSLLYDMADMDLMGAMKDMMKMNTMOPMRUMURMVRMWKMXNMXVMYRMZNNADNGNNIONOKNPRNZDOMRPABPENPGKPHPPKRPLNPYGQARRONRSDRUBRWFSARSBDSCRSDGSEKSGDSHPSLLSOSSRDSSPSTNSYPSZLTHBTJSTMTTNDTOPTRYTTDTWDTZSUAHUGXUSDUSNUSSUYIUYUUYWUZSVESVNDVUVWSTXAFXAGXAUXBAXBBXBCXBDXCDXDRXOFXPDXPFXPTXSUXTSXUAXXXYERZARZMW
name
The internal name of the curve.
string-
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 curve type.
string
behavioralratevolatility
values
The list of values for this curve.
array-
version_id
The version identifier of the data such as the firm’s internal batch identifier.
string-
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