NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
===Duplicates in the Country Structure (mandatory)===__NOEDITSECTION__
Having duplicates on name (on the same level/node) in the country structure e.g. two villages called “Berg” in the one municipality creates a lot of problems when importing data and creating statistics. Note that the duplicates are not shown in the GUI [[Country structure duplicates|(query)]].
===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 therefor 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 here [[Unknown Device]]. Run the [[Unknown device Accident| query]] and highlight to the country that Accident type will be updated.
===Data quality queries - Duplicates===__NOEDITSECTION__