Computer Sciences Corporation
Work Order
March 8, 2022 - Prices Valid Until 03/31/22
Agreement No. 01-STE-0106 Work Order No. 5
Database analysis will be performed to ensure Customer’s environment after upgrades are stable. The
process involves comparing the upgraded Customer database with the standard Riskmaster database of a
new Riskmaster environment and to identify any gaps.
Gaps include the following:
o The information of new tables in Riskmaster database.
o The information of new columns in database tables.
o Mismatches in tables column Data type and other column properties (e.g., sizes).
o Archival information for descoped tables and columns, etc.
All gaps are documented and thereafter necessary SQL scripts are created to address all identified gaps.
These SQL scripts are delivered as an outcome of Database analysis along with instructions and sequence
for executing these scripts.
Upgrade Lawson Employee to Assure Claims Interface
Customer will purchase DA DIS licensed tool to be used for importing employee data into Assure Claims.
Customer will provide the source data via SFTP. The entirety of the source data will be provided to start the
data import process.
CSC will write batch jobs for reading the source data and populate it into MS Access database instead of the
old MDB database and will then use the DA DIS tool for importing data from the MS Access database to
Assure Claims.
CSC will use the same employee matching criteria as is used currently and setup the periodic import as per
current the current frequency.
Based upon the employee matching criteria, DA DIS will either create new employees or update existing
employees in Assure Claims.
There will be two (2) cycles of delivery: first the Test/Training environment, and then Production. Should
Customer want additional delivery, the additional delivery hours will require a change control order and be
subject to additional fees.
Risk to Lawson Indemnity /Risk to Lawson AP
Assumptions:
User will manually enter the needed input fields in the dashboard prior to running reports.
The csv/Excel files will contain headers. User must manually make format changes as needed to the files
and manually rename as needed.
All data must exist in Assure Claims.
Custom changes will need to be made in Elasticube to support case statements/conditional logic.
Customer will create their own dashboards, as confirmed via email on March 18, 2022.
With Sisense option Customer may need to manually update the file or rename it. Through the utility, the
file can be coded to format and named as per requirements.
Two extract files from RISKMASTER will be provided.
Nightly Backups
Upon request, a nightly backup of the Customer database can be placed into SFTP for Customer to
download. Customer can restore the backup to a local Microsoft SQL Database Server. Customer
acknowledges that this data would not be real time, and any costs shall be solely borne by Customer. There
are no additional charges from CSC for this service.
Rhodes — SR-0020110506 - GDC
