Investigate: CP0001947 - Coop migration

[TVWerdal]

We need to investigate what would be involved in bringing a recently restored mainframe based coop from CPRD to BCROS.

Original ticket here: https://sbc-registries.atlassian.net/jira/servicedesk/projects/ITOPS/queues/custom/33/ITOPS-266131

[argush3]

@TVWerdal @MKagis @vikas-gov @davemck513 @ozamani9gh
Have reviewed migrating via jupyter notebook and tombstone flow.

Notebook route - don't recommend it as it seems like it hasn't been used in a long time so hard to say if it will work. As well, CP0001947 has a bunch of conversion filings modernized may not be able to handle via filer.

Tombstone flow - did a few tweaks to COLIN subset extract script and the tombstone flow to quickly test if it was possible to migrate COOP to dev/test environments. It seems like it is possible but there were some data issues. More details below. For the time being, inclined to think this is the lowest effort way to get CP0001947 migrated to modernized system.

General notes about migrating CP0001947 to modernized system:

• Migrated CP0001947 successfully to dev/test
  • https://dev.business-dashboard.bcregistry.gov.bc.ca/CP0001947?accountid=2596
  • https://test.business-dashboard.bcregistry.gov.bc.ca/CP0001947?accountid=1009
• Unable to file AR due to following missing data issues
  • office mailing address is null
  • ceased directors all have missing mailing & delivery addresses
• Coop type is not something that COLIN modeled so this value is not populated when CP0001947 was migrated to dev/test.
• The business summary will have a warning at top as historical data has not been backfilled.
• Have tested following filings successfully in Dev for CP0001947 after fixing office and ceased officer data
  • ARs
  • special resolution
  • change of director
  • change of address

Outstanding questions

• What do we want to do about missing address data for registered office and ceased directors. These address issues are stopping AR filing. Do we want to data fix in COLIN before migrating or fix after migration to modern?
• Do we need coop type populated during migration process? Coop seems to function properly until a special resolution filing is done. Validation flags the coop type at this point as being null.
• The business summary will have a warning at top as historical data has not been backfilled. If the business summary looks ok, we can mark it as being backfilled so the warning is not present.
• Certified stamp positioning is off and hides existing info for change of address and change of director filing
• special resolution filing is still using old certified stamp...not sure if this is an issue
• Without data fixes, https://test.business-dashboard.bcregistry.gov.bc.ca/CP0001947?accountid=1009) is what CP0001947 would look like if we migrated to Prod right now. Aside from the missing address data issues, missing coop type and certified stamp issues that we already know about, are we missing anything? Any other missing data or expected ledger entries? Are there any expected legacy outputs that are required?