We have 20,000 safety analysis documents written by hand by employees before they carry out dangerous work. We will input these.
We want to automate the process so users can enter new job analysis docs and also look at the old docs currently hand written but to be loaded into this system by us.
Documents would be linked to assets then probably 6 layers of child assets.
Example Vehicle - Toyota 4wd - registration number - tyres - null - null
Example Site Name - Process Plant - Crusher - Crusher 301 - Crusher gearbox - null
So click on vehicles then Toyota 4wd then registration number then tyres - then populate the input form asset details - maybe a concatenated string?
I have previously written larger programs in access so can set up the relationships and tables easily enough but have no experience with SQL and web design.
The safety analysis docs have from 1 to several hundred steps with each step a work task - these tasks are then checked for any hazards and controls are put in place to stop the hazards.
For example one step may be Step 3 Undo and remove pulley guard
The inputter then needs to be able to select from hazards for this task (separate tables)
A list of all parent hazards are shown - the user selects the hazards parent and the hazards child opens - select the hazards child and both hazard parent and hazard child are used to populate the form.
Example of hazards for this task - Heavy Lift (hazards parent) opens hazards child where all heavy lifting hazards are reviewed - ie crane lift, block and tackle, two person lift (all filled out later)
The hazards selected then open a controls table related to the child hazard or parent hazard. Example may be Hazard Child - Crane Lift - controls - use correct lifting gear and licensed crane driver. May be several controls for one hazard and these need to be selected and populate the form.
There also may be several hazards for each work task.
So the work task is one field, the hazard (from hazards table) is another and the controls from the Controls table is another. Controls are reliant or linked to hazards.
Each document also needs a description, asset or asset child selected from tables, name of person filling out the document, date and the ability to print out.
This is a very basic overview.
Would want web based and suited to mobile phone users as well.
I understand this is a very basic overview and I have not as yet sat down and drawn up the tables and relationships needed.
So we want to be able to add new work analysis documents but look at all te old ones to ensure we are capturing all the hazards.
Want to be able to input all the old documents and be able to view them via assets or description search.