Type CompanyRelsLatest
Type category Entity
Description Details of latest parent-child relationship between two entities
Fields
Name Type Filters Description
key id string(30)* = Unique Identifier between a child and parent company pair. It's equivalent to the companyRelId_VendorID
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.
ciqCompanyIdChild long(-2147483648,2147483647)* Unique identifier assigned to a company. This field represents the unique company id for the child entity.
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.
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.
link endDateSource DateSource Source of relationship end date.
enddate date Date on which relationship between a child and its parent ends
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
keyInstnChild long(-2147483648,2147483647) Legacy S&P Global institution ID of the child company in the relationship.
keyInstnParent long(-2147483648,2147483647) Legacy S&P Global institution ID of the 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. This value is in %
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
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(8000) 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.
startDate date* Date on which relationship between a child and its parent starts
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
32 rows of 32 total
API Open API Specification