Linux Training Proposal

City of Largo WAMS Software Requirements









Proposal # 09-P-299 Procurement of a Work and Asset Management System (WAMS) - Appendix A Questionnaire



Enter Company Name Here



Req_I Questions Proposer Response Additional Comments

D Out of the Requires Not Future

Box Configuratio Available or Enhanceme

n Supported nt





Can you establish standard descriptions and boilerplate for data such

1 as parts, equipment, etc.?





Is there a standard dictionary to ensure consistent nomenclature and

2 format across the enterprise?



Can you establish standard enterprise-wide numbering schemes?

4 Example: part numbers and supplier part reference numbers.







5 Can you establish standard forms and reports?





Can you establish standard hierarchies to be used across the

6 enterprise? Example: Hierarchy for equipment, parts, employees, etc.





Can you import/export data into the WAMS using ASCII print file

7 format?





Can you import/export data into the WAMS using OpenOffice file

9 format?







10 Can you import graphics into the WAMS?







14 Can you print barcode labels for equipment/components?







17 Can you print barcode labels for employee ID?







18 Are label layouts user-definable?





Can you enter scanned information, online and batch, for equipment or

19 parts?





Can you enter scanned information, online and batch, for warehouse

22 issuance/receipts/returns?





Can you enter scanned information, online and batch, for purchase

24 order numbers?









Can you enter scanned information, online and batch, for purchase

25 order part numbers?





Can you enter scanned information, online and batch, for work order

26 numbers?







27 Is there error checking for format using Boolean logic?







28 Is there error checking for logic using Boolean logic?







29 Is there error checking for range through use of Boolean logic?







33 Is error checking for format available for all fields?







34 Can error checking for format involve other fields?







35 Is error checking for range available for all fields?





Can error checking for range involve other fields? example: using an

36 equation or Boolean logic to compare to another field.







37 Is error checking for logic available for all fields?

Can error checking for range, format, logic be specific to a given user

or user group? Example: Maintenance planners must enter data in the

following format for a given field: XX-NNN, otherwise an error

39 message appears.







40 Can you establish mandatory fields?



Can you establish mandatory fields for a given user or group of users?

Example: Certain trades must enter certain information that is not

41 required for other trades, otherwise an error message appears.





Is there error checking for format through table lookup? Example: part

42 number must be 5 numeric digits starting with an alpha character.



Is there error checking for logic through table lookup? Example:

Wrong engine on vehicle, or too many pumps in a given piece of

43 equipment.





Can error messages be classified by the user (e.g. info only, action,

44 shutdown)?







45 Are error or other messages customizable by the user?



If there is a "serious" error, can a predefined action be initiated?

Example: If a user makes multiple attempts to perform an action that is

46 not allowed, an alert is sent to the supervisor.







47 Do error messages have a reference number for easy locating?





Do error or other messages provide troubleshooting suggestions or

48 wizard?

Can you set action required if a user is in breach? Example: If a user

tries to access a restricted area or enter restricted data, perhaps an

alert can be sent to the supervisor. A less severe action may be an

59 error message can be displayed to the user.





Can you secure what data is allowed for a given field for a given user?

60 Example: A given user can only enter labor rates in US dollars.





Can you set $ limits for fields such as purchase request, purchase

62 order, work order, project?







63 Does the audit trail display: date/time stamp, user, and all action's?



Is there an audit trail that tracks changes to the database by the user?

That is, including field value before change and field value after

65 change.







71 Is the software program copy protected?





Is there password protection on individual functions (e.g.

73 read/add/change/delete)?







74 Is there password protection on individual modules?







82 Is there on-line help specific to procedures (i.e., "how to" help)?





Is there graduated help, i.e., can you choose between advanced or

83 beginner help?





Is there micro-help, i.e. help labels when cursor touches an icon or at

84 bottom of screen?







86 Is there a comprehensive help index?







87 Can a user customize the help index?







88 Is there a comprehensive table of contents?







90 Are examples given for most of the help screens?







91 Can a user modify help messages?







92 Is CBT training available via online help?





Can you toggle dynamically between multiple windows showing

98 hierarchy above and cost data?



Can you toggle dynamically between multiple windows showing

hierarchy above and graphics? Example: For equipment hierarchy,

99 show graphic of corresponding equipment.





Can you toggle dynamically between multiple windows showing

100 hierarchy above and object detail?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 1 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D



Are there features (e.g. shading, color) to distinguish mandatory

110 fields?







111 Are there features (e.g. shading, color) to distinguish optional fields?

Are there indicators that information has arrived, a database has

changed, or action is pending? Example: An icon flashes on the

bottom right of the screen signaling to the user that a new work

112 request has been entered by someone on the system.







114 Is there an "undo" feature available even after writing to the database?







114 Is there an "undo" feature available even after writing to the database?





Can you save the customized data entry screen under the user

115 profile?







117 Are there audible warnings?







118 Can you turn off audible warnings?







120 Is there a built-in "copy" feature for repetitive data entry?





Is there an easily customizable, quick data entry screen available for

122 all input screens?





Are there features (e.g. shading, color) to distinguish display only

123 fields?







132 For every screen, is it clear where you are in the application?





Are function keys available for frequently used menu items? For

133 example: Alt F5 will open a new work order.







134 Are macros built into the program for repetitive keystrokes?





Is there a search engine for finding relevant objects such as work

135 orders, people, etc.?







136 Are multiple toolbars available for different functional groupings?







138 Are toolbar icons available for most functions?





Is there an easy way for users to edit standard data entry forms?

143 Example: User edits a standard work request or time card form.





Is a license required for data entry using web-based forms? Example:

145 Building superintendents entering monthly fire equipment status.

Are templates available for different roles, industries, and

applications? Example: A form for retail stores or hospitals to enter

work requests, a home-based work request form for tenants, a kiosk-

146 based work request in a large facility.

Can you drill down to lower level objects from portal links? Example:

From the portal, link to filtered and sorted list of active work orders,

and then drill down on one of the work orders in the listing for work

147 order detail.







148 Can you then edit base documents such as a work order?



Can users adjust the auto refresh rate of data on the portlet?

Example: How often KPI's, exception reports or alarm screens are

153 updated.





Can users set up a custom portlet or home page with quick access to

154 key forms/functions/reports?





Can default values be defined using algorithms, equations, or

155 business rules?





Are users assigned a default organization in a multi-plant enterprise?

156 That is, to prevent logging in and out of each organization.





Can a user expand and customize fields without accessing the source

161 code?







166 Can a user change the assignment of function keys?





Are wizards available to walk users through customization and

170 configuration?





Can a user expand/edit standard forms (e.g., work order) without

174 accessing the source code?





Can a user expand/edit standard reports without accessing the source

175 code?







181 Is there drill-down capability on all reports and listings?





Is there drill-down capability to lowest level, on any field of any screen,

183 by double-clicking?







184 Can all standard reports be sorted and filtered using Boolean logic?







185 Can all look-up tables be sorted and filtered using Boolean logic?





Can all online browses or queries be sorted and filtered using Boolean

186 logic?





Is there an option for ALL reports to be printed to screen, file, or

187 printer?





Is there an option for ALL graphics to be printed to screen, file or

188 printer?







189 Are all reports available online?





Can reports be printed locally (i.e., not centralized printing and

190 distribution)?







191 Are all browsers and queries available from within the WAMS?





Can users select preferred graph formats for reporting? Example:

192 line graph, bar chart, pie chart, run chart, etc.





Can users select preferred business intelligence formats for

193 reporting? Example: stoplights, speedometers, etc.





Upon completion of an ad hoc query, can users perform global

195 functions on records selected?





Can the user define the algorithm for calculating the KPI using any

196 combo of fields or math functions?



Are standard KPI's from the Florida Benchmarking Consortium

197 provided by the vendor?

Are standard KPI's provided by the vendor built on "industry-standard"

algorithms, where possible? That is, has some effort been made to

determine the generally accepted norm in defining KPI's such as

198 downtime, utilization, availability, etc.

Can standard algorithms for standard KPI's be customized by the

user? That is, if a user does not agree with a WAMS vendor's

standard algorithm, or requires a modification based on internal

200 company standards.





Can users add their own KPI's to the list of standard KPI's, including

201 corresponding algorithms?





