ores.dq.lei_entity

1. Flags
2. Columns
3. Artefact indexes
- 3.1. entity_legal_address_country
- 3.2. entity_entity_category
4. SQL
- 4.1. Flags
5. Insert trigger
- 5.1. Validations
6. C++
7. Notes
8. See also

GLEIF LEI entity master data from LEI2 golden copy files

1. Flags

2. Columns

2.1. lei

Legal Entity Identifier — the natural key for this entity.

std::string(faker::string::alphanumeric(20))

2.2. entity_legal_name

std::string(faker::company::companyName())

2.3. entity_entity_category

std::string(faker::word::noun())

2.4. entity_entity_sub_category

std::string(faker::word::noun())

2.5. entity_entity_status

std::string(faker::word::noun())

2.6. entity_legal_form_entity_legal_form_code

std::string(faker::string::alphanumeric(4))

2.7. entity_legal_form_other_legal_form

std::string(faker::word::noun())

2.8. entity_legal_jurisdiction

std::string(faker::location::countryCode())

2.9. entity_legal_address_first_address_line

std::string(faker::location::streetAddress())

2.10. entity_legal_address_city

std::string(faker::location::city())

2.11. entity_legal_address_region

std::string(faker::location::state())

2.12. entity_legal_address_country

std::string(faker::location::countryCode())

2.13. entity_legal_address_postal_code

std::string(faker::location::zipCode())

2.14. entity_headquarters_address_first_address_line

std::string(faker::location::streetAddress())

2.15. entity_headquarters_address_city

std::string(faker::location::city())

2.16. entity_headquarters_address_region

std::string(faker::location::state())

2.17. entity_headquarters_address_country

std::string(faker::location::countryCode())

2.18. entity_headquarters_address_postal_code

std::string(faker::location::zipCode())

2.19. entity_entity_creation_date

std::chrono::system_clock::now()

2.20. registration_initial_registration_date

std::chrono::system_clock::now()

2.21. registration_last_update_date

std::chrono::system_clock::now()

2.22. registration_next_renewal_date

std::chrono::system_clock::now()

2.23. registration_registration_status

std::string(faker::word::noun())

2.24. entity_transliterated_name_1

std::string(faker::company::companyName())

2.25. entity_transliterated_name_1_type

std::string(faker::word::noun())

3. Artefact indexes

3.1. entity_legal_address_country

3.2. entity_entity_category

4. SQL

4.1. Flags

5. Insert trigger

5.1. Validations

column

validation_function

6. C++

6.1. Flags

6.2. Repository

6.3. Domain includes

#include <chrono>
#include <string>

6.4. Entity includes

#include <string>
#include "sqlgen/Timestamp.hpp"

6.5. Conventions

6.6. Table display

column	header
lei	LEI
entity_legal_name	Legal Name
entity_entity_status	Status
modified_by	Modified By

6.7. Custom repository methods

6.8. Presentation

6.8.1. Columns

enum_name	field	header	type	width
Lei	lei	LEI	string	150
LegalName	entity_legal_name	Legal Name	string	250
Status	entity_entity_status	Status	string	120

7. Notes

Bound to Artefact staging only (alongside its shape profile): this artefact type's own row in ores_dq_artefact_types_tbl (lei_entities) has target_table=/=target_subject both null – explicitly terminal, not published anywhere. GLEIF LEI golden-copy data is queried directly from the artefact table (dq_lei_entities_query_functions_create.sql); a same-component main table would be an orphan nobody designed for. Two other artefact-type rows (lei_counterparties, lei_parties) publish this same artefact data onward, but to ores.refdata's own tables, not a ores.dq-owned one.

UI deliberately disabled: the generated read-only Explorer list window queried the (correctly nonexistent) main table and errored on open. Its data has no working read path of its own – it powers the GLEIF counterparty picker, a different UI surface – so there is no browsing screen to commission until that path exists.

8. See also

ores.dq — component group overview.