ADOT database changes and the new 2017 ADOT Crash form
With the redesign of the ADOT crash form some fields were preserved, and others were removed or consolidated. During this process, new lookup values were added to ADOT’s database to standardize and accommodate for the changes to the form. ADOT will not be converting old data to match with the new format, some fields and or values could be blank. ADOT’s internal database lookup values DO NOT MATCH with the current crash form.
Since ADOT will not be converting old data, they need to keep all of the lookup values, new and old, in their database and in the lookup tables. In order to accommodate this, the internal lookups will not match up with the lookup numbers on the ADOT crash forms. Therefore, Crash Magic will need to use the internal database lookups given by ADOT.
2. Angle (front to side) (other than left turn)102. Angle (front to side) Same Direction103. Angle (front to side) Opposite Direction104. Angle (front to side) Right Angle105. Angle – Direction not specified
In these cases, we tried to match up the beginning of the text values so that they would be sorted alphabetically when viewing them during the setup of a filter or report. We also included the number value at the end of the text in order differentiate them. That way when a filter is created, you will see all the values that could be a possibility, and are able to include appropriate ones in the filter. This will be important if you are filtering on data that could cover several years where multiple values are used in the database (and you’ll want to include all of them).