Fetches the relationship records that link a LEI to its direct or ultimate children. Where
lei_children() returns the children's own LEI records, this returns the relationships
themselves: their type, status, the periods they cover, and how they were corroborated.
Usage
lei_child_relationships(id, type = c("direct", "ultimate"), limit = 200L)Arguments
- id
(
character(1))
The Legal Entity Identifier (LEI) to fetch the child relationships for.- type
(
character(1))
The type of child relationships to fetch. One of"direct"or"ultimate". Default is"direct".- limit
(
NULL|integer(1))
Maximum number of records to return. Default200L. UseNULLto fetch all.
Value
A data.frame() with one row per relationship and the same columns as
lei_parent_relationship(), where start_node is the child and end_node is id.
When the LEI has no children, NULL.
See also
lei_parent_relationship() for the relationship to the parent of a LEI,
lei_children() for the children's LEI records.
Examples
# \donttest{
lei_child_relationships("O2RNE8IBXP4R0TD8PU41", limit = 5)
#> start_node end_node relationship_type
#> 1 5493007CD14TLLOHFX18 O2RNE8IBXP4R0TD8PU41 IS_DIRECTLY_CONSOLIDATED_BY
#> 2 549300QV9DX9XDXFUI91 O2RNE8IBXP4R0TD8PU41 IS_DIRECTLY_CONSOLIDATED_BY
#> 3 549300R5KWVK6X3WAP35 O2RNE8IBXP4R0TD8PU41 IS_DIRECTLY_CONSOLIDATED_BY
#> 4 549300ND75H8476SLO73 O2RNE8IBXP4R0TD8PU41 IS_DIRECTLY_CONSOLIDATED_BY
#> 5 549300XOHLO9G78P6819 O2RNE8IBXP4R0TD8PU41 IS_DIRECTLY_CONSOLIDATED_BY
#> relationship_status relationship_period_start relationship_period_end
#> 1 ACTIVE 2021-12-01 <NA>
#> 2 ACTIVE 2017-11-27 <NA>
#> 3 ACTIVE 2018-02-15 <NA>
#> 4 ACTIVE 2017-12-13 <NA>
#> 5 ACTIVE 2017-12-21 <NA>
#> accounting_period_start accounting_period_end document_filing_period_start
#> 1 2020-01-01 2020-12-31 <NA>
#> 2 2017-01-01 2017-12-31 <NA>
#> 3 2017-01-01 2017-12-31 <NA>
#> 4 2021-01-01 2021-12-31 <NA>
#> 5 2021-01-01 2021-12-31 <NA>
#> document_filing_period_end initial_registration_date last_update_date
#> 1 <NA> 2014-08-02 02:23:00 2023-07-31 17:34:15
#> 2 <NA> 2015-09-22 02:17:00 2023-07-31 17:11:36
#> 3 <NA> 2014-06-19 01:50:00 2023-07-31 17:11:36
#> 4 <NA> 2014-06-21 01:41:00 2023-07-31 17:11:36
#> 5 <NA> 2016-01-07 02:33:00 2023-07-31 17:11:36
#> registration_status next_renewal_date managing_lou
#> 1 LAPSED 2018-06-30 19:34:00 5493001KJTIIGC8Y1R12
#> 2 LAPSED 2019-11-20 00:30:00 213800WAVVOPS85N2205
#> 3 LAPSED 2020-02-19 00:18:00 213800WAVVOPS85N2205
#> 4 LAPSED 2023-01-06 22:44:00 213800WAVVOPS85N2205
#> 5 LAPSED 2022-09-22 18:00:00 213800WAVVOPS85N2205
#> corroboration_level corroboration_documents corroboration_reference
#> 1 ENTITY_SUPPLIED_ONLY SUPPORTING_DOCUMENTS <NA>
#> 2 ENTITY_SUPPLIED_ONLY SUPPORTING_DOCUMENTS <NA>
#> 3 ENTITY_SUPPLIED_ONLY SUPPORTING_DOCUMENTS <NA>
#> 4 ENTITY_SUPPLIED_ONLY SUPPORTING_DOCUMENTS <NA>
#> 5 ENTITY_SUPPLIED_ONLY SUPPORTING_DOCUMENTS <NA>
#> valid_from valid_to
#> 1 2023-08-05 <NA>
#> 2 2023-08-10 <NA>
#> 3 2023-08-10 <NA>
#> 4 2023-08-10 <NA>
#> 5 2023-08-10 <NA>
lei_child_relationships("O2RNE8IBXP4R0TD8PU41", type = "ultimate", limit = 5)
#> start_node end_node relationship_type
#> 1 5493007CD14TLLOHFX18 O2RNE8IBXP4R0TD8PU41 IS_ULTIMATELY_CONSOLIDATED_BY
#> 2 549300YBX5WAFBREYJ86 O2RNE8IBXP4R0TD8PU41 IS_ULTIMATELY_CONSOLIDATED_BY
#> 3 253400CT0XYF33T5Y650 O2RNE8IBXP4R0TD8PU41 IS_ULTIMATELY_CONSOLIDATED_BY
#> 4 549300MW31Z3IK0WRG66 O2RNE8IBXP4R0TD8PU41 IS_ULTIMATELY_CONSOLIDATED_BY
#> 5 222100RVKRQIZ3UVBB77 O2RNE8IBXP4R0TD8PU41 IS_ULTIMATELY_CONSOLIDATED_BY
#> relationship_status relationship_period_start relationship_period_end
#> 1 ACTIVE 2017-07-22 00:00:00 <NA>
#> 2 ACTIVE 2017-07-22 01:46:15 <NA>
#> 3 ACTIVE 2020-08-09 21:00:00 <NA>
#> 4 ACTIVE 2018-03-13 00:00:00 <NA>
#> 5 ACTIVE 2018-02-02 00:00:00 <NA>
#> accounting_period_start accounting_period_end document_filing_period_start
#> 1 2020-01-01 00:00:00 2020-12-31 00:00:00 <NA>
#> 2 2017-01-01 00:00:00 2017-12-31 00:00:00 <NA>
#> 3 2021-12-31 21:00:00 2022-12-30 21:00:00 <NA>
#> 4 2017-01-01 00:00:00 2017-12-31 00:00:00 2017-01-01
#> 5 2017-01-01 00:00:00 2017-12-31 00:00:00 2017-01-01
#> document_filing_period_end initial_registration_date last_update_date
#> 1 <NA> 2014-08-02 02:23:00 2023-07-31 17:34:15
#> 2 <NA> 2014-08-02 02:23:00 2020-07-28 15:37:00
#> 3 <NA> 2022-07-20 12:56:49 2023-07-20 02:37:34
#> 4 2017-12-31 2023-08-08 18:57:51 2023-08-08 18:57:52
#> 5 2017-12-31 2015-10-01 00:00:00 2023-08-09 09:31:00
#> registration_status next_renewal_date managing_lou
#> 1 LAPSED 2018-06-30 19:34:00 5493001KJTIIGC8Y1R12
#> 2 LAPSED 2018-06-30 19:29:00 5493001KJTIIGC8Y1R12
#> 3 LAPSED 2023-07-20 12:57:51 253400M18U5TB02TW421
#> 4 LAPSED 2021-03-09 20:53:00 529900F6BNUR3RJ2WH29
#> 5 LAPSED 2021-01-07 18:00:00 549300O897ZC5H7CY412
#> corroboration_level corroboration_documents
#> 1 ENTITY_SUPPLIED_ONLY SUPPORTING_DOCUMENTS
#> 2 ENTITY_SUPPLIED_ONLY SUPPORTING_DOCUMENTS
#> 3 ENTITY_SUPPLIED_ONLY OTHER_OFFICIAL_DOCUMENTS
#> 4 FULLY_CORROBORATED ACCOUNTS_FILING
#> 5 FULLY_CORROBORATED ACCOUNTS_FILING
#> corroboration_reference valid_from
#> 1 <NA> 2023-08-05 00:00:00
#> 2 <NA> 2023-08-05 00:00:00
#> 3 <NA> 2023-07-21 00:00:00
#> 4 https://web3.cmvm.pt/sdi/emitentes/docs/fsd469442.pdf 2023-08-09 16:00:00
#> 5 https://web3.cmvm.pt/sdi/emitentes/docs/fsd469442.pdf 2023-08-09 16:00:00
#> valid_to
#> 1 <NA>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
# }