Entity debtor

Details of entity debtor

Name

debtor

Code

debtor

Parent

Logical Data Model 'RRE DDA PER BANK LDM'

Comment

Debtor means the counterparty which has the unconditional obligation to make repayments arising under the instrument.

Parent Entity

counterparty role


List of attributes of the entity debtor

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

 

counterparty role

entty_rl

Role of the counterparty in an instrument.

Variable characters (25)

counterparty-instrument role type

X

X

 

counterparty identifier

counterparty_identifier

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

Each counterparty identifier must be unique for each counterparty reported by the same reporting agent and the same counterparty must be identified by the reporting agent using the same counterparty identifier. This identifier must not be reused by the same reporting agent at any point in time to identify a different counterparty.

Variable characters (60)

identifier domain

X

X

 

reporting reference date

reporting_reference_date

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

Defined as yyyy-mm-dd.

Date

reporting reference date

X

X

 

current debtor's employment status

current_debtor_s_employment_status

Code is a free format text that descibes the code of the logical data model.

Variable multibyte (255)

code

 

 

X

inception date of first instrument for investing in RRE

inception_date_of_first_instrument_for_investing_in_rre

The date on which the first instrument for investing in RRE originated between the debtor and the reporting agent.

Date

date with exclusions

 

 

 

debtor past due indicator

debtor_past_due_indicator

Debtor past due indicator indicates whether or not a debtor is past due. According to Regulation (EU) No 680/2014 assets qualify as past due when counterparties have failed to make a payment when contractually due. Note that past due occurs as soon as the debtor is already one day past due.

Variable characters (50)

debtor past due indicator

X

 

 

current toetsinkomen

current_toetsinkomen

The current toetsinkomen is the most recent value of the toetsinkomen of the debtor or as an alternative a close proxy of the toetsinkomen (e.g. the gross annual income of the debtor) which is available to the reporting agent.

Decimal (12,0)

euro amount (positive and negative)

 

 

 

date of current toetsinkomen

date_of_current_toetsinkomen

The date of current toetsinkomen is the date to which the current toetsinkomen refers.

Date

date

 

 

 

total assets

total_assets

The total assets is the value of all assets (pledged and unpledged) of the debtor or as an alternative a close proxy of the total assets.

Decimal (12,0)

euro amount (positive and negative)

 

 

 

date of total assets

date_of_total_assets

The date of total assets is the date to which the total assets refers.

Date

date

 

 

 

total liabilities

total_liabilities

The total liabilities is the value of all liabilities of the debtor or as an alternative a close proxy of the total liabilities.

Decimal (12,0)

euro amount (positive and negative)

 

 

 

date of total liabilities

date_of_total_liabilities

The date of total liabilities is the date to which the total liabilities refers.

Date

date

 

 

 

date of current debtor's employment status

date_of_current_debtor_s_employment_status

The date of current debtor’s employment status is the date to which the current debtor’s employment status refers.

Date

date

 

 

 


List of child entities of the entity debtor

Child Entity

Inheritance

debtor past due

debtor past due indicator

debtor not past due

debtor past due indicator


List of relationships of the entity debtor

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

employment status_classifies_debtor

employment_status_classifies_debtor

X

debtor

employment status

 

0,n

1,1

has

debtor_has_ead_model

X

EAD model debtor

debtor

EAD model debtor -> debtor

0,n

1,1

has

debtor_has_lgd_model

X

LGD model debtor

debtor

LGD model debtor -> debtor

0,n

1,1

has

debtor_has_debtor_instrument_data

X

debtor-instrument data

debtor

debtor-instrument data -> debtor

1,n

1,1

has

debtor_has_pd_model

X

PD model debtor

debtor

PD model debtor -> debtor

0,n

1,1

has default data in

debtor_has_default_data_in_debtor_data

X

debtor default data

debtor

debtor default data -> debtor

0,n

1,1


List of child inheritances of the entity debtor

Name

Code

Mutually Exclusive

Inherit All

Generate Parent

Generate Children

debtor past due indicator

debtor_past_due_indicator

X

 

X

X


List of parents of the entity debtor

Parent

Parent Entity Code

Logical Data Model 'RRE DDA PER BANK LDM'

entty_rl_ancrdt_cllctn


List of identifiers of the entity debtor

Name

Code

Parent

Primary Identifier

debtor PK

debtor_pk

Entity 'debtor'

X


List of associated business rules of the entity debtor

Name

Code

Rule Type

debtor omc0024 inception date of first instrument for investing in RRE cannot be "non-applicable" in case bsi class of the instrument is 'woninghypotheken"

omc0024

Constraint

debtor ssmc0001 debtor is always a household

ssmc0001

Constraint

debtor omc0009 at least one recognized instrument needed for default data

omc0009

Constraint