Development of the IT system of the Oleśnica City Hall necessary to support e-services: e-Office III stage and purchase of field programs for budget units of the Oleśnica City Hall

A. Oleśnica City Hall - implementation deadline 15.12.20

I. Purchase and implementation of a compatible and integrated whole IT system together with functionality enabling customers to access selected information collected in the office's database, whose design will implement cooperation between electronic document circulation and domain systems (related to handling taxes and non-tax revenues, financial and accounting modules , budget, contracts, payroll and payroll systems, and systems regarding land issues, leases, information on the resources of traditional archives, etc. cooperating with the State Register System), integration of electronic circulation with external platforms (ePUAP, Centralized System for Access to Public Information, Electronic Invoices Platform ) and integration of domain systems among themselves.

II. Purchase and implementation (installation, configuration, parameterization) of a report generator and components necessary for its operation on an integrated database (BI type solutions or based on the properties of a data warehouse) allowing for obtaining synthetic, filtered information that is a cross-section of the databases of the applications used. In order to carry out the task, the Employer also allows the use of "data warehouse" updated automatically between 22-6.

III. Preparation and implementation of data and environment archiving procedure as well as recovery and verification of copies made using the Employer's hardware and software infrastructure with ongoing notification to the e-mail address about the progress of the procedure.

IV. Database verification and migration.

V. Training

B. City budget units - implementation deadline 20.12.20.

I. Purchase and implementation of a compatible and integrated system with the IT system referred to in point AI for the budget units of the City of Oleśnica along with the functionality that allows customers to access selected information stored in the database, the design of which will implement cooperation between electronic document circulation and systems domain (related to the handling of financial and accounting modules, budget, contracts, HR and payroll, and systems regarding information on traditional archive resources, etc. cooperating with the State Register System), integration of electronic circulation with external platforms (ePUAP, Centralized System for Access to Public Information / BIP, the Electronic Invoices Platform) and the integration of domain systems among themselves.

II. Database migration.

III. Purchase and implementation (installation, configuration, parameterization) of a report generator and components necessary for its operation on an integrated database (BI type solutions based on the properties of a data warehouse) allowing for obtaining synthetic, filtered information that is a cross-section of the databases of the applications used.

IV. training

C. Option - Open data - date of exercising the option on 20.12.20.

1. Providing a portal in the ICT environment of the Contractor for the presentation of public data of the Oleśnica City Hall and budget units at least at the fourth level (sharing data using URI (Uniform Resource Identifier) links and using RDF (Resource Description) technology Framework) describing the data (http://5stardata.info/en/examples/gtd-4/)) in accordance with the API standard for the programming interface of the database access application based on the manual published by the Ministry of Digitization entitled "Opening data. Good Practice Guide ”available at https://dane.gov.pl/article/1223. The portal should present in the form of rows numbered data in a user-friendly, communicative and user-friendly manner, and enable the printing of selected data with a summary of numerical values