HomeMy WebLinkAbout26 - Instructions - Enterprise Resource Planning Software & Implement (3)Bozeman, MT
Interfaces
Please use the descriptions below to complete columns L - R on the subsequent tab.
If the Respondent recommends additional interfaces, please add them in the table at the bottom of the interfaces tab and include them in the fixed fee price.
Column
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
Response Key - Column L (Respondent Interface Plan)
Available Response
Keep
Temporary
Go-Away
Not Accommodate
Response Key - Column M (Direction_R)
Available Response
Inbound
Outbound
Bi-directional
Response Key - Column O (Method_R)
Available Response
API
File
N/A
Response Key - Column P (Experience)
Available Response
Yes
No
Response Key - Column Q (Type of Solution)
Available Response
Configurable
Customized
Indicates input cell for Respondent to supply information
Header
Application
Application Description
Interface Description
Comments
Direction
Frequency
Method
City Interface Plan
Direction_FS
Frequency_FS
Method_FS
Respondent Interface Plan
Direction_R
Frequency_R
Method_R
Experience
Type of Solution
Comments_R
Description
A permanent interface with the ERP solution
The interface that is only required during implementation
The interface that is no longer required as a result of the new ERP solution
Respondent will not accommodate this interface
Description
Respondent proposes an inbound data transfer to the ERP
Respondent proposes an outbound data transfer from the ERP
Respondent proposes a bi-directional data transfer to and from the ERP
Description
Respondent proposes an API to transfer data
Respondent proposes use of a file to transfer data
Type of connection is not applicable or unknown
Description
Respondent has developed an interface with the third-party solution
Respondent HAS NOT developed an interface with the third-party solution
Description
Existing interface that will need to be configured
Interface will require custom development
Description
Current City application
Description of application
Description of the interface needs with the application and future ERP
City's comment on the interface for additional context
Current data flow direction of interface
Current frequency of interface
Current method for interface
The City's intention for the interface plan
City's envisioned data flow direction of interface
City's envisioned frequency of interface
City's envisioned method for interface
Respondent's proposed interface plan
Respondent's proposed data flow direction
Respondent's proposed frequency of interface
Respondent's proposed method for interface
Indicate if Respondent has experience developing interfaces with the third-party solution or provider
Respondent should indicate if the solution is configurable or will require customed development
Respondent should include any comments or assumptions relevant to the answers above
Attachment 3.2 - Interfaces
Application
Accurate
ActiveDirectory
Benefit Provider - Allegiance
Benefit Provider - MetLife
Benefit Provider - Montana Municipal Interlocal Authority (MMIA)
Benefit Provider - Mutual of Omaha
CIMS
CityWorks
CivicRec
CrewSense
Deckard
Employee Navigator
E-Soft
First Due
FirstView RMS
Future Permitting System
Future Utility Billing System
GIS (ESRI) - VantagePoint
InvoiceCloud
Lansweeper
Laserfiche
Mission Square
MPERA
MuniCourt
Naviline
NeoGov
OpenGov
PACE
Passport
PowerBI
ProjectDox (Avolve)
Tax filing
Time & Attendance
US Bank
US Bank
Vector Solutions
Workiva
Zuercher
If Respondent recommends additional interfaces not included in this, please add them here and include in Price Proposal
Application Description
Add additional rows as necessary
Application Description
Background checks
Single Sign On
Medical and Dependent FSA
Dental and Vision
Benefits provider systems (MMIA, Metlife, Mutual of Omaha, HSA/FSA providers)
Accident, Hospital, Critical Illness, Long-Term Disability
Cemetary management system
Work order management and asset tracking
Recreation revenue data
Scheduling software for Fire
Short Term Rental permits
Benefits enrollment system
Background checks
Commercial building inspections (Fire)
Fire department incident reporting
TBD permitting, licensing, and code enforcement system
TBD Utility Billing system
Infrastructure asset location tracking; Property file information
Online payments for utilities
Tracking IT equipment and software lifecycles
Document storage
Voluntary retirement deduction
State retirement system
Payment of court fees
Current ERP system that also provides Utility Billing functionality and takes payments for Permitting system
Recruitment, onboarding, performance evaluations
Pet license billing
Scheduling software for Police
Parking payment information (permits and fines)
Data reporting / manipulation with "keys" to align to state accounting requirements (BARS)
Plan / application review software
Filing of tax documents
Record of payroll hours
P-Card provider
Payroll direct deposit and vendor payments
Learning Management System
Financial reporting and budget document preparation
Police records
Interface Description Needs
Interface Description Needs
1. Employee information
2. Background check results
1. Employee ActiveDirectory data
1. Employee information
2. Employee payroll / deduction information
1. Employee information
2. Employee payroll / deduction information
1. Employee information
2. Employee payroll / deduction information
1. Employee information
2. Employee payroll / deduction information
1. Summary revenue data by account code
1. Capital asset information (description, location, value, etc.)
2. Employee information (wage rate, skills, etc.)
3. Inventory items and associated value for financial reporting
4. Purchasing / requisitions
1. Summary revenue data by account code
1. Employee data
2. Project / accounting data
3. Leave accruals / deductions
4. Time entry and paycode data
1. Payment information
1. Employee data
2. Plan information (type, cost, etc.)
1. Employee information
2. Background check results
1. Summary revenue data by account code
1. Employee data
1. Employee data
2. Chart of Accounts / GL Mapping
3. Cash receipts / deposit advice
4. Summary revenue data by account code
5. Accounts receivable summary
6. Refunds & voids
1. Employee data
2. Chart of Accounts / GL Mapping
3. Cash receipts / deposit advice
4. Summary revenue data by account code
5. Accounts receivable summary
6. Refunds & deposits
1. Parcel data
2. Customer data
3. Asset information
1. Customer information
2. Revenue information (individual accounts and summary data)
1. Employee data
2. Asset information
TBD
1. Employee information
2. Employee payroll information
1. Employee information
2. Employee payroll information
1. Summary revenue data by account code
1. Chart of Accounts / GL Mapping
2. Summary revenue data
1. Job description information
2. Job requisition information
3. Candidate information (when hired)
1. Summary revenue data by account code
2. Receivable / payment information
1. Employee data
2. Project / accounting data
3. Leave accruals / deductions
4. Time entry and paycode data
1. Summary revenue data by account code
2. Receivable / payment information
Access to system data for City to run ad-hoc and custom reports in PowerBI application
1. Payment information
2. Customer / project information
1. W-2 Information uploaded to approapriate taxing authorities (state, federal)
2. 1099 Information uploaded to approapriate taxing authorities (state, federal)
1. Employee data
2. Project / accounting data
3. Leave accruals / deductions
4. Time entry and paycode data
1. Employee data
2. Accounting data
3. Transaction data (amount, vendor, etc.)
1. Employee information
2. Employee payroll information
1. Employee data
1. Budget information (adopted, budget to actual, etc.)
2. Financial data for financial reporting (i.e., ACFR data)
1. Employee data
Comments
Comments
Currently manual cash receipting process
Manual Cash Receipting
Request guidance from Respondent on which information / tasks (accrual balances, time off requests, etc.) lives in which system (Scheduling vs. ERP)
Manual Cash Receipting
No financial data transacted but would like FirstView to have current employee data from HCM
List Permitting providers for which Respondent has a pre-existing integration
List Utility Billing providers for which Respondent has a pre-existing integration
GIS is the source of truth for geospatial data
May be temporary integration until UB system goes live.
ActiveDirectory report used to assess "active" personnel
Possible need to link ERP transactions to documents stored in Laserfiche
Envision needing a temporary integration for revenue data until new Utility Billing and Permitting systems go live
Currently manual cash receipting process
Request guidance from Respondent on which information / tasks (accrual balances, time off requests, etc.) lives in which system (Scheduling vs. ERP)
Currently use dedicate payment terminal for parking payments.
Query-based reporting
Currently serves as portal for permit applications. If remains in future state, would like to know if payments made by applicant
Query-based reporting
System for police records and misdemeanor code enforcement cases
Direction
Direction
None
None
None
None
None
None
None
None
Inbound
None
None
None
None
Inbound
None
None
None
Bi-Directional
Inbound
Inbound
None
None
Outbound
None
None
None
Outbound
None
Inbound
Outbound
Bi-Directional
None
Bi-Directional
Outbound
Outbound
None
Outbound
None
Frequency
Current State
Frequency
N/A
N/A
N/A
N/A
N/A
N/A
On Demand
N/A
On Demand
N/A
N/A
N/A
N/A
On Demand
N/A
N/A
N/A
Daily
Auto - On Demand
Weekly
N/A
N/A
Per Pay Period
N/A
N/A
N/A
On Demand
N/A
Daily
Daily
Auto - On Demand
N/A
On Demand
Monthly
Per Pay Period & On Demand
N/A
Daily
N/A
Method
Method
N/A
N/A
N/A
N/A
N/A
N/A
Manual Entry
N/A
Manual Entry
Manual Entry
N/A
N/A
N/A
Manual Entry
N/A
N/A
N/A
Auto (programmatic) Procedures
Auto Procedures
Manual Export/Import
N/A
N/A
Programmtic Export File
N/A
N/A
N/A
Manual Entry
Manual Entry
Manual Entry
Report Export
Auto Procedures
N/A
Programatic import/export process
Programmatic Export File
Programmatic Export File
N/A
Report Export
N/A
City Interface Plan
City Interface Plan
Keep
Keep
Keep
Keep
Keep
Keep
Keep
Keep
Keep
Keep
Keep
Go Away
Keep
Keep
Keep
New
New
Keep
TBD
Keep
Keep
Keep
Keep
Keep
Temporary
Go Away
Keep pending Permitting RFP
Keep
Keep
Keep
TBD
Go Away
Keep
Keep
Go Away
Keep
Keep
Direction_FS
Direction_FS
Bi-directional
Bi-directional
Bi-directional
Bi-directional
Bi-directional
Bi-directional
Inbound
Bi-directional
Inbound
Bi-directional
Inbound
Bi-directional
Inbound
Outbound
Bi-directional
Bi-directional
Bi-directional
Inbound
Bi-directional
Bi-directional
Bi-directional
Bi-directional
Inbound
Inbound
Inbound
Bi-directional
Inbound
Outbound
Outbound
Bi-directional
Bi-directional
Outbound
Outbound
Frequency_FS
BZN Envisioned Future State
Frequency_FS
Daily
Real time
Daily
Daily
Daily
Daily
Daily
Hourly
Daily
Real time
Daily
Daily
Daily
Daily
Real time
Real time
Hourly
Hourly
Daily
Ad-hoc
Weekly
Weekly
Daily
Daily
Daily
Real time
Hourly
Ad-hoc
Ad-hoc
Hourly
Hourly
Daily
Daily
Method_FS
Method_FS
File
API
File
File
File
File
File
API
File
API
File
File
File
File
API
API
API
File
File
API
File
File
File
File
File
API
API
API
File
File
File
File
File
Respondent Interface Plan
Respondent Interface Plan
Direction_R
Direction_R
Frequency_R
Respondent Proposed Future State
Frequency_R
Method_R
Method_R
Experience
Experience
Type of Solution
Type of Solution
Comments_R
Comments_R