## Entity domestic immovable property

### Details of entity domestic immovable property

Name | domestic immovable property
Code | domestic_immovable_property
Parent | Logical Data Model 'RRE DDA PER BANK LDM'
Comment | Domestic immovable property is immovable property which has its location in the Netherlands
Parent Entity | immovable property

### List of attributes of the entity domestic immovable property

Name | Code | Comment | Data Type | Domain | Mandatory | Primary Identifier | Foreign Identifier | Keywords
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 |  |
postal code | postal_code | Only the first 2 characters of the Dutch postal code should be reported as a 4 character string (i.e. postal code "1234 XX" should be reported as "1200"). The full list of allowed postal codes can be found in the RRE business terms. | Variable multibyte (255) | code | X |  | X |
country | country | Country is the country where the immovable property is located. | Characters (2) | ISO 3166 Country | X |  | X |
energy label | energy_label | Energy label indicates the energy classification of domestic immovable properties. | Variable multibyte (255) | code | X |  | X |
date of the energy label | date_of_the_energy_label | Date of the energy label indicates the date on which the energy label of the domestic immovable property as reported in “energy label” is considered to have been established or changed. | Date | date with exclusions | X |  |  |

### List of relationships of the entity domestic immovable property

Name | Code | Generate | Entity 2 | Entity 1 | Dependent Role | Entity 1 -> Entity 2 Role Cardinality | Entity 2 -> Entity 1 Role Cardinality
classifies | energy_label_classifies_domestic_immovable_property | X | domestic immovable property | energy label |  | 1,n | 1,1
contains | country_contains_domestic_immovable_property | X | domestic immovable property | country |  | 0,n | 1,1
contains | postal_code_contains_domestic_immovable_property | X | domestic immovable property | postal code |  | 0,n | 1,1

### List of parents of the entity domestic immovable property

Parent | Parent Entity Code
Logical Data Model 'RRE DDA PER BANK LDM' | immovable_property

### List of identifiers of the entity domestic immovable property

Name | Code | Parent | Primary Identifier
domestic immovable property PK | domestic_immovable_property_pk | Entity 'domestic immovable property' | X

Previous
Home
Next