Changes

Data quality checks before upgrading to V6.0

233 bytes added, 22:19, 7 April 2015
no edit summary
===Accident - Unknown device (mandatory)===__NOEDITSECTION__
The field ''Unknown device'' is an old Yes/No field from Legacy. This field is very often conflicting or duplicate to the values in table ''accdeviceinfo'' and therefore it was decided to remove it from the database. The upgrade script will update the '''Type of Accident''' depending on the values of ''Unknown Device'', see the rules [[Unknown Device| here]]. Run the [[Unknown device Accident| query]] and highlight to the country that Accident type will be updated.
 
===Inactive items (mandatory)===__NOEDITSECTION__
The upgrade functionality should have set inactive items to active. [[Update isactive | Here]] you will find SQL that fix that.
You need to notify the country how many were changed.
===Data quality queries - Duplicates===__NOEDITSECTION__
6,632
edits