LCFS - Fix Compliance Report History for Rejected Records

[AlexZorkin]

Description
The ETL process failed to capture the correct history status values for rejected compliance reports. Update the ETL or post-processing logic to align these values with the original data, ensuring accurate historical tracking.

Task

• Investigate the current ETL process to identify why history status values for rejected reports are incorrect.
• Update the logic to properly capture and record the original status values for rejected compliance reports.
• Validate the updated history records against original source data.

Acceptance Criteria

• History status values for rejected compliance reports accurately match the original data.
• Updated ETL or post-processing logic captures and records the correct status values.

This ticket ensures that compliance report history accurately reflects the original data for rejected reports, enhancing data integrity and auditability.