LCFS - Fix Duplicate Draft FSE `charging_equipment` Records
- Dominant language
- Python
- Stars
- 7
- Forks
- 7
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 87
Description
**Describe the task**
Find duplicate draft records in versioned FSE `charging_equipment` data caused by the versioning bug, propose a fix strategy, align with the team lead on scope, then implement the patch.
**Purpose**
Duplicate draft records left in place risk data integrity issues and incorrect state transitions downstream. This task ensures they are identified and cleanly resolved.
**Acceptance Criteria**
- [ ] Query written to identify all affected `charging_equipment` draft records with duplicate versions
- [ ] Fix strategy documented and reviewed with team lead before any data is touched
- [ ] Patch implemented and verified after team lead sign-off on scope
**Additional context**
- Discovery only first — no records modified until strategy is approved
- Confirm the bug's active time window with whoever owns the versioning fix to scope the query
- Follow-up remediation card may be needed if data volume is large
Contributor guide
Assessment
This issue has not been assessed yet.