Laserfiche WebLink
O <br /> HARRIS <br /> Wit,-- ' ' UTILITIES <br /> Everett, City Of m Oracle to SQL Server <br /> Conversion of Cayenta ERP 7.9 <br /> Change Order #001, <br /> g_ 9 ` ' -fi { T_ p " „ <br /> Wig, <br /> t� 'ra �s _ 3A , vaL - 3i a 000044r* <br /> �a' xt ` > <br /> ; �o-- 11k—ly� , � .: �' * z i X�e m ^^ f'a :slar�s; LA <br /> Change Order 001 -Changes to SOW-The Additional Data Conversion Test Run and The Additional <br /> Milestones <br /> _- - -- +':'a_s?"Z-'j-.=_- __+4zu_YaT•2 a - :�. .._t 4 fr'^^ �=r��-- -- ��'-�'��_'_`?'ns__ ".z't'c`'a�, WAMW .a.'ti13 <br /> WidlO <br /> . .w,4- c *a% �4c i t 4 i' ax•-,.u�1 - gra 4; <br /> ^ �,-moi.; �^,''�!E''��.3. -.-_�T;r.�`.' x`,' ��i'F� .�.�r,'Y`..yt��=a ��F-1 n�• �x��.;;3�� 'at=:a���3�i.a,'�`-�}^•;ra,�.. <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 /> O 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 /> Y 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 theconversion, 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 4th day of May 2017. <br /> ,��� �J�.r i''�T '�. C� ��—.¢�'3��...s_s � sr e } � -s ���r .ha "�_ <br /> ^:4'` V3, A r M Y``NN -yam-�r-� '�.e. - _ t• .�rW �'ta`i-t t y �17I- , <br /> Cbntand Gene i n © '{ <br /> Cayenta, a Division of Harris Computer 1 of 5 January 28, 2019 <br /> Systems <br /> 12 <br />