Entity postal code region

Details of entity postal code region

Name

postal code region

Code

postal_code_region

Parent

Logical Data Model 'RRE DDA PER BANK LDM'

Comment

Country and postal code information of the location of the immovable property.

Parent Entity

<None>


List of attributes of the entity postal code region

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

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

postal code

postal_code

The numerical part of the postal code of the immovable property.

Short integer

postal code numeric

X

X

 

country

country

ISO 3166-1 alpha-2 code of the country. For counterparties, the country refers to the country of residence of the counterparty.

Characters (2)

ISO 3166 Country

X

X

X


List of relationships of the entity postal code region

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

classifies

address_classifies_immovable_property

X

domestic immovable property

postal code region

 

0,n

1,1

contains

country_contains_address

X

postal code region

country

postal code region -> country

0,n

1,1

reports

reporting_agent_delivery_reports_addres

X

postal code region

reporting agent delivery

postal code region -> reporting agent delivery

0,n

1,1


List of identifiers of the entity postal code region

Name

Code

Parent

Primary Identifier

postal code region PK

property_location_pk

Entity 'postal code region'

X