Purpose of the file: This file is used to collect and centralise Product Carbon Footprint (PCF) data provided by external suppliers for specific raw materials procured by Syensqo. It records validated supplier PCF values and their carbon breakdowns (fossil, biogenic, land use, aircraft), together with supplementary indicators such as carbon content (BCC, TCC, RCC, CCU), transport PCF, primary data share, and data quality rating.
The data supports environmental reporting, sustainability assessments, and internal PCF calculations at the material/plant level.
2. File Structure
2.1. List of tabs
| Sheet Name | Description | Mandatory | Comment |
Sheet1 | Main data entry sheet. Contains validated supplier PCF values per raw material, supplier, and plant combination. | YES | Don't delete this sheet |
2.2. Main columns description
SHEET: Sheet1_TFS
| prod_year | gbu | material_code | material_name | Supplier_code | Supplier_name | Plant_code | Plant_name | PCF_supplier | PCF_supplier_fossil | PCF_supplier_biogenic | PCF_supplier_landuse | PCF_supplier_aircraft | BCC_supplier | TCC_supplier | RCC_supplier | CCU_CC_supplier | PCF_transport_supplier | PDS_supplier | DQR_supplier | Adj_coeff_supplier | Comment | Qualification_Status | Collection_Date | Qualification_Date | Qualificator | |
| Sample Data | 2021 | CS | WP1_400/118919 | 2-ETHYL HEXYL ACRYLATE BULK | 106496 | BASF CORP | 1402 | CLAMECY | 2.31 | 1.98 | 0.23 | 0.6 | 0.5 | 3 | ||||||||||||
| Mandatory Field ? | Mandatory field | Mandatory field; Must be filled. Validation if the GBU exists. | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; | Not mandatory field | Not mandatory field | Not mandatory field | Not mandatory field | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 20 | Not mandatory field | Not mandatory field.If the field is filled, the values should be between 1 and 3 | Not mandatory field. | Not mandatory field. | Not mandatory field. | Not mandatory field. | Not mandatory field. | Not mandatory field. |
| Data Type | string | string | string | string | string | string | string | string | Float greater than 20 and lower than - 20 should not be uploaded | float between 0 and 1 | float between 0 and 1 | float between 0 and 1 | float between 0 and 1 | float between 0 and 20 | float between 0 and 1 | float between 1 and 3 | float | String | 3 options: Validated (default, if empty) Pending Rejected | Date | Date | String | ||||
| Field Description | Year for which PCF is calculated | SAP code of the GBU (Global Business Unit); It can take the values "CS" for Novecare, "SP" for Specialty Polymers | SAP Raw Material Code | SAP Raw Material Name | SAP Supplier Code from BW SPRINT | SAP Supplier Name from BW SPRINT | SAP Plant Code | SAP Plant Name | Validated PCF from the supplier for the specific Raw Material | Validated fossil part of the PCF provided by the supplier for the specific raw material | Validated biogenic part of the PCF provided by the supplier for the specific raw material | Validated landuse part of the PCF provided by the supplier for the specific raw material | Validated aircraft part of the PCF provided by the supplier for the specific raw material | Biogenic Carbon Content: amount of carbon in the finished product that is derived from renewable biological sources, measured in kgC per kg of product coming from the supplier | Total Carbon Content = amount of carbon present in one kilogram of a product, measured in kgC / kg of material. This is shared by the supplier | Recycled Carbon Content = amount of carbon recycled present in one kilogram of a product, measured in kgC / kg of material. This is shared by the supplier | Carbon Capture Utilisation = a range of applications through which CO2 is captured and used either directly (i.e. not chemically altered) or indirectly (i.e. transformed) into various products. | Validated PCF for upstream transportation from the supplier to Syensqo for the specific Raw Material | Primary Data Share = proportion of PCF data that is collected directly from suppliers | Data Quality Rating = measure of the data quality of the emissions in the footprint, number of 1-3, with 1 being the best possible score | Coefficient specifying the concentration for the specific Raw Material | Qualification status of pcf collected from Supplier Helps historisation of pcf collection and qualification | Date of collection of pcf from Supplier Helps historisation of pcf collection and qualification | Date of qualification within Syensqo of pcf collected from Supplier Helps historisation of pcf collection and qualification | Person within Syensqo responsible of qualification of pcf collected from Supplier Helps historisation of pcf collection and qualification | |
| Comments |
Data Owner - Hubert Sizaret (the data owner will receive the error file by email and will be responsible for making any necessary manual corrections.)