Data fixes: Set AR reminder to false for migrated corps
- Dominant language
- JavaScript
- Stars
- 23
- Forks
- 62
- Avg merge
- 24m
- Merged PRs (30d)
- 1
Description
**Note: need approval to do this from business + home team before we can proceed with this work**
Corps already migrated as a part of EA and Group 1 batches where the AR reminder flag is true are still receiving AR reminder emails even if the corp has been frozen.
We will need to apply a data fix to ensure that all AR reminder flags for these businesses are set to false.
Future migrations will handle this scenario via #30922
**Tasks**
- [ ] Write COLIN update sql script to update all migrated corps to have AR reminder flag of false
- [ ] Run script in prod after testing in dev/test
- [ ] Create appropriate migration tracking entries to serve as audit record that AR reminder flag was set to false in COLIN
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by locating the COLIN update SQL conventions and migration-tracking entry points, then identify migrated EA and Group 1 corps whose AR reminder flag is true. Test the data fix in dev/test before production execution; done means all qualifying flags are false and audit entries exist.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgres, sql
- Domain
- data, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100