Alright Alpha Pros...What do you think?
First...a big thanks to Eric, Steve, Pat, Keith for helping me out in the past.
THE BIG PICTURE: I am developing a web based safety round tracking system for people to enter safety round findings. I expect to have 100 clients. Each client will have a several buildings and each building will have dozens of departments.
PROBLEM NUMBER 1:
Although >90% of the system will work for everyone, each client does have minor differences. One of my main issues is how to let each facility set the priority level for each individual safety round finding (there are 130 different findings possible).
Here is how the system works. A user logs in and is directed to the website for their facility. The user than clicks a link allowing them to enter a new safety round. They begin by chosing the department (from their facility only) they are adding a safety round for. The next dialog allows them to start entering findings by selecting from the list of 130 possible findings mentioned above (this list is common to ALL clients).
Each finding has a risk factor associated with it. The higher the risk factor, the faster the item must be fixed. When the safety round is completed with all the findings entered, the report is emailed to the department manager with each finding listed in priority order. Here is what I need help with, I need each client to be able to set their OWN priority level to each of the 130 possible findings. They will also need to be able to set the time limit for each priority level. I have no idea how to accomplish this. Should I create a seperate findings list for every client? That would nean 100 tables containing the 130 possible findings. I can do this but it would be a pain to have to manage it especially if I needed to make a change to the possible findings. Is there an easier way?
PROBLEM NUMBER 2:
My other issue is database size. Each client will have approx 300 departments. And every department is surveyed twice per year with an average of 10 findings found each survey. This means that I could have as many as 600,000 individual findings per year. Each finding consists of 12 fields.
Thanks in advance for your assistance.
First...a big thanks to Eric, Steve, Pat, Keith for helping me out in the past.
THE BIG PICTURE: I am developing a web based safety round tracking system for people to enter safety round findings. I expect to have 100 clients. Each client will have a several buildings and each building will have dozens of departments.
PROBLEM NUMBER 1:
Although >90% of the system will work for everyone, each client does have minor differences. One of my main issues is how to let each facility set the priority level for each individual safety round finding (there are 130 different findings possible).
Here is how the system works. A user logs in and is directed to the website for their facility. The user than clicks a link allowing them to enter a new safety round. They begin by chosing the department (from their facility only) they are adding a safety round for. The next dialog allows them to start entering findings by selecting from the list of 130 possible findings mentioned above (this list is common to ALL clients).
Each finding has a risk factor associated with it. The higher the risk factor, the faster the item must be fixed. When the safety round is completed with all the findings entered, the report is emailed to the department manager with each finding listed in priority order. Here is what I need help with, I need each client to be able to set their OWN priority level to each of the 130 possible findings. They will also need to be able to set the time limit for each priority level. I have no idea how to accomplish this. Should I create a seperate findings list for every client? That would nean 100 tables containing the 130 possible findings. I can do this but it would be a pain to have to manage it especially if I needed to make a change to the possible findings. Is there an easier way?
PROBLEM NUMBER 2:
My other issue is database size. Each client will have approx 300 departments. And every department is surveyed twice per year with an average of 10 findings found each survey. This means that I could have as many as 600,000 individual findings per year. Each finding consists of 12 fields.
Thanks in advance for your assistance.
Comment