ores.dq.lei_relationship

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

GLEIF LEI corporate hierarchy relationships from RR golden copy files

1. Flags

2. Columns

2.1. relationship_start_node_node_id

Legal Entity Identifier of the relationship's start node — the natural key for this entity.

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

2.2. relationship_start_node_node_id_type

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

2.3. relationship_end_node_node_id

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

2.4. relationship_end_node_node_id_type

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

2.5. relationship_relationship_type

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

2.6. relationship_relationship_status

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

2.7. relationship_period_1_start_date

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

2.8. relationship_period_1_end_date

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

2.9. registration_initial_registration_date

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

2.10. registration_last_update_date

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

2.11. registration_registration_status

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

2.12. registration_validation_sources

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

3. Artefact indexes

3.1. relationship_end_node_node_id

3.2. relationship_relationship_type

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>

6.5. Conventions

6.6. Table display

column	header
relationship_start_node_node_id	Start Node
relationship_end_node_node_id	End Node
relationship_relationship_type	Type

6.7. Custom repository methods

6.8. Presentation

6.8.1. Columns

enum_name	field	header	type	width
StartNode	relationship_start_node_node_id	Start Node	string	150
EndNode	relationship_end_node_node_id	End Node	string	150
RelType	relationship_relationship_type	Type	string	150

7. Notes

Bound to Artefact staging only (alongside its shape profile): this artefact type's own row in ores_dq_artefact_types_tbl (lei_relationships) has target_table=/=target_subject both null – explicitly terminal, not published anywhere. GLEIF LEI corporate-hierarchy data is queried directly from the artefact table; a same-component main table would be an orphan nobody designed for.

UI deliberately disabled: same rationale as lei_entity – the generated read-only Explorer list window queried the (correctly nonexistent) main table and errored on open.

8. See also

ores.dq — component group overview.