Hemet City Council
May 28, 2024

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,

CERTIFICATIONS AND PARTNERSHIPS
Our solution brings the following strengths to City of Hemet, CA:

1. Highly skilled and experienced team with strong credentials in Implementation Services.

2. Cost-optimal delivery from our global delivery location for Oracle in India, with estimated effort specified.

3. We are proposing a solution that includes the project management, functional, and technical services devoid of unnecessary overhead or unreleased capacity.

4. Proven Implementation and Support methodology undergirded by ITIL processes and CMMI Dev3 certified delivery infrastructure and continuous Process Improvement through Agile processes and digitization.

We are confident of meeting City of Hemet, CA goals in a systematic and partnershipdriven approach.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,

2. Requirements
Provided as a separate Word document.

3. Pricing
Provided as a separate Word document.

4. XTGlobal Consultants Implementation Methodology
XTGlobal follows Oracle Unified Methodology to implement Oracle’s ERP Cloud. Below is our approach:

OUM includes support for a variety of Cloud projects, from guiding customers in planning their transition to the Cloud, to SaaS implementations and to managed Cloud services.

Best Practices for Oracle Cloud Implementation Project

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Communication and status reporting
XTGlobal believes in transparent reporting with customers and to achieve this we use several KPIs to measure the service levels performance. XTGlobal will provide periodic reports to monitor how the service is being delivered and to apprise senior management with the help of our Customer Success Manager.

Consistent communication and status reporting is a vital part of our customer satisfaction efforts. As part of our ITIL and PMBOK methodology we will formulate a detailed communication and control model. The guidelines from this model can be leveraged by your leadership to establish proper levels of ownership over operations and ensure that all policies and procedures are properly followed. The elements of this model include processes, policy, procedures, and other resources required to carry out effective project management.

In addition to the Service Delivery Manager, an Engagement Manager, who reports to XTGlobal’s executive management, will have an oversight to the execution of the implementation & support project. The Engagement Manager will work closely with customer’s management team to make sure service level commitments are being met.

It is a general practice with XTGlobal to conduct monthly meetings with the City of Hemet executive/Project Sponsors to review the implementation progress and discuss any major concerns. XTGlobal Support Manager, Engagement Manager and Executive Management or Designate will be present and provide an opportunity for the customer to discuss any shortcomings.

XTGlobal proposes the following to maintain active communication with all stakeholders through different means and at different intervals:

Weekly Status Reports
▪ Project Health
▪ On-going Activities
▪ Completed Activities
▪ Upcoming Milestones
and Releases
▪ Bug Fixes
▪ Action Items and Due
Dates
▪ Risk Identification and
Mitigation
Monthly Status Reports
▪ Track Unresolved Issues
▪ Project Progress
▪ SLA Adherence
▪ Metrics Reporting
▪ Discuss Deviations
▪ Agreements and
Disagreements
▪ Escalations
Quarterly Meetings
▪ Review SLA Adherence
between Client and
XTGlobal Management
▪ Review of SLA Contract
and Creation of any
Necessary Updates
▪ Overall Feedback from
Client Stakeholders to
XTGlobal Senior
Management

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
▪ XTGlobal will facilitate weekly status meetings with your staff to update status, and action plans.
▪ XTGlobal will conduct monthly meetings with key decision makers to review project health and performance.
▪ XTGlobal Implementation analysts will work directly with your IT staff and/or Users to understand legacy system, integration and its various issues. ▪ XTGlobal will use Phone and/or Email to communicate updates for incidents or planned outages.

Any other means of communication that City of Hemet prefers/uses (on-line portals etc.) can also be incorporated into the operations of the implementation team.

Project Management Approach
Issues Management:

Throughout the term of this SoW, issues may arise requiring further information or a decision for resolution. The project team’s objective is to resolve all issues at the lowest level possible. When an issue cannot be resolved at the project team level, the following escalation path will be followed. Each contact shall have the amount of time indicated in the “Response Time” column for bringing resolution to the issue, prior to the issue being escalated to the next contact level.

Deliverables and Acceptance Criteria
Acceptance criteria for deliverables need to be defined in THE CITY OF HEMET terms:
▪ Specific.
▪ Measurable.
▪ Agreed (between The City of Hemet and XTGlobal at definition). ▪ Realistic (the deliverable can be realized, and the criteria can be measured). ▪ Timely (deliverables can be realized in the provided or available time frame).

Continuous Improvement Approach
As an organization, XTGlobal believes in providing its partners with immediate cost savings through an accelerated delivery service in an incremental method of continuous improvements. XTGlobal works with customers to identify opportunities for continuous improvement. Then Plan the change, implement on a small scale. Analyze the results to implement the change in wider scale and assess the results continuously for process efficiency and customer satisfaction. This is an on-going effort to improve the service and increase the quality, by focusing on the behavior first and then the processes. Metrics Collection, Analysing and reporting improvements and tying improvement activities to the results.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
A proposed timeline for the project
The estimated timeline to implement Oracle cloud is 10 months, with an additional 2 months of support engagement.

However, if City of Hemet, CA would like to implement this project with different timelines, XTGlobal will work with the customer and renegotiate the project timelines accordingly.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Project Team
S.No. Role No.of
Resources
1 General Ledger 0.5
2 Capital Assets 0.5
3 Cashiering/Cash Management 1
4 Purchasing 1
5 Accounts Payable 1
6 Accounts Receivable 1
7 Project and Grant Accounting 1
8 Budget Management 1
9 Utility Billing/CIS 1
10 Human Resources 1
11 Timekeeping 1
12 Payroll 1
13 Reporting 5
14 Project Manager 1
15 Onsite ERP Analyst & Coordinator 1
***The Average time per month is 160 hours
Data Conversion methodology
Load Legacy Data. During this step, your legacy data is loaded into the system. Notice that you are not migrating this data directly into production. Rather, your rows are loaded into tables that are identical to the production tables; they just have a different Staging
Production
Load Legacy
data
Assign
production keys
Old/new key
Conversion
Tables
Errors
XML
Resolution
Conversion
tables
Control
Tables
Errors
Insert rows in
production.

Validate staging
Resolve XML
storage keys
Validate
production

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
owner. Mapping legacy data into the system is probably the most challenging part of the conversion process because the system is a normalized database (and most legacy applications are not).

Validate Staging. During this step, the system validates the data you loaded into the staging tables. Note that validation rules validate your staging data using the control tables that have been set up in production.

Assign Production Keys. During this step, the system allocates random, clustered keys to the rows in the staging database.

XML Resolution. During this step, the system resolves legacy keys that may be mapped to an XML storage field with new values that were assigned in the key assignment step.

Insert Rows Into Production. During this step, the system populates your production tables with rows from the staging. When the rows are inserted, their prime keys and foreign keys are reassigned using the data populated in the key assignment and XML resolution steps.

Validate Production. During this step, you rerun the object validation processes, but this time against production. We recommend performing this step to confirm that the insertion programs have executed successfully.

Training Process
▪ Define Training Needs
o Assess end user training needs based on in-scope processes, roles, and system functionality.
▪ Train the Trainer.
o Provide training material templates.
▪ Deliver Training
o Provide training to core team members.
o Deliver process and systems end user training materials and vet content with SMESs.
▪ Monitor and Refresh.
o Address training issues (if needed)
o Provide post go-live training support as needed.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Testing Methodology
XTGlobal uses Agile methodologies to manage and track Testing activities.

Test Management:
• Metrics Collection
• Analyzing and Reporting Metrics
• Incorporating Ongoing Improvements
• Managing Schedules and Costs
Test Infrastructure:
• Managing Environments
• Managing Data Sets
• Configuration & Build Management
• Managing Testing Tools
Test Planning Test Design Test Build Test Execution
• Test Strategy –
Product
Specific, Risk
Focused,
Diversified &
Practical
Approach
• Test Plan
- Strategy +
Logistics
• Test
Organization –
Roles and
Responsibilities
• Analyzing
requirements
• Determining
Coverage – Risk
Based &
Practical
• Determining
Testing
Procedures:

Automated,
Manual,
Exploratory,
Load
• Requirements
Traceability
Matrix (RTM)
• Creating
manual test
cases
• Creating
automated test
cases
• Defining test
data
• RTM
• Executing
Manual Tests
• Executing
Automated
Tests
• Recording
Defects
• Verifying RTM
TaaS (Testing-as-a-Service) Offerings:
• As part of the offering, provide a ready to use automated regression test suite with several standard HCM, ERP and SCM scenarios
• Automation of client specific, business critical functions and standard operating procedures into the suite.
• Automation of validation of all SOA based interfaces including file formats and sizes. • Enhancement the test suite periodically by adapting to UI Changes and other updates pushed by Oracle.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
• Performing a detailed analysis of test results including e-mail notifications, screenshots, logs and dashboards.
• Providing functional experts to review results and provide necessary in-sights into release readiness.

TaaS Value Propositions:
• A large team of automation and manual testers available on-demand • Vast expertise and experience in Selenium and other test automation tools • Extensive experience in configuring and using various test management and version control tools.
• Expertise across modules in Cloud HCM, ERP, SCM and Integrations • Experienced yet cost-effective resource pool.
• Ability to support round the clock with a proven Onshore/Offshore delivery model.

Security
Authentication and Access Control:
▪ Formalized, documented process for managing access to all systems that process, store or access sensitive client data.
▪ Enforcement of complex account/password policies.
▪ Incorporate multi-factor authentication for remote network access originating from outside the network.
▪ Disabling of media and USB ports on local systems.

Network Security:
▪ We can setup secure point-to-point VPN tunnel between our office network and THE CLIENTnetwork.
▪ Usage of software and hardware-based tools/techniques to detect and prevent network intrusions.
▪ Implementation of stateful-inspection and DPI firewalls.

Vulnerability Management:
▪ We have a documented patch management and distribution process that ensures all system components and software are protected from known vulnerabilities. ▪ We perform yearly internal and external vulnerability testing by a qualified thirdparty. ▪ We deploy anti-virus and anti-malware on all systems commonly affected by malicious software.

Security Awareness Training:
▪ We ensure all users receive regular security awareness training.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Auditing:
▪ Centralized logging implemented for system/network activity. ▪ Strong encryption, cryptography, and security protocols utilized to safeguard THE CLIENTsensitive data during transmission over open, public networks.

Physical Access:
▪ Employ physical safeguards and visitor access controls (card and biometric) to prevent unauthorized access to all systems used to process or store sensitive THE CLIENTdata.
▪ Utilize video monitoring at all ingress/egress points, with video data maintained for up to 60 days.

Recruiting:
▪ We perform third-party background verification (including drug test and criminal check) before hiring fulltime employees.
▪ All our offshore resources are fulltime employees.

Security (Roles and Responsibilities):
▪ XTGlobal and THE CLIENTwill identify delivered Permission Lists and delivered roles to include in the products or product functionality to be utilized and create Roles and User Profiles, as included in the scope of this implementation, unless otherwise stated in this document.
▪ After the roles and permission list have been identified, additional Permission Lists, Roles, or User Profiles can be created, but are the responsibility of THE LONG BEACH UNIFIED SCHOOL DISTRICT. Delivered permission lists and roles will be used to create up to 25 User Profiles.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Overview of Fusion Security Vs EBS Security

5. XTGlobal Consultants Support Methodology
At XTGlobal, we believe in providing reliable and qualitative support to our clients throughout the project to enable them to get the best ROI out of their investment. To achieve this, we have come up with the Cloud Enterprise Support Methodology (CESM) to ensure efficient and consistent delivery support to our clients. Based on ITIL frameworks, our systematic approach helps our clients mitigate risks, adopt cost-efficient practices, and build a stable IT environment. With a focus on growth, scalability, and lowered costs, XTGlobal, CESM methodology uses well-defined frameworks, phases, and milestones to keep the project on track at all costs.

Cloud Enterprise Support Methodology (CESM)
These are some of the key components of our Cloud Enterprise Support Methodology (CESM):

Service Strategy and Design:

In this phase, XTGlobal tries to understand the client’s requirements on a strategic level.

Based on our service offerings, we align them with the client’s service needs as much as possible to derive the best results. Our involvement starts from determining the appropriate SLAs, creating the service scope, and establishing a service desk strategy. Our detailed SoW (Statement of Work) contains XTGlobal’s and client’s responsibilities, change and escalation procedures, detailed frameworks, costs, pricing, and every other detail related to the project.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
System Stabilization, Steady State, Operational Maturity:

Once the system is designed and developed, several aspects come into play to keep it up and running. From day-to-day operations to routine incidents, there are certain support issues that need to be addressed on a continuous basis. This stage addresses several critical aspects of the project such as Incident Management, Problem Management (with root cause analysis), Instance Management, Patch Management, and Knowledge Management. It encompasses business process improvements to improve performance and reliability.

Continuous Improvement:

At this stage, the processes are in the stage of being finalized. Any improvements to efficiency are determined at this stage. Using metrics, we determine the reliability of the new system even when there are changes in the customer’s requirements. At this stage, our focus is on eliminating outstanding support issues as much as possible and ensuring overall customer satisfaction.

Importance of Cloud Enterprise Support Methodology (CESM) The CESM is a proven tool to track system and service performance. It is an effective measurement system to ensure quality in project deliverables. Apart from ensuring better service levels, it also focuses on improved customer adoption rates and customer satisfaction ratings.

CESM ensures:
• Easy access to known issues and solutions through knowledge base tools. • Change Management, Instance Management, and Patch Management tools to ensure smooth transitions with minimal business disruption.
• Reduced incidents over a period of time.
• Optimized system performance and enhanced business processes.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Incident and Problem Management Support
XTGlobal’s focus is on restoring normal service as fast as possible with minimal disruption to normal business operations and/or user productivity. We strive to add value to the client’s business by improved service quality by preventing incidents with significant business impact and adopting a more proactive approach to avoid incidents.

Key Performance Indicators:
▪ Number of Repeated Incidents: Number of repeated incidents with known resolution methods
▪ Remotely Resolved Incidents: Number of incidents resolved remotely by the service desk.
▪ Number of Escalations: Number of escalations for incidents not resolved in the agreed-on resolution time.
▪ Number of Incidents: Number of incidents registered by the Service Desk ▪ Incident Resolution Time: Average time for resolving an incident. ▪ First Time Resolution Rate: Percentage of incidents resolved at the Service Desk during the first call.
▪ Resolution within SLA: Rate of incidents resolved during solution times agreed in SLA ▪ Incident Resolution Effort: Average work effort for resolving incidents. ▪ Number of Recurring Incidents: Number of recurring incidents for each category ▪ of IT service
▪ Number of Problems: Number of problems registered for each category of IT service

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
▪ Number of Existing Known Errors
▪ Number of Incidents per Problem: The number of incidents attached to a problem before its identification.
▪ Average Problem Diagnosis Time
▪ Average Problem Resolution Time
Escalation Process/Contacts
Level XTGlobal Contacts City of Hemet
Contacts
Response Time
1 st Level
Contact
Sudhir Bhilar, Manager TBD 5 business days
2 nd Level
Contact
Bharat Rampally, VP Oracle
practice
TBD 3 business days
3 rd Level
Contact
Alma John, VP Sales TBD 3 business days
Oracle ERP Cloud Environment Availability SLA
These following Service Level Objectives apply to this Statement of Work and will be negotiated with The City of Hemet:

Priority
Code
Description Target
Response
Time
Target Resolution
Time (PROD)
Target Resolution
Time (Non-PROD)
1 Critical 1 Hour 8 Hours N/A
2 High 4 Hours 2 Days 3 Days
3 Medium 2 Business Days 5 Days 5 Days
These following is Oracle ERP Cloud (SaaS) environment availability:

Environment Availability
Production 99.9%
Integration Cloud >99.9%
Change Management Methodology
The following Change Process will be used to manage all alterations to this SoW. Examples of alterations include, but are not limited to: changes in scope, Work Products (including accepted Work Products), schedule, and costs occurring for any reason, including failure of The City of Hemet to fulfil its roles and responsibilities, unforeseen events, delays caused by The City of Hemet, delays caused by Software Vendors or any third-party vendors that

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
are not included in the scope of this solution, and inaccurate assumptions and dependencies. XTGlobal will not perform services not described in this SoW until a Change Request has been approved.

Change Request Process:

1. Either party may notify the other of requested changes by completing a “Change Request” (“CR”) form, which provides justification for the change and the proposed impact to the scope, schedule, and cost.

2. If The City of Hemet has initiated the Change Request, XTGlobal will respond to the CR with the impact to the scope, schedule, and cost.

3. The City of Hemet approver will approve or reject the requested Change Request within five (5) business days from the receipt of the CR form.

4. If The City of Hemet approver does not approve or reject the requested Change Request within five (5) business days from the receipt of the CR form and does not communicate a reasonable timeframe in which a decision will be made, the requested CR will be considered deferred:
a. The CR status will be logged, tracked and managed as a ‘deferred’ request. b. Services will progress without incorporating the requested change into the work plan.
c. Where an approval or rejection decision is necessary for the Services under this SoW to progress, XTGlobal and The City of Hemet will use the Issues Management process above.

5. For CRs outside the stated project scope, The City of Hemet will authorize budget allowance and payment, on a time and materials basis, for XTGlobal to perform the initial analysis of a requested change.

6. XTGlobal shall coordinate any changes in hardware, network, software, configuration, or Services with THE CITY OF HEMET. The City of Hemet may defer the change based on impact to business operations.

7. The City of Hemet will be responsible for any additional hardware or software costs associated with the implementation of Single Sign On (SSO) integration with LDAP.

8. XTGlobal and The City of Hemet shall work in good faith to resolve disputes regarding the In-Scope or Out-of-Scope classification of work, using the Issues Management process above.

9. Sample Change Request Form

10.The City of Hemet and XTGlobal will complete the Change Request Form in below table for each change that is required to the project baseline during the life of the project.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,

6. Technology Overview
Table A: RASCI Chart Definitions
Code Role Role Detail Description Notes on Use
R Responsible Individual operationally responsible for
performing a program activity.

Responsible individuals report to the
Accountable individual.

Only one individual is
responsible for any given
activity.

Responsible is a proactive
role.

A Accountable Individual with final accountability for
the results of a program activity.

Accountability includes the mandate to
dismiss or accept the results per
activity as realized by the Responsible
individual.

It also holds the budget to back the
mandate.

Only one individual is
Accountable for any given
activity.

Accountable is a reactive
role.

S Supportive Individuals who support the
Responsible individual in realizing the
program activity. They actively
participate in realizing, executing, and
performing the activity.

Supportive individuals report to the
Responsible individual.

Multiple individuals can
participate in support of
the Responsible
individual for any given
activity.

Supportive is a proactive
role.

C Consulted Individuals who should be Consulted in
realizing, executing, and performing
the activity, on the scope, execution,
and result of the activity.

Multiple individuals can
require to be heard for
any given activity.

Consulted is a reactive
role.

I Informed Individuals who need to be Informed,
but have no role in the realization,
execution, and performance of an
activity, other than being Informed on
the result of the activity.

Multiple individuals can
be Informed on the
results of any given
activity.

Informed is a passive
role.

This RASCI model allows for the combinations of responsibilities per role, per activity shown in Table B:

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Table B: Additional Role Combinations
Code Role Role Detail Description Notes on Use
AR Accountable
Responsible
Individual with final accountability,
budget and mandate and the proactive
responsibility to realize, execute and
perform an activity.

Quite common in
service, contract,
performance, and HR
management.

AS Accountable
Supportive
Individual with final accountability,
budget and mandate and supporting the
Responsible individual in realizing,
executing, and performing an activity.

Quite common in
program, relationship,
and risk management.

AC Accountable
Consulted
Individual with final accountability,
budget and mandate and will need to be
Consulted for the realization, execution,
and performance of an activity.

Uncommon combination
in sourcing, only in
demand management.

Scope of Services/Activities — Detailed Example using RASCI.

The scope of work for this assignment is as follows:

Table C: Sample Detailed Activity Summary and Related Responsibilities Activity
XTGlobal
THE
CITY
OF
HEMET
Third
Parties
Strategy Assessment
Confirm and refine the IT implications of THE
CITY OF HEMET' articulated business strategy.

R AS C
Confirm and refine the desired role of IT at THE
CITY OF HEMET in the context of the business
strategy.

