Laserfiche WebLink
For fields that hold codes O,e. text or numeric values that have specific mcanin«s), cross -neaps between valid <br />codes and their meanings will be provided in separate tables, tiles or reports. <br />€t is assumed that Santa Ana will clean up (close, Complete. void) all outstanding orders. in order to <br />reduce the ri.iinbcr of service orders that will need manual entry pest co,version. <br />It is assumed that Santa Ana will produce financial reports needed from the legacy CIS system prior to the <br />enQuesta Go Live. Santa Ana should also maintain a copy of their existing system or detailed reports in order <br />to be able to access historical data other than consumption history since it will not be converted. <br />it is assumed that Santa Ana a, ill Create and execute urt =t test plans to ensure validity of data extracted. Santa <br />Ana �.vill identify data that does not m,:et data re.luirentent. of the data dictionary and will correct that data so <br />that the tiles submitted to S &S only contain clean data. F.xttmples (If' cleanup tasks include but aren't limited <br />to: <br />• Manually correcting invalid intorntation <br />• Writing off invalid transactions <br />• Removal of duplicate records <br />• Removal ofobsolete records <br />• Correction of data that falls outside acceptable values including codes and ranges <br />The enQuesta system requires Service Premise Address street names to be consistent and in a valid format. <br />Data Conversion Responsibility Matrix <br />P-- Primary responsibility <br />S Supporting role <br />The following table summarizes the most important deliverables and responsibilities for a successful <br />conversion: <br />TAW <br />SO <br />Santa Ana <br />Lead data conversion effort <br />p <br />Create data conversion plan <br />P <br />S <br />Provide list of data that needs to be converted along with major enQuesta tables that <br />will be populated and applicable valid codes/ianges. <br />P <br />Create data detinition'dictionary <br />p <br />Perform data extraction from legacy systems <br />p <br />Unit test extracted data for validity <br />p <br />Cleanup of data in legacy systems <br />p <br />Map data between legacy system extract and enQuesta <br />P <br />S <br />Sign -off on data mapping <br />p <br />Develop conversion scripts for import of data into enQuesta <br />p <br />Perform data import into enQuesta <br />p <br />Provide expert resources to answer questions about legacy systems and extracted <br />data in a timely manner <br />P <br />Perform balancing tests between legacy systems and extracted data tiles <br />S <br />P <br />Perform balancing tests between extracted data files and enQuesta <br />P <br />S <br />Perform simulation conversion <br />p <br />S <br />Sign -off on balancing tests <br />p <br />Perform data validation on accounts in legacy and enQuesta systems <br />S <br />P <br />Troubleshooting <br />p <br />S <br />Perform final conversion <br />P <br />S <br />Santa Ana may request that S &S provide additional support for tasks that Santa Ana is solely responsible for. <br />These requests will be addressed through change control. <br />Lawson Software — Confidential 54 <br />