1.) What systems are being used to create these reports today?
2.) What is the not-to-exceed budget for this project?
3.) What types of city systems will the solution need to integrate with? How will the solution be able to connect with these systems? (API, etc)
1. Periodic housing production reports are created manually, using a combination of building permit and fee data from Infor (an ERP system) and two master spreadsheets maintained by the Planning Bureau. Data is filtered and aggregated by hand. However, Development Services is currently in the process of streamlining this, with the goal of migrating all Planning data into Infor, which if implemented correctly will allow Infor to produce scheduled and ad-hoc reports.
2. This is still being determined.
3.
A. At a minimum, the solution will need to be easily updated with the data reflected in the housing production reports as described above, as well as using a platform (such as the City’s website or intranet) to make the dashboard accessible for all City staff.
B. Ideally, the solution would also be able to seamlessly integrate with Infor to automatically pull reports and update data given preexisting parameters, as well as displaying this information on the Development Services website in an intuitive way.
Asked
Answered