25C - AGMT CITYWIDE BUDGET SOFTWARE

Home Browse Search

HR Data Sync. Automated facility to synchronize Salaries data between Questica In scope Budget and The Customer's Lawson HR system. Questica shall be responsible for providing the software interface into Questica Budget and the operational infrastructure required to manage the integration. The Customer shall be responsible for making available the data to be exported from the Lawson system, either in CSV formatted files or by ensuring that the standard Lawson to Questica Budget integration component is available for extracting data from and updating data within that system. This will be through the export and import of structured files or by providing database interfaces (stored procedures and queries). This integration synchronizes: • New, deleted and updated employees; • New, deleted and updated positions; • Changes in employee -position relationships; • Changes in position -costing center relationships. The integration of profiles (bargaining units), grades, steps, pay scales and benefits shall not be included unless expressly referred to in the "Customizations" section of this Scope of Work. Notwithstanding responses to Requests for Proposals or other communications between Questica and The Customer, the integration of custom chart field items is not included unless expressly set out in the "Customizations" section of this Scope of Work. 2.4. Capital Module The Questica Budget Capital module is included in this installation. Functional Area Description.. Conflgumdon ... Import Projects Configuration and data import of standard Questica Capital data In scope structures, using data supplied by The Customer in Excel® workbooks provided by Questica. At a minimum, the files will contain the data necessary to: • Create Projects (including closed projects where historical budget is to be loaded); • Add Projects to Departments consistent with, and shared by, the Operating budget module; • Define Project Promotion Stages. The configuration data may optionally contain data necessary to: • Define Asset Categories & Asset Types; • Define Project Regions; • Define a Single Set of Project Ranking Metrics. InIdal Data Load... Initial Capital data imported into Questica Budget from Excel® files ("workbooks") Import Initial Import the current/future Capital budget, with 5 years of future In scope Budget forecast data from data import workbooks: • Create dollar budget line items with GL Accounts and Funds ... at the Project level. Questica will carry out a second import of the current/future budget if required. This accommodates an initial data load at the start of the implementation and a refresh prior to going live. © Questica Inc. December 11, 2017 25C-21 Page 19 of 27