File link:
1. Purpose of the file:
This file is exported from the Fact PCF table and must be completed by the Process Owner to validate computed Product Carbon Footprint (PCF) values for finished products.
For each finished product / plant / production year combination, the file pre-populates system-generated fields (PCF value, BOM balance, source, metadata dates, run ID) and exposes two fields for the Process Owner to fill in: validation_input (YES or NO) and comment.
The validated data is re-imported into the PCF tool to confirm or flag PCF values as valid, rejected, or under review. Previous validation history is also included (last_validated_value, last_pcf_final, pcf_ID, last_validated_comment, validation_insert_date) to provide context for the review.
2. File Structure
2.1. List of tabs
| Sheet Name | Description | Mandatory | Comment |
PCF_Validation | Main data sheet. Pre-populated with system data; Process Owner fills in validation_input and comment only. | YES | Don't delete this sheet |
2.2. Main columns description
SHEET: PCF_Validation
| FIELD | gbu | site_code | site_name | plant_code | plant_name | material_code | material_name | prod_year | product_type | bom_balance | rm_mapped_pc | pcf_final | source_pcf_fp | fact_pcf_is_valid | fact_pcf_meta_insert_date | fact_pcf_meta_run_id | fact_pcf_updated_date | validation_input | comment | last_validated_value | last_pcf_final | pcf_ID | last_validated_comment | validation_insert_date | validation_insert_date 2 |
| DESCRIPTION | SAP code of the Global Business Unit. | Unique CERISE code of the site where the finished product is produced. | Name of the site as identified in CERISE. | Unique SAP code of the plant where the finished product is produced. | SAP name of the plant. | Unique SAP code assigned to the finished product. | SAP name of the finished product. | Calendar year for which the PCF is computed. | Indicates whether the product is SIMPLE (only the finished product is produced) or COMPLEX (the BOM recipe contains materials produced simultaneously with the finished product). | Proportion of raw material quantities compared to the finished product quantity. | Proportion of raw materials in the BOM recipe for which an emission factor is available. | Global PCF (kgCO₂e/kg) for the finished product as computed by the PCF tool. | Source of the PCF data. | System indicator confirming the data is the most recent, valid, and relevant record. | Timestamp indicating when the PCF data was first calculated and inserted. | Unique identifier assigned to the specific PCF calculation run. | Timestamp indicating when the PCF data was most recently updated. | Evaluation of the PCF value by the Process Owner. Must be filled in for each row. | Free-text notes added by the Process Owner to explain or justify the validation decision (e.g. reason for rejection, data anomalies). | The validation decision recorded during the most recent previous validation cycle. | The PCF value that was validated in the most recent previous validation cycle. | Unique identifier of the PCF record that was validated in the previous cycle. | The comment recorded during the most recent previous validation cycle. | Timestamp of the most recent validation submission for this record. | Timestamp of the second most recent validation submission for this record (historical). |
| DATA TYPE | String | String | String | String | String | String | String | String | String | Float | Float | Float | String | String | Timestamp | String | Timestamp | String | String | String | Float | String | String | Timestamp | Timestamp |
| MANDATORY | YES | YES | NO | YES | NO | YES | NO | YES | NO | YES | YES | NO | YES | YES | YES | YES | YES | YES | NO | NO | NO | NO | NO | NO | NO |
| VALIDATION / ALLOWED VALUES | e.g. CS, SP, TS, PA, OG, CM. Validated against known GBU list. | e.g. 1386, 1341 | Free text | e.g. 0241, 7851 | Free text | e.g. WP2_400/45571 | Free text | e.g. 2024, 2025 | SIMPLE | COMPLEX | Float ≥ 0 | Float between 0 and 1 | Float ≥ 0 | Computed FP pcf or "Manual FP pcf" | YES | NO | Format: YYYY-MM-DD HH:MM:SS | System-generated alphanumeric ID | Format: YYYY-MM-DD HH:MM:SS | YES or NO only | Free text | YES | NO (from prior cycle) | Float ≥ 0 | System-generated hash string | Free text (from prior cycle) | Format: YYYY-MM-DD HH:MM:SS | Format: YYYY-MM-DD HH:MM:SS |
| TYPE | System | System | System | System | System | System | System | System | System | System | System | System | System | System | System | System | System | Process Owner | Process Owner | System | System | System | System | System | System |
3. Filling instructions
| Sheet Name | Instructions |
| Sheet1 | • This file is pre-populated with system-generated data exported from the Fact PCF table. Do NOT modify any system-generated columns (all columns except validation_input and comment). • The only two fields to be filled in by the Process Owner are: • Rows where validation_input is left blank will not be processed. • Do not add or remove rows or columns. • Previous validation history columns (last_validated_value, last_pcf_final, pcf_ID, last_validated_comment, validation_insert_date) are provided for reference only – do not modify them. • Duplicate rows will be rejected during data upload. Ensure no duplicate entries are present.. |
4. Maintenance best practices
Please comply with the following instructions to maintain the file:
• Always keep the original structure (do not add/remove columns without approval).
• Update only the necessary fields.
• Save a backup copy before any major changes.
• Respect data confidentiality.
5. Contact Points
| File owner | Hubert Sizaret |
| Technical Support | Camille Faure Laëtitia Arantes |
The data owner will receive the error file by email and will be responsible for making any necessary manual corrections.
For any questions or issues, please contact the responsible person listed above.
Please strictly follow these guidelines to ensure data quality and reliability.