17 2/25/15 3/10/15 d. Is a database schema of the Versaterm data tables available to DAP vendors? The database schema can be made available during an on-site briefing for Finalists. Please see Section 1.9 of the RFP. 18 2/25/15 3/10/15 The Gartner Excel spreadsheet on page 3 of the RFP identifies approximately 97 data fields that “are not tracked”. a. Question: Does this mean that these data items are not currently captured and stored in any database or electronic format? Yes. 19 2/25/15 3/10/15 In the RFP it states: “As such, over the course of the procurement for the DAP under this RFP, SPD will be engaged in a parallel effort to remedy the data gaps identified by Gartner.” Please describe the project or activities that are in progress to address these data gaps: Gartner has recommended options for how the data gaps can be remediated. SPD is currently evaluating which options to implement. More information may be provided through addenda as available.
complex. ESRI ArcGIS is the city GIS standard for mapping & spatial analysis. Sun setting ESRI within the SPD would be need to be evaluated as a value proposition as we need to maintain compatibility with the City’s GIS system. Using other software (using the appropriate OGC standards) could mitigate some of those risks. 46 3/04/15 3/17/15 c) Do vendors need to account for licensing or other ongoing support costs for any of these tools? If the vendor’s solution exclusively leverages ESRI for mapping and spatial analysis, they would need to account for additional licensing costs required by the project that are over & above the licensing we currently have in place. Ongoing support would be handled by in-house GIS staff and the City of Seattle Enterprise License Agreement with ESRI. If the vendor’s GIS solution does not leverage ESRI, then the vendor should account for any and all licensing costs for GIS tools, data, services, and imagery, as well as ongoing support costs for maintaining such in the application. The more standards-compliant the GIS toolset, the less ongoing support will be assigned to the vendor 47 3/04/15 3/17/15 Future users of the new DAP :
49 3/04/15 3/17/15 Which open source Enterprise Service Bus is being planned for future use and how far is this implementation? SPD is currently implementing a new version of our Enterprise Service Bus using the following main components: Linux, Tomcat, CXF, JPA, Camel and Active MQ. We are well into the development stage of the base architecture and are beginning testing with the first of many data exchanges. We will have many exchanges migrated by the end of 2014 50 3/04/15 3/17/15 How will the new DAP need to cater for the 40 data exchanges currently occurring with other City departments? (if at all?) In its initial phases, it will not. SPD currently has several data exchanges with the County, City departments, and other agencies. It is possible that some of these exchanges will eventually be migrated to the DAP as a data source 51 3/04/15 3/17/15 Given the many various applications and data sources in use currently in SPD, can you highlight which are the most complex and difficult to access and how this is currently carried out? Additional information regarding SPD applications will be provided during an on-site briefing for Finalists. 52 3/04/15 3/17/15 Are there any plans to replace any of the existing SPD applications and their supporting databases and how will this potentially impact the DAP implementation? The Law Department’s On-Track system is in the early stage of a replacement project. Some SPD HR applications may be replaced by a later phase of the City’s adoption of the Cornerstone On Demand system. Additional information regarding these and any other efforts will be made available to Finalists as it becomes available.
application or expected to be captured within the BI system? City expects that information regarding incidents relevant to some litigation (e.g., litigation regarding use of force) will be captured in IAPro. The DAP will pull data from each of these systems. 86 3/05/15 3/17/15 Page 22 of the Functional Requirements states: "A new and litigation management system may have to be acquired or created." Has a litigation management system been created? Should the scope of the DAP project include the ingestion of data from this or another to be named system? See response to Question 85. 87 3/05/15 3/17/15 Page 29 of the Functional Requirements States: "Associate supervisors’ notes of issues or problems noted during yearly performance appraisal with EIS events." Is this capture functionality part of IApro, the Custom Workflow application or expected to be captured within the BI system? Supervisors’ notes are not expected to be captured by the DAP. Supervisory notes are kept in the HR systems that the DAP will pull information from. 88 3/05/15 3/17/15 The PWC Gap Analysis report has made a recommendation to hire "15 additional Technology Resources." Have you and/or do you plan to fill these headcount positions? These additional resources have not been hired and there are currently no specific plans to do so. SPD is in the process of selecting a consultant to provide a more detailed analysis of its overall IT organization structure and staffing needs. We are also looking for recommendations from Vendors on resources that will be required to maintain the DAP. 89 3/11/15 3/17/15 How many end users will access the system? Please see response to Question 10.