Entity non-land

Details of entity non-land

Name

non-land

Code

non_land

Parent

Logical Data Model 'CRE GLO per bank LDM'

Comment

 

Parent Entity

immovable property


List of attributes of the entity non-land

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

 

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

measurement date of occupancy

measurement_date_of_occupancy

The date on which the occupancy rate of the real estate collateral, as reported in the attribute Occupancy rate, has been measured/recorded.

Date

date with exclusions

 

 

 

occupancy rate

occupancy_rate

Occupancy rate of the real estate collateral means the percentage of the total rentable surface area of the Real estate collateral that is income producing.

Decimal (12,0)

real number (non-negative)

X

 

 

total rentable surface

total_rentable_surface

Total rentable surface of the real estate collateral in square meters.

Decimal (12,0)

real number (non-negative)

X

 

 

street

street

Counterparty's street address, including the street number.

A finite sequence of characters.

Street number is the number of the building on the street.

Variable multibyte (255)

medium sized string

X

 

X

city / town / village

city_town_village

Counterparty's city, town or village.

A finite sequence of characters.

Variable multibyte (255)

medium sized string

X

 

X

postal code

postal_code

Counterparty's postal code.
A finite sequence of characters.

Variable multibyte (20)

code 20

X

 

X

country

country

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

Characters (2)

ISO 3166 Country

X

 

X

energy label

energy_label

Energy label of real estate collateral means the energy label or energy performance certificate of the real estate collateral.

Variable multibyte (255)

code

X

 

X


List of relationships of the entity non-land

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

classifies

energy_label_of_real_estate_collateral_classifies_non_land

X

non-land

energy label

 

0,n

1,1

is location of

nuts_3_region_is_location_of_collteral_located_in_reporting_member_state

X

non-land

address

 

0,n

1,1


List of parents of the entity non-land

Parent

Parent Entity Code

Logical Data Model 'CRE GLO per bank LDM'

immovable_property


List of identifiers of the entity non-land

Name

Code

Parent

Primary Identifier

non-land PK

immovable_property_pk

Entity 'non-land'

X