Can key performance indicators (KPI's) and targets be tracked

202 online/real-time?







203 Can you specify the refresh rate?







204 Can you display when the information was last updated?







206 Can you filter the data displayed (e.g., only exceptions)?





Can you select a business intelligence format or icon for each KPI?

207 Example: dashboard, stoplight, etc.

For each KPI, can you establish low, high and acceptable ranges?

Example: For a given KPI, establish the min. and max. values of the

expected/acceptable/normal range. Anything less than the min. will be

209 the "low range", and anything greater than the max.

For each KPI, can you establish low, high and acceptable ranges?

Example: For a given KPI, establish the min. and max. values of the

expected/acceptable/normal range. Anything less than the min. will be

209 the "low range", and anything greater than the max.



Can you establish descriptors for the ranges? Example: for low range

- label "poor"; for acceptable range - label "normal"; for high range -

210 label "excellent"









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 2 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D



Can you show graphically the KPI trend over a user-defined period

211 online/real-time?







212 Can you compare the trend to previous period's?







213 Can you compare the trend to expectation?







214 Can you compare the trend to best practice or a stretch goal?





Can users exchange data? Example: Users share standard data,

217 performance benchmarks, best practices.





Is there a newsgroup/bulletin board where users share WAMS-

218 specific problems/solutions?







219 Can steps in the work flow be made mandatory or optional?

Can work flow be fully integrated with electronic commerce? For

example: using the workflow engine to route purchase requisitions,

RFQ's, quotations, purchase orders, invoices, etc. internally and with

223 external vendors via the Internet.





Can work flow automatically create a to-do list for users based on their

224 roles?







227 Can users determine statistics for a given work flow?







228 Can standard times for each activity on a work flow be entered?





Can a given work flow be assigned to an individual, group of people,

229 or level in organization?





Can you assign an appropriate work flow based on the characteristics

230 of a specific object?





Do work flows allow a choice of automatic or manual approvals for

232 each status change?









Can you attach documents to objects such as an equipment record,

233 work order, purchase order, etc.?







Is there a viewer for viewing most file types from within the WAMS?

For example: all OpenOffice documents, e-mail, CAD drawings .dwg

234 .dgn, Adobe .PDF files, ASCII .txt files, and scanned documents









Can you optionally launch the document from within the WAMS rather

235 than use the viewer?









Can you provide long descriptions for documents from within the

237 WAMS?









238 Can you provide keywords for documents from within the WAMS?









239 Can you categorize and index documents from within the WAMS?





Can you create blanket work orders usable on multiple equipment

254 from different cost centers?







255 Can you define shift hours on the work order?





Can you prohibit a user charging dollars to someone else's cost

256 center?







259 Are safety tasks/instructions recorded against work orders?









Can you retrieve drawings directly into the WAMS from within the work

260 order screen?







Can drawings be edited from within the work order screen? Example:

Add lubrication points and notes on a CAD drawing for a given

261 part/component.





Is there a standard parts list for the selected asset within the work

262 order screen?





Can you select parts from multiple warehouses from within the work

264 order screen?









265 Can you receive parts back into stores as "quantity to be repaired"?









268 Can you flag parts as to "critical spares"?









269 Can you flag parts as "hazardous material"?









Can you drill down on standard parts to view nameplate detail from the

270 inventory control module?









Can you hot key to a drawing showing standard parts for the asset?

271 That is, from within the work order screen.





Can you drill down on hot spots on the drawing to link to detailed part

information? That is, the detailed parts information comes from the

inventory control module, but all is visible from within the work order

272 screen.



Can you see detailed parts status from within the work order screen?

That is, can you determine from within the work order screen, quantity

273 of parts in stock, on reserve, on order, in transit, and in quarantine.





Can you select new, used, or reconditioned parts from within the work

274 order screen?









275 Can you view stock levels of each within the WO screen?







Can you separately identify contract maintenance on the schedule? If

276 yes, can you avoid distortion of capacity on the schedule?







Can contract labor hours be planned & actuals reported without

278 WO/PO distortion?







Similarly, can material be planned and actuals reported without

279 WO/PO distortion?









Are total dollars booked for planned labor & material used in

280 establishing approval levels?









Does approval level change when the WO is in overrun for total

281 labor/material $'s booked?









282 Can you define approvals for status changes for WO's?







Can you set up multiple approvals where routing is automated?

Example: If a large job needs three signatures, the work order is

283 routed automatically to each of the approvers in sequence.





Can you set up approvals by one of multiple people including auto

routing & notification? Example: If a job can be approved by one of

three people, the work order is routed to each of the approvers. When

284 1 signs off, the others are notified so there is n









Can you set up alternative approvals, e.g., when primary approver is

285 on vacation?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 3 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D









286 Can you define approval limits as a range over time or by approver?







287 Can you reopen a closed work order?







288 Can you charge labor to a closed work order?







289 Can you charge materials to a closed work order?





Can you prevent closing a work order based on work order status

290 (e.g., missing/wrong info)?





Can you prevent closing a work order based on asset status (e.g.,

291 pending disposition)?



Can you record final asset disposition status before closing the work

order? Example: Sample statuses are salvaged, scrapped, sold, out

292 for repair, in stores, and installed.







293 Will the WAMS accept web-based Work Requests?



Can work requests be created by anyone with web or e-mail access, &

processed automatically? Example: Standard maintenance work

request form that sits on the client and is sent by e-mail or via the web,

294 then queued for review by the maintenance planner.





Will work request originators receive acknowledgment that the work

295 request was received?





Can originators determine work request status at any time (e.g.,

296 reviewed by planner, % complete)?





Will originator receive acknowledgment when work request is

297 rejected?





Will originator receive acknowledgment when work request is rejected,

298 including explanation?





Can the work request be completed via web browser (i.e., software is

299 not required on the client terminal)?







300 Is there a field to prioritize WO's based on urgency?







301 Is there a field to prioritize equipment based on criticality?







302 Is there a field to prioritize WO's based on criticality?







303 Is there a field to prioritize equipment based on criticality?







304 Is there a user-defined field to prioritize WO's other than above?







305 Is there a user-defined field to prioritize equipment other than above?





Are there any other fields to prioritize WO's or equipment used in

306 scheduling?



Are priorities combined and used to suggest a schedule? If yes, can

you avoid distortion of capacity on the schedule? Example: Multiply

urgency by equipment criticality and use product for prioritizing work

307 orders.









310 Does the graphical schedule show workload capacity?







Can you drag/drop work orders on the graphical schedule, & see

311 effect on workload/availability?







Can you drag/drop resources on the graphical schedule, & see effect

312 on workload/availability?







Can you drill-down to access detailed WO info from within the graph

313 itself?









314 Can you then edit the WO info from within this detailed WO screen?









315 Is there a calendar showing hours available by crew by day?









316 Can you show crew utilization graphically by day?







Can you report on how many tools & special equipment are checked

326 out by a given user?









327 Can tool usage be analyzed from the schedule, i.e., utilization?









328 Can tools be scheduled separately to avoid double booking?







Can scheduled tool use be estimate cost, e.g., allocation by resource

329 type? That is, charge an hourly tariff to a cost center.









330 Can special equipment such as cranes be scheduled separately?







Can special equipment usage be analyzed from the schedule, i.e.,

331 utilization?





Can special equipment scheduled be estimate cost, e.g., allocation by

332 resource type? That is, for serialized and non-serialized.







333 Can you track tools and special equipment in for repair?







Does the schedule have resource balancing utilizing planned

334 absences?







Does the schedule have resource balancing utilizing planned

335 downtime?







Can the schedule display in-process work orders, including revised

336 hours by craft to completion?









337 Can you report on crew or trades person utilization?









338 Is a distinction made between scheduling and planning?





Are pull-downs, code tables or standards available for PM task

348 definitions?







349 Are pull-downs, code tables or standards available for PM task times?





Are pull-downs, code tables or standards available for corrective task

350 times?







351 Is standard data available for safety checklists and tasks?









Are pull-downs, code tables or standards available for reliability-cent

352 red maintenance conditions linked to tasks?







353 Can you trigger PM by time?





Are readings validated with a user-defined validation formula?

Example: If a volume reading is keyed in for a gas tank that doesn't

354 hold that much gas, then an error message is given.





Can you have a PM routine triggered on a preferred day/date if within

356 tolerance?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 4 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D





358 Can you establish PM shadowing to avoid duplicate PM's?





Can you "override or take credit" for corrective work that covers PM

359 work due?







360 Can you trigger PM by usage using a separate field?







361 Can you trigger PM by event using a field?







362 Can you trigger PM by condition using a field?







363 Can you have multiple triggers per asset?







364 Will the trigger from one of these indicators reset all other triggers?







365 Can you nest triggers with different cycles?





Can you combine indicators using Boolean logic to create

366 consolidated or alternate indicators?





Can you recommend corrective action based on condition? Example:

367 If condition 1 = "x", and condition 2 = "y", then trigger PM number "z".





Are conditions and alarms visible and distinguished on the graphic (ex,

370 blinking, color changes)?







372 Can you enter a new condition easily from within the graphic screen?





Can you trigger a user-defined activity such as an alarm, pager, or e-

373 mail?





Can you trigger a user-defined activity when a PM routine's "critical %"

374 reaches a threshold?





Can you trigger a user-defined activity when a failure has repeated

376 within a user-defined period?





Can you trigger a user-defined activity when downtime exceeds a

377 threshold value?





Can you trigger a user-defined activity when measures exceed control

378 limits?





Can you trigger a user-defined activity when measures trend within

379 certain % of control limits?





Can you trigger a user-defined activity when average mean time

380 between failure (MTBF) is outside a given range of values?





Can you trigger a user-defined activity when equipment is due for

381 warranty work?





Can you trigger a user-defined activity when parts have not arrived for

382 a work order coming due?





Can you trigger a user-defined activity when wait time within a work

383 flow exceeds a value?





Can you trigger a user-defined activity when activity times within a work

384 flow exceed standard?





Is there a PM master which can show forecasted cycles resulting from

385 choice of frequency?





Can you make adjustments to scheduling of the PM routine within the

386 PM master?







387 Can you display shutdown periods on the PM schedule?









388 Can you display peak production periods on the PM schedule?









389 Can you display holidays on the PM schedule?







390 Is there a 52-week schedule?





Is PM history used automatically to suggest corrections to future PM

391 scheduled?









392 Will the priority automatically increase, the longer the PM is not done?





Can users ensure there is no accumulation of missed PM's?

Example: Suppose 8 daily PM's have been missed in a row. Users

393 may not wish to have 9 identical PM's print out on the 9th day.









Can you establish seasonality for a given procedure (i.e., start/stop

394 dates)?





Can you establish annual seasonality for a given asset (i.e., start/stop

395 dates for winter versus summer)?









396 Can you establish multiple start/stop dates for procedures?







397 Can you establish multiple blackout periods for procedures?









398 Can you establish multiple start/stop dates for assets?





399 Can you establish multiple blackout periods for assets?









400 Can you schedule PM by the hour?





Can you schedule PM by number of recurrences? Example: Repeat

401 this PM routine for 6 cycles and then stop.



Can you schedule PM occurrence by recurring month/days?

Example: Repeat a PM procedure every 2nd Tuesday, every other

402 month.





Can you schedule PM on specific calendar dates? Example: Repeat

403 the PM procedure on Feb. 3, Mar 9, Jun. 1, and Dec. 22.



Can you schedule PM with specific calendar dates as exceptions?

Example: Repeat PM procedure every 4 weeks except July 1 and

404 Sept. 2.



Can you establish a PM route for a single asset type across multiple

locations? Example: Inspection of all pressure valves in multiple

405 facilities.





Can you establish a PM route for multiple assets in one location?

406 Example: Inspection of multiple assets on one stretch of roadway.



Can you establish an "asset group" tying several assets to one or

407 more procedures?







408 Can you route PM's referencing a GIS map or interface?





Can problem/cause/action codes be recorded against individual

409 assets along a route?



Can labor and material be charged to an individual asset along the

410 route?





Can labor and material be charged using an average cost spread over

411 all assets in a route?



Can you conduct multiple inspections at multiple points on an asset or

infrastructure? Example: Set up inspection for corrosion level on a

414 pipe at entrance and at 10-foot intervals.





Can you define min. and max. thresholds values for inspection

415 readings?





Can you set up & record results of a risk-based assessment using

419 risk, criticality,and failure mode?





Will the system automatically increase the frequency of inspection if

420 the risk increases?







421 Can you define a "confidence rating" on the risk?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 5 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D



Can you provide inspector with historical information including last

423 value, date, and description?









424 Is replacement frequency tracked for inspection tools?





Will a standard work order or PM routine be issued automatically if the

426 critical value is reached?







429 Can you report on work history by a GIS locator?







431 Can you assign assets on the map to a route?







433 Can you flip back and forth between the map and asset record?





Can you budget and track actual maintenance costs down to the G/L

436 account code?





Is the budgeting module directly integrated with the planned

437 (committed) hrs/materials on the WO's?



Can you budget for multiple cost types and track actuals against

them? Example: labor, material, overhead, contract labor, contract

438 material, rentals, service expenses (e.g. travel related to service work).









439 Is there detailed budgeting available for capital projects?









441 Is activity based costing available?









442 Are activity codes linked to G/L account codes?







443 Can you budget for activity codes?





445 Can you charge time and materials cost directly to an asset?



Can you optionally track actual repaired value for an asset or

446 depreciated/appreciated value?





447 Can you assign an average repair cost to an asset?





Can you track equipment costs by user-defined statistics? Example:

448 Cost per ton produced; cost per mile





449 Can you identify assets as trackable?









450 When assets are tracked, can user define status (e.g., out for repair)?







451 Can you identify assets as repairable?



Can you identify assets as requiring inspection or other quality-control

452 procedure?



Can you track asset move history for each location following multiple

454 transfers between sites?



Does move history show move date, from/to location, from/to parent,

455 WO/PO number's, & move cost?





Can you track costs for multiple lives of an asset (e.g., after rebuild or

456 replacement), or total across all lives?







457 Are all work orders on warranty summarized and reported?





Can you favor use of non-serialized parts that are closer to warranty

458 expiration?





Does the program record and track multiple warranties on a single

460 asset?





Is warranty type differentiated, e.g., manufacturer's, vendor-based, or

461 extended?







462 Can warranties be tracked on a calendar basis?







463 Can warranties be tracked on an asset basis?







465 Can you do warranty renewals?





Can you favor use of serialized parts that are closer to warranty

466 expiration?







467 Can you define an event type?







468 Can you track problem/cause/action codes for events?





471 Can you track event history?





472 Can you define an event class? Example: reduced service





473 Can you link an event to a given asset?





474 Is there a date and time stamp for the start and end of the event?

Can you record activities and actions that make up the event duration?

Example: Event steps such as inspect, maintenance call, leak

477 discovered, etc.





478 Can you track elapsed time for each activity within an event?





479 Can you track total elapsed time for an event?



Are problem codes grouped and tied to a given asset? Example:

Only 8 of the 500 possible problem codes are shown as available to a

480 user for applying to a given asset.



Can you group and tie problem codes to a given asset group?

481 Example: for ALL pumps rather than a single serialized pump.

Are cause codes grouped and tied to a given problem code for a

given asset (group)? Example: Only 5 of the 400 valid cause codes

are shown as available to a user for a given problem code of a given

482 asset.

Are action codes grouped and tied to a given problem/cause/asset

combination? Example: Only 7 of the 600 valid action codes are

shown as available to a user for a given cause code of a given

483 problem code of a given asset.

Can you select codes from a master list to reduce duplication? That

is, choose from a master list of all problem codes, those problem

codes you would like to assign to a given asset or asset group.

484 Similarly, for cause and action codes.







486 Can you record and report on reason codes for downtime?





487 Are repaired parts tracked, i.e., serialized parts tracking?









488 Can shop charges for parts be tracked (e.g. machining in-house)?





490 Is there an option to vary the amount of detail saved to history?





Can you set default for a given employee, as to whether alerts sent via

492 e-mail, pager, etc.?



Are frequencies and probabilities analyzed for problems/complaints?

Example: Using Pareto analysis, predictive trending, correlation, and

493 other statistical analysis tools.



Is "time since the last failure" tracked for a user-defined root cause?

That is, to determine if a given course of action has been effective in

494 reducing the frequency of failure due to a given root cause.



Is "time since the last failure" tracked for a user-defined action taken?

That is, determine how effective optional actions/solutions are to given

495 root causes.



Is "time since the last failure" tracked from the last checkpoint? That

is, determine whether checkpoints are too often or not often enough,

496 or whether they are possibly ineffective in catching potential failures.



Can you drill down to determine detail from these "time since the last

failure" analysis screens? That is, if not trending in the right direction,

497 why not? If it is, what is the next biggest failure problem to work on?



Are frequencies and probabilities analyzed for root causes? Example:

Using Pareto analysis, predictive trending, correlation, and other

498 statistical analysis tools.



Are frequencies and probabilities analyzed for actions taken?

Example: Using Pareto analysis, predictive trending, correlation, and

499 other statistical analysis tools.







500 Is Pareto analysis done for problem/cause/action codes?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 6 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D





501 Is mean-time-between-failures (MTBF) tracked?







502 Can you determine MTBF for a specific root cause?







503 Is mean-time-to-repair (MTTR) tracked?







504 Is mean-wait-time (MWT) tracked?



Is "time since the last failure" tracked for any failure type, in order to

determine trend? That is, to determine if asset reliability is improving

505 over time.







508 Are frequencies and probabilities analyzed for equipment availability?





Are frequencies and probabilities analyzed for equipment

509 performance (e.g. speed)?





511 Can you quantify, track, and analyze asset reliability?

Can you quantify, track and analyze asset performance? Example:

Pareto, root cause, and impact analysis of (opportunity) loss of

512 production, and revenue loss.





513 Can you quantify, track and analyze asset utilization?

Can you quantify, track and analyze asset availability? Example:

Pareto, root cause and impact analysis around downtime, revenue

514 loss, number of stoppages.

Can you quantify, track and analyze quality impact? Pareto, root cause

and impact analysis of scrapped quantity and revenue loss caused by

maintenance-related factors (as opposed to operator error, product

515 quality, etc.).



Is life cycle cost for a given asset tracked (i.e., TCO or total cost of

516 ownership)?



Is life cycle cost for a group of assets tracked (e.g., certain type/brand

517 of pumps)?





Is there a troubleshooting database to help diagnose repair

518 problems?







519 Can you track and analyze warranty repair work done?





Are safety tasks/instructions tracked and analyzed for work orders &

520 PM routines?









521 Can you do manual appreciation of capital spares?







Can you record and manage to measurement standards? Example:

Including gauge usage, gauge requirements for parts, calibration

535 procedures, etc.









536 Are multiple measurements allowed?







537 Can you download work orders onto a PDA?





Can you upload from a PDA, hours worked and work done against a

538 work order?







539 Can you download parts required?







540 Can you download other inventory information?







541 Can you upload parts used?







542 Can you download tools required?





Can you scan barcodes on assets, parts, or employee badges with

543 scanner built into PDA?





Can you enter work requests on the PDA (e.g., resulting from an

544 inspection)?





Will the proposed system support a centralized employee database in

571 a HR system?





Does the software have the ability to automatically communicate any

617 changes to all affected parties via work flow management?





Can the system alert the Supervisor when employee is out of

785 compliance in training or certification?





Does the proposed system have the ability to link to a Health and

797 Safety database to extract information such as MSDS sheets?







815 Is a user-defined fiscal calendar available in the WAMS?







816 Are user-defined calendar periods a function of the WAMS?





Does the system support a user-defined calendar period for the

819 organization?







Does the WAMS have the ability to open and close calendar periods

823 by entity?







852 Is rounding by column a function of the WAMS for reports?





Does the WAMS support spreadsheet-ready exports in tab delimited

853 format?





Can the WAMS export into OpenOffice Spreadsheets as tab

854 delineated?







870 Can the WAMS produce reports on a standard operating system?

Does the WAMS have a versatile end user reporting tool - flexible

report format / rounding options / calculation options / variance

analysis - that can easily access the underlying data contained in the

915 general ledger data base?





Does the WAMS provide the user with the ability to design standard

999 monthly reports as well as "one-off' reports?





Will the software allow the user to manipulate historical data with the

1026 appropriate security?







1071 Can the user Import/export transactions to another database?







1071 Can the user Import/export transactions to another database?







1366 Will the system maintain asset number and type?







Does the system have the capability to report against a capital

1376 budget?





1403 Does the system have a user-defined depreciation calendar?



Can the user set depreciation options (year-to-date, period-by-

1411 period)?



Will the WAMS allow the user to set default depreciation rules by date

1442 placed in service?





Can the user store e-mail addresses, web sites, fax number in the

1725 vendor profile?







1726 Can an item be linked to a vendor record?







1727 Can the user track vendor lead times (external and transportation)?









Does the system have an expiration date for shelf life of controlled

1736 items?









Can you generate claims for non-conformance receipt, for return of

1745 goods?





Does the system Interface with the inventory system to: 1) Update the

