Type CompanyRels
Type category Entity
Description Details of parent-child relationship between two entities
Timeseries key id, startDateavailable from 1900-01-01
Fields
Name Type Filters Description
key id string(30)* = Unique Identifier between a Child and Parent company pair. It's equivalent to the companyRelId
timeline startDate date* =< >= Date on which Relationship between a child and its parent starts
aggregateDebtProvided decimal{11,3} The cumulative value of debt funding provided by the lender to the KeyInstn in various transactions (in USD)
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the Price is calculated.
filter_list ciqCompanyIdChild long(-2147483648,2147483647)* = Unique identifier assigned to a company. This field represents the unique company id for the child entity.
filter_list ciqCompanyIdParent long(-2147483648,2147483647)* = Unique identifier assigned to a company. This field represents the unique company id for the Parent entity.
ciqCompanyIdRolledUpChild long(-2147483648,2147483647) Unique identifier assigned to the rolled up company id for the child entity.
ciqCompanyIdRolledUpParent long(-2147483648,2147483647) Unique identifier assigned to the rolled up company id for the parent entity.
filter_list companyRelId long(-2147483648,2147483647)* = Unique Identifier between a Child and Parent company pair
link companyRelType CompanyRelType = Unique identifier of the nature of relationship between the parent and child.
controllingInterest boolean Majority ownership interest by the immediate parent in its child entity
conversionFactorDate date Date when the conversion factor was applied to convert USD amount to local currency.
endDate date Date on which Relationship between a child and its parent ends
link endDateSource DateSource Source of relationship End Date.
filter_list goldenCompanyRelPitId long(-9223372036854775807,9223372036854775806)* = Unique identifier for the Point in Time company relationship
investmentCurrency string(3) ISO 4217 currency code in which the total investment is made by the parent company in the child company at the time the relationship was enacted.
isEstimated boolean Indicates that the relationship was estimated from indicative sources without conclusive evidence, populated only for private to private company relationships
isPrimary boolean Indicates if Investment Advisor relationship is primary for multi-advisor funds
filter_list keyInstnChild long(-2147483648,2147483647) = Keyinstn for Child Company in the relationship.
filter_list keyInstnParent long(-2147483648,2147483647) = Keyinstn for Parent Company in the relationship.
lastUpdated dateTime Last modification date and time
latestPercentOwnership decimal{9,6} Percent owned by immediate parent in its child entity as of date
localCurrencyTotalInvestment decimal{18,9} Total investment by the parent company in the child company at the time the relationship was enacted, in millions of local currency
percentOwnership decimal{9,6} Percent owned by immediate parent in its child entity
link reasonForChange ReasonforChange Unique identifier to identify the reason for change in rel attributes - populated only for end dated rels.
relationshipConfirmedDate date Date when the relationship is validated and information was found for the relationship attributes (not within 1 year)
relationshipSource string(80000) Actual source of information used to capture the relationship corresponding to the source type
link sourceType SourceType Unique identifier for the source of relationship.
link stakeType StakeType Unique identifier for the extent of ownership between the parent and child.
link startDateSource DateSource Source of relationship Start Date.
statusConfirmedDate date Date when the relationship is validated and information was found for the relationship attributes (within 1 year)
totalInvestment decimal{18,9} Total investment by the parent company in the child company at the time the relationship was enacted, in millions of USD
33 rows of 33 total
API Open API Specification