2-Attachment B - Functional and Technical Requirements.xlsx

This is a Functional and Technical Requirements matrix for an Agenda Management Software Solution being procured by the City of Wichita, Kansas for the City Clerk's office. The document outlines a comprehensive set of required and desired capabilities organized across four primary categories: Technical, Security (Access), Reports, and Integration. All requirements listed are marked as "Required" baseline functionality with no items designated as desired, third-party applications, planned for future release, or requiring source code modifications.

The technical requirements include reporting on separate databases, batch processing capabilities, application server separation from database servers, API and web service interfaces for external system integration, PCI compliance, dual monitor support, client-interface-based job management, and critical stipulations that AI systems cannot use City data for model training or retraining while ensuring all City data remains owned and controlled by the City. Security requirements mandate compliance with relevant standards such as ISO 27001, SOC 2, GDPR, and HIPAA; role-based access control; multi-factor authentication support; AES-256 encryption for data at rest and TLS 1.2+ for data in transit; comprehensive audit logging; secure credential storage; and regular penetration testing. Reporting requirements call for built-in or integrable reporting engines compatible with platforms such as Power BI or Tableau, ad-hoc and scheduled report generation, multiple export formats (PDF, Excel, CSV), role-based report access, KPI dashboards, audit trails for report activities, and customizable filtering and grouping. Integration requirements specify compatibility with existing systems including ERP, SSO, and payment gateways, as well as support for both file-based and API-based data exchange methods.