Type BDCPortfolio
Type category Entity
Description Captures detailed investment-level data made by Business Development Companies (BDCs) in portfolio companies in standardized terms. It includes financial metrics, instrument attributes, and investment characteristics across reporting periods. It supports granular analysis of individual investments, facilitates performance tracking, and enables regulatory and strategic reporting.
Fields
Name Type Filters Description
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: %).
43 rows of 43 total
API Open API Specification