bcgov / entity

ServiceBC Registry Team working on Legal Entities
Apache License 2.0
23 stars 57 forks source link

Analytics Request - #21158

Open lmcclung opened 1 week ago

lmcclung commented 1 week ago

Information / Data analysis required

Please describe what analysis is needed A clear and concise description of what you are looking for. I am trying to determine the scope of the work involved in migrating all the entities that are still on COBRS mainframe to COLIN and Postgres. To help, I need to understand:

1) number of entities on COBRS, broken down by Entity type (ie. tramway, cemetary, FI, EP Coop, etc.) 2) number of filings (per entity or entity type) that would need to be migrated 3) confirmation on what filings are currently brought over from COBRS to CPRD on the weekly job David R runs

Deadline Please let us know when this data is required. Is this a priority? Item #1 by EOD May 8, if possible. The rest can follow, ideally by May 10.

Screenshots If applicable, add screenshots to help explain your request.

Deliverable

Additional context Add any other context about your request.

droberts27 commented 1 week ago

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

Businesses on the Mainframe and in CPRD |   |   |   -- | -- | -- | --   |   |   |   |   |   Business Type | Postgres | Count | Filings | Most Recent Filing | Comments   |   |   |   |   |   coop | yes | 2414 | 39320 | 2024-05-06 | "extend agm" and "change in rules resolution date" in weekly batch job xpro coop | no | 53 | 857 | 2024-03-27 | filings in weekly batch job   |   |   |   |   |   credit union | no | 144 | 300 | 2024-02-20 | filings in weekly batch job parish | no | 77 | 79 | 2023-12-11 | filings in weekly batch job private act | no | 404 | 991 | 2024-02-27 | filings in weekly batch job   |   |   |   |   |   Cemetary | no | 28 | 33 | 1993-03-04 |   Library Association | no | 109 | 188 | 2010-01-04 |   Pension Funded Society | no | 2 | 3 | 1985-08-08 |   Railway | no | 10 | 14 | 2006-12-27 |   Society Branch | no | 2 | 2 | 0001-01-01 |   Tramway | no | 11 | 12 | 1956-08-29 |   Trust | no | 166 | 338 | 1999-12-01 |  

droberts27 commented 1 week ago

co_req0416.xlsx

image.png
droberts27 commented 1 week ago

Please use the attachment above, not the table in the comment above it.

lmcclung commented 1 week ago

Thanks @droberts27 this is really helpful. Most recent filing date is very interesting.