| key |
id |
string(25)* |
= |
Unique identifier for each portfolio record. |
|
allInRateCash |
decimal{18,6} |
|
The cash-pay portion of the all-in interest rate applicable to an investment, representing the contractual rate of return payable in cash to the investor. |
|
allInRatePIK |
decimal{18,6} |
|
The total interest rate under payment-in-kind (PIK) terms (Magnitude: %). |
|
allInRateTotal |
decimal{18,6} |
|
The complete interest rate applied, aggregating both cash and payment-in-kind (PIK) components (Magnitude: %). |
|
baseRate |
string(50) |
|
The benchmark interest rate applied to the loan, such as London Interbank Offered Rate (LIBOR) or Secured Overnight Financing Rate (SOFR). |
|
baseRatePeriod |
string(255) |
|
The duration or frequency at which the base interest rate resets. |
|
bdcMasterId |
long(-9223372036854775807,9223372036854775806) |
|
Identifier used to associate related Business Development Company (BDC) records. |
|
borrowerNameId |
long(-2147483648,2147483647) |
|
A unique identifier assigned to the borrower associated with the investment. |
|
cash |
decimal{18,6} |
|
The contractual cash-pay rate applicable to an investment, representing the portion of interest, dividend, or distribution payable in cash to the investor. |
|
ciqCompanyIdBDC |
long(-2147483648,2147483647) |
|
The unique identifier for the Business Development Company (BDC) involved in the investment. |
|
ciqPortfolioCompanyId |
long(-2147483648,2147483647) |
|
The identifier for the company receiving investment from the Business Development Company (BDC). |
|
ciqSecurityId |
long(-2147483648,2147483647) |
|
A unique identifier from the Capital IQ database used to track individual securities. |
|
ciqTransactionId |
long(-9223372036854775807,9223372036854775806) |
|
A unique identifier assigned to each transaction for tracking and audit purposes. |
|
cloType |
boolean |
|
Indicates whether the investment involves a Collateralized Loan Obligation (CLO). It can take one of two values: 1 represents that CLO is involved, 0 represents CLO is not involved. |
|
cost |
decimal{18,6} |
|
The acquisition price of the investment, used for valuation and performance tracking as per reported currency. |
|
costUSD |
decimal{18,6} |
|
The investment cost converted to U.S. dollars (Magnitude: $000). |
|
currency |
string(3) |
|
The ISO 4217 alpha-3 compliant code identifying the currency in which the transaction is denominated. |
|
defaultRate |
decimal{18,6} |
|
The interest rate triggered in the event of borrower default (Magnitude: %). |
|
fairValue |
decimal{18,6} |
|
The current market value of the investment, based on prevailing conditions as per reported currency. |
|
fairValueUSD |
decimal{18,6} |
|
The current fair value of the investment converted to U.S. dollars (Magnitude: $000). |
|
filingDate |
date |
|
The ending date of the financial reporting period covered by a quarterly, semi-annual, or annual filing. This date represents the end of the reporting period and not the filing submission date. |
|
filingPeriod |
string(20) |
|
The financial reporting cycle (e.g., Q1 2023) for which the data was submitted. |
|
floor |
decimal{18,6} |
|
The minimum interest rate applicable to the loan, regardless of market fluctuations (Magnitude: %). |
|
initialInvestmentDate |
date |
|
The date on which the initial investment was made in the asset or company. |
|
insertedDateTime |
dateTime* |
|
The Inserted Date captures when the portfolio record was first created in the database. This is in UTC timezone. |
|
instrumentName |
string(510) |
|
The financial instrument as reported in filings or source data. |
| link |
instrumentStandardName |
InstrumentName |
|
A normalized label for the financial instrument, ensuring consistency across records. |
|
isBSL |
boolean |
|
Identifies whether the loan is classified as a Broadly Syndicated Loan (BSL). |
|
lastModifiedDateTime |
dateTime* |
|
Timestamp of the most recent update for the portfolio record in UTC timezone. |
|
lxId |
string(50) |
|
An identification number used to track loans. |
|
maturityDate |
date |
|
The date when the loan or investment reaches its contractual end. |
|
mostRecentSequence |
boolean |
|
Indicates the latest version or update of the record, supporting version control. |
|
nonAccrual |
string(20) |
|
Indicates whether the investment is currently on non-accrual status due to performance or risk concerns. |
|
nonAccrualFlag |
boolean |
|
Indicates whether the investment is currently on non-accrual status. |
|
periodEndDate |
date |
|
The conclusion date of the reporting period for the investment data. |
|
pikRate |
decimal{18,6} |
|
The interest rate applied under payment-in-kind (PIK) terms, where interest is paid in securities rather than cash (Magnitude: %). |
|
principal |
decimal{18,6} |
|
The original amount invested or loaned, excluding interest or fees in reported currency. |
|
principalUSD |
decimal{18,6} |
|
The principal amount converted to U.S. dollars for standardized reporting (Magnitude: $000). |
|
securityERS |
boolean |
|
Indicates whether the record represents the Earliest Recorded Sequence for the associated LoanX ID (LXID). |
|
securityMRS |
boolean |
|
Indicates whether the record represents the Most Recent Sequence for the associated LoanX ID (LXID). |
|
securityType |
string(50) |
|
The category of financial instrument held. It can take one of three values:Debt: Represents that the security involved is Debt.Equity & Other: Represents that the security involved is Equity and other types. |
|
shares |
string(255) |
|
The investment holding, represented as the number of shares or units, a fractional value (e.g., 5.82), or a percentage of total holding (Magnitude: Count or %). |
|
spread |
decimal{18,6} |
|
The additional interest charged over the base rate, reflecting borrower risk and market conditions (Magnitude: %). |