Entity instrument

Details of entity instrument

Name

instrument

Code

instrument

Parent

Logical Data Model 'AnaCredit GLO per bank LDM'

Comment

'instrument' means any item specified in the data attribute 'type of instrument', as defined in Annex IV.

The level of granularity for the instrument data is the instrument. Each record is uniquely identified by the combination of the following data attributes: (a) reporting agent identifier; (b) observed agent identifier; (c) contract identifier; and (d) instrument identifier."

Parent Entity

<None>


List of attributes of the entity instrument

Name

Code

Comment

Data Type

Domain

Mandatory

Primary Identifier

Foreign Identifier

reporting agent identifier

reporting_agent_identifier

 

Variable characters (60)

identifier domain

X

X

X

observed agent identifier

obsrvd_agnt_cd

Observed agent identifier is a number, assigned by De Nederlandsche Bank, that uniquely identifies the observed agent.

Variable characters (60)

identifier domain

X

X

X

reporting reference date

reporting_reference_date

 

Date

reporting reference date

X

X

X

contract identifier

cntrct_id

An identifier applied by the reporting agent to uniquely identify each contract. Each contract must have one contract identifier. This value will not change over time and cannot be used as the contract identifier for any other contract.
Each contract identifier must be unique for each contract that generates credit risk for the same observed agent. This identifier must not be reused at any point in time to identify a different contract with the same observed agent.

Variable characters (60)

identifier domain

X

X

X

instrument identifier

instrmnt_id

An identifier applied by the reporting agent to uniquely identify each instrument under a single contract. Each instrument must have one instrument identifier. This value will not change over time and cannot be used as the instrument identifier for any other instrument under the same contract.

Each instrument identifier must be unique for each contract, i.e. all instruments embedded in a single contract are to be assigned a different instrument identifier, and these must not be reused at any point in time to identify a different instrument within the contract. However, instruments associated with different contracts may use the same identifier.

Variable characters (60)

identifier domain

X

X

 

type of instrument

typ_instrmnt

Classification of the instrument according to the type of contractual terms agreed between the parties.

Variable multibyte (255)

code

X

 

X

inception date of the instrument

dt_incptn_instmnt

The inception date of the instrument is the date on which the current instrument relationship originated, i.e. the date on which the instrument agreement became binding for all parties.

Defined as yyyy-mm-dd.

The inception date of the instrument is the date on which the instrument, belonging to the contract, became binding for al parties.

Date

date with unknown

X

 

 

amortisation type

typ_amrtstn

Type of amortisation of the instrument including principal and interest.

Variable multibyte (255)

code

X

 

X

currency

crrncy_dnmntn

Currency denomination of instrument, in accordance with the ISO's 4217 standard.

Characters (3)

ISO 4217 Currency

X

 

X

fiduciary instrument

fdcry

Identification of instruments in which the observed agent acts in its own name but on behalf of and with the risk borne by a third party.

Variable multibyte (255)

code

X

 

X

interest rate reset frequency

intrst_rt_rst_frqncy

Frequency at which the interest rate is reset after the initial fixed-rate period, if any.

Variable multibyte (255)

code

X

 

X

interest rate type

typ_intrst_rt

Classification of credit exposures based on the base rate for establishing the interest rate for each payment period.

Variable multibyte (255)

code

X

 

X

legal final maturity date

dt_lgl_fnl_mtrty

The contractual maturity date of the instrument, taking into account any agreements amending initial contracts.

Defined as yyyy-mm-dd.

Date

date with exclusions

X

 

 

commitment amount at inception

cmmtmnt_incptn

Observed agent's maximum exposure to credit risk on the inception date of the instrument, without taking into account any protection held or other credit enhancements.

Total commitment amount on the inception date is established during the approval process and is intended to restrict an observed agent’s amount of credit risk to a given counterparty for the relevant instrument.

Amount in euro. Foreign currency amounts should be converted into euro at the respective ECB euro foreign exchange reference rates (i.e. the mid-rate) on the reporting reference date.

Commitment amount at inception is mandatory, except for instruments of type overdraft when applicable to current accounts with no credit limit.

Decimal (16,0)

euro amount (non-negative) with exclusions

X

 

 

payment frequency

pymnt_frqncy

Frequency of payments due, either of principal or interest, i.e. number of months between payments.

Variable multibyte (255)

code

X

 

X

project finance loan

prjct_fnnc_ln

Identification of project finance

Variable multibyte (255)

code

X

 

X

purpose

prps

Classification of instruments according to their purpose.

Variable multibyte (255)

code

X

 

X

recourse

rcrs

Classification of instruments based on the creditor’s rights to seize assets other than any protection pledged to secure the instrument.

Variable multibyte (255)

code

X

 

X

subordinated debt

sbrdntd_dbt

Identification of subordinated debt.
Subordinated debt instruments provide a subsidiary claim on the issuing institution that can only be exercised after all claims with a higher status (e.g. deposits/loans) have been satisfied.

