When we do demonstrations of our safety Forms and Recordkeeping component, we often get asked about what data gets stored with each record, and what reports (or queries) can be run later. This post is meant to explain the functionality that is within our software, what we have in the works, and what functionality is NOT available in the system that you will need to look elsewhere to compliment the Safety Management System.
The SafetySync recordkeeping module allows you to store the following information (and thus later query):
- Record Type (from list of Forms)
- Filled In By (from list of Employees)
- Job # (a simple text field)
- Location (from a list of Locations in the system or "Other"-which allows text to be entered)
- Deficiencies (problem discovered, corrective action required, priority level, assignment, due date)
We are currently working on functionality that will also allow you to track (and later query):
- Equipment # (from a list of Assets/Equipment)
The sorts of reports you can
therefore run in the system would include:
- A list of Emergency Drills that were performed in the Edmonton last month (with links to the source record)
- A list of Hazard IDs that had one or more deficiencies discovered by Joe Blow (with links)
- A list of all Safety Meetings performed on job # 12345
- A list of all Inspections that were done on Tank A
- A list of all records that had deficiencies with the string "trip hazard" in them
- A list of all records that had priority levels that were "Critical"
What our forms and recordkeeping system cannot
do, is delve into the data that is contained within each record:
- A list of Inspections that identified a pressure reading of 120psi on Pump B
- A list of Safety Meetings which Bob, Joanne and Dave attended
- A list of Emergency Drills that were completed in 2 minutes or less
- And so on...
In order to accomplish the latter, we highly recommend a field data capturing system, along the lines of what Spira Data Corp
. offers with their Spira Mobile
product. I have worked with this product in the past and it is extremely flexible and robust, allowing companies to manage accounting, inventory, payroll (and yes even safety data). Each form in Spira is no longer a piece of paper or an Excel spreadsheet, but an actual data capture tool that later synchronizes all the fields on the form to a database back end. You can then query and report on any or all the fields on the form. The form will take longer to build than a simple spreadsheet, but it will populate back-end systems like those used for invoicing and payroll.
The other advantage of Spira Mobile, is that it allows you to easily take the forms "offline" when there is no Internet connection available. With our software you may occasionally have to print paper copies of certain forms or save them on the hard drive of a laptop or handheld, to be completed and later emailed, faxed or uploaded back to SafetySync. Spira Mobile takes care of the synchronization automatically.
Spira comes at a cost, but if an organization spends enough time compiling and reporting on data captured in the field, it can be a huge time saver. Many implementations can pay for themselves in less than a year. Field data capture for work orders (or field tickets as they are sometimes called) is their specialization. The return on investment for the forms that initiate the invoicing process are largest because they can significantly shorten your billing cycle (thereby improving your cash flow), and because lost forms or re-keying mistakes can cost the company revenue. Unfortunately, capturing data on safety forms does not have these same benefits, so the business case is somewhat harder to justify.
If you like the data-capturing functionality offered by the Spira Mobile product, and would like to integrate it with the rest of your safety management system in SafetySync, contact our customer support
, or the folks at Spira