Entity rental contract

Details of entity rental contract

Name

rental contract

Code

rental_contract

Parent

Logical Data Model 'CRE GLO per bank LDM'

Comment

 

Parent Entity

<None>


List of attributes of the entity rental contract

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

rental contract identifier

rental_contract_identifier

An identifier applied by the reporting agent to uniquely identify each rental contract linked to commercial real estate collateral. Each rental contract must have one rental contract identifier

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

X

rental contract start date

rental_contract_start_date

The rental contract start date is the date that the rental contract involving the real estate collateral becomes legally binding.

Date

date

 

 

 

rental income

rental_income

Rental income is the total rental income per month stipulated in the real estate collateral rental contract.

Decimal (16,0)

euro amount (non-negative)

X

 

 

rental contract type

rental_contract_type

Rental contract type refers to the type of the rental contract of the real estate collateral.

Variable characters (50)

rental contract type

X

 

 


List of child entities of the entity rental contract

Child Entity

Inheritance

indefinite rental contract

rental contract type

fixed term rental contract

rental contract type


List of relationships of the entity rental contract

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

has

rental_contract_has_non_immovable_property_rental_contract_data

X

immovable property-rental contract data

rental contract

immovable property-rental contract data -> rental contract

1,n

1,1

reports

reporting_agent_delivery_reports_rental_contract

X

rental contract

reporting agent delivery

rental contract -> reporting agent delivery

0,n

1,1


List of child inheritances of the entity rental contract

Name

Code

Mutually Exclusive

Inherit All

Generate Parent

Generate Children

rental contract type

rental_contract_type

X

 

X

X


List of identifiers of the entity rental contract

Name

Code

Parent

Primary Identifier

rental contract PK

rental_contract_pk

Entity 'rental contract'

X