| key |
id |
string(36)* |
= |
The id field uniquely identifies the FundPerformanceByPartner entity record. |
| timeline |
lastUpdatedDate |
dateTime |
=< >= |
The time at which the record last updated. |
|
capitalCommitted |
decimal{12,2} |
|
The capital committed by an investor to a fund. (Magnitude: $M) |
|
companyIdFund |
long(-2147483648,2147483647)* |
|
The S&P Cap IQ unique company ID for a fund. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization. |
|
companyIdIssuer |
long(-2147483648,2147483647) |
|
The S&P Cap IQ unique company ID for a firm. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization. |
|
currency |
string(3) |
|
The currency in which the General Partners(GP)/ Limited Partner(LP) provides the fund data in the document. Alphabetic code used to identify currencies pursuant to ISO-4217. |
|
dateOfCommitment |
date |
|
The date when investor made the capital commitment. |
|
distributionsAsReported |
decimal{12,2} |
|
The total income and capital realized from fund investments, net of expenses and liabilities, as reported by the source. This value excludes any carry or performance fees earned by the general partners. (Magnitude: $M) |
|
documentSource |
string(100)* |
|
The source of the document. |
|
documentVersionId |
long(-2147483648,2147483647)* |
|
The specific version of the filing document. For S&P CapIQ Pro, it acts as an S&P Version ID (SNPVersionID). |
|
dpi |
decimal{8,2} |
|
The distributions as a percent of paid-in-capital. This value prioritizes the as-reported figure when available; otherwise, the derived value is used. (Magnitude: %) |
|
dpiAsReported |
decimal{8,2} |
|
The distributions as a percent of paid-in-capital. The value is reported from the source. (Magnitude: %) |
|
dpiDerived |
decimal{8,2} |
|
The distributions to paid-in capital (DPI) as a percentage. This value is derived from the reported distributions as a percentage of the reported limited partner interest. (Magnitude: %) |
|
dryPowderMultipleDerived |
decimal{5,2} |
|
The value is derived from capital committed as a multiple of outstanding commitment (Magnitude: x). |
|
fundPerformanceDateEnd |
date* |
|
The date of the end of the period. |
|
isDefaultSelection |
boolean |
|
Indicates that the record represents the default selection for a specific fund and quarter. A value of 'true' (or '1') signifies the default selection. |
|
keyInstnFund |
long(-2147483648,2147483647)* |
|
The S&P Cap IQ unique company ID for a fund. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization. 'KeyInstn' is ex-SNL entity identifier. |
|
keyInstnIssuer |
long(-2147483648,2147483647)* |
|
The S&P Cap IQ unique company ID for a investor. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization. 'KeyInstn' is ex-SNL entity identifier. |
|
lpsInterest |
decimal{8,2} |
|
The Limited Partnership's (LPs) aggregate commitments to the partnership as a percent of all commitments. This value prioritizes the as-reported figure when available; otherwise, the derived value is used. (Magnitude: %) |
|
lpsInterestAsReported |
decimal{12,2} |
|
The value reported for the Limited Partner's (LPs) capital contribution to the partnership. (Magnitude: $M) |
|
lpsInterestDerived |
decimal{8,2} |
|
The limited partnership's (LPs) aggregate commitments to the partnership as a percent of all commitments. The value is derived from the reported limited partner interest as a percent of the total capital committed. (Magnitude: %) |
|
lpsInterestReported |
decimal{8,2} |
|
The Limited Partnership's (LPs) aggregate commitments to the partnership as a percent of all commitments. The value is reported from the source. (Magnitude: %) |
|
managementFee |
decimal{12,2} |
|
The management fee charged to the limited partners (LP) during the investment period of the fund. (Magnitude: $M) |
|
maxRelativeCount |
long(-32768,32767) |
|
The max relative count. Similar to MostRecentSequence(MRS) except the highest value, not the lowest, represents the most recent. |
|
mostDatedSequence |
long(0,255) |
|
Indicates that the record is the oldest in the time series for a specific fund and investor combination. A value of 1 signifies the oldest record, while a value of 0 or null indicates it is not. |
|
mostRecentSequence |
boolean |
|
The sequence number that ranks records in descending chronological order within a time series. The value '1' identifies the most recent record, there will always be at least one record with a sequence value of '1'. |
|
netInternalRateReturn |
decimal{8,2} |
|
The net internal rate of return (IRR) for the fund, calculated after the deduction of management fees and carried interest (Magnitude: %). |
|
netMultiple |
decimal{5,2} |
|
The value represents the total value generated by an investment relative to the capital invested expressed as a multiple. This value prioritizes the as-reported figure when available; otherwise, the derived value is used.(Magnitude: x) |
|
netMultipleAsReported |
decimal{5,2} |
|
The value represents the total value generated by an investment relative to the capital invested expressed as a multiple. The value is reported from the source. (Magnitude: x) |
|
netMultipleDerived |
decimal{5,2} |
|
The value is ratio between the total value (Distributions + Residual) that the LP has generated to capital invested by the Limited Partner expressed as a multiple. (Magnitude: x) |
|
outstandingCommitment |
decimal{12,2} |
|
The definitive outstanding capital commitment of an investor to a fund, also known as unfunded commitment or uncalled capital. This value prioritizes the as-reported figure when available; otherwise, the derived value is used. (Magnitude: $M) |
|
outstandingCommitmentAsReported |
decimal{12,2} |
|
The outstanding capital commitment of an investor to a fund, presented exactly as it was reported by the source. This value is also known as unfunded commitment or uncalled capital. (Magnitude: $M) |
|
outstandingCommitmentDerived |
decimal{12,2} |
|
The outstanding capital commitment of an investor to a fund, also known as unfunded commitment or uncalled capital. It represents the total unexpired capital commitment less the total capital drawn, plus any unexpired recallable capital since inception as derived. (Magnitude: $M) |
|
relativeBegun |
date |
|
The start date of the relative period. |
|
relativeEnded |
date |
|
The end date of the relative period. |
|
residualValueAsReported |
decimal{12,2} |
|
The remaining value of the fund as derived from the general partners valuation of the unrealized portfolio. (Magnitude: $M) |
|
rvpi |
decimal{8,2} |
|
The residual value to paid-in capital (RVPI) as a percent of paid-in-capital. This value prioritizes the as-reported figure when available; otherwise, the derived value is used. (Magnitude: %) |
|
rvpiAsReported |
decimal{8,2} |
|
The residual value to paid-in capital (RVPI) as a percent of paid-in-capital. The value is reported from the source. (Magnitude: %) |
|
rvpiDerived |
decimal{8,2} |
|
The residual value to paid-in capital (RVPI) as a percent of paid-in-capital. The value is derived from reported residual value as a percent of reported limited partnerships interest. (Magnitude: %) |
|
totalValue |
decimal{12,2} |
|
The total value is defined as the sum of distributions and remaining value with Limited Partners (LP). This value prioritizes the as-reported figure when available; otherwise, the derived value is used. (Magnitude: $M) |
|
totalValueAsReported |
decimal{12,2} |
|
The total value of a fund, presented exactly as it was reported by the source. (Magnitude: $M) |
|
totalValueDerived |
decimal{12,2} |
|
The total value of a fund, calculated as the sum of all distributions and the remaining value held by the Limited Partners (LP). (Magnitude: $M) |
|
trailingFiveYearsReturn |
decimal{8,2} |
|
The Internal Rate of Return (IRR) calculation between points in time where the beginning point (last 60 months preceding reported date) is variable and the end point is fixed (reported date). (Magnitude: %) |
|
trailingOneYearReturn |
decimal{8,2} |
|
The Internal Rate of Return (IRR) calculation between points in time where the beginning point (last 12 months preceding reported date) is variable and the end point is fixed (reported date). (Magnitude: %) |
|
trailingTenYearsReturn |
decimal{8,2} |
|
The Internal Rate of Return (IRR) calculation between points in time where the beginning point (last 120 months preceding reported date) is variable and the end point is fixed (reported date). (Magnitude: %) |
|
trailingThreeYearsReturn |
decimal{8,2} |
|
The Internal Rate of Return (IRR) calculation between points in time where the beginning point (last 36 months preceding reported date) is variable and the end point is fixed (reported date). (Magnitude: %) |
|
updateOperation |
long(0,255) |
|
The value will represents the operation on the record. |