I'm trying to show employee availability where overlapping project commitments with less than FTE exists.
EX: Joe Prj344 5/1/01 8/1/01 .5 FTE
Joe Prj346 6/30/01 11/14/01 .25 FTE
I'd want to show the .75 commitment level, the .5 levels, and the complete availability on either side.
This only needs a month-level granularity; we'll use business rules, e.g. "If start date < 15th of month show month as committed."
My guess is that I'll have to build a temp table that goes for the range needed, probably six months, and show the commitment level for each project/emp/FTE/month value and then query the resulting table. I'm also thinking that building this table will require VB procedural stepping through the commitments table, parsing the START & STOP dates first to check the business rules, and then creating the project/emp/FTE/month records for the temp table.
I certainly don't expect someone to solve this for me, but if I'm trying to do something that is a standard proc among the more savvy please point me to existing examples somewhere!
Thanks,
Jeff
EX: Joe Prj344 5/1/01 8/1/01 .5 FTE
Joe Prj346 6/30/01 11/14/01 .25 FTE
I'd want to show the .75 commitment level, the .5 levels, and the complete availability on either side.
This only needs a month-level granularity; we'll use business rules, e.g. "If start date < 15th of month show month as committed."
My guess is that I'll have to build a temp table that goes for the range needed, probably six months, and show the commitment level for each project/emp/FTE/month value and then query the resulting table. I'm also thinking that building this table will require VB procedural stepping through the commitments table, parsing the START & STOP dates first to check the business rules, and then creating the project/emp/FTE/month records for the temp table.
I certainly don't expect someone to solve this for me, but if I'm trying to do something that is a standard proc among the more savvy please point me to existing examples somewhere!
Thanks,
Jeff