Quote:
Where will it be hosted?
Lets assume that it will be hosted on a Company Server.
Quote:
Will all employee's have access?
Not all employees. I foresee the following persons;
1. HR Manager. To adjust names of employees as they come & go, edit the employee authorisations on equipment, or transfer employees within the four crews.
2. Workshop Manager. To add or amend list of Equipment available,
3. Shift Supervisor. To allocate employees to various locations and equipment
4. Mining Operation Supervisor. To list current & future jobs.
5. Project Manager. To oversee all of the functions.
Maintenance
To keep the concept from getting far to complex, the Maintenance component will be dealt with separately. All we need to know at this point is whether a machine is available for use.
HR
To keep the concept from getting far to complex, the HR component will be dealt with separately. All we need to know at this point is whether an employee is authorised to operate the machine in question. A primary matrix will be maintained to record all employees and their authorisations. A secondary matrix can then determine the skills sets within the crews, and from that it can be determined if further training should be provided to suit the operational needs of the Company
Quote:
Will it be printed on large paper and posted on the wall, or will it be looked up on the screen?
On Screen only at this stage.
Quote:
Will the report show just for 1 employee or the shift or the crew?
Shift Supervisor will need it for each 12 hour shift.
Project Manager & Mining Operations Manager for a longer period ( Which is going to force us to use a true database as against Excel only)
HR Manager needs to see the " at this point in time" view
Quote:
how will the machines be allocated? Per day, per week, month, depends on the task?
Per 12 hour shift. Whilst a task may take up to 2 months to complete, ( For Example. Pre-Stripping parameters range out to 6 cuts of 4 metres in depth, bench widths of up to 200 metres, and bench lengths up to 1500 meters. Thats an awful lot of dirt to dig up and carry out) While the location for a set of machines may not change, the allocation needs to be considered on a per shift (12 hour) basis.
Quote:
This looks like it could be interesting and fun at the same time! :yes
The objective here is to primarily to come up with a workable solution, however, more importantly its a great opportunity to learn how something like this could be achieved. Everyone is invited to contribute ideas and or workable examples, and from this specific questions may be derived into specific forums.
I hope that everyone treats it as fun way to learn.