Data mapping analysis for Society Branch Incorporation Application Data
- 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 Society Branch Incorporation Application 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 COBRS-to-LEAR data mapping spreadsheet linked in the issue and compare its fields with the LEAR and COBRS database structures. Consult David Roberts for mapping or COBRS-specific questions. Done means identifying missing source data or LEAR support and creating follow-up tickets for the required extract, database, or code changes.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, postgres
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100