average unit cost of the item received 2) Increment on-hand quantity

when a purchase order is received 3) Increment on-order quantity

1777 when a purchase order is opened?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 7 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D



Can the user print a vendor performance report based on: 1)

Shipment and purchasing history 2) Showing late deliveries (days

late) 3) Orders placed 4) Rejects (number and percent) 5) Price

1780 variances 6) Dollar volumes?









1786 Can the WAMS track purchases YTD in number and dollars?









1789 Can track the storage unit of measure?









1792 Can the system produce 24 month statistical performance data?









1796 Can generate a Vendor performance (price, quality, delivery) report?









1797 Ability to generate vendor quality ratings?









1798 Ability to provide statistical updating and reporting of supplier rating?









1803 Ability to retain requisition history?







Can the purchase requisition reference to the project, account,

1809 program, contract and/or sales order?





Does the software provide for work order on-line approvals with Work

1862 flow Management?





Does the software provide for work order on-line approvals with Work

1862 flow Management?





Does the user have the ability to track contract acknowledgment in the

1893 WAMS?





Does the user have the ability to track contract history maintenance in

1894 the WAMS?





Does the user have the ability to link and review contract

1895 documentation and produce related reports?





Does the user have the ability to track the contract agreement number

1897 in the WAMS?





Does the user have the ability to track contract types (i.e. normal,

1898 special) in the WAMS?





