Resolution No. 96302111
RESOLUTION NO. 9630
3 II A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
4 VERNON APPROVING AND AUTHORIZING THE EXECUTION OF A
CONTRACT FOR SOFTWARE DEVELOPMENT BY AND BETWEEN
5 THE CITY OF VERNON AND ANGEL CITY DATA, LLC FOR
PHASE 2 OF THE DATABASE TRACKING SYSTEM FOR THE
6 FIRE DEPARTMENT
7
8 WHEREAS, on June 25, 2007, the City Council of the City of
9 Vernon adopted Resolution No. 9352 approving an agreement with Angel
10 City Data, LLC ("Angel City") for Phase 1 of the development and
11 implementation of a customized database tracking system for the Fire
12 Department that will consolidate its data that is currently in various
13 FileMaker software programs into one comprehensive FileMaker program
14 to increase productivity and efficiency by eliminating separate data
15 entry and maintenance of information and increase reporting
16 capabilities (the "Database Tracking System"); and
17 WHEREAS, the Fire Department is ready to implement Phase 2 of
18 the Database Tracking System with Angel City for an' estimated cost of
19 Forty -Nine Thousand Nine Hundred Sixty -Two Dollars and No Cents
20 ($49,962.00) with a deposit of thirty percent (30o) or $14,850.00 due
21 with the issuance of the Purchase Order; and
22
WHEREAS,
Angel
City is
proposing that the
Database Tracking
23
System be built in
three
phases
with the first phase
being the building
24 of the FileMaker Pro foundation, the second phase being the automation
25 of the system and the third phase taking the system to the web; and
26 WHEREAS, the City and Angel City desire to enter into a
27 software development contract setting forth the terms and conditions of
28 the services to be performed for Phase 2 of the creation, installation,
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
SECTION 5: The City Council of the City of Vernon hereby
authorizes the City Administrator, or his designee, to make whatever
nonsubstantive, administrative and/or text changes, upon advice of
counsel, to the Contract.
SECTION 6: The City Clerk of the City of Vernon shall
certify to the passage of this resolution, and thereupon and
thereafter the same shall be in full force and effect.
APPROVED AND ADOPTED this 2nd day of June, 2008.
AT'T T
M NUELA GIRON, City Clerk
Name: Leonis C. Malburg
Title : Mayor ;`—M - D' ^—Tam ef3
1
- 3 -
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
STATE OF CALIFORNIA )
) ss
COUNTY OF LOS ANGELES )
I, MANUELA GIRON, City Clerk of the City of Vernon, do hereby
certify that the foregoing Resolution, being Resolution No. 9630, was
duly adopted by the City Council of the City of Vernon at a regular
meeting of the City Council duly held on Monday, June 2, 2008, and
thereafter was duly signed by the Mayor or Mayor Pro-Tem of the City of
Vernon.
(SEAL)
MANUELA G RON_, City Clerk
- 4 -
EXHIBIT A
CONTRACT FOR SOFTWARE DEVELOPMENT
This is a contract to develop database and/or web software between Angel City Data, LLC (vendor) and
Vernon Fire Dept (client).
Project Scope
The attached document, Project Estimate VFD003-v2 (estimate) establishes the functional and structural
requirements for designing and building a FileMaker Pro database system (the system) for managing many
facets of client's operation. For a full list of all functions comprised by this system, please refer to the
aforementioned estimate.
Justification
The system will provide the tools necessary for increasing productivity, minimizing redundant data entry,
and presenting data and reporting capabilities that previously required manual assembly. The system will
provide management with tools for verifying accountability and follow through of various staff members.
The system will feature several automated routines that previously required manual execution. The
system design will also provide extensive scalability, allowing the system to grow considerably without
special handling or additional programming. The new system will potentially provide a much higher level
of security than current systems and will provide opportunities for future integration with other client
systems.
Exclusions from Functionality
It Is understood that no printed documentation will accompany the system. Please note that this can be
arranged separately at anytime, subject to hourly charges. Please also note that many verbally discussed
or previously documented items will not be included in this initial phase of development but may be added
at a later time. Migration of existing data is also excluded from this initial phase but can be done by VFD
staff or through vendor (additional charges apply).
Security
The system will provide specific levels of security as detailed in the estimate.
System Platform
The system will be designed primarily for both Windows XP, Vista and Mac OS X Operating system use.
The FileMaker Pro system will work across the client's existing network. Client will provide an approved
environment (computers and network) for running FileMaker Pro software over. Vendor will make
recommendations to the client to achieve the above environment. Please note that system will utilize
FileMaker Pro version 8.5 or higher and therefore requires that all computers be running compatible
operating systems.
The Estimate
Vendor represents that all requirements stated in the Project Estimate are those that the Client has
deemed necessary and complete. Vendor is confident that the estimates provided herein are sound.
Therefore, the total estimated amount of 302.8 hours of work shall not be exceeded without prior written
justification and subsequent written consent by an authorized representative of the Client.
Omissions
It is the Client's responsibility to ensure that all requirements are properly documented and accounted for
in the Project Estimate. Any errors in or omissions from the signed Project Estimate and Contract are the
sole responsibility of the client once the project has begun. Vendor will schedule review calls or meetings
with primary client contacts to update progress of project and approvals for necessary processes to move
forward.
Payment Schedule
30% of the estimated project cost is due and payable upon execution of this agreement and must be
received before the project can begin. An additional 50% of the total will be due at the project midpoint.
Remaining 20% will be due upon successful delivery and acceptance by client. Any items subject to actual
billing ("rough estimate" or "to be determined" or third party software items) will be billed as they occur
during normal billing cycles (1st and 15th of each month).
Changes to scope of work
Client requested changes to the scope of work set forth in the Project Estimate will be handled by written
change orders and are subject to additional charges at $150/hr rate. Each change order will be estimated
and approved by client signature prior to being implemented.
Client Acceptance
Upon installation of the completed work, it is the responsibility of the Client to verify that the work
accurately represents what is stated in the Project Estimate and other related documents. Client will be
asked to, sign a Document of Delivery upon acceptance of the work product. Should there be any issues
or discrepancies, the Client must present them in writing to vendor within 30 business days. Vendor
agrees to resolve any issues in a timely manner.
Client approval of all completed requirements. constitutes compliance by Vendor, entitles Vendor to any
remaining compensation and removes Vendor from any liability for specifications not listed in any
supporting project documentation..
Please note that upon system installation and final payment, vendor will provide client with master
password to software, and full ownership of the software will be transferred to client to do with it as they
see fit. Client will be under no obligation to vendor from that day forward.
Technical Support
Vendor will provide 90 days free technical support on all systems developed or purchased under this
contract. Vendor warrants that the system will function properly and according to specifications stated in
the Project Estimate and related documents for a period of 90 days upon completion date of the project so
long as the database structure, layouts & scripts remain untouched by the Client's employees or agents
(anyone other than Vendor personnel). Any system problems that occur as a result of faulty hardware, 3rd
party software conflicts or any deviations from the conditions specified are not covered under this
warranty.
Example of Work
Vendor reserves the right to include the system/database developed for Client in its portfolio as an
example of work to potential clients and/or professional trade organizations. Vendor will obtain written
client approval of system and database documentation used prior to presenting. Vendor understands the
sensitivity of client information and therefore promises to use only sample (mock) data in the portfolio.
Limits of Liability
Except in the event of gross negligence on the part of the vendor, the vendor shall not be liable towards
the Client for any fault or any direct or indirect damage resulting there from, and the Client shall
indemnify the Vendor and hold it harmless from and against all claims, including all claims under a
warranty, in any of the following cases:
-Modifications made to the System or its components by a person other than the Vendor or a person
reporting to the Vendor;
-Hardware or software modifications or additions made to the computer equipment which affect the proper
operation of the System or its components;
-The introduction of a computer virus into the computer equipment which affects the proper operation of
the System or its components;
-The migration of the System and its components to a different hardware or software environment;
-The loss of business opportunities or income relating to the operation or failure to operate of the System
or its components; and
-Unlawful or unauthorized third party hacking into the computer equipment.
UNLESS OTHERWISE PROVIDED FOR IN THIS AGREEMENT, UNDER NO CIRCUMSTANCES WILL
THE VENDOR (INCLUDING, IF APPLICABLE, ITS SUBSIDIARIES AND PARENT COMPANY, AND ITS
SHAREHOLDERS, DIRECTORS, OFFICERS, EXECUTIVES, EMPLOYEES, ASSOCIATES AND
VENDORS) BE HELD LIABLE TOWARDS THE CLIENT OR ANY THIRD PARTY FOR ANY INDIRECT,
CONSEQUENTIAL, SPECIAL, PUNITIVE OR EXEMPLARY DAMAGES, INCLUDING, WITHOUT
LIMITATION, ANY LOSS OF PROFITS OR OTHER ECONOMIC LOSS (RESULTING FROM A
CONTRACTUAL OR EXTRA -CONTRACTUAL FAULT OR FROM NEGLIGENCE), EVEN IF THE VENDOR
HAS BEEN NOTIFIED OF THE POSSIBILITY OF SUCH DAMAGES. CERTAIN JURISDICTIONS
PROHIBIT THE EXCLUSION OR LIMITATION OF LIABILITY FOR INDIRECT OR CONSEQUENTIAL
DAMAGES, AND IT IS POSSIBLE THAT ONE OR MORE OF THE AFOREMENTIONED EXCLUSIONS
OR LIMITATIONS WILL NOT APPLY. IT IS ALSO POSSIBLE THAT THE CLIENT MAY HAVE OTHER
RIGHTS, WHICH RIGHTS MAY VARY FROM ONE PLACE TO ANOTHER. UNDER NO
CIRCUMSTANCES WILL THE VENDOR'S TOTAL LIABILITY TOWARDS THE CLIENT EXCEED THE
VALUE OF THE SERVICES RENDERED TO THE CLIENT AND PAID FOR BY IT. THE CLIENT
EXPRESSLY RELEASES THE VENDOR FROM ANY LIABILITY EXCEEDING THE SAID LIMIT.
Duration
The terms and pricing of this Requirements Specification and Project Estimate are deemed time -sensitive
and must be executed within 60 days (until 6/3/2007). If this contract is not executed prior to or on this
date, this contract and all the terms within are null and void and related pricing and terms are subject to
change.
Project Estimate Project Estimate VFD003-v2 & above contract:
Agreed to by Vendor: Agreed to by Client:
Sign & Date
David A. Knight
President
Angel City Data LLC
ATTEST:
By:,
Manuela Giron, City Clerk
APPROVED AS TO FORM:
By:
Jeff A. Harrison, City Attorney
Sign & Date
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818)238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
VF0003-v2
Ranking Key:
c" LYJ" e 1 Mandatory (Item needed to tui011 requirement), Optional = Client option, Future - (Possible future item -does not affect the estimate total) ,J/Gl%�i���
Angel City Data System Design Specification
150 E. Olive Ave, Suite 213, Vernon Fire Department
Burbank, CA 91502 Schedule System Phase 2
(818) 238-0172 VFDoo3_V2
Fire Personnel Contact Information
Staff Qualifications / Certifications
Staff Training
Shift Scheduling
PTO Management
Overtime
Shift Trades
Off -Duty (IOD/training /jury duty)
Obligations
Reporting
System is designed to run on FileMaker 9 or higher. and HeMaker Server 9 or higher ONLY. This has already been purchased by
customer,
............. .............
Mandatory 00)
.......................... ...... ...... ........
Req ift, ement EOW.natcd 0-xit (0 IhmIr
Page 2 5.12212008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
VR"3• 2..
210 Default Station/Apparatus Screen
A new screen similar to the current schedule screen which would show the default stations and default apparatus for each staff
member for each of the three platoons. Give the ability for staff to be moved around with the same click to select and click to move
behavior as in the schedule screen. This Interface would allow changes to default stations and apparatus in one central location. This
screen would also allow a scheduler to place a staff member onto IOD or another off -duty situation such as jury duty or training.
Users will not need to track historical changes of default stations and apparatus. Off -duty status will be stored at the staff level, and
will not be stored at the assignment level until the shift is scheduled. When scheduling a shift, the system will check whether the staff
member is off --duty due to IOD/training/jury duty etc., and will schedule the day accordingly.
Ninklnu Element Uesa_iP..r!4 "............._...,
..,...,....K.......................,,.....,......,,.............,..,.................,................
Mandatory Screens Default Station/Apparatus Screen
220 Login Behavior
When logging in, take staff member to their own record.
Mm%', ......................................................................
Mandatory Table Login behavior
Est I-ipi115,i(�P�C�'
........................................................................................... ..lip j, O hrs
Neoiui; emcn Fsr.ir;°,nt ; {. >>i. {4G it , $6,fit?£#,tiiA
0.50
....................... ............................... ..............................
$82.50
230 Reserves Module
Need to be able to track Reserve Personnel. These are 10-12 volunteers. System will be able to put them on the schedule, specify
their station, but leave their apparatus as unassigned. Their rank will be "reserve". They will appear on the printout in the "personnel
on duty (non scheduled)" with reason `reserve". System will need to know the station for each reservist, so we might need to add a
station column to the printout. PTO, training, and qualifications cannot be added to Reservists, and users should be prevented from
doing so if they try.
rt<'ticir'rtk rrre.nC.................1�5cri?=r.n Est l
Mandatory Screens Reserves Module
................................I........................._. 28.00 hrs
....._......_......_............._........_...._.....................---........,.._....._...................._.__......._._......._..._........_....-------............_........._........
L.$(IYfialc";.l C4,S?; ilii=-:,$): M'at(! (t,{.S
240 Window Closing
System will be modified to be sure the close window ' does not cause any unexpected behavior.
a.,........., s
Mandatory Screens Be sure the close window " x" does not cause any problems.
--- —---- ._.--......._........ -
Iz c;.irE>nient. Fstiniatexl €:ost (3 iris): $495.00
('. 6 C',. pp ,.J f� 11 -3
iQtt'1� �.?tIn74�LW� .[' 1 f:i
.. ,- -c !
Page 3 5/22/2008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
VI'DW3•0..
310 Calendar Settings
In Calendar Settings, if end date Is earlier than start date, change end date to match start date. Otherwise leave the end date alone.
Ranku'i Ek;T-i, nE' O cviptlUn,,..,.,..., :sC idours:`Prir:
Mandatory Functional 0.50 tr
..
_............. _..........................._...................._............._......._..................._.............._........:... _..:_.._... ...................................
itf:ciiir� r .nt Estimated Cost (.5 E,rs): $82.50
320 Shift -Off Behavior
When shifting -off, give ability to adjust start and end time creating smaller shifts, and requiring less PTO. System will not need the
same functionality when requesting trades, and when requesting overtime. These revised hours will be viewed on the schedule
screen and the schedule printout, but will. not require any changes to the schedule screen and schedule printout.
When adjusting start and end time after PTO has been allocated, need to adjust PTO as well. The system will bring up a window
showing how the PTO hours were originally allocated, and user will be able to adjust the PTO to match the new hours.
In addition to the Battalion Chief, six staff can shift off at one time - 2 captains, 2 engineers, and up to 4 firefighters. Partials are
allowed, but only pay attention to 6 hour blocks, Battalion Chief or assistant chief can override this'in an emergency. This rule will be
"hard -coded" so if a change is needed, VFD will have to call ACD and request additional work.
Ran i 3 E ELenl iC
c
Mandatory Functional Ability to adjust shift -off hours before allocating PTO 4,0,0 nrs
Mandatory Functional Ability to adjust shift -off hours after allocating PTO 8,00 nrs
Mandatory Functional Shift Off Rule Enforcement 4,00 nrs
........._--.......... I ............... _............__....._.............-......__...................._....................................._.._.........._....................._..._........ _............. ............ ...........,..............................._.._.....I..
'2e.r.:uir;ment Fstimatari Cost (fir i:rs): $Z, O,{50
330 Shift Schedule Screen/Printout
On the shift schedule screen, and the shift schedule printout, system will show exactly who is working and when. Staff doesn't need
the ability to assign more than 1 staff member for each 6 hour shift, but staff does the need the ability to adjust hours for a shift even
if it means backing the start time up into a previous shift. For example Firefighter #1 works 7am-9am and is assigned to the first 6
hour shift of the day. Firefighter #2 works 9am-7pm and is assigned to the second 6 hour shift of the day. The schedule needs to
show that Firefighter #2 started at 9am even though that time is earlier than the start time of his shift, which is 1pm-7pm.
rt'nC. i!.il lit=r',.....,..>t iw ifr;; rir:=
Mandatory Screens Adjustments to shift screen IS() nrs
Mandatory Report Adjustment to shift printout 1,50 nrs
..................................... ...... ............__......... _.....I.... _...........__.......__.................._......................................................_..._.............. .... ............... I ....... . _...... _..._ _.-. _.._........._.........
t2ec{i:irein rit Es[irnated Cost (hes): $495.00
340 Approve OT w/o assigning staff to apparatus
On the shift schedule screen, schedulers need to be able to approve OT without assigning staff to an apparatus. System will show the
staff member on the schedule screen and schedule printout.
Mandatory Functional Approve OT w/o assigning staff to apparatus
.. .. _..._..._ I ....................... ................ ..-..........._...............................................................--._.......................
Est ttv ti ri
..................................................................... 8.00 nrs
._....._.............._ _..... _.............................. _....._......_........... . _
f equire"Tient ESUnate t cf"'st (8 !;r5'i: $1,320.00
Pane 4 5,12212008
Angel City Data
System Design Specification
150 E. Olive Ave, suite 213 Vernon Fire Department
Burbank, CA 91502 Schedule System Phase 2
(818) 238-0172
vrOMs ,z.
350 Schedule Screen Modifications
Schedule screen will be enhanced with colored indicators - green meaning all is scheduled, yellow to mean partially scheduled, and red
for not yet scheduled. These indicators will be next to each position, and also at the top of the screen to represent the entire shift.
Adjust the schedule screen so that Station 3 and Station 4 do not appear to have an empty row at the bottom of their box.
System will open the assignment detail screen directly from the schedule screen. This will allow a scheduler to shift someone off, or
adjust their hours, without having to switch back and forth between the schedule screen and the staff screen.
fktn in i tit it..3l i7c:.........•....................
t st' t ours;3=rice
Mandatory
Screens
Add colored Indicators to schedule screen
16.00 hrs
Mandatory
Screens
Adjust Station 3 and 4
1.00 n
Mandatory
...................................................................................................................
Functional
Schedule Screen to Assignment Detail
................-- - --...__......... ................
2.00 hrs
........_............................. ..................... ....... ....... .............. _.................
Reci -c—tTtent Estimatii-d Cost 0.9 llrsl: 4' ,1s.orl
360 Split Shifts for Battalion Chiefs
System will show split shifts for battalion chief, both on the schedule screen and on the schedule printout.
R<ri ilc(rizl......... Elt.r.erit............... e,:r!F,tivn Fsl' Hc,trciPt k :.
..............................:....................................... ... -
Mandatory Screens Modify Schedule Screen 3.00 his
Mandatory Printouts Modify Schedule Printout 3.00 hrs
..................................................................... _.......................... ........ ...... ................................... _..._.._:..._..........._............__....._......................._..............................................
Esu -tated Cost ft; $990.00
370 Overtime -
OT should be labelled consistently throughout the entire database with no periods, and no lowercase letters.
??!n..fCiqki?jk)f............... De..scup. t„iot.................................................... ..............;... i..
Mandatory e r:
Screens change appearance of OT throughout database - NO CHARGE 0.0IT
`€ttx:;.;irern lit Fstiniaftnd Cost 0 ..•s): $0.00
380 Obligation Module
A new tab will be added to the schedule screen showing staff available for obligation. These are staff that are not on this shift and
have not requested OT, and are not scheduled due to trade, etc. These staff should be sorted in order of obligation based on
obligations hours already performed, last obligation date, and seniority. The sort order Is the same as OT, but tracked separately
(even though when you do work under obligation, you do get paid OT, but do not gain OT hours, only obligation hours) Give ability
to click on these staff, and place him on the schedule (unassigned) or onto an apparatus. System will ask the reason, and ask the
specific hours. User can specify whether this should be counted as OT or as obligation. If a staff member get obligated and put on an
apparatus, the staff member earns obligation hours, but if another staff member volunteers to take someone's obligated shift, he gets
OT hours, not obligation hours. The first staff member's obligation is canceled.
tanka3: LicrnEat .si1€ir^...
_...............f<a li uf'ri
Optional Screens Obligation module L4,Q) hrs
..........................................................................................................................................................................................................................................
�eettttement 1 <atirnated Cos, (24 !+rs',.; $3,960.00
390 Off Duty Partial Shifts
System needs to be able to create partial shifts for Off Duty (IOD, training, jury duty) When a staff member marks an assignment as
off -duty, the system asks if it is a full shift or a partial shift. If it is a partial shift, it breaks the assignment into four 6 hour blocks, and
then asks the user to specify which blocks are being used for the off -duty.
ttFsnkirl ,Efc;r)ent DeL';ri..tin.; Ftr, Price
.° ; ..RA—............................................................ .... tiaurs't ri::._
Mandatory Table Off Duty Partial Shifts 4,00 hrs
........................:................_............. _. _..._........ ........... ... ....... _................................. ........................ ............................ .....,..._................... ....... ....... ........ ....... ............_......._...........
A(--1 lrement E;, Nizit d Cost (4 nrs;: $660.00
Page 5 512212008
Angel City Data
150 E. Olive Ave, Sulte 213
Burbank, CA 91502
(818)238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
vrtw:u-vz
.lwi�tlal IA lBleaa�afewF�ialUr,raFail e[R lSKKOB�.�A3 oar 4GIF,W�ri1
Page 6 5/22/Z008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
vi
• +eMill
410 Changes to Vacation Time Accrual
System will automatically add vacation time into the accounts of all active staff. System will use the following rates for adding this
vacation time:
Staff under 10 years, 12 hours per 2 weeks
Staff under 25 years (but with at least 10 years), 13.85 hours per 2 weeks
Staff with 25 years and more, 14.77 hours per 2 weeks
iLkinn Elerrr.t iJ scrst;ti rtt ti )urs Ptic;n
Mandatory Functional Changes to Vacation Time Accrual 5,00 hrs
........................................................................ _................................_ _...._..............
Estlrnrzt _d t: csst: (6 hr5): $990.00
s � � e � . •s1 /i
Page 7 512ZI2008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
VfiAD3,2
53.0 Bulletin Board
A new module will be added to the system for adding To -Do items for specific days. This modules will contain the following fields:
Note (Text)
Name of staff member who created the note (might be different than the staff member entering it into the computer),
Start time (Time)
End time (Time)
Date of Note (Date)
Notes from the assistant chief cannot be deleted. There would also be a note field from the chief - this Is not connected to a specific
date, but can be seen from any day, and would only require a notes field, no start time or end time.
System will provide a printout to print all notes for a specified date.
System will allow staff to view the bulletin board for the day from the schedule screen.
Staff will be able to create notes from anywhere in the database.
Rtarkino
I*Ee;;nrnt
3.}w r j.,t+o
Mandatory
Table
,.......
Notes Table
Mandatory
Screens
Bulletin Board Screen
Mandatory
Screens
Popup window for adding or editing notes
Mandatory
Functional
Ability to add notes from anywhere In the system,
Mandatory
... ................. .........
Report
............ .............
Printout of all notes for a specified date.
-................................ -... .._.._..................... ....... ....... ...-.._............ ...... ,.............
.............. .
Est Hour�;!Pdve.
2.00 hrs
5.(PJ hrs
2,(K! hrs
2.()(,} hrs
5,00 hrs
1te .0rement is 'Iirrk Wdl ("=)s.t (1.6 €.rs). $2,640.00
:...��¢ , U I.0: # .
,> 0 _ E 4f ? tE11 �d t3St r
.,�a.,s'; -,. .,n�r,s-'.`�: #Sr_->'„e T�3,f ,s 3 arIr,
P',ge 8 5121208
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172
System Design Specification
Vernon Fire (department
Schedule System Phase 2
%1)00.3-V2.
4
610 Training Module
System needs to track training hours for staff in a certain topic. This is separate from qualifications. System will allow a certain
number of hours to be assigned to a staff member or group of staff members. Functionality will be integrated into the Group
Functions. System will track monthly totals and yearly totals. A new Training table will be added including the following fields:
Training Type (Text)
Training Date (Date)
Start Time (Time)
End Time (Time)
Name of Staff Member
System will provide a training report where user can specify a staff member, a rank, or a date range, and can see a report of all
training for that criteria. System will provide a detail view where staff can add, delete, and edit training records, System will also
provide a list view with sortable columns.
.........«.>..............».,.».............».........,.».,..,>,<,.............,..................».....».
.>i'. Ni9kli" J -Yice
Mandatory
Screens
Training Detail Screen
4.t10 hrs
Mandatory
Screens
Training List Screen
4,00 hrs
Mandatory
Table
Training Table
3,00 hrs
Mandatory
Screens
Training Tab on Staff Screen
5,00 hrs
Mandatory
Functional
Ability to add training to one staff member or a group
(>,i)() hrs
Mandatory
Report
Training Report
5,00 hrs
E,t)n ai'e.d Cost (2E hr-l1%
$4r620.00
Fj-- a as € a
• ii
Page. 9 5/2Z/2008
Angel City Data System Design Specification
150 E. olive Ave, suite 213 Vernon Fire Department
Burbank, CA 91502 Schedule System Phase 2
(818) 238-0172 VfYX03•vz.
Page 10 512.2120W
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
VRXQ3-v2
820 Project Management
Calls and email between client and Angel City Data; Q & A; note taking; redesign time; prototyping; emalling screen shots, record
keeping, milestone meetings, etc. Totals = 10% of development time.
N3-*—no"i' El*emet..........IRE�Or...... ....................... .............
I
"n.--...MandatoyProject Mgt 11,80 nrs
............ ........ .............. - ................ ................... ......
Rf-.Yquiremwmt Estimirm:xJ Cost (21.8 hrs): $3,597.00
z
AKRIMM50, — " � , "", 4 � S , " �' 'T J� �"" - " ffi , 'Q -,Z -,'5
:"" '44, "P I -, 1 3
t IRWIN
Page 11 512212008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502 .
(818)238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
vrL` -v7_
830 System Testing
Testing includes populating the database with a realistic amount of data and testing the functionality of all buttons, navigation,
calculations, etc. for both accuracy and performance (speed).
t jement ..».,,.... I .;cxi0t . ................. ..... ....>.............».....>.,:.<.........,.,<...................... --- .................
,>,.. =t Nrn�sr�%i iir,
Mandatory Installation Onsite Installation and Server/workstation configurations 23,00 hrs
Mandatory Testing System testing 2.0,0() hrs
...... ............................. ........................... ........ ._..... _...... _...... _...................-................... .... ._......-,...... .... ..._.............. ....._....... .... ...... _............ ...........
Rc' i�ais. r i<:nt Fsfimated Q: S* tr 3 nrs): $7,095.00
Page 12 5/Z.2/,?008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172
840 Design
Angel City Data will work with VFD to design Phase 2 of the Schedule System.
System Design Specification
Vernon Fire Department
Schedule System Phase 2
V11=3_14
.......... Fk3ncrt.............. ........... -- . ..... ........... ....... .. -- .......... ........
Mandatory Design 20.00 1 h .
.................. I ............. ............ . ............ .......... ............ ... .................. . ..... ............................. ...................... . ........... ............. - ..... - .......... ....................... -
Rq e nt E I I -c.Ldr mc- -4.2rnated Ciost (20 hrs): $3,300.00
Page 13 512212008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
VRA0.3-0.
850 Staff Training
Angel City Data to provide free training equal to 5% of development time. Client also requested an additional 25 hours of training
time.
Ek:rnent Descniption
........... .... . ................ ...... .................... -'- .. ........ ............................
Optional Training 11 hours Onsite training free with system purchase. U.,
. ...... .............. OAX) IT
............
Requireme'at Eqlmat-M Cbst (0 hr-,': $0.00
Grand Total Estimate (302.80 hrs): $49,962.00
Note: There may be options in this spec that are not reflected in this total
Please hand check items for accurate total
page 14 512212008
11A+
9548
- F
tkltt:
5/22108
PO,
Verbal
".
PtojCOL.
Shift Scheduling Database
Phase 2
Vernon Fire Dept
3375 Fruitland Ave.
Vernon, C A 90058
Attn: Andy Guth
Dcsc;rlp?lun Da M1, t End
Development Deposit (30%) for Database Tracking 5/22/08
System VFDO03
Remit To.: Angel City Data, L.L.C.
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172 ph
(818) 238-0173 fx
Tax ID: 20-2919383
(Illy, Rate- Amount
90.00 $165.00 $14,850.00
Invoice Total: $14,850.00
Payments Received:
Balance Due: $14,850.00
4305 Santa Fe Avenue, Vernon, California 90058
Telephone (323) 583-8811
June 9, 2008
Mr. David Knight
Angel City Data, LLC
150 E. Olive Avenue, Suite 213
Burbank, CA 91502
Re: Software Development Contract
Dear Mr. Knight:
Transmitted herewith is a copy of the fully executed agreement, as
referenced above, approved by City Council on June 2, 2008, through
Resolution No. 9630.
If you have any questions regarding this matter, please call Mr. Mark
Whitworth, at (323) 583-8811 ext. 280.
Very my yours,
1/ `4
Nelly Giron
City Clerk
NG:dr
c: Mark Whitworth
Purchasing
Resolution No. 9630
Agreement File No. 08-053
E ,clusivefy Industriaf
CONTRACT FOR SOFTWARE DEVELOPMENT
This is a contract to develop database and/or web software between Angel City Data, LLC (vendor) and
Vernon Fire Dept (client).
Project Scope
The attached document, Project Estimate VFD003-v2 (estimate) establishes the functional and structural
requirements for designing and building a FileMaker Pro database system (the system) for managing many
facets of client's operation. For a full list of all functions comprised by this system, please refer to the
aforementioned estimate.
Justification
The system will provide the tools necessary for increasing productivity, minimizing redundant data entry,
and presenting data and reporting capabilities that previously required manual assembly. The system will
provide management with tools for verifying accountability and follow through of various staff members.
The system will feature several automated routines that previously required manual execution. The
system design will also provide extensive scalability, allowing the system to grow considerably without
special handling or additional programming. The new system will potentially provide a much higher level
of security than current systems and will provide opportunities for future integration with other client
systems.
Exclusions from Functionality
It is understood that no printed documentation will accompany the system. Please note that this can be
arranged separately at anytime, subject to hourly charges. Please also note that many verbally discussed
or previously documented items will not be included in this initial phase of development but may be added
at a later time. Migration of existing data is also excluded from this initial phase but can be done by VFD
staff or through vendor (additional charges apply).
Security
The system will provide specific levels of security as detailed in the estimate.
System Platform
The system will be designed primarily for both Windows XP, Vista and Mac OS X Operating system use.
The FileMaker Pro system will work across the client's existing network. Client will provide an approved
environment (computers and network) for running FileMaker Pro software over. Vendor will make
recommendations to the client to achieve the above environment. Please note that system will utilize
FileMaker Pro version 8.5 or higher and therefore requires that all computers be running compatible
operating systems.
The Estimate
Vendor represents that all requirements stated in the Project Estimate are those that the Client has
deemed necessary and complete. Vendor is confident that the estimates provided herein are sound.
Therefore, the total estimated amount of 302.8 hours of work shall not be exceeded without prior written
justification and subsequent written consent by an authorized representative of the Client.
Omissions
It is the Client's responsibility to ensure that all requirements are properly documented and accounted for
in the Project Estimate. Any errors in or omissions from the signed Project Estimate and Contract are the
sole responsibility of the client once the project has begun. Vendor will schedule review calls or meetings
with primary client contacts to update progress of project and approvals for necessary processes to move
fo rwa rd .
Payment Schedule
30% of the estimated project cost is due and payable upon execution of this agreement and must be
received before the project can begin. An additional 50% of the total will be due at the project midpoint.
Remaining 20% will be due upon successful delivery and acceptance by client. Any items subject to actual
billing ("rough estimate" or "to be determined" or third party software items) will be billed 'as they occur
during normal billing cycles (1st and 15th of each month).
Changes to scope of work
Client requested changes to the scope of work set forth in the Project Estimate will be handled by written
change orders and are subject to additional charges at $150/hr rate. Each change order will be estimated
and approved by client signature prior to being implemented.
Client Acceptance
Upon installation of the completed work, it is the responsibility of the Client to verify that the work
accurately represents what is stated in the Project Estimate and other related documents. Client will be
asked to sign a Document of Delivery upon acceptance of the work product. Should there be any issues
or discrepancies, the Client must present them in writing to vendor within 30 business days. Vendor
agrees to resolve any issues in a timely manner.
Client approval of all completed requirements constitutes compliance by Vendor, entitles Vendor to any
remaining compensation and removes Vendor from any liability for specifications not listed in any
supporting project documentation.
Please note that upon system installation and final payment, vendor will provide client with master
password to software, and full ownership of the software will be transferred to client to do with it as they
see fit. Client will be under no obligation to vendor from that day forward.
Technical Support
Vendor will provide 90 days free technical support on all systems developed or purchased under this
contract. Vendor warrants that the system will function properly and according to specifications stated in
the Project Estimate and related documents for a period of 90 days upon completion date of the project so
long as the database structure, layouts & scripts remain untouched by the Client's employees or agents
(anyone other than Vendor personnel). Any system problems that occur as a result of faulty hardware, 3rd
party software conflicts or any deviations from the conditions specified are not covered under this
warranty.
Example of Work
Vendor reserves the right to include the system/database developed for Client in its portfolio as an
example of work to potential clients and/or professional trade organizations. Vendor will obtain written
client approval of system and database documentation used prior to presenting. Vendor understands the
sensitivity of client information and therefore promises to use only sample (mock) data in the portfolio.
Limits of Liability
Except in the event of gross negligence on the part of the vendor, the vendor shall not be liable towards
the Client for any fault or any direct or indirect damage resulting there from, and the Client shall
indemnify the Vendor and hold it harmless from and against all claims, including all claims under a
warranty, in any of the following cases:
-Modifications made to the System or its components by a person other than the Vendor or a person
reporting to the Vendor;
-Hardware or software modifications or additions made to the computer equipment which affect the proper
operation of the System or its components;
-The introduction of a computer virus into the computer equipment which affects the proper operation of
the System or its components;
-The migration of the System and its components to a different hardware or software environment;
-The loss of business opportunities or income relating to the operation or failure to operate of the System
or its components; and
-Unlawful or unauthorized third party hacking into the computer equipment.
UNLESS OTHERWISE PROVIDED FOR IN THIS AGREEMENT, UNDER NO CIRCUMSTANCES WILL
THE VENDOR (INCLUDING, IF APPLICABLE, ITS SUBSIDIARIES AND PARENT COMPANY, AND ITS
SHAREHOLDERS, DIRECTORS, OFFICERS, EXECUTIVES, EMPLOYEES, ASSOCIATES AND
VENDORS) BE HELD LIABLE TOWARDS THE CLIENT OR ANY THIRD PARTY FOR ANY INDIRECT,
CONSEQUENTIAL, SPECIAL, PUNITIVE OR EXEMPLARY DAMAGES, INCLUDING, WITHOUT
LIMITATION, ANY LOSS OF PROFITS OR OTHER ECONOMIC LOSS (RESULTING FROM A
CONTRACTUAL OR EXTRA -CONTRACTUAL FAULT OR FROM NEGLIGENCE), EVEN IF THE VENDOR
HAS BEEN NOTIFIED OF THE POSSIBILITY OF SUCH DAMAGES. CERTAIN JURISDICTIONS
PROHIBIT THE EXCLUSION OR LIMITATION OF LIABILITY FOR INDIRECT OR CONSEQUENTIAL
DAMAGES, AND IT IS POSSIBLE THAT ONE OR MORE OF THE AFOREMENTIONED EXCLUSIONS
OR LIMITATIONS WILL NOT APPLY. IT IS ALSO POSSIBLE THAT THE CLIENT MAY HAVE OTHER
RIGHTS, WHICH RIGHTS MAY VARY FROM ONE PLACE TO ANOTHER. UNDER NO
CIRCUMSTANCES WILL THE VENDOR'S TOTAL LIABILITY TOWARDS THE CLIENT EXCEED THE
VALUE OF THE SERVICES RENDERED TO THE CLIENT AND PAID FOR BY IT. THE CLIENT
EXPRESSLY RELEASES THE VENDOR FROM ANY LIABILITY EXCEEDING THE SAID LIMIT.
Duration
The terms and pricing of this Requirements Specification and Project Estimate are deemed time -sensitive
and must be executed within 60 days (until 6/3/2007). If this contract is not executed prior to or on this
date, this contract and all the terms within are null and void and related pricing and terms are subject to
change.
Project Estimate Project Estimate VFD003-v2 & above contract:
Agreed to by Vendor:
Sign & Date V - V
David A. Knight
President
Angel City Data LLC
ATTE S
MANTIELA GIRON, City C erk
Agreed to by Client:
Sign & Date
Leonis C. Malburg
Name Printed
Mayor Title
APPROVED TO FORM:
J A. WRISON, City Attorney
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 23e-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
VFD003-0
Ranking Rey:
Page 1 Mandatory (Item needed m NIMI requirement), Optlonai = alern option, Future = (PossUe futwe igmdoes not affect the estimate homl) 5/22/2008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
WNW-v2
I IN
100 Overview
This Database System is being designed to significantly Improve the tracking of
Fire Personnel Contact Information
Staff Qualifications / Certifications
Staff Training
Shift Scheduling
PTO Management
Overtime
Shift Trades
Off -Duty (IOD/training/jury duty)
Obligations
Reporting
System is designed to run on FileMaker 9 or higher. and FlleMaker Server 9 or higher ONLY. This has already been purchased by
customer.
FLankina E fl"E?e1?t................. e cx pricr-.........,,........................... -.................. ,,,,..,.....,.<...,............ .. E !: hou�sil�rice
Mandatory
:,.
0.0E) T'
ReqlufrMent ESH-Matrti Gos ,'O ilrs)- $0.00
Page 2 512217008
Angel City Data
System Design Specification
150 E. Olive Ave, Suite 213 Vernon Fire Department
Burbank, CA 91502 Schedule System Phase 2
(818) 238.0172
:JF1EHr-r11MnV
210 Default Station/Apparatus Screen
A new screen similar to the current schedule screen which would show the default stations and default apparatus for each staff
member for each of the three platoons. Give the ability for staff to be moved around with the same click to select and click to move
behavior as in the schedule screen. This Interface would allow changes to default stations and apparatus in one central location. This
screen would also allow a scheduler to place a staff member onto IOD or another off -duty situation such as jury duty or training.
Users will not need to track historical changes of default stations and apparatus. Off -duty status will be stored at the staff level, and
will not be stored at the assignment level until the shift is scheduled. When scheduling a shift, the system will check whether the staff
member is off -duty due to IOD/training/jury duty etc., and will schedule the day accordingly.
rtankiro i iei ...... DCSCYiA ............ . . Est iyJI1i5/1jP'FA
;.n.............. ............,........ ce
Mandatory Screens Default Station/Apparatus Screen 40,00 hrs
...............................
Requirem a t F";timate-d U)st 00 :erg); $6,600.00
220 Login Behavior
When logging in, take staff member to their own record.
k r�lnna Element ............ . 3 sd•iotig ...,........................»,,..................................................., ...... „ C<a i ; sir r i
_....r c
Mandatory Table Login behavior 050 tr
...........................................................................:............................................... ...................... ................................................. .................................. ................
.,.,......
lIc-quite nent l stlnusted Cost (.Sir<,:•): $82.5D
230 Reserves Module
Need to be able to track Reserve Personnel. These are 10-12 volunteers. System will be able to put them on the schedule, specify
their station, but leave their apparatus as unassigned. Their rank will be "reserve". They will appear on the printout in the "personnel
on duty (non scheduled)" with reason "reserve". System will need to know the station for each reservist, so we might need to add a
station column to the printout. PTO, training, and qualifications cannot be added to Reservists, and users should be prevented from
doing so if they try.
DK-scri Abn tst i s:4rsr'}, ri
................................... ..........,.. ,..:
Mandatory Screens. Reserves Module 28.00 hrs
............... ............ ............................_.............._...._...................._.................................._.........................._......_......... ..................... ...... .---------- .... .............
_..._._
t,.0wt. 2so$4,620.00
240 Window Closing
System will be modified to be sure the close window "x" does not cause any unexpected behavior.
t ;itrirs13 ri -
Mandatory Screens Be sure the close window"x" does not cause any problems. 3,00 hrs
i2equirement Estimated Cn>t (3 hi-s): $495.00
M
:rtnriaCt°`M�1tiotal'Fsllrrtafeel5r
Page 3 512212008
Angel City Data System Design Specification
�:2 4l•`a tili�l"1 �t�tl�.•
5s.6BJ i1WY
310 Calendar Settings
In Calendar Settings, If end date Is earlier than start date, change end date to match start date. Otherwise leave the end date alone
fi Rqk ^y Ek n=_ni' D " ,tic?" 1 sl'. Nours'f ric
_.. .............
.............................__....,..........................,...............
Mandatory Functional 0.50 tr
_................... _... _.............
.._............
RO,ulrement Estlmat A Cost (. !,r* $ti 2.50
320 Shift -Off Behavior
When shifting -off, give ability to adjust start and end time creating smaller shifts, and requiring less PTO. System will not need the
same functionality when requesting trades, and when requesting overtime. These revised hours will be viewed on the schedule
screen and the schedule printout, but will not require any changes to the schedule screen and schedule printout.
When adjusting start and end time after PTO has been allocated, need to adjust PTO as well. The system will bring up a window
showing how the PTO hours were originally allocated, and user will be able to adjust the PTO to match the new hours.
In addition to the Battalion Chief, six staff can shift off at one time - 2 captains, 2 engineers, and up to 4 firefighters. Partials are
allowed, but only pay attention to 6 hour blocks. Battalion Chief or assistant chief can override this'in an emergency. This rule will be
"hard -coded" so if a change is needed, VFD will have to call ACD and request additional work,
Rankh3cl Elcmeju i7ftiril:j.U5 r< Est } #tar5;f ric1
Mandatory Functional Ability to adjust shift-4hroff hours before allocating PTO ) t
s
Mandatory Functional Ability to adjust shift -off hours after allocating PTO 8.00 hrs
Mandatory Functional Shift Off Rule Enforcement hrs........................ ............. ............. .................. ._.......... _.............. .............. .._... ....................... ............ ................ .... _..._.._.......
' enut!ement EsurnatLtJ Cost ;16 hr,?: 2,Ga0.ii0
330 Shift Schedule Screen/Printout
On the shift schedule screen, and the shift schedule printout, system will show exactly who is working and when. Staff doesn't need
the ability to assign more than 1 staff member for each 6 hour shift, but staff does the need the ability to adjust hours for a shift even
if it means backing the start time up into a previous shift. For example Firefighter #1 works 7am-9am and is assigned to the first 6
hour shift of the day. Firefighter #2 works 9am-7pm and is assigned to the second 6 hour shift of the day. The schedule needs to
show that Firefighter #2 started at 9am even though that time is earlier than the start time of his shift, which is Ipm-7pm.
R kli inc......... EE.:S r :J i7 e:r 3t'iix Fs't' 'rif umii rk
, da
......:..........
Mandatory Screens Adjustments to shift screen 1.5n hrs
Mandatory Report Adjustment to shift printout _...._......_............_................................................. _.............. _............ _............._..............................._....._..... 1a0 hrs
_ ......._....._.._ _......_......_........
Requirement Eu nateci Cost (3 hrs.: $495.00
340 Approve OT w/o assigning staff to apparatus
On the shift schedule screen, schedulers need to be able to approve OT without assigning staff to an apparatus. System will show the
staff member on the schedule screen and schedule printout.
Rarikinl........... ......................... ESt. H �i i rir_:
Mandatory Functional Approve OT w/o assigning staff to apparatus �� hrs
_............................_...._.._............._...._............._....., _...._......_
Requirement Estimated Cr,,Kjt 'S I;rs): $1,320.00
Page 4 5,12212008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818)238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
iM1YY.i.0
350 Schedule Screen Modifications
Schedule screen will be enhanced with colored indicators - green meaning all is scheduled, yellow to mean partially scheduled, and red
for not yet scheduled. These indicators will be next to each position, and also at the top of the screen to represent the entire shift.
Adjust the schedule screen so that Station 3 and Station 4 do not appear to have an empty row at the bottom of their box.
System will open the assignment detail screen directly from the schedule screen. This will allow a scheduler to shift someone off, or
adjust their hours, without having to switch back and forth between the schedule screen and the staff screen.
Rtnllcn� 2......... fit iral ............
. Uesrr irtion
Est. Hourslprice
Mandatory
Screens
Add colored Indicators to sch
schedule screen
............................................................................. .......................,:......,...
16.U0 hrs
Mandatory
Screens
AdJust Station 3 and 4
Mandatory
Functional
Schedule Screen to Assignment Detail
100 If
........................ .................... I ....... ..... ..................... _.............2 00 hrs
..... _.... _...-..
ttequlrtment Estimated Cost (11) hrs): $3,135.00
360 Split Shifts for Battalion Chiefs
System will show split shifts for battalion chief, both on the schedule screen and on the schedule printout,
r�<ardcir�i . Elell it DescrIpLiyr: R1, Hoursi pri
................................ .,,..................... ....,.... .. ..................
n story Screens Modify Schedule Screen 3,00 nrs
Mandatory Printouts Modify Schedule Printout ,
.................. ...............__30p nrs
....................._....:.........._...-.............._..........._.............._...-._..............................-...............
R--g0re'nQnt $990.00
370 Overtime
OT should be labelled consistently throughout the entire database with no periods, and no lower case letters.
.................. .:::..............:.................... ..:......:...........
krt .
.....................:........................................'", ...
Mandatory Screens change appearance of OT throughout database - NO CHARGE 6.60 it
..............................
Estimated Cost ((l
380 Obligation Module
A new tab will be added to the schedule screen showing staff available for obligation. These are staff that are not on this shift and
have not requested OT, and are not scheduled due to trade, etc. These staff should be sorted in order of obligation based on
obligations hours already performed, last obligation date, and seniority. The sort order is the same as OT, but tracked separately
(even though when you do work under obligation, you do get paid OT, but do not gain OT hours, only obligation hours) Give ability
to click on these staff, and place him on the schedule (unassigned) or onto an apparatus. System will ask the reason, and ask the
specific hours. User can specify whether this should be counted as OT or as obligation. If a staff member get obligated and put on an
apparatus, the staff member earns obligation hours, but if another staff member volunteers to take someone's obligated shift, he gets
OT hours, not obligation hours. The first staff member's obligation is canceled.
kankkrn E#cr cpt Descr':.oiun
Gt
a..........................................................................,.........,...............
.....,..........................................,...................,,,. .... .,...... .................... .t our Sri
Optional Screens Obli ...ation module
_..................:.......... ...9... ..................... - -.._.. -- 24.011 nrs
-
lequftement Estirnated Qx t (24 Ivs;, $3,960.00
390 Off Duty Partial Shifts
System needs to be,able to create partial shifts for Off Duty (IOD, training, jury duty) When a staff member marks an assignment as
off -duty, the system asks if it is a full shift or a partial shift. If it is a partial shift, it breaks the assignment into four 6 hour blocks, and
then asks the user to specify which blocks are being used for the off -duty.
122r�YiFr 3,.......,.. Elc,rnent t3escriptin_ ............. Ett } four /Ir c2......................................................................
Mandatory Table Off Duty Partial Shifts 9 nrs
_.............................................................................._..............-..............._............................._.......................................... ............_...................... ...
rte<iuirernem E"AUrnated Cost (4 ^ s): $660.00
Page 5 512212008
Angel city Data System Design Specification
150 E. Olive Ave, Sulte 213 Vernon Fire Department
Burbank, CA 91502 Schedule System Phase 2
(S18)238-0172
vR)"-v2
n � nass�s� Rt i v At<lARsl���[f tl S wi R.J>.c >pw rs,
Page 6 51221200B
Angel City Data
150 E. Olive Ave, Sulte 213
Burbank, CA 91502
(818) 238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
WM3-v2
410 Changes to Vacation Time Accrual
System will automatically add vacation time into the accounts of all active staff. System will use the following rates for adding this
vacation time:
Staff under 10 years, 12 hours per 2 weeks
Staff under 25 years (but with at least 10 years), 13.65 hours per 2 weeks
Staff with 25 years and more, 14.77 hours per 2 weeks
Wkln� Flertt€nt _i3nscrl;tiurt
.......«.........................................f.....,........................... .......,.....,.,................. .. Ecfliners; I'i"I(:^
Mandatory Functional Changes to Vacation Time Accrual nrs
................ ...... _......_............................_............._.......................,.........._............................._.. _....................
i%eipirerno.o?: Fntim-i d)t Cost hrsj: $900.00
RI- e 7 512ZI2008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 23MI72
System Design Specification
Vernon Fire Department
Schedule System Phase 2
V-v2.
510 Bulletin Board
A new module will be added to the system for adding To -Do items for specific days. This modules will contain the following fields:
Note (Text)
Name of staff member who created the note (might be different than the staff member entering It Into the computer),
Start time (Time)
End time (Time)
Date of Note (Date)
Notes from the assistant chief cannot be deleted. There would also be a note field from the chief - this is not connected to a specific
date, but can be seen from any day, and would only require a notes field, no start time or end time.
System will provide a printout to print all notes for a specified date.
System will allow staff to view the bulletin board for the day from the schedule screen.
Staff will be able to create notes from anywhere in the database
PtarzKin
K.......................
Eiemr3nt'
fX-rcri .3t7oil ..................................................._......_...,........,.....,...............,
Est tiaurs/Price
Mandatory
Table
NotesTable
..................,.,......,......,,...................,........................,........,.
2,00 hrs
Mandatory
Screens
Bulletin Board Screen
SO nrs
Mandatory
Screens
Popup window for adding or editing notes
2.W hrs
Mandatory
Functional
Ability to add notes from anywhere In the system.
2,00 hrs
Mandatory
.................... .......
Report
...... ..... ..............................
Printout of all notes for a specified date.
................... _.._..._....... ...... ............... __ . _................
5.00 hrs
......... ................... .............._..........___..... .............. ...................... ......._..
Reouir ment FsV'ri,eVn! (1.6 :rs;: $2,640.00
.r. ■ as e a r e":is t!ii
page 8 512212008
Angel City Data
System Design Specification
150 E. olive Ave, Suite 213 Vernon Fire Department
Burbank, CA 81502 Schedule System Phase 2
(818) 238 0172 vM003-v2
U IEW,,
610 Training Module
System needs to track training hours for staff in a certain topic. This is separate from qualifications. System will allow a certain
number of hours to be assigned to a staff member or group of staff members. Functionality will be integrated into the Group
Functions. System will track monthly totals and yearly totals. A new Training table will be added including the following fields:
Training Type (Text)
Training Date (Date)
Start Time (lime)
End Time (Time)
Name of Staff Member
System will provide a training report where user can specify a staff member, a rank, or a date range, and can see a report of all
training for that criteria. System will provide a detail view where staff can add, delete, and edit training records. System will also
provide a list view with sortable columns.
Ik��3:V1�J l=1n{]nt. t19%•..... •. .........»....u>......
�>l lil��r�lf !'r�ila >..a...>....K».......v... •... •.•.»..e. ...a..>.•aa..»... •.>..»>••..r....•......•....•.•..»>...u,..a..->::••.»,•a..»...............•a•....•.a..».•a.»:...o».••a.>»•.......•aa......-..r.•......•....,.......>.....>,....>r
Mandatory
Screens
TrainingDetail Screen
4.W hrs
Mandatory
Screens
Training List Screen
4,00 hrs
Mandatory
Table
Training Table
3.00 hrs
Mandatory
Screens
Training Tab on Staff Scrden
S,W hrs
Mandatory
Functional
Ability to add training to one staff member or a group
f,,pp hTS
Mandatory
Report
........ ..".................
Training Report
..."................_..................... ................. .................... .......... ......_......................................... ........ .............. ........ ..........................
6,00 hrs
............
I cqul`^i':3£Tlt Estinii-Aed- Cbstc (t8 7:•1i:
............. ...
$1,620.00
Page 9 512212008
Angel City Data System Design Specification
150 E. Olive Ave, sulte 213 Vernon Fire Department
Burbank, CA 91502 Schedule System Phase 2
(818) 238-0172 vwYws•W
swam
710 Password Manager
An administrative area will be added so that an administrator can control the accounts and passwords for the entire staff. Staff can
request a password reset, and staff can choose a new password without the administrator knowing the newly selected password.
fLankirra Element . Lhsr_if tseE;» . . F.st i?+ (rice
Mandatory Screens Password Manager 1.6,00 hrs
„ ................. ............................................. ........................... ....................,,_...........
Requi€'C:Silent i=.sinialed Cost (U; h1 m): $2,640.00
_a`. ._ �a Ctlrity 1fr l ,Fstf �tated'Cost:
'age i 0 512212008
Angel City Data System Design Specification
150 E. Olive Ave, suite 213 Vernon Fire Department
Burbank, CA 91502 Schedule System Phase 2
(818) 238-0172 vria M-W.
t?ankirtri ....... Ek r1ent W.. i 5ra ipti r.,,.....>.........<.......................................................>,....,,..,..,,...,.,..,...... «,f ......��s�i?€ fc
..
Mandatory Project Mgt 21.80 nrs
8€.,.qKiren'ient Estini m' Cost (21..8 ilrs): $3,597.00
.A .., .df(9an�aaini�t( C ostJ597.00
Page 11 51221208
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818)238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
VHM ja
830 System Testing
Testing includes populating the database with a realistic amount of data and testing the functionality of all buttons, navigation,
calculations, etc. for both accuracy and performance (speed).
tLnksna........ (ic me nt ........,... lea ,.. ,»..... EfNrnu!Nic��».».......,<..e
Mandatory Installation Onsite Installation and Server/workstation configurations 23.00 hrs
Mandatory Testing System testing 70.00 hrs
?iE°quit nkmt 1=5lin ait.".d € )st (13 hr5): $7,095.00
Page 12 512.212008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818)238-0172
B •. a
840 Design
Angel City Data will work with VFD to design Phase 2 of the Schedule System.
System Design Specification
Vernon Fire Department
Schedule System Phase 2
VR=3••2
......._....l=k�ncnc.. D �trlptior i=<f #a �r,;7ric
_...................................................................._......_............................,........................................._...............................
...........�!zt�,
Mandatory Design hrs
_........._................... ....._._.__.....__..........,._.............._....._.....,........
Require -rent EgnaWd Cu,t (2u ir•s); $3,300.00
R79a 13 51221..2008
Angel City Data
150 E. Olive Ave, Suite 213
Burbank, CA 91502
(818) 238-0172
System Design Specification
Vernon Fire Department
Schedule System Phase 2
vRXM-V2
850 Staff Training
Angel City Data to provide free training equal to 5% of development time. Client also requested an additional 25 hours of training
time.
ftin9<.<..,,....El�;m ,t t)esci'i tvn> <.,,,,.<..».....„ . Estflaiws%?nc7 ,.
»...... ».... »........................I......»»<....,<...»........,...,................»......,.....,....».,...».>....,,.<...,.....,........,......».....,,...„,. , .r...:...;::
Optional Training it hours Onsite trainin free with stem purchase. 0.00 h..................... ........................................................................................._p........................,................_............................................_..................................._....._......_...
Requironomt Estiroat,cl (bst r0 hrs). $0.00
Grand Total Estimate (302.80 hrs): $49,962.00
Note: There may be options in this spec that are not reflected in this total
Please hand check items for accurate total
Page 14 5/22/2008
-=
Ina.:
9548
F,
Date:
5/22/08
PO-
Verbal
Project:
Shift Scheduling Database
4%!� {
Phase 2
) _ s ..:
Vernon Fire Dept
Remit To: Angel City Data, L.L.C.
3375 Fruitland Ave.
150 E. Olive Ave, Suite 213
Vernon, CA 90058
Burbank, CA 91502
Attn: Andy Guth
(818) 238-0172 ph
(818) 238-0173 fx
Tax ID: 20-2919383
Nascription Dam. Kart
FAI City. mate Amount.
Development Deposit (30%) for Database Tracking 5/22/0B
90.00 $165.00 $14,850.00
System VFDO03
Invoice Total: $14,850.00
Payments Received:
Balance Due: $14,850.00
RISK MANAGEMENT OFFICE
INTER -DEPARTMENT MEMORANDUM
DATE: June 11, 2008
TO: Nelly Giron
City Clerk
FROM: Willard G. Yamaguchi
Risk Manager I A
RE: Angel City Data LLC
Please be advised that the above referenced has provided
acceptable insurance coverage.
Attached for your retention are insurance certificates and
related policies, declarations and/or endorsements for the
above -referenced insured that were issued by:
• The Hartford (General Liability)
• ACE -American (Professional Liability)
• USAA Casualty Insurance Company (Automobile Liability)
• Guard Insurance (Workers Compensation)
This concerns review and modify of the database, FileMakerPro,
in the Fire Department.
WY/ab
108398 Angel City Data LLC
Aeord Certificate (page I of I)
6/10/2008 3:46:35 PM
ACORDx CERTIFICATE OF LIABILITY INSURANCE
°6/1012008
PRODUCER
TECHINSURANCE
1301 Central Expy South, Suite 115
Allen, TX, 75013
(800) 668-7020
THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION
ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE
HOLDER. THIS CERTIFICATE DOES NOT AMEND, EXTEND OR
ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW.
INSURERS AFFORDING COVERAGE
INSURED
Angel City Data LLC
150 E. Olive Ave., Suite 213
Burbank, CA 91502
INSURER A: Wile Hartford
INSURER B: ACE -American
INSURER c:
INSURER D:
INSURER E:
COVERAGES
THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED, NOTWITHSTANDING
ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR
MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH
POLICIES. AGGREGATE LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS.
INSR
LTR
TYPE OF INSURANCE
POLICY NUMBER
POLICY EFFECTIVE
.DA D
POLICY EXPIRATION
DAT /D
LIMITS
GENERAL LIABILITY
F'HCH OCCURRENCE
$ I,000>000
X COMMERCIAL GENERAL LIABILITY '
CLAIMS MADE OCCUR
46SBARL4020
9/28/2007
9/28/2008
DAM GE TO T
PREMISES (Ea arcurrence)
$ 300,000
MED EXP (Anyone person)
$ 10,000
A
PERSONAL & ADV INJURY
$ 1,000,000
GENERAL AGGREGATE
$ 2,000,000
GEN'L AGGREGATE LIMIT APPLIES PER:
PRODUCTS - COMP/OP AGO
$ 2,000,000
X POLICY Llj� LOC
AUTOMOBILE
LIABILITY
ANY AUTO
COMBINED SINGLE LIMIT
(Ea accident)
$
BODILY INJURY
(Per person)
$
ALL OWNED AUTOS
SCHEDULED AUTOS
BODILY INJURY
(Per accident)
$
HIRED AUTOS
NON -OWNED AUTOS
PROPERTY DAMAGE
(Per accident)
$
GARAGE LIABILITY
AUTO ONLY -EA ACCIDENT
$
ANY AUTO
OTHER THAN EA ACC
$
AUTO ONLY: AGO
$
EXCESS LIABILITY
OCCUR CLAIMS MADE
EACH OCCURRENCE
$
AGGREGATE
$
$
DEDUCTIBLE_
$
RETENTION $
WORKERS COMPENSATION AND
EMPLOYERS' LIABILITY
WC STATU- OTH-
TORY LIMITS ER
E.L. EACH ACCIDENT
$
E.L. DISEASE - EA EMPLOYEE
$
151, DISEASE - POLICY LIMIT
$
B
OTHER
PROFESSIONAL LIABILITY
(Errors & Omissions)
G21509760 001
11/28/2007
11/28/2008
CLAIMS-MAQE
OCCURRENCE $1,000,000
AGGREGATE $1,000,000
FIDELITY BOND
(rhird Party Employee Dishonesty)
EACH OCCURRENCE
EMPLOYMENT PRACTICES LIABILITY
EACH OCCURRENCE
DESCRIPTION OF OPERATIONSILOCATIONSIVEHICLES/EXCLUSIONS ADDED BY ENDORSEMENT/SPECIAL PROVISIONS
City Of Vemon is included as an additional insured with regard to the general liability coverage. r
City of Vernon
4301 S Santa Fe Ave
Vernon, CA 90058
Attn: Risk Management
SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATIO
DATE THEREOF, THE ISSUING INSURER WILL ENDEAVOR TO MAIL 30 DAYS WRITTEN
NOTICE TO THE CERTIFICATE HOLDER NAMED TO THE LEFT, BUT FAILURE TO DO SO SHALL
IMPOSE NO OBLIGATION OR LIABILITY OF ANY KIND UPON THE INSURER, ITS AGENTS OR
AUTHORIZED REPRESENTATIVE
THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY.
POLICY CHANGE
This endorsement changes the policy effective on the Inception pate of the policy unless another date is indicated
below:
Ln Policy Number: 46 SBA RL4020 DX COPY
N
M
co
'-I
Named Insured and Mailing Address; ANGEL CITY DATA LLC
co
P
0 150 E. OLIVE AVE., SUITE 213
O BURBANK CA 91502
N
0
a Policy Change Effective Date: 09/28/07 Effective hour is the same as stated in the
Declarations Page of the Policy.
�r
0
o Policy Change Number: 002
Agent Name: TECHINSURANCE. COM/PHS
Code: 505565
POLICY CHANGES:
r HARTFORD CASUALTY INSURANCE COMPANY
e=
ANY CHANGES IN YOUR PREMIUM WILL BE REFLECTED IN YOUR NEXT BILLING
STATEMENT.
THIS IS NOT A BILL.
NO PREMIUM DUE AS OF POLICY CHANGE EFFECTIVE DATE
FORM NUMBERS OF ENDORSEMENTS REVISED AT ENDORSEMENT ISSUE:
IH12001185 ADDITIONAL INSURED - MANAGER/LESSOR
PRO RATA FACTOR: 1.000
THIS ENDORSEMENT DOES NOT CHANGE THE POLICY EXCEPT AS SHOWN.
Form SS 12 1104 05 T Page 001
Process Date: 09/26/07 Policy Effective Date: 09/28/07
Policy Expiration Date: 09/28/08
UW COPY
POLICY NUMBER: 46 SBA RL4020
THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY.
ADDITIONAL INSURED - MANAGFR/LESSOR
CITY OF VERNON
4301 S. SANTA FE AVE.
LOS ANGELES, CA 90058
THE REGENTS OF THE UNIVERSITY OF CALIFORNIA UC IRVINE
3056 HEWITT HALL
IRVINE CA 92697-4028
Farm IH 12 00 1185 T SEQ. NO. 002 Printed In U.S.A. Page 001
Process Date: 0 9 / 2 6 / 0 7 Expiration Date: 09/28/08
UW COPY
110
N
ri
w
S=
wiii .
SAS
Z
PRODUCER'S FACT SHEET
NAMED INSURED: ANGEL CITY DATA LLC
POL ##: 46 SBA RL4020 DX
PRODUCER'S NAME: PRODUCER'S CODE: 505565
TECHINSURANCE.COM/PHS
POL EFF DATE: 09/28/07 POL EXP DATE: 09/28/08
DIRECT ACCOUNT BILL NUMBER — 11458192
TRANSACTION TYPE: ENDORSEMENT
ENDORSEMENT PREMIUM: $0.00
NON —PREMIUM BEARING
AGENT SALES
TRANS EFF DATE: 09/28/07
CHANGE NO.; 002
FORM TITLE
SS 12 11 04 05 POLICY CHANGE
IH 12 00 11 85 ADDITIONAL INSURED — MANAGER/LESSOR
PRODUCER'S FACT SHEET PAGE 1
09/26/07 46 SBA RL4020 DX (09/28/08)
LAST PAGE 3
USAA CASUALTY INSURANCE COMPANY MAIL MCH-M-S
v� RENEWAL OF
(A Stock Insurance Company)
State
06 ven
POLICY NUMBER
U§AA® 9800 Fredericksburg Road - San Antonio, Texas 78288
XXr
00318 91 46C 7102 8
- CALIFORNIA AUTO POLICY
POLICY PERIOD: (12:01 A.M. standard time)
RENEWAL DECLARATIONS
EFFECTIVE JAN 05 2008 UNTIL TERMINATED
OPERATORS
01 DAVID A KNIGHT
ATTACH TO PREVIOUS POLICY
Named Insured and Address
DAVI:D A KNIGHT
2718 NORTH LAMER STREET
BURBANK CA 91504-1649
Description of Vehicle(s)
VEH USE*
SYM
WORK/SCHOOL
Moines BPr e
Vya Week
VEH
YEAR
TRADE NAME
MODEL
BODY TYPE
UAL
ANNMILEAGE
IDENTIFICATION NUMBER
06
00
HONDA
ACCORD EX
SED 4D
8500
1HGCG1655YA082445
14
B
The VehicleW described herein is principally garaged at the above address unless otherwise stated. W/C=Work/School• B=Business* F=FarimeP=Pieaswe
VEH 06 BURBANK CA 91502-1357
This po icy provides those coverages where a premiumr is shown below. a limits s own
may be reduced by policy provisions and may not be combined regardless of the number of
vehicles for which a premium is listed unless specifically authorized elsewhere in this policy.
COVERAGES LIMITS OF LIABILITY
VEH
D=DED6PR MH
VEH
VEH
VEH
("ACV" MEANS ACTUAL CASH VALUE)
MI
D=: DEDI PREMIUM
D=DED PREMIUM
D=DED PREMIUM
AMOUNT $AMOUNT]
$
AMOUNTI$
AMOUNT $
PART A - LIABILITY
BODILY INJURY EA PER $ 500,00
EA ACC $1,000,00 251.31
PROPERTY DAMAGE EA ACC $ 500,00 156.52
PART C - UNINSURED MOTORISTS
BODILY INJURY EA PER $ 500,00
EA ACC $1,000,000 69.06
I
ADDITIONAL INTEREST - EMPLOYER
LOSS PAYEE
VEH 06 AMERICAN HONDA FINANCE, CYPRESS CA
VEH 06 AMERICAN HONDA FINANCE, CYPRESS CA
ENDORSEMENTS: ADDED 01-05-08 - NONE
REMAIN IN EFFECT(REFER TO PREVIOUS POLICY)- A073(03) A400CA(02) A100CA(03)
5100CA(01)
E
H
E
H
E
H
EV
H
ui vvi i ivraa vvnrnrur, we nave uauseu Lnis puiiuy Lu ue siyneu uy uur rresiuenL aim aeuretary aL aan Hnwiiiu, i exas,
on this date NOVEMBER 29, 2007
St Alan Secreta
soon c ry Stuart Parker, President
Jun 04 08 01:59p Angel City Data
r�r=n
PAYCHEX AGENCY INC.
1175 JOHN STREET
WEST HENRIETTA, NY 14585
ANGEL CITY DATA, LLC
150 EAST ALIVE AVE.
SUITE 213
BURBANK, CA 915Q2-
818-238-0173 p.3
TMS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION
ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE
HOLDER. THIS CERTIFICATE DOES NOT AMEND. EXTEND OR
COMPANY
A
COMPANY
B
C MPAMv
COM0PANY
GUARDINSURANCE
THIS IS TO CERTIFY THAT THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD
INDICATED, NOTWITHSTANDING ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS
CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECTTO ALL THE TERMS,
EXCLUSIONS AND CONDITIONS OF SUCH POLICIES, LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS.
TYPE OF INSURANCE POLICY NUMBER FWCT EFFECTIVE POLICY EXPIRATION LIMITS
---- --- —.. _ DATE(MMMDrYY) DATE(MWDENM
COMMERCIAL GENERAL LIABILTY
E=VLAIMS MADE [�CCUR
OWNER'S 6 CONTRACTOR'$ PROT
ANY AUTO
ALL OWNED AUTOS
SCHEDULED AUTOS
HIRED AUTOS
NON -OWNED AUTOS
ANY AUTO
UMBRELLA FORM
OTHER THAN UMBRELLA FORM
WORKER'S COMPENSATION AND
A EMPLOYERS' LIABILITY
THE PRCPRIETORI
PARTNERS/EXECUTIVE [] INCL ANWC912223
OFRCERSARE: O EXCL
OTHER
DESCRIPTION OF OPERATIONSILOCATXWASIVENICLES/SPECUIL ITEMS
CITY OF VERNON
4305 S Santa Fe Ave
Las Angeles, CA 90058
GENERALAGGRfiGATE Is
PRODUCTS -COMPIOPAGO $
PERSONAL ADV NJURY $
EACH OCCURRENCE $
FIRE DAMAGE (Any one Fire) S
MED EXP (Any one person) $
COMBINED SINGLE LIMIT $
BODILY INJURY $
(Perperson)
BCUILYINJURY $
(Per accidem)
PROPERTYDAMAGE $
AUTO ONLY - EA ACCIOENT S
OTHER THAN AUTO CNLY:
EACH ACCIDENT $
AGGREGATE S
EACH OCCURRENCE g
AGGREGATE $
EL EACH ACCIDENT S 1 D0,000.00
04/17/08 04/17/09 EL DISEASE -POLICY LIMIT $ 500,000.00
EL DISEASE - EA EMPLOYEE $ 100,000.00
SHOULD ANY OF THE ABOVE DESCRI BM POLCIES BE CANCELLED BEFORE THE
EXPIRATION DATE THEREOF, THE ISSUING COMPANY WILL ENDEAVOR TO MAIL
30 DAYS WHRTEN NDTICE TO THE CERTIFICATE HOLDER NAMED TO THE LEFT,
BUT FAILURE TO MAIL SUCH NOTICE SHALL WpOSE NO OBLIGATION OR LIABILITY
OFANY KIND UPON THE COMPANY, ITSAGENTSOR REPRESENTATIVES.
Best's Rating Center - Company Information for Hartford Casualty Insurance Company
Page I of 2
Ratings Definitions ►
Search Best's Ratings
Press Releases
Related Products ►
Industry & Regions[
Country Risk
Structured Finance
How to Diet Ratted
Contact an Analyst
Is: Financial Strength Issuer Credit Securities Advanced Search
Hartford Casualty Insurance Company
(a member of Hartford Insurance Group)
A.M.Best #: 02229 NAIC #: 29424 FEIN #: 060294398
Address: One Hartford Plaza
Hartford, CT 06155
Best's Ratings
Phone:860-547-5000
Fax: 860-547-6343
Web: www.thehartford.com
Financial Strength Ratings View_ Definitions
Rating: A+ (Superior)
Affiliation Code: p (Pooled)
Financial. Size Category: XV ($2 Billion or greater)
Outlook: Stable
Action: Affirmed
Effective Date: June 25, 2007
* Denotes Under Review Best's Ratings
Other Web Centers:', Se
A
This rating is assigned to Pinanci
companies that have, in our
abi opinion, a superior lity to
meet their ongoing obligations A+
to policyholders. -
Issuer Credit Ratings View Definitions
Long-Term:aa-
Outlook: Stable
Action: Affirmed
Date: June 25, 2007
Reports and News
Visit our NewsRoom for the latest news and press releases for this company and its A.M. Best Group.
AMB Credit. Report- Insurance Professional Unabridged) (formerly known as Besfs Company Repo
x Best's Financial Strength Rating and rationale along with comprehensive analytical commentary, c
business overview and key financial data.
Report Revision Date: 07/18/2007 (represents the latest significant change).
Historical Reports are available in AMB Credit Report - Insurance_ Professional (Unabridged) Archi
. Best's Executive Summary Reports (Financial Overview) - available in three versions, these pi
style reports feature balance sheet, income statement, key financial performance tests including p
liquidity and reserve analysis.
Data Status: 2008 Best's Statement File - P/C, US. Contains data compiled as of 5/20/2008 (Quali
Checked).
Single Company - five years of financial data specifically on this company.
Comparison - side -by -side financial analysis of this company with a peer group of up to five o
companies you select.
Composite - evaluate this company's financials against a peer group composite. Report displ,
average and total composite of your selected peer group.
AMB Credit Report - Business Professional - provides three years of key financial data present
�? colorful charts and tables. Each report also features the latest Best's Ratings, Rating Rationale an
-i from our Business Review commentary.
Data Status: Contains data compiled as of 5/20/2008 (Quality Cross Checked).
Bests Key Rating Guide Presentation Report - includes Best's Financial Strength Rating and fi
�y x: as provided in Best's Key Rating Guide products.
rilY,
Data Status: 2006 Financial Data (Quality Cross Checked).
Financial and Analytical Products
Best's Property/Casualty Center - Premium Data & Reports
Best's Key -Rating -Guide - P/C, US & Canada
http://www3.ambest.comlratingsIFullProfilc.asp?B1=0&AMBNum=2229&AItSrc=l &A1tNum... 5/20/2008