bcgov / bcgov/entity

Data fixes: Set AR reminder to false for migrated corps

Open
#30,923 0 comments 0 reactions 0 assignees View on GitHub
blocked Entities - Data Migration Needs Decision
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.