Does the user have the ability to track contract start and end dates in

1899 the WAMS?





Does the user have the ability to track agreement signal date in the

1900 WAMS?









1945 Inventory/stock value list by warehouse, product range, special orders





Does the user have the ability to track contact effective dates in the

1965 WAMS?







Does the System provide inquiry and reporting capability for inventory

1980 transaction summary by from and to dates







Does the System provide inquiry and reporting capability for inventory

1981 status by item number & location?







Does the System maintain item number history of usage, both planned

1988 and unplanned, purged upon a specific date criteria?





Will the System support the following: bar coding of individual parts as

received prior to warehousing, real-time scanning & inventory updates

1991 at picking, real-time scanning at shipping?





Is the System capable of managing harmonized part number

information & integrating /maintaining harmonized information with 3rd

1998 party (e.g. Freight Forwarder)?









2003 Does the System have the ability to track inventory by business unit?







Does the System have the ability to plan and control inventory in

2005 independent work cells?







Can the System provide for multiple facilities, warehouses,

2008 stockrooms, inventory locations?







Does the System have the capability to: receive, stock, disburse, and

2021 report on inventory by part number and location utilizing bar code?





Does the WAMS provide audit trail of all transactions by document

2023 number and part number?







Can the system automatically generate statistical and focus forecasts

2063 for the inventory?







Can the user run safety stock initialization/simulation reports from the

2065 proposed system?







Can the user set capacity allocation by contract/project in the

2107 proposed system?









2108 Is end-item alternative allocations supported by the system?







Does the proposed system support online allocation detail with

2109 pegging?









2110 Can the user perform manual override of allocations of shipping?









2111 Will the system flag parts below reorder points when allocated?









2113 Can the user Reallocate reserved inventory across orders?









2114 Can back order allocation show available inventory per location?









2115 Can back order allocation allow allocation of quantity by location?









2116 Can the user perform back order de-allocation?







Can the system perform an automatic de-allocation of inventory if

2117 order is rejected?







Can the system perform an inventory allocation as order is released

2118 for ALL orders?









2119 Can the user perform a material and capacity allocation?







Does the System have the ability to display resources/inventory

2121 availability by location online?







Does the System have a user-defined reservation criteria for

2123 sequencing/creating reservations?









2124 Can the system produce an order line status reservation?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 8 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D





Will the system support an automatic quantity reservation and ship

2125 date confirmation as orders are created?







Will the System support lot handling, oldest lot automatically default

2126 for order reservation?









2127 Will the System support reservation based on picking methods?







Does the system allow for automatic alternative sourcing if inventory is

2129 not available in the defined sourcing link?







Does the system display limits to specific warehouses, inventory

2130 allocations, lot numbers?









2131 Can the system produce shortage conditions reporting?









2132 Does the system allow for manual updates of inventory quantities?







Can the adjustment reason codes (i.e.: cycle count, poor quality) be

2133 assigned?







Does the system support a control number required to record

2134 inventory transaction?







Will the System have the ability to display the Inventory balance before

2135 adjustments and after adjustments?







Will the System allow for an audit trail of inventory adjustments for

2136 reporting?









2138 Can the System Create reorder notices via email or pop-up message?







Does the System have the ability to report overstock/under stock

2139 exceptions?







2140 Is the software architecture based on a relational DB design?







2141 Does the system have normalized tables?







2142 Does the application provide SQL APIs calls/data requests?







2143 Does the system support Multi-RDBMS portability?









Will the user be able to replicate database master files, fields,

2145 structures?







2146 Does the system supports Disaster Recovery Institute procedures?





Is the system structured with a common relational model for sharing

2157 data across multiple databases?





Does the proposed software interface to relational database

2158 structures?





Does the proposed software interface to system management or

2160 network configuration for automatic job execution?





Does the software support concurrent access to the data with data

2177 locking, check-in/check-out integrity mechanisms?





Can the system combine information from different databases or data

2182 sources in one query/report?





Does the WAMS support an end-user database environment

2200 designed for "what-if" modifications/queries?







2201 Does the system have denormalized read-only database tables?







2202 Does the system have a data effective rating?







2203 Can the system perform a data element time-sensitivity analysis?







2204 Will the user have SQL report writer query access?





Does the proposed system support external data warehousing tools

2205 and databases?





Does the system perform an automatic maintenance of a complete

2219 audit trail?





Does the system perform an automatic maintenance of a complete

2219 audit trail?







2220 Does the system perform an automatic maintenance of error logs?









2222 Will the WAMS accept input transactions in a continuous process?









2223 Will the WAMS support continuous data load?









2224 Will the WAMS support Multiple loads processed simultaneously?









Can the user perform internal data validation/error checking in the

2225 WAMS?









2226 Can the user conduct error file review and/or manipulation?









2227 Does the WAMS support data reprocessing?









2229 Does the software support RS-232 Communication protocol?









2229 Does the software support RS-232 Communication protocol?





Will the WAMS support the I/O driver interfaces to bar code readers,

2230 automatic ID devices, gauges?







2231 Will the WAMS support RF radio frequency/bar code readers?









Will the proposed system support data input/output from a pen-based

2232 system?









Will the proposed system support data input/output from a portable

2233 data terminal?









2234 Will the system support voice recognition?









Will the proposed system support data input/output from a touch

2235 screen?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 9 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D









2236 Does the proposed system support data input/output from a mouse?









2237 Does the proposed system support data input/output from a trackball?









Does the proposed system support data input/output from the

2239 keyboard?









2240 Does the proposed system support data input/output from a gauge?









2241 Does the proposed system support data input/output from a scanner?









2242 Does the WAMS support generalized codes validation tables?









2243 Can the WAMS produce master file audit reports?









2244 Can the user scroll and key word search displayed reports?









Can the user perform a system cross-reference of files, fields,

2245 programs, menus, messages?





Can the user set the bar code control character sequences for printing

2247 performed documents in the proposed system?









Does the WAMS have the ability to display standard messages and

2248 reason codes?









2249 Does the WAMS provide customized help windows?









2252 Does the WAMS provide user menus?









2253 Does the WAMS support operating system command options?







2254 Will the WAMS support database dumps and loading?









2255 Does the WAMS support archive history file reloads?







2266 Does the WAMS have customization and tailoring capabilities?







2267 Does the system have an API configuration tool?







2268 Does the system have an API program interface?







2269 Do you have a tool to build an interface?







2270 Are the WAMS screens pre-configured?









2274 Will you provide an administration toolkit?







2275 Will you provide a setup documentation?





Does the WAMS support templates to extend basic HTML with SQL

2276 functions?







2278 Does the software support a template generated web form?







2284 Can a user modify or customize a form?





Can the WAMS use dynamic SQL statements from all form inputs,

2288 URL strings and environment?





Does the software support a function for generating e-mail, based on

2290 HTML form input?







2291 Can the user input user-defined procedures?





Does the system have the capability to have simultaneous access to

2293 heterogeneous databases?





Seamless integration between application and OpenOffice desktop

2297 applications





Does the WAMS support an intuitive drag-and-drop tool for easily

2299 accessing ad hoc database information?





In the Web Interface, can the user read and write/modify data at a

2306 browser level?





In the Web Interface, can the user read and write/modify data at a

2306 browser level?







2314 Does the system conduct data integrity checks?







2317 Does the WAMS support Advanced Encryption Standard (AES) data?





Can the system assign a time data sequence number in each

2323 transaction?







2324 Does the system accept logins?







2327 Does the system have a remote agent for database access?





Does the system have the ability to transmit results from one database

2328 to another database?







2331 Will the system allow data merging from multiple sources?







2352 Does the system support S/MIME e-mail?







2354 Does the system support MIME e-mail?







2369 Does the user have the option of selecting a date format?





Does the WAMS support multiple date formats: month/date/year,

2378 day/month/year, year/month/day?





Does the software provide Integrated Development Environments

2405 (IDE)?







2411 Does the software provide Scripting Tools?







2412 Does the software provide Business Object Development?







2422 Does the software support Java?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 10 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D





2426 Does the software support XML?







2427 Does the software support HTML?



Will the software support automatic referential integrity check for

enforcing procedural controls and process rules for its workflow

2434 component?





Does the software have pre-loaded select process models (i.e.

2435 logistics)?





Does the software have pre-loaded select process models (i.e.

2436 supply chain)?





Does the software have pre-loaded select process models (i.e.

2437 customer care)?





Can you set up user-definable processes and process

2438 configurations?





Will the software allow the user to load processes from external

2439 sources?





Will the software the display of required process steps that the system

2440 must execute to complete procedures?





Does the system support importing and exporting of data? If so,

