CCA 05/27/2014 �
� CITY COUNCIL MEETING OF MAY 27, 2014
GTY dF
FRIDLEY
The City of Fridley will not discriminate against or harass anyone in the admission or access to, or
treatment, or employment in its services, programs, or activities because of race, color, creed,
religion, national origin, sex, disability, age, marital status, sexual orientation or status with regard to
public assistance. Upon request, accommodation will be provided to allow individuals with
disabilities to participate in any of Fridley's services, programs, and activities. Hearing impaired
persons who need an interpreter or other persons with disabilities who require auxiliary aids should
contact Roberta Collins at 572-3500. (TTD/572-3534)
WORKSHOP— 6:30 P.M.
1. Updates from the Community Development
Department.
CITY COUNCIL MEETING (7:00 P.M.)
PLEDGE OF ALLEGIANCE.
PRESENTATION:
2013 Comprehensive Annual Financial Report
APPROVAL OF PROPOSED CONSENT AGENDA:
APPROVAL OF MINUTES:
City Council Meeting of May 12, 2014 .................................................................. 1 - 6
NEW BUSINESS:
1. Resolution in Support of an Application
for a Minnesota Lawful Gambling Premises
Permit for Fridley Lions at Broadway Bar &
Pizza Located at 8298 University Avenue NE
(Vllard 3) -
....................................................................................................... 7
FRIDLEY CITY COUNCIL MEETING OF MAY 27. 2014 PAGE 2
NEW BUSINESS (CONTINUED):
2. Resolution in Support of an Application
for a Minnesota Lawful Gambling Premises
Permit for Fridley American Legion Post 303
at Two Stooges Sports Bar and Grill Located
at 7178 University Avenue NE (Ward 3) ....................................................... 9 - 10
3. Motion to Approve Disbursement of the
Twin Cities Gateway Community Grant
Funds and Authorize Execution of 2014
Member City Marketing Grant
Agreement .................................................................................................... 11 - 13
4. Claims .......................................................................................................... 14 - 28
5. Licenses ....................................................................................................... 29 - 33
OPEN FORUM, VISITORS: Consideration of items not on Agenda — 15 minutes.
ADOPTION OF AGENDA.
NEW BUSINESS:
6. Resolution Approving a Contract with Tyler
Technologies for an Enterprise Resource
Planning (ERP) Solution ............................................................................... 34 - 99
7. Informal Status Reports ................................................................................ 100
ADJOURN.
CITY COUNCIL MEETING
CITY OF FRIDLEY
MAY 12,2014
The City Council meeting for the City of Fridley was called to order by Mayor Lund at 7:06 p.m.
ROLL CALL:
MEMBERS PRESENT: Mayor Lund
Councilmember Barnette
Councilmember Saeflce
Councilmember Varichak
Councilmember Bolkcom
OTHERS PRESENT: Wally Wysopal, City Manager
Deb Skogen, City Clerk
Greg Kottsick, Public Works
Don Abbott, Director of Public Safety
Darcy Erickson, City Attorney
PROCLAMATIONS:
Presented the following proclamations:
National Police Week: May 11-17, 2014
Peace Officers Memorial Day: May 15, 2014
Public Works Week: May 18-24, 2014
APPROVAL OF PROPOSED CONSENT AGENDA:
APPROVAL OF MINUTES:
Board of Appeal and Equalization Meeting of Apri114,2014
City Council Meeting of Apri128,2014
Councilmember Bolkcom indicated Jim Blazer's name is misspelled in the City Council
Meeting minutes. It should be Jim Glazer.
APPROVED AS CORRECTED.
1
FRIDLEY CITY COUNCIL MEETING OF MAY 12.2014 PAGE 2
OLD BUSINESS:
1. Second Reading of an Ordinance Amending Fridley City Code, Chapter 28,
Carnivals.
WAIVED THE READING OF THE ORDINANCE AND ADOPTED ORDINANCE NO.
1316 ON SECOND READING AND ORDERED PUBLICATION.
NEW BUSINESS:
2. Claims (163732 —163931)
APPROVED.
3. Licenses.
APPROVED THE LICENSES AS SUBMITTED AND AS ON FILE.
APPROVAL OF CONSENT AGENDA:
MOTION by Councilmember Barnette approving the proposed consent agenda. Seconded by
Councilmember Varichak.
UPON A VOICE VOTE, ALL VOTING AYE, MAYOR LUND DECLARED THE
MOTION CARRIED UNA1vIMOUSLY.
ADOPTION OF THE AGENDA:
MOTION by Councilmember Bolkcom to approve the agenda. Seconded by Councilmember
Saefke.
UPON A VOICE VOTE, ALL VOTING AYE, MAYOR LUND DECLARED THE
MOTION CARRIED UNANIMOUSLY.
OPEN FORUM:
No one from the audience spoke.
OLD BUSINESS
4. Resolution Waiving Requirement for Non-Qualifying Organization and Supporting
the Application for a Minnesota Lawful Gambling Premises Permit for Spring Lake
Park Lions at Broadway Bar and Pizza, Located at 8298 University Avenue N.E.
(Ward 3) (Continued Apri128,2014).
2
FRIDLEY CITY COUNCIL MEETING OF MAY 12,2014 PAGE 3
Mayor Lund removed himself from this item as he has personal interest being a member of the
Fridley Lions Club. He handed over the chair to Mayor Pro Tem Robert Barnette.
Debra A. Skogen, City Clerk, stated Minnesota state law requires a lawful gambling
organization applying for a state premise permit to obtain a resolution of support from the City
they will be conducting business in. Fridley City Code Section 603.25.2.E requires an
establishment to seek a qualifying organization. Section 30.02.1.B defines a qualifying
organization as one having one-third of its membership residing in the City or one having a
principal office or business in the City for a continuous period of at least one year. If the
establishment is unsuccessful at locating a qualifying organization, they shall attest to that fact.
City Council may waive this requirement for a non-qualifying organization.
Ms. Skogen stated Broadway Bar and Pizza's lease with Spring Lake Park Youth Hockey has
ended. Broadway Baz and Pizza did seek out and interviewed two qualifying organizations but
also interviewed three non-qualifying organizations. Based on the interviews, Broadway Bar and
Pizza determined Spring Lake Park Lions was the best fit for their organization. The City
received a premise permit application from the Spring Lake Park Lions for Broadway Bar and
Pizza at 8298 University Avenue NE, and Broadway Bar and Pizza and Spring Lake Park Lions
asked the City Council to grant a waiver allowing them to take on lawful gambling in Fridley as
a non-qualifying organization.
Ms. Skogen stated the premise permit was brought before the City Council on April 28, 2014,
for their review. City Council took testimony from the owner of Broadway Bar and Pizza, the
president and gambling manager of Spring Lake Park Lions, and the gambling manager of the
Fridley Lions.
Ms. Skogen stated currently there are no criteria in the CiTy Code for issuing a waiver.
Broadway Bax and Pizza have not provided the City with evidence required by the City Code
Sec. 603.25.2.E that qualifying organizations are not available or are uninterested in their site.
Such evidence would justify granting of the waiver.
Ms. Skogen stated staff's recommendation is to discuss and make a determination of the
direction Council wants to proceed by adopting the resolution to waive or deny the request. If
the City Council believes the intent of the City Code is to require a qualifying organization if one
is interested, the City should adopt the resolution denying the request for a waiver. The
resolutions in front of the Council may be amended or changed as they see fit.
Councilmember Bolkcom stated one of the reasons they continued the discussion until tonight
was to review the minutes. On Page 70 of the agenda book, in the minutes from the Council
meeting of Apri126, 2010, she had asked if it made sense to put criteria in the ordinance. City
Attorney Fritz Knaak responded "with the language in the ordinance, the idea is preference for
Fridley organizations and it must be stated so. If preference was created to Fridley organizations
it would make sense to have that be an ongoing preference. If no Fridley organization were
available and an establishment wants someone to come in, they may come in at the sufferance of
the City until a Fridley organization would want it. Council could waive this option without this
language in specific situations. Technically Council has the right to do that which may create a
3
FRIDLEY CITY COUNCIL MEETING OF MAY 12.2014 PAGE 4
situation where someone would consider an enforceable right to renewal and Council may find
them in a court case."
Councilmember Bolkcom said the discussion started because there were other communities that
would only allow organizations residing in their own community. Fridley wanted to do the same
thing. At the last meeting, there was a lot of discussion as to what "residing" meant. One-third
of its membership has to reside in Fridley. There was a discussion about what would happen if
no organization in Fridley came forward. From what she read throughout all the minutes, the
discussion was based on whether they wanted to give preference to Fridley's organizations and
be similar to a lot of other communities. Basically the waiver was put in there if there were no
organizations.
Councilmember Bolkcom stated in the current case, they do have an organization residing in
Fridley who wanted to have this gambling license. There was a lot of discussion and they ended
up saying there does not need to be any criteria because if there is an organization that resides in
Fridley, they would get preference. There would only be a waiver if no organization in Fridley
was interested. The City could then allow an organization outside of the City.
Mayor Pro Tem Barnette stated he agreed.
Councilmember Varichak stated it was nice to get the minutes to know they were on the right
track and have the minutes to reaffirm that.
Councilmember Bolkcom stated there was even discussion that each organization was supposed
to come forward by February 1.
Ms. Skogen stated in 2010, the premise permits went from being approved semi-annually to
being approved perpetually. At the time the ordinance was drafted, there was only one Fridley
organization, other than the American Legion, the VFW and the Knights of Columbus, who held
their own charitable gambling in their own buildings. The other organizations were all from
outside the City. When the City surveyed the surrounding communities in 2010 and again this
year, they found that three of the seven do have preferences and only allow organizations from
their communities. The other four do not.
Ms. Skogen stated this came forward because Broadway Bar and Pizza interviewed and they
wanted to have the establishment of their choice. There could be some different interpretations
from the way the ordinance is currently written, which is why staff is suggesting two resolutions.
If Council felt the discussion and the intent of the ordinance is that it is only be for a qualifying
organization,this would provide them additional evidence in support of the ordinance.
Councilmember Bolkcom stated Ms. Skogen mentioned the establishment needs to present
evidence. Where is that referenced?
Ms. Skogen replied it is a discussion she and the City Attorney have had. The evidence would
be that they went out to seek some different organizations. They may have found them, but they
were not interested or available. They did go out and they did seek the organizations.
4
FRIDLEY CITY COUNCIL MEETING OF MAY 12,2014 PAGE 5
Councilmember Bolkcom asked Ms. Skogen for clarification. Is she talking about when an
establishment seeks organizations to come into their facility and there is no qualifying
organization?
Ms. Skogen replied another organization would be seeking a premises permit for Two Stooges.
They have interviewed and will be going with the American Legion. However, if the Legion
was not interested and because the Fridley Lions had ceased their operation there, the evidence
they would bring in is that the Legion was not interested and the Lions had closed their operation
so they needed a waiver to bring in somebody else. In this case it is a little bit different.
Reading the ordinance the way it is written, even knowing the background, it needs to be
clarified a little bit more. That is why staff brought it forward this way.
Councilmember Bolkcom stated what Ms. Skogen is saying is that from the intent of the
minutes, if you read the minutes from the past meetings, it was the intent of the Council at that
time to give a preference to an organization in Fridley but that it also made sense to put
something in so there could be a waiver if there was not an organization in our City. That way,
the establishment could still have a charitable organization in their establishment. That is how
she remembered the whole conversation. It would probably make sense to go back and look at
that ordinance and maybe develop criteria.
Wally Wysopal, City Manager, stated what Councilmember Bolkcom pointed out is exactly the
dilemma the staff was in. The ordinance does not reflect what the Council desired and just made
a blanket statement that a petitioner can request a waiver. The objective standards, for staff to
interpret that, do not exist. Therefore, it had to come back to Council for clarification. It would
be helpful to have that ordinance clarified. At least now they have it on record that Council's
interpretation of the waiver means there are no other Fridley organizations that are available to
provide that service. What they are being presented with is a request for waiver that there are
available organizations, but they prefer to use someone else. That is just the clarification they
are looking for.
Darcy Erickson, City Attorney, stated Mr. Wysopal has adequately described it. Once you
review the record, the minutes of the prior City Council meetings back in 2010, they contain
references to creating a more restrictive environment and creating a preference to local
organizations. They are a good source of what the intent of the current ordinance is. That is
accurately stated as there probably is an organization that is qualifying and interested, but the
preference of the applicant is for an outside organization.
MOTION by Councilmember Bolkcom to adopt Resolution No. 2014-38, Resolution Denying
Waiver of Requirement for Qualifying Organization for Minnesota Lawful Gambling Premises
Permit for Spring Lake Park Lions at Broadway Bar and Pizza Located at 8298 University
Avenue NE. Seconded by Councilmember Saefke.
UPON A VOICE VOTE, ALL VOTING AYE, WITH MAYOR LUND ABSTAINING,
MAYOR PRO TEM BARNETTE DECLARED THE MOTION CARRIED
UNANIMOUSLY.
� 5
FRIDLEY CITY COUNCIL MEETING OF MAY 12.2014 PAGE 6
5. Informal Status Report. None.
ADJOURN:
MOTION by Councilmember Barnette to adjourn. Seconded by Councilmember Varichak.
UPON A VOICE VOTE, ALL VOTING AYE, MAYOR LUND DECLARED THE
MOTION CARRIED UNANIMOUSLY AND THE MEETING ADJOURNED AT
7:37 P.M.
Respectfully submitted by,
Denise M. Johnson Scott J. Lund
Recording Secretary Mayor
6
i AGENDA ITEM
CITY COUNCIL MEETING OF
°TM°F May 27, 2014
r�o��r
To: Walter Wysopal, City Manager�%���/
From: Debra A. Skogen, City Clerk�
Date: May 22,2014
Re: RESOLiITION IN SUPPORT OF AN APPLICATION FOR A MINNESOTA
LAWFUL GAMBLING PREMISE PERMIT FOR FRIDLEY LIONS AT
BROADWAY BAR&PIZZA LOCATED AT 8298 AVENUE NE
Minnesota State Law requires a gambling organization applying for a State Premise Permit to
contact the City in which it will be conducting lawful gambling in to provide a resolution in
support of their application. The City received an application Brad Sieloff, Gambling Manager
for the Fridley Lions to obtain a premise pernut at Broadway Bar&Pizza located at 8298
University Avenue NE.
Spring Lake Park Youth Hockey had been conducting lawful gambling at Broadway Bar and
Pizza until the lease was cancelled in March. Changes to the City Code require the
establishment to work with a City organization. The Fridley Lions is a qualifying organization.
Staff contacted the MN Gambling Control Board to see if there were any outstanding issues with
the organization. There were none. In addition, the Fridley Police Department had no issues
with the Fridley Lions.
Staff recoxnmends the City Council adopt a resolution in support of the Fridley Lions application
of a lawful gambling premise permit for Broadway Bar and Pizza located at 8298 University Ave
NE.
7
RESOLUTION NO. 2014-
A RESOLUTION IN SUPPORT OF AN APPLICATION
FOR A MINNESOTA LAWFUL GAMBLING PREMISES PERMIT
FOR FRIDLEY LION5 AT BROADWAY BAR& PIZZA
LOCATED AT 8298 UNIVERSITY AVENUE NE
WHEREAS, the City of Fridley has been served with a copy of an Application for a Minnesota
Lawful Gambling Premise Permit from Fridley Lions; and
WHEREAS, the location of the Premise Permit is for Broadway Bar and Pizza located at 8298
University Avenue NE; and
WHEREAS, the Fridley Lions is a qualifying organization and currently holds one license for
lawful gambling at the Shortstop—Fridley; and
WHEREAS, the City of Fridley has found no reason to restrict the location or deny the
application for lawful gambling purposes.
NOW, THEREFORE BE IT RESOLVED that the City Council of the City of Fridley hereby
supports the Minnesota Lawful Gambling Premise Permit Application for the Fridley Lions
located at Broadway Bar&Pizza located at 8298 University Avenue NE, Fridley, Minnesota.
PASSED AND ADOPTED BY THE CITY COUNCIL OF THE CITY OF FRIDLEY THIS
27th DAY OF MAY 2014.
Scott J. Lund, Mayor
ATTEST:
Debra A. 5kogen, City Clerk
8
/ AGENDA ITEM
� CITY COUNCIL MEETING OF
�� May 27, 2014
FRIDLEY
To: Walter Wysopal, City Manage����/
From: Debra A. Skogen, City Clerk �
Date: May 22, 2014
Re: RESOLUTION IN SUPPORT OF AN APPLICATION FOR A MINNESOTA
LAWFUL GAMBLING PREMISE PERMIT FOR FRIDLEY AMERICAN
LEGION POST 303 AT TWO STOOGES SPORTS BAR AND GRILL LOCATED
AT 7178 UNIVERSITY AVENUE NE
Minnesota State Law requires a gambling organization applying for a State Premise Permit to
contact the City in which it will be conducting lawful gambling in to provide a resolution�in
support of their application. The City received an application Steve Linder, Gambling Manager
for Fridley American Legion Post 303, located at 7365 Central Avenue NE, to obtain a premise
permit at Two Stooges Sports Bar and Crrill located at 7178 University Avenue NE.
The Fridley Lions had been conducting lawful gambling at Two Stooges until the lease was
cancelled in March. Changes to the City Code require the establishment to work with a City
organization. The Fridley American Legion is a qualifying organization.
Staff contacted the MN Gambling Control Board to see if there were any outstanding issues with
the organization. There were none. In addition,the Fridley Police Department had no issues
with for the Fridley American Legion Post 303.
Staff recommends the City Council adopt a resolution in support of the Fridley American
Legion's application for lawful gambling premise permit at Two Stooges Sports Bar and Grill
located at 7178 University Avenue NE.
9
RESOLUTION NO.2014-
A RESOLUTION IN SUPPORT OF AN APPLICATION
FOR A MINNESOTA LAWFUL GAMBLING PREMISES PERMIT
FOR FRIDLEY AMERICAN LEGION POST 303 AT TWO STOOGES SPORTS BAR
AND GRILL LOCATED AT 7178 UNIVERSITY AVENUE NE
WHEREAS, the City of Fridley has been served with a copy of an Application for a Minnesota
Lawful Gambling Premise Permit for Fridley American Legion Post 303; and
WHEREAS, the location of the Premise Peimit is for Two Stooges Sports Bar and Grill located
at 7178 University Avenue NE; and
WHEREAS, the Fridley American Legion Post 303 is a qualifying organization and currently
holds one license for lawful gambling at the Fridley American Legion Post 3031ocated at 7365
Central Avenue NE; and
WHEREAS, the City of Fridley has found no reason to restrict the location or deny the
application for lawful gambling purposes.
NOW, THEREFORE BE IT RESOLVED that the City Council of the City of Fridley hereby
supports the Minnesota Lawful Gambling Premise Permit Application for the Fridley American
Legion Post 303 located at Two Stooges Sports Bar and Grill located at 7178 University Avenue
NE, Fridley, Minnesota.
PASSED AND ADOPTED BY THE CITY COUNCIL OF THE CITY OF FRIDLEY THIS
27th DAY OF MAY 2014.
Scott J. Lund, Mayor
ATTEST:
Debra A. Skogen, City Clerk
10
/ AGENDA ITEM
� CITY COUNCIL MEETING OF
�°F MAY 27, 2014
FRIQLEY
To: Walter Wysopal, City Manage��%f/
From: Debra A. Skogen, City Clerk
Jack Kirk, Director of Parks and Recreation
Date: May 22,2014
Re: Approval of Twin Cities Gateway Community Grant Funds Dispersal and
Authorization and Execution of 2014 Member City Marketing Grant Agreement
The City of Fridley is a member of Twin Cities Gateway (TCG), a Tourism Bureau which collects
a 3%lodging t�on hoteUmotel properties. Fiscal year 2013 ended in February of 2014
(December receipts) showing lodging tax revenue was $780,759, 8% above the estimated revenue
for 2013. Of that amount,the lodging properties in the City of Fridley contributed$41,967.24,
which is $6,876 over fiscal year 2012, or 5.4%of the total revenue.
TCG budgets for a Member City Marketing Grant program providing a minimum grant of$3,000
to each City. In addition, it provides an incremental grant based on a percentage of the lodging
tax each city brought in for the previous year. In 2013,the Board of Directors approved a total of
$75,000 for marketing grants to member cities in the 2013 Annual Budget. ($27,000 to fund the
base amount and $48,000 to fund the incremental differences.) Based on that information the City
will receive a Community Grant for 2013 in the amount of:
Base Grant: $3,000
5.4%Incremental Grant 2 592
Total Grant $5,592
According to MN Statutes 469.169, the grant must be used, "for the purpose of marketing and
promoting the City as a tourist or convention center." In other words,the grant should be used
to increase visitation into and throughout the community. TCG now requires the cities to
complete a Member City Mazketing Grant Agreement which defines how the funds may be
used and requires an accounting of how the funds were spent.
Staff recommends allocating the TCG Community Grant as follows, but to also a11ow some
flexibility if the funds cannot be used for marketing:
Promotion and Mazketing of Spring Fling $ 273
Promotion and Marketing of Fridley `49er Days $3,000
Promotion and Marketing of Pumpkin Night in the Park $ 273
Promotion and Marketing of WinterFest $ 273
Promotion and Marketing of ROCKS Summer Program $ 273
Promotion and Marketin�of SNC Nature Camps $1,500
Total Grant Funding . $5,592
11 1
Staff recommends a motion approving the disbursement of the TCG Communiry Grant as
recommended above and authorizing the City Manager to execute the 2014 Member City
Marketing Grant Agreement, as shown in Attachment 1.
12 2
Attachment 1
����,
�����
i �; ir� ci � if,�
GATEWAY
Fridley 2014 Member City Grant Agreement
This Agreement between the City of Fridley, 6431 University Avenue NE, Fridley, MN 55432,
hereinafter"the City," and Twin Cities Gateway, a Minnesota non-profit corporation, 10801
Town Square Drive, Blaine, MN 55449, hereinafter"the Bureau," contains the terms and
conditions for a 2014 grant to the City in the amount of $5,592 from the Bureau to the City.
Whereas the grant funding provided is based on local option lodging taxes collected by the City
and the eight other member cities of the Bureau; and
Whereas the City agrees to expend the grant funding in compliance with MN Statute 469.10
which states that gross proceeds from any t� imposed shall be used for the purpose of marketing
and promoting the City as a tourist or convention center; and
Whereas the Bureau has specified that grant funds must be used for advertising,marketing, and
promotional efforts to increase participation, attendance, or visitation to an event, activity, or
facility located within the City, and/or to add new activities to enhance existing events; and
Whereas the Bureau specifies that advertising, marketing, and promotional efforts for which
said grant funding is used must extend beyond the borders, or boundaries of the City; and
Whereas it is agreed that prior to December 31, 2014, the City will provide an overview of how
the Bureau grant funding was utilized, as well as in accordance with this Agreement
documentation of expenses by providing copies of actual receipts or invoices for expenses
Now by execution of this Agreement, the City and the Bureau agree to and approve the terms
and conditions contained herein.
By: City of Fridley By: Steve Markuson/Twin Cities Gateway
Signature Signature
Date: Date:
13 3
` AGENDA ITEM
COUNCIL MEETING OF MAY 27, 2014
F�°� CLAIMS
CLAIMS
1405 (ACH PCard)
163932 - 164095
14
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 1
PROGRAM: GM350L
CITY OF FRIDLfiY FROM 05/12/2014 TO OS/23/2014 BANK CODE 00
----------------------------------------------------------------------------------------------
--------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
-------------------------------------------------------------------------------------------------------------
__ACCOUNT # TRN DATE DESCRIPTION INVOTCE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------
OS/22/2014 1405 U.S. BANCORP SERVICE CENTER, I 21065 6, 794,29
101-OS81-465.42-20 OS/O5/2014 OFFICE SUPPLIES OFFICEMAX O5/2014 24.20
101-0881-465.42-20 O5/OS/2014 OFFICE SUPPLIES OFFICEDEPOT OS/2014 38,05
101-0881-465.43-37 OS/OS/2014 CONFERENCE-HICKOK AMERICAN PLNG OS/2014 65. 00
101-0881-465.43-37 OS/OS/2014 PLANNING CONFERENCE HOTEL MARRIOTT OS/2014 737,76
101-0881-465.43-33 OS/OS/2014 PLNG CONFERENCE TAXI SERV DIALLO CAB OS/2014 34.00
101-0770-455.42-21 OS/OS/2014 STORAGE TU$S TARGET OS/2014 38.53
101-0770-455.42-21 OS/OS/2014 DUCK TAPE MENARDS OS/2014 35.00
101-0220-415.42-20 OS/OS/2Q24 OFFICE SUPPLIES OFFICE DEPOT 05/2014 52.58
101-0331-415.42-20 OS/OS/2014 OFFICE SUPPLIES OFFICE DEPOT OS/2014 129.19
101-0331-415.43-37 OS/OS/2014 REGISTRATION CAFR/GASB MNGFOA O5/2014 50.00
101-0331-415.43-37 O5/OS/2014 GFOA MTG MNGFOA O5/2014 15.00
101-0331-415.42-21 O5/OS/2014 LICENSE PLATES #117΅ MNDVS O5/2014 30.00
101-0332-415.42-20 OS/OS/2014 OFFICE SUPPLIES OFFICE DEPOT OS/2014 25.66
101-0333-415.42-21 OS/OS/2014 WEBSITE EXTENSION LIC TRINITRONIC OS/2014 19.00
101-0440-425.42-20 OS/OS/2014 OFFICE SUPPLIES OFFICEDEPOT/MAX OS/2014 223.33
101-044Q-425.42-21 O5/05/2014 COMMENDATION CEREMONY MCDON OS/2014 l,gg
101-0440-425.42-21 OS/OS/2014 INSPECTOR INTERVIEW PANEL NELSON CHEESE OS/2014 33 ,�g
101-0440-425.42-21 OS/OS/2014 SAFETY CAMP SUPPLIES SARAGLOVECO OS/2014 121.06
101-0440-425.42-21 05/OS/2014 NIGHT TO UNITE SUPPLIES OFFICE MAX O5/2014 4.50
101-0550-425.42-12 OS/OS/2014 FUEL FOR POWER TOOLS BOBBY/STEV AUTO OS/2014 38.79
101-0550-425.42-21 OS/OS/2014 AETURN MOUSE/POINTER AMAZON 05/2014 40.57-
� 101-0550-425.42-21 OS/OS/2014 MAGAZINE RACK FIRE BRK RM AMZ DISPLAYS2G0 OS/2014 69.75
(� 101-0550-425.42-21 OS/OS/2014 WATER,GARBAGE BAGS STA 1 MENARDS OS/2014 82.06
101-0550-425.42-20 OS/OS/2014 OFFICE SUPPLIES OFFICE DEPOT OS/2014 15.49
101-0550-425.42-22 OS/OS/2014 BRASS COUPLING HOME DEPOT OS/2014 6.70
101-0550-425.43-37 OS/OS/2014 REGISTRATION-BERG INTL ASSOC FIRE OS/2014 290.00
101-0550-425.43-40 OS/OS/2014 EMT REGISTRY-BELMORE NATL REGISTRY O5/2014 70. 00
101-0661-435.42-17 05/OS/2014 WORK COAT-ROBERTS MIDWEST WORKWR OS/2014 71.14
101-0666-435.42-22 OS/05/2014 CABLE TIES MILLS FLEET OS/2014 65.52
101-0666-435.42-22 OS/05/2014 CABLE TIES MENARDS OS/2014 46.25
101-0666-435.42-22 OS/OS/2014 TOP WIND JACKS MENARDS OS/2014 91.87
101-0666-435.42-22 OS/O5/2014 LUMBER/SUPPLIES BOARDWALK HOME DEPOT QS/2014 58.36
101-0666-435.43-40 OS/OS/2014 SHARPEN CHIPPPER BLADES SGSI OS/2014 48.00
101-0668-435.42-22 OS/05/2014 SHOVELS,CHAIN SAW OIL HOME DEPOT OS/2014 115.21
101-0668-435.43-40 OS/OS/2014 SHARPEN CHIPPER BLADES SGSI OS/2014 48.00
101-0669-435.42-20 OS/OS/2014 OFFTCE SUPPLIES OFFICE MAX OS/2014 25.88
101-0669-435.42-21 OS/O5/2014 LICENSE PLATES #117,#901 MN DVS OS/2014 31.47
101-0669-435.42-25 OS/05/2014 CLOCK FOR SHOP OFFICE MAX OS/2014 24.49
101-0669-435.42-20 OS/OS/2014 INK FOR PRINTER OFFICE MAX OS/2014 76.05
101-0770-455.42-21 OS/OS/2014 NICKEL JAM PRIZES,CRAFTS ORIENTAL TRDG OS/2014 132.56
101-0770-455.42-21 OS/OS/2014 REPLACEMNET SCISSOR BAR KD KANOPY OS/2014 70.70
101-0770-455.42-21 OS/OS/2014 ZONE FIELD TRIP CHEAP SKATE OS/2014 110.00
101-0770-455.42-21 OS/OS/2014 ZONE MOVIE CHEAP SKATE OS/2014 4.61
101-0770-455.42-21 OS/OS/2014 SPORTS/CRAFT SUPPLIES S&S WORLDWIDE OS/2014 176.93
I01-07�0-455.42-21 OS/OS/2014 DODGEBALL SWEARBANDS PARTY CITY OS/2014 37.25
101-0770-455.42-21 OS/OS/2014 SPORTS/CRAFT SUPPLIES S&S WORLDWIDE OS/2014 174.07
101-0770-455.42-21 OS/OS/2014 SPORTS/CRAFT SUPPLIES S&S WORLDWIDE � O5/2014 414.59
101-07�0-455.42-21 OS/O5/2014 PAINT DOBBERS MSCHAELS OS/2014 Zg.lg
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 2
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------------------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
101-0770-455.42-21 OS/O5/2014 TABLE COVERS PARTY CITY OS/2014 26.99
101-0770-455.42-21 OS/OS/2014 SPORTS/CRAFT SUPPLIES S&S WORLDWIDE OS/2014 80.53
101-0770-455.43-31 OS/OS/2014 MEMBERSHIP AGING COUNCIL NCOA OS/2014 145.00
101-0882-465.42-21 OS/O5/2014 STAMPS OFFZCE DEPOT OS/2014 29.01
270-0771-455.43-30 OS/05/2014 TURTLE VET FEES AVIAN/EXOTICVET OS/2014 90.45
270-0771-455.42-21 OS/OS/2014 PLASTER PARIS HOME DEPOT OS/2014 14.53
270-0771-455.42-21 O5/OS/2014 SPRING FLING SUPPLIES PARTY CITY OS/2014 117.73
270-0771-455.42-21 OS/OS/2014 SPRING FLING SUPPLIES DOLLAR TREE OS/2014 22.14
270-0771-455.42-21 OS/OS/2014 CATERPILLARS FOR LESSONS CAROLINA BIOL OS/2014 112.93
270-0771-455.42-21 OS/OS/2014 SEEDS 1ST GRADE LESSONS AMAZON 05/2014 41.31
270-0771-455.42-21 OS/OS/2014 SUPPLIES-POLLIWOGS TARGET OS/2014 11.91
601-6000-415.42-20 OS/OS/2014 OFFICE SUPPLIES OFFICE DEPOT OS/2014 11.38
601-6000-415.43-40 OS/OS/2014 CHECK 21 IMPLEMENTATION CREDITRON CORP OS/2014 1, 800.00
601-7000-415.42-25 O5/OS/2014 TOOLS FOR WATER DEPT NAPA OS/2014 119.98
101-0668-435.42-22 O5/OS/2014 BLADES HOME DEPOT OS/2014 59.17
602-7000-415.42-22 OS/OS/2014 OUTLET COVER BEISSWENGERS OS/2014 5.39
609-9100-415.42-20 O5/OS/2014 OFFICE SUPPLIES OFFICE DEPOT OS/2014 17.24
270-0771-455.42-21 OS/O5/2014 LAMINATE,BOOK AMAZON OS/2014 35.63
OS/15/2014 163932 AUTOMATIC SYSTEMS CO INC 1158 5, 070.03
602-7500-415.43-40 04/16/2014 LIFT STA UPGRADES 27578 OS/2014 5, 070.03
OS/15/2014 163933 ALBRECHT SIGN & GRAPHICS,INC 1285 28.19
r 101-0550-425.43-40 OS/06/2014 DOOR SIGN 20896 OS/2014 28.19
OS/15/2014 163934 ADVANCE SHORING COMPANY 1304 195.58
408-0005-415.43-41 OS/13/2014 SHORING FOR RAMP SUPPORT 414180 OS/2014 195.58
OS/15/2014 163935 ALPHA MEDICAL EQUIPMENT 1309 108.80
240-0000-425.42-21 OS/02/2014 SOF TACTICAL TORNIQUET 1197 OS/2014 108.80
OS/15/2014 163936 BATTERIES PLUS 2004 44.94
602-7000-415.42-22 O5/OS/2014 BATTERIES 028412555 OS/2014 44.94
OS/15/2014 163937 DON BANIA JR 2018 400.00
101-0770-455.43-40 OS/12/2014 SAFETY CAMP PRESENTATION OS/2014 400.00
OS/15/2014 163938 B.D.S. LAUNDRY EQUIP CO 2033 219.47
101-0550-425.43-40 OS/06/2014 SERVICE WASH MACHINE SOI0071564 OS/2014 219.47
OS/15/2014 163939 BOYER TRUCKS INC 2035 930.48
101-0000-144.00-00 04/29/2014 PARTS OS/2014 930.48
OS/15/2014 163940 BEN SAEFKE PHOTOGRAPHY 2222 150.00
101-0550-425.43-40 OS/12/2014 FIREFIGHTERS PHOTOS 435 OS/2014 150.00
OS/15/2014 163941 CARQUEST AUTO PARTS 3005 32.01
101-0550-425.42-22 OS/12/2014 BATTERY TENDER 2589394056 OS/2014 32.01
OS/15/2014 163942 CRITTERS & COMPANY INC 3149 510.00
101-0770-455.43-40 O5/12/2014 SAFETY CAMP PERSENTATION OS/2014 510.00
i
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 3
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------------------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOIINT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
O5/15/2014 163943 COON RAPIDS CHRYSLER-JEEP 3158 288•48
101-0880-465.43-40 O5/06/2014 ALIGHMENT,SAFETY INSPECT CHC5450553 OS/2014 288.49
OS/15/2014 163944 CHANTZCLEAR PIZZA 3239 26.00
101-0770-455.42-21 OS/06/2014 PIZZA B-PARTY ZONE OS/2014 26.00
OS/15/2014 163945 CENTERPOINT ENERGY-MINNEGP_SCO 3252 1,524.36
609-9100-415.43-38 OS/07/2014 UTILITIES 97917173 OS/2014 357.82
270-0771-455.43-38 OS/07/2014 UTILZTIES 55302905 OS/2014 179.37
601-7000-415.43-38 OS/07/2014 UTILITIES 55134407 OS/2014 38.38
101-0669-435.43-38 OS/07/2014 UTILITIES 55703078 OS/2014 948.79
OS/15/2014 163946 CENTURY LINK 3295 874.08
101-0110-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 6.65
101-0220-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 O5/2014 16.62
101-0221-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 9.97
101-0224-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 6.65
101-0331-415.43-32 OS/O1/2014 PHONE SERVZCE Z010553 OS/2014 39.88
101-0332-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 9.97
101-0333-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 29.90
101-0440-425.43-32 OS/01/2014 PHONE SERVICE Z010553 OS/2014 322.38
101-0441-425.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 33.23
101-0550-425.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 56.50
J 101-0660-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 109.68
101-0661-435.43-32 OS/O1/2014 PHONE SERVICE Z010553 O5/2014 29.91
101-0669-435.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 43.21
101-0880-465.43-32 O5/O1/2014 PHONE SERVICE Z010553 OS/2014 23.26
101-0881-465.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 33.23
101-0882-465.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 13.29
101-0770-455.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 36.56
101-0770-455.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 3.32
270-0771-455.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 16.62
601-6000-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 6.65
601-7000-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 6.65
225-0000-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 6.65
237-0000-415.43-32 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 6.65
101-0000-135.00-00 OS/O1/2014 PHONE SERVICE Z010553 OS/2014 6.65
OS/15/2014 163947 CENTURY LINK 3295 6�2•�z
101-0550-425.43-32 OS/O1/2014 PHONE SERVICE Z010545 OS/2014 282.85
101-0669-435.43-32 OS/O1/2014 PHONE SERVICE Z010546 OS/2014 103.30
601-7000-415.43-32 OS/O1/2014 PHONE SERVICE Z010548 O5/2014 143.56
101-0333-415.43-32 OS/O1/2014 PHONE SERVICE 5742480 OS/2014 36.61
101-0440-425.43-32 OS/O1/2014 PHONE SERVICE E830233 OS/2014 106.40
OS/15/2014 163948 CENTURY LINK 3296 26.78
101-0220-415.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 .69
101-0221-415.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 .92
101-0224-415.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 .23
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 4
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------------------------------------------�-----------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
101-0331-415.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 O5/2014 4.10
101-0332-415.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 , OS/2014 .73
101-0440-425.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 11.62
101-0550-425.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 1.49
101-0669-435.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 1.03
101-0880-465.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 1.19
101-0881-465.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 1.23
101-0770-455.43-32 05/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 3.26
270-0771-455.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 .22
601-6000-415.43-32 OS/03/2014 LONG DISTANCE PHONE SERV 1300216645 OS/2014 .07
OS/15/2014 163949 CREATIONS BY RICHARD CADY 3320 150.00
101-0550-425.42-21 OS/06/2014 FLAGS 140417A,140403A OS/2014 150.00
OS/15/2014 163950 DAMA METAL PRODUCTS INC 4114 119.00
101-0550-425.42-21 OS/12/2014 KEY BOX TAMPER SWITCHES 13335 OS/2014 119.00
OS/15/2014 163951 ESCH CONSTRUCTIONS SUPPLY, INC 5024 354.09
101-0668-435.42-22 OS/08/2014 ASPHALT BLADE 515887 OS/2014 354.09
OS/15/2014 163952 EMERGENCY APPARATUS MAINT 5038 1,636.83
101-0550-425.43-40 OS/12/2014 PUMP TESTING 73491, 92, 93,94 OS/2014 1,636.83
OS/15/2014 163953 EMERGENCY AUTOMOTIVE TECHNOLOG 5073 460.80
p~p 101-0000-144.00-00 04/29/2014 AMBER LENS AW0429145 05/2014 138.60
101-0440-425.42-25 04/23/2014 PUSH BUMPER AW04221414 OS/2014 322.20
OS/15/2014 163954 FLEXIBLE PIPE TOOL CO 6015 1, 078.50
602-7000-415.42-22 OS/02/2014 REEL SPEED VALVE 17396 OS/2014 353.00
601-7000-415.43-40 OS/12/2014 REPAIR CAM SHAFT 17429 OS/2014 725.50
OS/15/2014 163955 FRANZ REPROGRAPHICS 6090 280.90
101-0661-435.42-20 OS/13/2014 INK, ROLL PAPER 129951 OS/2014 280.90
OS/15/2014 163956 FERGUSON WATERWORKS #2516 6134 672.61
601-7500-415.42-22 OS/02/2014 GATE VALVE 77858 OS/2014 672.61
OS/15/2014 163957 GOPHER STATE ONE-CALL INC 7013 377.10
601-7000-415.43-40 04/30/2014 APRIL CALLS 103582 OS/2014 188.55
602-7000-415.43-40 04/30/2014 APRIL CALLS 103582 OS/2014 188.55
OS/15/2014 163958 GENERAL SECURITY SERVICES CORP 7040 512.64
101-0550-425.43-40 OS/06/2014 FIRE SYSTEM TEST 305444,45,59,60 OS/2014 512.64
OS/15/2014 163959 GRAINGER 7041 24.00
101-0666-435.42-22 OS/OS/2014 CABLE TIES 9436297643 OS/2014 24.00
OS/15/2014 163960 G & K SERVICES 7100 44.21
270-0771-455.42-17 04/30/2014 RUGS 1006258590 O5/2014 44.21
OS/15/2014 163961 GENESIS EMPLOYEE BENEFITS 7162 663 .80
704-0000-415.43-30 OS/12/2014 VEBA ADM,CLAIMS 23705 OS/2014 663.90
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 5
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO O5/23/2014 BANK CODE 00
------------------------------------------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
OS/15/2014 163962 HEALTH PARTNERS 8022 730.00
101-0550-425.43-30 OS/07/2014 FIRE FITNESS EXAM O5/2014 730.00
O5/15/2014 163963 HOLIDAY CREDIT OFFICE 8023 630.16
101-0440-425.42-12 OS/03/2014 FUEL OS/2014 630.16
OS/15/2014 163964 INSTRUMENTAL RESEARCH, INC 9036 256.00
601-7000-415.43-40 04/28/2014 WATER TESTING 8540 OS/2014 256.00
OS/15/2014 163965 IPHOUSE INTERNET 9047 45.00
101-0333-415.43-32 OS/06/2014 DOMAIN HOSTING OS/2014 45.00
OS/15/2014 163966 INTERSTATE ALL BATTERY CENTER 9073 83.94
101-0669-435.42-22 OS/OS/2014 BATTERIES 1902702000605 OS/2014 83.94
OS/15/2014 163967 KATH FUEL OIL SERVICE 11014 1, 928.00
101-0000-142.00-00 OS/09/2014 OIL/LUBE 461913 OS/2014 1,448.00
101-0000-142.00-00 04/30/2014 OIL 460949 OS/2014 480.00
O5/15/2014 163968 LYNN PEAVEY COMPANY 12018 87.50
101-0440-425.42-21 OS/06/2014 EVIDENCE TUBES 288782 OS/2014 87.50
�S/15/2014 163969 LOFFLER COMPANIES, INC 12143 843.15
�p 101-0333-415.43-40 O5/06/2014 PRINTER USAGE,MAINT 1748462 OS/2014 843.15
OS/15/2014 163970 METROPOLITAN COUNCIL 13020 1,050.00
601-7000-415.43-31 OS/12/2014 INDST DISCHARGE PERMITS 1033535,534,536 OS/2014 1,050.00
OS/15/2014 163971 M.T.I. DIS.TRIBUTING CO 13046 31,222.88
408-0007-455.42-22 04/25/2014 IRRIGATION SUPPLIES 35200-35204 OS/2014 31,222.88
O5/15/2014 163972 MENARDS - FRIDLEY 13256 51.50
101-0666-435.42-22 OS/09/2014 FIELD SPIKES 63913 OS/2014 18.56
101-0660-415.42-22 OS/12/2014 ROUNDUP,PICTURE HANGER 64196 OS/2014 32.94
OS/15/2014 163973 MINN STATE BOARD OF ASSESSORS 13378 215.00
101-0332-415.43-31 OS/08/2014 STATE LIC RENEWALS OS/2014 215.00
OS/15/2014 163974 NORTHERN SANITARY SUPPLY INC 14089 122.44
101-0550-425.42-22 OS/12/2014 TRUCK TOWELS,FILTERS 168352 OS/2014 122.44
OS/15/2014 163975 N.A.S.R.O.-NATL ASSOC OF SCHOO 14098 80.00
101-0440-425.43-31 OS/13/2014 MEMBERSHIP-TITUS,KNAEBLE OS/2014 80.00
OS/15/2014 163976 NORTHLAND CHEMICAL CORP 14102 950.00
101-0669-435.42-22 OS/14/2014 DEGREASOR 5054174,5054034 OS/2014 950.00
OS/15/2014 163977 ON SITE SANITATION 15035 880.46
101-0666-435.43-41 OS/14/2014 PORTABLE RESTROOMS OS/2014 880.46
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 6
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------------------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
OS/15/2014 163978 PARK SUPPLY OF AMERICA 16004 52.66
601-7000-415.42-22 OS/06/2014 BOILER LOG BOOKS 729200 OS/2014 52.66
OS/15/2014 163979 PRO-TEC DESIGN 16154 546.22
101-0660-415.42-21 04/03/2014 KEY FOBS 66828 OS/2014 546.22
OS/15/2014 163980 PERFECT 10 CARWASH EXPRESS 16200 180.00
101-0661-435.43-40 04/30/2014 CAR WASH-PUBLIC WORKS OS/2014 5.00
601-7000-415.43-40 04/30/2014 CAR WASHES-PUBLZC WORKS OS/2014 15.00
602-7000-415.43-40 04/30/2014 CAR WASHES-PUBLIC WORKS OS/2014 15.00
101-0882-465.43-40 04/30/2014 CAR WASH BAL-CITY FIALL OS/2014 1.00
101-0440-425.43-40 OS/12/2014 CAR WASHES-POLICE OS/2014 144.00
OS/15/2014 163981 PET FOOD ETC 16201 6.91
270-0771-455.42-21 OS/08/2014 CRICKETS OS/2014 6.91
O5/15/2014 163982 RUFFRIDGE-JOHNSON EQUIP CO INC 18020 Sg,gg
101-0000-144.00-00 03/21/2014 HOSE C65609 OS/2014 59.98
OS/15/2014 163983 4-ACE PRODUCTIONS 18102 395.00
101-0770-455.43-40 OS/12/2014 SAFETY CAMP PRESENTATION OS/2014 395.00
��/15/2014 163984 SCHARBER & SONS INC 19011 485.72
p 101-0000-144.00-00 OS/07/2014 PARTS P43218 OS/2014 132.34
101-0000-144.00-00 OS/07/2014 PARTS P43217 OS/2014 336.78
101-0000-144.00-00 OS/07/2014 PARTS P43552 OS/2014 16.60
OS/15/2014 163985 SILENT KNIGHT SECURITY SYSTEMS 19026 420.00
270-0771-455.43-40 OS/06/2014 FIRE MONITORING 46053 OS/2014 420.00
O5/15/2014 163986 STAR TRIBUNE 19171 250.00
270-0771-455.43-34 OS/06/2014 SPRZNG FLING AD 1009845247 O5/2014 250.00
OS/15/2014 163987 SUBURBAN TIRE WHOLSALE, INC 19229 89.60
101-0000-143.00-00 OS/07/2014 TIRES 1012532 OS/2014 89.60
OS/15/2014 163988 SPLIT ROCK STUDIOS 19380 7,760.00
270-0771-455.43-40 OS/13/2014 EXHIBIT CONCEPT DESIGN 2136 OS/2014 7,760.00
OS/15/2014 163989 TERRY OVERACKER PLUMBING 20029 361.00
101-0880-465.43-40 OS/OS/2014 INSPECTIONS 40008 OS/2014 72.00
101-0880-465.43-40 OS/OS/2014 INSPECTIONS 40012 OS/2014 72.00
101-0880-465.43-40 OS/09/2014 INSPECTIONS 40010,11,13 OS/2014 217.00
OS/15/2014 163990 TOSHIBA BUSINESS SOLUTIONS 20060 17.70
101-0669-435.43-35 OS/02/2014 MAINT/USAGE 10923582 OS/2014 17.70
OS/15/2014 163991 TOTAL ENTERTAINMENT PRODUCTION 20113 250.00
101-0770-455.43-40 OS/12/2014 SAFETY CAMP DJ OS/2014 250.00
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 7
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------------------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
OS/15/2014 163992 TITAN MACHINERY 20159 278.82
101-0000-144.00-00 04/30/2014 PEDAL ASSY 3620442 OS/2014 278,82
OS/15/2014 163993 U.S.A. BLUEBOOK 21051 271.76
601-7000-415.42-25 04/09/2014 TOOLS,SOCKET 314187 OS/2014 271.76
OS/15/2014 163994 VIKING INDUSTRIAL CENTER 22011 425.20
602-7000-415.43-40 04/21/2014 REPAIR/RECER RETRACTABLE 3014218 OS/2014 425.20
OS/15/2014 163995 VERIZON WIRELESS 22050 26.02
101-0550-425.43-32 OS/12/2014 WIRELESS SERVICE 9724640278 OS/2014 26.02
OS/15/2014 163996 WONDERLIC, INC 23013 956.25
101-0221-415.43-30 OS/09/2014 PERSONAL CHARACTERISTICS 6345736,345754 OS/2014 956.25
O5/15/2014 163997 W.C.E.C. - WEST CENTRAL 23034 1,334.50
351-0000-475.43-40 OS/09/2014 VAC OIL/GAS DISPOSE 72705 OS/2014 1,334.50
OS/15/2014 163998 THOMSON REUTERS-WEST GOVT SERV 23054 146.83
101-0440-425.43-40 OS/13/2014 APRIL INFORMATION CHRG 829519330 OS/2014 146.83
OS/15/2014 163999 WATER CONSERVATION SERVICE, IN 23059 266.80
N 601-7500-415.43-40 OS/OS/2014 LEAK LOCATES 5074 OS/2014 266.80
H+
OS/15/2014 164000 WENCK ASSOCIATES,INC 23070 884.48
603-7500-415.43-30 OS/08/2014 OAK GLEN CREEK PROJ 11401892 O5/2014 884.48
OS/15/2014 164001 XCEL ENERGY 24002 18,825.01
101-0440-425.43-38 OS/07/2014 UTILITIES 411587744 OS/2014 493.73
609-9200-415.43-38 OS/07/2014 UTILITIES 411606477 OS/2014 868.59
101-0660-415.43-38 OS/07/2014 UTILITIES 411584229 OS/2014 3,769.86
101-0550-425.43-38 OS/07/2014 UTILITIES 411402596 OS/2014 44.76
101-0666-435.43-38 OS/07/2014 UTILITIES 411430431 OS/2014 11.38
609-9100-415.43-38 OS/07/2014 UTILITIES 411523278 OS/2014 1,566.61
601-7000-415.43-38 OS/07/2014 UTILITIES 411863083 OS/2014 12,070.08
OS/15/2014 164002 XEROX CORPORATION 24004 48.41
101-0550-425.43-35 OS/06/2014 PRINTER USAGE 73749815 OS/2014 48.41
OS/15/2014 164003 SHORTSTOP BAR 99998 200.00
101-0000-240.00-00 OS/07/2014 TSP 14-OS DEPOSIT REFUND O5/2014 200.00
OS/15/2014 164004 H & R BLOCK 99998 200.00
101-0000-240.00-00 OS/07/2014 TSP 14-05,14-06 DEPOSIT REFUND OS/2014 200.00
OS/15/2014 164005 HERRMANN, KAY 99999 68.86
601-0000-245.00-00 O5/07/2014 UB CR REFUND-FINALS 000004745 OS/2014 68.86
OS/15/2014 164006 BRAATEN, C LIA 99999 178.91
601-0000-245.00-00 OS/07/2014 UB CR REFUND-FINALS 000055095 OS/2014 178.91
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 8
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------=-----------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
OS/15/2014 164007 ALTENDORFER, GREGORY 99999 20.65
601-0000-245.00-00 OS/07/2014 UB CR REFUND-FINALS 000158665 OS/2014 20.65
OS/15/2014 164008 SHOQUIST, RONALD R 99999 201.95
601-0000-245.00-00 OS/07/2014 UB CR REFUND-FINALS 000058985 OS/2014 201.95
OS/15/2014 164009 JOHNSON, ROSANNE 99999 40.97
601-0000-245.00-00 OS/07/2014 UB CR REFUND-FINALS 000104165 OS/2014 40.97
OS/15/2014 164010 SCOTT NOHNER 2014467 25.00
101-0000-347.80-51 OS/08/2014 REC REFUND � OS/2014 25.00
OS/15/2014 164011 TWIN CZTY EXTERIOR CO INC 2014651 88.96
101-0000-322.10-41 OS/07/2014 REFUND BUILDING PERMIT OS/2014 88.96
OS/22/2014 164012 ANOKA COUNTY TREASURER 1048 987.50
101-0333-415.43-32 OS/19/2014 BROADBAND 8140512K O5/2014 400.00
270-0771-455.43-32 OS/19/2014 BROADBAND B140512K OS/2014 400.00
101-0550-425.43-32 OS/19/2014 BROADBAND B140512K OS/2014 150.00
101-0770-455.43-32 OS/19/2014 BROADBAND B140512K OS/2014 37.50
OS/22/2014 164013 ANOKA COUNTY TREASURER 1048 348.21
N 101-0440-425.42-12 OS/21/2014 FUEL FOR DTF-CRESTIK H140519B OS/2014 348.21
N
OS/22/2014 164014 ADVANCE COMPANIES INC 1061 547.80
101-0881-465.43-40 OS/15/2014 YARD ABATEMENT 8557 OS/2014 547.80
OS/22/2014 164015 REPUBLIC SERVICES #899 1082 21, 942.59
237-0000-415.43-40 OS/15/2014 APRIL RECYCLING CHRGS 0899002471571 OS/2014 21, 942.59
OS/22/2014 164016 ANOKA COUNTY ELECTIONS 1087 4,237.59
101-0223-415.43-40 OS/18/2014 JOINT POWERS ANNUAL FEE 201411 O5/2014 4,237.59
OS/22/2014 164017 ADVANCED GRAPHIX INC 1151 1,422.50
101-0550-425.43-40 04/24/2014 GRAPHICS FOR VEHICLES 189515 OS/2014 1,422.50
OS/22/2014 164018 AUTOMATIC SYSTEMS CO INC 1158 2,596.00
601-7000-415.43-40 OS/16/2014 MOBILE ACCESS SETUP SCADA 276705 OS/2014 1,298.00
602-7000-415.43-40 OS/16/2014 MOBILE ACCESS SETUP SCADA 276705 OS/2014 1,298.00
OS/22/2014 164019 ANOKA COUNTY PROP RECORDS/TAX 1233 . 138.00
101-0881-465.43-40 OS/15/2014 FILING FEES 529 OS/2014 138.00
OS/22/2014 164020 ALBRECHT SIGN & GRAPHICS,INC 1285 193.29
101-0550-425.43-35 OS/06/2014 LETTERING FOR TRUCK 20801,20829 OS/2014 176.79
101-0220-415.42-21 OS/20/2014 NAME PLATE 20955 OS/2014 16.50
OS/22/2014 164021 AURELIO'S FAMILY PIZZERIA 1286 723.09
101-0770-455.42-21 OS/13/2014 VOLUNTEER LUNCA 1451365 OS/2014 723.09
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 9
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------------------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
OS/22/2014 164022 ADAM'S PEST CONTROL, INC 1301 47.00
101-0660-415.43-40 OS/21/2014 MAY PEST CONTROL 886183 OS/2014 47.00
OS/22/2014 164023 APEX PRINT TECHNOLOGIES 1311 1, 819.26
601-6000-415.43-32 04/30/2014 METER CARDS 165353 O5/2014 1,069.26
601-6000-415.43-32 04/30/2014 WEBSITE 165353 OS/2014 502.50
602-6000-415.43-32 04/30/2014 WEBSITE 165353 OS/2014 247.50
OS/22/2014 164024 BARTON SAND & GRAVEL CO 2005 597.65
601-7500-415.42-22 OS/15/2014 WATER BREAK MATERIALS OS/2014 547.65
601-7500-415.43-40 OS/15/2014 DISPOSAL FEES OS/2014 50.00
OS/22/2014 164025 BROOKDALE CHEVROLET 2076 145.24
101-0000-144.00-00 OS/14/2014 OIL PAN 385984 OS/2014 145.24
OS/22/2014 164026 BRO-TEX, INC 2173 250.00
237-0000-415.43-40 OS/15/2014 DROP OFF CHARGE-RECYCLING 448476 OS/2014 250.00
OS/22/2014 164027 JEAN COYLE 3060 96,77
101-0770-455_42-21 OS/15/2014 FLANNEL-CAMPAIGN OF CHEER OS/2014 96.77
OS/22/2014 164028 COMMERCIAL ASPHALT 3100 2,643.55
N 601-7500-415.42-22 OS/15/2014 ASPHALT OS/2014 2,643.55
OS/22/2014 164029 CUB STORE INC-NEW BRIGHTON STO 3126 59.37
101-0770-455.42-21 OS/03/2014 ZONE BIRTHDAY CAKE OS/2014 18.51
101-0770-455.42-21 OS/13/2014 VOLUNTEER LUNCH SUPPLIES OS/2014 40.86
OS/22/2014 164030 COMO LUBE & SUPPLIES INC 3129 150.00
101-0669-435.43-40 OS/19/2014 PARTS WASHER SERVICE 563576 OS/2014 150.00
O5/22/2014 164031 CENTRAL TURF & IRRIGATION SUPP 3131 215.40
101-0668-435.42-22 OS/12/2014 IRRIGATION HEADS PLOW DMG 603640900 OS/2014 215.40
OS/22/2014 164032 C.D.W. GOVERNMENT, INC 3163 1,281.14
705-0000-415.45-60 OS/07/2014 WIRELESS FIREWALL LR63836 OS/2014 1,041.20
705-0000-415.43-40 OS/07/2014 SUPPORT SERVICE AGREEMNT LS27914 OS/2014 239.94
OS/22/2014 164033 COMMUNITY HEALTH CHARITIES 3227 g,6Z
101-0000-219.08-00 OS/23/2014 PAYROLL SUMMARY 20140523 OS/2014 9.62
OS/22/2014 164034 CENTURY LINK 3295 36.89
270-0771-455.43-32 OS/10/2014 PHONE SERVICE 7848676 OS/2014 36.89
O5/22/2014 164035 CHARLESTON COUNTY FAMILY COURT 3316 451.50
101-0000-219.19-00 OS/23/2014 PAYROLL SUMMARY 20140523 OS/2014 451.50
O5/22/2014 164036 CROSSPOINT ENTERPRISES 3321 200.00
101-0770-455.43-40 OS/13/2014 VOL LUNCH ENTERTAINMENT OS/2014 200.00
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 10
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------------------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
O5/22/2014 164037 DALCO 4078 352.61
101-0669-435.42-22 O5/09/2014 TOWELS,CAN LINERS 2744651 OS/2014 352.61
OS/22/2014 164038 DEFORGES PLUMBING 4147 1,371.28
101-0660-415.43-40 O5/19/2014 REPLACE WATER HEATER 1393 OS/2014 1,371.28
OS/22/2014 164039 E.C.M. PUBLISHERS INC 5001 285.14
101-0224-415.43-34 OS/13/2014 LEGAL NOTICE-ORD 1314 100349 O5/2014 150.64
101-0881-465.43-34 OS/13/2014 LEGAL NOTICE-ORD 1315 100350 OS/2014 134.50
05/22/2014 164040 EMBEDDED SYSTEMS INC. 5025 2,008.32
101-0441-425.43-40 OS/20/2014 SIREN MAINTENANCE 33454 OS/2014 2, 008.32
O5/22/2014 164041 EVERGREEN LAND SERVICES COMPAN 5079 1,176.00
237-0000-415.43-40 OS/20/2014 MATTRESS RECYCLING 1578 OS/2014 1, 176.00
OS/22/2014 164042 FLEXIBLE PIPE TOOL CO 6015 2,253.50
101-0000-144.00-00 OS/19/2014 PARTS FOR JETTER #673 17473 OS/2014 2,253.50
OS/22/2014 164043 FRIDLEY POLICE ASSOCIATION 6117 80.00
101-0000-219.22-00 OS/23/2014 PAYROLL SUMMARY 20140523 O5/2014 80.00
OS/22/2014 164044 FIRST-SHRED 6157 800.00
� 237-0000-415.43-40 OS/15/2014 SHREDING-RECYCLING EVENT 111577 OS/2014 800.00
OS/22/2014 164045 FRONTIER PRECISION, INC 6159 1,131.00
101-0661-435.42-21 04/28/2014 TRIMBLE BUS SURVEY SFTWRE 125903 O5/2014 1,131.00
OS/22/2014 164046 HOFFMAN BROS. SOD, INC 8028 306.73
101-0660-415.42-22 OS/08/2014 DIRT, MULCH 1864 OS/2014 306.73
OS/22/2014 164047 HOISINGTON KOEGLER GROUP INC 8077 16,814.69
227-0000-415.43-30 OS/16/2014 PROF SERVICES TOD PLAN 0140023 OS/2014 16,814.69
OS/22/2014 164048 HAGEN,CHRISTENSEN & MCILWAIN 8107 1,234.07
408-0005-415.43-30 OS/14/2014 PROF SERVICES WORK STUDY 13657 OS/2014 1,234.07
OS/22/2014 164049 HEIGHTS BAKERY 8170 23.75
101-0770-455.42-21 OS/21/2014 ROLLS FOR SR CASINO 132 OS/2014 23.75
OS/22/2014 164050 I.C.M.A. 9008 1, 094.19
101-0220-415.43-31 OS/14/2014 MEMBERSHIP 192396 OS/2014 1,094.19
OS/22/2014 164051 INFRATECH INC 9051 477.60
101-0000-144.00-00 04/21/2014 INTAKE TUBING 1400154 OS/2014 477.60
OS/22/2014 164052 INTERSTATE ALL BATTERY CENTER 9073 68.10
101-0440-425.42-21 OS/19/2014 BATTERIES 1902701001295 OS/2014 68.10
OS/22/2014 164053 KING ELECTRIC 11021 85.00
101-0441-425.43-40 O5/21/2014 SIREN REPAIRS 7518 O5/2014 85.00
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 11
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------------------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
OS/22/2014 164054 KILLMER ELECTRIC CO INC 11034 959.95
601-7000-415.43-40 O5/14/2014 TROUBLESHOOT VFD 7796021628 OS/2014 959.95
O5/22/2014 164055 JENNIFER LEAF 12181 45.00
101-0770-455.43-40 OS/OS/2014 CHORES/MORE OS/2014 45.00
OS/22/2014 164056 METROPOLITAN COUNCIL 13020 296,945.05
602-7000-415.43-38 OS/06/2014 JUNE WASTEWATER SERVICE 1033421 OS/2014 296,945.05
OS/22/2014 164057 MATRIX COMMUNICATIONS INC 13028 652.50
101-0333-415.43-40 05/13/2014 INSTALL LINES 75100 OS/2014 247.50
705-0000-415.42-21 OS/13/2014 ADAPTER,PAONE LINES 75100 OS/2014 405.00
OS/22/2014 164058 MINNEAPOLIS FINANCE DEPT 13033 3,258.00
101-0440-425.43-40 OS/08/2014 APS TRANS FEES 400413004940 O5/2014 3,258.00
O5/22/2014 164059 M.T.I. DISTRIBUTING CO 13046 3,924.83
408-0007-455.42-22 OS/12/2014 IRRIGATION COMMONS PRK 95540800 OS/2014 51.68
408-0007-455.42-22 OS/12/2014 IRRIGATION COMMONS PRK 95035205 OS/2014 3,873 .15
O5/22/2014 164060 MINN DEPT OF HEALTH 13125 13,022.00
601-0000-200.00-00 OS/15/2014 2ND QRT WTR SERV CONNECT 2ND QRT WATER S OS/2014 13,022.00
�j /22/2014 164061 METRO SALES INC 13135 212.00
101-0333-415.43-40 O5/13/2014 PRINTER USAGE 605069 OS/2014 212 .00
OS/22/2014 164062 MINN DEPT OF LABOR & INDUSTRY 13150 110.00
601-7000-415.43-31 OS/13/2014 SOILER LICENSE OS/2014 50.00
101-0669-435.43-31 OS/13/2014 BOILER LICENSE OS/2014 30.00
101-0660-415.43-31 O5/13/2014 BOILER LICENSE OS/2014 30.00
OS/22/2014 164063 MINNESOTA BENEFIT ASSOC - M.B. 13220 73.68
101-0000-219.09-00 OS/23/2014 PAYROLL SUMMARY 20140523 OS/2014 73.68
OS/22/2014 164064 MENARDS - FRIDLEY 13256 94.29
601-7000-415.42-22 OS/13/2014 BATTERIES 64323 OS/2014 58.31
603-7000-415.42-25 OS/13/2014 RAKE,TELESCOPING POLE 64308 OS/2014 35.98
OS/22/2014 164065 MINN CHILD SUPPORT PAYMENT CEN 13307 6.93
101-0000-219.19-00 OS/23/2014 PAYROLL SUMMARY 20140523 OS/2014 6.93
OS/22/2014 164066 MANSFIELD OIL COMPANY 13472 8,842.09
101-0000-141.00-00 O5/19/2014 FUEL 609225 OS/2014 8,842.09
OS/22/2014 164067 NATL BUSINESS FURNITURE 14025 482.00
101-0221-415.42-21 05/14/2014 OFFICE CHAIR ZJ848517TDQ OS/2014 241.00
101-0881-465.42-21 OS/14/2014 OFFICE CHAIR ZJ848517TDQ OS/2014 241.00
O5/22/2014 164068 CITY OF NEW BRIGHTON 14067 6,343.27
601-7000-415.42-22 04/22/2014 WATER CHEMICALS OS/2014 6,343.27
I
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 12
PROGRAM: GM350L
CITY OF FRIDLEY FROM O5/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------------------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
OS/22/2014 164069 NCPERS MINNESOTA-478000 14107 736.00
101-0000-219.27-00 OS/23/2014 PAYROLL SUMMARY 20140523 OS/2014 736.00
OS/22/2014 164070 NELSON CHEESE & DELI 14119 107.10
101-0220-415.43-37 OS/19/2014 CONF MTG BOX LUNCHES 104911 OS/2014 107.10
OS/22/2014 164071 OPEN YOUR HEART 15011 25.00
101-0000-219.08-00 OS/23/2014 PAYROLL SUMMARY 20140523 OS/2014 25.00
O5/22/2014 164072 PARSON'S ELECTRIC CO 16023 9,447.88
101-0665-435.43-40 OS/06/2014 REPAIR SEVERAL LIGHTS 31145 OS/2014 9,447.88
OS/22/2014 164073 PRINT CENTRAL 16067 '64.00
237-0000-415.43-35 OS/15/2014 RECYCLING EVENT POSTER 104155 OS/2014 64.00
OS/22/2014 164074 PIONEER RIM & WHEEL COMPANY 16070 123.99
101-0000-143.00-00 OS/07/2014 BATTERY 1242649 OS/2014 102.88
101-0000-144.00-00 OS/13/2014 RIM 1243459 OS/2014 21.11
OS/22/2014 164075 PACE ANALYTICAL SERVICE INC 16135 543 .50
601-7000-415.43-40 OS/13/2014 LOCKE PRK NPDES 12140460 OS/2014 543.50
�ns/22/2014 164076 PETCO 16146 157.57
101-0440-425.42-21 OS/O1/2014 K-9 SUPPLIES OA053540 OS/2014 157.57
OS/22/2014 164077 MATTHEW PERRON 16217 19.74
101-0668-435.42-17 OS/13/2014 REIMB SAFETY BOOTS OS/2014 19.74
OS/22/2014 164078 R.J.M PRINTING 19036 47.60
101-0221-415.43-35 OS/19/2014 BUSINESS CARDS 81098 OS/2014 47.60
OS/22/2014 164079 MARK SCHULTE 19041 68.00
101-0666-435.42-17 OS/14/2014 REIMB SAFETY BOOTS OS/2014 68.00
OS/22/2014 164080 SCHIFSKY AND SONS INC 19045 2,482.43
101-0668-435.42-22 OS/09/2014 ASPHALT 56371 OS/2014 283.86
601-7500-415.42-22 OS/09/2014 ASPHALT 56371 OS/2014 2,198.57
OS/22/2014 164081 STREICHER'S 19050 685.59
101-0440-425.42-17 04/21/2014 UNIFORMS 1086408 OS/2014 51.00
101-0440-425.42-17 04/21/2014 IINIFORMS 1086421,1086580 OS/2014 102.00
101-0440-425.42-25 04/23/2014 FLASHLIGHT 1086842 OS/2014 122.60
101-0440-425.42-17 04/23/2014 UNIFORMS 1087247 OS/2014 153 .00
101-0440-425.42-17 04/21/2014 UNIFORMS 1086423 OS/2014 74.00
101-0440-425.42-17 04/21/2014 UNIFORMS 1084502 O5/2014 154.99
101-0440-425.42-17 04/09/2014 UNIFORMS 1084422 O5/2014 28.00
OS/22/2014 164082 STANDARD INSURANCE COMPANY 19063 5,128.25
101-0000-219.12-00 OS/16/2014 MAY LIFE INS 643900 OS/2014 2, 928.27
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 13
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
-----------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
101-0000-135.00-00 OS/16/2014 MAY LIFE INS 643900 OS/2014 65.75
704-0000-219.12-00 OS/16/2014 MAY LIFE INS 643900 OS/2014 4.35
101-0000-219.23-00 OS/16/2014 MAY LTD 643900 OS/2014 2,104.90
101-0000-135.00-00 O5/16/2014 MAY LTD 643900 OS/2014 24.98
OS/22/2014 164083 SUN BADGE CO 19131 51.00
101-0440-425.43-40 OS/09/2014 REPAIR BADGE 351102 O5/2014 51.00
OS/22/2014 164084 STIMEY ELECTRIC 19255 2,080.08
101-0440-425.43-40 OS/16/2014 GIIN RANGE LIGHTS 2364 OS/2014 976.52
601-7000-415.43-40 OS/16/2014 ELECTRICAL WRT DEPT 2344 OS/2014 878.56
601-7500-415.43-40 O5/16/2014 DRILL HOLE WTR PROJ 2344 OS/2014 225.00
OS/22/2014 164085 TARGET 20004 239.05
101-0�70-455.42-21 OS/18/2014 ZONE SUPPLIES 05/2014 34.83
101-0550-425.42-21 O5/18/2014 TABLES,MIRROR STA 2 OS/2014 204.22
OS/22/2014 164086 TERRY OVERACKER PLUMBING 20029 408.00
101-0880-465.43-40 OS/13/2014 INSPECTIONS 40015 OS/2014 72.00
101-0880-465.43-40 OS/15/2014 INSPECTIONS 40016-40019 OS/2014 336.00
OS/22/2014 164087 TRI-COUNTY LAW ENFORCEMENT ASS 20128 75.00
101-0440-425.43-31 OS/15/2014 ANNUAL DUES OS/2014 75.00
� /22/2014 164088 ANDREW TODD 20132 1,236.00
101-1000-415.43-37 OS/06/2014 SCHL REIMB SPRING 2014 PSA615 OS/2014 1,236.00
OS/22/2014 164089 UNITED WAY 21035 25.00
101-0000-219.08-00 OS/23/2014 PAYROLL SUMMARY 20140523 OS/2014 25.00
OS/22/2014 164090 VALLEY-RICH CO INC 22006 10,482.80
601-7500-415.43-40 04/26/2014 REPAIR WATER MAIN BREAK 20105 OS/2014 10,482.80
OS/22/2014 164091 WALTERS RECYCLZNG & REFUSE SER 23088 1,220.74
101-0666-435.43-40 OS/10/2014 REFUSE HAULING 751445,751444 OS/2014 568.19
101-0669-435.43-40 O5/10/2014 REFUSE HAULING 753640 OS/2014 540.57
270-0771-455.43-40 O5/10/2014 REFUSE AAULING 753640 OS/2014 111.98
OS/22/2014 164092 XCEL ENERGY 24002 9,591.39
601-7000-415.43-38 OS/12/2014 UTILITIES 412163078 OS/2014 8,244.02
101-0669-435.43-38 OS/12/2014 UTILITIES 412489463 OS/2014 1,347.37
O5/22/2014 164093 ZAHL-PETROLEUM MAINTENANCE 26015 439.87
101-0669-435.43-40 OS/12/2014 REPAIR FUEL ISLAND 0198825 OS/2014 439.87
OS/22/2014 164094 DAVID ANERSON 2014101 12.30
101-0666-435.42-17 OS/14/2014 REIMB SAFETY BOOTS OS/2014 12.30
OS/22/2014 164095 SAMUEL ERICKSON 2014213 35.00
101-0666-435.42-17 OS/14/2014 REIMB SAFETY BOOTS OS/2014 35.00
PREPARED OS/22/2014, 14:54:22 A/P CHECKS BY PERIOD AND YEAR PAGE 14
PROGRAM: GM350L
CITY OF FRIDLEY FROM OS/12/2014 TO OS/23/2014 BANK CODE 00
------------------------------------------------------------------------------------------------------------------------------------
CHECK CHECK CHECK
DATE NUMBER VENDOR NAME VENDOR # AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT # TRN DATE DESCRIPTION INVOICE PO # PER/YEAR TRN AMOUNT
------------------------------------------------------------------------------------------------------------------------------------
DATE RANGE TOTAL � 550,017.30 *
N
00
� CITY COUNCIL MEETING OF
MAY 27, 2014
`m°F BUSINESS LICENSE LIST
FRDLtY
NEW LICENSES
TYPE OF LICENSE: APPLICANT: APPROVED BY:
Carnival License—Fridley 49er Day Gopher State Exposition Public Safety Director
Festival June 27-29,2014 St.Cloud,MN Fire Marshall
Applicant Randy Forcier Parks Director
Location 7000 Central Ave NE Planning
Medtronic Parkin Lot
Street Vending Matt Milner Sales Public Safety Director
49er Days Parade Fridley,MN Parks&Recreation Director
June 27,2014 Applicant: Gerry Johnson City Clerk
RENEWAL LICENSES
TYPE OF LICENSE: APPLICANT: APPROVED BY:
Food Drake Enterprises Inc dba Papa Public Safety Director
Murphy's Pizza Fire Marshall
205 57`�Ave NE Planning
A licant: Jos h Jenni eo
Best of Thai dba Taste of Thailand
7890 University Ave NE
A licant: Toun Thanane
Tree Trimming and Removal Crystal Tree Service Public Safety Director
Crystal,MN Public Works Director
A licant Chuck Johnson
Gosiak Tree Service
Little Falls MN
A licant Robert Gosiak
Nature's Trees dba St Crou�Sava Tree
Roberts,Wisconsin
A licant Andrew D b
Reid's Lawn&Tree Service
Brooklyn Park,MN
A licant Thomas Reid
29
� AGENDA ITEM
CITY COUNCIL MEETING OF MAY 27, 2014
F°TMO� LICENSES
Contractor T e A licant A roved B
Absolute Mechanical LLC Heatin Mike Ericson Ron Julkowski,CBO
All A liance Installation Plus Inc Gas Jason Stevens Ron Julkowski,CBO
All Wa s Drains LTD Heatin Am Moe Ron Julkowski,CBO
All Wa s Drains LTD Gas Am Moe Ron Julkowski,CBO
Bob Kissner Plumbin &Heatin Heatin Robert Kissner Ron Julkowski,CBO
Climate Works Inc Heatin Kim Nelson Ron Julkowski,CBO
Demars Si s Si Erector Dennis Demars Ron Julkowski,CBO
G&H Heatin and Air Heatin Michael Gormle Ron Julkowski,CBO.
Groth Sewer and Water Excavatin L Groth Ron Julkowski,CBO
Heatin &Coolin Solutions Inc Heatin Brian R chl Ron Julkowski,CBO
Mobile Maintenance Inc Gas Ste hen Witzel Ron Julkowski,CBO
Mobile Maintenance Inc Heatin Ste hen Witzel Ron Julkowski,CBO
Modern Heatin &Air Conditionin Heatin Mike Renstrom Ron Julkowski,CBO
Modern Heatin &Air Conditionin Gas Mike Renstrom Ron Julkowski,CBO
Olson's Sewer Service Inc Excavatin Jon Olson Ron Julkowski,CBO
Riccar Heatin Gas Jeff Arent Ron Julkowski,CBO
Riccar Heatin Heatin Jeff Arent Ron Julkowski,CBO
Ryan Companies US Inc Commercial or Jill Blair Ron Julkowski,CBO
S ecial
Twin Ci Fire lace Heatin Mackenzie Thornton Ron Julkowski,CBO
Yale Mechanical Gas Jennifer Martindale Ron Julkowski,CBO
Yale Mechanical Heatin Jennifer Martindale Ron Julkowski,CBO
30
` AGENDA ITEM
CITY COUNCIL MEETING OF MAY 27, 2014
`xr�roF LICENSES
FRIDLEY
To: Walter Wysopal, City Manager
From: Scott Hickok, Community Development Director
Deb Biorn, Rental Property Inspections
Date: May 21, 2014
Re: Annual Renewal of Rental Licenses
AGENDA ITEM
CITY COUNCIL MEETING
Attached is a list of 77 properties that have submitted a rental license application,paid all fees
related to license renewal, and completed the rental inspections process.
T'he Rental Property Inspections Division of Community Development recommends that the City
Council approves the issuance of the rental licenses for these properties.
31
Ready for Certificate
The properties listed below meet the rental property guidelines according to Chapter 220 of the Fridley City Code
Property Id Property Address Units Owner
1099 5800 2 1/2 St. NE 4 Trung Duong
2172 4916 3rd St. NE 1 Bryan Scholtes
1156 6061-65 3rd St. NE 3 CF Investments Inc
1456 5622-24 4th St. NE 2 First Select Property Mgmt
1626 645 57th Ave. NE 1 T& K Properties
2159 710 58th Ave. NE 1 Wendy Anderson
1194 5410 5th St. NE 4 Carpathian Capital Fund, LLC
1364 1060 64th Ave NE 16 Samir Abumayyaleh
2098 260 67th Ave. NE 1 Rob Shimanski
1218 1565-77 68th Ave. NE 6 Rice Creek Townhouses
1219 1566-76 68th Ave. NE 6 Rice Creek Townhouses
1220 1578-88 68th Ave. NE 6 Rice Creek Townhouses
1221 1579-89 68th Ave. NE 6 Rice Creek Townhouses
1224 1600-10 68th Ave. NE 6 Rice Creek Townhouses
1225 1601-11 68th Ave. NE 6 Rice Creek Townhouses
1227 1613-19 68th Ave. NE 4 Rice Creek Townhouses
1228 1620-30 68th Ave. NE 6 Rice Creek Townhouses
1229 1621-31 68th Ave. NE 6 Rice Creek Townhouses
1230 1632-38 68th Ave. NE 4 Rice Creek Townhouses
1231 1633-39 68th Ave. NE 4 Rice Creek Townhouses
1232 1640-50 68th Ave. NE 6 Rice Creek Townhouses
1233 1641-51 68th Ave. NE 6 Rice Creek Townhouses
1234 1652-58 68th Ave. NE 4 Rice Creek Townhouses
1235 1653-59 68th Ave. NE 4 Rice Creek Townhouses
1236 1660-70 68th Ave. NE 6 Rice Creek Townhouses
1237 1661-71 68th Ave. NE 6 Rice Creek Townhouses
1238 1672-82 68th Ave. NE 6 Rice Creek Townhouses
1239 1673-83 68th Ave. NE 6 Rice Creek Townhouses
1240 1560-70 69th Ave. NE 6 Rice Creek Townhouses
1241 1590-96 69th Ave. NE 4 Rice Creek Townhouses
1242 1600-06 69th Ave. NE 4 Rice Creek Townhouses
1256 1270-76 72nd Ave. NE 4 Properties Six, LLC
1267 389 74th Ave. NE 11 Mystical Enterprises, Inc.
1268 415 74th Ave. NE 11 William Shaw
1272 350 75th Ave. NE 11 Doherty Properties, LLC
1534 450 75th Ave. NE 11 RAS Properties
1533 476 75th Ave. NE 11 RAS Properties
1943 6854 7th St. NE 1 Nancy Eggers
1284 101 83rd Ave. NE 41 University Ave Associates
1285 121 83rd Ave. NE 41 University Ave Associates
1287 141 83rd Ave. NE 36 University Ave Associates
1304 7431 Able St. NE 1 Andrew Clarke
1316 7595-97 Able St. NE 2 David A Schultr
2167 8051 Broad Ave. NE 1 Joseph C Kainz
1325 7150-56 Central Ave. NE 4 Radisson Management
1050 140-142 Charles St. NE 2 William Herschbach
1486 6190-92 East River Rd. 2 Bob& Frankie Fetrow
1600 6654 East River Rd. 1 Meidinger Enterprises, Inc.
2174 1057 Fillmore Cir. NE 1 Nicole & David Walker
2161 1072 Fillmore Cir. NE 1 Karilyn Miller
1354 7857-61 Firwood Way NE 2 John (Sam) Schudi
1356 7879-81 Firwood Way NE 2 Ted Raines
1358 7889-91 Firwood Way NE 2 Xiaolong Shih
2190 298 Liberty St. NE 1 Angela Dynkavitch
1376 7400 Lyric Ln. NE 8 William A. Shaw
1384 6019 Main St. NE 3 Yonas Berhane
1385 6021 Main St. NE 4 Xiao Long Shih
2203 721 Marigold Terrace NE 1 Amy Schmidt
1059 140 Mississippi PI. NE 32 4 Enes Gluhic
� AGENDA ITEM
� CITY COUNCIL MEETING OF
� MAY 27, 2014
To: Wa11y Wysopal, City Manager
From: Darin R.Nelson,Finance Director
Shelly Peterson,Assistant Finance Director
Date: May 22, 2014
Re: Resolution Approving a Contract with Tyler Technologies for an Enterprise
Resource Planning(ERP) Solution
Background
Finance and human resources staff began discussions about replacing the City's current financial
system almost two years ago. Our current system has been in place for close to 25 years and is due
for substantial upgrades if we are to maintain its existence. The current system is a DOS based
green screen system that lacks functionality and flexibility. Vendor provided enhancements to the
current system are minimal due to the age and platform of the system.
The City sent out requests for proposals late last summer to eleven software vendors. We received
three proposals back at that time. We were quickly able to eliminate one vendor strictly due to
pricing that was substantially more than the other two vendors. In addition to these two vendors,
staff also considered LOGIS,which is a consortium of local governments that provides financial
system services. Demos with these three vendors were conducted in November and December.
From that point, further analysis was done to assure that proper comparisons were being made and
that modules being proposed were applicable to our operations. At this point,LOGIS was
eluninated due to the price differential. This left us with two vendors,Tyler Technologies and
5pringbrook. Price on these two systems was virtually identical,which left the decision in the
hands of capability and fit.
Staff went on site visits to metro communities that aze currently utilizing each system. Inver Grove
Heights converted to Tyler Technologies in 2011 from the same system that we are currently using.
We also visited with the City of Roseville,which utilizes the Springbrook system. In addition to
these site visits,I made inquiries with other cities rnnning both applications. As a final procedure,
we required both vendors to physically demonstrate how our utility billing process would function
within both systems. Due to the manual nature of our utility meter cazds,we needed to make sure
that data entry for meter cards was as efficient as possible.
1
34
After these additional demos and further discussion amongst staff a decision was made to pursue
contract negotiations with Tyler Technologies for their Incode Version 10 product.
Attributes that set Tyler Technologies apart include:
- Superior on-line training program for staff development;
- Known ability to handle self read utility cards;
- A forms module that allows for the click of a button to create a standard form, such as an
NSF check notice for a utility customer or a high consumption letter;
- Evergreen policy so once we buy the software all future upgrades are included;
- Customer service expects to resolve 70%of the calls on the first contact;
- Budget module is more robust allowing for multiple budget scenarios;
- Includes ability to automatically reverse year end accruals;
- Auto cash balancing for dual entry accounting across multiple funds;and
- Multiple purchases can be flagged for fixed asset purchases.
We have budgeted$250,000 within the MIS Internal Service Fund for the replacement of the
financial system. Below is a summary of the cost comparisons between our current system and
the three vendors. The attached contract for Tyler Technologies does not include the cost of
purchasing servers,which has been included in the total cost for comparison purposes. Servers
would be purchased of�'of the state contract with specifications provided by Tyler Technologies.
One addirional service we elected to purchase is vendor provided maintenance. This provides
unlimited remote support on technical issues that may arise for both software and hardware.
This service also provides updates and installation of service packs,proactive system monitoring,
Windows updates, along with back up assistance. Springbrook did not offer this level of
supplemental service. Staff felt this was an important service especially in the early years of the
system to assure software and hardware issues are resolved quickly.
Due to the unknown nature of the conversion and the fluidity of implementation process,a 10%
contingency is appropriate in order to keep the process moving at an efficient pace. The 10%
contingency would be calculated off the estimated total of$188,994 for software,professional
services, and travel and would be a not to exceed amount of$207,893 for these services. Tyler
Technologies requires change orders for any changes to the original scope. The contingency
would allow staff to approve change orders for additional service requests if accumulated
changes orders are within the not to exceed amount.
Implementation is expected to begin this summer. Substantial system clean up and preparation
will be required in order to assure conversion goes as smoothly as possible. Part of this
preparation will include creating a new chart of accounts that better aligns with current financial
reporting requirements. Due to limited staff availability,the conversion will be done in phases.
Financials along with HRlpayroll will be done in the first phase with utility billing converted in
the second phase. I am anticipating we should be live on fmancials and HR/payroll by around
the first of the year or shortly thereafter and utility billing by next fall.
2
35
City of Fridley ERP Cost Comparison
05/21/14
CurrentHTE Springbrook- Tyler-
System LOGIS Premise Premise
Start Up Costs
HR/Payroll/Financials $ - $ 47,925 $ 80,250 $ 60,179
Utility Billing - 55,000� 20,775 31,654
Data Conversion - 70,000� 28,500 36,125
Training - - 54,250� 53,000�
Licenses - - 11,500 -
Special Assessments - 10,185 - -
Travel Costs* - - 24,200 21,811
HTE Discount - - - (13,775)
City Owned Servers 60,000 - 20,000 20,000
Total Start Up Costs 60,000 183,110 239,475 208,994 **
FirstYearSubscription Costs
HR/Payroll/Financials - 60,540 23,903 19,045
Utility Billing - 46,210 5,186 7,914
Vendor Provided Maint. (Opt) - - - 5,975
First Year Discount - _ (2g�pgg) _
Total FirstYearSubscriptionCosts 35,773 106,750 - 32,934
Years 2 thru 5 Costs
Year 2 36,846 122,140 29,670 34,251
Year 3 37,952 124,583 30,263 35,621
Year 4 39,090 127,074 30,868 37,046
Year 5 40,263 129,616 31,486 38,899
Total 5 Year Cost 249,924 793,273 361,762 387,746
Average 5 Year Cost $ 49,985 $ 158,655 $ 72,352 $ 77,549
*Travel Costs are billed on actual costs
** 1096 contingenty of$18,899 not included in total start up costs
Conclusion:
Staff recommends approving the attached resolution authorizing the Mayor and City Manager to
enter into an agreement with Tyler Technologies to fiunish,deliver, install and implement the
products and services set forth in the investment summary of the attached agreement with a not to
exceed amount of$207,893 for application software,professional services and travel.
Attachment
3
36
RESOLUTION NO. 2014-
A RESOLUTION APPROVING A CONTRACT WITH TYLER TECHNOLOGIES FOR
AN ENTERPRISE RESOURCE PLANNING(ERP)SOLUTION
WHEREAS, The City of Fridley sent our requests for proposals (RFP) to eleven soflware vendors
for an ERP solution that was to include financial,hr/payroll, and utility billing applications,and
WHEREAS, three vendors replied to the RFP and in addition LOGIS, a consortium of local
governments was also considered in the selection process,and
WHEREAS, after careful consideration, site visits and application specific demos, Tyler
Technologies was selected to pursue contract negotiations for their Incode Version X product,and
WHEREAS, attributes that set Tyler Technologies apart include but were not limited to; superior
on-line training, the lrnown ability to handle self read cards, and an evergreen policy to ensure the
City has unlimited access to all future upgrades and releases,and
WHEREAS, the MIS Internal Service Fund has $250,000 budgeted for the replacement of the
current financial system,and
WHEREAS, the cost to deliver, install, and implement the ERP with Tyler Technologies is
estimated to be $188,994 not including the cost of servers that will be purchased separately through
the state contract,and
WHEREAS, a project of this scope and nature is often subject to changes due to requests for
additional services, therefore a 10% contingency is appropriate to keep the process moving at an
efficient pace,and
NOW, THEREFORE, BE TT RESOLVED,by the City Council of the City of Fridley that the City
enter into an agreement with Tyler Technologies to furnish, deliver, install and implement the
products and services set forth in the investrnent siauunary of the attached agreement with a not to
exceed amount of$207,893 for application soflware,professional services and travel.
PASSED AND ADOPTED BY THE CTTY COUNCIL OF THE CITY OF FRIDLEY THIS
DAY OF ,2014.
SCOTT J.LUND-MAYOR
ATTEST:
DEBRA A. SKOGEN -CITY CLERK
37
Attach�nt
•
�••'+� � I�r
�.,.... �
�r tec.hnr��gies
AGREEMENT
This agreement ("Agreement") is made this day of , 2014 ("Effective
Date")by and between Tyler Technologies, Inc.,a Delaware corporation with offices at 5519 53rd Street,
Lubbock, Texas 79414 ("Tyler") and the City of Fridley, with of�ces at 6431 University Avenue, NE,
Fridley,MN 55432("Client").
WHEREAS Client selected Tyler to fumish, deliver, install and implement the praiucts and services set
forth in the investment summary attached hereto as Exhibit 1 ("Investment Summary");
NOW THEREFORE, in consideration of the foregoing and of the mutual covenants and promises set forth
herein,Tyler and Client agree that Tyler shall provide products and services, and Client shall pay prices,
as set forth in this Agreement.
1. SOFTWARE LICENSE AGREEMENT
1.1. License Grant.
1.1.1. Upon the Effective Date,Tyler hereby grants to Client a non-exclusive, non-transferable,
royalty-free, revocable license to use the Tyler software products set forth in the
investment summary attached hereto as Exhibit 1 ("Investment Summary'7 and related
interfaces(collectively,the"Tyler Software Products")and documentation provided in or
with the Tyler Software Products ("Dceumentation") for Client's internal business
purposes only and otherwise subject to the terms and conditions of this Agreement.
This license is revocable by Tyler if Client fails to comply with the terms and conditions of
this Agreement, including without limitation, Client's failure to timely pay the Software
fees in full. Upon Client's payment in full for the Tyter Software Products,this license wilt
become irrevocable, subject to the restrictions on use and other terms set forth in this
Agreement.
1.1.2. Tyler shall retain ownership of, including all intellectual property rights in and to, the
Tyler Software Products and Documentation.
1.1.3. The Tyler Software Products are not licensed to perform functions or processing for
subdivisions or entities that were not disclosed to Tyler prior to the Effective Date. Tyler
acknowledges and agrees that this Agreement shall also include the Fridley Housing
Redevelopment Authority(HRA)as such a subdivision.
1.1.4. The right to vansfer the Tyler Software Products to a replacement hardware system is
included in this Agreement. Client shall pay Tyler for the cost of new media or any
required technical assistance to accommodate the transfer. Client shaft provide advance
written notice to Tyler of any such transfer.
Contract tD#2014-0109
Tyler Technologies,Inc.and the City of fridley,MN Page 1
38
Attachment
1.1.5. Ciient acknowledges and agrees that the Tyler Software Products and Documentation
are proprietary to Tyler and have been developed as trade secrets at Tyler's expense.
Client shall use best efforts to keep the Tyler Software Products and Documentation
confidential and to prevent any misuse, unauthorized use or unauthorized disclosure of
the Tyler SoRware Products or pocumentation by any party.
1.1.6. The Tyler Software Products may not be modified by anyone other than Ty{er. If Client
modifies the Tyler Software Products without Tyler's prior written consent, Tyler's
obligations to provide maintenance services on,and the warranty for,the Tyler Software
Products will be void. Client shall not pertorm decompilation,disassembly,translation or
other reverse engineering on the Tyler Software Products.
1.1.7. Client may make copies of the Tyler Software Products for archive purposes only. Client
shall repeat any and aN proprietary notices on any capy of the Tyler Software Products.
Client may make copies of the Documentation for internal use on{y.
1.1.8. Tyler maintains an escrow agreement with an escrow services company under which
Tyler places the source code of each major release of the Tyler Software Products. At
Client's request, Tyler will add Client as a beneficiary to such escrow agreement. Client
will pay the annual beneficiary fee and is solely responsible for maintaining its status as a
beneficiary.
1.2. Limited Warranty. For the purposes of this Agreement, a "Defect" is defined as a failure of the Tyler
Software Products to substantially conform to the then-current specifications and the functional
descriptions of the Tyler Software Products in Tyler's written proposal to Client. In the event of conflict
between the afore-mentioned documents,the then-current speci�cations will control. A Tyler Software
Product is "Defective" if it contains a Defect. For as long as a current Maintenance Agreement is in
place, Tyler warrants that the Tyler Software Products will not contain Defects. If the Tyler Software
Products do not perform as warranted, Tyler will use reasonable efforts, consistent with industry
standards,to cure the Defect in accordance with Tyler's then-curcent support call process.
1.3. Intellectual Proaerty Infringement Indemnification.
1.3.1. Tyler's Obtigations. Tyler shaN defend, indemnify and hold harmless Client against any
claim by an unaffiliated third party of this Agreement that a Tyler Software Product, if
used within the scope of this Agreement,directly infringes that party's registered United
States patent,copyright or trademark issued and existing as of the Effective Date or as of
the distribution date of a release to the Tyler Software Product,and will pay the amount
of any resulting adverse final judgment issued by a court of competent jurisdiction or of
any settlement made by Tyler in writing.
1.3.2. Client's Obligations. Tyler obligations in this section are contingent on the Client
performing all of the following in connection with any claim as described herein:
Contract ID#2014-0109
Tyler Technologies,Inc.and the City of Fridley,MN Page 2
39
Attachment
a. Promptly notifies Tyler in writing of any such claim;
b. Gives Tyler reasonable cooperation, information, and assistance in connection
with the claim;and
c. Consents to Tyler's sole control and authority with respect to the defense,
settlement or compromise of the claim.
1.3.3. Exceptions to Tyler's Obligations. Tyler will have no liability hereunder if the claim of
infringement ar an adverse final judgment rendered by a court of competent jurisdiction
results from:
a. Client's use of a previous version of a Tyler Software Product and the claim would
have been avoided had Client used the current version of the Tyler Software
Product;
b. Client's combining the Tyfer Software Product with devices or products not
provided by Tyler;
c. Use of a Tyler Software P�oduct in applications, business environments or
prceesses for which the Tyler Software Product was not designed or
contemplated, and where use of the Ty{er Software Product outside such
application, environment or business process would not have given rise to the
claim;
d. Corrections, modifications, alterations or enhancements that Client made to the
Tyler Software Product and such correction, modification, alteration or
enhancement is determined by a court of competent jurisdiction to be a
contributing cause of the infringement;
e. Use of the Tyler Software Product by any person or entity other than Client or
Client's employees;or
f. Client's willful infringement, including Client's continued use of the infringing Tyler
Software Product after C{ient becomes aware that such infringing Tyfer Software
Product is or is likely to become the subject of a ciaim hereunder.
1.3.4. Remedy.
a. In addition to Tyler's obligation to defend, indemnify and hold Cfient harmless
pursuant to Section 1.3.1 of this Agreement, in the event a Tyler Software Product
is, by a court of competent jurisdiction, finally determined to be infringing and its
use by Client is enjoined,Tyler will,at its election:
b. Procure for Client the right to continue using the infringing Ty4er Software
Products;or
c. Modify or replace the infringing Tyler Software Products so that it becomes non-
infringing.
Contract ID#2014-0109
Tyler Technologies,lnc.and the City of Fridley,MN Page 3
40
Attachment
2. PROFESSIONAL SERVICES AGREEMENT
2.1. Services. Tyler shall provide the services set forth in the Investment Summary at Client's
election, including Consulting,Training, Conversion, and other miscellaneous Services.Tyler will
provide the services on the schedule, and according to the terms and conditions, set forth in
the parties' Statement of Work ("SOW'�, set forth at Exhibit 3. In addition to the terms and
conditions in the SOW,the following terms and conditions shall apply.
2.2. Expenses. Expenses shall be bilted in accordance with the then-current Tyler Business Travel
Policy, based on Tyler's usuaf and customary practices, plus a 10%travel agent processing fee.
The currertt.Tyler Business Travel Policy is attached hereto as Exhibit 2. Copies of receipts shall
be provided on an exception basis at no charge. Should all receipts for non per diem expenses
be requested, an administrative fee shall be incurred. Receipts for mileage and miscellaneous
items less than twenry-five dollars($25)are not available.
2.3. Ca�cellation of Services. In the event Client cancels services less than two(2)weeks in advance,
Client is liable to Tyler for (i) all nan-refundable expenses incurred by Tyler on Client's behalf;
and (ii) hourly fees associated with the canceled services if Tyler is unable to re-assign its
personnel.
2.4. Additional Services.
2.4.1. The Investment Summary contains a good faith estimate of senrice fees and travel
expenses. Training and/or consulting services utilized in excess of those set forth in the
Investment Summary and additional related services not set forth in the Investment
Summary will be billed at Tyler's then-current rates, plus travel expenses incurred in
accordance with Section 2.2.
2.4.2. Programming and/or interface quotes are estimates based on Tyler's understanding of
the specifications supplied by Client. 1n the event Cfient requires additional work
performed above the specifications provided, Tyler will submit to Client an amendment
containing an estimate of the charges for the additional work. Client will have thirty(30)
calendar days from the date the estimate is provided to approve the amendment.
3. MAINTENANCE AGREEMENT
3.1. Maintenance Services.This Maintenance Agreement is effective on the earlier of(i) ninety(90)
days after use of a Tyler Software Product in live production, or (ii) one hund�ed eighty (180)
days from the date Tyler made the Tyler Software Products available to Client for downloading;
and will remain in force for an initial one (1) year term, which will renew automatically for
additional one (1) year terms unless terminated in writing by either party at least fifteen (15)
days prior to the end of the then-current term. Tyler agrees not to increase maintenance by
more than 4%per year for years 2-4. �
Contract ID#2014-0109
Tyler Technologies,Inc.and the City of Fridley,MN Page 4
41
Attachment
3.2. Maintenance Services Terms Conditions Limitations and Exclusions.
3.2.1. For as long as a current Maintenance Agreement is in place, Tyler shatl, in a
professional,good and workmanlike manner,pertorm its obligations in accordance with
Tyler's then current support call process in order to conform the Tyler Software
Products to the applicable warranty under this Agreement. Current, software support
hours are from 7am -7pm CST Monday-Friday. If Client modifies the Tyfer Software
Products without Tyler's prior written consent, Tyter's obligations to provide
maintenance services on and warrant the Tyler Software Products shall be void. Tyler
reserves the right to suspend maintenance services if Client fails to pay undisputed
maintenance fees within sixty (60) calendar days of the due date. Tyler will reinstate
maintenance services upon Client's payment of the overdue maintenance fees.
3.2.2. For as long as a current Maintenance Agreement is in place Tyler shaN provide Client
with alf releases Tyler makes to the Tyler Software Products that Tyler makes generally
available without additional charge to customers possessing a current Tyler annual
Maintenance Agreement. Third Party Products and installation,consulting and Vaining
services related to the new releases will be provided to Client at Tyler's then-current
rates. Client acknowledges and agrees that a new release of the Tyler Software
Producu is for implementation in the Tyler Software Products as they exist without
Client customization or modification. Tyler shall support prior releases of the Tyler
Software Products in accordance with Tyler's then-current release life cycle policy.
3.2.3. Maintenance fees do not include instaltation or impfementation of the Tyler Software
Products, onsite support (unless Tyler cannot remotely correct a defect in a Tyler
Software Product), application design, other consulting services, support of an
operating system or hardware,and support outside Tyler's normal business hours.
3.3. Client Resaonsibilities.
3.3.1. Client shall provide, at no charge to Tyler, full and free access to the Tyler Software
Products; working space; adequate facilities within a reasonable distance from the
equipment;and use of machines,attachments,features,or other equipment necessary
to provide maintenance services set forth herein.
3.3.2. Tyler currently utilizes "Go To AssisY' as a secure commercial PC to PC remote
connectivity tool to provide remote maintenance services. Client shall maintain for the
duration of the Agreement a high-speed Internet connection capable of connecting to
Client's PC's and server. As a secondary connectivity tool to the Tyler Servers,Tyler will
install a third party secure unattended remote connectivity program,which is currently
Bomgar. Client will need to provide Tyler a login account with local administrative
privileges to the Tyler Servers. Tyler requires that Client also maintain an alternate
remote connectivity method (including VPN, if necessary) for backup connectivity
purposes. Tyler,at its option,will use the connections to assist with p�oblem diagnosis
and resolution.
Contract/D�2(J14-0108
Tyler Technologies,Inc.and the City of Fridley,MN Page 5
42
Attachment
3.4. Sunaort Terms for Clients Not Participating in Annual Maintenance Aqreement. The Software
License Agreement includes ninety (90j days free maintenance. If Client elects not to
participate in the Annual Software Maintenance Agreement, Client shall receive support on a
Time and Materials bas+s fol{owing ninety (90} days after the Tyler Software is verified in
accordance with the following terms.
3.4.1. Such Clients:
a. will receive the lowest priority for Software Support,
b. will be required to purchase new releases of the Software. New releases will
include fixes, enhancements, and updates, such as Tax Tables, W/2 reporting
formats,1099 changes,etc.,
c. will be charged$175 per hour with a two-hour minimum for all software support
calls,
d. will not be granted access to Tyler's software support web-site,
e. are subject to higher rates for training and continuing education performed by
Tyler employees. This is due to the fact that the Client may not be utilizing the
most current version of our software.
3.4.2. Tyler will not guarantee a program fix to a documented bug for software versions that
are not the currently released version. If a Client decides to discontinue the Software
Maintenance Agreement and later chooses to reinstate the Software Maintenance
Agreement, the Client will be required to pay the portion of annual software support
maintenance fees for the Enhancement and Software Updates(2796)dating back to the
� date when the Client discontinued the Software Maintenance Agreement.
4. THIRD PARTY PRODUCT AGREEMENT
4.1. AJc reement to License or Sell Third Party Products. For the price set forth in the Investment
Summary, Tyler agrees to license or sell and deliver to Client, and Client agrees to accept from
Tyler the hardware ("Hardware") and third party software ("Third Party Software") set forth in
the Investment Summary(collectively,the"Third Party Products'7.
4.2. Third Party Pcoduct Warranties. Client acknowledges and agrees that Tyler is not the
manufacturer of the Third Party Products. As such, Tyler does not warrant or guarantee the
Third Party Products. Tyler hereby grants and passes through to Client any warranty
adjustments that Tyler may receive from the developer, manufacturer or supplier of the Third
Party Products("Developer'�.
4.3. Third Party Software Maintenance. In the event Client elects not to purchase through Tyler
maintenance services on the Third Party Software, it shall be the responsibility of Client to
repair and maintain the Third Party Software and purchase enhancements as necessary after
Contract ID#2014-0109
Tyler Technologies,Inc.and the City of Fridley,MN Page 6
43
Attachment
installation.
4.3.1. In the event Client elects to purchase through Tyler maintenance services on the Third
Party Software, Tyler will facilitate resolution of a defect in Third Party Software with
the Developer.
4.3.2. In the event the Developer charges a fee for future Third Party Software release(s),
Client shall be required to pay such fee.
5. GENERAL TERMS AND CONDITIONS
5.1. Taxes. The fees set forth in the Investment Summary do not include any taxes, including,
without limitation, sales, use or excise tax. All applicable taxes shall be paid by Tyler to the
proper authorities and shall be reimbursed by Client to Tyler. In the event Client possesses a
valid direct-pay permit, Client will forward such permit to Tyler on the Effective Date, in
accordance with Paragraph 5.21. In such event, Client will be responsible for remitting all
applicable taxes to the proper authorities. If tax-exempt, Client will provide Tyler with Client's
tax-exempt certificate.
5.2. Force Maieure: Client Assistance. "Force Majeure" is defined as an event beyond the
reasonable control of a party, including governmental action, war, riot or civil commotion, fire,
natural disaster, labor disputes, restraints affecting shipping or credit, delay of carriers,
inadequate supply of suitable materials or any other cause which could not with reasonable
diligence be foreseen, controlled or prevented by the party. Neither party shall be liable for
delays in performing its obligations under this Agreement to the extent that the delay is caused
by Force Majeure.
5.2.1. Force Majeure will not be allowed unless:
a. Within ten(10)business days of the occurrence of Force Majeure,the party whose
performance is delayed thereby provides the other party or parties with written
notice exp4aining the cause and extent thereof, as well as a request for a time
extension equa{to the estimated duration of the Force Majeure events.
b. Within ten (10) business days after the cessation of the Force Majeure event, the
party whose performance was delayed provides the other party written notice of
the time at which Force Majeure ceased and a complete explanation of all
pertinent events pertaining to the entire Force Majeure situation.
5.2.2. Either party will have the right to terminate this Agreement if Force Majeure suspends
pertormance of scheduled tasks by one or more parties for a period of one hundred-
twenty(120)or more days from the scheduled date of the task. This paragraph will not
relieve Client of its responsibility to pay for services and goods provided to Client and
expenses incurred on behalf of Client prior to the effective date of termination.
5.2,3. In addition, Client acknowledges that the implementation of the Tyler Software
Products is a cooperative process requiring the time and resources of Client personnel.
Contiact ID�2014-0109
Tyler Technologies,Inc.and the City of Fridley,MN Page 7
44
Attachment
Client shall, and shall cause Client personnel to,use all reasonable efforts to cooperate
with and assist Tyler as may be reasonably required to meet the project deadlines and
other milestones agreed to by the parties for implementation. Tyler shall not be liable
for failure to meet such deadlines and milestones when such failure is due to Force
Majeure (as defined above) or to the failure by Client personnel to provide such
cooperation and assistance(either through action or omission).
5.3. Indemnification. Except for those inteflectual property infringement claims which are governed
by Section 1.3 of this Agreement,the parties to defend,indemnify and hold harmless as follows:
5.3.1. Tyler shall indemnify, defend and hold harmless Client and its agents, officials and
employees from and against any and all direct claims, losses, liabilities, damages,costs
and expenses (including reasonable attorney's fees and costs) for personal injury or
property damage aris+ng from Tyler's negligence or willfu!misconduct.
5.3.2. Subject to and limited by the tort liability limits set forth in Minnesota Statutes Chapter
466, Client shall indemnify, defend and hold harmless Tyler and its agents,officials and
employees from and against any and all direct claims, losses, liabilities, damages,costs
and expenses (including reasonable attorney's fees and costs) for personal injury or
property damage arising from ClienCs negligence or willful misconduct.
5.3.3. Nothing contained herein shall be deemed a waiver by Client of any governmental
immunity defenses,statutory or otherwise.
5.4. Limitation of Liabilitv. In no event shall Tyler be liable for special, indirect, incidental,
consequential, or exemplary damages, including, without limitation, any damages resulting
from loss of use, loss of data, interruption of business activities, or failure to realize savings
arising out of or in connection with the use of the Tyler Software Products, Services, or Third
Party Products. Tyler's liability for damages and expenses arising from the Tyler Software
Products or Services, whether based on a theory of contract or tort, including negligence and
strict liability, shall be limited to the Fees set forth in the Investment Summary related to the
defective product or service. Tyler's liability for damages and expenses arising from the Third
Party Products, whether based on a theory of contract or tort, including negligence and strict
liability,shall be limited to the license fee/purchase price of the Third Party Products. Such fees
reflect and are set in reliance upon this limitation of liability.
5.5. Disclaimer. THE RIGHTS, REMEDIES, AND WARRANTIES SET FORTH 1N THIS AGREEMENT ARE
EXCLUSIVE AND iN LIEU OF ALL OTHER RIGHTS, REMEDIES, AND WARRANTIES EXPRESSED,
IMPLIED, OR STATUTORY, INCLUDING, WITHOUT LIMITATION, THE WARRANTIES OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE,AND SYSTEM INTEGRATION, WHICH
ARE HEREBY DISCLAIMED BY TYLER.
5.6. Qispute Resolution. The parties agree to notify each other within fifteen (15) business days of
becoming aware of a dispute under this Agreement("Dispute Notice Date").
Contract ID,�2014-0109
Tyler Technologies,Inc.and the City of Fridley,MN Page 8
45
Attachment
5.6.1. The parties further agree that, before resorting to any formai dispute resolution
process, they will first engage in good faith negotiations in an effort to find a solution
that serves their respective and mutual interests. Party principals agree to participate
directly in these negotiations. Unless otherwise agreed in writing,the parties shall have
fifteen (15) business days from the Dispute Notice Date to begin these negotiations,
and thirty (30) days from the Dispute Notice Date to complete these negotiations. All
such negotiations will be deemed confidential settlement discussions not subject to
disclosure under Federal Rule of Civil Procedure 408 and/or any similar applicable state
rule.
5.6.2. In ihe event the parties fail to resolve the dispute as set forth above,the dispute will be
referred to non-binding mediation with mediation costs split equally between the
parties. Thereafter, either party may assert its other rights and remedies under this
Agreement within a court of competent jurisdiction.
5.6.3. Nothing in this Article will prevent a party from applying to a federal or state court of
competent jurisdiction to obtain injunctive relief pending resolution of the dispute
through the dispute resolution procedures set forth herein.
5.7. No Intended Third Party Beneficiaries. This Agreement is entered into solely for the benefit of
Tyler and Client. No third party will be deemed a beneficiary of this Agreement, and no third
party will have the right to make any claim or assert any right under this Agreement.
5.8. Governing Law. This Agreement will be governed by and construed in accordance with the laws
of Client's state of domicile.
5.9. Severabilitv. If any term or provision of this Agreement or the application thereof, to any
extent, be held invalid or unenforceable,the remainder of this Agreement or the application of
such term or provision to persons or circumstances other than those as to which it is held
invalid or unenforceable will not be affected thereby, and each term and provision of this
Agreement will be valid and enforced to the fullest extent permitted by law.
5.10. No Waiver. In the event that the terms and conditions of this Agreement are not strictly
enforced by Tyler or Client, such non-enforcement shall not act as or be deemed to act as a
waiver or modification of this Agreement, nor shaN such non-enforcement prevent Tyfer or
Client from enforcing each and every term of this Agreemer�t thereafter.
5.11. Amendment. This Agreement may only be modified by written amendment signed by
authorized representatives of both parties.
5.12. Termination.
5.12.1. Termination for Cause. Client may terminate this Agreement for cause in the event
Tyler does not cure a material breach of this Ag�eement within thirty (30) days of
receiving notice of such breach from Client. Upon wch termination, Client shall pay
Tyler for all services and expenses not in dispute and non-Defective Tyler Software
Products which were delivered or incurred prior to the date Tyier received Client's
Contract ID#2014-0109
Tyler Te�hno/ogies,lnc.and the City of Fridley,MN Page 9
46
Attachment
notice of termination. Payment for services and expenses in dispute will be determined
in accordance with the dispute resolution process.
5.12.2. Termination for Non-appropriation. If Client should not appropriate or othenivise make
available funds sufficient to purchase,lease,operate or maintain the products set forth
in this Agreement,or other means of performing the same functions of such products,
Client may unilateraNy terminate this Agreement only upon thirty (30) days written
notice to Tyler. Upon termination, Client shall remit payment for all products and
services defivered to Client and all expenses incurred by Ty1er prior to Tyler's receipt of
the termination notice. Client will not be entitled to a refund or offset of previously
paid license and other fees.
5.13. No AssicLnment. Client may not assign its rights and responsibilities under this Agreement
without Tyler's prior written permission,not to be unreasonably withheld.
5.14. Successors and Assiqns. This Agreement shall inure to the benefit of and be binding on the
parties hereto and their permitted successors and assigns.
5.15. Confidentialitv. Both parties recognize that their respective employees and agents, in the
course of performance of this Agreement,may be exposed to confidentiat information and that
disclosure of such information could viotate rights to private individuals and entities. Each party
agrees that it shall not disclose any confidential information of the other party and further
agrees to take appropriate action to prevent such disclosure by its employees or agents. The
confidentiality covenants contained herein will survive the termination or cancellation of this
Agreement for a period of two(2)years.
5.15.1. This obligation of confidentiality will not apply to information that:
a. At the time of the disclosure is in the public domain;
b. After disctosure, becomes part of the public domain by publication or otherwise,
except by breach of this Agreement by a party;
c. Either party can establish by reasonable proof was in that the other party's
possession at the time of disclosure;
d. Either party receives from a third party who has a right to disclose it to a party;or
5.16. Is subject to Freedom of Information Act and Minnesota Government Data Practices Act
request only to the extent disclosure is based on the good faith written opinion of the
information recipient's legal counsel that disclosure is required by taw. However, any such
disclosure by the information recipient must be preceded by the information recipient's prompt
notice of the service of process or other documentation that underfies such required disclosure.
In addition, the information recipient must use its best efforts to assist the information
disclosing party to obtain a protective order or otherwise protect the confidentiality of such
information as permitted by law. The information disclosing party reserves the right to obtain a
protective order or otherwise protect the confidentiality of such information as permitted by
law.
Contract ID�2014-0109
Tyler Technologies,lnc.and the City of Fridley,MN Page 10
47
Attachment
5.17. Shi in . Delivery shatl be F.O.B.shipping point.
5.18. Payment Terms.
5.18.1. Tyler shall invoice Client$19,515.00 upon the Effective Date. Such amount equals 25%
of the license fees for the Tyler Software Products.
5.18.2. Tyler shall invoice Client$46,835.00 when Tyler has made the Tyler Software Products
available to Client for downloading. Such amount equals 6096 of the license fees for the
Tyle�Software Products.
5.18.3. Tyler shall invoice Client $11,709.00 upon the earlier of (i) the first use of a Tyler
Software Product in live production,or(ii)one hundred eighty(180)days from the date
Tyler made the Tyler Software Products available to Client for downloading. Such
amount equals 15%of the license fees for the Tyler Software Products.
5.18.4. Tyler shall invoice Clierrt fees for services,plus expenses,if and as providedlincuned.
5.18.5. Tyler shall invoice a 50% deposit for modifications upon delivery of specifications and
50% upon delivery of modification. Tyler will perform a modification upon receipt of
written notice to proceed from Client. Client wiA have thirty(30) days from delivery of
a modification to test such modification. In the event Client does not report an issue
with such modification to Tyler within such thirty(30) day period,the modification will
be deemed in compliance with the specifications.
5.18.6. Prices do not include travel expenses incurred in accordance with Tyler's then-current
Business Travel Policy.
5.18.7. Payment is due within thirty (30) days of the invoice date. If payment is not made
within thirty(30)days of the invoice date,a one and one half percent(1.5%)per month
interest charge shall be assessed until date of payment.
5.18.8. Maintenance fees are waived through the earlier of (i� ninety (90) days after use of a
Tyle�Software Product in live production,or(ii)one hundred eighty(180)days from the
date Tyler made the Tyler Software Pralucts available to Client for downloading.
Subsequent annual Maintenance fees are subject to change and will be due on the
anniversary of such date.
5.19. Electronic Payment. Tyler prefers to receive payments electronically. Tyler's electronic
payment information is as follows:
Bank: Wells Fargo Bank,N.A.
420 Montgomery
San Francisco,CA 94104
ABA: 121000248
Account: 4124302472
Beneficiary: Tyler Technologies Inc.—Operating
Contract ID#2014-0109
Tyler Technologies,lnc.and the City of Fridley,MN Page 11
48
Attachment
5.20. Entire Agreement. This Agreement represents the entire agreement of Client and Tyler with
respect to the subject matter hereof, and supersedes any prior agreements, understandings,
and representations, whether written, oral, expressed, implied, or statutory. Client hereby
acknowledges that in entering into this Agreement it did not rely on any information not
explicitly set forth in this Agreement.
5.21. Multiple Originals and Signatures. This Agreement may be executed in multiple originals,any of
which shall be independently treated as an original document. Any electronic,faxed, scanned,
photocopied or similarly reproduced signature on this Agreement or any amendment hereto
shall be deemed an original signature and shall be fully enforceable as if an original signature.
5.22. Notices.
5.22.1. All notices or communications required or permitted as a part of this Agreement will be
in writing (unless another verifiable medium is expressly authorized) and will be
deemed delivered when:
a. Actually received,
b. Upon receipt by sender of a certified mail,return receipt signed by an employee or
agent of the party,
c. Upon receipt by sender of proof of email delivery,or
d. If not actually received, ten (10) days after deposit with the United States Postal
Service authorized mail center with proper postage (certified mail, return receipt
requested) affixed and addressed to the respective other party at the address set
forth in this Agreement o�such other address as the party may have designated by
notice or Agreement amendment to the other party.
5.22.2. Consequences to be borne due to failure to receive a notice due to improper
notification by the intended receiving party of a new address will be borne by the
intended receiving party. The addresses of the parties to this Agreement are as follows:
City of Fridley Tyler Technologies,Inc.
6431 University Avenue,NE One Tyler Drive
Fridley, MN 55432 Yarmouth,ME 04096
Attention: Darin Nelson Attention:Associate General Counsel
5.23. Independent ConVactor. This is not an agreement of partnership or employment of Tyle� or
any of Tyler's employees by Client. Tyler is an independent contractor for all purposes under
this Agreement.
Contract lD,tE 20i4-0109
Tyler Technologies,lnc.and the City of Fridley,MN Page 12
49
Attachment
5.24. Tyler Products and Services. Client may purchase additional Tyler products and services at
quoted prices from Revised Quote dated January 29, 2014 for a period of 12 months from date
of contract,after that time period,prices shall be the current list price,pursuant to the terms of
this Agreement,by executing a mutually agreed addendum.
IN WITNESS WHEREOF,persons having been duly authorized and empowered enter into this Agreement.
City of fridley,MN Tyler Technologies,tnc.
By: By�
Name: Name:
Title: Mayor Title:
Date: Date:
City of Fridley,MN
By:
Name:
Title:City Manager
Date:
Contrad IDi�2014-0109
Tyler Technologies,lnc.and the City of Fridley,MN Page 13
50
Exhibit 1
Attachment
investment Summary ,; ����
Mr.Darin Nelson
City of Fridley w��
Contract ID#: 20140109
Prepared for: City of Fridley
Contact Person: Mr.Darin Nelson Issue Date: 517114
Address: 6431 University Avenue,NE
Fridley,MN 55432
Phone: (763)5723520 Sales Rep: T.puinn
Pax:
Email: darin.nelsonC�fridlevmn aov
Tax Exempt: Yes/No
Product,Service 8 Equipment Upon Upon As Agreed As Progress Ta��s Annual
Execution Delivery Upon Occurs Fees
Total Applicationa Softwara 22,958 55,100 22 g5g
License Fees-INCODE Finenciel Sude 4,759 31,725
License Fees-INCODE Personnel Menegemenf Suite 1,836 12,240
Ucense Fees-INCODE Customer Relationship Menagement Suite 4,748 31,654
License Fees-INCODE Document Managemenf Suite 2 qg2 �s 2�4
Loss Oiscvun! i3A44) f�12651 ;2.066) 113,775)
Tofal Profesaional Servicea
Implemenfation 47,500 47,500
Project Menagement&Finel Implementation 5,500 5,500
Deta Conversion 39,625 39,625
Mnual Senicea
Employee Sel(Service 3,000
Tyler On Demend-Tyler U 1,000
Systems Menegement
5,975
Totals 19,515 46,835 71,709 92,625 170,683 32,934
Please Note:Treve/expensea wJll be bflled as incuned.
Page 1
51
Attachment
Software Licenses
Mr.Darin Nelson +�w �����`
City of Fridley,MN ���`` ti
May 7,2014
Estimated Estimated
Application Software Hours Services License Fee Services Annual Fee
Incode Financial Management Suite 31 725 17 000 7 931
Core Financials 76 9,500
(General Ledger,Budget Prep,Bank Recon,Accounts Payable)
Positive Pay
Purchasing 24 3,000
Fixed Assets 16 2,000
Project Accounting 12 1,500
Financial Consutting Services g �ppp
Incode Personnel Management Suite 12 240 11 000 6 O60
Personnel Management 72 9,000
Employee Self Service (Number of FTE Employees) 32 NIC
(Employee Portal)
ESS Time&Attendance(Number of FTE Employees) 32 3,000
Personnel Management Consutting Service 16 2,000
Incode Customer RelationshiR Management Suite 31 654 16 500 7 914
Utildy CIS System gg ��pp�
Utility Payment Import(Generic Intertace) Included Included
Third Party Printing Intertace Included Included
Utility Handhekl Meter-Reader Intertace-Itron Included Included
Tax LIEN Process and File Export S 1,000
Cashiering 24 3,000
(Support Credit/Debit Cards via ETS,PCl Compliant)
Miscellaneous Accounts Receivable 12 1,500
Incode Content/Doeument Management Suite 16 214 3 000 4 054
Incode Printing and Reporting Solutions
Standard Forms Package Included Included
(4 Ove�lays for Financials,5 Overlays(or CRM, 1 Logo)
Secure Signatures(includes 2 signatures) InGuded Included
Output Director
Output Director 8 1,000
(Base Engine,Print Outpuf Channel, Tyler Content Management Output
Channel,Emad Output Channel)
Lasertiche Output Channel Included Included
Content Management
Lasertiche Financial&Personnel Suite Intertace 8 1,000
Lasefiche CRM Suite Intertace g �,ppp
Professional Services 5,500
Professional Services
Final implementation 24 3,000
Projed Management 2,500
Incode Application Subtotal 444 47,500 91,833 47,500 25,958
Professional Services 24 5,500
Preferred Customer Discount (15%) (13,775)
Application and System Software Total 47,500 78,058 53,000 25,958
Page 2
52
Attachment
•
Professional Services '•"• tv�er
Mr.Darin Nelson ,i��s� �� �f ����k1e-
City of Fridley
May 7,2014
Estimated
Conversion Services Hours Services Conversion Fee
_ Financial Applications 8 500
General Ledger 8 1,000
-Chart of Accounts-No History
-Budget(2 years)
-Summarized History(2 years)
Accounts Payable 4 500
-Vendor Master Info,address,primary contact
-1099 Balances(current year)
Fixed Assets 8 1,000
-Assets information with improvements,totals only,no history)
PersonneUPayroll Applications 8 000
Personnel ManagemenUPayroll 32 4,000
-Basic Employee Information-employee master,address,primary contact,standard
dates(i.e.hire,birth,termination,leave),standard phones(work,home,cell),current direct
deposit,current position,retirement,employee deductions,employee taxes
-Current Year Leave Balances
-Current Year detailed employee pay history-paycheck earnings,eaming distribution,
deductions and taxes OR current year quarterly summarized history
Utility Billing 23 125
Utility-CIS 38 4,750
-Contacts/PropertieslAccounts
-Service meter info-meter inventory
-TransactionlConsumptionlRead History(2 Years)
-Metered services(1 metered service)
-Non-Metered service(up to 2 services)
Bank code,drafts,deposits 2 250
Meter change outs,contracts/billed deposits,devices 4 500
Notes 1 125
Converaion Services Total 39,625
Note:
Financial data conversion consists of current year plus 2 years history.
Utility Billing conversion data consists of current year plus 5 years history.
Financial conversion will include City of Fridley,and the Fridley HRA(assumes data is provided in same format)
Page 3
53
Attachment
Tyter On Demand-Tyler U '�„�` t Rer
Mr.Darin Nelson �1■ �, ,.
City of Fhdley,MN
May 7,2014
��� Annual Fee
Tyler On Demand-Tyler U
Tyler U Subscnption 1,000
-E-leaming courses available for alt employees during the subscription period
-Unlimited access to hundreds of e-leaming courses spanning the entire suite of Tyler applications
-Unlimited access to on-demand Continuing Professional Education credit courses certified by NASBA standards
-Un4imited access to Govemment compliance courses such as fiIPAA Compliance,Red Flag Rules,and Workp{ace Harassment Prevention
-Available 24/7
-New courses created continually
Tyler Technologies,Inc.is registered with the National Association of State Boards of Accountancy(NASBA)as a sponsor of continuing
professional education on the Nationa!Registry of CPE Sponsors.5tate boards of accountancy have final authairy on the acceptance of
individuaf courses for CPE credit.Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through
its website: �vww.leaminqmarket.ora
Tyler Online Trafning CeMer Totat �'��
Page 4
54
Attachment
Systems Management „�;
Mr.Darin Nelson ������► #yler
City of Fridley,MN • ' `""`��'``
May 7,2014
Service Annual Fee
Tyler Systems Management
TylerApplfcat�on Servers
Annual Fee 5,975
Tyler Systems Management includes:
Proactive System Monitoring
"Tyler apptication availability
*Server Hardware Monitoring
*Monthly System Status reports via email
Remote Technical Support 7a-7p CST
*Troubleshoot Tyler Server and Workstation Hardware and Software Issue
*Technical Help-Desk Support-Unlimited Remote support on technical issues.
"Tyler Application and DB migration to new hardware
Database Administration
'SQL Server updates and Patches
*Database Monitoring
*Maintenance Plan setup
Backup Assistance
*Guide you through establishing backup procedures that will minimize your
downtime in the event of a disaster.
"Troub�eshoot and resolve problems with backups
Network Protection Services
*Service packs and windows updates
*Tyler Application Automated update service
Reduced rate for on-site assistance
*$100/hr for on-site troubleshooting and consulting services
Tyler Remote Helpdesk Requirements
*High speed internet required
"Supported tape backup hardware and software
'All supported computers must meet Tyler minimum hardware requirements
Systems Management 5,975
Non Participation
Help Desk
LAN Troubleshooting $75 per 1/2 hour,maximum 90 Minutes
WAN Troubleshooting $75 per 1/2 hour, maximum 90 Minutes
HW Troubleshooting $75 per 1/2 hour,maximum 90 Minutes
Page 5
5S
Attachment
Exhibit 2
Tyler Business Travel Policy
1. Air Travel
A. Reservations and Tickets
Tyler's Travel Management Company (TMC) will provide an employee with a direct flight within
two hours before or after the requested departure time, assuming that flight does not add more
than three hours to the employee's total trip duration and the fare is within $100 (each way) of
the lowest logical fare. lf a net savings of $200 or more (each way) is possible through a
connecting flight that is within two hours before or after the requested departure time and that
does not add more than three hours to the employee's total trip duration, the connecting flight
should be accepted.
Employees are encouraged to make reservations far enough in advance to take full advantage of
discount opportunities. A seven-day advance booking requirement is mandatory. When booking
less than seven days in advance,management approval will be required.
Except in the case of international travel where a segment of continuous air travei is scheduled to
exceed six hours,only economy or coach class seating is reimbursable.
B. Baggage Fees
Reimbursement of personal baggage charges are based on the trip duration as foAows:
• Up to five days=one checked bag
• Six or more days=two checked bags
Baggage fees for sports equipment are not reimbursable.
2. Ground Transportation
A. Private Automobile
Mileage Allowance-Business use of an employee's private automobile will be reimbursed at the
current IRS allowable rate, plus out of pocket costs for tolls and parking. Mileage will be
calculated by using the employee's office as the starting and ending point, in compliance with IRS
regulations. Employees who have been designated a home office should calculate miles from
thei�home.
B. Rental Car
Employees are authorized to rent cars only in conjunction with air Vavel when cost,convenience and
Page 1
56
Attachment
the specific situation require their use. When renting a car for Tyler business, employees should
select a "mid-size" or "intermediate" car. "Full" size cars may be rented when three or more
employees are Vaveling together. Tyler carries leased vehicle coverage for business car rentals;
additional insurance on the rental agreement should be declined.
C. Public Transportation
Taxi or airport limousine services may be considerecf when traveling in and around cities or to and
from airports when less expensive means of transportatibn are unavailable or impractical. The actual
fare plus a reasonable tip (15-1896) are reimbursable. In the case of a free hotel shuttle to the
airport,tips are included in the per diem rates and will not be reimbursed separately.
D. Parking and Tolls
When parking at the airport, employees must use longer term parking areas that are measured in
days as opposed to hours. Park and fly options located near some airports may alsfl be used. Foc
extended trips that would result in excessive parking charges, public transportation to/from the
airport should be considered. Tolts will be reimbursed when receipts are presented.
3. Lodging
Tyler's TMC will select hotel chains that are well established, reasonable in price and conveniently
located in relation to the Vaveler's work assignment. Typical hotel chains include Courtyard,Fairtield Inn,
Hampton Inn and Holiday Inn Express. If the employee has a discount rate with a local hotel,the hotel
reservation should note that discour�t and the employee should confirm the lower�ate with the hotel
upon arrival. Employee memberships in travet clubs such as AAA should be noted in their travel profiles
so that the employee can take advantage of any lower club rates.
"No shows"or cancellation fees are not reimbursable if the employee does not comply with the hotel's
cancellation policy.
Tips for maids and other hotel staff are included in the per diem rate and are not reimbursed separately.
4. Meals and Incidental Expenses
Empfoyee meals and incidental expenses while on vavel status are in accordance with the federal per
diem rates published by the General Services Administration. Incidental expenses include tips to
maids, hotel staff, and shuttie drivers and other minor travel expenses. Per diem rates range from
$46 to$71. A complete listing is available at www.gsa.gov/perdiem.
A. Overnight Travel
For each full day of travel,all three meals are reimbursable. Per diems on the fi�st and last day of a
vip are governed as set forth below.
Page 2
57
Attachment
Departure Day
Depart before 12:00 naon Lunch and dinner
Depart after 12:00 noon Dinner
Return Day
Return before 12:00 noon Breakfast
Return between 12:00 noon&7:00 p.m. Breakfast and lunch
Rewrn after 7:00*p.m. Breakfast,lunch and dinner
*7:00 is defined as direct travel time and dces not include time taken to stop for dinner
The reimbursement rates for individual meals are calculated as a percentage of the full day per diem
as follows:
• Breakfast 15%
• Lunch 2596
• Dinner 60%
B. Same Day Travel
Employees traveling at least 100 miles to a site and returning in the same day are eligible to claim
lunch on an expense report. Employees on same day travel status are eligible to claim dinner in the
event they return home after 7:00*p.m.
5. Entertainment
Att entertainment experises must have a business purpose; a business discussion must occur either
before, after or during the event in order to qualify for reimbursement. The highest-ranking employee
present at the meal must pay for and submit entertainment expenses. An employee who submits an
entertainment expense for a meal or participates in a meal submitted by another employee cannot claim
a per diem for that same meal.
6. Internet Access—Hotels and Airports
Employees who travel may need to access their e-mail at night. Many hotels provide free high speed
internet access and Tyler employees are encouraged to use wch hotels whenever possible. If an
employee's hotel charges for intemet access it is reimbursable up to $10.00 per day. Charges for
internet access at airports are not reimbursable.
Effective April 1, 2012
Page 3
58
Attachment
Exhibit 3
�
�
� � �
� �
� � i�.�,�
� �
i �e� hr�olo ��s
�
Statement of Work
Software and Implementation Services
Prepared for.
City of Fridley, MN
Prepared by:
Tyler Technologies, inc.
www.tvlertechnoloqies.com
May 2, 2014
Printed by terry.quinn on 5/2/2014 at 623 AM Page 1 of 41
59
Tyter Technoiogies Statement of Work
Attachment
Table of Contents
PROJECTSCOPE&SUMMARY................................................................................................................................3
DATACONVERSION...............................................................................................................................................5
INVOICINGAND CLIENT SIGNOFFS.............................................................................................................................5
KEYPROJECT ASSUMPTIONS......................................................................................................................................5
OUTOF SCOPE...........................................................................................................................................................6
RISK/MITIGATIOIV STRATEGY...............................................................................................................................7
UNAVAILABILITY�INCOMPATIBILITY OF STAFF.......................................................................................................................7
CLIENTSTAFF UNAVAIIABIlI1Y...........................................................................................................................................7
SCOPECHANGES............................................................................................................................................................7
AcrivmrFoCUS.............................................................................................................................................................7
INCOMPLETE LEGACY,INTERfACE DOCUMENTAl10N.............................................................................................................8
ACHIEVABLEGOALS........................................................................................................................................................8
TECHNOLOGYAGE..........................................................................................................................................................8
CRITICAL SUCCESS FAC70RS..................................................................................................................................8
FIJTURE AMENDMENI'S TO SCOPE.........................................................................................................................9
PRO)ECT MANAGEMENT........................................................................................................................................9
STAFFING...................................................................................................................................................................9
PROJECfSCHEDULE.................................................................................................................................................10
DEVELOPMENTTOOLS.........................................................................................................................................10
DOCUMENTATION...............................................................................................................................................10
TYLER-PROVIDED DOCUMEWTATION.................................................................................................................................10
CLIENT-PROVIDED DOCUMENTATION................................................................................................................................10
SOW AITACHMEN73 LI51'ING..............................................................................................................................11
SOW Attachment A—(SampleJ Work AcknowledgemenL Form..........................................................................11
SOW Attachmenc 8—(Samp/eJ Change Order Form............................................................................................11
SOW Attachment C-Hardware/Software Requirements..................................................................................11
SOW Attachmeni D—Standard interfaces..........................................................................................................11
SOW Attachment E—Convenion Detail..............................................................................................................11
A7TACHMENTS....................................................................................................................................................12
��r.�/isJla� Page 2
Printed by terry.quinn on 5/2/2014 at 623 AM Page 2 of 41
60
Tyler Technologies Statement of Work
Attachment
PROJECT SC4PE&SUMMARY
The software and services purchased are outlined in the Investment Summary Section of the Agreement.
Any standard interFaces purchased are listed in the Investment Summary section of the Agreement and detailed in
SOW Attachment D—Standard Interfaces. It is important for the Client to read the portion of the Attachment
related to each interFace purchased to understand its full fundionality.
Data conversion services and other professional services hours included in tfie Investment summary are estimates.
Additional analysis will be performed during the Assess&Define stage to provide definitive pricing.
(ver.7/15/13) Page 3
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 3 of 41
61
'� � ! �
, • � r
i
- • • � _ ' • _ _ • ' : • _ • : • : • • - . • • _. • • . • C. f '
• • - • • • • ' � 1 ' • " • 1 • " _ • • - . • ' ' _ • ' _ �
� M;�ckofiCz i d.� Cempleteiftg�csurveys v� ,,,.,;.j,a,-� r.?ai�at�•r � Srainfunctinnal6ea�. � �u:c�eerarclGe-!ve
Q yr:!:,-`-�r�=.r.,._.,,,_.,,r � Rzvlw.ciientpmce�� = �- .=r�.,,, . --._r � ons}!s:?meper�icn p �
� _ ^ F�natlmp�wn?r't,^,r�
� ,,J r`` ` ,' ` __ Q7 anddata ;n _ - -ar-�;! .__r.*rs.s � Condxt�rtei2! U Trar�.ite?nEr;�:pFt�r:
•,_, � �1 Id?ntit��an�curcm � � CSaeracronal7e�
Et=t ;sh -r^cr,ra•or � � - .rri -;�,a �_'�c J
re o�r[s - '�j Frcj?rt Cb�OiC
� Ct=r:e P � Confirm°roper �F
� Idontih/sflrdardfr�rm `� - - �---''`��-f l3 lnsia€t:Snan � f�fee[ing
� "--=" ��rf��:__..,ir},r= ih.p,ra_. ---:_�--� � CL
� p �y Tes:Custorn Re�ert^
r �{re,-t -r�'` �, r F i fr-r-r :,_.a_r�: '.� :rf �r �'v-�� � arMdfcrr4nT�rat���
- r !T�
� •t Q _ � L e= f r E r r. �!„�r � Convers.inn ts�e
� r_• =i�..: _ _, �.:�-r= Re.ai�.rtion
��r r, r__� - _, r�p - F•J�
;'6 ��h .i��e 1 •Yf�A�A-��� 'v- '� Crsre�ge�r�t�nF;�ae
a � p�f P.c=_:�lu.ien
� bp Train En�d Users
CV �
r ��
�t'� E=
� y
o,�
�
�
r- • . � • r � • � • r • - • r •
Tyler Technologies Statement of Work
Attachment
Each stage,as established above,is designed to provide a point at which a full review of the stage objedives
is assessed for completeness. When a stage is complete,a Work-Acknowledgement Form(see SOW
Attachment A-(Sample)Work Acknowledgement Form)is completed and signed by the Client signifying
acceptance of that stage and the beginning of the next stage. Each stage is dependent on the results of the
previous stage and therefore,each stage of the methodology cannot begin until the previous stage is
completed and approved.
DATA CONVERSION
The goal of the data conversion process is to transfer information from one or more legacy systems into the
Tyler system in an accurate and verifiable manner. Verification of the data conversion consists of comparing
the on screen data elements and management reports of each system. As such,very little is done in the
conversion process to"fix"the data. Inconsistencies or corruption in the original data wiA carry over to the
new system—these issues should be identified and resolved by the Ciient before final data conversion on the
legacy system(s)or shortly after"going live"on the Tyler system.
Attachment E—Conversion Detail of this document provides detailed information on Oata Conversion if
conversion is included in your Investment Summary.
INVOICING AND CLIENT SIGNOFFS
Tyler invoicing and payment terms are detailed in the Payment Terms section of the Agreement.In addition
to responsibility for the payment of all invoicing outlined in the Agreement, Client is responsible for signing
off on the hours consumed in accordance with project requirements. An approved Change Order is required
if additional hours are needed or scope is changed.
KEY PROjECT ASSUMPTIONS
• Client and Tyler shall review their responsibilities before work begins to ensure that Services can
be satisfactorily completed.
• Client will provide Tyler with access to its equipment,systems,and personnel to the extent
needed to complete the defined Services.
• Ctient wil{provide work space for Tyler Services for work completed on C{ient premises.
• Tyler shall initia{ly implement the most current version of the Tyler software at the time of the contract
signing.During the implementation Tyler will provide newer releases of the software that meet or
exceed the version available at contract signing.After Go-Live,the Client is responsible for installing
newer releases. Release notes are provided for all new versions.
• Client will maintain primary responsibility for the scheduling of Client employees and facilities in
support of project activities.
• Client shall provide Tyler with network access for remote installation and testing through industry
standards such as Virtual Private Network(VPN)or other secure access methods.
• Client will allow users to access the following websites to ensure adequate access to Support resources:
■ heip.ryleru.com
■ tyleru.com
■ tylertech.com
■ tylercommunity.tylertech.com
• Client will provide/purchase/acquire the appropriate hardware,software and infrastructure assets to
support all purchased Tyler software products in both support/testing and production environments.
• Client is responsible for proper site preparation,hardware,software and network
configuration in accordance with Tyler specifications.
• Uient has,or will provide,access licenses and documentation of existing system to any 3`�
party system software which Tyler will be required to read,write or exchange data.
(ver.7/15/13) Page 5
Printed by terry.quinn on 5/2/2014 at 6_23 AM Page 5 of 41
63
Tyler Technologies Statement of Work
Attachment
• Client has,or will provide,a development/testing environment for data conversion and
interface testing as they are developed by Tyler.
• Tyler sfiaN be responsible for implementing a functioning version of the application software(assuming
Client has installed the proper hardware,software,and networking devices).
• Tyler will provide Client with status reports that outline the tasks completed.Tyler will also provide
details rega�ding the upcoming tasks that need to be completed during the coming weeks,the
resources needed(from Client)to complete the tasks,a current or updated version of the project plan,
and a listing of any issues that may be placing the project at risk(e.g.,issues that may delay the project
or jeopardize one or more of the production dates)as needed.
OUT OF SCOPE
• Tyle�software is sold as COTS(commercial off the shelf)software. Any custom development such as;
changes to source code,additional interface development,legacy or other imports are not within the
scope of this agreement:
Custom Programming-Tyler products will be implemented"off the shelY'without
customization,except as purchased and then detailed in Attachment F-Customizations. Any
additional customizations identified or requested wiil be quoted as requested.Unless otherwise
agreed,these customizations will be designed,deve{oped,implemented,and tested during the
Final Implementation phase("post go live"). If there are no customizations in the Agreement,
there will not be an Attachment F to this document.
Custom Modifications-Custam modifications are changes to the functionality of existing Tyler
software products. These changes may involve the addition of new�elds to a screen,the
enhancement or automation of a process,or the creation of a new module.Software
modifications are not within the scope of this agreement except as detailed in Attachment F-
Customizations. If there are no customizations to the software,there will be no Attachment F to
this document.
Tyler wiil make every effort to design custom modifications so that they can be leveraged by
more than just one Client. This focus will affect the approach to designing,developing,and
deploying new functionality so that we may benefit the largest population of users possible.
Custom interFaces—Custom interfaces involve the development of a standard,repeatable
process for transferring information into or out of the Tyler software. These interfaces may take
the form of a user-initiated import/export program,an API,or a web service. There are no
custom interfaces included in the scope of the agreement unless detailed in Attachment F-
Customizations.
Custom Reports—Custom Reports involve the development of new reports that are not offered
as part of the standard reporting package and modifications to existing reports. There are no
custum reports included in the scope of the agreement unless detailed in Attachment F-
Customizations.
• Resource hours that extend scope. (Additional hours must be approved through a Change Order.)
• Any undocumented requirements. Undocumented requirements include requirements not specified in
this Statement of Work and associated attachments.
• Post System Acknowledgement Configuration. System Acknowledgement requirements are met at the
completion of End User Training and User Acceptance Testing stage. Any changes requested of the
Tyler implementation team to alter the configuration,post acknowledgement of these milestones,must
be documented through a Change Order and may incu�additional costs. Client may have access to
�ver.7/SSJ13) Page 6
Printed by terry,quinn on S/2/2014 at 6:23 AM Page 6 of 41
64
Tyler Technologies Statement of Work
Attachment
built-in configuration tools,so,when available,is free to reconfigure or create new configuration as
required or desired.If assistance using these tools is required,additional change orders may apply.
RISK/ MITIGATION STRATEGY
Unavailability/Incompatibility of Staff
Risk: Tyler recognizes that individuals assigned to projects may become unavailable due to various
causes. Further,Tyler recognizes that individuals sometimes clash for reasons of incompatibility. Tyler
schedules team membe�s based on ali the projects to which those individuals are assigned. Unavailability
may occur due to unforeseen circumstances such as family matters or the employee's departure from
Tyler employment.Incompatibility creates intolerance in project objectives and tasks and creates
unnecessary delays and can lead to project failure if not corrected.
Mitigation: In the event a Tyter project member is determined to be unavailable,a Tyler manager will
consult with Client on alternatives such as a temporary replacement or substitute of the person. Likewise
a simiiar response is expected from the Client if their team member is unavailable.
Incompatibility is addressed first through attempts to resolve the compatibility issues between
individuals. Failing resolution,team members must be replaced. In the event a Tyler team member is
determined to be incompatible,Tyler will repiace with a new team member and provide time to orient to
the project before assuming their respective responsibilities.
Client Staff unavailability
Risk:Delays in the project timeline wiil occur if appropriate Client staff is unavailable to meet with or
respond to Tyler for timely decisions and or directions.
Mitigation:Client should ensure that staff assigned to this project is given sufficient priority and authority
to work with Tyler while compieting other Client responsibilities in a timely fashion. Decisions must be
made in hours and days,not weeks.
Scope Changes
Risk: Poorly defined projects always take longer than expected or cost more than expected because of
poo�ly defined scope at the beginning of the projed.
Mitigation:Both parties must ensure that the scope of the project is well stated and completely defined
to the best of each party's knowledge. Functional requirements should be reviewed carefully to ensure
completeness. Change Orders are required to document any subsequent impact on schedute and/or
costs.
Activity Focus
Risk: Activity Focus is the risk that minor activities consume time that should othervvise be dedicated to
major activities of the project,with the end result of time and/or costs overrunning budget.This risk is
sometimes associated with efforts that lead to scope changes.Examples include meetings of little
substance or that go longer than they need,or time consumed investigating undocumented fundionality
or other activities not in scope.
Mitigation:Project Managers for both Parties must guard themselves to avoid focus driR by ensuring the
focus is squarely on meeting deadlines,services,and configuration requirements of the implementation
as planned and documented in the planning,assessment and definition stages.
�ver.7/15/13) Page 7
Printed by terry,quinn on 5/2/2014 at 6:23 AM Page 7 of 41
65
Tyler Technofogies Statement of Work
Attachment
Incomplete Legacy, Interface Documentation
Risk: During the project certain third party documentation will be required for such tasks as interface
development and import of(egacy data and others.
Mit�ation:Client should ensure that APIs,specific documentation,or file specifications for interfacing to
other systems is available to Tyler and that legacy data imports are known in advance of need.
Achievable Goals
Risk: The expectations of this project are set too high or a�e not explicit or clear to Client Staff and thus
not communicated to Tyler through Functional Requirements and clearly stated scope.
Mitigation:The parties must ensure,through the Contract and Task Orders,that tfie goals of the project
are explicit,well defined and attainable,and that both parties have"signed ofY'on the requirements.
Technology Age
Risk: This risk is highly dependent on the choice of Tyler products and whether the Client is hosting any of
those products. If the Client will be hosting its own servers,the technology utilized should be robust to
enough to meet the Client's needs for several years into the future.Technology that barely meets
minimum requirements today will be insufficient as the system and its needs grow.
Mitigation:Tyler will assist Client in determining optimal technology and plans to guard against pre-
mature obsolescence.
CRITICAL SUCCESS FACTORS
In order to successfully execute the services described herein,there are several critical success fadors for the
project that must be closely monitored.These factors are critical in setting expectations between the Client
and Tyler,identifying and monitoring project risks,and promoting strong project communication.
• Knowledge Transfer-While Tyler cannot guarantee specific expertise for Client staff as a result of
participating in the project,Tyler shall make reasonable efforts to transfer knowledge to the Client. It
is critica{that Client personnel participate in the analysis,configuration and deployment of the Tyler
software in order to ensure success and to transfer knowiedge across the organization.After
completion of the production phase,the C4ient will be responsib{e for administering the configuration
and introduction of new processes in the Tyler system.
• Dedicated Client Particlpation—Tyler fully understands that Client staff members have daily
�esponsibilities that shall compete with the amount of time that can be dedicated to the Tyler
implementation project. However,it is critical that the Client understands and acknowledges that its
staff must be actively involved throughout the entire duration of the project as defined in the Project
Plan.Tyler shall communicate any insufficient participation of Client and Tyler resources,as well as
the corresponding impact(s�,through Project Status Reports.
• Acknowledgement Process—Acknowledgment must be based on criteria. The objectives and tasks of
each stage of a project provide the basic criteria by which to judge acceptance of a stage is to be
granted. Within each stage additional criteria will be developed by team members on which to judge
future stages. For example, User Acceptance Testing will be based on criteria developed in earlier
stages.
As resources are consumed,Tyler shall provide the Client with a Work Acknowledgement Form(see
Attachment A-(Sample) Work Acknowledgement Form) to formalize receipt. The Work
��.�Ils)ia) Page 8
Printed by terry,quinn on S/2/2014 at 6:23 AM Page 8 oj41
66
7yler Technologies Statement of Work
Attachrtient
Acknowledgment Form is subsequently signed by the appropriate Client stakeholder(s),and faxed or
emaiied to Tyler, Timely and honest acceptance is required to maintain project momentum. Failure
to properly establish acceptance criteria or failure to accept a properly completed stage wilt cause
delays in the project.
In an effort to ensure quality and complete satisfaction with each stage of the project, Tyler's
professional services division has established the foilowing rute: A Signed Work Acknowledgement
Form(see Attachment A)is required upon completion and Client-acknowledgement of the resources
consumed on the project. Stage signoff is aiso required before proceeding to the next stage in the
process.
• Managing Projed Scope-In an effort to implement the project on time and within budget,both Tyler
and Client agree to limit the software and professional services to only those items identified in this
Statement of Work.Expanded scope resuits in additional costs.
Change orders or contract addendums for additional items outside the scope of the defined project
requirements must be submitted in advance and signed by project stakeholders before work can be
accomplished on those items. likewise,reductions of the def+ned scope will also require a Change
Order.
FUTURE AMENDMENTS TO SCOPE
Future changes in the project scope,beyond the capability of a Change O�der,will assume the appropriate
processes outlined in this Statement of Work and in the Agreement,unless future scope changes require a
different or modified process. tf no new Statement of Work is required,then new functionality and payment
requirements are provided for in an amendment to the initial Agreement.
PROjECT MANAGEMENT
Tyler performs ongoing project management services throughout the implementation in order to plan and
monitor execution of the project.Pro}ect Management includes the following tasks:
• Project plan
• Project document management
• Issue iog management and escalation
• Status reporting
• Change order management
• Resource management
• Executive project oversight via Executive Sponsor and Project Review Committee
By mutual agreement some project management tasks are shared between the Tyler Project team and the
Client Project Manager/Stakeholders.
STAFFING
Every reasonable effort is made to maintain a consistent project team from Tyler for the duration of the
project. Should the Client have concerns related to assigned resources,those concerns should be submitted
to the Tyler Project Manager or Tyler Management Staff for review and consideration. Tyler will make
staff+ng decisions based on appropriate skifl set and other soft skills of resources deemed compatible to the
success of the proJect.
�ver.7/15/13� Page 9
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 9 of 41
67
Tyler Technologies Statement of Work
Attachment
PROJECT SCHEDULE
Upon execution of the contract,the parties will subsequently collaborate during the project planning and
initiation stage to determine a start date for senrices to be rendered. Upon initiation of these services,Tyler
shall work with Client to co{laboratively define a baseline or preliminary project schedulejplan. Given the
fact that project schedules a�e working documents that change over the course of the project,Tyler shall
work closely with Client to update,monitor,agree,and communicate any required changes to the project
schedule.
Development Tools
No special development tools are required for the Tyler software. Tyler source code is not accessible(unless
through the requirements of an Escrow Agreement).
The configuration tools are built into the software,and the Client has fuli access. The Tyler implementation
staff will use these same configuration tools to set up the system with the Client. The Client wiil receive
training on the use of these tools.
Third party report writers(i.e.Crystal Reports)—Some clients may choose to use a third party report writer
like Crystal Reports to create/modify their own reports. The Client is responsible for the procurement of a
ticense of this third party report writer. Tyler does not provide training or assistance on the creation of such
reports and recommends this function be reserved for System Administrator or designated staff who have
the skills and necessary access,and who understand the applicat+on databases.
Documentation
Tyler-provided documentation
Over the course of the 5stage implementation fifecycie,the Tyler project team will provide stage-specific
documentation in a range of formats(both editable and non-editable}.Examples include:
• Data Collection docs(MS Excel and/or MS Word)for configuration
• Training Documentation Templates�MS Word and MS PowerPoint)
• Release Notes for Service Packs(PDF)
• Other documentation as required for the specifics of the project.
Client-provided documentation
� A definitive list of Client-provided documentation is not possible until af1 aspects of tfie implementation are
determined,usually in the begin�ing stages of the project. Certainly,Client's assistance in completing the
Tyler-provided forms and requests for configuration information is essential to a successful project. The Tyler
Projed Manager will provide the Client with detail of the documentation necessary for each product to be
successfully implemented. The list below is a sample of the types of documentation that is likely to be
requested.
Documentation originated by the Client includes:
• Applicatio�P�ogramming Interface documents{API's)for any third-party software system to wfiich
the Tyler software will interface and exchange data.
• Legacy system data documentation and data in a format suitable for conversion into the Tyler
System(please see section titled Data Conversion).
• Workflow documentation on the ClienYs current business processes
• Copies of pertinent ordinances or other controlling authorities
��..�/ss/is► Page
10
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 10 of 41
68
Tyler Technologies Statement of Work
Attachment
• Fee Schedules
• Copies of existing forms and other documents presented to the public and expected to be derived
from the Tyler Software.
SOW ATTACHMENTS LISTING
SOW Attachment A-(Sample)Work Acknowledgement Form
This form provides the means for the Client to accept work provided or
provide reason for deniai of a work.
SOW Attachment B-(Sample)Change Order Form
Any change in the project must have a completed and approved Change
Order.
SqW Attachment C-Hardware/Software Requirements
This document provides the recommended hardwareJsoftware
requirements for the Tyler system. Performa�ce using systems which do
not meet these requirements may not have expected performance levels.
SOW Attachment D-Standard Interfaces
This document provides a summary description of the purpose and
functio�of the interface along with field specifications.
SOW Attachment E-Conversion Detail
Provides a description of the conversion process and legacy data
specifications for each application suite.
(ver.7j15/13) Page
11
Prinded by terry.quinn on 5/2/2014 at 6:23 AM Page 11 of 41
69
Tyler Technologies Statement of Work
Altachment
ATTACHMENTS
Attachment A-Work Acknowledgment
Work Acknowledgment
Client:
Date:
VisitJDeliverable:
, � � , .� . -
❑ I am satisfied with the work pe�Formed for this stage,and/or deliverable.
❑ I am NOT satisfied with the work performed for this stage,andJor deliverable.
In an effort to ensure qual'rty and complete satisfaction witfi each phase of the project Tyles Technologys Professional Services
division has established the following rules:
1. Projects will not be allowed to move from one phase to another without a sign off indicating satisfaction with the
work performed. The Tyler Technology project team will immediately stop all other tasks,complete the phase at
hand,and obtain sign off before moving to the next phase.
2. Customer understa�ds that any payment not received within 30 days of invoice will result in work stoppage. All
related project tasks will be stopped untii payment is received.
Print Name:
Signature:
Date:
(Please reYUrn signed copy to the Tyler Technology project team)
���.��u�is1 Page
12
Printed by terry.quinn on 5/2/2014 at 6:23 AM 7 o Page 12 of 41
Tyler Technologies Statement of Work
Attachment
Attachment B- Change Order Form
Change Order Form
Client: Date:
Generated By:
Authorized
By:
Change Overview:
Narrative Descri tion of Chan e:
Impact of Change:
Schedule Delay of milestone&sub-tasks on Tyler Technologies Implementation
Impact: Pro'ect Plan includin :
Task Proposed Date
Chan es
Cost Impact:
Change Detail Credit Debit Total
Revision No.:
No changes may be made to this project wifhout the agreement of the Project Manager(s), and must
be approved by ihe Project Director. Submit endorsed Change Order to[he Ty/er Techno/ogy
Project Manager
Date Comments �►pP�oved
A roved B Si nature
(ver.7J15/13) Page
13
Printed by terry.quinn on S/2/2014 at 6:23 AM Page 13 of 41
71
Attachme�t
•
���'•• t ler
.,...
� 'r,;-�,r c:4,�r�s
Empowering�o�le wiw serrre the pubiit'
_.......__
Incode V . X Sa�.ution
SYSTEM REQUIREMENTS
7yler's software is designed to operate on networks and operating systems that meet
certain requirements.Systems that do not meet the required specifications may not
provide reliable or adequate performance,and Tyler cannot guarantee acceptable
results.
SITE AS5ESSI�NT
Your site's system requirements are contingent upon several factors.Tyler uses a point
system to help determine which specifications and configurations work best for your
site.This document will help Tyler determine which setup is best for you.
For each of the following applications that your site will use,indicate your site's quantity
for each application variable. Each quantity has a pre-determined Point Value in
parentheses,which is used to tabulate your'Total Point Value"below.
CIS #of accounts NA(0)
1-5,000 accounts(4)
5,001-25,000(6)
25,001+(10J
_ ..___.... . .._._...__ . .......... �..... .......... ........P. _y .. ... . ... _ _ _._.... r .�__..... ._......_.. __......_....
Court #of violations er ear NA 0
1-10,000 violations(3J
10,001-60,000(6)
60,001-150,000(11J
150,001+(31J
_ .. . ........... .. . .... . .... ..... .. ...... ... _ _ ....._. ............. . __. .. .. ....
Financials AP #of vendors NA(0)
1-1,000 vendors(1)
1,001-3,000(2J
3,001+(3)
_._.....�. . _ .
_.... _ __..... _ ......__ _....
FA #of assets NA(0)
1-200 assets(1)
201-1,000(2J
1,001+(3)
_....._._..... .. . ._....._ ___. . ...._ .._._... _ _.____ ._.. ..... _ .. .... ..........
GL #of funds NA(OJ
1-25 funds(1J
26-100(2J
101+(3)
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 14 of 41
�2
Attachment
PY #of employees NA(0)
1-100 employees(1)
101-250(2)
251+(3)
_...... . . _ _ ._..... _ ... .._._ _._ _.__ __.._..._. � __ ..
Tax #of parceis NA(0)
1-20,000 parcels(3)
20,001-40,OQ0(6)
40,001+(IOJ
__ ._ ._ ...... . ..._...._ _ . __ . _ . ...... . ........._ ._...�
TCM #of documents processed per year NA(0)
1-12,000 documents(1)
iz,00i—so,000(z�
50,001+(5J
_.. _...... ..._ _. _....___ __.._..
Total Point Value
SERVER SPECIFICATIONS
For the following table,use your Total Point Value from above to determine which
specifications are required fo�your site's business�eeds.
• The single server configuration is denoted as"Single".
• Dual server configurations are broken into Application Server(AS)and Database
Server(DB)requirements.
. .. -. •- •
1-5 6-10 i1-30 31+
Single AS DB AS DB
Xeon Quad � � � � �
Processor Core(GHz)1
Contact Tyler
Memory GB RAM 16 8 16 16 32 for custom
Available Sus l 100 100 100 100 100 specifications.
Dtsk GB GB GB GB GB
Space2�3 Bus 2 500 500 1 500 3
GB GB TB GB TB
11f running in a virtuaf environment,four virtua{cores are needed.
Z Tyler's standard maintenance plan includes an automatic backup of your database
in this disk space.
3 If using TCM,these storage requirements may increase.See page 5 for details.
E55 Users:If you need external access to ESS,a dedicated server is recommended.This
additional server requires the same specifications indicated in the Application Server
(AS)coiumn based on your Total Point Va1ue.
Printed by terry.quinn on S/2/2014 at 6:23 AM 73 Page 15 of41
Attachment
RE QU IREMENT S
Gonfiguration Diagram
�
�, s
'° a .R.
1«0 � y �
O �
3
� �
v
_
� a
a
a
° d ', £ -— a
� 2 m
. � g c
a O ' � d
¢ g � t
N
�'�1 V
Y
�Y
�+
d
2
��
� /���
N c =
w � `
� v
F
c
f �
v
� � �. ��
� � � _
m �� �
i C � "
� � �
•' �
�
v
a
� {� --- �
!�; o �
« 3
m
Y v°
N O
� � d 3 � ,
���� v � „ �
Y �
� d O
� 3
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 16 of 41
74
Attachment
Server Configuratian
. .. _ ''
Dedicated Server
MS Windows Certified Server4
General Server
Removable Media(for backups)
Gigabit Ethernet
Operating System MS Windows 2008 R2 Server(x64)Standard or Enterprise
Database Component MS SQL Server 2008(x64)Standard or Enterprises
Domain w/Active Directory Services
Network Environment internet Information Services(IIS)7
.NET 3.5 Framework
For OS SAS RAID1
Hard Drive Arrays For SQL,Transaction Logs,DB files,and SAS RAIDS or
V.X program files SAS RAID10
4 Nationally recognized brand
S if running a duai server configuration,this is only needed on the database server.
Workstation
. .. -.
Hardware Microsoft Windows Certified PC6
Protessor Pentium Core 2 Duo
Memory 4 GB RAM
Disk Space 10 GB available
Operating System Windows XP Professional or Windows 7 Professional�
Network 100/1000 mbps Ethernet
Network
Environment Workstation is a member of the Domain$
Graphics 128 Dedicated Graphics—Running 1280x10249
6 Nationally recognized brand
'Windows 95/98/ME,XP Home,and Vista Home editions and workgroup or peer-to-
peer networks are not supported.
$Tyler's V.X servers and workstations must authenticate with and be members of a
Microsoft Active Directory network. Workgroup and peer-to-peer networks are not
supported.
9The V.X application windows are not fully visible at resolutions lower than 1280x1024.
Printed 6y terry.quinn on 5/2/2014 at 6:23 AM Page 17 of 41
75
Attachment
Remote Wo�icstation
Tyler requires a remote access solution such as Citrix or Windows Terminal Services for
any workstations accessing the server with a direct connection of less than 100 mbps
full-dupiex. For best results,remote workstations should run Citrix orTerminal Services
over a permanent VPN tunnel.
Peripherals
Cashiering Equipment
. . - _- ..-
Reteipt Printer Epson 6000 or
Epson 950
Cash Drawer Media Plus Automated Cash Drawer
Bartode Scanner lltilities Symbol LS2208
Card Swiper Magtek Mini Swipe Reader
Workstations designated as Cashiering stations require parallel ports for Epson TM-
U950P Receipt Validation Printers. Epson TM-H6000111 Thermal Receipt Printers require
USB ports and can be configured for Ethernet with optional adapters.An approved ETS-
encrypted mag stripe reader is required for card reading.
Cou�t Equipment
. . ..-
Signature Pad Topaz Signature Pad T-L462
Camera Log+tech C310HD WebCam
Printer Compatibility
Many V.X users print forms and reports directly from the application to their printers.
We recommend using laser printers because they offer universal compatibility for all
applications.
.- -.. . � .. .
Any Laser Printer10 � 0 PCL 5 or above
loDot matrix printers are not supported.HP Printers are highly recommended.
Scanner Compatibility
If you are using TCM,TWAtN compatible scanners are required.You can use any TWAIN
compatible scanner;however,if it's not listed in the cha�t below,you may have reduced
functionality.
. ..-
Canon • DR-5010C • DR-X10C
• DR-2510C • DR-7550C
• DR-4010C • DR-6050C
• DR-3010C • DR-9050C
• DR-M160
Printed by terry.quinn on 5/2/2014 at 6:23 AM 76 Page 18 of 41
Attachment
Fujitsu • fi-6110 • fi-6130Z
• fi-6670 • fi-6140Z
• fi-6770 • fi-62302
. fi-6240Z
Graphtex • CS500 Proll
Hewlett Packard • Scanlet 825011
(Hp) • ScanJet 835011
• ScanJet 839011
Panasonic • KV-S2045C11
Xerox • Documate 15211
11 Not fully supported—These scanners have not been tested in our lab.They are in use by one
or more customers and may have issues that have not been reported.
TCM STORAGE RLQUIREI�NT
TCM requires disk space beyond the basic Specifications listed on page 2.The additional
storage requirement is calculated using severaf factors:the number of pages processed
a year,the types of images processed,your site's expected growth rate,and a buffer,
which protects you from unforeseen changes to these factors.
Image storage requirements must be calculated on a client-by-client basis and the
amount of storage required is determined in pre-sales technical discussions.Since TCM
can vary widely,it is good practice to discuss your specific storage needs with Tyler.
To help you calculate your site's storage needs,the following Loss{ess Compression
table illustrates the file size associated each of the 10 di{ferent Image Types.
Lossless Compression
.-
8.5 x 11 TIFF 8&W 200 .OS MB
300 .1 MB
600 .4 MB
Graysca{e 200 100 M8
300 6 M8
600 24 MB
Color 200 12 MB
300 24 MB
600 95 MB
8.5 x 11 PDFlZ B&W (Page) 1.3 MB
12 This PDF estimate is based upon the average-size document generated
directly from a Tyler application.It does not include embedded fonts and is
simply a representative sample.
Estimating Storage Requirements
To estimate your storage needs,use your site's records and the previous table.
For each Image Type shown above that your site will store,identify the following values:
A. Number of pages processed a year'3
B. Respective file size for the Image Type(MB)
Printed 6y terry.quinn on S/2/2014 at 6:23 AM Page 19 of 41
77
Attachment
C. Number of Years of Storage
D. Growth Rate(%as decimal value)
E. Conversions Only:Existing Database Size(MB)
F. AxBxC
G. OxF
H. E+F+G Base Number
131f your site only tracks the number of documents per year,multiply that number
by 5 to get your page-based number for calculating Tyler's storage requirements.
The standard document size for most Tyler applications is 5 pages.
Standard Recommendation
• To replicate data,multiply your Base Number x 2: MB
Backup Recommendation
• To dump the database to disk,multiply your Base Number x 3: Mg
RECO1rII��NDED BACRUP PROCEDURES
Developing a consistent backup strategy is a vital part of any organization's business
continuity plan.A good backup plan ensures that you do not lose the hard work and
time you invested in data entry if a hardware failure or natural disaster occurs.A plan
such as this is easy to develop and usually easy to implement.This section outlines the
steps you should take to properly back up your V.X data.
Rotating Tapes
First,establish a good tape rotation for your backups.Tyler recommends that you use,
at a minimum,the following 6-tape rotation:
M T W Th F1
M T W Th F2
This rotation is sufficient for most customers because it a{lows you to go back a few
business days to find files.However,if you feel you need a little more protection,you
can use a different set of tapes for Mon-Thurs of Week 2,and/or you can keep a Fri 3
and Fri 4 tape so that you have a month's worth of Friday backups.We also recommend
that you periodically(monthly,quarterly,etc.)puN a tape permanently out of rotation to
store off site.
We do NOT recommend the use of differentlal or incremental backups. Performing a
full backup of the entire V.X folder every night will allow you to restore�les without
having to use a series of tapes to perform the restore.This turns a restore process into a
much more manageable and less time-consuming process.
Printed 6y terry.quinn on 5/2/2014 at 6:23 AM Page 20 of 41
78
A�achment
Backin�Up Your SQL Database
For customers who use Microsoft SQL for the V.X database,there are additional backup
requirements for your V.X software.In addition to backing up the\DATA folder(and
others mentioned above),you must also back up your Microsoft SQL databases.For V.X,
the default databases shouid consist of at least Tyler_Configuration,Tyler_QBE,and
Tyler_Financials.
There are a few different methods for backing up your SQL database.
• SQL Backup Function:The Microsoft SQL Server 2008 R2 Management Studio has
built-in backup tooVs that can cause SQL to dump the V.X database to a backup fife in
the SQL defau{t backup folder while the SQL services are running.This location is:
C:\Program Files\Microsoft 5QL Server\MSSQL\Backup\*
*The Microsoft SQL Server
installation path may vary • Third-Party Backup Agent:This method requires that you have some sort of third-
slightly per installation. party backup program(e.g.,Symantec Backup Exec,Brightstor ARC Serve,etc.)which
uses a S4L backup agent.These special backup agents allow the Microsoft SQL
databases to be backed up while they are online.
• Script:You can create a script which stops the Microsoft SQL Server service before a
normal tape backup and restarts it after the tape backup is complete.This allows you
to back up the*.mdf and*.Idf files(the database and transaction log,respectively)in:
C:\Program Files\Microsoft SQL Server\MSSQL\data
directory*
If you choose this route,Tyler can assist you with creating this script at the time of the
V.X software installation.
Other Directories in the V.X Folder
ForV.X,you need to backup C:\Program Files\Tyler Technologies*. As
we add features and functionality to our software,the number and size of the
applications and runtimes needed to run our applications will continue to grow.
Watching for Signs of Failure
Monitor your backup's status every morning.If there is a noticeable problem,such as an
error light blinking on your tape drive,a tape being ejected without your knowledge,or
an error message displaying about your backup,please contact us or your IT staff so that
the problem can be resolved quickly.
Accepting Responsibility
Having good backups of V.X data is your responsibility.However,Tyler Technoiogies
offers additional services that can help monitor your local backups,transmit your data
to off-site focations,and even provide access to your V.X software and data over the
Internet in case of disaster or serious equipment faifure at your site.
Disaste�Recorery
In case of system failure due to unforeseen disaster,Tyler recommends that you have a
Business Continuity Plan,which should include a disaster recovery service.Tyler offers a
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 21 of 41
79
Attachment
disaster recovery service for an additional fee.If you haven't already purchased this
plan,contactTechnical Services or Sales at 1-800-646-2633 for more information.
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 22 of 41
SO
Attachment
i
•�`i�� � '��
•��.•
� •�;-�i;�cs���c��.
Empo�verin�people who serve the public'
Utility Billing Conversion Summary
This document is a summary of what is included in the standard conversion for Tyler Technologies Utility Billing Suite.
This is not a complete description;for a complete description, please refer to the Tyler Technologies Utility Billing Data
Conversion Specification document available upon request.
Client Responsibilities
• Data in Tyler's Standard Data Layouts or approved formats
. Provide data definitions
• Provide matching reports
. Provide screen shots
• Review conversion prior to training and go-live
Data Conversion
The Utility Billing conversion has additional options that can be purchased depending on the level of data to be
converted. Each option has a different cost associated with it.
Utility Billing
Standard Conversion Includes:
• Utility Contact information
• Utility Mailing and Billing Addresses
• UtiVity Properties
. Account Master
. Meters
• Transaction History—tncludes current year plus 1 prior year
o If the transaction history is not clean it may not be possib{e to convert. In this case,balances wou{d be
reguired to be provided by you and these would be converted in ptace of the detailed transactions.
• Services Metered—Includes 1 metered services
• Services Non-Metered—Includes up to 2 non-metered services
• Bill Compare ran against one billing cycle
• Standard User Defined Fields
Additional Options:
• Bank Codes and Bank Drafts � Devices
• ACTIVE Deposits • AMP(Average Monthly Payments)
• Device Inspections • Energy Assistance
• Renumbering of Accounts • Sewer Assistance
• Contracts • Winter Average
• Notes � Additional Metered Services(over one)
+ Additional Years of Transactional History(per year) • Additional Non-Metered Services(over two)
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 23 of 41
81
Attachment
Not Converted:
• Deposit History
• Service Orders
• Meter Change Outs
Custom Conversion Services
The following are a few examples of items that are not included in the standard conversion and can be addressed
through custom conversion services:
• Converting records with counts lower than 1000 accounts
• Multiple Bill Compares on multiple cycles. This will require additional"Before"and "Afte�"billing data along
with additional hours.
• Cross referencing beyond Tyler Technologies'defined code tables
• Additional User Defined Fields
• Converting of compound meters
• Additional Contact information for Non-Utility accounts
• Additional Properties for Non-Utility accounts
• Running more than 3 standard conversions
• Data cleaning; including but not limited to name clean-up, parsing names/address and data fixes
• Converting from multiple sources of data
• Tyler Technologies assisting in data extraction from your existing system
• Tyler Technologies defining file layouts if not provided
• Changing configuration after sign-off
Data Extract
The standard conversion includes converting from a single source of data. If data is stored in multiple databases or data
is provided in multiple formats custom conversion services may be required.
If unable to provide the data in Tyler's Standard Data Layouts your data will need to be provided in one of the following
formats:
• Microsoft S4L Server database
• Microsoft Access database
• Delimited ASCII text files(pipe"�"delimited is preferred)
• Excel spreadsheets—with flat data, not grouped like a report
The screen shots and matching reports need to be provided to Tyler Technologies at the same time as the data. To
ensure the reports accurately represent the data,staff should exit the software prior to pulling the data and restrict
processing of any transactions until after the reports have been generated. If the reports don't accurately represent the
data an additional data pull may be required,which could result in a delay in the schedule.
It is important to understand that the conversion will not"rehabilitate"old data. The conversion process does not clean
up or correct problems in old data;data is converted one for one. For example,if the current system allowed
punctuation,the new software will also display data with the exact same punctuation after the conversion. If data
manipulation is desired,please contact your Project Manager to assist in preparing a work order for these services.
Printed by terry.quinn on S/2/2014 at 6:23 AM Page 24 of 41
82
•
��••i� A ���
��r.i
• 'cc:;�n[�(;�?IF�;
Financial Conversion Summary �mpaweringpe�oplewhoservethepubllt
This document is a summary of what is included in the standard conversion for Tyler Technologies Financial Suite.This is
not a complete description;for a complete description,please refer to the Tyler Technologies Financial Data Conversion
Specification document available upon request.
Client Responsibilities
• Data in Tyler's Standard Data Layouts or approved formats
• Provide data definitions
• Provide matching reports
• Provide screen shots
• Review conversion prior to go-live
Data Conversion
Each area of the financial conversion has different options depending on the level of data to be converted. Each option
has a different cost associated with it. Certain options cannot be converted unless other options are pu�chased. Full
dependencies are detailed in the Financial Data Conversion Specification document.
General Ledger
Standard Conversion Includes:
• Fund and account lists
• Summarized history for current fiscal year plus two prior fiscal years
• Budgets and budget adjustments for current fiscal year plus two prior fiscal years
Additional Options:
• Additional summarized history and budgets(additionaf fee per fiscal year)
• Transaction history(fee per fiscal year}
Accounts Payable
Standard Conversion Includes:
• Vendor master information,address,primary contact
• 1099 baiances provided by client for current year
Personnel Management (Payroll and Human Resources}
Standard Conversion Includes:
• Basic employee information—employee master,address, primary contact,standard dates (i.e., hire, birth, leave,
termination),standard phones(i.e.,work, home,cell),direct deposit,position, retirement,deductions and taxes
• Current year leave balances
• Current year detailed employee pay history such as paycheck,earnings,earning distribution,deductions and
taxes OR current year quarterly summarized history
Additional Options:
Printied by terry.quinn on 5/2/2014 at 6:23 AM Page 25 0/41
83
Attachment
• Dependent details,additional contacts, notes,additional dates(e.g.,anniversaries,seniority),additional phones
(e.g.,spouse,fax)
• Dired deposit detailed history
Fixed Assets
Standard Conversion Includes:
• Asset informatio�,improvements
• Accumulated totals, no history
Applications not converted
• Bank Reconciliation
• Purchase Orders
Custom Conversion Services
The following are a few examples of items that are not included in the standard conversion and can be addressed
through custom conversion services:
• Combining/splitting of GL account numbers
• Converting records with counts lower than 50 for Personnel Management,100 for Fixed Assets and 250 for all
other modules
• Cross referencing beyond Tyler Technologies'defined standardized codes
• Running more than 3 standard conversions
• Data cleaning; including but not limited to name clean-up and data fixes
• Converting from multiple sources of data
• Tyler Technologies assisting in data extraction from your existing system
• Tyler Technologies defining file layouts if not provided
• Changing configuration after sign-off
Data Extract
The standard conversion includes converting from a single source of data. If data is stored in multiple databases or data
is provided in multiple formats custom conversion services may be required.
If unable to provide the data in Tyler's Standard Data layouts your data will need to be provided in one of the following
formats:
• Microsoft S4l Server database
• Microsoft Access database
• Delimited ASCII text files(pipe"�"delimited is preferred)
• Excel spreadsheets—with flat data, not grouped like a report
The screen shots and matching reports need to be provided to Tyler Technologies at the same time as the data. To
ensure the reports accurately represent the data,staff should exit the software prior to pulling the data and restrict
processing of any transactions until after the reports have been generated. If the reports don't accurately represent the
data an additional data pull may be required,which could result in a delay in the schedule.
It is important to understand that the conversion will not"rehabilitate"old data. The conversion process does not clean
up or correct problems in old data;data is converted one for one. For example,if the current system allowed
punctuation,the new software will also display data with the exact same punctuation after the conversion. If data
manipulation is desired,please contact your Project Manager to assist in preparing a work order for these services.
Printed by terry.quinn on 5/2/2014 at 6:23 AM Poge 26 of 41
84
Attachrnent
V.X Utility Billing - AMI AMR Interface
Purpose
The AMI/AMR meter interface allows users to define the definitions for meter reading import and export files.
File Definition
The interface allows users to define how to interpret data records from an external fite that can be exported from
the system and or imported from another system.The data in these files+s then used to update meter reading data.
Users can define multiple definitions and save them in the system.
File layout options are:
• File Type Options
o Binary Sequential
■ Delimiter
• (None)
• Comma
• Tab
o Line Sequential
■ Delimiter
• (None)
• Comma
• Tab
o XML File
� No Delimiter
• Record Type Options
o Header
o Section Header
o Detail
o Section Trailer
o Trailer
Data elements available are:
. Field Names—Record Type"Header'
o Account Number
o Beginning Account
o Create Date
o Create Time
o Cycle
o Ending Account
o Filler
o Job Label
o Job Number
o Job Wording
o Line Return
o Meter Count
o Projected Read Date
o Radio Count
o Record Id
1 � Page
Printed by terry.qrdnn on S/2/2014 at 623 AM Page 27 of 41
g5
� Attachme�t
o Record Type
o Route
o Route Count
o Route Segment
• Field Names—Record Type"Section Header"
o Account Number
o Beginning Account
o Create Date
o Create Time
o Cycie
o Ending Account
o Filler
o Job Labe{
o Job Number
o Job Wording
o Line Return
o Meter Count
o Projected Read Date
o Radio Count
o Record Id
o Record Type
o Route
o Route Count
o Route Segment
• Field Names—Record Type"Detail"
0 50ESS
o Account
o Account Number
o Account Service UDD
o Account Status
o Account UDD
o Add.Full
o Add.Number
o Add. Number/Street
o Add.Street
o Add. Unit
o Address Service UDD
o Alert Code
o Badger Serv. Number
o Billing Cycle
o Cannon Meter
o Current Read
o Customer Class
o Cycle
o Datamatic Read Type
o Demand Decimals
o Device Code
o Dialog NJW ID
o Dials
o Expected Consumption
o Filler
2 � Page
Printed by terry.quinn on 5/2/2014 at 6:23AM Page 28 of41
86
Attachment
o High Audit
o High Consumption
o Instruction Code
o Itron Read Type
o Job Label
o Job Number
o Latitude
o Line Return
o Location Code
o Location Description
o Longitude
o tow Audit
o Low Consumption
o Meter Group Code
o Meter Make
o Meter Number
o Meter Read Type
o Meter Sequence
o Meter Serial
o Meter Size
o Meter Status
o Meter Type
o Meter UDD
o MTS Indicator
o Multiplier
o Name
o No Delimiter
o Number Estimated
o Occupant
o Prev. Demand Cons.
o Prev. Demand Read
o Prev. Read
o Prev. Read Date
o Prev. Read Minus X
o Prev. Read Plus X
o Property Acc. Number
o Read Group
o Read Sequence
o Reading Skip
o Record Counter
o RecordlD
o Record Type
o Remote Read 1D
o Remote Read Type
o Route
o Route Segment
o Service Address UDD
o Service Category
o Service Code
o Service Description
o Slot
3 � Page
Printed by terry.quinn on 5/2/2014 at 6:23AM Page 29 of 41
�7
AttachmeM
o Tamper Code
o Touch Meter Number
o TWACS Account Slot
o Walk Sequence
• Field Names—Record Type"Section Trailer'
o Account Number
o Beginning Account
o Create Date
o Create Time
o Cycle
o Ending Account
o Filler
o Job Label
o Job Number
o Job Wording
o Line Return
o Meter Count
o Projected Read Date
o Radio Count
o Record Id
o Record Type
o Route
o Route Count
o Route Segment
• Field Names—Record Type"Section Trailer"
o Account Number
o Beginning Account
o Create Date
o Create Time
o Cyc{e
o Ending Account
o Filler
o Job Label
o Job Number
o Job Wording
o Line Return
o Meter Count
o Projected Read Date
o Radio Count
o Record Id
o Record Type
o Route
o Route Count
o Route Segment
4 � Page
Printed 6y terry.quinn on 5/2/2014 at 6:23 AM Page 30 of 41
8g
Attachment
i
��•'�• t fer
.,. .
. _. . ,
E+mpoweris�plop{t wAo serre the pubiic
V.X General Ledger Journal Entry Import Feature
Purpose
The lourna!Entry Import feature allows journal entries to be created in a V.X GL Journal Entry Process packet from a
file supplied by a third party.
File Definition Examples
The GL Journal Entry Import File Definition describes how to interpret data records from an external file and
translate them to records in the Incode V.X software.
Data elements required in the import�le include:
• GL Account,including the Fund(up to 100 characters)
• Amount(numeric 9(10�.99 format)
• Cash Transaction Number[only required when GL Account is a Cash account�up to 20 characters)]
• Cash Transaction Type[only required when GL Account is a Cash account,(1 character)]
Cash Transaction Types include:
o A=Bank Draft Reversal o L=EFT Reversal
o B= Bank Draft o M=Miscellaneous
o C=Check o N=Interest Reversal
o D=Deposit o P=Deposit Reversal
o E=EFT o R=Service Charge Reversai
o H=Check Reversal o S=Service Charge
o I=Interest
• Note:The file must be a balanced file where total debit amounts equal total credit amounts.
Additional optional data elements available to import include:
• Post Date
• Journal Number(up to 20 characters)
• Journal Description(up to 50 characters)
• Line Item Description(up to 50 characters)
• GL Account Key(up to 50 characters)
• Project Account Key(up to 50 cha�acters)
The import file layout definition accepts the following file formats:
• Fixed Width
• Delim9ted
o Colon
o Comma
o Dash
o Period
o Pipe
Printed 6y terry.quinn on 5/2/2014 at 6:23 AM Page 310/41
89
Attachment
Fixed Width File Example:
a. File Definition defined in V.X�
-� ,;_, . ._ a... . .. _ , . ... _ - - -
'���� �' �"
� Sptie m�d Cbs� f� Save and t�cw 1� Ddrte itdn I � � � � ( :;ii Print Scrcnn I !�
Fixed Wid#h-F6ced Wid1fi Example
c'xnera� �►�s _ __
File Lsyout
codt Fo�a vrdm
Account Map
pescr�ptio� Fzed Width Exempk
Project Msp
File Sped6cations - _ -- - - -— — --- - -
Flk Lqyout �ed Wfdth '
17elknited�+ . - •
+�Records to Skip 1
ImQoRQQtiorts __-- - .__---. _ __ _.__._ _ _.-_ -.-- --
Default Rk Locatian `�,
Joumai Descriptbn fixedl�dtNJoumal Description
une�en+�escNanon
co�roaa,�wna ioo - �4,.
5i�pk Jowr�sl Erkry J
Manwl Aeoount Map
Marwsl Project Map
Summaryikscription --- � . __,_ __.— -- _-------- ___._ _._ . _._ �__
, . . . .
,
� , . .
��° °. - .
Printed by terry.quinn on 5/Z/2014 at 6:23 AM Page 32 of 41
90
Attachment
����� _ _° a' �
y s,+«�ueu f y s.,��.r,an�„, !,K od�mm I« '� � �1 .i;CnntScreen ! +�1
Fboed Width-Fi�oed�dth fxample ��
Genenl � Post Dete �
File Layout �
ReW Nunber Date Wnnat MM,'9D1rriY
Account Msp
P��� ErtircReW Repecisttem i ExASna i
Statt Pozkion 1 lourrol Seperatar
Lenpth 10
�Add'`Ddete i
f�afd FiNd Number }oumaf Sepscatw fnn�e FxW Stan Posrtwn lmpth Dau f ormat
_— ._—_._— — ---------'—'---t
�(���.re+a�... ,� .w._a�m���a+gcs�+'��w,x�xa��;�nrts'.-,Y'���.+�iws;�;+e�f,�.'"r.w�,*..�+a»'!.�-.. en�
�: - '_"..�.._..__...�.�_._.....__..-_.._.._._._._ ..,__� � ___�_.._..�.�___:�==_t
=�rnouM t2 1Z
�c:ouM Num6er �5 1 t
line har Destrip�ior 37 13
Cast Tranec6ar Number 51 �9
Cash Tram�Type 62 1
�,.e..�•2��s.� �J e��..-,.�x ys�,r-::ryc � .�-...; � .-�,. .. . -�-, <,�-_. : ��ar � +� ��"��3� �.`w?�=
�.� �,.���,�...,��_ .'�ta.m, ��i��r �_°a� .F���.�z�"'��� '#w ��+at����;�,� ��
b. Sample Fixed W+dth File�
Post Date Amount Account Description CashTran# CashTranType
10/O1/2012 1100.58- 100-3361.30 description 1
10/O1/2012 5000. 00 100-1102. 00 description 2 DEP0099244 D
10/O1/2012 900.00- 500-3401.30 description 3
10/O1/2012 2587. 00- 100-3310.40 description 4
10/O1/2012 100.00- 100-3380.17 description 5
10/O1/2012 312 .42- 710-3334.00 description 6
Printed by terty.quinn on 5/2/2014 at 6:23 AM Page 33 of 41
91
Attachment
Delimited File Example:
a. File Definition defined in V.X�
•�irtnpo�!�i6m+�tenante °" .�'�:
� SavearudCloze � SavesntlNew 1: tle�tteftan I � '�, �' � f �i PrintStreen {.'i�
Delimited-�limited Example
Geru"'°� Detaiis - - _. _ __ - -- -
file Layout
tode DNimiterJ
Accautrt Map
Deuription Defimitcd Emrr�le
Project iUlap
Fae 5pecifica6ons � - _ _. _ _ __ _.. _ .. ...__. _ __
flk Layout QNimfted �
Delimited By tomma �
�Re�ids to Skip 1
ImPort Opuons -- -- _ — - -- - — -- — - -- -- -- - __ ___
Oe�ult Hk Loutlon �,
lotmal Daviption Deffmited Jownal Descr{p�on
tine8em Desa►ption
Cont�ollirg FuM . 190 � �
Sinpk Jounf�l Enhy J
Manual Account Map
Mar�l Project Msp
Synr+�xy npt►on -- ._. _�_. _ _-—— -
___ -- - __ - — -----
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 34 of 41
92
Attachment
�l�pak. ' . °. [p'�
{d s.ve:na ewsr I y sa4e ae+d niew 't x eeeiec�[cem I�, t � � � ;;;►vrinc Scrcen I �r _
Delimited-Delimited E�mpte
��a� RNd Post Drte `
File leyout �
�idd PMnher i Datc Focrost MIuWO,M'YY
AccounL Map
Project Map Endex Rtld J Reqex Rettem � �� ;
StsR Posftion lourmi 5eparator
ls�qth
���{�f
Field F�eld Number Joumal Separator Endre F�eld &an Posrtiort length Oate Fortnat
.�.M..______ _._. ___ -
...._�.....
� . . r�>•�.,.�>-.a,.���(rrrrt��r���s*�m. , ��;��fi�' .. ._ , , ::� ... �i�rdasi
�___�___'_" " _ ' �_.._.�____�...�._""
�YI'CLOt I �
R�coacnt Numbar ? d
l9ne Ncm D�acAptian 4 �I
Cash 7rensactian N4mber 5 �/
Cash TTensacbon Type & d
.._,_ .. _, .���. .. , , .
� r. �_ , s'� - .s.-..� .�- ,. ...iiTta,...., r� . _ �.� ... � . ..
b. Sample CSV File �
Post Date,Amount,Account,Description,CashTran#,CashTranType
10/O1/2012, -1100.58, 100-3361.30,description 1„
10/O1/2012, 5000. 00,100-1102. 00,description 2,DEP0000244,D
10/O1/2012, -900.00,500-3401.30,description 3„
10/01/2012, -2587.00,100-3310.40,description 4„
10/O1/2012, -100.00,100-3380.17,description 5„
10/O1/2012, -312 .42, 710-3334 . 00,description 6„
Printed by terry.quinn on S/2/2014 at 6:23 AM Page 35 of 41
93
Attachmerrt
GL Journal Entry Process
Import Journal Entries Step>Journal Entry Import Wizard
�'+�,��e'" , � �, -
,lewnd Ea9�r Nnpo�t w�rara
Stl�etapartOMwfEian
Definition Selec6on -- —
1mP�1DNUiillon Fhoe�Wklth � '�
Fqe loatbn C1Fh[ed YYMthtmport witfi Pccoud Mapttt '�+`,
loumai[vHiy Setup - - - - -- —
Jowrol Number JM03986 I Ne�d '!
Dtsaiprion FboM Wldtl�Jourel DlsaiPtlon
Co�O11Nq Wnd lU0 � '+�k,
Posd�g Date 1Q,"O1R012 .
Reversinp Oste �
Summwry Desnip6ion _ _. _ _ _
_ _. _
� < Bect �� Ndd> �� CsnaN �� ►1e1p �
p�a �s.0" � �.li�� ., as.f+,r.¢..,"a�mn.z�.�:�w c4 x�a,:�r.:�t*,.
��� �
����
AIp01t1310►�
_ . _ _._ _.______ —'_._'__—_.
IP��
lme Number 6►or
_ .
__ -- --(
{ ` Bbc ���, .[anGN _�� ►�?. _1
Printed by teiry.quinn on 5/2/2014 at 6:23 AM Page 36 of 41
94
Attachment
journal Entry Review Step
�. - ,,. .�°w � � �...
+d�+�tnt1#�R+�vi�r �ryl�
� Save and Gas� � .;�p Princ Screen 1 ,�!
GLPlCT10840-Journat Endy Import Example
loumat Entry' � Add�` Edit�� Deiete �
Accounts
Distribution Number Description Post Dete Rewenal Date
._._..._. _�_____ . .. ..�,_i
► > . � `� '�s, . '
. . _ �'��� ;.
� : . ,
*Screen captures as of 12/31/13 are subject to change.
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 37 of 41
95
Attachment
V.� Utility Billing Payment Import
Purpose
The Utility Billing Payment Import feature allows payments to be imported into a Payment Process or Cashiering
from a file.
File Definition
The import file definition describes how to interpret data records from an external file and then create payment info
in the V.X Utility Billing system. Users can c�eate multiple different file import layout definitions and save them in
the system.
Data elements available are:
� Account
o Required
o This would be the utility account number the payment shauld be processed against.
• User Defined
o Optional
o In this section users would be able to choose from the list of User Defined fields that have been
created against the Utility Billing account.
• Payment Amount
o Required
o This would be the payment amount that will be processed against the Utility Billing account.
• Reference
o Optiona)
o This is a reference value ihat will be assigned to the payment transaction's reference field.
File tayout options are:
• Fixed Width
o User are able to define the starting position and length for each field
• Delimited
o Comma
o Tab
Fixed Width File Example:
a. The example below shows a fixed width file containing the Account Number,Amoant,and Reference field.
ACCOUNT NUMBER AMOUNT REFERENCE
001-00015-000 100.00 CHK#10002
500-01411-001 591.32
099-02225-030 1245.25 CC54545459
Delimited File Example:
a. The example below shows a comma delimited file containing the Account Number,User Defined field,
Amount,and Reference field.
1 � Page
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 38 of 41
96
Attachment
ACCOUNT NUMBER,USER DEFINED,AMOUNT,REFERENCE
001-00015-000„ 100.00,CHK#10002
500-01411-001„ 591.32,EDG5G854F5
099-02225-030„ 1245.25,
2 � Page
Printed by terry.quinn on 5/2/2014 at 6:23 AM Page 39 of 41
97
Attachment
V.X Cashiering Cash Collections Receipt Import
Furpose
The Cashiering Import Miscellaneous Receipts feature imports miscellaneous GLB type payments into a completed
batch in the Cashiering Operator Process from a file.
File Definition
The import file definition describes how to interpret data records from an external file and then create receipt info
into a compieted batch in the V.X Cashiering Operator Process. Each line in the file will create a unique and separate
receipt.
Data elements available are:
• Journal Fund
o Optional
o This field designates the General Ledger Fund to which the import file will post;per line item in the
file.
• Journal Account
o Optional
o This field designates the account associated with the miscellaneous receipt;per line item in the file.
• Payment Method
o Optional
o This field designates that the payment method is described in the import file; per line item in the
file.
• Payment Amount
o Required
o This field designates the payment amount per receipt.
• Customer Name
o Optional
o This will be the name associated with the receipt.
• Pay Reference
o This field designates the user specified reference per receipt.
Note:
Although many of the fields are optional it is advised to enter more info to help with identifying receipts later.
File layout options are:
• Fixed Width
o llser are able to define the starting position and length for each field
• Delimited
o Comma
o Tab
o Pipe
Delimited File Exomple:
1 � Page
Printed by terry.quinn on 5/2/2014 at 623 AM Page 40 of 41
98
Attachment
The example below shows a comma delimited file containing the Fund Code,Account Code, Payment Method,
Amount,Customer Name and Reference.
_ d Code,Account Code,Payment Methad,Amount,Cuatomer Neme,Relerenae
� 100,4550.00,CA,-361.7,Hob Gilmore,0
: 100,1002.00,CK,-200,Joe 3mith,1234
_ 100,1002.00,CC,-250,Jenn Kidd,O
_ 100,1002.00,MO,-100,Jenn Kidd,123456
F lOD,1002.00,OT,-50,0?,0
2 � Page
Printed by terry.qninn on S/2/2014 at 6:23 AM Page 41 of 41
99
� AGENDA ITEM
� CITY COUNCIL MEETING OF MAY 27, 2014
CfiY OF
FRIDLEY
1NFORMAL STAlUS REPORTS
100