Laserfiche WebLink
CliTe <br /> HARRIS <br /> UTILITIES <br /> Everett, City Of - Oracle to SQL Server <br /> Conversion of Cayenta ERP 7.9 <br /> Change Order #001 <br /> Title <br /> Change Order 001 —Changes to SOW—The Additional Data Conversion Test Run and The Additional <br /> Milestones <br /> Background and Justification <br /> The purpose of this change order is to include an additional Test Conversion, a.k.a. 'Test Conversion #2' <br /> in the SOW, along with the new corresponding Milestones CONV10, CONV11 to accommodate the need <br /> of a special conversion approach, addressing specifics of the Everett's Production database structure. <br /> Justification: <br /> While preparing for, and also during, the pre-agreed Test Conversion, represented in the SOW by the <br /> Milestones CONV4, CONV5, the Cayenta team discovered an additional level of Everett's Cayenta <br /> Production system complexity, including: <br /> • Large number of custom objects. The list contains: <br /> o 414 Custom Views <br /> o 369 Custom Tables <br /> o 8 Stored Procedures <br /> o 8 Database Triggers <br /> By definition, custom objects are the responsibility of the client to convert. However, due to their <br /> number and their interconnection, Cayenta team took over the task of either directly converting <br /> these objects, or providing instructions how to, to minimize risks associated with otherwise an in- <br /> house conversion <br /> • Historical data from closed Fiscal Years, going back to the year of 1992. <br /> Each closed fiscal year adds between 80 to 90 tables. The total number of the historical tables <br /> (cca 2.300) almost doubled the number of tables to be handled by the conversion, thus creating <br /> an additional conversion process time <br /> The facts above led to the conclusion, that an additional Test Conversion (#2) will be required to devise <br /> new conversion technique and scripts to handle the volume, new -non-standard - custom objects, and <br /> the performance, in order to meet the downtime restrictions during the go-live weekend. <br /> This Change Order and Amendment to the Statement of Work ("Change Order") is made by and between <br /> Cayenta, a Division of N. Harris Computer Corporation and Everett, City Of and relates to the Statement <br /> of Work made effective as of 4"' day of May 2017. <br /> Contact and General Information <br /> Cayenta, a Division of Harris Computer 1 of 5 January 28, 2019 <br /> Systems <br />