Exhibit_2_-_Integration_Inventory.xlsx
XLSX spreadsheet 13 KB Posted
- Attached to
- Enterprise Asset Management - Software & Implementation State and local contract opportunity
- Solicitation number
- RFP 26-0007
- Issued by
- Maricopa County, Phoenix City, Arizona
About this file
The document is an integration inventory exhibit for the City of Phoenix's Enterprise Asset Management (EAM) software and implementation project. The solicitation seeks a comprehensive five-year contract commencing on or about May 1, 2026, covering multiple municipal departments including Aviation, Public Works, Street Transportation, and Water Services. The project aims to replace existing asset management applications with an integrated cloud-based SaaS solution capable of tracking, analyzing, and forecasting asset performance. The procurement requires a vendor with at least five years of experience implementing EAM products for public entities, with proposal responses due by November 14, 2025, and a pre-offer conference scheduled for October 10, 2025. The evaluation process will allocate 675 total points across three categories: System Capabilities (300 points), Experience and Qualifications (185 points), and Method of Approach (190 points).
The integration inventory reveals a complex technological ecosystem managing 443 properties across 11 client departments, totaling 10,496,280 square feet and 14,709 land acres. The current infrastructure involves intricate data exchanges between systems including eChris (PeopleSoft), HARS, SCADA, GIS, AutoCAD, Dynamics365, and various Building Automation Systems. While specific budget details are not explicitly stated, the procurement emphasizes robust security protocols, including a data privacy questionnaire to assess vendors' privacy risk levels. The project requires comprehensive system integration, supporting multi-departmental configurations and connecting with existing platforms like SAP. Key deliverables include work order management, preventive maintenance tracking, resource allocation, mobile field operations, and advanced reporting and analytics capabilities, with Water Services currently managing 2,128,271 total assets and potential future expansion to 340,000 assets.
View the file
Other files for this state and local contract opportunity
Show all 50
Enterprise Asset Management - Software & Implementation has more files on GovTribe.
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Exhibit 2
| EXHIBIT 2. | CURRENT EAM INTEGRATIONS | |||||||
| Interfaces across all systems shall be updated to modern platforms, adopting industry-standard protocols and design practices to enhance integration, interoperability, security, and performance. | ||||||||
| Interface | Type of Connection | Frequency | How data is fetched | Average per day / Description | Dept. | Direction WAM/WACS | Notes | |
| eChris (PeopleSoft) | DBLink -- Grant to two eChris view having 1,400 rows of data each | Once a day | A custom procedure will insert/update data into SYNERGEN tables | 2,800 | Employee and Wage Interface into WAM | HR | Inbound | |
| HARS | DBLink -- Grant to two HARS tables/views having 800 rows and around 3 million rows | Once a day | A custom procedure will insert/update data into SYNERGEN tables | 800 | Process Control Data (SCADA) into WAM. Same Asset will have multiple Readings per day, 754 unique Point ID's. | WSD | Inbound | |
| UCOS | JDBC connection inserting data into SYNERGEN | On demand | A custom procedure of WAM database is invoked and data inserted to WAM | 1 | Create Work Request into WAM | WSD | Inbound | |
| SAP Transaction file | FTP between SAP and ITS | 4 times a day | A custom http method will read the file and insert data into SYNERGEN tables | 100 | Checkout Issues coming into WAM | ITS | Inbound/Outbound | Column D refers to Inbound but there is transactions both ways between SAP and WAM. |
| SAP Catalog file | FTP between SAP and ITS | Every 6 hours | A custom http method will read the file and insert data into SYNERGEN tables | 5,000 | SAP Catalog Items and Item Details (every 6 hours) | ITS | Inbound/Outbound | Column D refers to Inbound but there is transactions both ways between SAP and WAM. |
| Checkout request | Web service | On demand | Web service is invoked via http method via stored procedures called from forms | 100 | Checkout Requests are sent to SAP | WSD | Outbound | |
| Requisition | Web service | On demand | Web service is invoked via http method via stored procedures called from forms | 5 | Requisitions from WAM to SAP | WSD | Outbound | |
| GIS | DBLink | Once a day | A batch job invokes web service via http method through stored procedure | 200 | WSD | Inbound/Outbound | ||
| SAP Follow On | Web service | Once a day | A batch job invokes web service via http method through stored procedure | 5 | Shopping Carts for Items that are not carried in the Storeroom. Requisitions created in WAM, PO is created in SAP, Invoice in SAP. Return SAP shopping cart number to WAM | WSD | Inbound/Outbound | |
| AutoCAD Suite | N/A | |||||||
| GIS | Webservice | On demand | multiple webservices to provide location based information (Street names, Block #, District #, etc) | Street Transportation Department, Public Works Department | Inbound/Outbound | |||
| SAP | Webservice | On demand | Submit crew report details (Employees hours and material consumption) | Street Transportation Department | Inbound/Outbound | |||
| Dynamics365 | Webservice | On demand | Receives the requests submitted by the public relevant to Street Maintenance Issues and Downed traffic signs, triggers Citizneserve to create work orders and automatically assigns them to crews | Street Transportation Department | Inbound | |||
| Building Automation Systems (e.g. Trane, Delta) | BACnet | On demand | Staff utilize the platform to monitor building systems on an as-needed basis. | Enables different building systems (e.g. HVAC, lighting, and fire safety) to communicate and be controlled from a single platform | Public Works Department | N/A | A data communication protocol for building automation and control networks. |
File details come from the government source that posted it. Updated .