Job Assignment Design Help (1 Viewer)

[The_Vincester]

I need some basic help designing an environment where jobs can be assigned to personnel. Typically they'll have the same "job" every day, but if someone is absent then their job must be reassigned, distributed among the others.

The large assigment of job can be done automatically on a daily basis, and the reassignment could be manual. We're dealing with about 120 people, with 5 or so people absent at a time (potentially).

I'd like to track only whether or not the job has been completed. They'll have access to update their record.

I could do this fairly easy except for the fact that they'll have a daily assignment. How to I do this without generating a table without future dates? Or can I?

For some reason I just can't wrap my head around this design working with dates, assignments and completion.

Any help would be appreciated.

 

[cuttsy]

Would it work if you just had a Job table, Staff table and Assignment table?

Job([U]JobID[/U], JobName, Started, Completed)
Staff([U]StaffID[/U], Firstname, Surname, JobTitle)
Assignment([U][I]Staff[/I][/U], [U][I]Job[/I][/U])

 

[The_Vincester]

Yes, that's what I was thinking, but I just can't get how to give them a set schedule that's daily assigned.

There are days when they won't completed assignments, there are also days when they'll pick up MORE assigments.

 

[cuttsy]

Job Table
J1, Do something, 01/09/2006, 05/09/2006
J2, Do Something Else, 01/09/2006, 02/09/2006
J3, Do Another Thing, 02/09/2006,
J4, And Another Thing, 02/09/2006, 04/09/2006

Staff Table
S1, Joe, Bloggs
S2, Jane, Doe
S3, Alan, Smith

Assignment Table
S1, J1
S2, J2
S2, J3
S3, J4

If you store the information like this. What doesn't it do that you require?

 

[The_Doc_Man]

Use the SEARCH function of this forum for articles on Scheduling. Many threads have addressed job assignments as a schedule or work-schedule topic.