Internal and External Resources

[silentwolf]

Hi guys,
was wondering if someone has an idea how I supose to structure my tables.
Currently I work with one table tblEmployees... this table is linked with tblEmpProjects... so tblEmployees, tblProjects, tblEmpProjects...
Now sometimes there are other resources needet for a project but I don t realy like to have them in my tblEmployees listed..

So what would be the best way of using the lets call it "tblExternalRessources" so I could get those working times into my tblEmpProjects...
How would you guys go about it?

Would be nice if someone has an idea how this would be best do achive.
The thing is that I have already quite alot of data where the tblEmployee_Id is linked to tblEmpProject.. so like to keep them as they are.


Many thanks

Albert

 

[RickXL]

Hi,

I understand why you do not want to mix employees with external contractors, however, I think that is the way to go.

I implemented a solution like this for a household name, UK multinational and it did work!

There is always a conflict between people on the payroll that HR are interested in and people actually doing the work that a project needs to know and record working times for. You need to have extra fields in your employee table that can be used to remove external personnel from employee-only reports. We used the start and end dates the same for everyone but the "employee/non-employee" flag and the "relevant for payroll" flags etc were set appropriately.

I hope this helps,

 

[silentwolf]

Hi Rick,
thank you for your reply!!
And yes every input or idea helps!

Thank you