Name fundamentals
Version 2.18
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 2024-12-27
Types
Name Category Services Description Count
DataItem entity linktimelinespeaker_phone Reference table containing details for data item IDs <1K
FinancialAuditType entity linktimelinespeaker_phone Reference table for the audittype <1K
FinancialCollectionAsReportedData entity linktimelinespeaker_phone This entity contains the as reported data collected for a company i.e. prior to standardization 206.4 K
FinancialCollectionDeletedBreakups entity linktimelinespeaker_phone This entity contains the as reported data collected for a company for which breakup is collected 327.0 K
FinancialCollectionInterimData entity linktimelinespeaker_phone This entity is a processing table which contains the interim data prior to standardization 25.9 K
FinancialCollectionStandardizedData entity linktimelinespeaker_phone This entity contains the standardized data for a company 666.0 K
FinancialCollectionStandardizedDataIQAdded entity linktimelinespeaker_phone This entity contains market data related information for a company 661.5 K
FinancialCollectionStandardizedTextData entity linktimelinespeaker_phone This entity contains the captions for standardized data items 631.3 K
FinancialCollectionType entity linktimelinespeaker_phone A financial collection represents an actual set of collected data. This table contains information to help query specific collections <1K
FinancialCrossCollection entity linktimelinespeaker_phone This table contains the components of the cross period collection 27.8 K
FinancialDataSetType entity linktimelinespeaker_phone Reference table that describes the dataset <1K
FinancialDescription entity linktimelinespeaker_phone Table containing the description for the descriptionid 12.4 K
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 1.0 M
FinancialInstanceToCollectionDetails entity linktimelinespeaker_phone This table is used to define the relationship between a financial instance and a financial collection, allowing a collection to be associated with multiple instances 969.1 K
FinancialInstanceToCollectionType entity linktimelinespeaker_phone This table describes the type of relationship between the Financial Instance and the Financial Collection <1K
FinancialInstanceType entity linktimelinespeaker_phone This table contains details on the type of instance e.g. press release, original instance, encore etc <1K
FinancialPeriodType entity linktimelinespeaker_phone This table 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
FinancialUnitType entity linktimelinespeaker_phone Reference table that describes the magnitude <1K
RatioComponentInstances entity linktimelinespeaker_phone Table which contains instances which are used for calculating ratios 7.8 K
20 rows of 20 total
Diagrams
Class
Entity Relationship