Data source:
Data source mapping and lineage, DPL creation: 03 Data Knowledge PCF - Sustainability IT11672
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 material_code not equal to "" |
Flat File management
- Flat Files Links to Input Data for PCF
- Flat File management documentation ⇐ DOCUMENTATION !
PCF_InputFile_ Specifications (data quality check of input files)How-to update Ecoinvent - How to get and extract the useful dataset from Ecoinvent files
Data Preparation:
- Fact_BOM and FACT_bom_spp
- BOM Intermediate PF1
- Table FACT_CALC_bom New CALC BOM WP1
- WRK_imep_site_net_output
- Tables: WRK_finished_product_std_qty, DIM_plant_site, DIM_conversion_unit
- PF1 Intermediates BOM/IMEP: BOM Intermediate PF1 x CALC BOM intermediate PF1
Validation process
PA-933 Implement PCF validation flow
Historization & Flat files mgt including Ecoinvent
- PCF Historization rules
- Functional historisation: Rules definition and implementation related to the functional process (from inputs - Flat Files)
Scope 3.1 Raw Materials:
- Suppliers / Ecoinvent Emission Factor : PA-261 | Calculation EF at Raw Material Level
- CO2 Contribution calculations: FACT_CALC_scope_3_1_3_4_upstream_estimated
- Quality KPI : PA-353 RM_Mapped_pc
NEW Quality KPI (BOM_balance):
→ For Novecare: PA-1808 | Compute BOM Balance WP1
→ For Specialty Polymers: PA-1812 | Compute BOM Balance PF1
→ Add bom balance KPI in PCF and Biogenic validation flat files: PA-1940 | Add Bom_Balance KPI in PCF and Biogenic validation flat files
Scope 3.4 upstream Transport
- Integrate scope 3.4 upstream transport in scope 3.1 data flow PCF Scope Corrections
Scope 1, 2 and 3.3 Energy:
- CO2 Contribution calculations:WRK_scope_1_2_3_3_wp1_estimated
Energy type, activity code and vector mapping WP1
- Apply Energy quantity corrections on BOM PCF Scope Corrections
- PF1 SPP Allocation Allocate energy CO2 contribution to Intermediate Products:
Scope 3.4 internal transportation:
- CO2 Contribution calculations: PA-172 Scope 3.4 intermediates on standard routes
- Quality KPIs: PA 418 - KPI Missing route FP and Missing Intermediate at FP Level
- SPP calculations FACT_CALC_transportation_scope_3_4_interm_estimated_spp
Scope 3.5 Waste and Scope 1 GHG :
- CO2 Contribution calculations: FACT_CALC_scope_3_5_1ghg_wp1_estimated
- Site net production Qty IMEP_site_net_output
- Wastes Emission Factors at site level PCF Scope Corrections
- SPP Waste: FACT_CALC_scope_3_5_1ghg_pf1_estimated_spp
Biogenic:
- PA-298 Biogenic Carbon Content
- Flat file from R&I Novecare for Biogenic data of Raw Materials: Biogenic_content - PCF check tab Priority List - top products
- PCF Biogenic Talend generation file
- NEW Quality KPI (TCC_rm_mapped):
→ For Novecare: PA-1826 | Compute raw materials mapping on TCC for Novecare WP1
→ For Speciality Polymers: PA-1834 | Compute raw materials mapping on TCC for SpP PF1 - NEW Ingest manual biogenic: PA-1835 | Ingest manual calculated biogenic KPIs
Fact_Pcf:
- PCF calculation : Fact_pcf FACT_pcf AGGREGATION SPECIFICATION_WP1 & PF1
- Prod com aggregation : Prod com PCF and Biogenic
- PDS / DQR PA 467 - PDS and DQR
- Product type SIMPLE / COMPLEX / local / multiple output Table : Product_Type_Simple
- Table : Product_Type_Simple _SPP
NEW Ingest manual PCF: PA-1926 | Ingest manual calculated PCF KPIs
Small enhancements:
- Align meta_run_id and updated date in final result table: PA-1779 | Align meta_run_id and updated_date in FACT_pcf table current history
- Set commercial products aggregations to null: PA-1781 | Set to NULL the commercial product aggregated KPIs
Data Quality
DPL specifications
Link for all functional docs links
Foster your navigation:
Flat Files Links to Input Data for PCF
FOR PROD. ENV. export to GCP_PROD
Advanced_GBU_Access_rights_PROD_
PCF_InputFile_Master_Unit_conversion_PROD_
GEO_GCP (Geographical classification master table)
AO_GCP (Activities overview from the Database Overview xls file)
LCIA_GCP (Emissions factors by activity)
PCF_InputFile_ef_rm_mapping_PROD_
PCF_InputFile_ef_supplier_PROD_
PCF_InputFile_ef_wastes_sites_PROD_
PCF_InputFile_ef_transp_routes_PROD_
PCF_InputFile_Energy_contribution_correction_PROD_
PCF_InputFile_energy_mapping_PROD_
PCF_InputFile_biogenic_masterdata_CS_PROD_
PCF_InputFile_biogenic_masterdata_SPP_PROD_
NEW PCF_InputFile_manual_biogenic_PROD_
PCF_InputFile_validation_pcf_PROD_
PCF_InputFile_validation_biogenic_PROD_
Connected files for supervision
PCF validation status overview
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 number | Scope name |
|---|---|
| Scope 1 | Direct energy emission (Electricity, Steam, Gas, Fuel) |
| Scope 2 | Indirect energy emission (link to energy production) |
Scope 3.1 | Raw materials |
| Scope 3.3 | Energy emission upstream (Ressources before the energy production, for exemple carbon footprint produce by the truck to get uranium) |
| Scope 3.4 intern | Transportation of intermediate |
| Scope 3.4 upstream | Transportation of Raw Materials from our suppliers site to our plants |
| Scope 3.5 | Waste produce during the End to End production of the finish product |
| Scope 1 other GHG | Other Green house Gas |