Entity immovable property

Details of entity immovable property

Name

immovable property

Code

immovable_property

Parent

Logical Data Model 'CRE GLO per bank LDM'

Comment

Immovable property is protection received that does have a fixed location according to its type.

Parent Entity

protection received


List of attributes of the entity immovable property

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

 

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

 

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

 

type of real estate collateral

type_of_real_estate_collateral

 

Variable multibyte (255)

code

X

 

X

liquidation value

liquidation_value

Estimate of realizable real estate collateral value through liquidation at reporting reference date.

Decimal (16,0)

euro amount (non-negative)

 

 

 

parking space attached

parking_space_attached

Parking space attached indicates whether or not the real estate collateral has a parking space attached to it that is taken into account in the valuation of the collateral.

Variable multibyte (255)

code

 

 

X

country

country

Country is a code that indicates the country where the real estate collateral is located.

ISO 3166-1 alpha-2 code of the country.

Characters (2)

ISO 3166 Country

X

 

X


List of child entities of the entity immovable property

Child Entity

Inheritance

domestic immovable property

country

foreign immovable property

country

non-land

type of real estate collateral

land

type of real estate collateral


List of relationships of the entity immovable property

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

classifies

parking_space_classifies_immovable_property

X

immovable property

parking space attached

 

0,n

0,1

classifies

type_of_real_estate_collateral_classifies_immovable_property

X

immovable property

type of real estate collateral

 

0,n

1,1

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

is location of

country_is_location_of_immovable_property

X

immovable property

country

 

0,n

1,1


List of child inheritances of the entity immovable property

Name

Code

Mutually Exclusive

Inherit All

Generate Parent

Generate Children

country

country

X

 

X

X

type of real estate collateral

type_of_real_estate_collateral

X

 

X

X


List of parents of the entity immovable property

Parent

Parent Entity Code

Logical Data Model 'CRE GLO per bank LDM'

protection_received


List of identifiers of the entity immovable property

Name

Code

Parent

Primary Identifier

immovable property PK

immovable_property_pk

Entity 'immovable property'

X


List of mappings of the entity immovable property

Classifier

immovable property