BC Reg X Test Scenarios - Jurisdiction

[ianco]

Add unit tests for the following scenarios (from Melissa):

Here are some samples. Note, while you’ve asked for data from TEST I thought you were pointed to our UAT environment. I’ve provided examples from both to be safe.

TEST:
A0070693 - CATHERINE R. MCCREARY PROFESSIONAL CORPORATION – Home Jurisdiction Alberta (can_jur_typ_cd ‘AB’)
A0080150 – LORDON HOLDINGS INC. – Home Jurisdiction Delaware (can_jur_typ_cd = ‘OT’ and othr_juris_desc = ‘US, DE’)
A0059933 – AMEC PROJECT INVESTMENTS LIMITED – Home Jurisdiction United Kingdom (can_jur_typ_cd = ‘OT’ and othr_juris_desc = ‘GB’)
A0060938 – BERENS ENERGY LTD. – Home Jurisdiction Not on File (can_jur_typ_cd ‘OT’ and othr_juris_desc = null).
LLC0000389 – TEST LLC – Home Jurisdiction Switzerland (can_jur_typ_cd = ‘OT’ and othr_juris_desc = ‘CH’)

UAT:
A0059733 - LAWTON PARTNERS FINANCIAL PLANNING SERVICES LIMITED – Home Jurisdiction Manitoba (can_jur_typ_cd = ‘MB’)
A0040189 - STEELER, INC. – Home Jurisdiction Washington (can_jur_typ_cd = ‘OT’ and othr_juris_desc = ‘US, WA’)
A0059933 – AMEC PROJECT INVESTMENTS LIMITED – Home Jurisdiction United Kingdom (can_jur_typ_cd = ‘OT’ and othr_juris_desc = ‘GB’)
A0060938 – BERENS ENERGY LTD. – Home Jurisdiction Not on File (can_jur_typ_cd ‘OT’ and othr_juris_desc = null).
A0060045 – SUGARLAB CORP. – Home Jurisdiction Federal (can_jur_typ_cd ‘FD’).

*In each case the home jurisdiction is as listed above. The ‘registered jurisdiction’ would be BC as the extraprovincial record is from BC.

[ianco]

Adding unit tests for:

select * from bc_registries.corporation
where corp_num in
('A0059733','A0040189','A0059933','A0060938','A0060045');

[ianco]

"registered jurisdiction" is empty for BC corporations