2453 describe the method.







2455 Are all system data selectable from look up tables or drop down lists?





Does the system support data grouping, which is used in reporting

2456 and configuration?





Will the system be capable of supporting multiple locations or sites in

2458 the organization?







2459 Does system maintenance require specialized IT support?





Can the Data input screens be customized such that unwanted fields

2462 can be hidden from specific users?







2463 Can all system labels be changed to local requirements?





Does the system support an audit trail that records details of all

2464 transactions?



Does the system have a comprehensive asset or equipment register

2466 that is capable of holding data on up to N assets?





Does the system support asset "cloning" or copying to speed data

2467 input?



Can the user link assets spare parts, such as standard o-ring as part

2468 of pump replacement?



Does the asset register support a hierarchical (Parent/Child) location

2469 structure?





Does the asset register provide adequate functionality for the control

2470 of safety documentation?



Does the asset register support the definition of equipment types, e.g.

2472 motors, compressors, etc?





Does the system support the input of unplanned work requests by non-

2473 maintenance personnel?





Is there an easy input option available to minimize training required for

2474 these personnel?









Is the system equipped with an approval protocol that allows work

2475 requests to be converted to work orders by authorizing personnel?









Does the system support automatic notification for work requests that

2476 are raised against assets that have safety issues?







2477 Is an e-mail facility available for work orders?







2478 Will the system allow the user to apply failure codes to work requests?









Does the system have the ability to send work request to different

locations? This is to accommodate sites that have maintenance

2479 personnel in different workshops.





Is there an easy input option for creating unplanned work orders (as

2480 opposed to unplanned work requests.)?









Does the system support retrospective work orders to ensure that all

2481 work history is captured?



Will the user have the ability to capture all required information

pertinent to the organization in the Work Order, such as safety

2482 documents, materials used, labor used, spares used, etc?







2483 Is the work order customizable to local requirements?





Does the System have the capability to scan the PM schedule to see

if any planned maintenance can be issued along with the unplanned

2484 work order?





Does the system support the use of follow-up work orders where

2485 equipment is put back in service with work still outstanding?





Does the application support your requirements with respect to work

2486 order status?







Can the user display outstanding work orders by status, location,

2487 asset, etc. should be a straightforward process?





Can Work Orders be tracked through the process by the person who

2488 initiated them?







2489 Are planned work orders easily scheduled and generated by users?





Can the user configure planned work order status and type (e.g.

2490 "open", "complete", "Safety", "PM", etc.)?







Does the system support all possible types of calendar based

2491 maintenance scheduling, including daily weekly, monthly, etc?



Does the WAMS have the capability to include a user-configurable

holiday calendar that can be set to prevent planned maintenance from

2492 being scheduled during holiday periods?







2493 Is the system flexible in its handling of PM tasks?





Does the system allow for the user to include required spares and

2494 resources on PM work orders?





Are the planned work schedule viewing options flexible enough to

allow different user to select and view PM for their area of

2495 responsibility?





Will the system allow forecasting of PMs for a selectable period in

2496 advance?





Will planned work generation be possible by individual areas or

2498 departments?





Do the system's planned maintenance routines have fixed and floating

2499 scheduling options?





Does the system's planned maintenance work orders support the

2500 inclusion of multiple crafts on one job?









2501 Does the system have the ability to track each crafts person's time?



Are operation-based work order generation supported? For example,

where PM's are generated according to run-time as opposed to

2502 calendar period.



Does the system support planned maintenance inspections? These

will require the capability of creating a PM without linking it to a single

2503 asset.







Is schedule balancing or rescheduling of PM work supported by the

2505 system?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 11 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D





Can inventory reorder points and max/min levels be set and managed

2507 within the System?









2508 Is the System equipped to locate spare parts multiple stockrooms?









2509 Will the System track spare part usage history?









2510 Can the System record and track material shelf life?







Does the System have the ability to track vendor records and lead

2511 time details?









2512 Will the System retain Issue history?









2514 Does the system support a facility to store images of stocked parts?







Will the System support stock reservations, where spares can be

2516 reserved for specific individuals, groups or work order?







Will the purchasing system integrate fully with the inventory Control

2518 system?









2519 Can an approved supplier listed be maintained in the System?









2520 Are automatic reorder of parts supported by the System?









2522 Does the System contain a purchasing module?









2523 Will the System allow users to check status of their orders?









2524 Can the System link a purchase order to an individual work order?









2526 Can the System accommodate bar coding of spares?









2527 Does the system have a maintenance project management tool?



Can the system track all costs, including contractors' costs, throughout

2528 the project life cycle?





Does the project management application provide for adequate

2529 description of the project and its activities?







2530 Does the application support sub-projects?





Does the application support activities, dependencies and other main

2531 project planning terms and functions?







2532 Does the application support reporting?





Is the application capable of producing work orders for individual

2533 project activities?





Can the employee salary and charge rate records be recorded in the

2537 system?







Can the user record issued tools, clothing and protective equipment in

2540 the proposed system?









2541 Can employee shift schedules be set in the proposed software?





Are the reports provided with the system comprehensive, quick and

2543 easy to run?





Are the vendor supplied reports customizable? If so, can they be

2545 saved as a different file?







2546 Will graphical reports be included?









Will the system contain a maintenance backlog and performance

2547 reports?





Are reports that facilitate continuous improvement effort (e.g. Pareto

2548 charting) included?





Does the WAMS support the creation of new reports to the user's

2549 requirements?





Is the system capable of handling any specific grounds maintenance

2557 issues?





Can the user raise and submit an unplanned work request for a

2565 breakdown event?

Please identify the diagramming techniques used by your firm to

illustrate the business processes that currently exist in the targeted

application environment. Flow charts, Data Flow Diagram, OO

2626 Diagram, and/or ER diagrams.



Will Rapid Prototyping techniques be used to let users preview key

functions to determine the data entry/inquiry/reporting formats most

2635 suitable to end user needs?

Is a local source of software support available for the vendor's

product? If yes, are the local support technicians employee's of the

2639 vendor or are they employees of a third party support group?



Does the vendor company fully support customized software

2641 developed by the vendors staff?



Will a Help Desk offering live telephone support be available during

2642 normal business hours for this system when live usage starts?

When onsite support is needed, what is the guaranteed response

time? Same day as initial call, next business day, same day as initial

2643 call, next business day, or as soon as possible (not defined).



Is a staff member dedicated to software support available during

2646 normal business hours?



Will a web site dedicated to ongoing support of the system be

2648 provided by the vendor?





2649 Is onsite training available during the installation of the software?







2650 Is onsite training available on an ongoing basis?







2651 Can the training be customized to meet the specific needs?





Are training manuals, i.e., software procedure manuals, provided

2652 during the training?







2654 Is field level on-line help available at all times?







2655 Is the on-line help customizable by the user without recompiling?





2657 Is the proposed system ISO 9000 certified?







2689 Are "thin-clients" fully supported by the proposed software?







2706 Is a dedicated server required?







2708 Is there any limit on the size of a single library?





Are any modifications to existing hardware required by the proposed

2709 system?







2710 If hardware changes are required please describe them here.







2712 Are mirrored disk supported? If yes, please describe.









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 12 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D





2717 Is transaction rollback function supported? If yes, please describe.







2723 Does the software support GIF - Graphical Interchange Format files?







2724 Does the software support DIF - Data Interchange Format?





Is the ODMA (Open Document Management API) standard supported

2725 by the proposed system?





Is the proposed software compliant with LDAP (Lightweight Directory

2727 Access Protocol)?







2730 Is the proposed software ODBC and JDBC compliant?





Please list the database servers the proposed software natively

2731 supports.

Will the next release of the proposed software require any data to be

converted to a format different than the format required by the current

2737 version of the proposed software?





Is the Architectural Orientation of the proposed software "Web-

2738 centric"?



Is the proposed software web-centric? If so, when was it first released

2739 with a "web-centric" architecture?









2743 Can users search the document database by keyword?









Can users search the document database by Boolean command

2744 string?









Can users search for documents by keyword and Boolean commands

2745 simultaneously?





Is it possible for a user to quickly change which data is displayed in

2746 the results of an inquiry or search?







Is it possible for an user to attach a hardcopy document to a existing

document by scanning the document, then setting up a link to the

2747 document scan image from the document maintenance screen?





Is it possible for a user to attach an e-mail to an existing document by

2748 setting up a link to the e-mail from the document maintenance screen?









2749 Can users search the attached documents or e-mails?





Can users easily view a hot list of recently performed searches and

2750 reuse them if desired?





If the proposed software provides for user-defined fields, can online

2755 help related to each individual field be created?



Are DETAILED error messages that enable the user to identify and

correct the problem causing the error provided by the proposed

2756 software?





Does the proposed software provide the ability for an authorized user

2757 to access and use customize screens and menu?





Does the proposed software provide the ability for an authorized user

2758 to customize screens?







2763 Does the proposed software support code tables?



Can terminology appearing in on-screen Field Labels be customized?

For example, can "staff" be changed to "technician" in all appropriate

2764 on-screen Field Labels?



Can terminology appearing in on-screen text boxes be customized?

For example, can "staff" be changed to "technician" in all appropriate

2765 Text Boxes?



Can terminology appearing in on-screen Drop-Down Boxes be

customized? For example, can "staff" be changed to "technician" in

2766 all appropriate Drop-Down Boxes?



Can terminology appearing in Screen Captions be customized? For

example, can "staff" be changed to "technician" in all appropriate

2767 Screen Captions?



Can terminology appearing in Screen Displays be customized? For

example, can "staff" be changed to "technician" in all appropriate

2768 Screen Displays?



If the proposed software provides user defined fields, does it allow a

user with proper clearance to designate the input validation rules used

2769 to validate data entered into the field?



If the proposed software provides user defined fields, does it allow a

user with proper clearance to designate the Field Label displayed on-

2770 screen to describe the field?



