File link:
Purpose of the file: This file rovides 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 | ||||||||||
| 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.)