I am trying to utilize the resource time used table again. When I total the LoadHours for a given row (Job/asm/op), I am not getting the same total as the EstHours from JobOper. I am trying to understand how these values are calculated, and what they really mean.
Does ResourceTimeUsed.LoadHours include queue time, move time, and setup time?
Does JobOper.EstSetHours or EstProdHours include Queue or move time?
If I want to know what the total load against a resource group is from a particular job, is there a place to see that? I can see it in the job or resource scheduling board, but it looks like I have to manually add up the hours using the visual layout. Is there a place to just see the total?
Are you suggesting the time it takes to complete a job is determined by other jobs on the schedule? I am not so much concerned with when the job will complete, just how many hours it will take. Shouldn’t the estimated hours to complete a job be the same regardless of where it gets placed in the schedule? Man, this is confusing!
No, I’m saying unscheduled jobs will not have a record in the RTU table. You can also have someone un-engineer, modify, then rerelease a job but didn’t remove/readd it to the schedule so now you have two tables saying different things about the same job.
I wouldn’t bother trying to reconcile the two. Over here, RTU is the canon. It’s used in the canned scheduling boards, my custom reporting, and that unfortunate integration with Forcam (half the API is German).