bcgov / bcgov/entity

Fix dissolution date for CORP and COOP

Open
#16,776 0 comments 0 reactions 0 assignees View on GitHub
ENTITY - DO NOT USE Priority3
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.