Entity financial data

Details of entity financial data

Name

financial data

Code

financial_data

Parent

Logical Data Model 'RRE DDA PER BANK LDM'

Comment

The financial data describes the instrument’s financial development.

Parent Entity

<None>


List of attributes of the entity financial data

Name

Code

Comment

Data Type

Domain

Mandatory

Primary Identifier

Foreign Identifier

reporting agent identifier

reporting_agent_identifier

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

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

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

X

reporting reference date

reporting_reference_date

reporting reference date is a date that indicates the date the attribute type delivery pertains to.

Defined as yyyy-mm-dd.

Date

reporting reference date

X

X

X

outstanding nominal amount

otstndng_nmnl_amnt

Principal amount outstanding at the end of the reporting reference date, including unpaid past due interest but excluding accrued interest. The outstanding nominal amount must be reported net of write-offs and write-downs as determined by the relevant accounting practices. Any drawn amount of an instrument must be registered in the data attribute ‘outstanding nominal amount’."

Decimal (12,0)

euro amount (non-negative)

X

 

 

bouwdepot amount

bwdpt_amnt

Bouwdepot amount is the amount which has been paid out to the debtor in the form of a bouwdepot (building deposit) for the purpose of paying for costs of building and refurbishing residential real estate.

Decimal (12,0)

euro amount (non-negative) with exclusions

X

 

 

periodic repayment due

periodic_repayment_due

The part of the amount of the periodic contractual payment consisting of the periodic repayment of the instrument (e.g. in case of instruments with an linear or annuity amortisation schedule) or premiums and deposits in savings, investment or insurance products for the repayment of the instrument.

Decimal (12,0)

euro amount (non-negative)

X

 

 

periodic interest payment due

periodic_interest_payment_due

The part of the amount of the periodic contractual payment consisting of the periodic interest payment.

Decimal (12,0)

euro amount (non-negative)

X

 

 

next interest rate reset date

next_intrst_rt_reset_dt

The date that the next interest rate reset, as defined in Part 3 of Annex I to Regulation (EU) No 1071/2013 (ECB/2013/33), takes place. If the instrument is not subject to a future interest rate reset, its legal final maturity date will be reported.

Date

date with exclusions

X

 

 

cumulative repayments

cumulative_repayments

The cumulative amount of the periodic contractual payment consisting of the periodic repayment of the instrument (e.g. in case of instruments with an linear or annuity amortisation schedule) or premiums and deposits in savings, investment or insurance products for the repayment of the instrument.

Decimal (12,0)

euro amount (non-negative)

X

 

 

cumulative prepayments

cumulative_prepayments

The cumulative amount of voluntary prepayments on the instrument during the reference period, excluding prepayments in the form of extra premiums and deposits in savings, investment or insurance products for the repayment of the instrument.

Decimal (12,0)

euro amount (non-negative)

X

 

 

interest rate

annlsd_agrd_rt

Annualised agreed rate or narrowly defined interest rate in accordance with Regulation (EU) No 1072/2013 of the European Central Bank (ECB/2013/34) . Regulation (EU) No 1072/2013 of the European Central Bank of 24 September 2013 concerning statistics on interest rates applied by monetary financial institutions (ECB/2013/34) (OJ L 297, 7.11.2013, p. 51).

Decimal (12,0)

real number (positive or negative) with exclusions

X

 

 

accrued interest

accrued_interest

The amount of accrued interest on loans at the reporting reference date as defined in Regulation (EU) No 1071/2013. In accordance with the general principle of accruals accounting, interest receivable on instruments should be subject to on-balance sheet recording as it accrues (i.e. on an accruals basis) rather than when it is actually received (i.e. on a cash basis).

Decimal (12,0)

euro amount (non-negative) with exclusions

X

 

 

exit status

exit_status

Exit status is the indication whether the instrument has disappeared from the report in the reference period. In case the instrument has disappeared the exit status also indicates the reason for disappearance.


Variable multibyte (255)

code

X

 

X

default status of the instrument

dflt_stts

This attribute identifies instruments in default in accordance with the CRR.

Variable multibyte (255)

code

X

 

X

securitized instrument indicator

securitized_instrument_indicator

Securitized instrument indicator distinguishes instruments into those instruments that are part of a securitization and those that are not securitized.

Variable characters (50)

securitisation indicator

X

 

 

past due instrument indicator

past_due_instrument_indicator

Past due instrument indicator distinguishes instruments into instruments which have been past due and instrument which have not been past due.

Variable characters (50)

past due instrument indicator

X

 

 


List of child entities of the entity financial data

Child Entity

Inheritance

instrument subject to securitisation

securitized instrument indicator

instrument not subject to securitisation

securitized instrument indicator

instrument past due

past due instrument indicator

instrument not past due

past due instrument indicator

credit lines other than revolving credit instrument

type of instrument

reverse repurchase agreements instrument

type of instrument

trade receivables instrument

type of instrument

revolving credit other than overdrafts and credit card debt instrument

type of instrument

credit card debt instrument

type of instrument

overdraft instrument

type of instrument

financial leases instrument

type of instrument

other loans instrument

type of instrument


List of relationships of the entity financial data

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

classifies

default_status_classifies_financial_data

X

financial data

default status

 

0,n

1,1

classifies

exit_status_classifies_instrument

X

financial data

exit status

 

0,n

1,1

has

instrument_has_financial_data

X

financial data

instrument

financial data -> instrument

1,1

1,1


List of child inheritances of the entity financial data

Name

Code

Mutually Exclusive

Inherit All

Generate Parent

Generate Children

past due instrument indicator

past_due_instrument_indicator

X

 

X

X

securitized instrument indicator

securitized_instrument_indicator

X

 

X

X

type of instrument

type_of_instrument

X

 

X

X


List of identifiers of the entity financial data

Name

Code

Parent

Primary Identifier

financial data PK

financial_data_pk

Entity 'financial data'

X


List of associated business rules of the entity financial data

Name

Code

Rule Type

financial data tpc0005 next interest rate reset date cannot be earlier than reporting reference rate

tpc0005

Constraint