File link: PCF_InputFile_ef_rm_mapping
Purpose of the file: This file associates eco-invent keys and SP proxy keys to allocate an Environmental Footprint (EF).
| Site_Code | Site_Name | Material_Code | Sys_Material_Code | Material_Name | Activity_UUID_Product_UUID | SP_Proxy | Adj_coef | Activity_Year | pcf_transport | dqr_technology | dqr_time | dqr_geography | dqr_completness | dqr_reliability | Comment | |
| Sample Data | XCLDPL_8702 | PCF_EXCLUDED_PLANT | WP1_400/128661 | FATTY ACID BLEND TRC814 C8,C14 BU | 07. Fatty acid {ID&MY}| fatty acid production, from RBD palm kernel oil | Cut-off, U_CIRAIG from Erasm | 2022 | 3 | 3 | 3 | 3 | 3 | |||||
| Mandatory Field ? | Mandatory field; Must be filled | Not mandatory field.If the field is filled, the values should be string | Not mandatory field.If the field is filled, the values should be string | Mandatory field; Must be filled. All lines without numbers after the "/" will be considered as an error | Not mandatory field.If the field is filled, the values should be string | Not mandatory field. Combination of these two fields being empty results to not importing the line nor giving out an error | Not mandatory field.If the field is filled, the values should be float | Mandatory field; Must be filled | Not mandatory field. >=0 | Not mandatory field. Float 1 to 5 | Not mandatory field. Float 1 to 5 | Not mandatory field. Float 1 to 5 | Not mandatory field. Float 1 to 5 | Not mandatory field. Float 1 to 5 | Not mandatory field. | |
| Data type | Only String | Only String | Only String | Only String | string | string | string | float | Only String | Positive float (above 0) | float | float | float | float | float | String |
| Field Description | SAP Site Code | SAP Site Name | SAP Raw Material Code for the specific Raw Material | SAP system and SAP Raw Material Code for the specific Raw Material | SAP Raw Material Name | Concatenation of fields Activity_UUID and Product_UUID taken from Ecoinvent datasource that acts as a key for the mapped Raw Material | Proxy of Raw Material taken from SimaPro | Coefficient specifying the concentration for the specific Raw Material | Year for which PCF is calculated | Product Carbon Footprint of the raw material transportation. It is expressed as KG Carbon/KG Product. | 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. Subcategory Technology | 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. Subcategory Time | 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. Subcategory Geography | 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. Subcategory Completeness | 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. Subcategory Reliability | Comments inserted by the data owner related to the value inputed |
| Comment | ||||||||||||||||
Data Owner - Hubert Sizaret (the data owner will receive the error file by email and will be responsible for making any necessary manual corrections.)