Analytics Request - 2023 ALF filings - Deadline April 17

[lmcclung]

Information / Data analysis required

• [x] BC Companies
• [x] Sole Prop / General Partnership
• [ ] Names
• [x] Personal Property Registry
• [x] Manufactured Homes
• [ ] ServiceBC Connect
• [ ] API
• [ ] Other
• If other please specify

Please describe what analysis is needed A clear and concise description of what you are looking for. I'm trying to understand how big of a marketshare ALF has in terms of filings done on our BCOL application in 2023

• do they just file Corporate registry transactions or also MHR/PPR?
• how many transactions (broken down by MRH / PPR / Corporations)
• how much money did we collect
• how much did we re-imburse to ALF

If it's really complicated to find all this information, even if can find out ow much we reimburse ALF, we can extrapolate from there. Here a snip of a report I found in an email chain which generated some of this info...

Deadline Please let us know when this data is required. Is this a priority? April 17th - but negotiable

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

Deliverable

• [ ] Excel Spread Sheet
• [ ] Digital Dashboard
• [ ] Simple reply to email -If by email: send to Linda, Sal, Dwayne G, Dani, John Lane

Additional context Add any other context about your request. Let me know if I need to send this over to Melanie and Michael Kagis

[gprimeau]

@mhohertzCITZ need assistance with your team on this request.

[mhohertzCITZ]

@gprimeau how can we help? What skills are needed? I can then choose the best fit person.

[gprimeau]

@mhohertzCITZ I'm thinking help with researching ALF filings etc . where are they located in our system. are they mainframe... will we need Mr. Kagis's team to help with this as well?

[mhohertzCITZ]

@gprimeau Michael's team does work with the mainframe folks so yes I would think so.

[TGrahamBC]

Created ITOPS-102342 to have Legacy BA's look into this

[lmcclung]

Darci Denis commented: Hi Linda, Here is the information you requested regarding ALF filings for COLIN. John pulled the information based on filing codes in the mainframe that are specifically for ALF. He’s pulled all of 2023 for you, as well as the current numbers for 2024. Please let us know if you have any questions, or if you need anything further. BCOL_ALFF_2023_2024 (83a98d7f-0014-46b2-9276-89b5a128664c).xlsx

[gprimeau]

@lmcclung thank you! I will grab the spread sheet and make it more understandable and have the ability to answer your above questions.

[gprimeau]

@lmcclung I have made adjustments to the above table to make it more selective in see totals. @TGrahamBC

BCOL_ALFF_2023_2024 .xlsx

[lmcclung]

Thanks Gen & Darci,

The original questions I had in the ticket #20791 were: • do they just file Corporate registry transactions or also MHR/PPR? – still needs confirmation • how many transactions (broken down by MRH / PPR / Corporations) – provided in spreadsheet • how much money did we collect – still needs clarification • how much did we re-imburse to ALF – still needs confirmation

I’m still unclear on the answers, so I have more questions… • The fee codes you listed below are for corporations so does that confirm ALF doesn’t do anything with MHR/PPR? • What’s the difference between the ALFF_AMT and the TOTAL_COLLECTED? Do they include the Registry filing fees? • Does either of these amounts include the ALFF fee that was reimbursed to them? • What is the ALFF amount that we reimbursed to them? • If it doesn’t include the ALF fee, then do we know how much the ALF fee is so that I can multiply it by the QTY. • What’s an ALF – Intro Filing? Does it correspond to a Registries filing?

Finally… can you give me the total money we brought for the same filings (paid by BCOL, Credit Card, Cash/Cheque, etc.). Break it down by month just like you have in your spreadsheet above.

Then hopefully I can determine market share.