Purpose of the file: This file provides manual PCF KPIs calculated by experts for some finished products.
| GBU | Finish_Product_Code | Finish_Product_Name | Plant_Code | Plant_Name | Activity_Year | PCF_finish_product | PDS_finish_product | DQR_finish_product | Comment | |
| Sample Data | CS | WP1_400/101479 | JAGUAR C 500 25 KG PAPER BAG (55.115 LB) | 0267 | 7424 Vernon | 2022 | 0.7846282543 | 1 | 0.8785866762 | Manual data from expert |
| Mandatory? | Mandatory field; Must be filled. Validation if the GBU exists. | Mandatory field; Must be filled in | Mandatory field; Must be filled in | Mandatory field; Must be filled in | Mandatory field; Must be filled in | Mandatory field; Must be filled in | Mandatory field; Must be filled in | 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 1 and 3 | Not mandatory field. |
| Data type | string | string | string | string | string | string | float >= 0 | float between 0 and 1 | float between 1 and 3 | string |
| Field Description | SAP code of the Global Business Unit (CS for Novecare, SP for Speciality Polymers, TS for Technology Solutions, etc.) | Unique code assigned to the finished product for identification in SAP | Name of the finished product in SAP | Unique code assigned (for identification in SAP) to the plant where the material is produced | Name of the plant where the material is produced | Year for which the PCF is manually imported | Global PCF (carbon footprint) for the finished product manually entered by the data owner | Primary Data Share = proportion of PCF data that is collected directly from suppliers, as opposed to secondary data which is derived from generic databases such as EcoInvent | 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 | Notes added by the data owner to highlight or explain the data inserted |
| Comment | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | An error message should be sent to the Data Owner. | A warning message should be sent to the Data Owner. | A warning message should be sent to the Data Owner. |
Data Owner - Hubert Sizaret and Damien Bourcier (the data owner will receive the error file by email and will be responsible for making any necessary manual corrections.)