Northeast Presentations

University of Delaware had vendors from 12 years ago that were stored with a TIN as a vendor_ID. We created an automated process to convert these vendors to sequential vendor_IDs. Then we created a process to consolidate 1099 information where payments existed for old and new vendors. In the same year, we also converted all vendor file attachments from storage on a file server to the database, tied to the vendor, so the user saw no difference, but had a securer storage of the attachment, in blobs. After these conversions, attachments were moved from the prior vendor to the new vendor, thru an automated process.
Particular attention paid to the bolt-on process to consolidate the 1099 information.