Variable multibyte (255)

code

X

 

X

repayment rights

rpymnt_rghts

Classification of credit exposures according to the creditor's rights to claim the repayment of the exposure.

Variable multibyte (255)

code

X

 

X

interest-only indicator

interest_only_indicator

Interest-only indicator distinguishes instruments according to the fact that at the reporting reference date, the instrument is interest-only or not interest-only.

When the amortisation type is
- 'French', or
- 'Fixed amortisation schedule', or
- 'Other',
Then
the interest-only indicator must be a "non-interest-only instrument".

Variable characters (50)

interest-only indicator

X

 

 

credit risk deterioration purchase indicator

credit_risk_deterioration_purchase_indicator

Credit risk deterioration purchase indicator indicates whether the instrument was bought for an amount lower than the outstaning amount due to credit risk deterioration, or whether that is not the case.

Variable characters (100)

credit risk deterioration purchase indicator

X

 

 

drawn instrument indicator

drawn_instrument_indicator

Drawn instrument indicator distinguishes financial data into those data relating to instruments where money has been drawn from and those where no money has (yet) been drawn from.

Variable characters (25)

drawn instrument indicator

X

 

 


List of child entities of the entity instrument

Child Entity

Inheritance

drawn instrument

drawn instrument indicator

undrawn instrument

drawn instrument indicator

fixed interest instrument

interest rate type

non-fixed interest instrument

interest rate type

interest-only instrument

interest-only indicator

non-interest-only instrument

interest-only indicator

non-deteriorated credit risk instrument

credit risk deterioration purchase indicator

deteriorated credit risk instrument

credit risk deterioration purchase indicator


List of relationships of the entity instrument

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

classifies

instrument_purpose_classifies_instrument

X

instrument

instrument purpose

 

0,n

1,1

classifies

payment_frequency_classifies_instrument

X

instrument

payment frequency

 

0,n

1,1

classifies

interest_rate_reset_frequency_classifies_instrument

X

instrument

interest rate reset frequency

 

0,n

1,1

classifies

project_finance_loan_indicator_classifies_instrument

X

instrument

project finance loan indicator

 

0,n

1,1

classifies

recourse_indicator_classifies_instrument

X

instrument

recourse indicator

 

0,n

1,1

classifies

subordinated_debt_indicator_classifies_instrument

X

instrument

subordinated debt indicator

 

0,n

1,1

classifies

repayment_rights_classifies_instrument

X

instrument

repayment rights

 

0,n

1,1

classifies

interest_rate_type_classifies_instrument

X

instrument

interest rate type

 

0,n

1,1

classifies

fiduciary_instrument_indicator_classifies_instrument

X

instrument

fiduciary instrument indicator

 

0,n

1,1

classifies

type_of_instrument_classifies_instrument

X

instrument

type of instrument

 

0,n

1,1

classifies

amortisation_type_classifies_instrument

X

instrument

amortisation type

 

0,n

1,1

contains

contract_contains_instrument

X

instrument

contract

instrument -> contract

0,n

1,1

has

instrument_has_accounting_data

X

accounting data

instrument

accounting data -> instrument

0,1

1,1

has

instrument_has_financial_data

X

financial data

instrument

financial data -> instrument

1,1

1,1

has

instrument_has_instrument_protection_received_data

X

instrument-protection received data

instrument

instrument-protection received data -> instrument

0,n

1,1

has creditor via

instrument_has_creditor_via_creditor_instrument_data

X

instrument

creditor-instrument data

creditor-instrument data -> instrument

1,1

1,n

has debtor via

instrument_has_debtor_via_debtor_instrument_data

X

debtor-instrument data

instrument

debtor-instrument data -> instrument

1,n

1,1

has servicer via

instrument_has_servicer_via_servicer_instrument_data

X

instrument

servicer-instrument data

servicer-instrument data -> instrument

1,1

1,n

is denomination currency of

currency_is_denomination_currency_of_instrument

X

instrument

currency

 

0,n

1,1


List of child inheritances of the entity instrument

Name

Code

Mutually Exclusive

Inherit All

Generate Parent

Generate Children

credit risk deterioration purchase indicator

credit_risk_deterioration_purchase_indicator

X

 

X

X

drawn instrument indicator

drawn_instrument_indicator

X

 

X

X

interest rate type

interest_rate_type

X

 

X

X

interest-only indicator

interest_only_indicator

X

 

X

X


List of identifiers of the entity instrument

Name

Code

Parent

Primary Identifier

instrument PK

instrument_pk

Entity 'instrument'

X


List of associated business rules of the entity instrument

Name

Code

Rule Type

business rule classification

business rule scope

severity

instrument tpc0001 fiduciary instrument has a different servicer from the creditor

tpc0001

Constraint

tuple constraint

Checked within the data delivery

signalling