file link: PCF_InputFile_ef_supplier
Purpose of the file: This file includes comprehensive data on emission factors associated with suppliers and their products, encompassing both Product Carbon Footprint (PCF) and biogenic emissions.
| gbu | Rawmaterial_code | Rawmaterial_name | Supplier_code | Supplier_name | Plant_code | Plant_name | PCF_supplier | BCC_supplier | TCC_supplier | RCC_supplier | CCU_CC_supplier | PCF_transport_supplier | PDS_supplier | DQR_supplier | Adj_coeff_supplier | Activity_Year | |
| Sample Data | CS | WP1_400/118919 | 2-ETHYL HEXYL ACRYLATE BULK | 106496 | BASF CORP | 1402 | CLAMECY | 2.31 | 3 | 2021 | |||||||
| 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. 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. | Mandatory field |
| Data Type | string | string | string | string | string | string | string | Float greater than 20 and lower than - 20 should 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 |
| Field Description | 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 | 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 | Year for which PCF is calculated |
| 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.)