Name fundamentals
Version 2.43
Description S&P Capital IQ Financials provides global standardized financial statement data for over 200,000 companies, including over 95,000 active and inactive public companies.
Timeseries Available from 2025-06-26
Types
Name Category Services Description Count
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
116 rows of 116 total
Diagrams
Class
Entity Relationship