If the proposed software provides user defined fields, does it allow a

user with proper clearance to designate the allowable Field Data Type

2771 (numeric, binary, etc.)?



If the proposed software provides user defined fields, does it allow a

user with proper clearance to designate the input validation rules used

2772 to validate data entered into the field?



If the proposed software provides user defined fields, does it allow a

user with proper clearance to designate Drop-Down Lists containing

2773 the entries valid for each field?







2775 Can the online Help be modified by a user with proper clearance?





Does the proposed software enable an authorized user to specify the

2779 business process rules to be used?



Is a graphical flowcharting tool made available to the user for creation

of business process rules and work flow using a "drag and drop"

2780 action?







2784 Can the document management features be accessed via OLE?







2785 Can the proposed system function as a DDE Server?







2786 Can the proposed software function as a DDE Client?









Are discrete document resources such as graphic files, fonts, etc.,

2787 tracked automatically?





What level of integration is provided, NONE, ONE WAY, or TWO

2789 WAY?







2792 Can storage locations be defined based on user/document type?



Is a collection of standard, published, and fully documented

Application Programming Interface's provided with the proposed

2798 software?





Is a collection of standard, published, and fully documented XML

2799 Object's) provided with the proposed software?



Can applications provided by others be easily integrated with the

proposed software through a standard, documented Application

2800 Programming Interface (API) collection?





Do the standard APIs and XML Objects provided with the proposed

2801 software enable full integration with third party ERP systems?







2806 Is a SOAP API provided by the proposed system?









Have you integrated any 3rd party ERP applications with the proposed

2808 software? If so, please list.





Is the Web interface enabled through CGI programming, user-defined

2811 HTML templates, or a proprietary high-level scripting language?



Which of the following Knowledge Database functions are provided?

Task Standards Library, Troubleshooting Guides, and Procedure

2822 Library:





Are any of the following equipment management functions provided?

Equipment listing, specification & parts list for equipment, and tool

2825 management.







Are planning and scheduling of maintenance management functions

2830 provided? If yes, describe the major features and processes.





Is maintenance budgeting of maintenance management activities

2832 provided? if yes, describe the major features and processes.









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 13 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D



Are maintenance management requirements forecasting provided? if

2833 yes, describe the major features and processes.





Is predictive maintenance management functions provided? if yes,

2834 describe the major features and processes.





Is inspection scheduling provided? if yes, describe the major features

2835 and processes.



Is the management of hazardous materials included in the inventory

management function? If yes, please describe the processes and

2836 functions?





2845 Are the equipment management cost history report provided?









Are the equipment list and specification accessible through the

2847 maintenance management systems?





Are the following equipment management and daily processing

functions supported? Equipment. Bill-of-Materials? Equipment

2849 specific repair log? Is repair cause tracking provided?



Can the work order management system complete an equipment

2852 downtime analysis and report?







Are multiple and simultaneous scheduling parameters supported in

2853 the maintenance scheduling features?





Are PM costs automatically accumulated in the appropriate category

2854 or account?









2855 Are the PM schedule settings displayed on-screen for reference?





Can the maintenance management system generate and schedule

2856 recurring work orders?







2857 Are detailed task descriptions available on Work Orders and reports?









2858 Can PM be scheduled in response to downtime or outage situations?







2859 Are PM schedule compliance (adherence) statistics tracked?





Are service contracts for work orders supported? If yes, please

2862 describe.





Describe how warranty claims development and management is

2863 supported.







Are inventory processing and management features provided for

2864 multiple locations and stores?







Does the inventory processing and management system track tools

2865 and equipment?







Does the inventory processing and management features include

2866 where used reporting?







Does the inventory processing and management provided a pick list

2867 of the current open work orders?







Are each stores inventory counts automatically updated when Work

2868 Orders are processed?





Can the work order management system report the status of all Work

2869 Orders?









2870 Is automatic Work Order Backlog Reporting provided?







2871 Are automatically generated Work Order Cost Estimates provided?





Is a Work Order Cost History maintained and available for reporting

2872 purposes?





Can the work order management system provide on-line, real-time

2874 parts availability and reservation?







2875 Can Work Orders be ranked, and assigned, based on priority?







2877 Is employee availability and scheduling provided?







Can the work order management system define the current and past

2878 employee utilization?





Are all parts and equipment represented in a Warranty tracking

2880 function?









2884 Service call management and transaction processing?









2887 Are inventory records for new purchase items created automatically?





Can the proposed system act as a Web-enabled Services platform to

2898 request, broker, and deliver Web services?





Does the proposed software provide a "point and click" wizards for

2911 management reporting function?





Is a rules editor to enhance or modify the rules engine provided by the

2912 proposed system?





Can the proposed system be customized via XML without any

2914 programming skills?

Does the proposed software enable the creation of multiple user

interfaces to process information? For example, could each

department manager set the user interface to display the information

2915 commonly accessed by his/her department?



Does the proposed software provide a predefined facility for routing

work to those entities (people or systems) with the least amount of

2918 current work?



Are advanced search functions for easily searching for and retrieving

specific process and system related data provided by the proposed

2923 software?



Does the proposed system's "control panel" screen allow an

authorized user to access operational areas such as: Access new

work for processing, start existing processes, monitor process

2925 performance, view the status of existing processes, generate/view rep



Does the proposed system's "control panel" screen allow an

authorized user to access administrative areas to deploy new

2934 processes?



Does the proposed system's "control panel" screen allow an

authorized user to access administrative areas to create supporting

2935 electronic forms for new or existing processes?



Does the proposed system's "control panel" screen allow an

authorized user to access administrative areas to manage user

2936 privileges, manage user roles or manage security?



Is a graphical flowcharting tool made available to the user for creation

of business process rules and work flow using a "drag and drop"

2940 action?



Does the proposed software provide the ability to setup timers and

alarms, within the work flow process being defined, to alert users of

2941 impending deadlines?





Is a graphical, drag & drop, point & click design work flow modeling

2942 environment provided by the proposed software?





Does the proposed software's process design facility use "check-

2943 in/check-out" rules to ensure work flow design integrity?

Does the proposed system provide built-in property editors to

configure automatic activity information such as: Business rules,

escalation rules, routing logic, actors, actions, deadlines, and priority

2944 levels?



Does the proposed system provide built-in property editors to

configure rules governing manual activity in the following areas:

2951 Business rules and escalation rules?



Does the proposed system provide built-in property editors to

configure rules governing manual activity in the following areas:

2952 Routing logic, Actors, Actions, Deadlines, and Priority levels?



Does the proposed system provide built-in property editors to

configure rules governing manual activity in the following areas:

2952 Routing logic, Actors, Actions, Deadlines, and Priority levels?





Are predefined, built-in tasks provided by the proposed software for

2958 looping and branching work flows?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 14 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D



Are predefined, built-in tasks provided by the proposed software for E-

2960 mail?





Can the work flow needed to address errors and omissions be

2962 modeled using the proposed software?





Does the proposed system provide the ability to embed exception

2963 handling processes into the work flow being defined?





Does the proposed system enable modeling multiple escalation work

2964 flows based on problem type?





Is parameterized e-mail creation and use fully supported by the

2965 proposed software?





Is a full work flow simulation capability provided by the proposed

2966 software?



Indicate which of the following actions can be triggered by another

system's time-out/failure codes: Fail over processes, Alerts, Rules-

2975 based events, Retransmissions, Queries, and Escalations.





Can third-party time-out and failure codes be used by the proposed

2981 software to configure the user interfaces?





Can third-party time-out and failure codes by used by the proposed

2982 software in reports?





Can third-party time-out and failure codes by used by the proposed

2983 software in GIS maps?





Does the proposed system support dynamic process variables that

2985 provide real-time stat change as the work flow progresses?





Can the proposed software utilize electronic forms created by third-

2995 party applications?



Please indicate which of the following can create forms compatible

and usable by the proposed system: OpenOffice, Word, Excel,

2996 Adobe.



Is a forms design function for creating interactive electronic forms, to

be accessed by work flow participants, provided by the proposed

3000 system?







3001 Can the forms designer create new forms?





Can the forms designer utilize forms created by a third-party

3002 application?





Can the forms designer add intelligent functionality for data pre-

3003 population to new or existing forms?





Can the forms designer add math calculation functionality to new or

3005 existing forms?





Can the forms designer add drop-down list functionality to new or

3006 existing forms?





Can the forms designer add check box functionality to new or existing

3007 forms?





Does the proposed software provide the ability to define rules that

3008 split the execution path of a process into two or more parallel paths?





Can the separate paths of a specific process be joined at a specific

3009 point?





Can data from each path be merged together (consolidated into a

3010 single document)?





Can a process with multiple starting and ending points be defined

3011 using the proposed software?





Can the same process be ended in multiple ways, using different sub-

3018 processes based on a given value?







3019 Does the proposed software provide facilities for ad-hoc routing?





Does the software provide the ability to select desired information

3020 recipient's) from a predefined drop-down list?



Please indicate with a YES response if the following can be used as a

recipient in an ad-hoc routing situation: Users, Departments, Positions

3021 (roles), and Groups.





Can the proposed software detect external events and then initiate

3025 and/or complete a specified process?





Can the proposed software launch another application in reaction to a

3031 specified event?

Does the proposed software provide predefined process modeling

tools for including manual activities such as decision making, data

entry, information review, and other activities requiring human

3032 intervention?





Can an electronic form be setup to appear at each manual activity in

3035 the work flow process definition?





Can a specific application be setup to be launched (executed) at each

3036 manual activity in the work flow process definition?





Can a priority be assigned to a manual activity within a specific work

3038 flow?





Can a priority be assigned specific relative deadline (cycle time) within

3039 a specific work flow?





Can a priority be assigned an expiration deadline within a specific work

3040 flow?







3041 Can a manual activity reminder be setup within a specific work flow?





Can a priority be assigned a specific escalation action after a deadline

