bcgov / bcgov/entity

Data mapping analysis for Financial Institution Change of Name

Open
#25,693 0 comments 0 reactions 0 assignees View on GitHub
COBRS
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 structures in the LEAR db and where COBRS Financial Institution Change of Name data belongs in LEAR and how to transform the data.

- [ ] Determine if COBRS db extracts all relevant data for filing that need to make it into LEAR db. Reference [data mapping\(COBRS  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 COBRS specific questions.
- [ ] Determine if LEAR db supports all the data from COBRS db extract
- [ ] Cut tickets as required based off of analysis done in this ticket.
Potential tickets may include:
* Update COBRS db extract script to pull missing data
* Update LEAR db and/or code to support data being pulled over from COBRS db extract

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the linked COBRS-to-LEAR data mapping spreadsheet and compare its filing fields with the COBRS extract and LEAR database structures. Confirm which data is available and supported, document gaps, and create follow-up tickets for missing extracts or LEAR changes; consult David Roberts where the mapping or COBRS behavior is unclear.

Written by the indexing model from the issue text.

Assessment

Domain
data-engineering, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.