HomeMy WebLinkAboutAgenda_GGAF_07.27.2016Notice of Meeting for the
General Gov ernment and Finance Adv isory Board
of the City of Georgetown
July 27, 2016 at 4:30 PM
at Georgetown Communications and Technology Conference Room, located at 510 West
9th Street, Georgetown, TX
The City o f G eo rgeto wn is committed to comp lianc e with the Americans with Dis abilities Ac t (ADA). If yo u
req uire as s is tanc e in participating at a p ublic meeting d ue to a disability, as d efined und er the ADA, reas onab le
as s is tance, ad ap tatio ns , or acc o mmo d ations will b e provid ed up o n req uest. P leas e c o ntact the City Sec retary's
Office, at leas t three (3) days prior to the sc hed uled meeting d ate, at (512) 930-3652 o r City Hall at 113 Eas t 8th
Street fo r add itional info rmation; TTY us ers ro ute through Relay Texas at 711.
Legislativ e Regular Agenda
A Review draft minutes fro m the June 29, 2016 General Go vernment and Financ e Advis o ry Bo ard Meeting -
Danella Ellio tt, Executive Assistant
B Co nsideration and possible ap p ro val o f an ap p ro p riation of $59,860.00 to SunGard Pub lic Sec tor,
Incorporated to convert the p revious Polic e Dep artment Rec o rd s Management datab as e into the exis ting
SunGard O SS I R ecords Management databas e. – Chris Bryce, Director, Informatio n Tec hno lo gy; Jes s
Henderson, IT Op erations Manager – Pub lic Safety.
C Overview and d is cus s io n o f the City’s employee leave ac crual polic ies - Tad d P hillips, Directo r, Human
Res o urc es
CERTIFICATE OF POSTING
I, Shelley No wling, C ity S ecretary fo r the C ity of Geo rgeto wn, Texas , d o hereby c ertify that this Notice of
Meeting was p o s ted at City Hall, 113 E. 8th Street, a p lace read ily acc es s ible to the general p ublic at all times ,
on the ______ d ay o f __________________, 2016, at __________, and remained so p o s ted fo r at leas t 72
c o ntinuo us ho urs p receding the sc heduled time o f s aid meeting.
____________________________________
S helley No wling, City Sec retary
Page 1 of 16
City of Georgetown, Texas
Government and Finance Advisory Board
July 27, 2016
SUBJECT:
Review d raft minutes from the June 29, 2016 General Government and Financ e Ad vis ory Board Meeting -
Danella Ellio tt, Exec utive As s is tant
ITEM SUMMARY:
Review d raft minutes from the June 29, 2016 GGAF Meeting.
FINANCIAL IMPACT:
N/A
SUBMITTED BY:
Danella Ellio tt, Exec utive As s is tant
ATTACHMENTS:
Description Type
6.29.16 Draft Minutes Backup Material
Page 2 of 16
Minutes
General Government and Finance Advisory Board
City of Georgetown, Texas
Wednesday, June 29, 2016 at 4:30 PM
The General Government and Finance Advisory Board will met on Wednesday, June 29, 2016 at 4:30 PM at the Georgetown
Communications and Technology building (GCAT), located at 510 West 9th Street, Georgetown, Texas.
The City of Georgetown is committed to compliance with the Americans with Disabilities Act (ADA). If you require assistance
in participating at a public meeting due to a disability, as defined under the ADA, reasonable assistance, adaptations, or
accommodations will be provided upon request. Please contact the Board Liaison, at least four (4) days prior to the scheduled
meeting date, at (512) 930-3676 or City Hall at 113 East 8th Street for additional information; TTY users route through Relay
Texas at 711.
Board Members Present City Staff Present
Tommy Gonzalez, District 7 David Morgan, City Manager
James Bralski Laurie Brewer, Assistant City Manager
Thomas Bonham Leigh Wallace, Finance Director
Severine Cushing Michel Sorrell, Controller
Trina Bickford, Purchasing Manager
Board Members Absent Trish Long, Facilities Superintendent
Keith Brainard, Chair Laura Maloy, HR Assistant Director
Eric Johnson, CIP Manager
Others Present Mike Stasny, Technical Services Manager
Susan Firth Chris Bryce, IT Director
Greg Berglund, Asst IT Director
Danella Elliott, Executive Assistant
Kris Jolley, Administrative Assistant
Legislative Regular Agenda
Severine Cushing called the meeting to order at 4:30 p.m.
A Review minutes from the May 25, 2016 General Government and Finance (GGAF) Advisory Board --
Danella Elliott, Executive Assistant
Board did not have any comments regarding the minutes from May 25, 2016.
Motion to approve the minutes by Tommy Gonzalez, second by Thomas Bonham. Approved 4-0 (Keith
Brainard absent)
B Consideration and possible action to approve the contract renewal for licensed electrician services to
Mercury Electric Company for an estimated annual amount of $150,000 – Trish Long, Facilities
Superintendent and Eric Nuner, Assistant Parks and Recreation Director
Trish Long addressed the Board. She explained that this item is to renew the Mercury Electric contract. This
is the last renewal on the original contract from November 2013, and next year they will go out for bids.
Eric Nuner explained that this is a line item in the Electric department ISF and the costs are spread out amongst
other departments. $150,000 is the most that will be paid annually.
Motion to approve Item B by Tommy Gonzalez, second by Thomas Bonham. Approved 4-0 (Keith Brainard
absent)
Page 3 of 16
Minutes
General Government and Finance Advisory Board
City of Georgetown, Texas
Wednesday, June 29, 2016 at 4:30 PM
C Consideration and possible action approving a resolution giving Michel Sorrell, Controller, the approval
to conduct business with various banking institutions and to appoint her as a “Representative of the
Depositor.” Leigh Wallace, Finance Director
Leigh Wallace, Finance Director addressed the Board. She explained that this item was to update the banking
resolution, authorizing Michel Sorrell, Controller to conduct business with various banking institutions, and
appoint her as a “Representative of the Depositor”, and also removes Laurie Brewer, Assistant City Manager.
She explained that any action taken will be in accordance with the City’s Investment Policy. This has been
vetted through Valley View.
Tommy Gonzales asked if there were enough representatives to be able to conduct business, and asked about
the procedures. Leigh replied “yes”, and that it takes at least 2 people to make a transaction.
Motion to approve Item C by Thomas Bonham, second by James Bralski. Approved 4-0 (Keith Brainard absent)
D Consideration and possible action authorizing the City Manager to negotiate and enter a Design-Build
cost plus with Guaranteed Maximum Price contract with G Creek Construction of Austin, Texas for the
Rehabilitation of Grace Heritage Center – Eric Johnson, CIP Manager and Laurie Brewer, Assistant
City Manager
James Bralski recused himself from this item and left the room.
Eric Johnson, CIP Manager addressed the Board. He gave the background and noted that a RFQ was issued on
April 25th and one response was received from G. Creek Construction, partnering with ARCHITEXAS.
ARCHITEXAS performed the original assessment in October of 2015.
Questions and discussion of why only one bidder responded. References were checked on G. Creek
Construction and nothing derogatory or bad came up.
Last renovation was done in 1992 and regular, extensive maintenance was not done following that. This will
not happen again, according to Eric, as it will be maintained and issues addressed as they occur.
Our Historic Planner, Matt Synatschk, is looking into “Market Credits”.
Council appropriated $150,000 from the Council Special Revenue Fund for Phase I repairs of Grace Heritage
Center. There is also $140,000 for Phase II, pending Council adoption of the FY2017 budget.
This item will come back before the GGAF Board with the Guaranteed Maximum Price in the Fall.
Motion to approve Item D (amended to add “the Design Build Fee will be included in the Guaranteed Maximum
Price”) by Thomas Bonham, second by Tommy Gonzalez. Approved 3-0 (Keith Brainard absent and James
Bralski recused)
Page 4 of 16
Minutes
General Government and Finance Advisory Board
City of Georgetown, Texas
Wednesday, June 29, 2016 at 4:30 PM
E Consideration and possible approval of a contract with Environmental Systems Research Institute
(ESRI) to provide geographic information systems software to the City of Georgetown for a total of
$115,111.50 over three years. Greg Berglund, Assistant Director, Information Technology
Greg Berglund, Assistant IT Director addressed the Board. He explained that this is to renew the agreement
with ESRI for GIS mapping software.
Discussion followed. Greg noted that his is used for mapping, website, EAM, future integrations, location
database, Parks & Rec software. This is a 3 year renewal, so we have this lower rate locked in. We would lose
out on a lot of services without it, including the 911 dispatch, and it is upgraded regularly. Mike Stasny added
that we have been using it for about 9 years, and it is top tier and used worldwide by 80-90%, including almost
all municipalities.
Motion to approve Item E by Tommy Gonzalez, second by Thomas Bonham. Approved 4-0 (Keith Brainard
absent)
Public Wishing to Address the Board
On a subject that is posted on this agenda: Please fill out a speaker registration form. Clearly print your name and the letter of
the item on which you wish to speak and present it to the Board Liaison on the dais, preferably prior to the start of the meeting.
You will be called forward to speak when the Board considers that item.
On a subject not posted on the agenda: Persons may add an item to a future Board agenda by contacting the Board Liaison no
later than noon on the Friday prior to the Wednesday meeting, with the subject matter of the topic they would like to address
and their name. The Board Liaison can be reached at 512-930-3676.
- At the time of posting, no persons had signed up to address the Board
Page 5 of 16
Minutes
General Government and Finance Advisory Board
City of Georgetown, Texas
Wednesday, June 29, 2016 at 4:30 PM
Adjournment
Motion to adjourn the meeting at 5:25 p.m. by Tommy Gonzalez second by Thomas Bonham.
__________________________________ ____________
Keith Brainard Date
Board Chair
__________________________________ ____________
Thomas Bonham Date
Board Secretary
__________________________________ ____________
Danella Elliott Date
Board Liaison
Page 6 of 16
City of Georgetown, Texas
Government and Finance Advisory Board
July 27, 2016
SUBJECT:
Cons id eration and p o s s ib le approval of an appropriatio n o f $59,860.00 to S unGard P ublic S ecto r,
Inc o rp o rated to c o nvert the previo us Polic e Department Records Management d atabase into the existing
SunGard OSSI Rec o rd s Management d atabas e. – C hris Bryc e, Direc tor, Info rmation Technology; Jes s
Hend ers o n, IT Operatio ns Manager – Pub lic S afety.
ITEM SUMMARY:
This item is to req uest an appropriation of $59,860.00 for the c onvers ion of eight years of histo rical Polic e
Department rec o rd s , to taling 42 GB of data, fro m the old QED Computer Aid ed Dispatch and Rec o rds
Management S ys tem to the current s ystem operated b y SunGard Public S afety, Inc o rp o rated . The QED
s ystem was used b y the Georgeto wn Polic e Dep artment to rec o rd inc idents that oc curred b etween 2002 –
2010. QED was rep laced b y SunGard in 2010.
At the p res ent, in o rd er to ins ure a complete record retrieval, Offic ers mus t searc h the exis ting SunGard
RMS and then run a s ep arate s earch in the QED d atabase.
The QED d atabase has als o b een o ut o f annual maintenanc e s inc e the implementatio n o f SunGard OSSI in
Octo b er of 2010. This exp o s es the City to a p o tential lo s s of d ata if the hard ware o r software were to fail.
This item was originally approved in Augus t 2015 in the amount of $60,000.00.
This data conversion was no t originally fund ed in the original software migratio n that oc c urred in 2010. As
a result, the P o lic e Department was approved to d o the conversion during the F Y 2016 b udget p ro cess.
FINANCIAL IMPACT:
All items were bud geted d uring the FY 2016 b ud get p ro c es s . Exp enses in the amo unt of $59,680.00 will be
recorded in ac c ount 570-5-0641-52-101 (IT C o ntracts ). T here are no rec urring c o s ts fo r this p ro ject.
SUBMITTED BY:
Chris Bryce, Direc tor, Informatio n Tec hno logy and Jes s Hend ers o n, IT Operatio ns Manager
ATTACHMENTS:
Description Type
SunGard Public Sector Quote for migration Backup Material
Page 7 of 16
Add-On Quote
Quote Prepared By:
4000 OSSI Court
High Point, NC 27265
Phone:336-878-1287 Fax:(407) 304-1272
Email:brian.rennie@sungardps.com
Brian Rennie
Quote Prepared For:
(512) 930-2517
Georgetown, TX 78628
Georgetown Police Department
Patrick Hurley
3500 DB Wood Road
Quote Date Valid Until
11/30/201606/24/2016Q-00021024
Professional Services
Product Name Proj Mgmt Impl Svcs Consulting Development Total Services
SunGard Professional Services
Product Code
59,160.00ONESolution Public Safety & Justice Data
Conversion
59,000.00 160.00 - - OS-PSJ-CV Ext Price:
Totals:$160.00 - - $59,000.00 $59,160.00
Install / Tech & Training Professional Services
Services
Technical Svcs Training Total ServicesProduct Code Product Name Installation
700.00 - InstallationPS-IN - 700.00
Totals: - $700.00 - $700.00
Product & Services
Professional Services:$59,860.00
Subtotal:$59,860.00
Total:$59,860.00
“Notwithstanding anything to the contrary which may be provided in this Add-On Quote, payment terms are as follows:
Project Management, Development and Installation ($59,860.00) payable as follows:
$20,000 on the execution of this Quote;
$20,000 on completion of services;
$19,860 on Acceptance of Services (as defined below).
Acceptance of Services: SunGard Public Sector will invoice Customer upon completion of the Services. Customer will notify SunGard Public Sector in
Comments:
Page 1 of 5SunGard Public SectorPage 8 of 16
writing of its acceptance or non-acceptance of the services within twenty (20) days after receipt of invoice. If customer fails to give written notice within the
specified timeframe, the services will be deemed accepted. Any notice of non-acceptance must be based solely upon non-performance in accordance
with the provisions of the scope of work for the data conversion services.”
SunGard proposes data conversion services to convert data from the legacy QED records system for Georgetown, Texas into the ONESolution RMS
modules listed below:
•Master Names (Persons and associated demographics)
•Incidents (including master vehicles, IBR/UCR property and supplements)
•Arrests
•Evidence
•Attachments
Also included are data conversion services for Discovery and Data Analysis; development of a statement of work to define specific data element mappings
and deliverables; client consultation and advisement; ETL solution design & programming; internal auditing and implementation of the final conversion
results and post go-live support for data conversion.
Long Description:
Data Conversion includes converting legacy data for a single agency only. All source data must be from a single source product/database. The customer
must provide complete copies of the source data as required throughout the conversion project. Typically, 3 extractions of data from the legacy system is
sufficient. Source data must be provided on standard PC readable media (an external hard disk drive, USB flash drive, CD/DVD, etc.) or via electronic
transfer (FTP, SecureFTP, etc.) and in one of the following formats (in order of preference): SQL Database Backup, DBF, Access, Excel or Delimited
ASCII text file including column headers. If the client cannot extract legacy data in one of these formats the services of a third party company may be
required. Costs or services associated with third party data extraction and delivery are specifically excluded. All data conversion services are provided
remotely unless specified otherwise. Legacy data will be converted into corresponding elements in the SunGard database. Where no directly corresponding
element exists in the ONESolution database, legacy data may be stored in “notes” or as an attachment to the original record contingent upon conversion of
attachments having been included in the conversion. SunGard will provide continual guidance to determine the best conversion approach for legacy data
based on client need. Data conversion does not include creation of new data elements in the SunGard product. Data that does not fit within the constraints
of the structure of the SunGard database must be translated, truncated or an alternate conversion approach (such as storing data in notes or as an
attachment) must be identified. SunGard will perform a thorough data analysis of legacy data. The results of the analysis will be used to document the final
scope, including details of data mapping and translation in a separate, mutually agreeable and properly executed scope of work. The scope of work will
become the binding agreement for specific conversion deliverables and final acceptance of converted data. The scope of work must be accepted, signed
and returned by the client before conversion work can begin.
ONESolution data conversions are performed on a modular basis. This means data is not converted “all at once” but instead, module by module with
quality review and feedback between modules. SunGard conversion developers will work with customer provided data experts, documentation or 3rd party
resources as required to understand legacy data structures, relationships and legacy business practices. Customer agrees to provide and coordinate
Page 2 of 5SunGard Public SectorPage 9 of 16
resources for understanding legacy data systems as required for a successful conversion. Client is responsible for translation of legacy codes to
ONESolution values as required. SunGard will provide codes requiring translation. Translation data must be returned before iteration 2 of conversion can
begin and within 7 business days of receipt to maintain the projected timeline. SunGard will design, code, test and deliver conversion results to a dedicated
environment for review by the customer. SunGard cannot make any assumption regarding correctness of customer data. Therefore the Client maintains
responsibility for confirming accuracy of converted data. The client must allocate staff as necessary to thoroughly review converted data and record all
adjustments needed during each iteration. Quality review must be thorough; all issues must be combined into a single list, per module; feedback for
required adjustments must be returned within 5 business days after delivery of the data. If, after 5 days, no feedback has been received SunGard will send
a reminder email to project stakeholders regarding the lack of responsiveness. If there is still no response 5 days after the reminder message has been
sent, the current iteration/module will be closed and the next iteration cycle will start by default. If the client is non-responsive for a period of 60 days
SunGard may close the conversion project and resources assigned for the project may be released. Should this occur, the project must be re-planned and
restarted, which will result in additional costs and a new schedule. This proposal includes a limited number of review and feedback iterations. Up to 3
(three) iterations of upload, review and feedback, per module, are included in the pricing provided. Adjustments will be made between each data upload to
achieve the best result possible. After the third iteration of each module, SunGard will provide a module acceptance form. The Customer must return the
signed module acceptance form for each module prior to delivery of converted data into the final environment. The final (fourth) data upload is for customer
acceptance of the data conversion, as a whole and with converted data in its permanent destination. Should the conversion require more than 3 iterations
for any given module, to correct issues that could have been identified by more thorough customer review or more timely customer feedback the effort for
those iterations will be billed on an hourly basis at the current SunGard rate for data conversion services. On an average basis the effort for additional
conversion iterations is 12 hours per module. The proposal includes final conversion into the respective ONESolution product archive environment(s)
hosted on customer provided equipment unless specifically stated otherwise. Any change to the conversion type/approach (production, archive or hybrid)
must be made as soon as possible and should be considered an irreversible change to the scope of the project due to the varying work approaches.
Conversion of data to any module not listed in this proposal or conversion of data from additional systems is specifically excluded and will require additional
analysis, scope, definition and pricing.
It is understood that minor data manipulation may be needed during conversion to “clean-up” legacy data that may not be suitable for conversion as-is.
Requests for data cleanup must be limited to items of large scale; affect a significant number of records and can be addressed in a systematic manner.
Correction of multiple, one-off, discrete or unusual occurrences of specific mistakes in the legacy data may be considered at an additional cost. Proactive
identification of data anomalies, discussion of business rules and relationships between legacy data elements will support a conversion with the best
possible quality and help maintain the timeline of the conversion.
Ongoing maintenance for conversion issues is not unlimited. Conversion processes include multiple opportunities for identification and correction of
problems during the iterative cycles of review and feedback. In as much, SunGard will provide support for newly reported issues of problems with
conversion for a period of 60 days following acceptance of the converted data for conversion into the final destination or 30 days after initial production use
of the converted data, whichever is later. Any issue reported after the window of support will require additional analysis, a written definition of scope of work
and is subject to additional costs. Requests for conversion support outside this period of time should be initiated through your SunGard account executive.
Master records will be converted based on their use in converted data. Matching conditions vary by data type. If the matching condition is not met, a new
master record will be created otherwise the converted record will be linked to the existing master record, avoiding duplication of master records where
possible.
Conversion pricing is exclusive of professional services costs for setup of the conversion environment; training or AIC assistance with conversion activities;
conversion project management or travel costs/budget for onsite data conversion activities.
Page 3 of 5SunGard Public SectorPage 10 of 16
License, Project Planning, Project Management, Consulting, Technical Services, Conversion, Third Party Product Software and Hardware Fees are due upon execution of
this Quote. Training fees and Travel & Living expenses are due as incurred monthly. Installation is due upon completion. Custom Modifications, System Change Requests
or SOW's for customization, and Third Party Product Implementation Services fees are due 50% on execution of this Quote and 50% due upon invoice, upon completion.
Unless otherwise provided, other Professional Services are due monthly, as such services are delivered. Additional services, if requested, will be invoiced at then-current
rates. Any shipping charges shown are estimated only and actual shipping charges will be due upon invoice, upon delivery.
Annual Subscription Fee(s): Initial annual subscription fees are due 100% on the Execution Date. The initial annual subscription term for any subscription product(s) listed
above shall commence on the Execution Date of this Agreement and extend for a period of one (1) year. Thereafter, the subscription terms shall automatically renew for
successive one (1) year terms, unless either party gives the other party written notice of non-renewal at least sixty (60) days prior to expiration of the then-current term.
The then-current fee will be specified by SunGard Public Sector in an annual invoice to Customer thirty (30) days prior to the expiration of then-current annual period.
SunGard Public Sector Application Annual Support: Customer is committed to the initial term of Maintenance and Support Services for which the support fee is included
in the License fee(s) and begins upon execution of this Quote and extends for a twelve (12) month period. Subsequent terms of support will be for twelve (12) month
periods, commencing at the end of the prior support period. Support fees shown are for the second term of support for which SunGard Public Sector is committed and
which shall be due prior to the start of that term. Fees for subsequent terms of support will be due prior to the start of each term at the then-prevailing rate. Subsequent
terms will renew automatically until such time SunGard Public Sector receives written notice from the Customer thirty (30) days prior to the expiration of the then current
term. Notification of non-renewal is required prior to the start of the renewal term. Customer will be invoiced, and payment is due, upon renewal.
Third Party Product Annual Support Fees: The support fee for the initial annual period is included in the applicable Third Party Product License fees(s) unless otherwise
stated. Subsequent terms invoiced by SunGard Public Sector will renew automatically at then-prevailing rates until such time SunGard Public Sector receives written
notice of non-renewal from the Customer ninety (90) days in advance of the expiration of the then-current term. Notification of non-renewal is required prior to the start of
the renewal term. Customer will be invoiced, and payment is due, upon renewal. As applicable for certain Third Party Products that are invoiced directly by the third party
to Customer, payment terms for any renewal term(s) of support shall be as provided by the third party to Customer.
Payment terms as follows, unless otherwise notated below for Special Payment Terms by Product:
This Quote constitutes an Amendment to the Software License & Services Agreement and the Maintenance Agreement (together, the "Contract and Agreement") by and
between the parties hereto. The product and pricing information detailed above comprises the "Exhibit 1" schedule attached to this Amendment. Except as otherwise
provided herein, all terms and conditions of the Contract and Agreement shall remain in full force and effect.
Any interfaces listed above are interfaces only. Customer shall be responsible for obtaining the applicable software, hardware and system software from the appropriate
third party vendor.
Any software applications listed above which are solely owned by SunGard Public Sector are "Component Systems" under the provisions of the Contract and
Agreement. Before signing this Quote, please contact your Account manager if you are not certain which software applications are owned by SunGard Public Sector.
Any hardware or other third party products and services listed above, including third party software, are "Pay Agency Products" under the provisions of the Contract and
Agreement.
For training and on-site project management sessions which are cancelled at the request of Customer within fourteen (14) days of the scheduled start date, Customer is
responsible for entire price of the training or on-site project management plus incurred expenses.
Additional Terms:
Georgetown Police Department
Page 4 of 5SunGard Public SectorPage 11 of 16
Authorized Signature:Date:Printed Name:
Page 5 of 5 SunGard Public Sector
Page 12 of 16
City of Georgetown, Texas
Government and Finance Advisory Board
July 27, 2016
SUBJECT:
Overview and dis c us s ion of the City’s emplo yee leave acc rual p o licies - Tadd Phillip s , Direc tor, Human
Resources
ITEM SUMMARY:
Overview o f the C ity’s employee leave ac crual p o licies .
FINANCIAL IMPACT:
N/A
SUBMITTED BY:
Tadd Phillip s , Direc to r, Human Res o urc es
ATTACHMENTS:
Description Type
Leave Accrual Pres entation Pres entation
Page 13 of 16
7/21/2016
1
City of Georgetown
Employee Leave Data
Employee Leave Benefits
The table above reflects current leave benefits for City employees.
•All numbers reflect hour increments
•Following the first fiscal year of employment, City of Georgetown employees
are required to take 40 hours of vacation per year.
Accrual Type Annual
Accrual
Max Accrual Max Payout
City of Georgetown Vacation 80 ‐160 240 240
Sick 96 none 0*
Holiday 72 72 0
Personal Holiday 32 32 0
*Police Civil Service Personnel receive a payout of up to 720 sick hours upon separation and Fire Civil
Service Personnel receive a payout of up to 1080 sick hours upon separation. City employees with frozen
sick leave accruals prior to October 1st, 2004 are eligible for payout of up to 480 hours at the rate of pay
they were receiving at that time.
Page 14 of 16
7/21/2016
2
Accrual Type Annual Accrual
COG
Annual Accrual
Comparators
Max Accrual COG Max Accrual
Comparators
Max Payout COG Max Payout
Comparators
Vacation 80 100 200 274 200 232
Sick 96 100 none 944 none 104
Holiday 72 87 72 87 0 0
Personal Holiday 32 10 32 10 00
Total Hours 280 298 304 1315 200 336
4 Year Employee
COG v.Comparator
Average
0
200
400
600
800
1000
1200
1400
Annual Accrual COG Annual Accrual
Comparators
Max Accrual COG Max Accrual Comparators Max Payout COG Max Payout Comparators
4 Year Employee Comparison
Vacation Sick Holiday Personal Holiday Total Hours
4 Year Employee Comparison
Accrual Type Annual Accrual
COG
Annual Accrual
Comparators
Max Accrual COG Max Accrual
Comparators
Max Payout COG Max Payout
Comparators
15 Year Employee COG v.
Comparator Average
Vacation 160 192 240 274 240 247
Sick 96 100 none 944 0 182
Holiday 72 87 72 87 0 0
Personal Holiday 32 10 32 10 0 0
Total Hours 360 390 344 1315 240 429
0
200
400
600
800
1000
1200
1400
Annual Accrual COG Annual Accrual
Comparators
Max Accrual COG Max Accrual Comparators Max Payout COG Max Payout Comparators
15 Year Employee Comparison
Vacation Sick Holiday Personal Holiday Total Hours
15 Year Employee Comparison
Page 15 of 16
7/21/2016
3
Payout Scenarios
Payout Scenario:
18 year Civil Service Police Officer according to current rates($65,915/annually)
•240 hrs. Vacation Payout = $7605.60
•720 hrs. Civil Svc. Sick Payout = $22,816.80
•480 hrs. Frozen Sick (prior to 2005 hrly. rate, $19.83) = $9,518.40
•Total Benefit Leave Payout = $39,940.80
Payout Scenario:
10 year non‐Civil Service full‐time employee making $50k annually
•240 hrs. Vacation Payout = $5,769.60
•Not eligible for Sick Payout or Frozen Sick (prior to 2005)
•Total Benefit Leave Payout = $5,769.60
Accrued Liability
FY2015 Comprehensive Annual Financial Report notes on long‐term liabilities p58
Page 16 of 16