Entity debtor-instrument data

Details of entity debtor-instrument data

Name

debtor-instrument data

Code

debtor_instrument_data

Parent

Logical Data Model 'RRE DDA PER BANK LDM'

Comment

Debtor-instrument data is the combination of debtor and instrument that indicates which debtor is debtor for which instrument.

Parent Entity

<None>


List of attributes of the entity debtor-instrument 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

counterparty role

entty_rl

Role of the counterparty in an instrument.

Variable characters (25)

counterparty-instrument role type

X

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

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 entity type delivery pertains to.

Defined as yyyy-mm-dd.

Date

reporting reference date

X

X

X

other debts at inception

other_debts_at_inception

The amount of other outstanding debts of the debtor (e.g. personal loans, revolving loans and overdraft, credit card debt) that are known to the creditor at the moment of inception of the instrument and that have been taken into account for the determination of the borrowing capacity of the debtor at the start of the mortgage loan. In case the debtor had no other debts, please report "0".

Decimal (12,0)

euro amount (non-negative) with exclusions

X

 

 

household type-instrument data indicator

household_type_instrument_data_indicator

The household type-instrument data indicator distinguishes the entity debtor-instrument data into partnership-instrument data and natural person-instrument data.

Variable characters (50)

household type-instrument data indicator

X

 

 


List of child entities of the entity debtor-instrument data

Child Entity

Inheritance

partnership-instrument data

household type-instrument data indicator

natural person-instrument data

household type-instrument data indicator


List of relationships of the entity debtor-instrument data

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

has

debtor_has_debtor_instrument_data

X

debtor-instrument data

debtor

debtor-instrument data -> debtor

1,n

1,1

has

counterparty_instrument_data_has_joint_liability

X

joint liability

debtor-instrument data

joint liability -> debtor-instrument data

0,n

1,1

has debtor via

instrument_has_debtor_via_counterparty_instrument_data

X

debtor-instrument data

instrument

debtor-instrument data -> instrument

1,n

1,1


List of child inheritances of the entity debtor-instrument data

Name

Code

Mutually Exclusive

Inherit All

Generate Parent

Generate Children

household type-instrument data indicator

household_type_instrument_data_indicator

X

 

X

X


List of identifiers of the entity debtor-instrument data

Name

Code

Parent

Primary Identifier

debtor-instrument data PK

debtor_instrument_data_pk

Entity 'debtor-instrument data'

X


List of associated business rules of the entity debtor-instrument data

Name

Code

Rule Type

debtor-instrument data omc0008 joint liability must exist for multiple debtors on instrument

omc0008

Constraint

PD model instrument/contract/debtor omc0113 initial PD of the PD model must be reported at least at one level

omc0113

Constraint