FIRST AMENDMENT TO RFP #20-24 UMS DATABASE AND REPORT MIGRATION SERVICESFIRST AMENDMENT TO CONTRACT BETWEEN
CITY OF CLEARWATER AND WHITLOCK CONSULTING GROUP
RFP #20-24 UMS DATABASE AND REPORT MIGRATION SERVICES
THIS FIRST AMENDMENT, entered into this /5 day of ril 2025, by and
between the CITY OF CLEARWATER ("City'), a Florida municipal corporation, P.O. Box
4748, Clearwater, Florida 33758 and Whitlock Consulting Group, ("Whitlock" or "Vendor"),
32 Riverview Drive, Beaufort, SC 29907, collectively as "Parties".
WHEREAS, the City sought a qualified vendor who specialized in Utility
Billing/Management Systems and Project Management for upgrade and data migration in a
Cayenta Utility (Harris Group Computer Corp.) environment.
WHEREAS, the City selected Vendor based on Request for Proposal ("RFP") #20-24
and responses by Vendor to RFP #20-24, which are incorporated by reference.
WHEREAS, on June 6, 2024, the Parties entered into a contract for the performance
of the services as outlined in RFP #20-24 and the payment of those services ("Contract").
WHEREAS, the project is on-going and it is necessary to extend the time for
performance, add additional services in accordance with the RFP, and increase the
compensation paid to the Vendor.
NOW THEREFORE, in consideration of the mutual promises contained herein
and other good and valuable consideration, the City and Whitlock agree that the
1
above terms, recitals, and representations are true and accurate and are incorporated
herein by reference, and the Parties further agree as follows:
1. Section 2. TIME OF PERFORMANCE.
The initial Contract Term shall commence on June 1, 2024 and end on June 30, 2025.
This Contract shall be extended from June 30, 2025 until December 31, 2025.
2. Section 3. COMPENSATION.
The City will pay Vendor in an amount not to exceed $332,736.00, as more fully
described in attached Exhibit A, inclusive of all reasonable and necessary direct expenses, if
applicable. The City may, from time to time, require changes in the scope of the project. Such
changes, including any increase or decrease in the amount of Vendor's compensation, and any
other changes in the terms of this Contract which are mutually agreed upon by and between
City and Vendor shall be effective when incorporated in written amendment to this Contract,
upon mutual agreement.
The City will pay Vendor an additional not to exceed amount of $173,812.00,
as more fully described in attached Exhibit A.1 (Supplemental Statement of Work).
3. All other terms and conditions of this Contract which are not expressly amended
or deleted herein shall continue in full force and effect.
2
IN WITNESS WHEREOF, the Parties have caused this First Amendment to be
signed in its corporate/legal name by its authorized representatives or persons authorized to
execute this First Amendment on the date and year first above written.
WHITLOCK CONSULTING GROUP
Michael Whitlock
Founding Partner
CITY OF CLEARWATER, FLORIDA
Bruce Rect
Mayor
Approved as to fo m:
Owen Kohler
Lead Assistant City Attorney
3
Je fer Poirrier
City Manager
WC -C
III IIx F.
Exhibit A.1: Supplemental Statement of Work
Project — City of Clearwater Cayenta UMS Database and Report Migration Services
1.0 Cayenta Environment Migration Support
1.1 Project Summary
The City of Clearwater is currently engaged with WCG as defined by the SOW associated with P024000857, for
upgrading its Cayenta environment by migrating its database from Oracle to SQL Server, and its reporting system
from Actuate to Cognos. This is a supplemental statement of work is for two items, 1) extending the original scope
by 6 months for PM and BA services, July 2025 — December 2025, but only 2 months of costs for BA services is
added, with no other changes in scope, 2) adding optional services described in the original statement of work
related to developing custom reports and improvement opportunities. See section 2.0 below for more details on
the custom report and improvement opportunities.
2.0 Develop and Test Custom Reports and Improvement Opportunity
Discovery / Implementation:
The purpose of this document is to provide additional information and details related to what was previously an
optional scope item in City of Clearwater/WCG's existing contract, as seen below:
Developing Custom Reports
(2.1) WCG's time and material costs to develop and test custom reports or provide any other services beyond the
scope of this RFP is $185 per hour, not inclusive of travel expenses.
Improvement Opportunities
(2.2) WCG is pleased to offer long-term support and maintenance services specific to utilities using Cayenta
software solutions. Through these services, utilities are able to leverage our Cayenta knowledge experts to extend
the useful life of their current systems and deliver an ongoing continuous improvement mindset where efficiency
gains are delivered through enhanced core configuration and process design. Such improvement opportunities
include streamlined processes for a reduced burden on the City's staff, modernization via updated configuration
and third -party interfaces, and improved customer satisfaction.
2.1 Report Development — Task
WCG will develop and validate 55 reports/custom portal statistics as shown in exhibit 1 below.
All reports/custom portal statistics listed in Exhibit 1 below will be developed and validated prior to delivery to the
City of Clearwater for testing. WCG's development will be based on the completed discovery sessions held with
various departments at the City of Clearwater.
Note: No hours or estimates are included in this SOW related to the list of portal statistics to be developed by
Clearwater city staff. WCG can support in this area, with estimates to be provided if it becomes necessary.
2.2 Improvement Opportunity — Task
WCG will lead discovery sessions with the City of Clearwater to review their collections process and specifically the
Improvement Opportunities listed below. The discovery sessions and the resulting documentation will be handled
on a time and material basis.
See section 4.0 for additional cost information.
11Page
WC.6
WCG improvement opportunity selection...
Collections Process
Update configuration of collection streams to avoid
manual interventions and utilize automation for items
such as avoiding NPOs for first-time offenders /
Excellent credit customers
Collections Process
Need to increase the collection fee to act as a stronger
deterrent and collect payment earlier
Collections Process
Automate the Payment Extension functionality to avoid
manual scheduling / rescheduling of NPOs
Collections Process
Look into using alerts and intelligent service order
configuration to automate and protect against
unwarranted service orders (e.g. payment vouchers)
The below items were selected by Clearwater personnel...
Utilizing Cayenta's Auto Reconnect process would be
really helpful for apartment complexes to minimize turn-
on/turn-offs and help automate the notifications to
landlords
Mass move-in/move-out functionality would drastically
help with scenarios where apartments are changing
ownership and minimize entries of individual transactions
Add configuration that allows certain meter reading
trouble codes to auto -create the appropriate repair
service order (e.g. broken box/lid)
Need a workflow specifically built for the short-term turn -
ons with pre-set services, no deposit, and pre -scheduled
move -outs
Clearwater benefit from a basic MWM solution for basic
customer -centric service orders to provide real-time
integration with Cayenta and Invoice Cloud
Use service/account alerts and SO logic to automate the
removal of the extra solid waste container upon move -out
so that the new customer starts with the basic service
from Day 1
2IPage
WC -6
\\III II�H t,
Look into using Installment Billing as opposed to true Pay
Arrangement functionality to avoid the Pay Arrangement
coming due all at once and to clean-up the bill
presentment
Need to provide a 'Reconnect Amount' to make sure that
all appropriate fees are included and to allow for
automation of reconnecting after Disconnect for Non -
Payment
Could use portal statistics for better tracking and
accountability of open, aging service orders
3.0 Deliverables
3.1 Report Development — Deliverable
WCG will develop the SQL for items in Exhibit 1 where the Proposed Approach is labeled as "Custom Report." The
SQL will be validated against the available data, and the resulting information will be presented to a City of
Clearwater user before being handed over to the BA for Cognos development. WCG will not be responsible for
developing reports in Cognos. For items where the Proposed Approach is labeled as "Custom Portal Statistic," WCG
will configure and test the portal before delivering it to the end user for further testing.
3.2 Improvement Opportunity — Deliverable
WCG to lead and document discovery sessions related to the City of Clearwater's collection process. The output of
the discovery sessions will determine the exact improvement opportunities to implement.
4.0 Project Effort and Cost
4.1 Project Management and Business Analyst services (July 2025 — December 2025):
Project Role FTE Hourly Rate Monthly Value
Project Manager
Business Analyst
0.5 FTE
0.5 FTE
$160
$160
$13,864
$13,864
Project Role Monthly Value # of Months Total Value
Project Manager $13,864
Business Analyst $13,864
6
2
TOTAL CONSULTING VALUE:
$83,184
$27,728
$110,912
3IPage
WC -6
\\IIII Ian ti
4.2 Report Development:
WCG's estimate for completing the 55 reports is 300 hours and an amount not to exceed $55,500.
Deliverable
Hours Hourly Rate Cost
55 Reports
300
$185
$55,500
4.3 Improvement Opportunity:
WCG's estimate for completing discovery related to the collections process is 15 hours and an amount not to
exceed $7,400.
Deliverable
Hours Hourly Rate Cost
Discovery
Implementation
15
$185
$2,775
25 $185 $4,625
5.0 Invoice and Payment terms
5.1 Payment Terms
WCG will invoice the City of Clearwater monthly as set out in section 4.0. Payment terms will be net 30.
5.2 Travel Expenses
The only additional costs for these resources will come from any required travel expenses (lodging, meals, and
travel). The travel estimates included here are in-line with previous project experiences as a means of developing a
not -to -exceed amount for the contract. WCG will remain flexible throughout the project regarding the balance of
work being completed onsite and work being completed remotely.
Average Cost / Week
Flight $600
Rental Car $300
Hotel $800
Per Diem $375
Total Weekly Cost:
$2,075
Actual travel expenses for flights, mileage, hotel, and per diem will be billed monthly as incurred.
4IPage
A 11 r N t.
WG6 t(\i1 11..,
Exhibit 1
Cayenta Client Ref # Report Name Proposed
Ref Approach
Number
CW -CIS -
02
AR Aged Cycle
Less than Zero
Final
AR Aged Cycle Less than
Zero Final
Cayenta Portal Name:
"Final Accounts with
credit balance for write
off"
3. Custom Portal
Statistic
New Discovery Notes
This is used to evaluate Final
Accounts with Credit Balance.
CW has not written off credit
blances on accounts under $5 as
there was no policy until now.
CW will use this portal to analyse
those accounts and enter a
refund record or transfer the
balance if no refund is entered.
Portal Stat will look for final
accounts with remaining amount
/balance less than 0. Portal will
provide basic account
information along with move out
date and the difference between
current system date and move
out date as Number of days
since moved out. Additional
columns can be added to the
portal at the time of
development. (CW: please note
that in version 9.2 there is a
Refund Portal Stat that cayenta
built that is a one stop shop to
transfer the credit balance to
another account or enter a
refund for the account.)
CW -CIS -
07
CS021 Pending
Test and CS021
for Draft /
Bank Draft
CS021 Part 1
CS021 Pending Test and
CS021 for Draft / Bank
Draft CS021 Part 1
4. Custom Report
This report is required going
forward. Chris, Bernice and
Margaux will provide
requirements for this report, the
current sample is from the Draft
Table.
CW -CIS -
08
CS021 Pending
Test and CS021
for Draft /
Bank Draft
CS021 Part 2
CS021 Pending Test and
CS021 for Draft / Bank
Draft CS021 Part 2
4. Custom Report
This report is required going
forward. Chris, Bernice and
Margaux will provide
requirements for this report, the
current sample is from the Draft
Table.
5IPage
WC -6
\\Ii1(II
�. 1�
,,.., 111Ar.
CW -CIS-
09
Inbill ageing
report AKA
Inbill ageing
accts detail
Inbill ageing report AKA
Inbill ageing accts detail
3. Custom Portal
Statistic
This is for accounts that are
pending to be billed. We will
work with the development
team to do this as a portal stat.
However, we might be able to
get some new portals that are
core in the SQL version under
the service billing portion that
might support this report.
Sample from Xavier in Email.
"Service Billing Portal Stats
should provide everything that
Billing Team needs". This
estimate will be removed if the
Service Billing Stats are
available.
CW -CIS-
17
Deposits
Deposits
4. Custom Report
Current Cayenta has a core
report- Security Deposits on
Account that will provide the
required information. If the
report needs to be modified to
include other information, we
can do so. We will build a
separate report only for the
Non -Cash Deposits.
CW-
GAS -03
Cut_cap
NG Meters By Address
Cognos Report Name:
Cut and Cap Locations
4. Custom Report
The Cup and Cap Actuate report
contains a flawed assumption
regarding the cut and cap date
column. It mistakenly equates
the service pull date with the
date when the service line was
actually cut and capped. To
accurately determine if a
location has been cut and
capped, we need to verify that a
cup and cap service order was
completed. That serves as a
definitive record of the work
performed.
CW-PU-
03
Test Back Flow
RC
back flows for testing by
route
10. Duplicate
reclaim residential (COMBINED) -
Same as CW-PU-01
CW-PU-
04
Test Back Flow
RC
back flows for testing by
route
10. Duplicate
reclaim residential and
commercial reclaim (COMBINED)
-Same as CW-PU-01
6IPage
A I I I II, t 1.
WC6
CW-PU-
05
Test Back Flow
RRCR
Back flows for testing by
route
10. Duplicate
residential and residential
reclaim (COMBINED) -Same as
CW-PU-01
CW-PU-
06
RWTRM
SWFWMD
FY22/23 Reclaimed
water consumption by
Project Area
4. Custom Report
This report is used annually and
monthly to check on all the
backflow testing that has been
done already. Report conditions
do not change. This is run by the
fiscal year. Oct 1- sept 31 is
fiscal. Provide consumption in
gallons.
CW-PU-
07
BF_Details_sry
_DEP
Backflow Details by type
and size
10. Duplicate
This is part of CCP- cross
connection control program.
Currently they search for
parameters after they run the
report. Going forward, the
report will contain parameters
that will be entered by the user
before they run the report.
Report output will be in excel, so
a user can filter the data after
the report has been run.
CW-PU-
08
PW004Keith
Water Consumptions
(residential)
10. Duplicate
This is meter reading data by
location. Allow the user to enter
the location class as a parameter
or Generic_cd_1, service type
and range of bill date --this is
part of CCP -To be included in the
Assembly report
CW-PU-
10
Pw004keith(1)
Water Consumptions
(commercial) (Same
report as above, except
the parameter value is
different).
10. Duplicate
same as PW004Keith-To be
included in the Assembly report
CW-PU-
11
Cross
Connection
Program
8. To Be
Determined
To be included in the Assembly
report
CW-PU-
13
Meter Change
Out
Meter Shop requirements ??
CW-PU-
14
Assembly
report
Assembly report
4. Custom Report
goal is to combine or streamline
the assembly report against
Keith reports and the reclaimed
water consumption report. The
estimate provided is to either
7IPage
\\11111,4 1.
WC -6 11.,.
Wage
combine reports or provide
several reports that can be used
for Cross Connection program or
otherwise.
CW -SW-
SW1
Possibly Closed in Error
3. Custom Portal
Create a report where the SO
01
(SO_Possibly_Closed_In
Error)
Statistic
was closed where the resolution
date is before the effective date,
include cancelled SO. Once a SO
has been reviewed, they can
click a button to add a preset
comment (config required) that
will then remove the record
from the portal stat. Portal will
look for records closed before
the effective date for the last 30
days from the resolution date.
RODMP, ROPUL, ROADD, ROSET,
CODMP, COPUL, COADD, COSET
CW -SW-
SW2
Routing Record Possible
4. Custom Report
SW Installed Assets Master
02
Errors
(RoutingRecordPossible
Errors)
Report: This report includes all
locations with a SWWB and SWF
service type where an asset is
installed and the pull date is null.
Users can filter the data based
on asset attributes and extended
attributes. It will also display
information on the active bill
codes linked to the Service Type
for the current account
associated with each location.
This report will also include data
for Shared Groups # and Address
attribute as these are asset
attributes. The report will also
provide data on the routes
assigned to each asset. Cognos
will provide a dropdown list of
values for each filter parameter
to streamline data filtering. This
report is designed to replace
several Actuate reports used to
identify data discrepancies
through various parameter
combinations. The report will be
available in Excel format,
allowing users to perform
Wage
WCC II
9IPage
additional data filtering within
Excel.
CW -SW-
SW5
Open Service Orders
4. Custom Report
Open and Resolved Service
05
(openSObyDistrib/
openSObyBillCycle)
Order Report: This report allows
the end user to filter data based
on Effective date, Resolved date.
Report built in Cognos, SQL
provided by Cayenta. Action
Codes included in the report :
#TDMP, #EDMP, #BDMP,
#RDMP, BBRPR, BBRPC, BBPUL,
BBSET, BBADD, RCRPR, RCRPC,
RCPUL, RCSET, RCADD, RBRPR,
RBRPC, RBPUL, RBSET, RBADD,
RCXPU, BBXPU, CTXPU, CTLOC,
CTRPR, CTRPC, CTPUL, CTSET,
CTADD, CTLNS, CTLND, CTLNP,
RORPC, RODMP, ROPUL, ROADD,
ROSET, ROLOC, RORPR, CORPC,
CODMP, COPUL, COADD, COSET,
COLOC, CORPR
CW -SW-
entered_events_SW6_o
4. Custom Report
Billable Event Master Report:
06
utput
This report includes data on all
Billable events (UM00285T)
entered in the system. User will
have the ability to filter the data
by Active and Final Accounts.
Date Range using the Trxn Date,
Asset Type, Product Quality,
Prod Destination, Billed,
Consumption Amount range will
be other parameters available in
the report. User can also request
to add additional filters that are
based on data on Location or
account such as Location class.
9IPage
WOG
CW -SW-
SW6
Hardship Letter -Portal
3. Custom Portal
A portal stat will be developed
07
Stat
Statistic
with additional discovery to
determine the criteria on who
receives the letter. The customer
has 60 days to respond. Manual
actions are taken by the SW
department once the customer
•
replies. The letter is based on
the assigned bill code: SWBBM,
RCBIM, SWBMO, RCBOM.
The portal stat will call API
RUNREPORT:
<Request>
<RunReport>
<Params>
<S U BSYSTE M_I D></SUBSYSTEM_
ID>
<REP0RT_ID></REPORT_I D>
<REQUEST></REQUEST>
<JO B_YN></JO B_YN>
<Parameter_Name_1></Parame
ter_Name_1>
<Pa ra meter_N a me_2></Pa ra me
ter_Name_2>
</Params>
</RunReport>
</Request>
CW -SW-
08
SW6
Hardship by driver list
4. Custom Report
Cognos Report Required. The
accounts that are "HARDSHIP" is
identified using comments field
in UM00285T. The list is
provided to the driver. The
current SQL will be used to
design the report.This query use
a table that looks like it is from a
linked database (UMSLIVE).
Need to know how SQL will
handle that.
CW -SW-
SW6
Hardships
4. Custom Report
Hardship_by_address/
09
(Hardship_by_address/
Hardship_by_day_route/
Hardship_by_day_route
/ Hardship_by_name
Hardship_by_name - All three
reports will be converted to
Cognos reports and see where
we can combine the data to
reduce the number of reports.
Current SQL will be evaluated
before report is designed in
10IPage
,1011.4 h
11 Page
Cognos. This query use a table
that looks like it is from a linked
database (UMSLIVE). Need to
know how SQL will handle that.
CW -SW-
10
SW7
Hotsheet_by_driver
4. Custom Report
Cognos Report Required. The
accounts that are "HOTSHEET" is
identified using comments field
in UM00285T. The list is
provided to the driver. The
current SQL will be used to
design the report
CW -SW-
11
SW7
Hotsheets
(H ot_sh eet_by_day_rou
te/
Hot_sheet_Comm_by_d
ay_route/
Hot_sheet_Recyc_by_da
y_route
4. Custom Report
Hot_sheet_by_day_route/
Hot_sheet_Co m m_by_day_rout
e/
Hot_sheet_Recyc_by_day_route
- All three reports will be
converted to Cognos reports and
see where we can combine the
data to reduce the number of
reports. Current SQL will be
evaluated before report is
designed in Cognos.
CW -SW-
15
SW11
Roll Off Duplicate Entry
(RollOff_DuplicateEntrie
s)
3. Custom Portal
Statistic
Portal Stat Required. This will
look for all Billable Entries
completed today, to check if
there is a duplicate entry for the
same Location in the last 7 days.
CW -SW-
21
SW17
Possible Billing
Transaction Date Error
(BillingDataErrors_past)
3. Custom Portal
Statistic
Portal Stat Required. The portal
will show records where the Trxn
Date on the Billable event is
greater than current system date
. The record will not fall from the
report until it is fixed.
CW -SW-
22
SW17
Possible Billing
Transaction Date Error (
BillingDataErrors_future
3. Custom Portal
Statistic
Portal Stat Required. The portal
will show records where the Trxn
Date on the Billable event does
not match the Resolution Date if
the resolution date is not null.
The data will filter on the last 7
days.
CW -SW-
24
SW19
30 Day List
(SW013_30d_noservice
)
3. Custom Portal
Statistic
Portal Stat Required. SQL
Provided, this shows assets that
11 Page
WGG
12IPage
have not had a billable entry
record for more than 30 days.
CW -SW-
33
SW28
Billable Holdings by
Service Address
(SW005ACC)
4. Custom Report
Billable Holdings Master Report:
This report will provide
information about all billable
holdings for Locations that have
active accounts being billed. Bill
Codes will be included in this
report. The report will have
parameters to filter the data.
CW -SW-
38
SW33
Holdiay Routes
(SXF_SW0031_select_5o
rMore)
4. Custom Report
This report is printed for a
Holiday such as Christmas to
only send the truck that has pick
up for the day. Current SQL to be
be evaluated
CW -SW-
39
SW34
Roll off Jurisdiction Bill
Code Errors
(RollOff_Juris_BillCd_Err
ors)
3. Custom Portal
Statistic
Portal Stat Required. This will
look for all Billable Entries
completed today, if there are
errors in the Bill Code, they are
fixed before Billing runs.
CW -SW-
45
SW40
Dormant Accts vs Non-
Dormant Accts
(Dormant_NonDormant)
4. Custom Report
Current SQL on the report should
not be used. Billing team has a
portal stat that they are using.
Use the Portal Stat SQL to create
a report for SW department
Month End
SQL>AR
10. Duplicate
All invoice cloud payments.
SQL=Cash By Source Core report
AR Aging acct detail by summary
code. SQL and AR Aging acct
detail. SQL=AR295T Aging Report
Core report being modified for
you- CW -GAS -04
Month End
SQL>AR>AR
Reconciliation
2. System
Functionality
All Payment SQL will be covered
within the cash by source report
and Munis GL Interface. The
Refunds. SQL will be covered by
refund interface with Munis and
Refund Check Register Core
report.
Month End
SQL>Balance
Water - Sewer
9. Not Required
All the queries were only written
to offset entries for the Munis GL
interface. These are not required
going forward as the GL interface
12IPage
WCC
13IPage
will handle. No report required
out of these.
Month End
SQL>Class by
Juris
4. Custom Report
INT.sql- Interruptible accounts,
this will be required going
forward. Rest of the queries are
used on the GAS 1-10 FY2024
report, so may not be required
going forward.
Month End
SQL>ClassCoun
t
4. Custom Report
gasactivemeters.sql -Getting a
count on how many customers
are on a particular service. This
will be required going forward.
Activeflatsvc.sql is no longer
required.
Month End
SQL>NG LP
taxes
4. Custom Report
NG taxes GRT, FF, UT.sql=This is
for the Gas Department and is
required going forward. It will be
built in Cognos with the
appropriate Groupings and
details required. Use GL
Year/Period as the parameters
when running the report and the
end user can run it on their own.
LP tax UT.sql is no longer
required.
Month End
SQL>P&R
4. Custom Report
Consumption and Cost - This will
be required going forward.
Change the criteria to look for
the GL code from the Bank Draft
Agreement table and not first
name.
Month End
SQL>Service
Counts
4. Custom Report
By the end of the month are
CUTON for each different type of
service. This is required going
forward.
Create a summary report that
gives counts of locations with
service type where the service
status =CUTON, WCG can help
with the SQL
13IPage
WC -6
Awu,a
+,a I tlA+
14IPage
Month End
SQL>Solid
Waste &
Recycling
9. Not Required
RC & SWF SV CHG Report-Munis
Interface will provide the GL
amounts and the report can
come from Munis. Compared
against Month End reports in
cayenta.
Recycle Monthly Data Extract -
How much we are charging per
account as to what was billed?
This is used for reconciliation,
may not be needed in future.
SW SWF COLL Data Extract- what
we billed them for SW where
anyone with containers? This is
used for reconciliation, may not
be needed in future.
SW SWWB and UM262t-ar299t -
This is used for reconciliation,
may not be needed in future.
Month End
SQL>Tax
Exempt
Queries
4. Custom Report
taxexemptar-LP NG SW WTR -
these are required going
forward. Used by Billing to check
accounts were charged correctly,
if not, fix it in cayenta but do not
have to send Finance the
corrected amount as the
interface will do it
Month End
SQL>Ar by gas
sales item type
4. Custom Report
Gas Fees revenue- broken down
by what GL account/Item Type -
This report can be built in the
future but using GL Period/Year
as the parameter. You can also
use summary code as the
dropdown value so the report
can be used by multiple
departments. WCG can help with
the SQL.
Month End
SQL>Cenergisti
c Export
4. Custom Report
This is an export for a third party
software and is required going
forward. The current SQL will be
used to build a rpeort in Cognos
and emailed once a month
through Cognos.
14IPage
WC€
151Page
Month End
SQL>Database
Check
9. Not Required
Not required going forward.
Month End
SQL>Munis
9. Not Required
Part of the interface
Month End
SQL>Group
range
9. Not Required
Not required - will be replaced
by the use of GL Period/Year
Month End
SQL>GRT
Detail
9. Not Required
Currently used for reconciliation.
GRT has its own GL code and
Month End reports can be used
to reconcile.
CW -LTR-
02
CI51
Final Notice
12. Custom Letter
This is sent via collection stream.
We need to know what
collection stream uses this letter.
Do you use auto -connect? And
do you send letters to landlords
if the tenant does not pay?
CW -LTR-
03
CIS2
Returned Check
12. Custom Letter
This will be developed in Cognos.
CW -LTR-
04
CIS3
Cash Only
12. Custom Letter
This will be developed in Cognos.
CW -LTR-
05
CIS4
Pay Arrangement
12. Custom Letter
There is a core cognos letter
already if CW wants to use.
CW -LTR-
06
SW2
Hardship Letter -Cognos
4. Custom Report
Letter to be developed in
Cognos. Account No will be the
paremeter sent, that will be used
to derive the mailing address of
the customer.
WCG-CW-3
Munis Interface for GL
and Refund
The standard Cayenta process
will be followed for the GL and
Refund Interface.
GL Interface: A file will be
exported daily through a
scheduled job that runs after
midnight. A corresponding core
report will also be generated and
made available on the Cognos
report server for review and
sign -off before the file is
imported into Munis. No manual
changes should be made to the
file, which will follow the format
151Page
WCC
\1 l�f II�H ti
rArt t ttAt.
16IPage
provided by CW. The Munis test
system must be available to
import the file to test this
interface. Development of this
interface cannot proceed until
WCG-CW-1 and WCG-CW-2 are
completed.
Refund Interface: A file will be
generated after the check
generation process is run in
Cayenta. The Refund Check
Register core Cognos report can
be used for review and sign -off.
No manual changes should be
made to the file, which will
follow the format provided by
CW. The Munis test system must
be available to import the file for
testing the interface
16IPage
**** End of Statement of Work *****
17IPage