Versions Compared

Key

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

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 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) )

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 

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

Validation process

Preparation

Table WRK_BOM
  • IMEP_site_net_output
  • PA-391 - Create Table Finished_Product_STD_QTY
  • Conversion Master table Materials: 

    Materials 

    • Suppliers / Secondary ( Proxy or Ecoinvent ) Emission Factor :
    PA-261 - Integrate Solvay Suppliers RawMat Carbon Footprint to our PCF
    •  

    → 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

    • CO2 Contribution calculations:
    DMSCOPEWP1_Estimated
  • Special PDS aggregation rule : Bug PDS
  • >>>> replaced by last part in PA-2551 | Update Scopes 3.1 and 3.4 to comply with TFS guidelines

    • Quality KPI : Raw material emission factor coverage
    Quality KPI

    Scope 3.1 Corporate Reporting 

    Scope 3.4 upstream Transport 

    Scope 1, 2 and 3.3 Energy

    • CO2 Contribution calculations:

    WRK

    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

    transportation: Scope 1 GHG and 3.5Waste : 

    • CO2 Contribution calculations:

    WRK

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

    Fact_Pcf

    Validation process

    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.   

    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.4Transportation of intermediateScope 3.5Waste produce during the End to End production of the finish productScope 1 other GHGOther Green house Gas

    How are calculated our PCFs?

    Image Removed

    Functional Data Flow: