ores.dq.lei_entity
Table of Contents
- Flags
- Columns
- lei
- entity_legal_name
- entity_entity_category
- entity_entity_sub_category
- entity_entity_status
- entity_legal_form_entity_legal_form_code
- entity_legal_form_other_legal_form
- entity_legal_jurisdiction
- entity_legal_address_first_address_line
- entity_legal_address_city
- entity_legal_address_region
- entity_legal_address_country
- entity_legal_address_postal_code
- entity_headquarters_address_first_address_line
- entity_headquarters_address_city
- entity_headquarters_address_region
- entity_headquarters_address_country
- entity_headquarters_address_postal_code
- entity_entity_creation_date
- registration_initial_registration_date
- registration_last_update_date
- registration_next_renewal_date
- registration_registration_status
- entity_transliterated_name_1
- entity_transliterated_name_1_type
- Artefact indexes
- SQL
- Insert trigger
- C++
- Notes
- Physical space
- See also
GLEIF LEI entity master data from LEI2 golden copy files
Flags
Columns
lei
Legal Entity Identifier — the natural key for this entity.
std::string(faker::string::alphanumeric(20))
entity_legal_name
std::string(faker::company::companyName())
entity_entity_category
std::string(faker::word::noun())
entity_entity_sub_category
std::string(faker::word::noun())
entity_entity_status
std::string(faker::word::noun())
entity_legal_form_entity_legal_form_code
std::string(faker::string::alphanumeric(4))
entity_legal_form_other_legal_form
std::string(faker::word::noun())
entity_legal_jurisdiction
std::string(faker::location::countryCode())
entity_legal_address_first_address_line
std::string(faker::location::streetAddress())
entity_legal_address_city
std::string(faker::location::city())
entity_legal_address_region
std::string(faker::location::state())
entity_legal_address_country
std::string(faker::location::countryCode())
entity_legal_address_postal_code
std::string(faker::location::zipCode())
entity_headquarters_address_first_address_line
std::string(faker::location::streetAddress())
entity_headquarters_address_city
std::string(faker::location::city())
entity_headquarters_address_region
std::string(faker::location::state())
entity_headquarters_address_country
std::string(faker::location::countryCode())
entity_headquarters_address_postal_code
std::string(faker::location::zipCode())
entity_entity_creation_date
std::chrono::system_clock::now()
registration_initial_registration_date
std::chrono::system_clock::now()
registration_last_update_date
std::chrono::system_clock::now()
registration_next_renewal_date
std::chrono::system_clock::now()
registration_registration_status
std::string(faker::word::noun())
entity_transliterated_name_1
std::string(faker::company::companyName())
entity_transliterated_name_1_type
std::string(faker::word::noun())
Artefact indexes
entity_legal_address_country
entity_entity_category
SQL
Flags
Insert trigger
Validations
| column | validation_function |
C++
Flags
Repository
Domain includes
#include <chrono> #include <string>
Entity includes
#include <string> #include "sqlgen/Timestamp.hpp"
Conventions
Table display
| column | header |
|---|---|
| lei | LEI |
| entity_legal_name | Legal Name |
| entity_entity_status | Status |
| modified_by | Modified By |
Custom repository methods
Qt
Columns (Qt model)
| 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 |
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.
Qt UI deliberately disabled (see Physical space below): the generated read-only Explorer list window queried the (correctly nonexistent) main table and errored on open. Its data has no working Qt 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.
Physical space
| Address | Enabled |
|---|---|
| ores.cpp.qt | false |
See also
- ores.dq — component group overview.