Share via

Store ESG measurement data

  • Article

Free trial

GHG emission scenarios

The environmental, social, and governance (ESG) data model stores the data into different target tables based on different greenhouse gas (GHG) emission measurement scenarios and granularities. To simplify the ingestion process, Sustainability data solutions in Microsoft Fabric provides an intermediary table called Emission raw data import to help you route your data to the correct target table.

Emissions raw data import ID

  • Party ID (FK)
  • Process ID (FK)
  • Process Type ID (FK)
  • Asset ID (FK)
  • Vendor ID (FK)
  • Generator ID (FK)
  • Greenhouse Gas Emissions Scope ID (FK)
  • Greenhouse Gas Emissions Category ID (FK)
  • Greenhouse Gas Emissions Purpose Type ID (FK)
  • Greenhouse Gas Source Type ID (FK)
  • Greenhouse Gas ID (FK)
  • Greenhouse Gas Emission Factor ID (FK)
  • Fuel Type ID (FK)
  • Purchased Energy Type ID (FK)
  • Metric Purpose ID (FK)
  • Calculation Algorithm ID (FK)
  • Period Start Timestamp
  • Period End Timestamp
  • Greenhouse Gas Emissions Units
  • Greenhouse Gas Emissions Unit of Measure ID (FK)
  • CO2e Emission Units
  • CO2e Emissions Unit of Measure ID (FK)
  • Related Cost
  • ISO Currency Code (FK)
  • Biogenic Emission Indicator
  • Biogenic Emission Factor
  • Emissions Raw Data Import Note

Scenarios

There are two scenarios in which you enter your GHG emission data, as shown in this table.

Scenario Scope ESG data model target tables
Total CO2 equivalent emission quantity Scope 1

Scope 2

Scope 3		 PARTY SCOPE CATEGORY PURPOSE GREENHOUSE GAS EQUIVALENT EMISSIONS
Greenhouse gas specific CO2 equivalent emission quantity Scope 1  PARTY GREENHOUSE GAS

PARTY PROCESS TYPE GREENHOUSE GAS

PROCESS GREENHOUSE GAS

PROCESS ASSET GREENHOUSE GAS
Scope 2  PARTY INDIRECT EMISSIONS

PARTY VENDOR INDIRECT EMISSIONS

PARTY VENDOR GENERATOR INDIRECT EMISSIONS
Scope 3  PARTY SCOPE CATEGORY GREENHOUSE GAS

Mandatory fields

In this section, you can identify the list of mandatory fields to be populated in the Emissions raw data import table for each of these scenarios.

Total CO2 equivalent emission quantity

Mandatory fields to be populated in Emissions raw data import table:

  • Emissions Raw Data Import ID
  • Source Modified On
  • Party ID/Asset ID/Process ID/Process Type ID
  • Greenhouse Gas Emissions Scope ID
  • Greenhouse Gas Emissions Category ID
  • Period Start Timestamp
  • Period End Timestamp
  • CO2e Emission Units
  • CO2e Emissions Unit of Measure ID

Greenhouse gas specific CO2 equivalent emission quantity (Scope 1)

Mandatory fields to be populated in Emissions raw data import table:

  • Emissions Raw Data Import ID
  • Source Modified On
  • Party ID/Asset ID/Process ID/Process Type ID
  • Greenhouse Gas Emissions Scope ID
  • Greenhouse Gas Source Type ID
  • Greenhouse Gas ID
  • Period Start Timestamp
  • Period End Timestamp
  • CO2e Emission Units
  • CO2e Emissions Unit of Measure ID

Greenhouse gas specific CO2 equivalent emission quantity (Scope 2)

Mandatory fields to be populated in Emissions raw data import table:

  • Emissions Raw Data Import ID
  • Source Modified On
  • Party ID/Asset ID/Process ID/Process Type ID
  • Greenhouse Gas Emissions Scope ID
  • Calculation Algorithm ID
  • Purchased Energy Type ID
  • Greenhouse Gas ID
  • Period Start Timestamp
  • Period End Timestamp
  • CO2e Emission Units
  • CO2e Emissions Unit of Measure ID

Greenhouse gas specific CO2 equivalent emission quantity (Scope 3)

Mandatory fields to be populated in Emissions raw data import table:

  • Emissions Raw Data Import ID
  • Source Modified On
  • Party ID/Asset ID/Process ID/Process Type ID
  • Greenhouse Gas Emissions Scope ID
  • Greenhouse Gas Emissions Category ID
  • Greenhouse Gas ID
  • Period Start Timestamp
  • Period End Timestamp
  • CO2e Emission Units
  • CO2e Emissions Unit of Measure ID

Water sustainability scenarios

The ESG data model stores the water quantity data into different target tables based on the granularity at which the data is captured. To simplify the ingestion process, SDSF provides an intermediary table called Water utilization raw data import to help users route their data to the right target table.

Water utilization raw data import

  • Party ID (FK)
  • Process ID (FK)
  • Process Type ID (FK)
  • Asset ID (FK)
  • Water Utilization Type ID (FK)
  • Water Source Type ID (FK)
  • Water Type ID (FK)
  • Metric Purpose ID (FK)
  • Calculation Algorithm ID (FK)
  • Period Start Timestamp
  • Period End Timestamp
  • Water Utilization Units
  • Water Utilization Unit of Measure ID (FK)
  • Water Related Cost
  • ISO Currency Code (FK)
  • Water Utilization Raw Data Import Note

Mandatory fields

Mandatory fields to be populated in Water utilization raw data import table:

  • Water Utilization Raw Data Import ID
  • Source Modified On
  • Party ID/Asset ID/Process ID/Process Type ID
  • Water Utilization Type ID
  • Period Start Timestamp
  • Period End Timestamp
  • Water Utilization Units
  • Water Utilization Unit of Measure ID

Waste sustainability scenarios

The ESG data model stores the waste quantity data into different target tables based on the granularity at which the data is captured. To simplify the ingestion process, SDSF provides an intermediary table called Waste raw data import to help users route their data to the right target table.

Waste raw data import

  • Party ID (FK)
  • Process ID (FK)
  • Process Type ID (FK)
  • Asset ID (FK)
  • Waste Material Type ID (FK)
  • Waste Stream ID (FK)
  • Waste Diversion Method ID (FK)
  • Metric Purpose ID (FK)
  • Calculation Algorithm ID (FK)
  • Period Start Timestamp
  • Period End Timestamp
  • Waste Volume
  • Waste Volume Unit of Measure ID (FK)
  • Waste Weight
  • Waste Weight Unit of Measure ID (FK)
  • Waste CO2e Emissions
  • Waste CO2e Emissions Unit of Measure ID (FK)
  • Waste Related Cost
  • ISO Currency Code (FK)
  • Waste Raw Data Import Note

Mandatory fields

Mandatory fields to be populated in waste raw data import table:

  • Waste Raw Data Import ID
  • Source Modified On
  • Party ID/Asset ID/Process ID/Process Type ID
  • Waste Diversion Method ID
  • Period Start Timestamp
  • Period End Timestamp
  • Waste Weight
  • Waste Weight Unit of Measure ID

Next step

Transform data

📄 Product page
🎓 Training

✅ Free trial
🎥 YouTube channel

💻 Community
LinkedIn icon. LinkedIn group