search

bcgov / entity

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

data issue: 68 firms with missing business number #14006

Open argush3 opened 1 year ago

argush3 commented 1 year ago

Orgbook folks ran an audit between LEAR db and Orgbook db and found that 68 SP/GPs with a missing business number.

Firms with this issue:

'FM0658778', 'FM0695565', 'FM0721556', 'FM0722328', 'FM0688779', 'FM0862064', 'FM0851393', 'FM0862084', 'FM0851732', 'FM0852438', 'FM0852439', 'FM0852992', 'FM0755491', 'FM0759489', 'FM0856046', 'FM0828603', 'FM0828611', 'FM0828589', 'FM0828595', 'FM0828617', 'FM0828592', 'FM0828615', 'FM0828521', 'FM0828609', 'FM0828604', 'FM0828522', 'FM0828605', 'FM0828613', 'FM0828616', 'FM0828622', 'FM0828624', 'FM0830644', 'FM0831071', 'FM0831067', 'FM0831635', 'FM0843827', 'FM0844095', 'FM0843829', 'FM0812602', 'FM0847694', 'FM0848433', 'FM0420032', 'FM0529160', 'FM0530188', 'FM0545939', 'FM0548000', 'FM0642988', 'FM0848487', 'FM0875038', 'FM0877321', 'FM0882138', 'FM0883731', 'FM0884483', 'FM0883938', 'FM0888958', 'FM0888939', 'FM0890595', 'FM0890866', 'FM0890601', 'FM0890871', 'FM0890690', 'FM0890215', 'FM0890775', 'FM0890216', 'FM0890604', 'FM0890969', 'FM0571090', 'FM0716414'

argush3 commented 1 year ago

@droberts27 I've reloaded these firms into Prod with the latest extract and I've spot checked quite a few firms. The business number looks good for almost all of the firms I checked except for one.

Example of a firm that still has a business number mis-match:

Business Number mis-match for: FM0571090 BC Reg: "843207705", OrgBook: "706669488"

The business.tax_id field in LEAR db is populated with the BN15 but it looks like OrgBook is expected the BN9 value that was provided by COLIN.