LCFS - Recalculate 2024 reports using updated compliance unit calculation

[airinggov]

Description:
Develop and execute a script to retroactively apply the updated compliance unit calculation methodology to all 2024 reports, including draft reports. The script must recalculate compliance unit values using the newly implemented decimal retention and rounding rules while ensuring that stored values remain consistent with the revised approach.

Wireframe:
N/A

Purpose and Benefit to User:

• Prevents discrepancies in compliance reporting due to calculation methodology changes.
• Aligns existing 2024 reports with the latest regulatory and system requirements.

Acceptance Criteria:

• A script is created to recalculate compliance unit values in all 2024 reports, fuel supply, export fuel and summary.
• The script includes both submitted, recommended and draft reports in its scope.
• Compliance units are recalculated using the new decimal retention and rounding rules.
• Recalculated values are stored correctly without altering the original report structure.
• The script logs execution details, including the number of records updated and any errors encountered.
• A dry run option is available to preview changes before execution.
• The script execution is tested in a non-production environment before deployment.

Development Checklist:

• Retrieve all 2024 reports from the database.
• Implement recalculation logic using the updated compliance unit rules.
• Ensure recalculated values replace old values in the appropriate fields.
• Validate that rounding is applied correctly in summary sections.
• Implement logging for tracking updates and debugging issues.
• Conduct a dry run to verify accuracy before executing changes in production.
• Perform QA testing to confirm correctness across various report types.
• Deploy the script and verify changes post-execution.

Notes:

• Coordinate with the compliance team to confirm recalculation accuracy.
• Ensure that running the script does not interfere with ongoing report submissions.
• Consider scheduling the script during off-peak hours to minimize system impact.