Fix dissolution date for CORP and COOP
- Dominant language
- JavaScript
- Stars
- 23
- Forks
- 62
- Avg merge
- 24m
- Merged PRs (30d)
- 1
Description
Update `dissolution_date` in `businesses` and `businesses_version` from dissolution filing `effective_date` if dissolution filing is `voluntary` and legal_type is not `SP` and `GP`
To find the data run these select query:
**As of today (2023-06-16) there are 31 rows (31 businesses) to be updated in PROD**
`SELECT b.dissolution_date, f.effective_date FROM public.businesses b inner join public.filings f on f.id = b.state_filing_id WHERE state='HISTORICAL' and legal_type not in ('SP', 'GP') and cast(dissolution_date as varchar(50)) like '%08:00:00+00' and f.filing_type='dissolution' and filing_json -> 'filing' -> 'dissolution' ->> 'dissolutionType' = 'voluntary'`
**As of today (2023-06-16) there are 34 rows (31 businesses) to be updated in PROD**
`SELECT b.dissolution_date, f.effective_date FROM public.businesses_version b inner join public.filings f on f.id = b.state_filing_id WHERE state='HISTORICAL' and legal_type not in ('SP', 'GP') and cast(dissolution_date as varchar(50)) like '%08:00:00+00' and f.filing_type='dissolution' and filing_json -> 'filing' -> 'dissolution' ->> 'dissolutionType' = 'voluntary'`
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by running the two supplied SELECT queries against the relevant PostgreSQL data and compare the affected businesses with their dissolution filings. Done means the qualifying CORP and COOP records in both businesses and businesses_version use the voluntary dissolution filing effective_date, with the reported row counts reconciled.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgres
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100