| key |
id |
string(25)* |
= |
Unique identifier for each investment status. |
|
aggregateCost |
decimal{18,6} |
|
The total acquisition cost of investments under this status, used for performance and valuation analysis (Magnitude: $000). |
|
aggregateFairValue |
decimal{18,6} |
|
The combined fair market value of all investments under this status (Magnitude: $000). |
|
aggregatePrincipal |
decimal{18,6} |
|
The total principal amount invested under this status (Magnitude: $000). |
|
fairValuetoCost |
decimal{18,6} |
|
The ratio measuring investment performance by comparing current fair value to original acquisition cost. |
|
fairValuetoPrincipal |
decimal{18,6} |
|
The ratio evaluating the valuation of investments relative to the original principal amount. |
|
insertedDateTime |
dateTime* |
|
Timestamp when the record was initially added to the database, providing a timestamp for data ingestion in UTC timezone. |
|
investmentCount |
long(-2147483648,2147483647) |
|
The total number of investments categorized under the specified status (Magnitude: Actual). |
|
investmentStatus |
string(20) |
|
A classification of the current condition of the investment. Allowable values include: 'Accrual' (indicating the loan is good) and 'NonAccrual' (indicating the loan has turned bad). |
|
lastModifiedDateTime |
dateTime* |
|
Timestamp of the most recent update for the record, enabling audit and version control in UTC timezone. |
|
latestPeriod |
boolean |
|
Indicates whether the record corresponds to the most recent reporting cycle. |
|
nonAccrualPct |
decimal{18,2} |
|
The proportion of investments under this status that are currently classified as non-accrual (Magnitude: %). |
|
periodEndDate |
date |
|
The conclusion date of the reporting period for which the investment status data is captured. |
|
portfolioCount |
long(-2147483648,2147483647) |
|
The number of distinct portfolio companies associated with the given investment status (Magnitude: Actual). |