| key |
id |
string(25)* |
= |
Unique identifier for each investment type. |
|
aggregateCost |
decimal{18,6} |
|
The total acquisition cost of investments under this type, used for performance and valuation analysis (Magnitude: $000). |
|
aggregateFairValue |
decimal{18,6} |
|
The combined fair market value of investments under this type (Magnitude: $000). |
|
aggregatePrincipal |
decimal{18,6} |
|
The total principal amount invested across all entries of this type (Magnitude: $000). |
|
fairValueToCost |
decimal{18,6} |
|
The ratio measuring investment performance by comparing current fair value to original cost. |
|
fairValueToPrincipal |
decimal{18,6} |
|
The ratio evaluating the valuation of investments relative to the original principal amount. |
|
insertedDateTime |
dateTime* |
|
Timestamp when the investment type data was first created in the system in UTC timezone. |
| link |
instrumentName |
InstrumentName |
|
A normalized label for the financial instrument (e.g., Term Loan, Equity), ensuring consistency across records. For the type of values please refer to entity InstrumentName. |
|
investmentCount |
long(-2147483648,2147483647) |
|
The total number of investments made under the specified instrument type during the reporting period (Magnitude: Actual). |
|
investmentType |
long(0,32767) |
|
The number of distinct investment categories involved during the reporting period (e.g., equity, debt, notes). |
|
lastModifiedDateTime |
dateTime* |
|
Timestamp of the most recent update, supporting audit and version control in UTC timezone. |
|
latestPeriod |
boolean |
|
Indicates whether the data corresponds to the most recent reporting cycle. |
|
nonAccrualPct |
decimal{5,2} |
|
The proportion of investments under this type currently classified as non-accrual (Magnitude: %). |
|
periodEndDate |
date |
|
The conclusion date of the reporting period for which the investment data is captured. |
|
portfolioCount |
long(-2147483648,2147483647) |
|
The number of distinct portfolio companies associated with the given investment type (Magnitude: Actual). |