Q2 2021

Wrap up of all releases and updates from April to June 2021 (Q2).

Commercial Locations

Bug Fix - 

• 49 uarn had duplicates. For the majority of the duplicates, we are able to revert back to the old record (so the ledger will be shown as an UPDATE), but for a handful of them (4 uarns), there will be a hard deletion in the snapshot and the action for the record in the ledger will be shown as a DELETE. The changes can be seen on the snapshot from 15/04/21 and ledger from 21/04/21. 
• In filed accounts, there were 39 early account records with incorrect start_date (i.e. shown as 0001-01-01). This has now been fixed and a process added to avoid future occurrences. This will be shown in the next Snapshot update for DoordaBiz on 02/05/21 and Ledger on 17/04/21.
• HSE fatality data added. From 02/05/21, you will be able to search for HSE cases that resulted in fatality by querying in DoordaHost: select * from doordabiz_snapshot.doordabiz_snapshot.risk_hse_case where description like '%fatality';
• The issue with duplicate entries being created by the Environment Agency has been resolved. We have added a new dataset named 'risk_eng_ea_enforcement', this replaces the previous 'risk_ea_enforcement'which has now been changed to a deprecated status. To apply the update make the following changes:
  • Replace the table 'risk_ea_enforcement' with 'risk_eng_ea_enforcement' 
  • Replace the endpoint 'https://api.doorda.com/biz/uk/ea_enforcement/{company_number}' with 'https://api.doorda.com/biz/eng/ea_enforcement/{company_number}' 

New Dataset - 

• Large Companies need to report on their payment practices, (i.e how long it takes to process invoices), this is now available in DoordaHost and our API linked on company number. To view the schema and access methods view 'addon_company_payment_practice'. 
• Furlough claimants, lists the companies making claims on the Governments furlough scheme as well as the claim band by month. More information available here. To view the schema and access methods click here

DoordaBiz

New Dataset - Furlough claimants, lists the companies making claims on the Governments furlough scheme as well as the claim band by month. More information available here. To view the schema and access methods click here