bcgov / bcgov/entity

ULC/CCC/BC pipeline - update to support Change of Address

Open
#23,130 0 comments 0 reactions 0 assignees View on GitHub
Entities - Data Migration
Dominant language
JavaScript
Stars
23
Forks
62
Avg merge
24m
Merged PRs (30d)
1

Description

This ticket is to update the pipeline to support Change of Address.

This will include:
* Updating raw sql queries to pull in required data from COLIN db extract
* Updating code to generating filing json for given filing
* Update custom filer code to process generated filing json
* Testing pipeline against a decent sample size to see what errors come up

When updating the pipeline to support a given filing, the initial testing will be done locally against a COLIN db extract. We can test with a smaller but significant sample size of fillings to have a certain level of confidence that the pipeline is working in general for a given filing.

In our overall migration testing, all migration of prod COLIN corp data will be tested. Under this comprehensive testing, various data issues and edge cases will be discovered for various filings. We will cut tickets at this time to address the issues that come up.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the pipeline's raw SQL queries, filing JSON generation, and custom filer processing code. Run the pipeline locally against a COLIN database extract and a smaller representative sample. Done means Change of Address filings are processed successfully and testing reveals no general pipeline errors.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgres, python
Domain
backend, data-engineering, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.