Versions Compared

Old Version 34

changes.mady.by.user GUIRARDEL, Matthieu

Saved on

compared with

New Version Current

changes.mady.by.user GUIRARDEL, Matthieu

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Why is it important for Solvay to calculate its PCFs ?

Our clients and the final consumers are asking for lower impact products. 

So we need to measure our products’ impact to be able to improve it and share it with our clients. We also want to progress towards a sustainable by design innovation and sustainable portfolio management.

Why do we need a digital initiative to calculate our PCFs?

Today the PCF is an output of Life Cycle Assessments, which are performed manually by R&I experts. They require weeks to months of work and one paint point is the data availability. 

With our initiative we want to automate the PCF calculations and make it available to our SD Champions, and even to our clients.

PCF breakdown by scope: 

Scope numberScope nameScope 1 Direct energy emission (Electricity, Steam, Gas, Fuel)Scope 2Indirect energy emission (link to energy production) 

Scope 3.1

Raw materials Scope 3.3Energy emission upstream (Ressources before the energy production, for exemple carbon footprint produce by the truck to get uranium)Scope 3.4 internTransportation of intermediateScope 3.4 upstreamTransportation of Raw Materials from our suppliers site to our plantsScope 3.5Waste produce during the End to End production of the finish productScope 1 other GHGOther Green house Gas

Computations in background are performed:

Every week day at 1pm : load of only Advanced_GBU_Access_rights_PROD_ 

Weekly 

  • every Tuesday evening:   Validation       +  Cerise load   +   calculation based on input flat files
  • every Thursday evening: Validation only 

Monthly every 14th of each month for a full load (all sources) + validation + calculation

Data source and Lineage

Data source: 

Data source mapping and lineage, DPL creation:  
sheet DataLineage_BQ_202503 Data Knowledge PCF - Sustainability IT11672
Looker Studio   https://lookerstudio.google.com/s/u7OZwfhNNSM

Data sources

Filters 

SAP ZWEHST098

Filter to keep only 

( authorization_group IN (ALL , ZZ_BU_00 , ZZ_RM_SCO , ZZ_RM_ECO )    

OR

  business_unit IN (CS, SP, PA, CM, TS, OG) )

AND

andmaterial_code not equal to ""

For info to get the commercial product code (basic_material or material_group for SPP)(case  whensource_systemlike'SP'thenmaterial_groupelsebasic_materialend)asspecification_codeJOIN DM.DIM_sap_zwehst098 AS sapON sap.source_system_material_name = material_code

This file can be found here: Functional documentation links

Overview on the calculation flows :  PCF Calculation Functional documentation

Flat File management

Data

Preparation: 

Preparation 

New FACT_imep from ODS.imep_conso (without order_type for WP2) and ODS_imep_pf2 (with order type for PF2): 

Validation process

Historization & Flat files mgt including Ecoinvent

Scope 3.1 Raw

Materials: 

Materials 

  • Suppliers / Secondary ( Proxy or Ecoinvent ) Emission Factor :PA-261 |  

→ Initial calculation of ef_rm for Scope 3.1 Calculation EF at Raw Material Level

>>>> Updated with PA-2551 | Update Scopes 3.1 and 3.4 to comply with TFS guidelines

Updates from primary and secondary data import up to FACT_CALC_scope_3_1_3_4_updstream_estimated

→ Details ont secondary data sources (full and bom to Reporting 3.1): PA-2180 | Corporate Reporting 3.1 detailed specification

>>>> replaced by last part in PA-2551 | Update Scopes 3.1 and 3.4 to comply with TFS guidelines

NEW

Scope 3.1 Corporate Reporting 

Scope 3.4 upstream Transport 

Scope 1, 2 and 3.3 Energy

: 

Energy type, activity code and vector mapping WP1

V.2 Allocate PF1 energy CO2 contribution to Intermediate ProductsExcluded Cost Objects Flat file: Energy SPP // Excluded Cost Objects flat file  

Scope 3.4 internal

transportation: 

transportation 

Scope 3.5

Waste and

Wastes & Scope 1

GHG : 

other GHGs 

Biogenic

: 

NEW // Remove commercial product aggregations from the final tables: PA-2634 | Remove Commercial Product aggregation from Biogenic tables

Fact_Pcf

: 

Small enhancements: 

Data

Quality

Quality 


DPL specifications

Link for all functional docs links

Foster your navigation:

Children Display

Flat Files Links to Input Data for PCF


FOR PROD. ENV. 

export to GCP_

PROD

3.4.1 Configuration PROD

Advanced_GBU_Access_rights_PROD_

PCF_InputFile_Master_Unit_conversion_PROD_

Config_default_PDS_DQR_PROD_        TFS compliant

EcoinventData_for_GCP_PROD

GEO_GCP  (Geographical classification master table)

AO_GCP     (Activities overview from the Database Overview xls file)

LCIA_GCP  (Emissions factors by activity)


3.4.2. RM-Mapping PROD

PCF_InputFile_ef_supplier_PROD_         TFS compliant

PCF_InputFile_ef_rm_mapping_PROD_ TFS compliant

PCF_InputFile_sp_proxy_PROD_             TFS compliant

PCF_InputFile_

ef

Substitution_BOM_

supplier

Imep_PROD_  NEW

PCF_InputFile_ef_wastes_sites_PROD_ 

PCF_InputFile_ef_transp_routes_PROD_

PCF_InputFile_

Energy

energy_

contribution_correction

mapping_PROD_ 

Consistency checks over Energy mapping:cerise-em-imep-bom-consistency

PCF_InputFile_Energy_

energy

contribution_

mapping

correction_PROD_

Biogenic_Master_GCP    /!\ one file for each GBU     

Syensqo_PCF_InputFile_biogenic_masterdata_CS_PROD_

Syensqo_PCF_InputFile_biogenic_masterdata_SPP_PROD_

Syensqo_PCF_InputFile_biogenic_masterdata_TS_PROD_

Syensqo_PCF_InputFile_biogenic_masterdata_OG_PROD_

Syensqo_PCF_InputFile_biogenic_masterdata_PA_PROD_

Syensqo_PCF_InputFile_biogenic_masterdata_CM_PROD_NEW

PCF_InputFile_manual_biogenic_PROD_

PCF_InputFile_manual_pcf_PROD_


3.4.3 Validation Process PROD

Syensqo_PCF_InputFile_validation_pcf_PROD_ 

Syensqo_PCF_InputFile_validation_biogenic_PROD_

Connected files for supervision

PCF validation status overview

PCF PROD Missing routes

What is PCF: 

It is the quantity of greenhouse gas that was emitted to manufacture a product. It can also include emissions during use and end of life.

It is expressed in CO2e, meaning CO2 equivalent, as other GHG are counted.

Here we are talking about cradle to gate footprint, meaning we are targeting emissions from our raw materials purchased or the extraction of our fossil energies up to the gate of our plants, meanning of course that we include the emissions to transform our raw materials into finished products.