Business Search: Add Good Standing in COLIN

[thorwolpert]

Business Search: Add Good Standing

BACKGROUND

Given The user is logged in
And has the appropriate payment methods enabled

Scenario: API returns Good Standing

When a search has been done on a business
Then the results has the Good Standing field set as either True or False for all modernized businesses and all COLIN BCA businesses not in the NWPTA agreement. For all other business types the field will not be present in the response.

Details

• Update COLIN API
• Update SOLR_FEEDER
• Update SEARCH-API
• Update SOLR
• Update IMPORTER (will need to calculate good standing for every record)
  • COLIN
  • LEAR
• Update UPDATER (augment test only -- should pickup change automatically)
• Ensure/update COLIN triggers are working on a 'good standing' change for all business types
• Create job/event that calculates good standing for LEAR (run daily)? Might not need - could be covered in importer changes verified covered by importer
• oracle corporation trigger update (last_ar_filed_dt, transition_dt) Work with David R
  • dev
  • test
  • prod
• sandbox deployment / verification
  • update OCP config to pull from integration db
  • update connection policy on integration db to allow OCP connection
  • update db in sandbox (hasn't got any migrations since 10 months ago)
  • deploy current legal-api image in sandbox (for db updates etc.)
  • run business search sandbox deploy/verify
• update api documentation

[forgeuxGH5]

do we need a design ticket for this?

[thorwolpert]

For the API and to meet MoForests needs, no.

For the UI, I think it would save a lot of grief to do that up front.

[kialj876]

So for the UI this would be adding a good standing indicator inside each row of the results right?

do we need a design ticket for this?

I think we do, yes

[thorwolpert]

Could we add to the API call sooner than later? It has a big impact on the MoFor workflow, so a large business value

[kialj876]

I think in order to do this well in the UI we will have to add it to the api response, which will mean adding it to the solr index, etc.

MoFor are wanting that information in the facets response right?

[thorwolpert]

Yep, I don't think it's a particularly small add, since it touches everything in the chain

[forgeuxGH5]

Ok - I'd need to get a design ticket in and prioritised

[steveburtch]

@janisrogers we want to release this COLIN API change (in good standing) next week but we will need some help to test it from someone who knows the business rules around good standing for BCA companies. Would you be able to help us with this or point us to who can? @kialj876 @patrickpeinanw @gunanagar

[kialj876]

Oracle trigger change in linked merged PR below