Entity foreign legal entity

Details of entity foreign legal entity

Name

foreign legal entity

Code

foreign_legal_entity

Parent

Logical Data Model 'CRE GLO per bank LDM'

Comment

Foreign legal entity is a legal entity that is not registered in the Dutch trade register.

Parent Entity

legal entity


List of attributes of the entity foreign legal entity

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

counterparty identifier

counterparty_identifier

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

Each counterparty identifier must be unique for each counterparty reported by the same reporting agent and the same counterparty must be identified by the reporting agent using the same counterparty identifier. This identifier must not be reused by the same reporting agent at any point in time to identify a different counterparty.

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.

Date

reporting reference date

X

X

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

 

Characters (2)

ISO 3166 Country

X

 

X

institutional sector

institutional_sector

 

Variable multibyte (255)

code

 

 

X

economic activity

economic_activity

A level two, three or four NACE code in accordance with Regulation (EC) No 1893/2006.

Variable multibyte (255)

code

 

 

X

balance sheet total

balance_sheet_total

Carrying value of the counterparty's total assets in accordance with Regulation (EU) 549/2013.

Amount in euro. Foreign currency amounts should be converted into euro at the respective ECB euro foreign exchange reference rates (i.e. the mid-rate) on the reporting reference date.

Decimal (16,0)

euro amount (non-negative)

 

 

 

number of employees

number_of_employees

Number of employees working for the debtor, in accordance with Article 5 of the Annex to Recommendation 2003/361/EC.

Non-negative number.

Decimal (12,0)

real number (non-negative) with exclusions

 

 

 

enterprise size

es_code

 

Variable multibyte (255)

code

 

 

X

legal form

legal_form

 

Variable multibyte (255)

code

 

 

X

date of enterprise size

date_of_enterprise_size

The date to which the value provided in the 'enterprise size' refers. This is the date of the latest data used to classify or review the classification of the enterprise.

Defined as yyyy-mm-dd.

Date

date

 

 

 

name

name

Full legal name of the counterparty.

A finite sequence of characters.

Example: The full legal name of Rabobank is "Coöperatieve Rabobank U.A".

Variable multibyte (1024)

large sized string

X

 

 


List of relationships of the entity foreign legal entity

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

classifies

foreign_legal_form_type_classifies_foreign_legal_entity

X

foreign legal entity

legal form type

 

0,n

0,1

classifies

institutional_sector_classifies_foreign_legal_entity

X

foreign legal entity

institutional sector

 

0,n

0,1

classifies

economic_activity_classifies_foreign_counterparty

X

foreign legal entity

economic activity

 

0,n

0,1

classifies

enterprise_size_classifies_foreign_legal_entity

X

foreign legal entity

enterprise size

 

0,n

0,1

is address of

address_is_address_of_counterparty

X

foreign legal entity

address

 

0,n

1,1


List of parents of the entity foreign legal entity

Parent

Parent Entity Code

Logical Data Model 'CRE GLO per bank LDM'

legal_entity


List of identifiers of the entity foreign legal entity

Name

Code

Parent

Primary Identifier

foreign legal entity PK

foreign_legal_entity_pk

Entity 'foreign legal entity'

X