| key |
id |
string(25)* |
= |
Unique identifier for the entity record. |
|
bdcType |
string(30) |
|
A classification of the Business Development Company (BDC). It can take one of two values: Internal: Represents a BDC that is internally managed. External: Represents a BDC that is externally managed. |
|
charTypeValue |
string(100) |
|
Describes the nature or attribute associated with the company’s classification. |
|
cik |
long(-2147483648,2147483647) |
|
A unique identifier assigned by the U.S. Securities and Exchange Commission (SEC) for regulatory filings, ensuring traceability in public disclosures. |
|
ciqCharTypeId |
long(-32768,32767) |
|
A unique identifier that links the company to a specific characteristic classification. |
|
ciqCompanyId |
long(-2147483648,2147483647)* |
|
A unique identifier assigned to the company within the Capital IQ (CIQ) Classic system, enabling consistent tracking across datasets. |
|
ciqCompanyTypeId |
long(-32768,32767) |
|
Unique identifier linking the company to a specific characteristic classification. |
|
companyName |
string(100) |
|
The official name of the Business Development Company (BDC) entity, used for identification and reporting. |
|
companyTypeName |
string(50) |
|
A descriptive label corresponding to the company's type, offering clarity in reporting and analysis. |
|
country |
string(2) |
|
Indicates the nation where the company is registered or primarily operates, supporting jurisdictional and regional analysis. This field stores the ISO 3166 alpha-2 compliant country code. |
|
endDate |
date |
|
The date when the company or record was closed, terminated, or became inactive. |
|
fundType |
string(50) |
|
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. |
|
insertedDateTime |
dateTime* |
|
Timestamp when the record was first added to the system in UTC timezone. |
|
isMainCompany |
boolean |
|
Indicates whether the entity is the primary company within a group or structure. |
|
lastModifiedDateTime |
dateTime* |
|
Timestamp of the most recent update made to the record, supporting audit and version control in UTC timezone. |
|
miKeyInstitutionType |
long(0,255) |
|
A classification system that assigns a numeric key to each type of institution for standardized identification and processing across systems. |
|
miKeyInstn |
long(-2147483648,2147483647) |
|
Unique identifier assigned to the company within the Capital IQ (CIQ) Pro system for advanced tracking and linkage. |
|
reportCycle |
string(50) |
|
Defines the frequency at which the company submits financial or regulatory reports (e.g., quarterly, annually). |
|
startDate |
date |
|
The date when the company or record became active, serving as the inception point for tracking. |
|
subTypeValue |
string(500) |
|
Provides additional granularity for classifying the company beyond its primary type. |
|
ticker |
string(20) |
|
The symbol assigned to the company for trading and identification purposes in financial systems. |