R AS —
Conduct a high-level assessment of people,
process and technology capabilities.

R AC C
Conduct a high-level IT cost benchmarking
assessment.

R AC C
Develop a pragmatic and executable governance
structure.

R AS I
Impact Assessment of Technology Disrupter
Explore technology disrupter relevance and
adoption priority.

R AC C

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Explore potential for impact, focus on key
elements and prepare an action plan.

R AS C
Assess the organizational readiness of THE CITY
OF HEMET’ business and IT units for technology
disrupter.

R AC C
Develop strategy for using technology disrupter. R AS C Define strategy, assess how best to
utilize/prepare an action plan for the next step.

R AS C
Implement strategy. R AS S
Design, build, roll-out, review and enhance. R AS S

1. Remote Access
If any XTGlobal personnel requires remote access to the CITY OF HEMET Facilities to perform any services under this SoW, THE CITY OF HEMET is responsible for creating a secure platform for remote access by such XTGlobal personnel. At a minimum, this will consist of (a) the maximum allowed encryption supported by both THE CITY OF HEMET and XTGlobal for a VPN tunnel and (b) a terminal services environment secured and controlled by THE CITY OF HEMET with remote access granted to XTGlobal. This will allow for all Work Products and data to remain onsite in the THE CITY OF HEMET Facilities and in full control of THE CITY OF HEMET.

THE CITY OF HEMET is responsible for preventing XTGlobal from removing any Confidential Information from the THE CITY OF HEMET Facilities via remote access. At no time will THE CITY OF HEMET grant unencrypted remote access to XTGlobal.

XTGlobal will follow the THE CITY OF HEMET documented access control procedures to gain remote access to the THE CITY OF HEMET Facilities. As part of the THE CITY OF HEMET Security Procedures, the THE CITY OF HEMET will provide VPN and terminal services tools, and the necessary network and environment logins to ensure that XTGlobal consultants will never have remote access to the THE CITY OF HEMET data except through those tools and logins. XTGlobal consultants will use those tools and logins for both onsite and remote access and will not have access to THE CITY OF HEMET data, except through those tools and logins.

2. Disaster Recovery for Oracle SaaS Public Cloud Services Disaster Recovery is crucial because companies need to be able to access their information around the clock. Uptime is everything when running an application on a public cloud. Having a Disaster Recovery plan secures the business-critical processes in the event of a disaster. Its cloud-based nature ensures continuous backup and instant availability, so if a physical site becomes temporarily unavailable, there is no lag time

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
in accessing information from the cloud.

Disaster Recovery (DR) services for Oracle SaaS Public Cloud services are intended to provide service restoration capability in the event of a major disaster, as declared by Oracle. Oracle will determine whether an event constitutes a disaster requiring the execution of the DR plan for the affected service.

Oracle will work to perform DR services for Oracle SaaS Public Cloud Services as described below.

For Remote Cloud Services, Oracle will work to provide DR services for the SaaS Public Cloud Service on the underlying platform contingent on You first performing the following to support disaster recovery in accordance with the DR plan: You must provide a secondary data centre site with network connectivity of sufficient bandwidth as determined by Oracle between Your primary and disaster recovery sites; and You must purchase sufficient additional services deployed at Your secondary site for disaster recovery purposes (e.g., an adequate number and type of Oracle Public Cloud Machines and SaaS Public Cloud Service subscriptions on that platform).

Oracle Public Cloud Machine and other Oracle Cloud Services that are deployed on Oracle Public Cloud Machine as the underlying platform, are examples of Remote Cloud Services.

Recovery Time Objective: Recovery time objective (RTO) is Oracle’s objective for the maximum period between Oracle’s decision to activate the DR recovery processes described in this document to failover the Oracle SaaS Public Cloud Service to a secondary site due to a declared disaster, and the point at which You can resume production operations in the standby production environment at the secondary site. If the decision to failover is made during the period in which an upgrade is in process, the RTO extends to include the time required to complete the upgrade. The RTO objective for each Oracle SaaS Public Cloud Service is described in this document below or is otherwise stated in the service description of the applicable Cloud Service.

Recovery Point Objective: Recovery point objective (RPO) is Oracle’s objective for the maximum period of data loss measured as the time from which the first transaction is lost until Oracle’s declaration of the disaster. The RPO does not apply to any data loads that are underway when the disaster occurs. The RPO objective for each Oracle SaaS Public Cloud Service is described in this document below or is otherwise stated in the service description of the applicable Cloud Service.

The RTO and RPO objectives do not apply to customizations that depend on external components or third-party software. During an active failover event or recovery operations, non-critical fixes and enhancement requests are not supported. Oracle is not responsible for issues arising from third party software and customizations to Oracle programs and services.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Upon Oracle’s declaration of a disaster for the following services (#1-6), Oracle will commence its Disaster Recovery plan to recover the production environments of the affected Cloud Services in accordance with the following RTO and RPO Objectives.

Production services may operate in a degraded state of performance for the duration of the disaster event.

The RTO is 12 hours. The RPO is 1 hour.

1. Oracle Fusion Customer Relationship Management Cloud Service

2. Oracle Fusion Human Capital Management Cloud Service

3. Oracle Fusion Enterprise Resource Planning Cloud Service

4. Oracle Taleo Enterprise Cloud Service

5. Oracle RightNow Cloud Service

6. Oracle Big Machines CPQ Cloud Service
Upon Oracle’s declaration of a disaster for the following services (#7), Oracle will commence its Disaster Recovery plan to recover the production environments of the affected Cloud Services in accordance with the following RTO and RPO Objectives.

Production services may operate in a degraded state of performance for the duration of the disaster event.

The RTO is 5 hours. The RPO is 1 hour.

7. Oracle Field Service Cloud Service
Upon Oracle’s declaration of a disaster for the following service (#8), Oracle will commence its Disaster Recovery plan to recover the production environments of the affected Cloud Services in accordance with the following RTO and RPO Objectives.

Production services may operate in a degraded state of performance for the duration of the disaster event.

The RTO is 30 minutes. The RPO is 15 minutes.

8. Oracle Responsys Automatic Failover for Transactional Messages Cloud Service For all Cloud Services in the South America Data Centre Region, in the event of a declared disaster, Oracle will activate processes to recover the production environment of the affected Oracle Cloud Service in an alternative Data Centre Region and will work to restore production data from the most recent available backup made prior to the onset of the disaster. Although Oracle will work to recover the service promptly, the nature of the disaster may affect the time within which the service can be recovered.

The Recovery Time and Recovery Point Objectives do not apply to Oracle Cloud Services in the South America Data Centre Region.

Upon Oracle’s declaration of a disaster for the following services (#9-24), Oracle will

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
commence its Disaster Recovery plan to recover the production environments of the affected Cloud Services. Production services may operate in a degraded state of performance for the duration of the disaster event. The RTO and RPO do not apply to these Oracle Cloud Services.

9. Oracle Marketing Cloud Service

10.Oracle Commerce Cloud Service

11.Oracle Eloqua & Content Marketing Cloud Service

12.Maximiser Cloud Service

13.Enterprise Performance Management Cloud Service

14.Oracle Transactional Business Intelligent Enterprise Cloud Service

15.Oracle Transportation Management Cloud Service

16.Oracle Global Trade Management Cloud Service

17.Oracle Responsys Cloud Service

18.Oracle Social Relationship Management Cloud Service

19.Oracle Social Data & Insight Cloud Service

20.Oracle Taleo Business Edition Cloud Service

21.Oracle Taleo Learn Cloud Service

22.Oracle Customer Experience for Midsize Cloud Service

23.Oracle Human Capital Management for Midsize Cloud Service

24.Oracle Enterprise Resource Planning for Midsize Cloud Service

7. References
Current Customers
Item Response
Current Customer #1
Name DEMDACO
Employee Count
Population
Contact Name Joshua L. Wilson
Contact Telephone and Email +1 913.749.3758 and
[email protected]
Project Scope DEMDACO is an e-commerce online
platform that offers variety of products.

XTGlobal is Supporting and assisting in
enhancements of Oracle EBS R12
environments of DEMDACO, also
integrating DEMDACO’s Oracle onpremises with Oracle Cloud via OIC to leverage the business process.

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
DEMDACO and STANISLAUS COUNTY
are similar in Integration architecture
as both have a wide number of Legacy
applications that needed integration
with Oracle ERP. XTGlobal is supporting
with Technical, Functional and Admin
skillsets.

Implementation Duration
Go Live Date
System Replaced
Current Customer #2
Name MasTech Digital
Employee Count 300
Population
Contact Name James McBride
Contact Telephone and Email +1 412.490.5526 and
[email protected]
Project Scope MasTech Digital is a leading provider of
Digital Transformation IT Services.

XTGlobal assisted MasTech in
Implementing and Supporting Oracle
ERP. XTGlobal is supporting Oracle HCM
environment of MasTech and every year
since late 2019 assisting on open
enrolments, benefits, life events and
other technical or functional tasks.

XTGlobal has assisting MasTech in
break-fix on customizations. In Year
2021 XTGlobal has started
implementing integrations for MasTech
by migrating JCS based process on
Oracle ERP Cloud via OIC.

Implementation Duration 6 months
Go Live Date 1-Apr-22
System Replaced No system for some countries only
spread sheet

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Current Customer #3
Name Greystar
Employee Count 200+
Population
Contact Name Jay Suryadevara
Contact Telephone and Email [email protected] Project Scope Greystar is the global leader in rental
housing with expertise in real estate
sectors across multiple geographies.

The company's business model is
unique in its ability to own, operate, and
develop collegiate, multi-family,
corporate, and senior housing across
the globe. XTGlobal is assisting
Greystar for supporting Oracle Cloud
Projects Module.

Implementation Duration
Go Live Date Sept-2023
System Replaced
Prior Customers
Item Response
Prior Customer #1
Name American Bar Association (ABA)
Number of Employees 1200
Population
Contact Name and Title Nancy Bauer
Contact Telephone and Email [email protected] Software Scope Financial System Replacement
Implementation Duration 9 months
Go Live Date

22.H.

ERP Implementation Services - City of Hemet
XTGlobal Inc.,
Reason for Change
Prior Customer #2
Name Sinclair
Number of Employees 200+
Population
Contact Name and Title Melissa Miecznikoski
Sr. Director Business Applications &
Process Analysis Manager
Contact Telephone and Email 410-568-1525 and
[email protected]
Software Scope Sinclair is a leading Headquartered in
the Baltimore suburb of Hunt Valley,
Maryland, the company is the secondlargest television station operator in the United States by number of stations
(after Nexstar Media Group), owning or
operating a total of 193 stations across
the country in over 100 markets
(covering 40% of American
households), many of which are located
in the South and Midwest, and is the
largest owner of stations affiliated with
Fox and ABC. Sinclair also owns four
digital multicast networks.

Implementation Duration
Go Live Date 2018
Reason for Change

8. Contract Performance
Not Applicable

9. Contract Samples
XTGlobal will share these details at next level of discussion.

10. Exceptions
No

22.H.

City of Hemet, California
User Count - Financials = 110 Named, 30 Concurrent
W2 Count - Human Capital Management = 352
Software – Year 1 $ Assumptions
Financials: TBD Needs a discussion with Oracle Sales
Representative
General Ledger, Project and Grant
Accounting, Budgeting,
Purchasing, Accounts Payable,
Accounts Receivable, Capital
Assets
Cashiering
Utility Billing TBD Needs a discussion with Oracle Sales Representative
Human Capital Management: TBD Needs a discussion with Oracle Sales Representative
Human Resources
Timekeeping
Payroll
Business License TBD Needs a discussion with Oracle Sales Representative
Sub-Total - Software
Implementation Services Assumptions
Implementation Project is divided into 4 Phase where
each face team will be contributing
into configurations, data conversions,
user training, reports & integration
developments.

PHASE 1: DESIGN: which is
requirement gathering (7 Weeks)
PHASE 2: COFIGURE: Team will
configure what was agreed during
DESIGN phase (13 Weeks)
PHASE 3: VALIDATE: City of Hemet
SME’s (Subject Matter Experts) will
perform testing & XTGlobal team will
fix (if any) and XTGlobal team will
provide Training (14 Weeks)
PHASE 4: TRANSIT: Migration to
Production (7 Weeks)
Hence the cost is divided across these
4 phases of Implementation project. A
project plan is shared separately for
your review.

Data Conversion
Training
Report Development
Integration
Travel
Other
Sub-Total - Implementation USD
1,733,160.00

22.H.

Support/Maintenance -
Software Years 2-10
Assumptions
Year 2 USD
10,000.00
Needs a discussion with Oracle Sales
Representative on License cost
Year 3 USD
11,000.00
Year 4 USD
12,100.00
Year 5 USD
13,310.00
Year 6 USD
14,641.00
Year 7 USD
16,105.00
Year 8 USD
17,716.00
Year 9 USD
19,487.00
Year 10 USD
21,436.00
Sub-Total -
Maintenance/Support
USD
1,35,795.00
Sub-Total - License TBD Needs a discussion with Oracle Sales Representative
Total USD
1,868,955.00
Excluding License Cost & Change
Request Cost

22.H.

2023 SoftResources LLC
City of Hemet, CA
Vendor Responses - ERP
Software Vendor Barupon Springbrook Sprypoint
UB +Cashiering Only
Tyler Universus
PDS
XT Global
(Oracle)

1. Company
▪ Company Name BARUPON, LLC Springbrook Software, LLC SpryPoint Services Inc. Tyler Technologies, Inc. Univerus, Inc. – Primary PDS Software - Partner
XTGlobal Inc.,
▪ Contact Name and
Title
Rupa Tammabattula, CEO Bea Williams, Sr. Account
Executive
Casey Dowd – Director of Sales Jason Cloutier Troy Schake – VP Business Development
Bharat Rampally and Vice
President
▪ Contact Address,
Phone, Email
3 Burroughs, Irvine, CA 92618
Phone: 888-202-3779 Ext: 136
email: [email protected]
1000 SW Broadway Suite 1900
Portland OR 97205
[email protected]
(503) 820-6272
401-45 Queen St
Charlottetown, PE
C1A 4A4
One Tyler Drive, Yarmouth ME
04096
800.772.22.60
[email protected]
514 Kennett Pike, Ste 1
Chadds Ford, PA 19317
904-705-4147
[email protected]
2701 Dallas Parkway,
Suite 550 Plano,
TX 75093, +972 755 1800,
[email protected]

2. Company Information
▪ Public vs. Private Private Private Private Public Private Incorporated ▪ Year Founded 2014 1985 2011 1966 2008 – Blue Ocean Systems (SAP) -a division of Univerus
2009 – Univerus E&W CIS
(formerly SmartGridCIS)
2019 – Univerus Inc.
(solutions have been
serving local governments
for over two decades)
1974 – PDS Software (Vista)
1998
▪ Revenue $43 million Available upon shortlist Annual revenues of $1.59 billion (2021)
2021 Annual Gross Sales
Univerus ~20 million
PDS ~10.8 million
TBD
▪ Nearest Office to
Hemet, CA
3 Burroughs, Irvine, CA 92618 Portland, OR Charlottetown, PE, Canada Modesto CA / https://www.tylertech.com/a
bout-us/about-tyler/locations
Univerus - Corporate offices
in North America are in
Chadds Ford, PA and
Vancouver, BC.

PDS - Main support office -
Blue Bell, PA (HQ) with a
Sacramento
R = Required
I = Important
N = Nice to have
E = Explore

22.H.

Software Vendor Barupon Springbrook Sprypoint
UB +Cashiering Only
Tyler Universus
PDS
XT Global
(Oracle)
Shared Service office in
Vancouver, B.C.

3. Vendor Employee Count 279 77 6,600+ Univerus - 164
PDS - 68
500+ Employees

4. Customers on Proposed
Software
5 ▪ Total Our proposed software has been
implemented successfully by over
500 customers.
2500+ 47 2261 County of Centre, PA signed
March 2023 for proposed
Univerus/PDS software
combination.

SAP Business By Design
(SAP ByD) – 76
Univerus E&W CIS - 24
PDS – 480+
▪ Cities Our software has been
implemented by more than 100
cities across the United States.
2000+ 13 961 SAP ByD – 27
Univerus E&W CIS - 17
PDS - 15% of base
customers are Government,
Special Districts, or Quasigovernment
72 ▪ California Public
Sector
We have successfully provided our
software and services to various
public sector organizations in
California
50+ 5 165 PDS - 3 1
▪ California Cities Our software has been
implemented by more than 20 cities
in California.
100+ - 121 PDS - 2 1

5. Target Customer Profile TBD
▪ Industry Our ERP software and services are
designed to meet the needs of local
government organizations such as
cities, counties, and other public
sector organizations.

Government Municipal Utilities/ Utilities Public Sector Univerus serves Local Government/Utilities. In
addition to Local
Government/Utilities, PDS
also serves Non-Profit,
Manufacturing, Healthcare,
and Retail.

TBD

22.H.

Software Vendor Barupon Springbrook Sprypoint
UB +Cashiering Only
Tyler Universus
PDS
XT Global
(Oracle)
▪ Sizing: User Count and
Population
Our software can accommodate
organizations of all sizes, from small
cities with less than 10,000
residents to large metropolitan
areas with over 1 million residents.

The number of users and
population size of the organization
will not be a limitation to the
implementation of our software.
3000+, Population 300-100,000 Users = 5 – 150
Population = 7500 – 200,000
(accounts)
Scalable products with the
smallest jurisdiction (Loving
County, Texas, with a
population of 82) to the
largest (Los Angeles County,
California, with a population
of 10.1M)
Univerus focuses on Local
Government in the midmarket range of 10,000 to
250,000 population.

Utilities focus between
7,500 to 75,000 consumers.

PDS focus is 200-10,000
employees.

TBD

6. Implementation Model:

Direct or Partner
We offer both direct and partner
implementation models to meet
the needs of our clients. Our direct
implementation model involves our
team of experts working directly
with the City of Hemet to
implement the ERP software and
services. On the other hand, our
partner implementation model
involves partnering with a trusted
third-party service provider to
deliver our software and services to
the City of Hemet.

Partner Direct Direct Direct Direct

7. Version Schedule TBD
▪ Proposed Version and
Release Date
Our proposed version is BaRupon
ERP 2023, with a release date of
August 2023.

Springbrook Cirrus, 2021 SaaS – 2023 2022.X, 2023.X SAP ByD: V22.08, August 2022
Univerus Energy & Water:

V7.5.23, January 2023
PDS Vista 7.2.3, Fall 2022
TBD
▪ Release Schedule We follow a quarterly release
schedule for our software updates
and improvements. Each release
includes new features and
functionality, bug fixes, and security
enhancements. Our support team
also provides ongoing technical
assistance to ensure our software
operates smoothly.

Springbrook releases service
packs on a weekly schedule.

These releases come with
additional documentation and a
comprehensive list of release
notes and enhancements when
upgrading to the newest
version. With the cloud
solution, these are rolled out at
no extra charge to all current
clients.

Twice Monthly Tyler application upgrades are
released quarterly. Software
corrections, known as
cumulative updates, are made
available for download
between quarterly releases.

All releases are cumulative
allowing clients to upgrade to
the latest application version
directly.

SAP ByD – Major Releases
every 2 years with patches
and bug fixes on-going.

Univerus Energy & Water –
Major Releases every
quarter with patches and
bug fixes on-going.

PDS - Minor Releases
Quarterly; Major 4-5 years.

TBD

22.H.

Software Vendor Barupon Springbrook Sprypoint
UB +Cashiering Only
Tyler Universus
PDS
XT Global
(Oracle)
▪ Number of Prior
Versions Supported
We provide support for the current
and two prior versions of our
software. This ensures that our
customers have access to the latest
features and functionality while
also maintaining support for those
who may not have upgraded to the
latest version yet.

Our Cloud subscription is on a
single release that we
update/upgrade for the life of
the subscription.

Not Applicable - SaaS 4-5 quarterly versions are
supported at any one time.

Univerus - In our proposed
SaaS environment, updates
are pushed as soon as they
are tested, communicated
and ready for release. We
prefer all clients stay on the
current release.

PDS - 2
TBD

8. Support Desk
▪ Location Our support desk is located at our
headquarters in 3 Burroughs, Irvine,
CA 92618. We have a team of
experienced support personnel who
are available to assist customers
with any technical issues or
questions they may have.

Nationwide, Remote Employees Charlottetown/ Remote Tyler’s main support offices are in Falmouth, Yarmouth,
and Bangor Maine and we
also have a strong presence
on the West Coast at our
Renton, Washington office.

Our Support Team is rounded
out with individuals located in
smaller offices in Arkansas
and Georgia, and remote staff
in various locations across the
country.

SAP ByD – Chadds Ford, PA
Univerus E&W CIS –
Alpharetta, GA, Charlotte,
NC,
Shared Service Office
Vancouver, BC
PDS - Corporate Office –
Blue Bell, PA
TX
▪ Hours of Support Our support desk is staffed 24/7 to
provide assistance to customers.

We understand the importance of
prompt and reliable support, and
we strive to provide the highest
level of service to our customers at
all times. We have a robust support
infrastructure in place to ensure
that our customers receive the help
they need when they need it,
regardless of the time of day or
night.

In addition to our support desk, we
also provide on-site support
services to customers as needed.

Our team of experienced
technicians is available to travel to
customer locations to provide
hands-on support and assistance
5 AM to 5PM PST 5am – 5pm PST
24/7 Client Portal
SLA Negotiated and agreed
upon
Support resources are
available 8:00 PM – 5:00 PM
across four standard time
zones (EST, CST, MST and PST)
and staffing is consistent to
support the volume of cases
throughout the day.

Univerus - 8AM to 8PM
Emergency 24/7/365
available via Unity Web
Portal
PDS - 8:30 am to 8:00 pm
Mon.-Thur. (5pm on Fri.)
Emergency 24/7/365 via
hot line
24X7

22.H.

Software Vendor Barupon Springbrook Sprypoint
UB +Cashiering Only
Tyler Universus
PDS
XT Global
(Oracle)
with any technical issues or
questions. We work closely with our
customers to ensure that their
needs are met and that they receive
the support and service they need
to be successful.

Pricing Summary – Summary
of RFP Section 3
Comments

9. Software License – Years 1-
10 a. Financials: 110 named
users, 30 concurrent
users
b. Human
Resources/Payroll: 352
W2s
c. Central Cashiering: 3
POS Stations, 25
named users
a. Financials: 110 named users, 30
concurrent users
Year 1: $50,000
Years 2-10: $25,000 per year
b. Human Resources/Payroll: 352
W2s
Year 1: $20,000
Years 2-10: $10,000 per year
c. Central Cashiering: 3 POS
Stations, 25 named users
Year 1: $15,000
Years 2-10: $7,500 per year
Total 1-Year Cost: $85,000
Total 10-Year Cost: $425,000
Please note that the above pricing is
an estimate and may be subject to
change based on the specific terms
and conditions of the contract.

No Restrictions, unlimited users SaaS proposal / no license fees.

Annual SaaS fees:
1) 258,565
2) 258,565
3) 258,565
4) 266,321
5) 274,311
6) 282,540
7) 291,071
8) 299,747
9) 308,740
10) 318,002
a. $1,172,914
b. $1,169,744
c. $767,715
Included in a & b
Agreed

