Reso 2006-970 - Laserfiche WebLink

Home Browse Search

City of Sunny Isles Beach New World to PtWin Data Migration/Cleanup Issues During the analysis of the New World data, prior to beginning of data migration, it was discovered that many data integrity and reliability issues existed in the current system. Further analysis indicated that they were caused by the following: . Data mapping errors during the initial conversion from the previous system to New World . Data entry errors during the initial conversion . Failure to close active permits when a job or project is completed . Contractor registration information errors and inconsistency . Programming errors during the initial conversion resulting in duplicate and triplicate records introduced into the New World database. . The change and adoption of new and different permit fees without entering them in the New World fees table . Current data entry errors e.g. The years 2007, 2008 etc. in date fields . The lack of a Street Dictionary file and a Street Alias file to allow the proper editing and importation of land parcel files from MiamilDade County. Without additional programming effort the migration of the New World data in its current state would only result in inaccurate and unreliable data in the new system and make PtWin no better that New World. In order to correct these problems additional tasks, not defined in the original scope of work, have been necessary. They are: 1. As part of the requirements for data migration requirements it was decided to migrate building permits and inspections so that there would be a migration of archived (closed) permits and active (open) permits. An analysis of the permit file indicated that there were only 247 closed permits out of a total of 8,451 total permits. Programs have been required to report these to the Building Department for manual cleanup and to close permits based on final inspections 2. Create a report of the New World fee tables for the Building Department to cross reference new fee codes to New World fee codes 3. Programming to report and cleanup duplicate and triplicate data 4. The creation on cross reference tables for old fee code to new fee code translation 5. Cleanup and populate throughout the necessary files contractor regiateration information 6. The creation of Street Dictionary and Street Alias tables for land parcel and programs to maintain them 7. Since PtWin lacks the ability to edit and cleanup land data imported from the county, the creation of AS/400 programs and procedures to be used on an ongoing basis prior to updating PtWin files 8. The deletion of inactive contractors prior to migrating to PtWin 9. Creation of reports to assist the Building Department in correcting incorrect and incomplete data 10. Creation of reports of invalid county land data for Building Department review