Does anyone know what it is that controls the JCDept coming into the labor dtl row?
The JCDept comes from the EMPBasic Table. When you enter the employee id it pulls the data from the there. At least that is my understanding.
3 Likes
That is correct.
Regards
Hmmm… I typically see LaborDtl.JCDept values that do not match the EmpBasic.JCDept.
Just noticed this old thread while I’m trying to come at JCDept from an opposing direction.
Would like to know how Project tracker is breaking out the hour estimates by JCDept
Ref Project Tracker → Project sheet → More → Summary → Detail Hours (Retrieve)
- So far I haven’t been able to find an explanation in the E10 documentation
And… as you’d expected, the E10 embedded help is especially brief concering Project Tracker-Detail Hours Fields:
EstLbrHours:… Specifies the estimated labor hours.
JCDept:… Specifies the JC Department code.
1 Like
If I recall correctly, the JCDept comes from the Resource/Group of the operation you are reporting against.
2 Likes
That has been my general understanging too.
Where for jobs, I would try to pulling JCDept from Resource/Group in the JobOpDtl table where JobOper.OpCode → JobOpDtl.OpCode.
While for Actual Labor the JCDept’s applied vary.
1 Like
Interesting. I will have to mark a different solution then.
The JC department is probably coming from the Employee.
Might it be different for Project Jobs @CTCharlie?