10. Implementation: Estimate
for implementation,
process review, design,
data conversion,
configuration, training,
report development,
integration, travel.

Process review and design: $20,000
Data conversion: $30,000
Configuration: $50,000
Training: $40,000
Report development: $25,000
Integration: $35,000
Travel: $15,000
Total: $215,000
See Included Implementation
Timeline Packet
$553,123 $735,015
Exhibit A pricing will provide
full details of this Pricing
Summary.

Project is divided into 4 Phase
where each face team will be
contributing into
configurations, data
conversions, user training,
reports & integration
developments.

PHASE 1: DESIGN: which is
requirement gathering (7
Weeks)
PHASE 2: COFIGURE: Team
will configure what was
agreed during DESIGN phase
(13 Weeks)
PHASE 3: VALIDATE: City of

22.H.

Software Vendor Barupon Springbrook Sprypoint
UB +Cashiering Only
Tyler Universus
PDS
XT Global
(Oracle)
Hemet SME’s (Subject Matter
Experts) will perform testing
& XTGlobal team will fix (if
any) and XTGlobal team will
provide Training (14 Weeks)
PHASE 4: TRANSIT: Migration
to Production (7 Weeks)
Hence the cost is divided
across these 4 phases of
Implementation project. A
project plan is shared
separately for your review.

11. Maintenance – if OnPremise:
d. Year 1
e. Years 2 – 10
d. Year 1: $60,000
e. Years 2-10: $40,000 per year
The actual pricing may vary
depending on various factors such
as the scope of services, the
complexity of the implementation,
and the specific needs of the City of
Hemet.

N/A SaaS proposed. N/A - Cloud Based SaaS
Model Proposed
Year 1: USD 10,000.00
Years 2-10: USD 1,35,795.00

12. Total 1-Year Cost –
Software, Implementation,
SaaS, or Maintenance
Software License – Year 1: $500,000
Implementation: $1,000,000
Maintenance – Year 1: $100,000
Total 1-Year Cost: $1,600,000
Please note that this is an estimate
and actual pricing may vary
depending on the specific needs
and requirements of the City of
Hemet, as well as any negotiations
or adjustments made during the
proposal process.
$262,529.00 Software – No license fees
Implementation is billed as
incurred and is dependent on
phasing. Needs additional
conversation.

Year 1 SaaS fees will replace
Eden maintenance fees. We do
not charge for two systems at
the same time. Year 1 SaaS
fees = $258,565.00
$982,304 USD 1,733,160.00

13. Total 10-Year Cost –
Software, Implementation,
SaaS, or Maintenance
Software License: $1,500,000 (for
10 years)
Implementation: $1,200,000
SaaS License: N/A (assuming OnPremise)
Maintenance:

Year 1: $300,000
Years 2-10: $200,000/year
Total 10-Year Cost: $4,100,000
(With Annual Uplift of 7%)
Yr 2: $98,466.75 Annual
Subscription
Yr 3: $105,359.42 Annual
Subscription
Through year 10 – only the
annual uplift will be applied to
renewal invoices.
3,369,499.00 $3,845,387 USD 1,35,795.00

22.H.

Software Vendor Barupon Springbrook Sprypoint
UB +Cashiering Only
Tyler Universus
PDS
XT Global
(Oracle)
Please note that this is an estimate
and actual pricing may vary based
on specific requirements,
negotiations, and other factors.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
Modules
R 14. General Ledger Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, General Ledger (GL) serves as
a robust, feature-rich
foundation for the Springbrook
suite of applications. This
intuitively designed application
provides the functionality
needed for more informative
online analysis and financial
reporting. The flexibility of the
application provides a stable
foundation for current
operations as well as future
growth. Complete integration
with the Springbrook suite of
applications allows for easy and
thorough consolidation of all
financial activity.
• Documents can be
attached to Journal
Entries and General
Ledger accounts.
• General ledger module
also features robust
and powerful report
writing tools including
the ability to create
GASB Reporting
(budgetary and GAAP
reporting)
• Maintenance/Utilities –
create and maintain GL
units and execute
0 4
Please refer to Enterprise ERP
Accounting Product Overview
for additional information.
4 – GL is a core module of
our ERP solution
Rating 4

22.H.

Page
8 of 93
Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
specialized GL tools.
• Uniform Chart of
Accounts – allows for
multiple funds and
departments to be
utilize.
• Configurable Imports
for Journal Entries,
Adjustments and Misc.
trans- actions are
available.
• Budget Adjustments –
adjust budget values on
a GL account.
• New Budget Info – edit,
maintain, and report on
GL budgets.

Display history information at
the account level can be
drilled down to the source
R 15. Budgeting Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, Springbrook Budgeting is a
comprehensive tool used to
generate a requested, proposed,
approved, or adopted budget.

This process allows you to: • Track budget revisions • Add attachments such as budget documents
to the budget amounts.
• Group general ledger
accounts to create
budgets for
department heads.
• Create and document
budget adjustments.
• Create period budgets. • Budgeted amounts can
also be imported from
and exported to
Microsoft Excel, which
allows you to
04 Please refer to Enterprise ERP
Budgeting Product Overview
for additional information.
4 – Budget is a core
module of our ERP
solution
Rating 4

22.H.

Page
9 of 93
Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
manipulate the budgets
in a spreadsheet and
then import the budget
amounts back into the
Extended Budgeting
process.

R 16. Purchasing Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, The Purchase order module
provides internal controls and
access for agencies to create
and send purchase orders to
vendors. It also provides
approvals through workflows
if the agency would like it setup that way. Overall, the purchase order (PO) is where
the approval and buying
happens and once the
purchasing or procurement
department has approved the
purchase requisition and given
you the figurative thumbs up
to purchase your desired
goods and services, it issues a
purchase order number, and
the purchase order can be
sent to the vendor through
our AP invoicing module
04 Please refer to Enterprise
ERP Purchasing Product
Overview for additional
information.
4 – Purchasing is a core
module of our ERP
solution
Rating 4
R 17. Accounts
Payable
Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal..
4, Springbrook Accounts Payable
helps to manage the money
owed to vendors. Here, you
can:
• Enter invoices for
accounting records if
they are not already
being created from out
other integrated
modules.
• Schedule invoice
payment
• The Electronic AP
04 Please refer to Enterprise ERP
Accounts Payable Product
Overview for additional
information.
4 – Accounts Payable is a
core module of our ERP
solution
Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
process allows you to
pay vendors
electronically using
ACH transactions rather
than generating a
physical check in the
Computer Checks
process.

R 18. Accounts
Receivable
Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, The Accounts Receivable
module provides a
comprehensive system for
creating and maintaining all
information pertinent to
recording and tracking customer
data, invoices, and balances.

Here are a few AR features:
• Allows users to search
for invoices by multiple
methods, including by
invoice number,
customer number or
customer name.
• Accommodates
multiple line items and
multiple revenue
distributions for each
invoice.
• Allows user to set up
and make use of
recurring invoices.
• Provides analysis of
invoice information by
department, activity,
items/services, age,
etc.
• Creates statements for
new invoices as
processed and includes
option to provide
customers with regular
0 4
Please refer to Enterprise ERP
Accounts Receivable Product
Overview for additional
information.
4 – Accounts Receivable is
a core module of our ERP
solution
Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
statements, regardless
of account activity.
• Prints statements from
history for a single
invoice or range of
transactions.
• Allows user to set up
and use individual
billing types to allocate
revenue to various GL
accounts.

Provides exhaustive
transaction history of
customer accounts including
aged balances
R 19. Project and
Grant
Accounting
Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, Some call it project
accounting or grant
management, the PM module
is used to gather transactions
form other modules and
generate reports summarizing
the information. PM is
integrated pulling transactions
generated in other modules
like AP, AR, CR, GL, IC, PR, PO,
ESS, WO. Basically, these
transactions are sent to the
PM module by including a PM
task and type code on the
transactions. It can be used for
very basic, simple projects or
large complex projects that
span over multiple years
0 4
Please refer to Enterprise
ERP Project & Grant
Accounting Product
Overview for additional
information.
4 – Project and Grant
Accounting is a core
module of our ERP
solution
Rating 4
R 20. Utility Billing Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, Utility Billing (UB) module is a
straightforward, yet flexible
suite really makes life easy for
you and for your customers
easily configured to work with
third party billing companies, or
as a complete end-to-end billing
wizard for a wide variety of

4. Proposing Best of Breed CIS/
Utility Billing solution and
supporting modules.
4 Please refer to Enterprise
Utility Billing Product
Overview for additional
information.
4 – Utility Billing module is
provided by Univerus

E&W CIS
Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
utility services. • Backflow
maintenance/tracking
capabilities
• Third Party Meter
Reading import/export
capabilities
• Meter Management • Ability to define
account policies for
effective tracking and
report of customer
information.
• Fee Codes, tax codes,
penalties and deposits
can be tracked and
maintained.
• Consumption tracking
and reporting
• Adjustment processing
to accounts
• Processing of payments
from CivicPay
integration available
• Winter averaging
capabilities
• Service Requests • Lot management • Robust reports & Tools CivicPay is a comprehensive
payment solution that
integrates seamlessly into the
entire Springbrook Suite.

While reducing time, steps,
and errors to improve
collection of payments and
provide citizens with the
fastest, easiest and safest bill
paying experience, CivicPay
remains PCI compliant and
allows customers easy login to
view their usage, request

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
services, set up recurring
payments and so much more.

R 21. Cashiering/Cas
h Receipts
Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, The Cash receipts is where
all payments are entered for
the system. They can be
imported, scanned, or entered
manually.

4. Cashiering is included with
SpryCIS
4 Please refer to Enterprise
ERP Cashiering Product
Overview for additional
information.
4 - Cashiering is a core
module of our ERP
solution
Rating 4
R 22. Capital Assets Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, The Fixed Assets Module
allows you to accurately track
the value of your fixed assets
from the date of purchase to
the final disposal. This process
involves a series of steps.

From creating inventory items,
updating physical counts,
generating GL and other
financial processing, to hosting
and reporting the detailed
historical data, costing data,
and vendor information, such
as pricing history and ordering
requirements. Springbrook’s
inventory control module is
designed to accommodate
diverse needs in controlling,
maintaining, and reporting on
your inventory
0 4
Please refer to Enterprise
ERP Capital Assets Product
Overview for additional
information.
4 – Capital Assets is a core
module of our ERP
solution
Rating 4
R 23. Business
License
Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, The License and Permit
Module was originally
designed in Springbrook for
recording and tracking of
business licenses that serve
the city. Over the years, we
have expanded this module to
be able to tackle a vast
majority of permits that a city
may need to track (garage sale
permits, street vendors,
vehicle sticker permits, pet
0 4
Please refer to Enterprise
ERP Business Licenses
Product Overview for
additional information.
0 - Will integrate with the
City’s vendor of choice
Needs a discussion with
Oracle Sales
Representative

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
licenses, contractors and much
more).

R 24. Human
Resources
Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, Human Resource
Management application that
connects HR information
directly to payroll records for
maximum efficiency when
managing payroll without
requiring double entry
0 4
Please refer to Enterprise
ERP Human Resources &
Talent Management Product
Overview for additional
information.
4 – Core module of Vista
suite
Rating 4
R 25. Time and
Attendance
Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, Time and Attendance can
be captured in either the ESS
or the Payroll Module itself.

Whether you prefer clocking in
and out, detailing hour to hour
project or departmental
distribution, our timekeeping
options will meet the needs of
most.
0 4
Please refer to Time and
Attendance Product
Overview for additional
information.
4 – Core module of Vista
suite
Rating 4
R 26. Payroll Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, The Springbrook Payroll
Module is designed not only to
pay employees, but also to
create batches to some of our
other integrated modules
based on the payroll processes
we complete
0 4
Please refer to Enterprise
ERP Payroll Product
Overview for additional
information.
4 – Core module of Vista
suite
Rating 4
R 27. Reporting Rating: 4, Comment: This
requirement is supported in the
proposed version and can be
implemented out of the box or
with configuration included in this
proposal.
4, Tableau is the industry
leading reporting software
that enables fast, customized,
easy to develop and interpret
visualizations supporting
virtually any local government
data reporting need. Tableau’s
software will provide your
agency with a host of
important advantages that
collectively deliver a
comprehensive interactive
view of programs, budgets,
and high-level trends.

4. Metebase reporting tools
is embedded in SpryCIS for
reports and dashboards
4 Please refer to Enterprise
Analytics & Reporting
Overview for additional
information.
4 – Core module of the
entire ERP solution
Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
Additionally, Tableau will
provide the reporting
capabilities necessary to
deliver analysis that may
become necessary for any
government entity that
received relief funding.

Tableau is pre-configured with
the most popular templates,
and provides access to a
growing library, composed of
templates culled from all other
local government agency
users. Tableau is easy to use,
capable of delivering results in
minutes and provides report
automation deliverable across
any platform or device. Take
advantage of what hundreds
of major cities, states and
government agencies are
already using. Tableau is a
leader on the Gartner Magic
Quadrant, is InfoWorld
Technology product of the
year and is offered free of
charge to all Springbrook
cloud customers...including
your agency.

Technology
R 28. Preference for
SaaS platform
deployment,
open to on
premises.

Rating 4: The software supports
both SaaS platform deployment
and on-premises deployment out
of the box.

SAAS, Browser Based Solution 4. SaaS Only 4
Tyler software-as-a-service
(SaaS) solutions are
subscription-based cloud
applications running on AWS,
the world’s most
comprehensive and broadly
adopted cloud platform.

Applications are available
securely
from any internet connection,
4 - Proposed Cloud Based
SaaS Model
Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
anywhere, anytime. Tyler
Technologies manages all
client hosting operations,
including application upgrades
and platform administration,
providing clients with a single
point of contact for all
software and hosting needs.

Clients receive clear and
concise documentation,
defining all aspects of the
relationship including
contract (commitment to
partner) and service level
agreement (measurable
expectations of availability).

R 29. Run on virtual
machines e.g.,
VMware/Nuta
nix if on
premises.

Rating 4: The software can run on
virtual machines such as
VMware/Nutanix if on premises.
4, Able to access anywhere
anytime with internet access

0. Not Applicable 0
Not applicable, SaaS
proposed
4 - Proposed Cloud Based
SaaS Model
Rating 4
R 30. Multiple
environments:

Production,
Test, Train,
Development.

Rating 4: The software supports
multiple environments including
Production, Test, Train, and
Development.
4, Springbrook will provide a
training sandbox to play in, in
addition to the production and
development systems that are
in existence.

4. Production, Staging,
Training (general
deployment).
4 Live, Train, Test, and
Implementation available
with standard deployments
4 - Production and Test
are included by default.

Additional environments
are available as requested
at additional cost. PDS
offer this for core
systems.

Rating 4
R 31. 100% Webbased
architecture.

Rating 4: The software has a 100%
web-based architecture.
4, Browser Based Architecture
on Microsoft Azure

4. Yes. 4
Tyler applications are built
and tested on the latest
HTML5 standards and
should be compatible with
any modern browser.
4 - The applications are
100% web-based
Rating 4
R 32. Role-level
security to
menu,
function, and
field level.

Rating 4: The software has rolelevel security to menu, function, and field level.
4, Springbrook offers a robust
selection of security controls
that can help lock down or
provide access to roles,
menus, functions, fields and

4. Role/ User based security 4
Role based security
supported. Select field
level.
4 - We have robust
functionality to create
users and set permission
levels. Permissions are
assigned to roles and each
Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
more. user can be assigned to
one or more roles. There
can be as many roles
defined as required by the
organization. Our solution
provides versatility when
setting permissions for
each role, including the
ability to set rights to
view, print, copy, access
to selected data only,
read-only access, data
access based on
departments, etc.

R 33. Integration
with Office 365
GCC - Word,
Excel,
Calendar,
SharePoint,
Teams.

Rating 3: The software can be
integrated with Office 365 GCC
using third-party software such as
Layer2.
4, Springbrook’s Browser
Based Cirrus product is built
on Microsoft Azure and can
seamlessly integrate with
other Microsoft products

4. Full single click export to
O365
4 Select integration where
available. Ie Word, Excel.
4 – Integration with Office
365 is provided
Rating 4
R 34. Microsoft 365
GCC Exchange
Server
interface for
email
notifications.

Rating 3: The software can
integrate with Microsoft 365 GCC
Exchange Server for email
notifications using third-party
software such as One Identity.
4, Springbrook’s Browser Based
Cirrus product is built on
Microsoft Azure and can
seamlessly integrate with other
Microsoft products
F. Not currently integrated to
Exchange – Future release
4 Many Tyler applications
include support for popular
calendaring systems
including Microsoft Outlook
and Exchange. Email
notifications and alerts can
be sent using most email
servers, including Microsoft
Exchange
4 – Integration with Office
365 is provided.

Rating 4
R 35. Single sign-on:

MS Active
Directory on
Premises, MS
Azure sync in
the Cloud.

Preference for
two-factor
authentication.

Rating 4: The software supports
single sign-on with MS Active
Directory on Premises and MS
Azure sync in the Cloud. Twofactor authentication can be implemented with additional
configuration.
4, Springbrook is built on MS
Azure and can provide
multifactor Authentication as
well as SSO capabilities

