bcgov / bcgov/entity

ULC/CCC/BC pipeline - data mapping analysis for Limited Restoration to Full

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

Description

This ticket is used to analyze whether we have the required tables and data in the COLIN db extract(postgres) and LEAR db to start updating the corps data pipeline to bring over Limited Restoration to Full for corps.

- [ ] Determine if COLIN db extracts all relevant data for filing that need to make it into LEAR db. Reference [data mapping\(COLIN  LEAR\) doc](https://docs.google.com/spreadsheets/d/1kTumSX59lp72kD6GdYLufn3nXAD1PA4E/edit?gid=1604073602#gid=1604073602) as starting point. May need to talk with David Roberts if there are questions about data mapping doc or COLIN specific questions.
- [ ] Determine if LEAR db supports all the data from COLIN db extract
- [ ] Cut tickets as required based off of analysis done in this ticket.
Potential tickets may include:
* Update COLIN db extract script to pull missing data
* Update LEAR db and/or code to support data being pulled over from COLIN db extract

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the COLIN db extract, the LEAR db, and the linked COLIN-to-LEAR data-mapping document. Compare the filing data needed for Limited Restoration to Full, consult David Roberts for mapping or COLIN questions, and treat the work as done when the support gaps are identified and any required follow-up tickets are created.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgres
Domain
data-engineering, databases
Issue type
Feature
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.