3042 or expiration date has passed, within a specific work flow?







3043 Are nested processes fully supported by the proposed software?





Can department-level processes be embedded into larger, entity-wide

3044 processes?





Can a higher-level (parent) process pass its variables to its embedded

3045 sub-processes?





Can a parent process pass its attachments to its embedded sub-

3046 processes?





Can a higher-level (parent) process pass its comments to its

3047 embedded sub-processes?





Does the proposed software support nested procedures even across

3048 multiple server clusters?





Can the proposed software access and utilize information from LDAP

3049 compliant systems?





Can the proposed system provide functionality that can be easily

3052 embedded in a Web or intranet portal?









Can the proposed system fully support and enable integration with

3061 American Data Group's financial systems?





List any other systems the proposed system fully supports and

3062 enables integration with.







3064 Does the proposed system fully support Linux database products?







3067 Does the proposed software fully support MySQL for Linux?









Please list any other document management systems that are

3073 compatible with and fully supported by the proposed software:





Using the proposed system, can authorized users take advantage of

3080 graphical process monitoring to view the status of work in progress?

Are graphical icons used to show the status and execution path of a

work flow process at any time? Please indicate which of the following

process are provided: Date & Time Received, Status, Urgency,

3081 Priority, Date & Time Due, Who is working on it current



Are the following types of reports provided ready-to-use with the

proposed software? Status, Throughput Analysis, and Ad-hoc

3094 Search Analysis





Does the proposed software enable users to "drill down" from a high-

3097 level process view to the individual activity detail level?





Can the proposed software interface with and utilize OpenOffice

3100 spreadsheets at specified points within a given work flow process?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 15 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D



Can the proposed software interface with and utilize any OLAP tool at

3102 specified points within a given work flow process?







3103 Can the proposed software export process data to OLAP tools?



Can a new work flow process be published in "test" mode for

simulation of the work flow process flow and to obtain benchmark

3104 statistics?



Does the proposed system's security function provide the following

GROUP restrictions? No Access rights? Read Only rights? Edit

3118 rights? See Filename Only?





Does the proposed system provide default user group settings to help

3138 speed up initial system implementation?



When using the proposed system, are process participants able to

see only what their security privileges enable them to see (participants

3140 see only what they need to perform their activities)?



Does the proposed software provide any features or functions

designed to minimum the risk of collaboration beyond the firewall? If

3146 YES, please explain in more detail:



Is a local source of software support available for the vendor's

3148 product?





3149 Are the local support technicians employee's of the vendor?



Does the vendor company fully support customized software that it

3150 develops for a customer?



Will a Help Desk offering live telephone support be available during

3151 normal business hours for this system when live usage starts?





3153 Is a Web site dedicated to interactive Help Desk functions available?



Will a web site dedicated to ongoing support of the system be

3154 provided by the vendor?



Is a staff member dedicated to software support available during

3158 normal business hours?





3159 Is support available 24 hours/day, 7 days/week?







3160 Is onsite training available during the installation of the software?







3161 Is onsite training available on an ongoing basis?





Can the training be customized to meet the needs of this specific

3162 client?





Are training manuals, i.e., software procedure manuals, provided

3163 during the training?







3164 Is on-line HELP available at the screen level?







3164 Is on-line HELP available at the screen level?







3166 Is the on-line help customizable by the user without recompiling?





Does the system provide dynamic listings of valid codes or text

3167 choices at each point where they are used?





3168 Is Annual Maintenance included?



Are new system releases available to existing users at an upgrade fee

3169 only?





3171 Are remote diagnostics offered?







3173 Are disaster recovery services available?







3178 How many users will the proposed system support concurrently?







3179 Is the proposed software licensed by number of concurrent users?







3180 Is the proposed software licensed by number of total user seats?







3188 Is any onsite installation assistance available?







3190 Is system training available?







3191 Is Customized Training, tailored to organization schedules, offered?







3192 Is any Onsite training available?







3193 What Offsite training is available?







3194 Are user training aids available on the World Wide Web?







3195 List the URL of any Web-based training.







3196 Are any tutorial disks or programs available for training?







3197 Are any Audio Visual training aids offered?





3199 Is a 12 Month Warranty offered?





Is Full documentation for all software and hardware components

3201 provided?



Are any electronic bulletin boards offered to help keep users abreast

3202 of late breaking information?





3203 Is a Help Hot Line telephone number maintained?



Is remote access via modem available to technical support

3204 personnel?







3206 Is this training done on an individual "one on one" basis?









3207 Is this training done on a group basis?





Will any printed documentation specific to this installation be

3208 distributed during training?









3213 Identify all the document types (file types) that should be supported.









Identify how the document types (file types) that should be supported

3214 are routed.





Can a predefined work flow structure (template) be created by the

3218 user and can be used to actually move data between processes?





Can a predefined work flow structure (template) be created by the

3219 user based on a "rules based engine"?





Can a predefined work flow structure (template) be created by the

3220 user?



Is unstructured work flow that allows the user to control which

documents go where, using image e-mail and user mailboxes,

3221 permitted?









Can file names be automatically assigned to documents as they are

3226 created?









Can documents be relocated to different directories by the proposed

3228 software?









3231 Are the documents currently open listed by user?









3235 Will the system list all documents formally checked out" by user?"









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 16 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D









Is the original version of the document automatically removed from the

3237 system?









3238 Does the system remove references to the original document?









Is the original document automatically backed up by the proposed

3239 software, or is it overwritten by the new version?





Is there a limit to how many versions of the system that can be

3240 simultaneously tracked?









Are tracking facilities available for tracking subversions of a

3242 document?









3243 Can multiple versions of a document be created? If so, how many?









Do work flow permissions override document management

3251 permissions for a specific document?









Are documents still accessible when being worked on by a work flow

3252 task?









3254 Can work flow processes span across multiple document libraries?







3255 Can a deadline be assigned to each task in a work flow process?







3256 Is a full audit trail available for each task in a work flow process?







3257 Can parallel work flows that converge be created?



Ability to store the following inventory parts information: Part ID, part

name, received unit of measure, stored unit of measure, description,

location, calculated average cost, part name, minimum quantity,

3258 quantity on order, quantity in stock, quantity







Does the System have the ability to automatically inform the user that

3278 an inventory minimum stock level has been reached?







Does the System have the ability to automatically inform the user that

3287 an inventory minimum stock level has been reached?



Does the System have the ability to generate a list of all transactions

associated with an individual part which at a minimum would include:

Part ID, Quantity, User ID,Date and time stamp, Type of transaction,

3290 Location removed from, and Location transferred



Ability to include vendor information: No Access rights? Read Only

3297 rights? Edit rights?







Can the System include as many vendors as required to be

3307 associated with a part?



Does the System have the ability to include manufacturer information:

Name, address, telephone number, contact name, 2nd contact name,

fax number, pager numbers, cell phone numbers, e-mail addresses,

3308 and web site URL?







Can the System include as many manufacturers as required to be

3318 associated with a part?







Does the System have the ability to identify and assign locations within

3319 a warehouse for storing inventory?









3320 Does the system have the capability to include bin management?



Does the system have a Scrap Routine which will allow inventory to

be listed as scrap, if damaged, and not be added to the inventory

availability list? The routine will track scrapped inventory items and

3321 record when they are removed for use.





Does the software provide the ability for the user to visually identify

3323 fields that must be completed during data entry for all screens?





Does the WAMS have the ability to display a pop-up calendar in date

3324 fields?



Does the software have the ability for free format fields to use data

processing functions such as word wrap, spell check, cut copy and

3326 paste.





Does the WAMS have the ability to use data validation functionality for

3327 all non free format data fields.?



Does the WAMS have the ability to create edit masks for asset ID

data entry fields? For example, ability to enter AB127657 which is

3328 displayed as AB-127-657.



Does the software have the ability to use an on-line help system that

will allow the user to display help information for all screens and data

3329 fields?





Does the software have the ability to customize the on-line help

3330 screens to display specific user information?





Does the software have the ability to navigate between modules

3332 without leaving the system?





Can the WAMS include user definable fields that can be named by the

3334 user?





Does the system have the ability to integrate with a mapping front-end

3335 so that a user can drill down from the map into the WAMS system?



Does the system have the ability to select an infrastructure asset from

the WAMS inventory and automatically display a map with the asset

3336 identified?





Does the system have the ability to select WAMS data to be displayed

3337 on the GIS screen?





Does the system have the ability to create work orders directly from

3338 the WAMS when on GIS screen?

Does the system have the ability to select an area on the map, select

an asset type and generate a work order for all the appropriate assets

with the selected boundary. The work order will then be treated as if it

3339 was created in the WAMS?





Does the system have the ability to synchronize/coordinate the WAMS

3340 and GIS databases?





Does the system have the ability to generate a map with a work order

3341 from within the WAMS?





Does the system have the ability to map work order status (open,

3342 closed) appropriately position with the asset on a map display?





Does the system have the ability to push selected WAMS features to

3343 the GIS for map display of features selected in the WAMS?







Can the System store, display and list all transactions associated with

3363 a part?





Does the WAMS have the ability to automatically generate a

3364 transaction description line for each parts transaction?







Can the System retain all transactions as history against each part and

3365 display historical transactions in a secure (non-changeable) screen?





Does the proposed system have the ability to store, track and update

3366 equipment specific parts lists?









3367 Can the System store and track unit costs for each part?







Does the System have the ability to define any type of facility or rolling

3369 stock as an inventory stock location?





Will the System include vendor information: name, address, telephone

#, contact name, 2nd contact name, fax, pager #, cell # and e-mail

3374 addresses?







Does the System have the ability to include as many vendors as

3375 required with a part?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 17 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D





3383 Does the system support printing of bar code labels?







Can the System print physical inventory counting sheets by location to

3384 the bin level?







Does the System have the ability to transfer parts between storage

3385 locations?







