| 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 |