| key |
id |
string(25)* |
= |
Unique identifier assigned to a Business Development Company (BDC) investment 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 All-In PIK Rate represents the total interest rate under payment-in-kind terms. |
|
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). |
|
borrowerName |
string(510) |
|
The standardized or managed name of the firm associated with the original borrower entry. |
|
borrowerNameId |
long(-2147483648,2147483647) |
|
A unique identifier assigned to each borrower name for consistent referencing. |
|
borrowerNameOriginal |
string(510) |
|
The name of the borrower as reported in the financial filing, preserving source accuracy. |
|
borrowersId |
long(-2147483648,2147483647) |
|
An internal unique identifier used to track borrower entities across systems. |
|
bslId |
long(-2147483648,2147483647) |
|
An identifier used to reference broadly syndicated loan (BSL) data within the system. |
|
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) associated with the investment or transaction. |
|
ciqDocumentId |
long(-9223372036854775807,9223372036854775806) |
|
Unique identifier for a source document. |
|
ciqPortfolioCompanyId |
long(-2147483648,2147483647) |
|
The identifier linking to the company in which the Business Development Company (BDC) has invested, enabling portfolio-level analysis. |
|
ciqTransactionId |
long(-9223372036854775807,9223372036854775806) |
|
A unique identifier assigned to each transaction for tracking and audit purposes. |
|
ciqVersionId |
long(-9223372036854775807,9223372036854775806) |
|
Unique identifier for a specific format or rendition of a source document. |
|
cloType |
long(0,32767) |
|
The category of Collateralized Loan Obligation (CLO) involved in the investment. |
|
cost |
decimal{18,6} |
|
The acquisition price of the investment, used for valuation and performance tracking in reported currency (Magnitude: $000). |
|
currency |
string(3) |
|
The ISO 4217 alpha-3 compliant code specifying the denomination of the investment, supporting multi-currency reporting. |
|
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 (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(10) |
|
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: %). |
|
footnotes |
string(200) |
|
Additional disclosures or explanatory notes related to the investment. |
|
fundType |
string(10) |
|
Specifies the kind of fund involved. It can take one of two values: BDC: Represents bdc fund is involved, IF: Represent interval fund is involved. |
|
industryName |
string(510) |
|
The borrower's primary industry, supporting sector-level analysis. |
|
initialInvestmentDate |
date |
|
The date when the first investment was made into the asset or company. |
|
insertedDateTime |
dateTime* |
|
Timestamp when the record was initially added to the database, providing a timestamp for data ingestion in UTC timezone. |
|
instrumentName |
string(510) |
|
The financial instrument as reported in the 10K or 10Q filing. |
|
instrumentStandardId |
long(-2147483648,2147483647) |
|
A unique identifier for the standardized instrument name, used for mapping and analysis. |
| link |
instrumentStandardName |
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. |
|
lastModifiedDateTime |
dateTime* |
|
Timestamp of the most recent update for the record, enabling audit and version control 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. |
|
order |
long(0,32767) |
|
Defines the sequence or priority of the record within reporting or processing workflows. |
|
pikFlag |
boolean |
|
Indicates whether payment-in-kind (PIK) interest terms apply to the investment. |
|
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 as per reported currency (Magnitude: $000) |
|
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. |
|
ticker |
string(20) |
|
An internal symbol assigned to a Business Development Company (BDC) for identification and reporting purposes. |
|
uniqueId |
long(-9223372036854775807,9223372036854775806)* |
|
Unique identifier used to distinguish a record and support deduplication and traceability. |