| key |
id |
string(100)* |
= |
The unique identifier for a particular company's debt obligation or equity component.Note: A componentId is not specific to a filing. The same componentId may be used across multiple filings if the details of the debt component did not change. For example, the component ID of 112233 is assigned for a 5% bond with an amount outstanding of $100mm due in 2015 (as listed in a company's 2009 annual report). If this same bond is listed in the company's 2010 annual report with an amount outstanding of $90mm, the same componentId of 112233 will be assigned. |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row |
|
activeFlag |
boolean |
|
Indicates that the component is active or outstanding |
|
addedOnDate |
dateTime |
|
Represents the date and time of when the credit facility or debt component was added. Time zone is EST. |
| link |
capitalStructureAsReportClassType |
CapitalStructureAsReportClassType |
|
Identifier is currently not being used in the Debt Capital Structure package. |
|
capitalStructureAsReportClassTypeId |
long(-2147483648,2147483647) |
|
Identifier is currently not being used in the Debt Capital Structure package. |
| link |
capitalStructureClassType |
CapitalStructureClassType |
|
The unique identifier for the forms of capital. |
|
capitalStructureClassTypeId |
long(-2147483648,2147483647) |
|
The unique identifier for the forms of capital. |
|
capitalStructureCleanedDescription |
string(255) |
|
For each componentId, the description of the component (e.g., short-term loans at 2.2%, convertible notes, other notes payable through 2006, etc.) |
|
capitalStructureComponentId |
long(-2147483648,2147483647)* |
|
Numeric identifier for a particular company debt obligation or equity component. A componentId is not specific to a single filing and may be reused across multiple filings if the component details remain unchanged. |
| link |
capitalStructureCumulativeType |
CapitalStructureCumulativeType |
|
The unique identifier that displays if cumulative interest debt exists (e.g., NA, Yes, No) |
|
capitalStructureCumulativeTypeId |
long(-2147483648,2147483647) |
|
The unique identifier that displays if cumulative interest debt exists (e.g., NA, Yes, No) |
| link |
capitalStructureIsConvertibleType |
CapitalStructureIsConvertibleType |
|
The unique identifier that displays whether the debt is convertible, and when available, the types of convertible debt.(e.g., yes, no, convertible, exchangeable, with warrants, etc.) |
|
capitalStructureIsConvertibleTypeId |
long(-2147483648,2147483647) |
|
The unique identifier that displays whether the debt is convertible, and when available, the types of convertible debt.(e.g., yes, no, convertible, exchangeable, with warrants, etc.) |
| link |
capitalStructureIsSecuredType |
CapitalStructureIsSecuredType |
|
The unique identifier that indicates whether the debt is secured, and when available, the types of secured debt. (e.g., yes, no, securitized, second lien, etc.) |
|
capitalStructureIsSecuredTypeId |
long(-2147483648,2147483647) |
|
The unique identifier that indicates whether the debt is secured, and when available, the types of secured debt. (e.g., yes, no, securitized, second lien, etc.) |
| link |
capitalStructureLevelType |
CapitalStructureLevelType |
|
The unique identifier for the priority level of the security's claim on assets in the event of liquidation (e.g., senior, subordinated, preferred, etc.) |
|
capitalStructureLevelTypeId |
long(-2147483648,2147483647) |
|
The unique identifier for the priority level of the security's claim on assets in the event of liquidation (e.g., senior, subordinated, preferred, etc.) |
| link |
capitalStructureNonRecourseType |
CapitalStructureNonRecourseType |
|
The unique identifier that displays if the debt is nonrecourse (e.g., NA, Yes, No) |
|
capitalStructureNonRecourseTypeId |
long(-2147483648,2147483647) |
|
The unique identifier that displays if the debt is nonrecourse (e.g., NA, Yes, No) |
| link |
capitalStructureParticipatingType |
CapitalStructureParticipatingType |
|
The unique identifier that displays if participating debt exists (e.g., NA, Yes, No). This identifier only applies to Preferred Securities (capitalStructureSubTypeId=9). |
|
capitalStructureParticipatingTypeId |
long(-2147483648,2147483647) |
|
The unique identifier that displays if participating debt exists (e.g., NA, Yes, No). This identifier only applies to Preferred Securities (capitalStructureSubTypeId=9). |
| link |
capitalStructureRedeemableType |
CapitalStructureRedeemableType |
|
The unique identifier that displays if the debt is redeemable (e.g., NA, Yes, No) |
|
capitalStructureRedeemableTypeId |
long(-2147483648,2147483647) |
|
The unique identifier that displays if the debt is redeemable (e.g., NA, Yes, No) |
| link |
capitalStructureSubType |
CapitalStructureSubType |
|
The unique identifier for the type of security associated with the component (e.g., commercial paper, revolving credit, term loans, bonds and notes, etc.) |
|
capitalStructureSubTypeId |
long(-2147483648,2147483647) |
|
The unique identifier for the type of security associated with the component (e.g., commercial paper, revolving credit, term loans, bonds and notes, etc.) |
|
companyId |
long(-2147483648,2147483647) |
|
The unique identifier assigned to each company in the S&P Capital IQ database. |
|
inactiveDate |
dateTime |
|
Represents the expiry or termination date and time of the credit facility or debt component. However, the time value is currently not available for the Capital Structure data and is therefore displayed as '00:00'. Time zone is EST. |
|
issuedCurrencyId |
long(-2147483648,2147483647) |
|
The unique identifier that denotes the currency for the debt issue (e.g., 160, 50, 27, 0, etc.) |
|
startDate |
dateTime |
|
Represents the start date and time of the credit facility or debt component. However, the time value is currently not available for the Capital Structure data and is therefore displayed as '00:00'. Time zone is EST. |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |