Sandbox affiliations data for Ministry of Transportation

[JohnamLane]

The ministry of transportation requires some known account affiliations from the sandbox.

They require 15 BCROS account #s that are known to have firm affiliations.

They just need the BCROS account # and the FM# so they can use the BCeID flow for their testing.

[daniwilliamson]

Related ticket: https://app.zenhub.com/workspaces/raid--work-space-617c3d4cef313f001d715a7c/issues/gh/bcgov-registries/raid/223

[magszymanski]

Hi - needing to urgently respond to the client about this data. Can you please let Dani and I know the day it will be available so that we can respond? Thank you :) CC: @daniwilliamson

[JohnamLane]

@magszymanski We have fetched the test data but now IDIM is having an issue in their test environment. I will contact the client once this is fixed. I will send an update to them if it's not fixed tomorrow.

[magszymanski]

Can I please confirm that someone had reached out to the client with the test data as this tix is closed? Thanks! @Jxio @JohnamLane @daniwilliamson

[JohnamLane]

@magszymanski we will close the loop on this. Test data has been shared, but the IDIM test environment is failing now. I will reach out to client when it's all ready to go

[Jxio]

query:

SELECT DISTINCT a.org_id AS "Account Number", e.business_identifier AS "Firm Id" 
    FROM affiliations a LEFT JOIN entities e ON a.entity_id = e.id
    WHERE corp_type_code IN ('SP', 'GP') LIMIT 15;

[JohnamLane]

@Jxio This ops ticket is back unfortunately. The list that you pulled appears to be from the Test environment. They need to be pulled from Prod for AUTH (as sandbox relies on Prod AUTH) and the sandbox for legal info. Not sure how easy this would be or if you have the required access, but let's discuss tomorrow.

[Jxio]

a new dataset generated and sent to John.