Can the System recommend alternative parts and locations based on

3389 work order reservations?





Does the proposed system have the ability to create pick lists of parts,

3390 tools and materials based on work order requirements?





Does the System have the ability to generate an internal purchase

request for parts to be ordered based on reaching a minimum stock

3391 level?







Will the System allow one purchase order to distribute material to

3394 multiple receiving locations?





Does the system have the ability to update unit price based on

3396 purchase order?









3398 Does the System have the ability to track items on back order?







Does the System allow for the creation of user defined requisition and

3399 purchase order numbering?







Does the System have the ability to track and report purchase order

3401 information?





Can the user record multiple labor, parts, material and miscellaneous

3402 costs directly to the work order?





Does the system have the ability to include comments for each work

3403 order task?







3404 Will the user have the ability to group work orders as a project?







Does the system have the ability to reassign work orders to another

3405 crew as required?





Does the proposed system allow the user to group assets for work on

3406 the same work order?







Does the system have the ability to assign employees to more than

3407 one crew?





Does the proposed system have the ability to include contract

3408 services as a separate cost item?







Can the System automatically reverse any parts or material

3410 reservations for a canceled work order?





Does the system have the ability to query the status of any work order

3411 by various query criteria, incl. dates, asset id, etc?



Does the system have the ability to associate documents and images

with a work order? Must have the ability to have them printed with the

3412 work order if required?



Does the system have the ability to roll-up cost information based on

3413 labor, equipment, parts and any other category required by the user?







Does the system have the ability to cancel a work order at any stage of

3414 the work order life cycle?





Does the system have the ability to route a work order to any crew

3415 field device, office printer, or e-mail?





Does the system have the ability to display backlogged work orders by

various selection criteria including: crew, priority, date opened and

3416 estimated completion date?





Does the WAMS have the ability to create user defined status and

3417 priority codes for use in a work order?



Does the system have the ability to distribute historical linear work

order information to each affected segment if an asset is split into one

3418 or more sections?





Does the system have the ability to distribute asset characteristic

3419 information with a work order if required?







Does the proposed system have the ability to change the status and

3420 priority of a work order?





Does the system have the ability to provide notification of duplicate

3421 work orders for the same asset?





Does the system have the ability to notify if work orders are

3422 outstanding for an asset when a new work order is requested?



Can the system provide notification if a PM is due, within a user

defined period, for an asset where a new work order has been

3423 requested?







3424 Does the system have the ability to create benchmark work orders?





Does the system have the ability to display and print special

3425 Instructions associated with a work order?



Does the system support the following fields available on the work

order screen: Asset ID and type, Date fields (include: initiated,

assigned, started, completed, closed), Maintenance type (scheduled,

3426 PM, emergency), Priority, Problem code and description





Does the system have the ability to allow additions to a scheduled

3438 work order after the work has started?







Does the system have the ability to analyze, develop and create

3439 resource scheduling and work load leveling?







Does the system have the ability to create crew/employee calendars

3440 based on the resource scheduling results?



Does the system have the ability to allow scheduled work to be

adjusted based on specific conditions such as daily weather

3441 conditions or the season?





Does the system have the ability to make global changes to

scheduled work orders such as reassigning a group of work orders to

3442 a new crew?





Does the proposed system have the ability to easily (drag and drop

functionality) assign available resources, parts and materials for WO

3443 scheduling/dispatching?





Does the system have the ability to reassign incomplete work orders

3444 to a new crew?





Does the system have the ability to change and delete work orders on

3445 the schedule?





Does the system have the ability to select multiple work orders for

3446 closing/completion?





Does the system have the ability to identify a work order task as

3447 complete or closed without closing the whole work order?





Does the system have the ability to reopen a closed work order to add

3449 comments & new information, apply corrections, and update costs?





Does the System have the ability to automatically reduce the quantity

on hand for any spare part used by a work order, if the spare parts

3450 function is used?





Does the system have the ability to transfer work order history with an

3451 asset if the asset address/location is changed?





Does the system have the ability to display a list of daily, weekly or

monthly work that will allow the work orders to be assigned to a crew or

3453 person?



Does the system have the ability to include an estimated time for

completion that can be used to compare to the actual time for

3454 completion?







Does the proposed system have the ability to display backlogged

3455 PMs by various selection criteria?





Does the WAMS have the ability to create a named benchmark

3456 (template) PM that can be used to create any new similar PM?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 18 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D



Does the system have the ability to change existing named PM

3457 definitions as required?









Does the system have the ability to include seasonal holds as a rule

3458 for the generation of a PM?





Does the system have the ability to automatically issue advanced

3459 reminders to the appropriate user of pending PM's?





Does the system have the ability to create one or more work orders

3460 from a PM for a set of assets requiring the same activity?



Does the WAMS have the ability to distribute maintenance history and

3461 costs to individual assets covered by a group asset PM?







Does the system have the ability to hold a PM until it is released into

3462 the normal scheduling routine?









Does the system have the ability to automatically review existing work

3463 orders before a PM is generated to ensure work is not duplicated?





Does the system have the ability to handle the overlap of PM

schedules (example monthly and quarterly) that are due at the same

3464 time?





Does the system have the ability to assign a PM schedule to a

crew/employee prior to the work order being generated so that work

3465 load leveling process can be performed?



Does the system have the ability to set a PM schedule by various

methods such as: fixed number of days; fixed schedule (e.g. every

3466 Monday); usage (e.g. every 1,000 hours of run time)?

Does the WAMS have the ability to identify an asset either by a single

unique alphanumeric identifier or by a pair of alphanumeric identifiers

where a linear asset is being entered into the system? (ex: by

3467 upstream manhole or downstream manhole)









Does the System have the ability to automatically detect, indicate and

3468 reject duplicate asset inventory numbers being generated?



Does the WAMS have the ability to enter a linear asset inventory ID

and for the system to display associated upstream and downstream

3470 assets?

Does the WAMS have the ability to enter a partial linear inventory

asset number then display all asset segments starting with the partially

entered information? (i.e. does the system have AutoComplete Data

3471 function?)



Does the WAMS have the ability to distribute historical linear inventory

asset information to each affected segment if an asset is split into one

3472 or more sections?







Will the user have the ability to attach and view electronic documents

(graphic, video & audio) to any asset inventory record? Please list

3473 available electronic formats.





Does the WAMS have the ability to perform asset hierarchy cost roll-

3474 up?





Does the WAMS have the ability to enter all equipment specification

3475 nameplate data?



Will the user be able to copy characteristic features of an asset or a

3476 hierarchical asset group to expedite the creation of new assets?





Does the system have the ability to manage the process of tracking,

3477 notification, and requirements of manufacturer warranties?



Does the WAMS have the ability to add new asset inventory types as

3478 required?



Does the WAMS have the ability to manage equipment usage

information. For example, is usage based on readings or cycle

3479 counts?





Will the WAMS allow safety messages based on equipment ID or

3480 equipment type?





Does the WAMS have the ability to track ownership of individual asset

3482 items?





Does the WAMS have the ability to attach one or more addresses to

3483 any asset?





Does the WAMS have the ability to set up Bills of Material for an

3484 asset?



Does the WAMS have the ability to associated permit information with

3485 an asset?





Does the WAMS have the ability to use user defined fields for an

3486 asset so that specific information can be included?

Does the WAMS have the ability to drill down and display, from the

asset record, specific transactions such as work orders, PMs and

costs. Asset ID, Serial number, Asset type, Size, Depth,

3487 Install/remove dates, Service status (e.g. in-service, out-of-service)







3517 Does the WAMS support Equipment details?







3528 Does the WAMS support Sewer Main Line data?







3529 Does the WAMS support Manhole data?







3544 Does the WAMS support Electrical Conduit data?







3545 Does the WAMS support Building data?







3546 Does the WAMS support Building equipment details?





Does the WAMS support structural details, such as, type, height,

3550 length, end treatment?



Does the software have the ability to create packages of documents

for routing and approval? This includes work requests/orders as well

3556 as documents.





Does the software allow the user to route, track, index and check the

3557 status of document approvals such as requisition orders?

Will the WAMS provide an extensive set of standard reports that need

only be chosen by the user with selection criteria (e.g. asset ID, date

ranges, etc.) to provide comprehensive asset and maintenance

3558 information?





Does the software have the ability to send report results to screen,

3559 printer, file or e-mail?







Can the System provide an easy to use ad hoc reporting tool as part

3560 of the system?





Does the software have the ability to store the ad-hoc report selection

3561 criteria for future use.





Will the ad-hoc report generator be mapped to the system fields and

3562 tables so no user integration process is required?





Does the WAMS have the ability to create, sort and store query

3564 selection criteria?





Does the WAMS have the ability to modify stored query selection

3566 criteria?





Does the WAMS have the ability export query results to standard

3567 format applications such as OpenOffice?





Does the WAMS have the ability to review all reports before they are

3568 printed?



Does the WAMS have the ability to store, track and update employee

records such as: Certifications/licenses held & required, training taken

3569 & required, and immunization renewal dates?







Does the WAMS have the ability to update asset or work order related

drawings and schematics to reflect equipment modifications that have

3572 been made?









Does the WAMS have the ability to query asset and work order related

3573 documents and images?



Does the WAMS have the ability to view and attach web addresses

and include them as part of a work order or attach them to inventory or

3574 inspection records?







Does the WAMS have the ability to embed electronic documents

(graphics, video) to any asset or work order records and then print as

3575 required?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 19 of 20 1/16/2012

City of Largo WAMS Software Requirements









Req_I Questions Proposer Response Additional Comments

D









Will the proposed software provide revision and version control of all

3576 documents?









Does the WAMS support multiple document types such as word

3577 processing, spreadsheets, CAD and graphics applications?









3578 Will the system allow documents to be used in their native form?









a85d3fb1-280c-4091-bb9b-f3350a8e2a38.xls 20 of 20 1/16/2012