4. Full SSO integration 4
Identity Workforce is a zerotrust, cloud Identity-as-aService (IDaaS) solution for Tyler’s back-office
applications. Built on Okta,
the industry leader in identity
management, Identity
Workforce enables secure,
4 – Our system supports
SAML 2.0 and OAuth 2.0
SAML Bearer
authentication.

Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
cloud-based authentication
for all users, regardless of
location, device, or network.

Identity Workforce supports
federation with industry
standard identity providers
(IdP’s) providing clients with
seamless, single sign-on
across all Tyler back-office
solutions. This also enables
clients to use their own login
and password policies,
including the use of
multifactor authentication for
enhanced identity verification.

The Tyler Identity User Store
can be used to create and
manage accounts that do not
exist in the client’s IdP, such
as contractors or seasonal
staff, or clients without a
supported IdP.

The following identity
providers (IdP's) are
currently supported for use
with Identity Workforce:

Microsoft Active Directory
through Azure AD, ADFS or
Okta AD agent, Google
Cloud Identity, Identity
Automation RapidIdentity,
and Okta. Support for
additional IdP's may require
additional costs, available
upon request.

R 36. List integration
technologies,
e.g., Web
Services, SOA,
XML, etc.

Rating 4: The software supports
various integration technologies
such as Web Services, SOA, XML,
etc.
4, Springbrook offers an Open
API for integrations with other
technologies

4. REST API, XML, JSON etc
supported
4 Tyler solutions offer a
variety of methods of
interfacing with external
third-party systems,
including file-based import
and exports and real-time
4 - All integration
technologies supported
Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
web service integration
through plug-and-play App
Connectors, and API Toolkits
and Connectors.

Tyler Integrated Solutions
Tyler’s family of ERP and Civic
solutions provide robust,
native integration, eliminating
the need to manage thirdparty interfaces and
integrations entirely. This
includes Enterprise Permitting
& Licensing, Enterprise
ERP, Enterprise Asset
Management, Cashiering and
Payments for point-of-sale
and online payment
processing, Content
Manager’s streamlined access
to records and documents,
and Enterprise Service
Request Access to manage
non-emergency inquiries,
incident reporting,
complaints, and service
requests.

File-based integration
Multiple file-based interfaces
are included, and all are
integrated as part of the
application, designed for end
users. Unlike systems that
require a database
administrator to import or
export data with their system,
users can easily import or
export data through pointand-click user interface. Userdefined templates specify the data layout for a specific
system, so users can quickly
choose the appropriate
template at the time of

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
import/export. Templates for
commonly used third-party
systems are also included out
of the box. File-based
interfaces can be scheduled
for one-time or recurring,
automated processing.

Imports can be configured
with Workflow to send
automated notifications or
approval requests before the
data updates a
record. Workflow business
rules can be set on a variety of
data conditions specific to the
imported data. This includes if
data causes an account to go
over budget, is over a certain
dollar amount, or is related to
a specific segment of your
general ledger. Only after all
workflow rules have
been approved does the
import update production
data. Depending on the
process, imports can also be
rejected at the item or file
level; rejected imports can be
resubmitted at any time.

Productivity Software Support
Application data can be
downloaded to a variety of
formats including PDF, XLS,
DOC, XML, and CSV. Any
productivity suite capable of
opening these file types can
be used, such as Microsoft
Office and Google Workspace.

Data can also be uploaded to
the system in these formats
through the integrated import
applications.

Most output include

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
hyperlinks to the
corresponding application
record for easy access. Most
output can also be
automatically archived to
Content Manager for quick
retrieval at any time. Some
applications also include mail
merge support, allowing users
to easily create and maintain
form templates for
completely customized
presentation of application
data. Any SMTP/IMAP server
can be used to send email
notifications, such as
Microsoft Exchange and
Gmail.
‘Plug-and-Play’ Application
Support
Plug-and-play application
support provides out-of-thebox integrations for a variety of third-party applications
through pre-packaged web
services. Tyler develops and
maintains these integrations,
requiring no development
expertise from the client to
configure.

API Catalog
API (Application Programming
Interface) Toolkits and API
Connectors add value to your
organization by enabling you
to create your own
integrations to share data
between Tyler and non-Tyler
applications.

API Toolkits contain all
exposed resources (or
endpoints) available in a
specific Tyler application

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
module such as Enterprise
ERP General Ledger, Accounts
Receivable, or Enterprise
Asset Management. API
Connectors contain a subset
or cross-section of API Toolkit
resources with the purpose of
facilitating a specific type of
integration such as third-party
cashiering, IVR, or applicant
tracking systems.

The API Developer Portal is a
powerful RESTful API gateway
that makes accessing Tyler
application data and
processes through Toolkits
and Connectors easy and
intuitive. The Portal conforms
to OpenAPI 3.0 and is secured
with OAuth 2.0 through Tyler
Identity. API resources include
example calls and produce
properly formatted
commands, allowing you to
easily exercise them against
your data.

The API Developer Portal
features include: • Simplified, structured API
documentation
• Industry standard
OpenAPI 3.0 interface
• Authentication using
OAuth 2.0 standard,
offering multiple login
flows to suit different app
implementation
scenarios.
• Data models and
examples for each
resource
• Produces HTTP URI and

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
CURL commands to
exercise resources from
within the documentation
and return data
• Real-time validation
• Standard HTTP status
codes
• Documentation to aid in
identifying and
understanding normal
resources used to
complete a given
integration.

R 37. Review
proposed
approach to
integration
with the
following:

Rating 4: The software supports
both SaaS platform deployment
and on-premises deployment out
of the box.
- Rating 4
R a. Cartegraph
EAM –
Service
requests to
Work
Orders, CIP,
Fleet
(Cloud)
Rating 3: The software can
integrate with Cartegraph EAM
using third-party software such as
Cartegraph Connector.
4, Springbrook supports
imports and exports from the
WO module to support Service
request creation as well as
tracking activity on WOs and
fleet maintenance activities.

4. Existing integration to
Cartergraph Outage
Management System.
0 A built-in integration with
Cartegraph is not currently
supported, however the
optionally proposed UB
Open API toolkit could be
leveraged by a third party to
develop an integration using
inbound-only web services
to retrieve and update work
order information in EERP.

This would not include CIP
or Fleet.
4: Our solution offers Web
API’s to achieve third-party
integration.

Note: Univerus also has
an EAM module, Univerus
Assets (asset
management, work
orders, fleet
management).

Rating 4
R b. Telestaff –
scheduling
and
timekeepin
g for Police
and Fire
OnPremises
Rating 4: The software can
integrate with Telestaff out of the
box.
4, Springbrook allows for the
import of Timecard
information from 3rd party
systems directly into the
payroll process.

Not Applicable 4
Supported assuming desire
is time sheets from Telestaff
to EERP for processing
assuming use of compatible
file formats.
4: Our solution offers Web
API’s to achieve third-party
integration.

Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
(Police),
Cloud (Fire)
R c. Harmony
– meter
reads,
account
updates
Rating 4: The software can
integrate with Harmony out of the
box.
4, Springbrook supports
several formats for meter
reads out of the box, and has a
configurable utility available
for supporting additional types

4. 4
This is supported, assuming
use of compatible meter
reading export/import
formats.
4: Our solution offers Web
API’s to achieve thirdparty integration.

Rating 4
N d. Tokay –
Water
backflow
(onpremises)
– status
lookup for
new
account
setup
Rating 4: The software can
integrate with Tokay out of the
box.
2, This might be accomplished
via the Open API, or it might
be a service request look up –
We would need to discuss
details further

4. Existing integration with
Tokay backflow.
4 The EERP Utility Billing
Solution offers a built-in
backflow tracking system,
however some custom, oneway exports to Tokay have
been created. Some
customization could be
required if existing customer
export formats cannot be
leveraged.
4: Univerus offers Web
API’s to achieve thirdparty integrations.

Rating 4
R e. NeoGov –
Recruiting,
onboardin
g,
evaluation
tracking
Rating 4: The software can
integrate with NeoGov out of the
box.

F, we do not currently offer an
integration with NeoGov, but
an API for applicant tracking
integration is on our roadmap
for the 2nd half of 2023
Not Applicable 4
Integration available via
compatible import/export
files and/or optionally
proposed Recruiting API
Connector
4: Our solution offers an
integration to NeoGov
Rating 4
R f. SirsiDynix
Horizon –
Library
System
Rating 4: The software can
integrate with SirsiDynix Horizon
out of the box.
2, This might be accomplished
via the Open API
Not Applicable 4
Import assuming use of
compatible import file
formats where applicable
4: Our solution offers Web
API’s to achieve thirdparty integrations.

Rating 4
R g. CentralSq
uare
Enterprise
Permitting
(TRAKiT)
or
replaceme
nt solution
–
Rating 3: The software can
integrate with CentralSquare
Enterprise Permitting (TRAKiT)
using third-party software such as
TRAKiT Connector.
2, This might be accomplished
via the Open API
2 – Will require Further
discussion
4 Replacement -Tyler offers a
fully integrated Enterprise
Permits solution. Please see
Tyler’s response to the City’s
Permitting, Planning, Land
Management Software and
Implementation Services
RFP for additional details
0: We will work with the
chosen vendor to
coordinate integration
Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
Permitting
and Land
Managem
ent,
about our Tyler Enterprise
permitting solution.

I h. Laserfiche
–
Document
Managem
ent
Rating 4: The software can
integrate with Laserfiche out of
the box.
4, We have an existing
integration to Laserfiche built
by a company called
Citiesdigital. The product is
called Unfetterfiche, and it
works with the enterprise
product.

4. Existing integration with
Laserfiche – Document
management
0 Replacement proposed –
Tyler’s Enterprise ERP and
Asset Management solutions
do not include direct
integration with third-party
Enterprise Content
Management (ECM) solutions.

Tyler has proposed Content
Manager, an integrated
content management
solution, to electronically
capture, manage, and retrieve
all documents related to Tyler
applications.

Content Manager includes a
document extract utility to
automate document and
metadata export to a file
system that clients can use to
import to a separate thirdparty ECM solution. Retrieval of content stored in thirdparty ECM solutions directly from Enterprise ERP and Asset
Management applications is
not supported.

Tyler recommends using the
fully integrated Content
Manager solution that was
built into the Enterprise ERP
and Asset Management
solutions. Anything
generated out of Enterprise
ERP and Asset Management
is automatically stored and
indexed back to the
corresponding records
4: Our solution includes an
integrated document
management system; we
have integrated to
LaserFiche in the past
however we provide several
of the features within the
core ERP that most
customers elect to use
instead of building an
integration.

Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
without any user
intervention.

R i. Esri ArcGIS
– Meter
Locations,
Latitude/L
ongitude,
Assessor
Parcel
Number
(APN).

Rating 4: The software can
integrate with Esri ArcGIS out of
the box.
2, This might be accomplished
via the Open API

4. Existing integration with
Esri ArcGIS
4 Integration with ESRI
available via optionally
proposed Enterprise GIS
4: Our solution offers Web
API’s to achieve thirdparty integrations.

Rating 4
R 38. Mobile
functionality
and devices
supported. iOS
required. App,
HTML5 and
Responsive
Design.

Rating 4: The software supports
mobile functionality and devices
with an iOS app, HTML5, and
Responsive Design.
4, Our system is fully browser
based and can be access on
mobile via the internet

4. Full responsive design/
available app.
4 Proposed EERP solution
allows for mobile
compatibility
4: Our solution is available
for devices such as
laptops, tablets, and
smartphones (Android
and iOS).

Rating 4
General
R 39. Real-time
integration
across all
modules.

Specify
exceptions.

Rating 4 - Real-time integration
across all modules is standard and
available in the proposed version.
4, Springbrook is a fully
integrated ERP with industry
leading process built among
our many modules.

4. Real-time integration
available among all SpryPoint
solutions as well as the
following:

FIS system (GL, AP, AR)
Payment Processor
4 Proposed Enterprise ERP
solution is fully integrated.
4 – Each module proposed
is fully integrated creating
a complete ERP suite.

Rating 4
R 40. Configurable
role or user
level
dashboards
including
favorites,
notifications,
reports, etc.

Rating 4 - Configurable role or
user level dashboards are
standard and available in the
proposed version.
4, System Wide Access
provides the client with a
variety of configurations and
security settings that allow for
customized roles, groups,
dashboards, workflows,
notifications and more.

4. Full dashboard capabilities,
user/ role based
4 Supported via Hub
Dashboard.
4 - Our ERP suite has a
robust dashboard feature
that allows your team to
configure dashboard
metrics and reports that
they need for their specific
roles. Each metric or report
by default supports drill
down to source transaction
data.

Rating 4
R 41. Unlimited Rating 4 - Unlimited user-defined 4, Springbrook provides user 4. Fully configurable 4 4 - The system allows you to Rating 4 Page 762 of 829

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
user-defined
fields that can
be used in
queries and
reports.
fields that can be used in queries
and reports are standard and
available in the proposed version.
defined fields throughout the
platform to ensure all
information is captured in the
proper area to the client’s
expectations
User defined fields is one of
the primary methods users
can customize the EERP suite
to their specific needs and
business practices.

Administrative options
include the order of the field,
screen name, data type, size,
status, requirement, and tool
tip. A customizable code
table exists for any drill down
data types.

User Defined fields are
available in select
applications and presented
to the end user in a
dedicated tab on program
screens. All fields and
associated codes are
contained in the client
database and are not
impacted by patches or
upgrades.
create unlimited user
defined fields and
descriptions on any data
entity in the application.

R 42. Mask sensitive
fields or
restrict access,
e.g., Social
Security
Number.

Rating 4 - Masking sensitive fields
or restricting access is standard
and available in the proposed
version.
4, Springbrook can accomplish
this via our tag security
feature

4. Fully configurable
encryption capabilities
4 Where available via Rolebased security. Select field level security, ie SSN.
4 – Menus, fields and
work centers are
presented to the user
based on their access
rights ensuring they only
see what is required for
the operation of their
role. Screen specific level
overrides allow global and
user specific changes to
the user screens and
creation of custom fields
to support your business
needs as necessary.

Rating 4
I 43. Define
mandatory
fields on
screens, web
Rating 4 - Defining mandatory
fields on screens, web forms,
mobile apps, etc. is standard and
available in the proposed version.
2, We don't offer this
functionality, but sometimes
workflows can be used as a
'back up validation' to

4. Fully configurable 4
Mandatory fields can be
defined on custom forms
such as applicant forms.
4 - Fields can be isolated to
a specific data entity based
on your business needs or
can be extended to other
Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
forms, mobile
apps, etc.
accomplish the same thing data entities to be able to
print on reports or forms as
required.

R 44. Rules based
workflow
routing with
prioritization,
alerts,
electronic
signatures, and
visible
approval
queue.

Rating 4 - Rules based workflow
routing with prioritization, alerts,
electronic signatures, and visible
approval queue is standard and
available in the proposed version.
4, Springbrook workflows and
notifications allow for multiple
layers of routing,
prioritization, filters, alerts and
notifications (all visible to
those who are able to see
them based on security).

4. Fully configurable 4
Enterprise ERP Workflow is a
comprehensive system
engineered to meet the
specific needs of the public
sector. It extends the
functionality and productivity
of the EERP system by
automatically notifying the
indicated end users when
action is needed, rather than
requiring them to look it up
manually.

The workflow system includes
an extensive approval engine,
monitoring hundreds of
processes throughout the
system. Approvals, alerts, and
notifications are generated to
users dynamically based on
the business rules created.

Flexible business rule creation
allows for universal,
sequential and parallel preapprovals, and “one or all” rules. Catchall rules can be
created to ensure that some
approvals are generated even
when no rules apply.

Workflow for key processes,
such as payroll processing,
can be configured to prevent
users from doing things out of
order. Routing and approval
criteria containing “and/or”
logic for building complex
rules include dollar amount
ranges, GL segment, over
budget conditions, and more.
4 - Our solution ships by
default with best practice
workflows and business
processes, that support
electronic routing of tasks
throughout the necessary
staff in each department.

Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
Workflow users can receive
and act on notifications,
approval requests, and alerts
several ways including in the
application, via automated
emails, and through a My
Work mobile app available on
Android, iOS, and Windows.

To ensure the integrity of
the workflow process, EERP
provides comprehensive
auditing as processes move
through workflow and on
changes to the workflow
system itself. Administrators
can analyze workflow
performance with
integrated management
tools to assist with process
reengineering.

I 45. Searchable and
context
sensitive help.

Rating 4 - Searchable and contextsensitive help is standard and available in the proposed version.
4, Springbrook offers a full
help documentation organized
into individual topics. Each
topic covers a specific element
or process within the
application and can be
searched or found in the
index. Many of these topics
include a list of procedural
steps or explanations that can
be expanded or collapsed to
display only the steps that are
relevant to your current task.

Within this area we also
provide relevant API
information as well as links to
tour the application and
understand our verbiage in the
system

4. Google style search
functions
4 The Enterprise ERP
application has an integrated
electronic help and
documentation system. EERP
programs include contextsensitive help that provides
task-related information for
screens and fields. This
online documentation helps
navigate through programs,
providing the procedures and
details needed to complete
tasks.
4 – Core Vista HCM – offers
online help which can be
search/index. All other
proposed modules will
deliver the capability to
search the system for
specific data and includes
context sensitive help.

Rating 4
R 46. Describe
available
Rating 4 - Available online training
and support tools are standard
4, Springbrook offers a
community website which has

4. Training videos within
application available. Videos
4 Tyler has integrated online
4: Univerus will deliver onsite and on-line training as Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
online training
and support
tools.
and available in the proposed
version.
many FAQ, tips and tricks,
videos, webinars, refresher
courses, as well as case
creation. These courses can be
searched by keyword, module,
or process. All information can
be downloaded in PDF and
support costs are included in
the annual subscription
fees. We host training
webinars as well.
include such topics as general
navigation through more
complex areas. Training videos
are frequently updated.

Product documentation is
available and accessed from
the application.
help and TylerU tutorial
videos.

Tyler maintains a complete
set of documentation that is
available to all users through
the KnowledgeBase. The
KnowledgeBase provides
users with a single, easily
accessible location to find all
existing documentation on
Tyler products and other
widely used technology
products. Included are
procedure documents, file
layouts, user guides,
installation manuals, setup
documents, system
administrator documents,
data schemas, training
exercises and much more.

Clients also have the ability to
download documentation into
Microsoft Word format to edit
to match internal policies and
procedures
the City desires. Univerus
provides our Unity Portal
for enhancement and bug
communication. Univerus
provides on-line training
videos for continued
product learning.

PDS provides VistaFlix via
Customer Support portal
for HCM components.

These are how-to Videos.

Additionally, all core
curriculum can be
provided remotely via
Zoom or Teams tools.

R 47. Audit trail and
reporting with
date, time,
user stamp,
and
before/after
values.

Rating 4 - Audit trail and reporting
with date, time, user stamp, and
before/after values is standard
and available in the proposed
version.
4, Springbrook provides a full
audit trail.

4. Fully configurable audit
features throughout solution.

Fields are fully audit tracked
and reportable. The audit
tracking shows old value,
new value, date and time
stamp as well as user stamp
for both old value and new
value.
4 Supported via integrated
audit.
4 - Our product has the
ability to track actions,
changes and/or
modifications to the
configuration of data in
the system and of the
users who performed
them. It automatically
tracks all activities and
edits and provides
reporting and viewing
capabilities.

Rating 4
R 48. Attach
documents
and images to
transactions
Rating 4 - Attaching documents
and images to transactions
throughout all modules is
standard and available in the
4, Springbrook does not have
any size of format limitations

4. Available throughout all
applications in the platform.
4 Attachments supported via
use of integrated Content
Manager
4 - Users can attach
various types of
information and
documents, such as
Rating 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
throughout all
modules (e.g.,

PDF, JPEG, TIF,
DWG, etc.).

Indicate any
size limits for
attachments.
proposed version with size limits
varying by file type.
photos, transactions,
work instructions,
warranty, Health and
Safety documentation,
inspections, links, etc. in
various formats.

R 49. Effective
dating of
transactions
throughout all
modules.

Rating 4 - Effective dating of
transactions throughout all
modules is standard and available
in the proposed version.
4, Date driven transactions
and effective dating is a
standard in our Springbrook
system.

4. Comprehensive date
stamping/ search features.
4 Supported where applicable
4 – Throughout, the
system gives you a range
of input date parameters
when creating
transactions that support
the ability to make
effective date changes.

Rating 4
R General Ledger
R 50. Modified
accrual
accounting
basis.

Rating 4 - Modified accrual
accounting basis is standard and
available in the proposed version.
4, Springbrook offers this
capability
4 EERP is a modified accrual
basis of accounting,
however cash basis can be
supported via modifications
to set-up and policies. Full
accrual reporting can be
supported via Tyler’s ACFR
Statement Builder.
4 – Modified Accrual is
supported as standard via
the sets of books feature
Fit
R 51. Indicate
number of
accounting
periods
supported to
isolate accruals
and audit
adjustments –
13 or 14
preferred.

Rating 4 - The proposed version
supports 13 or 14 accounting
periods to isolate accruals and
audit adjustments.
4, Ability to have up to 14
periods
4 14 periods total, periods 0-

13. 4 - SAP ByDesign supports
the ability to handle the
required periods in the year
and gives you an innovative
way to manage “posting
stages” in each period. This
allows you to keep a prior
period open for late
operational, adjustment
and closing entries whilst
allowing regular operational
postings in the current
period.

You can close a period
using the closing cockpit
Fit, 13 period supported

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
that allows you to see a
full task list and assignees
to run through the period
end closing process for
your business.

R 52. Multiple fiscal
years or
periods open
at one time.

Rating 4 - Multiple fiscal years or
periods open at one time is
standard and available in the
proposed version.
4, Springbrook offers this
capability
4 Ability to have two years
open at a time, and access
to more than one periodbased on user permissions
4 – The system supports 3
fiscal years being open at
one time, we recommend
having only two to meet
your business needs.

Fit
R 53. Fund
accounting
with automatic
inter-fund dueto, due-from
balancing.

Rating 4 - Fund accounting with
automatic inter-fund due-to, duefrom balancing is standard and available in the proposed version.
4, Springbrook offers this
capability
4 Enterprise ERP GL is a true
multi-fund accounting
system. Automatic interfund
balancing is available with
proper setup of due to/due
from accounts, etc.
4 – This feature is
supported as standard in
the ERP suite
Fit
R 54. Flexible Chart
of Account
format to
support 5 or
more
segments.

Current
format: Fund
(3,)
Department
(4), Object (4).

Additional
segments to
support cost
center,
activity, grant
or program,
etc.

Rating 2 - The current format of
the flexible Chart of Account
supports up to 3 segments for
Fund, 4 for Department, and 4 for
Object, but additional segments
to support cost center, activity,
grant, or program will require
modification with an estimated
cost to be determined.
4, Springbrook supports 6
characters up to 7 segments
4 Tyler’s Enterprise ERP
solution has a flexible chart
of accounts structure that
supports one fund (up to
four characters), one object
(up to six characters), one
project (if applicable) (up to
five characters), and up to
seven configurable
segments (up to 10
characters each) for a
maximum account length of
45 alphanumeric characters
across 10 segments.
4 - Our GL structure is
highly flexible with
multiple segments
supporting the requested
Fund, Department and
Object format the City
currently uses. We can
support any GL structure
required via the
organization structure
configuration of the
system and associated GL
account code.

Fit
R 55. Multiple
journal entry
types
including:

Rating 4 - The proposed version
supports multiple journal entry
types including standard,
reversing, recurring, allocations,
4, Springbrook can handle the
various journal entry types
mentioned
4 EERP allows for General,
Reversing, Recurring,
Budget Adjustments and
4 – Multiple journal entry
types are available in the
application that help drive
the default behavior of the
Fit

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
a. Standard
b. Reversing
c. Recurring
d. Allocation
s
e. Budget
adjustmen
ts and
transfers
f. Import
from Excel
budget adjustments and transfers,
and import from Excel.

Journal Imports. Allocation
codes can be used in
Invoice, Requisition,
Purchase Order and Payroll
programs.

Journal Entry screen and
required fields for each
transaction type to ensure
accuracy.

R 56. Copy a Journal
Entry to create
a new one.

Rating 4 - Copying a Journal Entry
to create a new one is standard
and available in the proposed
version.
4, Springbrook offers this
capability
4 ‘Posted Find’ from General
Journal Entry/Proof allows a
user to find an existing
posted journal and copy it to
a proof journal for review,
modification (if necessary),
approval (if necessary), and
posting.
4 – The copy JV feature is a
default option in the
application, we also
support recurring JE’s and
JE templates
Fit
R 57. Workflow
routing of
journal entries
for approval.

Rating 4 - Workflow routing of
journal entries for approval is
standard and available in the
proposed version.
4, Workflows can be used for
JE approvals
4 With proper workflow
setup, journal entries can be
routed through workflow for
approval. Users can define:
each task structure, user
performing task, order the
tasks are performed and
how re-routing is handled.
4 - Following the dual
control dual control
principle, the system routes
journal entries for approval
to the necessary staff
members.

Fit
R 58. Decentralized
Journal Entry
with rolebased
permission;
finance review
and approval
step before
posting.

Rating 3 - Decentralized Journal
Entry with role-based permission
and finance review and approval
step before posting is supported
with 3rd party software
integrated with the proposed
solution. The recommended
application is BlackLine.
4, Springbrook can maintain a
decentralized Journal Entry
with role-based permission;
finance review and approval
step before posting.
4 Journals can be entered
from any location assuming
the user is logged into
Enterprise ERP and has the
appropriate permissions
assigned. Workflow can be
setup for necessary
workflow approvals and
notifications.
4 – Role based approval
and decentralized entry
are all part of the core
system. We also support
strict dual control as
required by government
accounting standards.

Fit

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
R 59. Dashboard
view of budget
vs. actual by
department.

Rating 4 - Dashboard view of
budget vs. actual by department
is standard and available in the
proposed version.
4, Tableau allows us to
configure a dashboard to not
only show budget vs actual,
but many other desired
components.
4 Available via Hub
(dashboard)
4 – This is available on
both reports and
dashboards.

Fit
R 60. Attach
supporting
documents.

Rating 4 - Attaching supporting
documents is standard and
available in the proposed version.
4, Ability to attach documents
of any size in any format
4 Attachments supported via
Content Manager
4 - Attachments and other
supporting
documentation can be
added to the journal entry
with ease either during
the transaction or at any
subsequent time.

Fit
R 61. Support
generation of
ACFR. Describe
tools available.

Rating 4 - The proposed version
supports the generation of ACFR
with available tools.
4, ACFR reporting is fully
offered and in compliance.
4 Via Tyler ACFR Statement
Builder
4: The ACFR generation
process is supported by the
application allowing you to
build workbooks of reports
that allow you to create the
reporting content for the
ACFR for inclusion in the
City's ACFR template
Fit, FRS (Financial Reporting
Studio)
R Budgeting
R 62. Position
budgeting for
wages and
benefits.

Rating 4: The software supports
position budgeting for wages and
benefits out of the box or with
configuration included in this
proposal.
4, Springbrook offers an
extended budgeting module as
part of our standard financial
suite that allows for position
budgeting and more.
4 Position budgeting
supported via integrated
PR/HR
4 - Provided through the
PDS HCM Solution
TBD
R 63. Decentralized
budget entry by
department
with approval
workflow.

Rating 4: The software allows
decentralized budget entry by
department with approval
workflow, which is supported out
of the box or with configuration
included in this proposal.
4, You will be able to enter a
budget at department level
and have it approved.
4 Departments can enter
budget amounts in Central
Budget Entry and the
amounts can be reviewed by
appropriate department
heads with budget entry
department notification
workflow.
4 – Budget prep can be
accomplished by either the
budget prep module or
through Excel upload to the
ERP.

Fit
R 64. View budget vs.
actual for
Rating 4: The software allows the
view of budget vs. actual for
4, There are various ways to
view budget vs actual in
4 Users can link out to
4 - This is supported by
budget validity dates
Fit

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
multiple years
during budget
entry.
multiple years during budget
entry, which is supported out of
the box or with configuration
included in this proposal.

Springbrook dashboards and
reporting.

Account Inquiry and/or use
additional tabs to run
reports while entering
budget.
encompassing a multi-year
date range.

R 65. Document lineitem
assumptions
and attach
supporting
documentation.

Rating 4: The software supports
the documentation of line-item
assumptions and the attachment
of supporting documentation out
of the box or with configuration
included in this proposal.
4, Line-Item assumptions and
commits are part of our
Budgeting capabilities. The
system also allows for the
attachment of supporting
documentation throughout
the complete system.
4 Text and notes can be
entered at the account level
and description and
justification narratives can
be entered at the detail
level. Documents can be
attached at both account
and detail level via Content
Manager
4 - The system allows for
full notes and annotations
to the budget line items and
supports attachments by
default.

Fit
R 66. Online visibility
to budget input
status queue.

Rating 4: The software provides
online visibility to budget input
status queue out of the box or
with configuration included in this
proposal.
4, Springbrook Cirrus is
completely browser based and
all processes are online and
visible.
4 More specific information is
needed to fully understand
the question however
Enterprise Budgeting offers
online access to all budget
related processes including
workflow status.
4 – Budget prep module
provides visibility to budget
input status.

Fit
R 67. Multiple
versions per
fiscal year.

Rating 4: The software supports
multiple versions per fiscal year
out of the box or with
configuration included in this
proposal.
4, Multiple versions of the
budget can be entered,
viewed and compared
4 EERP offers an unlimited
number of budget versions
per fiscal year.
4 – Multiple versions are
supported by default with a
full version history approval
control.

Fit
R 68. Generate midyear budget.Rating 4: The software supports the generation of a mid-year
budget out of the box or with
configuration included in this
proposal.
4, You will be able to generate
a mid-year budget.
4 EERP Budgeting allows for a
mid-year projection to be
entered as well as separate
budget
amendment/transfer
functionality with workflow
available.
4 – Budget adjustments or
new budgets can be created
at any time during the fiscal
year.

Fit
R 69. Generate
budget
transfers and
Rating 4: The software allows the
generation of budget transfers
and adjustments with workflow
4, We can accomplish this, but
we do not have workflows
enabled for this process.
4 EERP allows for separate
budget
4 - Budgets are status
controlled giving you full
control over pending and
Fit

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
adjustments
with workflow
approval.
approval, which is supported out
of the box or with configuration
included in this proposal.

Separation of duties and
approvals can be
accomplished through menu
security.
amendment/transfer
functionality with workflow
available.
approved budgets and
approval tasks.

R 70. Budget
trending, multiyear projection,
and what-if
analysis.

Rating 4: The software supports
budget trending, multi-year
projection, and what-if analysis
out of the box or with
configuration included in this
proposal.
4, This is supported in
Springbrook’s Extended
Budgeting module.
4 The Budget Scenarios
program allows users to
prepare multiple versions of
proposed budget packages
at any budget level. Multiple
scenarios are created by
applying one or more
decision packages to a
budget projection. Users can
view the impact upon a
budget by applying dollar
value or percentage point
increases or decreases to
specific accounts.
4 – The budget prep
module provides multi-year
projection based on system
thresholds.

Gap
R 71. Input budget as
year total and
spread across
months by
percent or flat
amount.

Rating 4: The software allows the
input of budget as a year total and
the spread across months by
percent or flat amount, which is
supported out of the box or with
configuration included in this
proposal.
4, This is supported with our
Advanced Budgeting features.
4 The Monthly Budget
Amounts program allows
you to initiate and view
monthly budget transfers.

The Original Budget,
Transfers/Amendments,
Revised Budget, Actuals,
and Percent Used detail
fields provide a breakdown
of monthly
4 – The budget pre module
permits budget input and
spread by percent or flat
amount.

Gap, need to build custom
solution
I 72. Interface with
ClearGov or
other citizenfacing portal to
post summary
budgeting data
for public view.

Rating 3: The software can
interface with ClearGov or other
citizen-facing portal to post
summary budgeting data for
public view with third-party
software integrated with the
proposed solution. The name of
the recommended application is
ClearGov.
4, We have many clients who
currently use ClearGov and we
are fully integrated.
4 Ability to Export budget to
third party Interface is
available.
4: Would require custom
interface. To be discussed
during discovery phase.

Gap, need to build an
interface

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
N 73. Support
creation of
Budget Book.

Rating 4: The software supports
the creation of a Budget Book out
of the box or with configuration
included in this proposal.
4, Budget book can be created
with our Advanced Budgeting
Features.
3 Via optionally proposed
third party PatternStream
4 – Budget book can be
created by budget data
input or through Excel
upload.

Fit
I 74. Export budget
data to Excel for
review and
analysis.

Rating 4: The software allows the
export of budget data to Excel for
review and analysis, which is
supported out of the box or with
configuration included in this
proposal.

4. You will be able to export
this report into excel.
4 Most reports and standard
exports can be output to
Excel.
4 - SAP ByDesign supports
the ability to import from
excel and export to excel.

Fit
I 75. Import a budget
worksheet from
Excel.

Rating 4: The software allows the
import of a budget worksheet
from Excel, which is supported
out of the box or with
configuration included in this
proposal.
4, We have the capability to
import via csv.
4 The Import File screen
in Define/Start Budget
Projection imports budget
accounts and level
amounts.
4 - SAP ByDesign supports
the ability to import from
excel and export to excel.

Fit
R Purchasing
R 76. Vendor master
file data:
a. Legal and
DBA name
b. Multiple
contacts:
address,
phone,
email
c. Federal
and State
Tax ID
d. EDD flag
for
reporting
(California
)
e. Attachme
nts – W-9,
etc.
f. Insurance
certificate
a. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
b. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
c. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
d. Rating: 3 - This requirement can
be supported with 3rd party
software integrated with the
proposed solution. One
recommended application is
Avalara.
e. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
4, Vendor records are shared
across the application, so
vendors created in one module
will be available in another
module. These files are made
up of all required information
and more.
4 All covered via standard or
user defined fields. The
Vendor Insurance Certificates
program adds, maintains, or
deletes vendor insurance
certificate information. An
insurance certificate can be
associated with a general
vendor, purchase order,
contract, or project.
4 – Our solution supports
user definable vendor
master file attributes. The
vendor master contains a
number of core fields and
allows you to create
unlimited user definable
fields that the City
requires. Each can be set
to appear solely on the
vendor master or extended
to other areas, for example
to appear on a PO or other
document.

Vendor Master doesnot
include the below details
EDD flag
Insurance certificates

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
with
effective
dates
g. Banking
Informatio
n
h. User
defined
fields
f. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
g. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
h. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.

R 77. Purchase
Order
processing
including:
a. Effective
dating –
cross fiscal
years
b. Decentrali
zed
Requisitio
n entry
c. Budget
validation
d. Rules
based
workflow
approval
routing
with
dashboard
view of
status
e. Attach/pri
nt terms
and
conditions
f. Encumbra
nce
Accountin
a. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
b. Rating: 3 - This requirement can
be supported with 3rd party
software integrated with the
proposed solution. One
recommended application is
Procurify.
c. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
d. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
e. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
f. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
g. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
4, During the process of your
purchase orders you will be
able to process all of the
information that you
requested.
4 Effective dating is standard
throughout entering/posting
of transactions in Enterprise
ERP. Anyone logged into the
system can enter a
requisition from any
location assuming
appropriate permissions are
established. Budget
validation is part of every
transaction entered in the
system assuming an account
is flagged as ‘Budgetary’ and
to check the available
budget. Workflow can be
setup for necessary
approvals and notifications
for PO entry, PO change
orders, and req to PO
conversions. Attachments
via Content Manager.

Requisitions are posted as
pre-encumbrances and POs
are posted as
encumbrances. The Vendor
Insurance Certificates
program adds, maintains, or
deletes vendor insurance
certificate information. An
4 - Our solution supports a
comprehensive procure to
pay lifecycle that allows you
to manage the requisition,
purchase order, contracts,
bids and quotes and quote
arrangements with ease. All
requested features are
included as part of the base
functionality of the system.

Alert or report when
remaining balance is 10%
will be a custom report and
notification
Rest all are
standardfunctionality

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
g –
Requisitio
n and
Purchase
Order
g. Certificate
s of
Insurance
with
effective
dates
h. Attach
document
s – bids,
quotes,
etc.
i. Change
order
managem
ent with
workflow
approval
j. Alert or
report
when
remaining
balance is
10%
h. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
i. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
j. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
insurance certificate can be
associated with a general
vendor, purchase order,
contract, or project.

Certificates of insurance and
other documents can be
attached via Content
Manager. Open PO reports
are available to review PO
balances.

R 78. Allocate
Purchase
Order line item
to one or more
chart of
accounts,
contracts,
projects.

Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
4, This is accomplished with
the "Distribution" tab on the
purchase Order
4 PO lines can be allocated to
GL accounts, projects and/or
contracts.
4 – PO line items can be
allocated across a range of
distribution codes e.g., cost
centers / GL codes with split
percentages or dollar
values.

Feature is in built
R 79. Vendor
management
including:
a. Duplicate
vendor
a. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
b. Rating: 4 - This requirement is a
4, You will be able to track the
information you are requesting.
4 Duplicate vendors are flagged
based on TIN, but settings
allow for duplicate TINs to be
4 - Duplicate checking can
be setup to use three
severity levels of checks,
this gives you high degree
of flexibility in managing
Below functionality is not
inbuilt
Business license
verification
Link to state system

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
managem
ent
b. Vendor
search –
wildcard,
type
ahead
entry, etc.
c. Business
License
verificatio
n
d. Link to
State
system for
Contractor
License
verificatio
n
e. Attach
document
s – W9,
Insurance
Certificate
s, etc.
f. Notificatio
n or report
for
expiring
Certificate
of
Insurance
standard feature in most
accounting software and can be
implemented out of the box.
c. Rating: 3 - This requirement can
be supported with 3rd party
software integrated with the
proposed solution. One
recommended application is
Compliance.ai.
d. Rating: 3 - This requirement can
be supported with 3rd party
software integrated with the
proposed solution. One
recommended application is
ContractSafe.
e. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
f. Rating: 4 - This requirement is a
standard feature in most
accounting software and can be
implemented out of the box.
entered if needed. Vendor
search allows for wildcard.

Documents can be attached
via Content Manager and Hub
provides a card to track
vendor insurance expirations.

We do have integration with
EPL to track and confirm
Business Licenses
We currently do not support
integration with States for
Contractor License
verification
the vendor master and lets
you implement the City’s
business rules.

Documents such as
Insurance Certificates and
W9’s can be tracked on the
vendor attachments tab
and expiration dates and
renewal notices can be
managed from the vendor
master.

Insurance certificate expiry
notification will be custom
report.

I 80. Contract
Management
including:
a. Dates:

Start,
end,
cross
fiscal
years
b. Attach
a. Rating: 4 - The software
supports managing contract dates
including start, end, and cross
fiscal years.
b. Rating: 4 - The software
supports attaching documents to
contracts for easy reference.
c. Rating: 4 - The software allows
users to initiate
4, Currently we can offer the
ability to record 5 bids per PO.

Someday we will write a
contract mgmt. module
4 Multi-year contracts are
supported, documents can be
attached via Content Manager
and reqs and POs can be
created from Contracts.

Renewal reminders are
supported via reminder alerts.

Contract change orders can
be entered and approvals can
4 – The solution supports all
the City’s contract
requirements and will
management all relevant
documentation. Renewal
notices can be managed
from the vendor master.

The contracts feature has
tight integration to both
purchasing and accounts
All are standard
functionality

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
documen
ts
c. Initiate
Requisiti
ons/Purc
hase
Orders to
Contract
d. Contract
renewal
reminder
s
e. Change
Order
manage
ment
with
workflow
approval
f. Alert or
report
when
nearing
expiratio
n
Requisitions/Purchase Orders
directly from a contract.
d. Rating: 4 - The software
provides contract renewal
reminders to ensure timely
renewal.
e. Rating: 4 - The software
supports Change Order
management with workflow
approval for managing changes to
contracts.
f. Rating: 4 - The software
provides alerts or reports when
nearing contract expiration,
ensuring contracts are not missed.
be setup as necessary.

Expiration reminders can be
setup via reminder alerts.
payable processes, both
creating links to the
contract when a purchase
order is created and when
the supplier invoice is
posted. This means that
from the contract view you
can always see all related
documents and
transactions making it easy
for your purchasing team to
find and report on this data.

Our solution includes a
workflow-based tool to help
you manage both contract
creation and change order
management.

N 81. Import quotes
processed
through
PlanetBids.

Rating: 3 -: Importing quotes
processed through PlanetBids
requires integration with thirdparty software that can handle the import.
4, we can import quotes into
the PO module
4 Contracts and POs can be
imported using standard file
layouts
2 – This would require
custom integration. Price
included in RFP pricing.

Custom interface using OIC
I 82. Flag item as an
asset at
creation of
requisition or
Purchase
Order with
review before
posting to
Fixed Asset
module.

Rating: 4 - The software supports
flagging items as assets at the
creation of a requisition or
Purchase Order with a review
before posting to the Fixed Asset
module.
4, This is accomplished by
marking the "Fixed Asset"
checkbox on the PO Line Item
4 Line detail information on
Requisition and Purchase
Orders can include
inventory and fixed asset
designation.
4 – Purchase order to fixed
asset integration is a core
part of the system, allowing
you to define business rules
e.g., any item over $5k
becomes a fixed asset or
manually allowing you to
determine the fixed asset
creation based on business
rules
Standard functionality

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
R 83. Distribute
approved
Purchase
Orders to
suppliers via
email or push
to PlanetBids.

Rating: 4 - The software allows for
the distribution of approved
Purchase Orders to suppliers via
email or push to PlanetBids.
4, Electronic distribution is
offered throughout the PO
and AP modules. If a 3rd party,
such as PlanetBids is in use,
the use of our Open API can be
used to communicate at a
particular defined frequency.
4 Purchase Orders can be
emailed via Enterprise
Forms.
2 – This would require
custom development.

Cost included in RFP
pricing.

Push to planetbids is
custom
I 84. Vendor selfservice portal:
submit
invoices,
upload W-9,
submit change
of address,
update
banking data,
etc. with
review step
before posting.

Rating: 4 - The software provides
a vendor self-service portal for
vendors to submit invoices,
upload W-9s, submit change of
address, update banking data,
etc., with a review step before
posting.
0, Currently Springbrook does
not offer a vendor self-service
portal. This has been
discussed to be added to the
2024 roadmap
4 Supported via Vendor
Access. Workflow is
available for external vendor
updates that can be routed
to necessary approvers for
review before posting
change set.

F – Anticipated Q1 2024 Standard functionality
R Accounts Payable
R 85. Centralized (or
decentralized
with
permissions)
invoice entry,
scan and
attach
invoices,
workflow
routing for
approval,
electronic
signatures,
visibility of
approval
queue.

Rating: 4 - The software supports
centralized invoice entry, scan,
and attach invoices, workflow
routing for approval, electronic
signatures, and visibility of the
approval queue.
4, Springbrook can handle all
the above
4 Standard with Enterprise
ERP Accounts Payable.

Invoices can be entered
from any location assuming
the user is logged into the
system and has appropriate
permissions. Scans and
attachments are supported
via Content Manager and
workflow rules can be setup
for approval and notification
routing. Electronic
signatures assume the
username of the workflow
approver, and workflow
approvals can be surfaced in
Hub and email.
4 - The system has the
ability to support
decentralized invoice entry
at the department level and
has the ability to allow for
an invoice to be distributed
across departments with
appropriate workflow
routines for approval.

Invoice entry can be
streamlined using the email
scan feature for invoices
within the application. This
allows you to have the
system pre-populate the
invoice entry fields and
review and code the invoice
correctly.

Rating-4: Oracle supports
Centralized invoice entry,
scan & attach invoices,
workflow routing for
approval, electronic
signatures, visibility of
approval.

R 86. Distribute Rating: 4 - The software allows for 4, Ability to tie an invoice line 4 4 - The system has the Rating-4: Invoice lines can be Page 778 of 829

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
invoice line
item to
multiple
General Ledger
accounts.
the distribution of an invoice line
item to multiple General Ledger
accounts.
item to a specific GL account.

Each line item in the invoice
can have its own account
distribution
Allocation codes
automatically distribute a
single transaction amount
across numerous general
ledger accounts. Using the
allocation code, users can
assign a percentage of the
whole dollar amount to up
to 50 different accounts
ability to allow for an
invoice to be distributed to
at least 50 different general
ledger accounts.
created with multiple
general ledger accounts.

R 87. Support 2 and
3-way
matching;
Purchase
Order to
invoice or
Purchase
Order to
invoice
receiving.

Rating: 4 - The software supports
2 and 3-way matching, including
Purchase Order to invoice or
Purchase Order to invoice
receiving.
4, We offer 2- and 3-way
matching
4 Ability to determine threeway match status for how
purchase order liquidations
are handled.
4 - As part of the three-way
matching functionality, the
system includes a built-in
invoice verification tool,
allowing your employees to
create invoices with or
without reference to a
purchase order.

Rating-4: Oracle supports 2
and 3-way matching for
purchase order.

R 88. Allow Purchase
Order to
Invoice
variance within
a tolerance
level- dollar
amount or
percent.

Rating: 4 - The software allows for
Purchase Order to Invoice
variance within a tolerance leveldollar amount or percent. 4, This can be done in the
setup
4 Both are allowed and can be
set in AP settings
4 – Our solution has the
ability to set a tolerance at
invoice level by
department, which can limit
the amount of override
allowed on an invoice (by
either dollar amount or
percentage).

Rating-4: Oracle supports
purchase order to invoice
variance at dollar amount or
percent amount.

R 89. Support direct
invoice
processing
without
Requisition or
Purchase
Order.

Rating: 4 - The software supports
direct invoice processing without
a requisition or Purchase Order.
4, Invoices can be created
directly in our invoice batch
process without the need of a
PO or requisition. We also
offer the ability to create
recurring invoices for faster
entry.
4 PO not required to produce
an Invoice
4 - Invoices without a
Purchase Order can be
entered manually providing
additional coverage for this
business process.

Rating-4: Invoice can be
created without requisition
or purchase order.

R 90. Import
electronic
vendor
invoices, e.g.,
PDF; route for
Rating: 4 - The software supports
importing electronic vendor
invoices, e.g., PDF, routing for
approval, and processing for
payment.
4, We offer the ability to
import invoices, and we give
customers the ability to attach
PDF copies of invoices to
records.
4 Via Standard Imports
assuming compatible file
formats
4 - The system has the
ability to allow for the
electronic submission of
invoice from vendors (e.g.,
e-bills, etc.) with
Rating-4: AP invoices can be
imported using FBDI
template in Oracle & can be
used for further processing.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
approval and
process for
payment.
appropriate workflow
routines for approval.

R 91. Duplicate
invoice
management.

Rating: 4 - The software provides
duplicate invoice management to
avoid processing the same invoice
multiple times.
4, Notified when a duplicate
invoice is entered
4 Ability to restrict duplicate
invoice numbers by each
vendor number.
4 - The system has the
ability to provide
notification of duplicate
invoice number entry of
same vendor and provides
for authorized user
override.

Rating-4: Duplicate invoices
can be created in the system
using standard functionality.

But same invoice number
cannot be assigned. A suffix
or prefix can be used.

R 92. Interface with
Utility Billing
for processing
refunds to
customers.

Rating: 3 - The software requires
integration with Utility Billing to
process refunds to customers.
4, When you process a refund
for a UB customer this will
flow into AP so that the refund
check can be printed.
4 EERP offers a fully
integrated solution including
Utility Billing.
4 - The system has the
ability to create refund
transactions in a file or an
integration to post to
accounts payable for refund
check processing.

Rating-2: Integration is
required with Utility Billing
from Oracle.

R 93. Initiate online
check requests
(Request for
Payment),
attach
supporting
documentatio
n, and
workflow
approval
routing.

Rating: 4 - The software supports
initiating online check requests
(Request for Payment), attaching
supporting documentation, and
workflow approval routing.
4, The AP process allows for
documentation and workflow
processing
4 The Request for Check
program defines requests
for checks to be used to pay
vendors without requiring a
purchase order against
which to apply the payment.

Once approved, check
requests are converted into
accounts payable invoices in
order to generate checks.
4 - Our ERP suite includes a
payment monitor that
allows you to create online
check requests directly
from the associated
approved and payable
invoices entered into the
system. Our invoice entry
solution allows documents
to be manually added or
scanned using our
innovative AI enabled email
invoice scanning solution.

This allows your vendors
and staff to upload invoices
directly into the system for
scanning, matching to PO's
and then follow subsequent
posting and approval
workflows.

Rating-4: Payment process
request functionality can be
used.

I 94. Import and
process Credit
Card
4: The software supports
importing and processing Credit
Card transactions from a bank file
4, Imports are available
throughout the entire
Springbrook platform
4 The Purchase Card Import
program imports transaction
4 – Credit card transactions
can be imported directly
from bank files and
Rating-0 : Credit card
processing in Fusion
Applications cloud services

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
transactions
from bank file;
post to payee
vendor.
and posting to payee vendor. details for bills incurred by employees using purchase
order credit cards. It creates
new invoices using the data
from a designated file, and
the Invoice Entry program is
used to update and
proof/post these invoices.
matched to the correct GL
accounts or payee vendor
as required.
at this time has limited
controlled availability. The
credit card processing is
available only in data
centers where Fusion
Applications Payments
module has been certified
for Payment Card Industry
Data Security Standard (PCI
DSS v3.2.1). The credit card
processing is available for
the Fusion Applications
services that utilize Oracle
Fusion Payments module.

Out of the box, credit card
payment processing feature
comes disabled in the Fusion
Applications. It is enabled
after careful evaluation to
ensure compliance with PCI
requirements.

R 95. Flag invoice for
separate
check.

Rating: 4 – The software supports
Flag invoice for separate check.
4, Springbrook can place
invoices into separate checks
and/or create a batch to
include as many invoices as
the same check as needed.
4 Invoices can be designated
as separate check, this will
direct the program to print a
single, separate check for a
particular invoice.
4 – Our ERP suite has the
ability to flag invoices (or
groups of invoices) so that
more than one check may
be written to a vendor in
any given check run for
those transactions or
vendors requiring separate
checks.

Rating-4: Oracle supports
this requirement.

R 96. Recurring
Payables with
start and end
date, amounts
workflow
approval.

Rating 4 This requirement is
standard and available in most
accounting software, including
the proposed solution. Recurring
payables can be set up with a
start and end date, along with the
approval workflow, for regular
payments such as rent,
subscriptions, or utility bills.
4, you can set up recurring
invoices and a workflow for
approval.
4 The Recurring Invoices
program maintains recurring
vendor invoices and
generates a batch of
recurring invoices. The
Invoice Entry program must
be used to output and post
the batch created through
recurring invoice
4 – Using the recurring
invoice feature the system
has the ability to split an
invoice into a payment
schedule with at least
twelve different due dates
and due amounts.

Rating-4: Recurring invoices
functionality can be used.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
generation.

R 97. Manage
retainage –
primarily at 5%
on designated
invoices.

Rating 3 This requirement can be
supported with 3rd party
software integrated with the
proposed solution. Retainage
management software, such as
Textura or AIA, can be used to
manage and track retainage
amounts and release dates for
specific invoices.
4, Retainage is not an issue on
our cloud-based platform
4 The AP Retainage program
processes general and 1099
retainage amounts for
permanent withholding or
release to a vendor.
4 - Our ERP suite has the
ability to calculate and
track retainage on
specified invoices. The City
will set the percentage
based on purchase order.

Rating-4: Oracle supports
retainage system
I 98. Assign invoice
status to
“Hold” to stop
payment
processing.

Rating 4 This requirement is
standard and available in most
accounting software, including
the proposed solution. An invoice
can be assigned a status of "Hold"
to prevent it from being
processed for payment until the
issue with the invoice is resolved.
4, Springbrook can hold
payment processing
4 Via Invoice Status
4 - Payment Arrangements
can be offered over a set
term and can be setup
based on your business
rules and discretionary
policies.

We support the concept
of payment extensions
allowing you to give a
customer an extension on
their bill due date as
determined by business
rules. These extensions
are recorded in the
system as payment plans
and delay the date the
collections stream begins.

Rating-4: Invoice holds
functionality can be used.

R 99. Multiple forms
of payment;
check, wire,
EFT, ACH, etc.

Rating 4 This requirement is
standard and available in most
accounting software, including
the proposed solution. Multiple
forms of payment can be set up,
such as check, wire, EFT, ACH, and
more, to accommodate vendor
preferences and payment needs.
4, Springbrook offers multiple
forms of payment
4 Enterprise Accounts Payable
Invoices can create the
following types of payment:

Normal, Direct
Disbursement, Wire
Transfer, EFT, Single, and
Active Card Integration.
4 - Our ERP suite supports
multiple payment methods
including check and ACH.

Rating-4: Oracle supports
multiple forms of payment:

Check, wire, EFT, ACH etc.

I 100. Email
remittance
notification to
vendors for
Rating 4 This requirement is
standard and available in most
accounting software, including
the proposed solution. An email
4, ACH and notifications are
available in Springbrook
4 Payables Delivery method
can be set to ‘E-mail.’
4 – Our ERP suite comes
with a range of preconfigured notification
template events, with all
Rating-4: Payment
remittance advice can be
used

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
ach payments
including
details of
invoices
included in
payment.
remittance notification can be
automatically sent to vendors
when ACH payments are made,
including the details of the
invoices included in the payment.
the major events including
payment related tasks that
can be setup for email
notification. User defined
events can easily be added
throughout the
implementation process or
after by your staff to easily
support changing business
practices or regulatory
requirements.

R 101. Generate
Positive Pay
file for bank.

Rating 4 This requirement is
standard and available in most
accounting software, including
the proposed solution. Positive
Pay files can be generated for
banks to ensure that only
authorized checks are paid from
the company's bank account.
4, Ability to generate Positive
Pay file if set up to do so
4 EERP supports positive pay
by creating an electronic
positive pay file that
supports the check
reconciliation process. The
positive pay file consists of a
list of checks that an
organization has written
during the defined period.
4 - Positive pay files can be
generated from the
application.

Rating-4: Oracle generates
positive pay file for the bank.

R 102. Sales and use
tax
management
and reporting
for out of state
purchases.

Rating 4 This requirement is
standard and available in most
accounting software, including
the proposed solution. Sales and
use tax management and
reporting can be set up to comply
with state regulations for out-ofstate purchases.
4, AP can track Excise tax
purchases and calculate the
rates based on the invoice
amount
4 Enterprise Accounts Payable
supports both sales and use
tax processing.
4 – Taxes can be configured
based on state
requirements and reported
on accordingly.

Rating-4: Oracle fusion tax
module can be used to
achieve these requirements.

R 103. 1099
management
including
vendor
designation,
edit reports,
generation of
forms,
electronic
filing to IRS,
etc.

Rating 4 This requirement is
standard and available in most
accounting software, including
the proposed solution. 1099
management can be set up to
designate vendors and generate
forms for electronic filing to the
IRS.
4, we can provide the file to
import to the IRS.
4 The AP 1099 Manager
program provides a
centralized resource for
processing Accounts Payable
1099 records, including
1099-G, 1099-INT, 1099-
NEC, 1099-MISC, and 1099-S
forms.
4 - 1099 forms can be
created as required from
the application by your
users.

Rating-4 & Rating-2: 1099
report can be generated
from Oracle & can also be
customized based on
business requirements.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
N 104. Travel and
Expense
management
capabilities
including
reimbursemen
t requests,
travel
advances,
receipt
attachment,
amounts due
back from
employees,
etc.

Rating 4 This requirement is
standard and available in most
accounting software, including
the proposed solution. Travel and
expense management capabilities
can be set up for reimbursement
requests, travel advances, receipt
attachment, and amounts due
back from employees.
4, Travel and Expense
management capabilities
including reimbursement
requests, travel advances,
receipt attachment, amounts
due back from employees all
can be completed in
Springbrook
4 Please refer to product
overview for Enterprise ERP
Employee Expense
Reimbursement.
4 - Our ERP Suite allows
you to offer a fully
functional expense entry
system to our staff using
both the enterprise
application and our mobile
app. This allows your staff
to submit expenses for
approval, track pre-paid
expenses, attach receipts
and cost center allocations
all within the ERP suite.

Rating-4: Oracle fusion
expenses module supports
these requirements & the
reimbursements will
happen through Payables
module to the employees.

I 105. Electronic
Bank
reconciliation
based on
electronic bank
file import.

Rating 4 This requirement is
standard and available in most
accounting software, including
the proposed solution. Electronic
bank reconciliation can be set up
based on electronic bank file
imports to ensure accurate and
timely bank statement
reconciliation.
4, Electronic Bank
reconciliation based on
electronic bank file import can
happen in Springbrook
4 EERP can import multiple
compatible bank files.
4 - The bank reconciliation
feature of the application
will automatically import
bank files and perform
reconciliations based on
configured business rules.

Each transaction can be
reviewed by your staff if
needed.

Rating-4: Bank statement
imported electronically can
be reconciled in Oracle
Fusion Cash Management
module.

R Accounts Receivable
and Billing
R 106. Single
customer
master for all
receivables
(misc.

Accounts
Receivable,
Utility Billing,
Cash
Receipting,
etc.

Rating 4: The software supports a
single customer master for all
receivables out of the box or with
included configuration.
4, Customers receive a single
customer master record
amount all receivables

4. 4
The Customers program
maintains Accounts
Receivable customer
records. Customer records
are used throughout
Enterprise Revenue
Management programs.
4 – The Univerus allows for
all receivables including
Misc., Utility and Cash
Receipting.

Rating-4: Oracle supports
single customer master for
all receivables.

R 107. Duplicate
customer
Rating 4: The software supports
duplicate customer management
4, Springbrook offers duplicate
customer management

4. 4
System does not allow
4 – This question needs
clarification. We are not
Rating-4: Oracle detects
duplicate customers based

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
management. out of the box or with included
configuration.
duplicate customer
numbers.
completely sure what you
mean by duplicate
customer management.

System reviews the
database to determine if
the customer already exists
in the system.
on the customer account
number; tax id etc. &
prevents the user from
creation.

R 108. Generate
miscellaneous
billings that
are ad hoc or
recurring.

Rating 4: The software supports
generating ad hoc or recurring
miscellaneous billings out of the
box or with included
configuration.
4, you can use this for misc.
billing

4. This can be configured in
SpryCIS
4 Accounts Receivable Charge
Codes establish charge
codes used for principal
payment, fees, interest, or
penalty on bills for tax,
business licenses, utility
billing and more. Charge
codes apply specific types of
charges to bill detail lines
4 – Our ERP suite can
generate billings that are
one-off or set-up as
recurring.

Rating-4: Oracle supports
Miscellaneous receipt &
recurring invoice
functionalities for these
requirements.

R 109. Define and
generate
recurring
invoices with
start and end
dates.

Rating 4: The software supports
defining and generating recurring
invoices with start and end dates
out of the box or with included
configuration.
4, you can set up recurring
invoices

4. 4
Available via Recurring
Invoices within Enterprise
General Billing.
4 – The system can
accommodate a start and
end date for recurring
invoices.

Rating-4: Oracle supports
recurring invoice
functionality with recurring
period.

R 110. Import data
from Excel
worksheet to
create an
invoice.

Rating 3: The software supports
importing data from Excel
worksheet to create an invoice
with integration from a thirdparty application, such as Excel. 4, you can import a csv file 4. 4
Via Standard Imports
4 – The system allows for
the import of data from
Excel.

Rating-4: Oracle supports
Auto invoice template to
import the invoices.

R 111. Customize
miscellaneous
billing
templates.

Rating 4: The software supports
customizing miscellaneous billing
templates out of the box or with
included configuration.
4, yes 4. Billing templates
configuration during
implementation.
4 Accounts Receivable Charge
Codes establish charge
codes used for principal
payment, fees, interest, or
penalty on bills for tax,
business licenses, utility
billing and more. Charge
codes apply specific types of
charges to bill detail lines
4 – Billing templates can be
customized. This is part of
the implementation
process.

Rating-4: Invoice templates
can be customized based on
the business requirements.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
R 112. Add notes or
description.

Rating 4: The software supports
adding notes or description to
invoices out of the box or with
included configuration.
4, you can add notes or a
description in the description
field.

4. Notes and description can
be added to bill templated.

This can be configured during
bill template design during
implementation.
4 Invoice messages and
invoice message text can be
added to GB invoice batches
and comments can be
added to each invoice within
a batch.
4 – Notes and descriptions
can be included.

Rating-4: Additional
information or description
can be captured at invoice
level.

R 113. Scan and
attach
supporting
documentatio
n.

Rating 4: The software supports
scanning and attaching supporting
documentation to invoices out of
the box or with included
configuration.
4, supporting documentation
can be scanned and attached
throughout much of the
Springbrook system (included
AR, AP, UB, POs and more)

4. SpryCIS can store
attachment, it does not have
a scanner.
4 Via Content Manager
4 – Our ERP suite permits
the scanning and
attachment of supporting
documentation, including
uploading an electronic
file.

Rating-4: Scanned
documents can be
attached at invoice level.

R 114. Multiple forms
of payment:
cash, check,
ACH, credit
card, etc.

Rating 4: The software supports
multiple forms of payment,
including cash, check, ACH, credit
card, etc., out of the box or with
included configuration.
4, we can accept all these
types of payments

4. Available with integration
with PCI compliant electronic
bill payment processors
(EBPP)
4 Cash, check, ACH and Credit
card can be accepted.
4 – These forms of payment
are fully supported.

Rating-4: Oracle supports
multiple forms of payment:

Cash, check, ACH, Credit card
etc.

R 115. Generate daily
cash receipt
report by
payment type.

Rating 4: The software supports
generating a daily cash receipt
report by payment type out of the
box or with included
configuration.

Y, you will be able to see this in
reporting.

4. Cash receipt reports can be
generated from SpryCIS.

Report configuration is
included in implementation.
4 Standard report or through
SQL Server Reporting
Services
4 – Receipt generation is
supported showing
payment type(s).

Rating-2: Custom report can
be developed
R 116. Process and
manage NSF
payments.

Rating 4: The software supports
processing and managing NSF
payments out of the box or with
included configuration.
4, Springbrook has processes
to help with NSF payments

4. SpryCIS can process NSF
checks, and fees. It can also
reverse payments for bad
checks and optionally asses a
user-defined NSF charge.
4 Ability to charge fees for
NSF checks
4 – NSF management is
supported in the system.

More information required.

R 117. Generate
30/60/90 day
warning
letters; flag for
collection and
issue letter if
120 days past
due.

Rating 4: The software supports
generating 30/60/90 day warning
letters and flagging for collection
if 120 days past due out of the
box or with included
configuration.
4, Standard reports offer
30/60/90-day warning letters

4. Letters can be generated in
SpryCIS for the defined past
due time periods. Reports
are also available for review
as well.
4 The Aging Report creates a
report of overdue bills for a
range of customers, bill
years, accounts receivable
codes, special conditions,
bill types, and AR category
codes. Aging report is
exportable to Excel.
4 – The system includes a
dunning process that is user
designed.

Rating-4: Oracle supports
dunning configuration in
Advanced collections
module.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
N 118. Calculation of
interest and
penalties for
past due
invoices.

Rating 4: The software supports
the calculation of interest and
penalties for past due invoices out
of the box or with included
configuration.
4, you will be able to set up
different fees.

4. SpryCIS can calculate
interested and penalties as
defined by the City. This is
configured during
implementation.
4 Assess Late Fees calculates
late fees on outstanding and
unpaid invoices and prints a
list of the accounts and
invoices affected by this
activity
4 – The system supports
interest and penalties for
past due invoices.

Rating-4: For past due
invoices, Late charges can be
calculated on the invoices.

R Utility Billing
R 119. Integration to
General
Ledger.

Rating 4 - This requirement is
standard and available in the
proposed software version.
4, once committed this will
integrate with the GL

4. We have experience with
integrating to Dynamics, Tyler,
SAP, Workday, Oracle etc.
4 Fully integrated with Tyler’s
Enterprise Accounting/GL.
4 – The UB module has the
ability to perform electronic
on demand posting to
General Ledger after
accounting approval step is
performed.

Our Univerus CIS solution
enables users to (1) load a
customized chart of
accounts (double entry)
and track GL activity in a
separate set of tables, (2)
view financial transactions
and balance information in
a simple-to-read ledger,
and (3) capture GL
balances at a detail level
per charge or transaction
type.

Rating-4: Fusion Receivables
integrates with General
Ledger. All Receivables
subledger activities will be
transferred to General ledger
in the form of journal
entries.

R 120. Customer
master record
to include:
a. Account
number –
system
assigned
b. Service
type -
water,
sewer,
storm
a. Account number – system
assigned: Rating 4 - This
requirement is standard and
available in the proposed software
version.
b. Service type - water, sewer,
storm drain: Rating 4 - This
requirement is standard and
available in the proposed software
version.
c. Bill cycle - six: Rating 4 - This
requirement is standard and
4, you will be able to track all
this information.

4. SpryCIS can support master
record information listed.

SpryCIS can bill for a wide
range of service type, not
limited to the number of bill
cycles.
4 All information can be
tracked. Some information
will require the use of user
defined field functionality.

Attachments via Content
Manager
4 - The account
management feature allows
you to setup and maintain
all necessary information
about your customers,
including document
attachments where
necessary.

Rating-4 & Rating-2:
a.Rating-4, system assigned
b. Rating-2: Custom
descriptive field needs to be
defined.
c. Rating-2: Custom
descriptive field needs to be
defined.
d. Rating-2: Custom
descriptive field needs to be
defined.
e. Rating-4: In customer

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
drain
c. Bill cycle -
six
d. APN
number,
parcel ID,
lot
number
e. Multiple
contacts
including
name,
addresse
s, phone,
email
f. Notes
g. Meter
location/
GIS
coordinat
es
h. Documen
t
attachme
nts
available in the proposed software
version.
d. APN number, parcel ID, lot
number: Rating 4 - This
requirement is standard and
available in the proposed software
version.
e. Multiple contacts including
name, addresses, phone, email:

Rating 4 - This requirement is
standard and available in the
proposed software version.
f. Notes: Rating 4 - This
requirement is standard and
available in the proposed software
version.
g. Meter location/GIS coordinates:

Rating 4 - This requirement is
standard and available in the
proposed software version.
h. Document attachments: Rating
4 - This requirement is standard
and available in the proposed
software version.
contacts name, addresses,
phone, email details of
contacts can be captured.
f. Rating-4: Notes or
additional information can
be captured at customer
configuration level
g. Rating-2: Custom
descriptive field needs to be
defined.

R 121. Capture meter
attributes:
a. Serial
number
b. Install
date
c. Meter
type and
size
d. Descriptio
n
e. Manufactu
rer
f. Backflow
devices
g. Location:
lat/long,
a. Serial number: Rating 4 - This
requirement is standard and
available in the proposed
software version.
b. Install date: Rating 4 - This
requirement is standard and
available in the proposed
software version.
c. Meter type and size: Rating 4 -
This requirement is standard and
available in the proposed
software version.
d. Description: Rating 4 - This
requirement is standard and
available in the proposed
software version.
e. Manufacturer: Rating 4 - This
4, You will have the capability
to track this information.

4. SpryCIS can support meter
attributes listed.
4 Some may require the use
of user defined fields.
4 – Our solution allows you
to document and track
meter data as per userdefined fields. In addition,
you can record results of
meter inspections and store
meter maintenance
information.

Rating-4 & Rating-2: All these
requirements can be
captures using standard
fields & custom fields in the
required work areas.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
descriptio
n
requirement is standard and
available in the proposed
software version.
f. Backflow devices: Rating 4 - This
requirement is standard and
available in the proposed
software version.
g. Location: lat/long, description:

Rating 4 - This requirement is
standard and available in the
proposed software version.

R 122. Flag landlord
or alternate
contact to
receive
invoices or
statements.

Rating 4 - This requirement is
standard and available in the
proposed software version.
4, you can set up the landlord
on the different statements
that go out to the renter, so
they receive them as well.

4. SpryCIS can store alternate
contacts such as landlords, as
well, alternative addresses
can be stored as well.
4 Special conditions can be
set. Such as for final
statements
4 – Our solution allows
the CSR to set-up a
landlord and CSA on an
account(s) with the ability
to send invoices by
commodity type to the
landlord.

Rating-4: Alternative
contact can be added at
customer configuration
level
I 123. Initiate Service
Order to set up
new customer
accounts and
turn on
service, do
service shut
off, etc. Send
service
requests to
Cartegraph to
initiate work
orders would
be Nice to
Have.

Rating 3 - This requirement is
supported with 3rd party
software integrated with the
proposed solution. Cartegraph is
the recommended application.
4, you can use the service
orders in the UB module to do
this as well as the customer can
start a service request on the
civic pay portal.

4. SpryPoint platform includes
SpryMobile Field Services,
which can handle this item.

Catergraph
4 The EERP Utility Billing
Solution has built-in work
order processing
functionality which includes
the ability to create work
orders for new accounts,
turning on/off service,
shutting services off, and
replacing meters.

A built-in integration with
Cartegraph is not currently
supported, however the
optionally proposed UB
Open API toolkit could be
leveraged by a third party to
develop an integration using
inbound-only web services
to retrieve and update work
order information in EERP.

4: Would require
integration with
Cartegraph. Included in
implementation cost.

Rating-0: Service orders not
available in accounts
receivables module

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
R 124. Deposit
management
including:
a. Single
Family
Residential
: not more
than 3
times the
estimated
average
monthly
bill.
b. Single
Family
Residential
– with 2
shut off
notices:
greater of
2 times
the
estimated
average
periodic
bill or 3
times the
estimated
average
monthly
bill
c. Multiple
Residential
and NonResidential
: greater
of 1 ½
times the
estimated
average
monthly
bill, 2
times the
a. Single Family Residential: not
more than 3 times the estimated
average monthly bill.
b. Single Family Residential – with
2 shut off notices: greater of 2
times the estimated average
periodic bill or 3 times the
estimated average monthly bill.
c. Multiple Residential and NonResidential: greater of 1 ½ times the estimated average monthly
bill, 2 times the estimated average
periodic bill, or 3 times the
estimated average monthly bill.
d. Multiple Residential and NonResidential – with 2 shut off notices: greater of 2 times the
estimated average periodic bill or
3 times the estimated average
monthly bill.
e. Waivers based on credit history
– single family.
f. Reimbursement or apply to
account at the end of the time
period: Rating 4 - This
requirement is standard and
available in the proposed
software version.

Modified - please review 4. SpryCIS has very flexible
deposit handling functionality.

Deposits can be established by
“Type” which can be flexible to
define by service, service class
(eg commercial vs Industrial vs
Residential), and customer
type or credit situation.

Choosing the deposit type can
be predefined during the Move
In transition which normally
assigns the defaults of deposit
types anticipated based on
services at the incoming
premises. A user can manually
assess deposit types on
accounts at any time as well
(reassessing a deposit,
contractual overrides, etc).

Deposit assessments can also
have scripted definitions on
what criteria to base the
amount on. For example, a
utility can select bill history of
the past 24 months on the
premises service to average a
bill amount, then multiply by
two for a 2x Deposit rule.

Another more complex
example is to remove the
highest and lowest of the last
24 months and average the
rest or add a factor on top of
the average. In all cases, the
computed variables are stored
on the assessment for audit
backup on the calculation and
a user can override to smooth
the amount as needed.

Assessments can also define
how many installments it is
eligible for, and if the
0 a and f are supported; e can
be supported
visually/manually if an
integration with Online Utility
Exchange is leveraged.
4 – Our solution has a
robust and flexible deposit
capability allowing the City
to determine unique
deposit rules by customer
class. The City can choose
to leave the deposit on the
customer’s account, or
refund the deposit after a
period of time. You can
refund the deposit via check
or apply the refund to the
customer's account.

Modified - please review
Rating-4 Oracle fusion
Advanced Collections
module will meet the deposit
management requirements.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
estimated
average
periodic
bill, or 3
times the
estimated
average
monthly
bill
d. Multiple
Residential
and NonResidential
– with 2
shut off
notices:
greater of
2 times
the
estimated
average
periodic
bill or 3
times the
estimated
average
monthly
bill
e. Waivers
based on
credit
history –
single
family
f. Reimburse
ment or
apply to
account at
end of
time
period
installments will align to bill
due dates for ease of
statement delivery.

E 125. Tiered rate Rating F - This requirement will be 4, Tiered rate structures are 4. Flexible rate engine, also 4 4 – Our solution supports More information is

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
structure
(possible in the
future).
available in a future release. standard in Springbrook UB supports. Tiered rate structure available today and
formulaic and complex rates
supported as well.

Tables can be utilized to
created tiered rates in the
current version.
complex rate structures
including tiered rates.

Rate set-up is included in
the implementation
process.
required.

R 126. Water billing
at flat rate
based on
meter size plus
consumption.

Rating 4 - This requirement is
standard and available in the
proposed software version.
4, can set this up 4. Flexible rate engine.

SpryCIS can be configured to
billing consumption + flat
meter per meter size per
billing cycle.
4 Account types and rate
codes are site-defined. The
Rate Master’s program
maintains information used
to calculate charges
4 – Flat rate water billing
is supported in our rate
set-up and can be based
on meter size or
consumption.

Rating-4: Standard invoice
functionality can be used.

R 127. Prorate Water
bills based on
days of service.

Rating 4 - This requirement is
standard and available in the
proposed software version.
4, Springbrook has a variety of
ways to handle proration.
-Prorate minimum & prorate
high – are toggles that help to
prorate a minimum or flat
amount for new and final
billings. This will prorate the
amount for final billings or new
accounts within the billing
period.
-prorate consumption - allows
you to prorate the consumption
associated with the winter
averaging process to be
prorated by the percentage of
period the rate was effective
for.
-Prorate Steps – allow you to
toggle if you would like the
consumption amount level
breaks associated with each tier
of the service rate to be
prorated by the percentage that
the service rate was effective
during the period. This affects
the winter average process.
-Prorate by read date -
prorating based on the read
date of the meters on the
billing. For example, if meters

4. Flexible rate engine,
proration is configurable
during implementation.
4 The Utility Billing system
supports several different
methods of proration
including days of service.
4 – The system prorates
bills based on days of
service.

Rating-4: Standard invoice
functionality can be used.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
are read on the 15th of each
month and the service rate
becomes active on the 11th,
only five days of the billing will
be calculated using the new
service rate structure.

We also have a Prorate accts
over 100% in the Utilities Setup
will that helps to define whether
we need to be billed for more
than a month – overall, date will
drive the proration.

R 128. Add
miscellaneous
charges to
bills:
a. Service
setup =
$38 plus
water
service
b. Broken
locks =
$100
c. Shut Off
notice =
$50
a. Rating: 4 The software supports
adding a service setup fee to the
customer's bill.
b. Rating: 4 The software supports
adding a broken lock fee to the
customer's bill.
c. Rating: 4 The software supports
adding a shut-off notice fee to the
customer's bill.
4, you can set up different fees
that can be included onto their
bills.

4. Flexible rate engine and
these miscellaneous charges
are supported.
4 Account types and rate codes
are site-defined. The Rate
Master’s program maintains
information used to calculate
charges
4 – The City can set-up any
miscellaneous charge type
that can be added to a
customer's bill, including
the ones identified.

Rating-4: Standard invoice
can be created using
multiple invoice lines &
miscellaneous charges can
be captured at line level.

I 129. Record and
track time
when water
service is
turned on.

Rating: 4 The software supports
recording and tracking the time
when water service is turned on.
4, Springbrook can record and
track when the
utilities/services are turned on

4. With SpryMobile, this
activity is time stamped.
4 Date is recorded and can be
reported against.
4 – This would be
accomplished through our
service order and mobile
service order modules.

Rating-4: Can be captured at
Notes at transaction level.

R 130. Import meter
read
information
from Harmony
Meter Data
Management
and apply to
Rating: 3 The software can import
meter read information from
Harmony Meter Data
Management with the integration
of the Harmony Meter Data
Management application.
4, we can import all meter
reads

4. This is included in
implementation.
4 This is supported, assuming
use of compatible formats.
4: This would be a part of
the implementation
process. The Univerus CIS
system includes an MDM
module so data would need
to be consumed from
Harmony to Univerus.

Rating-2: Integration may be
required with Harmony
Meter Data Management
from Oracle.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
customer
account.

R 131. Flag and report
on missing
reads, zero
reads, no
changes in
consumption
month by
month, or
other
anomalies.

Rating: 4 The software can flag
and report on missing reads, zero
reads, no changes in consumption
month by month, or other
anomalies.
4, there are reports that will
show this information.

4. Managed during the Billing
Workflow but also could
include Custom
MetaBase Reports or KPIs
presented on a dashboard.
4 Standard and custom reports
can be utilized to surface the
scenarios listed. However,
this would not set a flag
automatically on the account.
4 – The CIS provides an
interactive view of all
accounts in a billing cycle
and flags the account for
missing reads or anomalies.

The billing representative
can then isolate the
account(s) to properly work
them to resolution. The
good accounts will proceed
to billing.

Rating-0 Not Available
R 132. Generate bill
file export –
provided to
outsourced
vendor for bill
generation and
mailing.

Rating: 4 The software can
generate a bill file export for
outsourced vendors to generate
and mail bills.
4, during the batch process
you will be able to export the
file.

4. Bill Print File Export
included in implementation
pricing.
4 Bill file export can be
created for use with 3rd
party bill print providers.
4 – The CIS system
produces a PDF of the bill
that can be printed inhouse by the City or send to
a third-party printer chosen
by the City.

Rating-4: Print Invoices
report can be used
R 133. Generate
billing for City
accounts and
automate
process to
record and
settle for
payment to
General Ledger
(without
generation of
Accounts
Payable check
and recording
of Cash
Receipt).

Rating: 4 The software can
generate billing for city accounts
and automate the process of
recording and settling for
payment to the General Ledger
without generating Accounts
Payable checks and recording of
cash receipt.

Added – please review 4. Clarification needed,
however SpryCIS does
integration with Accounts
Payment and includes a
robust Cash Receipt
functionality.
4 Supported with the use of
Enterprise ERP Financials.
4: Bills can be generated
through the system for
either City accounts or
consumer accounts.

Settlement to the General
Ledger is the same process.

More information is required
I 134. Flag or report
on temporary
water service
Rating: 4 The software can flag or
report on temporary water
service accounts that exceed 500
4, Thresholds can be defined
to indicate when account have
exceeded such values

4. Managed during the Billing
Workflow but also could
include Custom
4 Via special conditions code.
4 – Flags can be set to
detect and report on
consumption that exceeds a
Rating-0 Not Available

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
accounts that
exceed 500
cubic feet
consumption
per month.
cubic feet consumption per
month.

MetaBase Reports. specific threshold.

R 135. Flag accounts
as Do Not Shut
Off and
reason, e.g.,
medical, on
payment plan,
leak
investigation,
etc.

Rating: 4 The software can flag
accounts as Do Not Shut Off and
provide a reason, such as medical,
on a payment plan, leak
investigation, etc.
4, Springbrook offers Do Not
Shut off indicators and
reasoning to an account

4. Special Payment
Arrangement (SPA)
customers can be exempt
from late fees and
disconnects via
configuration.
4 Special conditions can be
defined for any of the
aforementioned instances.
4 – A flag can be set for
non-shutoff for specific
reasons including the ones
identified.

Rating-4: Oracle supports
these requirements
R 136. Searchable
customer
history by
parcel, name,
address, etc.

View accounts,
service orders,
work orders,
meter
replacements,
communicatio
ns, complaints,
resolutions,
etc.

Rating: 4 The software provides a
searchable customer history by
parcel, name, address, etc., and
allows viewing of accounts,
service orders, work orders,
meter replacements,
communications, complaints,
resolutions, etc.
4, we have a wide range of
search criteria

4. Google like search in
SpryPoint platform.
4 Via audit history. Standard
reports may suffice, in
addition, custom reports
can be created as needed.
4 – Our ERP suite provides a
very robust and flexible
search capability on any
data element contained in
the system. These data
views are interactive.

Rating-4: Review customer
accounts work area meets
these requirements.

R 137. Generate
workflow
review for
accounts
designated for
shut-off.

Rating: 4 The software can
generate a workflow review for
accounts designated for shut-off.
4, Workflows can help to take
care of accounts and shutoffs

4. Ability to flag accounts
designated for shutoff as a
task ad a report can
generated for cut/shut off
accounts per cycle. Service
order can also be generated
for shut-off.
4 Based on basic workflow
setup.
4 – Our ERP suite provides a
full workflow for accounts
moving to shut-off. This is
accomplished through the
service order and mobile
service order modules.

Rating-0 Not Available
R 138. Generate
email or text
notification to
work crew
Rating: 4 The software can
generate email or text
notifications to the work crew
when payment is received for an
4, Emails can be utilized 4. SpryMobile and SpryCIS is
on the same platform.

Updates in SpryCIS can be
sent to SpryMobile in real0
Not supported
4 – This functionality is
included in our mobile field
service order module.

Rating-4 Oracle fusion
Advanced collections module
support this requirement

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
when payment
is received for
account
designated as
a shut-off.
account designated for shut-off. time to handle this scenario.

R 139. Issue credit for
bill
adjustments
and apply to
next billing
cycle.

Rating: 4 The software can issue a
credit for bill adjustments and
apply it to the next billing cycle.
4, you can create an
adjustment

4. SpryCIS includes a very
flexible rate engine.
4 Bill credits can be applied
and balances can be
deferred to the next billing
cycle when desired.
4 – A CSR or billing
representative can create
an adjustment to an
account and apply it to the
next bill.

Rating-4: Credit memo
functionality can be used
R 140. Interface with
Accounts
Payable to
process
customer
refunds.

Rating: 4 The software can
interface with Accounts Payable
to process customer refunds.
4, refunds will integrate over
to AP to print the refund check
and send out to customer.

4. SpryCIS includes interface
with Accounts Payable to
process customer refunds.
4 Fully integrated with
proposed Enterprise
Accounts Payable
4: This can be handled
through the A/P module or
done through the billing
system
Rating-4: Oracle supports
customer refunds through
Accounts Payable.

R 141. Generate past
due letters
with late fees
after 60 days
in arrears.

Rating: 4 The software can
generate past due letters with
late fees after 60 days in arrears.
4, you can process a past due
batch.

4. Past due letters with late
fees can be generated in
SpryCIS. Past due dates can
be configured per customer’s
requirements.
4 Multiple letter/statement
output options are available
in addition to the use of mail
merge.
4 – Our ERP suite has a
flexible dunning capability
allowing the City to apply
late fees at a specific time.

Rating-4: Oracle seeded
reports can be used to meet
these requirements.

R 142. Establish and
track
extensions and
payment
arrangements
with different
terms (weekly,
bi-weekly,
monthly).

Rating: 4 The software can
establish and track extensions and
payment arrangements with
different terms, such as weekly,
bi-weekly, monthly.
4, Budget and Payment Plans
are possible in Springbrook

4. SpryCIS has robust
payment arrangement
functionality which includes
automated tracking and
processes if a customer fails
or breaks the arrangement.

This is configurable and
allows functionality like
configurable exceptions by
amounts and grace periods.
2 Payment plans are
supported, however
extensions are not currently
supported. Analysis needed
to quote.
4 – The system has a very
user flexible payment
arrangement capability
permitting the City to set
the frequency.

Rating-4: Payment terms for
different periods can be
defined.

R 143. Describe
available
Collection
Management
functionality
including
Rating: 3 The software supports
Collection Management
functionality, including notes,
correspondence, and collection
actions, but requires integration
with a third-party software
4, The Collections process is
used to write off the balance
of selected UB customer
accounts and will create an
adjustment type transaction
on the accounts. The Generate

4. SpryPoint Collections
provides notification to
customers of past due
payments. Configuration of
collection activities is user
definable by customer class
4 Tyler’s Collection and Billing
feature allows you to
schedule all delinquent
processing steps to run
automatically. This allows
4 – Our ERP suite delivers
collection management
functionality capable of
handling a flexible
collection process including
the ability to have a process
Rating-4: Oracle Advanced
Collections module can be
used for collection
management

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
notes,
correspondenc
e, collection
actions, etc.
application. step (UB> Collections>
Generate) of the process is
used to select the customer
accounts to process in the
batch. The balance of the
customer accounts will be
written off using the general
ledger accounts attached to
the service rates and fee codes
being written off. The
Collections adjustment type
code (UB> Utilities> Setup>
General tab> Collections
Adjustment Type field)
determines which general
ledger accounts attached to
the service rates and fee codes
on the customer accounts will
be used in the journal entry
created by the Collections
process. The collections
adjustment type code will also
display on the transaction line
item created on the customer
account
and can be triggered
automatically based on other
processes. Collections can also
interface with external
collection agencies who assist
with the recovery of bad debt.

Collection routines can be
segmented by Account Types
(residential, commercial,
industrial, etc.) and is also run
based on various statuses
including: Active, Inactive, final
bill disconnect etc.

Correspondent notices are
traced and stored in SpryCIS.

SpryCIS can create an export
file for the collection agency
which is typically exported in a
CSV format during the process
stage. Upon collection of funds
by the collection agency, a
payment import file of
payments is returned in the
same format which is easily
imported into SpryCIS.

Imported payments are
automatically applied against
the receivable balance of the
customer. SpryCIS will also
track the total amount that has
been collected by the
Collection Agency for reporting
and audit purposes.
your business rules and
procedures to do the work for
you.

Manage multiple active billing
cycles across your utility and
email statements
Support electric billing
functionality such as demand,
KVAR, and KWH
Accommodate all charges and
services with flexible rate
setup for consumption or flat
rates
Flexible bill statement
designs, including
consumption graphs
Send delinquent notices
automatically, apply late fees,
and run the shut off list at the
time of your choosing
Provide bill services at
different frequencies and on
the same statement
for each customer class.

R 144. Query: usage
within a data
range, peak
consumption,
etc.

Rating: 4 The software can query
usage within a data range, peak
consumption, etc.
4, all of this can be done in our
reporting tool.

4. SpryPoint's platform embeds
Metabase as an easy-to-use,
open-source business
intelligence tool to empower
users to access data. It allows
users to inquire about data
4 Standard reports may suffice,
additional custom reports can
be created as needed.
4 – In addition to the
Unity Analytics, which
show these data metrics,
the City can use any thirdparty tool to query data.

More information is
required

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
through ad-hoc queries and
provides answers in intuitive
formats such as charts, bar
graphs, tables, or dashboards.

Metabase will allow you to
easily transition from your data
to beautiful graphs and charts
with just a few clicks.

Metabase can be used with
data from a variety of
databases and data sources.

Users do not need to know SQL
to create visualizations, but
Metabase supports SQL for
advanced customization.

R Cashiering/Cash
Receipts
R 145. Centralized
cashiering for
multiple
departments
and locations.

Rating: 4 The software supports
centralized cashiering for multiple
departments and locations out of
the box.
4, you can have as many
cashiering.

4. SpryCIS Cashiering supports
payments for all receivables.
4 Application supports an
unlimited number of
departments/locations to
collect concurrent payments
4 - Our ERP suite has the
ability to include cash
receipt functionality that is
integrated with all other
system modules, multiple
departments and locations.

Rating-4: Oracle supports
Centralized cashiering for
multiple departments &
locations.

R 146. Customer lookup by wild
card, address,
phone
number, last
name.

Rating: 4 The software supports
customer look-up by wildcard,
address, phone number, last
name out of the box.
4, we had a wide range of
search criteria

4. SpryCIS search
functionality is like google
search
4 Look-up parameters are
defined by the individual
receivable applications.

Most support the items
listed here and wild card
type searches.
4 - The system has the
ability to search by wild
cards, phone number, last
name, etc. based on
security permissions.

Rating-4: Oracle supports
these requirements.

I 147. Centralized
view of
receivables
including
Miscellaneous
Billings,
Permits, Code
Rating: 4 The software supports a
centralized view of receivables
including Miscellaneous Billings,
Permits, Code Violations, Business
Licenses, Utility bills, etc. out of
the box.
4, this is where you will see all
payments flow through for all
modules.

4. SpryCIS Cashiering supports
payments for all receivables.
4 Supported with receivables
managed by EERP. Some
functionality related to
permits would require
integrated Permits solution
not currently proposed.
4 - The system has the
ability to provide
customizable screens
based on roles and
permissions.

Rating-4: Review customer
accounts work area
provides these
requirements.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
Violations,
Business
Licenses,
Utility bills,
etc.

R 148. Customizable
receipt format
by functional
area, e.g.,
header, layout,
fields, size,
comments or
messages, etc.

Rating: 4 The software supports
customizable receipt formats by
functional area, such as header,
layout, fields, size, comments, or
messages out of the box.
4, System Wide Access allows
for the configuration of
receipts, invoices, etc.

4. Receipt formats are
configured during
implementation and is
included in our
implementation costs.
4 A general receipt layout can
be defined for the system,
override formats are
defined by department, if
needed.
4 – Receipts can be
configured to meet the
desired look and
requirements for each
functional area.

Rating-2: Receipt format can
be customized based on
business requirements.

I 149. Compatible
with check
scan and MICR
reading
hardware for
checks.

Rating: 3 The software requires
integration with third-party check
scan and MICR reading hardware
for checks.
4, yes 0. The system does not include
a scanner. Check images can be
imported and/or attached to
payment records
4 Yes. See the current
supported hardware matrix
for the hardware needed to
support this requirement.
2 – This would be a custom
modification. Price included
in customization hours in
proposal.

Rating-4: Oracle supports
this requirement.

R 150. PCI-compliant
online
payment
gateway for all
receivables.

Currently using
Paymentus.

Rating: 4 The software supports a
PCI-compliant online payment
gateway for all receivables out of
the box, and Paymentus is
currently being used.
4, yes 4. SpryCIS has integration to
Paymentus (SpryPoint
partner).
4 The Cashiering application is
PCI complaint and passed an
annual
certification/recertification
process. Paymentus is not a
supported gateway for
Cashiering
4 – Our solution meets the
latest version of PCI for
processing of credit card
payments. We have a
range of payment partners
and have an active
integration with
Paymentus.

Rating-0: Oracle does not
provide payment gateway.

R 151. Real time or
batch posting
of receipts to
the General
Ledger. Prefer
real time for
updates to
Utility Billing
and Business
Licensing.

Rating: 4 The software supports
real-time or batch posting of
receipts to the General Ledger,
with a preference for real-time for
updates to Utility Billing and
Business Licensing, out of the box.
4, Real time posting to
integrated modules

4. SpryCIS includes
cashiering, with real time
updates to billing system.

Business licensing update will
require further discussion
4 Assumes All intra-tyler
integrations, and 3rd party
receivable integrations Via
compatible import/export
files where applicable.

Posting to the general
ledger is an end of day batch
process
4 –Our solutions as subledgers have a strict
financial control and
individual GL postings that
are completed in real time.

Daily reconciliation to the
main CIty ERP GL is advised.

Rating-4: Real time or batch
posting of receipts to the
general ledger is possible.

N 152. Partial Rating: 4 The software supports 4, Ability to accept partial 4. Payment priority hierarchy 4 4 - Our ERP suite has the Rating-4: Oracle supports Page 799 of 829

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
payment and
cash
application
hierarchy.
partial payment and cash
application hierarchy out of the
box.
payments as well as different
payment methods in one
transaction
is configurable. Payment
framework is flexible.

Partial payments, over
payments and payment
distribution rules are
applied by the receivable
applications and are
reflected in Cashiering.
ability for customers to
select the desired bill to pay
and make a partial payment
when more than one bill is
outstanding. The system
has the ability to record
type of payment (e.g.,
check, money order, cash,
credit card) and a unique
reference number.
partial payment application
R 153. Capture
alternate
payee name.

Rating: 4 The software supports
the capture of an alternate payee
name out of the box.
4, Description and details can
help to capture additional
details, like payee name.

4. Alternate payee name can
be entered if required. This
can be configured.
4 The receivable’s owner
name defaults in as the
“payer name” on the
receipt, but can be
overwritten by the cashier
to a different name
4 - the POS solution allows
us to track additional
information on each
payment, including this type
of information
Rating-4: Alternate payee
name can be captured.

R 154. Add a 2.8%
credit card fee
to
transactions,
with ability to
waive by
customer type,
e.g., utility
customers.

Rating: 4 The software supports
adding a 2.8% credit card fee to
transactions, with the ability to
waive by customer type, such as
utility customers, out of the box.
4, Ability to set up different
fees that you can pass on to
the customer

4. Fully customizable this is
defined during bill set-up,
and receipt set-up during
implementation
4 Possible via configuration -
one credit card tender type
with a 2.8% fee for nonutility bill payments, and a
second tender type with no
fees (cost absorbed by the
City) for utility bill
payments.
4 - The system has the
ability to add user defined
fees to an account.

Rating-4: Miscellaneous
receipt can be created & can
associated with original
receipt or Transaction
adjustment functionality can
be used.

I 155. Allow partial
payments and
note balance
due and due
date on
receipt.

Rating: 4 The software allows
partial payments and notes
balance due and due date on the
receipt out of the box.
4, Springbrook Allows partial
payments and note balance
due and due date on receipt.

4. Partial payments can be
processed. Balance due and
due date on receipt is
configured during receipt
template set-up during
implementation.
4 Standard functionality but is
only available if the
integrating receivable
application supplies
Cashiering the data
requested here to print on
the receipt.
4 – A cash receipt can be
produced with:

Amount paid,
Tender type;
Balance forward;
Other balances due, by
type, date and
Other user-defined fields.

Rating-4: Partial payments
can be allowed & balance
due &due date can be
tracked at transactions level
or Review customer accounts
level.

R 156. Support backoffice entry to
Cashiering
solution.

Rating: 4 The software supports
back-office entry to the Cashiering
solution out of the box.
4, Full access to cashiering
solution

4. Back office users can have
access to Cashiering if they
have the correct
role/permission.
4 Cashiering supports multiple
entry modes including
“Counter” for face-to-face
activity and “Mail” for back4 – Back-office payment
entry is supported in the
system.

Rating-4: Oracle supports
Miscellaneous receipts
creation for miscellaneous
business requirements.

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
office processing, for
example
R Project and Grant
Accounting
R 157. Describe
Project and
Grant
accounting
functionality;
separate
module or in
chart of
accounts, or
both.

Rating: 4 The software should
have a separate module for
Project and Grant Accounting,
which is a standard functionality
and can be implemented out of
the box.
4, we offer a Project or Grant
Management module that is
used to gather transactions
from other modules and
generate reports summarizing
the information. Project
Management is integrated
pulling transactions generated
in other modules (AP, AR, CR,
GL, PR, ESS etc.). These are
sent to the PM module by
including a task and type code
on the transactions. It can be
used for very basic projects or
large complex projects that
span over multiple years.
4 Please refer to the
Enterprise ERP Project &
Grant Accounting product
overview.
4 – Our projects and grants
module is fully integrated
into the core ERP suite and
directly ties into the main
GL, AP, Projects, Purchasing
and Time entry processes to
ensure all costs for grant
reimbursement are
accurately tracked.

Implementation with PPM
and Grants application
R 158. Project master
file data to
include:
a. Project
Number or
Grant
Number
b. Project
Type,
Name,
Descriptio
n
c. Location
d. Subproject
, Phase,
Activity
e. Start and
End Dates
f. Status:

Active,
Rating: 4 All the data fields
mentioned in this item are
standard and should be available
in the software out of the box.
4, yes, we can capture all this
information. 4
The Project Master record
includes the following
information: Number,
Name, Description, Type,
Funding Sources, Project
budget, Grant, Contracts,
Locations, Sub Projects,
Major Project, Dates, Status
and more.
4 - The project master
provides all key information
about all projects in one
place. The project master
view can be easily tailored
to the specific data the City
needs to track for each
project with the project
master supporting as many
user-defined fields as
needed. The module can
easily be configured to
support the varying needs
between various
departments and their
differing project types.

Standard Features – 4

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
Inactive,
Warranty,
etc.
g. Budget
h. Funding
Sources
i. Attachme
nts
j. User
Defined
Fields
R 159. Multi-level
project
hierarchy with
ability to
report on
detail or
summary data.

Multi-level project hierarchy with
the ability to report on detail or
summary data. Rating: 4
Comment: Multi-level project
hierarchy is a standard
functionality that should be
available in the software out of
the box.
4, Tasks and Misc. Fields can
be used to create multi-level
project hierarchy.
4 May require SQL Server
Reporting Services
4 - Our ERP suite has the
ability to support
parent/child relationships
for projects and subprojects. The system will
generate user-defined
reports allowing changes to
the detail level of report
parameters.

Reporting Requirement- BIP
Reports – 2
R 160. Import labor
allocation from
payroll and
apply to
specific
projects
and/or grants.

Rating: 3 The software should
support the import of labor
allocation from payroll and apply
it to specific projects and/or
grants with the help of third-party
software, such as ADP, Workday,
or Kronos.
4, Payroll is fully integrated
into the budgets tied to
Project and Grant Accounting
4 Payroll can be allocated to
project strings and grants
can be associated to
projects. Enterprise Payroll
is directly integrated, but if
an import is required, then
flexible journal import
functionality can be used to
import to the desired GL
and/or project accounts and
grants can be tied to various
accounts as necessary.
4 – Our solution allows you
to manage project tasks,
costs, staffing and overhead
allocations. The Project
Accounting module can
integrate with all other
proposed system modules
including (but not limited
to) general ledger,
budgeting, accounts
receivable, accounts
payable, purchasing, grants,
and payroll.

Standard Feature-4
I 161. Project
Accounting
dashboard that
displays
percentage of
completion,
project status,
Rating: 4 The software should
have a standard Project
Accounting dashboard that
displays all the mentioned data
out of the box.
4, Tableau will allow for the
creation of a dashboard to
display warranted data, in this
case a PA dashboard
4 Project Central provides
summary and detail views of
your organization's project
ledger data.

When the program opens, all
the projects to which you
4 - Our ERP suite has the
ability to provide a usercustomizable dashboard
with drill down capabilities.

Solution will accommodate
the list provided and
beyond.

Few existing standard
reports exist.

Reporting Requirement- BIP
Reports – 2

22.H.

Ranking Barupon Srpingbrook Sprypoint
UB-Cashiering Only
Tyler Universus
PDS
XT Global
open Purchase
Orders,
Change
Orders, budget
expended,
budget
remaining, etc.
have access are displayed.

Use the columns to sort by
criteria such as project type,
projected start and end date,
amounts, and whether any
warnings are associated with
the project.

When you click a project
code from Project Central,
the program refreshes to
display specific project
details, including expenses,
funding sources, and
warnings.

I 162. Close out a
project and
convert to an
asset.

Rating: 4 The software should
have a standard functionality to
close out a project and convert it
to an asset out of the box.
4, The payments made for the
asset will update Fixed Assets
but will not become an asset
until the user determines that
the project is completed. Or
we can also use the Work
Order module for Capital
Improvement projects that
will update as a Fixed Asset
upon completion of the
project.
4 ‘Flag Project for Creation of
a Capital Asset Record’
option is available when
closing a project which
indicates that the project
creates a capital asset
record upon closure, when
selected.
4 – Our solution has the
ability to close projects
either partially or
completely and can convert
to an asset without losing
the project history.

Standard Feature – 4
I 163. Grant
administration:
track
applications,
status, dates,
eligible
expenses, etc.

Rating: 4 The software should
have a standard Grant
administration functionality to
track all the mentioned data out
of the box.
4, In Project Management they
can track budgets, expenditures
and revenues for projects
4 Please refer to the Enterprise
ERP Project & Grant
Accounting product overview.
4 - The system has the
ability to track City-defined
information for grants.

Standard Feature – 4
R 164. Grant
management
accounting for
reimbursable
expenses.

Rating: 4 The software should
have a standard Grant
management accounting
functionality for reimbursable
expenses out of the box.
4 4
The Project Revenue
Allocation program allocates
expenses to their associated
funding sources. Funding
sources are defined as a
funding source string and
each string indicates an
4 - The system has the
ability to track and support
the process of
reimbursement requests
handling the invoice via the
projects module
Part of Configuration -4
If not fit with standard, we
can use pass model
wherever applicable – 2