bcgov / bcgov/entity

Load in multiple conversion filings and filings with effective dates prior to conversion filing

Open
#7,359 3 comments 0 reactions 0 assignees View on GitHub
ENTITY - DO NOT USE timeboxed
Dominant language
JavaScript
Stars
23
Forks
62
Avg merge
24m
Merged PRs (30d)
1

Description

## Background
This is a continuation of ticket #4711.
There are 108,949 active BC companies incorporated before March 26, 2004.
102,228 of these corporations have more than 1 filing with filing type CONVL.

## Description
This ticket has two parts:
- [ ] apply multiple conversion ledgers to postgres
- [ ] apply any other filings that have an EVENT_TIMESTMP in oracle prior to the conversion ledger EVENT_TIMESTMP

### There can be multiple conversion ledger filings. We need to bring over and apply them.:

CONVICORP - Incoporation Application pre COLIN
CONVLRSTR - about 450 entities that were in a limited restoration pre-COLIN
CONVDSO - company was dissolved pre-COLIN but was subsequently restore in COLIN
CONVREGST - the equivalent of an incorporation application for extraprovincial companies (not relevant to BC Limited Corporations so not necessary for our current migrations, but will be necessary when we tackle extraprovincial migrations.

#### Some really old entities have filings like Annual Reports that have effective dates prior to March 26, 2004 (conversion ledger). How do we apply the conversion filings first and then the older filings? The scope of this ticket includes finding & implementing a solution for this question.

https://chat.developer.gov.bc.ca/direct/argus_chiu#&gid=1&pid=4

Let's timebox to 2 days, and discuss progress and plan forward

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.