Name Assets
Version 1.49
Description The Asset Level Harmonization initiative aims to establish a consolidated database of stationary assets from all divisions of S&P Global, covering over 20,000 companies. The Asset dataset not only contains asset related fields, but also contains list of owner companies, and its source origins before the asset harmonization process. All assets will be given a unique key (asset_uid) so clients can easily identify assets over time, throughout ownership changes, openings and closings. We will also store the corresponding database keys for all S&P assets (e.g. power plant megawatts/fuel type, or automobile manufacturing plant productivity).
Types
Name Category Services Description Count
Asset entity linkspeaker_phone Entity to store asset related information. 5.3 M
AssetDataSources entity linkspeaker_phone Reference table containing the master list of data sources from which assets are collected. Each data source is uniquely identified by data_source_id and can be referenced by records in the sources table. <1K
AssetRelationshipType entity linkspeaker_phone Reference table defining the standardized types of relationships of an asset. <1K
AssetStatus entity linkspeaker_phone Lookup table containing the valid status values for an asset. Each record represents a distinct asset status and its corresponding identifier. <1K
AssetSubType entity linkspeaker_phone Lookup table containing the valid subtypes used to further classify assets. <1K
AssetType entity linkspeaker_phone Lookup table containing the valid types used to classify assets. <1K
Relationship entity linkspeaker_phone Defines the asset relationship types information. 4.5 M
Source entity linkspeaker_phone Defines the asset origin data sources. 4.0 M
8 rows of 8 total
Diagrams
Class
Entity Relationship