Entity immovable property-rental contract data

Details of entity immovable property-rental contract data

Name

immovable property-rental contract data

Code

immovable_property_rental_contract_data

Parent

Logical Data Model 'CRE GLO per bank LDM'

Comment

 

Parent Entity

<None>


List of attributes of the entity immovable property-rental contract 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

protection identifier

prtctn_id

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

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

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

X


List of relationships of the entity immovable property-rental contract data

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

has

immovable_property_has_immovable_property_rental_contract_data

X

immovable property-rental contract data

immovable property

immovable property-rental contract data -> immovable property

0,n

1,1

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


List of identifiers of the entity immovable property-rental contract data

Name

Code

Parent

Primary Identifier

immovable property-rental contract data PK

rental_contract_protection_received_data_pk

Entity 'immovable property-rental contract data'

X