| AsPresentedCollection |
entity |
linktimelinespeaker_phone |
Provides information regarding the actual set of collected data, such as income statement, balance sheet etc. |
500.0 K |
| AsPresentedData |
entity |
linktimelinespeaker_phone |
Stores raw, unadjusted financial data values exactly as they appear in original source documents, including reported figures, scaling, and currency information. |
500.0 K |
| AsPresentedFilingDetails |
entity |
linktimelinespeaker_phone |
Provides comprehensive details about a financial filing, including key dates, associated documents, and the Generally Accepted Accounting Principles (GAAP) applied to the financial statements. |
721.7 K |
| AsPresentedSourceCoordinates |
entity |
linktimelinespeaker_phone |
Provides the source document coordinates which will be used to highlight the exact location from which values are collected. |
416.0 K |
| AsPresentedStandardizedDataItems |
entity |
linktimelinespeaker_phone |
Provides reconciliation of standardized data items with as-reported data items at the instance level. |
590.0 K |
| CapitalIQFinancialTemplateType |
entity |
linktimelinespeaker_phone |
Contains the categories of financial reporting templates. |
<1K |
| CapitalStructureAsReportClassType |
entity |
linktimelinespeaker_phone |
Reference table that displays the types of as-reported debt class types. |
<1K |
| CapitalStructureClassType |
entity |
linktimelinespeaker_phone |
Contains information on the type of equity class e.g. Class A, Class B, Class O. |
<1K |
| CapitalStructureCollectionAsReportedData |
entity |
linktimelinespeaker_phone |
Contains the as reported data for an associated debt component and the numerical data item values. |
44.5 M |
| CapitalStructureCollectionStandardizedComponents |
entity |
linktimelinespeaker_phone |
Primarily contains debt capital structure information |
68.4 M |
| CapitalStructureCollectionStandardizedData |
entity |
linktimelinespeaker_phone |
Contains the numerical data items for an associated equity component at a particular financial collection. |
131.0 M |
| CapitalStructureComponent |
entity |
linktimelinespeaker_phone |
Information for each capital structure component for an associated S&P Cap IQ company ID |
11.6 M |
| CapitalStructureCumulativeType |
entity |
linktimelinespeaker_phone |
Reference table that indicates if the debt is redeemable. |
<1K |
| CapitalStructureInterestBenchmarkType |
entity |
linktimelinespeaker_phone |
Reference table that displays the debt interest benchmark. |
<1K |
| CapitalStructureInterestRate |
entity |
linktimelinespeaker_phone |
Provides debt interest data for each capital structure component for an associated debt component |
11.6 M |
| CapitalStructureInterestRateType |
entity |
linktimelinespeaker_phone |
Reference table that displays the type of debt interest rate. |
<1K |
| CapitalStructureIsConvertibleType |
entity |
linktimelinespeaker_phone |
Reference table that displays whether the equity is convertible, and when available, the type of convertible equity. |
<1K |
| CapitalStructureIsSecuredType |
entity |
linktimelinespeaker_phone |
Reference table that displays whether the debt is secured, and when available, the types of secured debt. |
<1K |
| CapitalStructureLevelType |
entity |
linktimelinespeaker_phone |
Reference table that displays the priority level of a security's claim on assets in the event of liquidation (e.g. Senior, Subordinated, Preferred, etc.). |
<1K |
| CapitalStructureMaturityValue |
entity |
linktimelinespeaker_phone |
Typically contains data related to maturity values of various debt securities. It includes information on different financial instruments and their respective maturity dates, which are crucial for assessing repayments/cash outflows. |
19.0 M |
| CapitalStructureMaturityValueType |
entity |
linktimelinespeaker_phone |
Categorizes the types of maturity values that can be associated with capital structure components. It represents maturity types like High-end year, High-end Month, High-end day & Conversion Beginning Year, Conversion Beginning month, Conversion Beginning day etc. can be associated with capital structure components. |
<1K |
| CapitalStructureNonRecourseType |
entity |
linktimelinespeaker_phone |
Reference table that indicates whether the debt is non recourse. |
<1K |
| CapitalStructureParticipatingType |
entity |
linktimelinespeaker_phone |
Reference table that indicates whether participating debt exists. This only applies to Preferred Securities (capitalStructureSubTypeId=9) and indicates whether the component has participating rights. |
<1K |
| CapitalStructureRedeemableType |
entity |
linktimelinespeaker_phone |
Reference table that indicates if the debt is redeemable. |
<1K |
| CapitalStructureSubType |
entity |
linktimelinespeaker_phone |
Reference table that displays the capital subtypes. |
<1K |
| CapitalStructureType |
entity |
linktimelinespeaker_phone |
Reference table that displays whether the equity is convertible, and when available, the type of convertible equity. |
<1K |
| DataFeedOutDataItemTemplateDisplay |
entity |
linkspeaker_phone |
Defines the template and display order for S&P Capital IQ (CIQ) data items, enabling the recreation of financial statements in a typical presentation format. |
1.3 K |
| DataItem |
entity |
linktimelinespeaker_phone |
Reference table containing details for data item IDs |
44.0 K |
| DataVendor |
entity |
linktimelinespeaker_phone |
Contains reference data that identifies the vendor for a particular data set. |
4.0 K |
| DocumentDetails |
entity |
linktimelinespeaker_phone |
Contains the details of the document from which data is collected |
8.2 M |
| ECSAuthorizedSharesType |
entity |
linkspeaker_phone |
Reference table that provides the textual description of the authorizedSharesTypeId. |
<1K |
| ECSVotingRightsType |
entity |
linkspeaker_phone |
Reference table that provides the textual description of the votingRightsTypeId. |
<1K |
| EquityCapitalStructureComponentProfilingAttributes |
entity |
linktimelinespeaker_phone |
Provides attributes of each equity component for an associated companyId. |
197.1 K |
| ExcelPeriodConstant |
entity |
linkspeaker_phone |
Defines various period constants used in Excel-related financial calculations, including economic and financial period types. It provides standardized identifiers for different time frequencies and period definitions. |
<1K |
| FastFinCapitalStructureCollectionAsReportedData |
entity |
linktimelinespeaker_phone |
Contains the as reported data for an associated debt component and the numerical data item values. |
5.0 M |
| FastFinCapitalStructureCollectionStandardizedComponents |
entity |
linktimelinespeaker_phone |
Primarily contains debt capital structure information |
32.3 M |
| FastFinCapitalStructureCollectionStandardizedData |
entity |
linktimelinespeaker_phone |
Contains the numerical data items for an associated equity component at a particular financial collection. |
60.7 M |
| FastFinCapitalStructureComponent |
entity |
linktimelinespeaker_phone |
Information for each capital structure component for an associated S&P Cap IQ company ID |
9.1 M |
| FastFinDocumentDetails |
entity |
linktimelinespeaker_phone |
Contains the details of the document from which data is collected |
1.5 M |
| FastFinFinancialCollection |
entity |
linktimelinespeaker_phone |
Contains the different collections that are reported in a filing |
3.5 M |
| FastFinFinancialCollectionAsReportedData |
entity |
linktimelinespeaker_phone |
Contains the as reported data collected for a company i.e. prior to standardization |
3.0 M |
| FastFinFinancialCollectionDeletedBreakups |
entity |
linktimelinespeaker_phone |
Contains the as reported data collected for a company for which breakup is collected |
14.0 M |
| FastFinFinancialCollectionInterimData |
entity |
linktimelinespeaker_phone |
Processing table which contains the interim data prior to standardization |
414.9 K |
| FastFinFinancialCollectionStandardizedData |
entity |
linktimelinespeaker_phone |
Contains the standardized data for a company |
22.0 M |
| FastFinFinancialCollectionStandardizedDataIQAdded |
entity |
linktimelinespeaker_phone |
Contains market data related information for a company |
47.0 M |
| FastFinFinancialCollectionStandardizedTextData |
entity |
linktimelinespeaker_phone |
Contains the captions for standardized data items |
30.0 M |
| FastFinFinancialCrossCollection |
entity |
linktimelinespeaker_phone |
Contains the components of the cross period collection |
99.2 M |
| FastFinFinancialInstance |
entity |
linktimelinespeaker_phone |
Contains details of filings reported by the company |
28.6 M |
| FastFinFinancialInstanceDetails |
entity |
linktimelinespeaker_phone |
A company's financials are collected on a period by period basis. A Financial Period is a defined period in time. A company that reports financial statement data will most likely have multiple period. Also it contains metadata for a given instance |
15.8 M |
| FastFinFinancialInstanceToCollectionDetails |
entity |
linktimelinespeaker_phone |
Used to define the relationship between a financial instance and a financial collection, allowing a collection to be associated with multiple instances |
1.5 M |
| FastFinFinancialPeriod |
entity |
linktimelinespeaker_phone |
Contains the periods in time for a company?s financials, which are collected on a period by period basis |
11.3 M |
| FastFinRatioComponentInstances |
entity |
linktimelinespeaker_phone |
Contains instances which are used for calculating ratios |
73.3 M |
| FeedDataItemDisp |
entity |
linktimelinespeaker_phone |
Contains mapping between the dataItemId and the corresponding displaySection for a particular type of display. It also includes the sort order for each displaySection in that display type, as well as the sort order for each dataItemId within that displaySection. |
41.0 K |
| FinDispCellClass |
entity |
linktimelinespeaker_phone |
Contains formatting rules to be applied dynamically based on the cell value. |
<1K |
| FinDispDataItemToDisplaySection |
entity |
linktimelinespeaker_phone |
Contains the mapping between a dataItemId to a financial glossary display page section as available on the CIQ platform. |
23.8 K |
| FinDispDisplayPage |
entity |
linktimelinespeaker_phone |
Contains display page information. Display pages represent financial statements, key stats, ratios and other categories of financial data as available on CIQ platforom. |
<1K |
| FinDispDisplayPageAndTemplateToDisplayType |
entity |
linktimelinespeaker_phone |
Contains the mapping between a displayTypeId, the displayPageId, and the corresponding templateTypeId. |
<1K |
| FinDispDisplaySection |
entity |
linktimelinespeaker_phone |
Contains display section information. Display sections represent a categorical grouping of data items for a particular template on the CIQ platform Examples include: Header items, Per Share items etc. |
2.4 K |
| FinDispDisplayType |
entity |
linktimelinespeaker_phone |
Contains display type information. Display types represent a more granular version of standard template types. Examples include: Banks: IS - Detailed, Banks: BS - Detailed etc. |
<1K |
| FinDispDisplayValueFormat |
entity |
linktimelinespeaker_phone |
Contains the format in which dataitemvalue should be displayed on the desktop page. |
<1K |
| FinancialAuditType |
entity |
linktimelinespeaker_phone |
Reference table for the audittype |
<1K |
| FinancialBlock |
entity |
linktimelinespeaker_phone |
Categorizes and groups related financial line items within a financial statement, providing a structural framework for organizing financial data. |
<1K |
| FinancialCollection |
entity |
linktimelinespeaker_phone |
Contains the as reported data collected for a company for which breakup is collected |
10.0 M |
| FinancialCollectionAsReportedData |
entity |
linktimelinespeaker_phone |
Contains the as reported data collected for a company i.e. prior to standardization |
472.8 M |
| FinancialCollectionDeletedBreakups |
entity |
linktimelinespeaker_phone |
Contains the as reported data collected for a company for which breakup is collected |
10.2 M |
| FinancialCollectionInterimData |
entity |
linktimelinespeaker_phone |
Processing table which contains the interim data prior to standardization |
2.5 M |
| FinancialCollectionStandardizedData |
entity |
linktimelinespeaker_phone |
Contains the standardized data for a company |
80.4 M |
| FinancialCollectionStandardizedDataIQAdded |
entity |
linktimelinespeaker_phone |
Contains market data related information for a company |
20.0 M |
| FinancialCollectionStandardizedTextData |
entity |
linktimelinespeaker_phone |
Contains the captions for standardized data items |
21.0 M |
| FinancialCollectionType |
entity |
linktimelinespeaker_phone |
Contains information to help query specific collections |
<1K |
| FinancialCrossCollection |
entity |
linktimelinespeaker_phone |
Contains the components of the cross period collection |
32.1 M |
| FinancialDataSetType |
entity |
linktimelinespeaker_phone |
Reference table that describes the dataset |
<1K |
| FinancialDescription |
entity |
linktimelinespeaker_phone |
Contains the description for the descriptionid |
26.9 M |
| FinancialInstance |
entity |
linktimelinespeaker_phone |
Contains details of filings reported by the company |
41.1 M |
| FinancialInstanceDetails |
entity |
linktimelinespeaker_phone |
A company's financials are collected on a period by period basis. A Financial Period is a defined period in time. A company that reports financial statement data will most likely have multiple period. Also it contains metadata for a given instance |
57.8 M |
| FinancialInstanceToCollectionDetails |
entity |
linktimelinespeaker_phone |
Used to define the relationship between a financial instance and a financial collection, allowing a collection to be associated with multiple instances |
2.0 M |
| FinancialInstanceToCollectionType |
entity |
linktimelinespeaker_phone |
Describes the type of relationship between the Financial Instance and the Financial Collection |
<1K |
| FinancialInstanceType |
entity |
linktimelinespeaker_phone |
Contains details on the type of instance e.g. press release, original instance, encore etc |
<1K |
| FinancialMultiplesReference |
entity |
linkspeaker_phone |
Reference table which provides the full item names and the excel metrics. |
<1K |
| FinancialPeriod |
entity |
linktimelinespeaker_phone |
Contains the periods in time for a company?s financials, which are collected on a period by period basis |
13.1 M |
| FinancialPeriodType |
entity |
linktimelinespeaker_phone |
Contains information on the type of period (annual, quarterly, LTM, YTD etc) |
<1K |
| FinancialRestatementType |
entity |
linktimelinespeaker_phone |
Reference table that describes the type of restatement for a particular financial statement, for example, Preliminary, Original, Restated, Discontinued Operations |
<1K |
| FinancialTemplateType |
entity |
linktimelinespeaker_phone |
Contains the categories of financial reporting templates |
<1K |
| FinancialUnitType |
entity |
linktimelinespeaker_phone |
Reference table that describes the magnitude |
<1K |
| FormType |
entity |
linkspeaker_phone |
Contains data of Form Type and its Description. |
<1K |
| FormulaCategoryType |
entity |
linktimelinespeaker_phone |
Contains the various financial formulas used in calculations |
<1K |
| GAAPCodes |
entity |
linktimelinespeaker_phone |
Contains Generally Accepted Accounting Principles (GAAP) codes used for preparing the financial statements. |
<1K |
| GlossaryDataItemToDisplaySection |
entity |
linktimelinespeaker_phone |
Contains the mapping between a dataItemId to a financial glossary display page section as available on the CIQ platform. |
7.5 K |
| GlossaryDataItemToTemplate |
entity |
linktimelinespeaker_phone |
Contains the mapping between a dataItemId to its corresponding template type. This mapping can be 1:1 or 1:many. |
12.0 K |
| GlossaryDisplaySection |
entity |
linktimelinespeaker_phone |
Contains the names of the financial glossary display page sections. These represent categories or groups of data items as available on CIQ platform. Examples include industry-specific or dataset-specific items. |
<1K |
| InstrumentDataType |
entity |
linktimelinespeaker_phone |
Contains the type of the instrument (i.e. either data or aggregate). Also includes block name and block id information. |
<1K |
| MasterAsPresentedFinancialDescription |
entity |
linktimelinespeaker_phone |
Contains the description as reported by the company for that particular line item |
500.0 K |
| OptionsCollectionStandardizedData |
entity |
linktimelinespeaker_phone |
Contains the financial numerical data (i.e. Data Item ID, data item value, unittypeid, scaleId etc.) associated with a collection. |
500.0 K |
| OptionsCollectionStandardizedTextData |
entity |
linktimelinespeaker_phone |
Contains the financial text data (Stock Option Plan Name, Share Class Name) associated with an option collection. |
500.0 K |
| OptionsCollectionStandardizedTrancheData |
entity |
linktimelinespeaker_phone |
Contains the financial numerical data (i.e. Data Item ID, data item value, unittypeid, scaleId etc.) of plantotrancheobjectid associated with a collection. |
500.0 K |
| OptionsCollectionStandardizedTrancheTextData |
entity |
linktimelinespeaker_phone |
Contains the financial numerical data (i.e. Data Item ID, data item value, unittypeid, scaleId etc.) of plantotrancheobjectid associated with a collection. |
509.6 K |
| OptionsPlanToObject |
entity |
linktimelinespeaker_phone |
Contains the mapping for option plans to object ids. |
663.1 K |
| OptionsPlanToTranche |
entity |
linktimelinespeaker_phone |
Contains the mapping for option plans to tranches. |
1.0 M |
| OptionsRanking |
entity |
linktimelinespeaker_phone |
Contains rankings for the tranches relating to Options / Warrants. When joining with other entities use only the planToTrancheObjectId |
1.0 M |
| RatioComponentInstances |
entity |
linktimelinespeaker_phone |
Contains instances which are used for calculating ratios |
90.8 M |
| Scale |
entity |
linktimelinespeaker_phone |
Defines scaling factors applied to financial data values to represent large numbers concisely and ensure accurate interpretation. |
<1K |
| ScreeningTrailingMultiples |
entity |
linktimelinespeaker_phone |
Stores calculated trailing multiples for companies, including the specific data value, its associated data type, and the relevant pricing date. It is used for screening and analysis of company performance metrics. |
399.3 M |
| ScreeningTrailingMultiplesDataTypeToComponents |
entity |
linkspeaker_phone |
Maps data types used in screening trailing multiples to their constituent numerator and denominator components. It provides a detailed breakdown of how each data type is constructed from its underlying financial elements. |
<1K |
| ScreeningTrailingMultiplesDetails |
entity |
linktimelinespeaker_phone |
Stores calculated trailing multiples for companies, including the specific data value, its associated data type, and the relevant pricing date. It is used for screening and analysis of company performance metrics. |
20.4 M |
| ScreeningTrailingMultiplesNumeratorType |
entity |
linkspeaker_phone |
Categorizes and identifies different types of numerators used in the calculation of screening trailing multiples. It provides descriptive names for various numerator components. |
<1K |
| Segment |
entity |
linktimelinespeaker_phone |
Contains data related to the segment. |
1.0 M |
| SegmentClassification |
entity |
linktimelinespeaker_phone |
Contains data related to the segment classification. |
1.0 M |
| SegmentClassificationType |
entity |
linktimelinespeaker_phone |
Contains data related to the segment classification type. |
<1K |
| SegmentDescription |
entity |
linktimelinespeaker_phone |
Contains data related to the segment description. |
1.0 M |
| SegmentType |
entity |
linktimelinespeaker_phone |
Contains data related to the segment type. |
<1K |
| SegmentsCollectionAsReportedData |
entity |
linktimelinespeaker_phone |
Contains as reported segment financial data pertaining to business and geographical segments. |
1.0 M |
| SegmentsCollectionStandardizedComponentsData |
entity |
linktimelinespeaker_phone |
Contains standardized segment financial data pertaining to business and geographical segments. |
1.0 M |
| SegmentsCollectionStandardizedData |
entity |
linktimelinespeaker_phone |
Contains the Standardized Segments data (i.e. Data Item ID, data item value, unittypeid, scaleId etc.) for a collection. |
1.0 M |
| SegmentsSubtotals |
entity |
linktimelinespeaker_phone |
Contains subtotaled segment financial data pertaining to business and geographical segments. |
<1K |
| SubType |
entity |
linktimelinespeaker_phone |
Contains descriptors for industries, geographies and other company characteristics. |
17.7 K |
| TrailingMultiples |
entity |
linktimelinespeaker_phone |
Contains trailing multiple data for companies, including currency conversion factors, financial instance details, and period types. It provides comprehensive data for analyzing company valuation based on historical performance. |
49.1 M |