We want to report on machine utilization, broken out by shift. I suspect that the shift configuration is either set up wrong or is not set up at all, as I see only one Shift id in the LaborDtl table. The shift ID of ‘1’ appears to be a default and is not even assigned to the same company as all of the resources that we want to report on. (see screenshot)
My first question is whether there is some way to calculate the shift breakout without having the actual shift id in LaborDtl.
The second question is whether there is a document that describes how to set up machine resources for a multiple shift production environment.
You set the Resource to be available when you expect it to run independent of which shift will be operating it in a given hour.
Yes, but it’s way easier to use the LaborDtl shift field, and you want to get that working correctly regardless of this specific project. To that end, the first thing I’d do is make sure all shop employees are configured with the correct shift. If you let employees select their shift when they clock in (consider disabling this) make sure they’re trained to select the correct one and that managers are enforcing compliance and/or correcting mistakes.
Now, in terms of the mangled historic data, you should have (regardless of emp shift settings) a “ClockinTime” field in the LaborDtl. It’s a decimal field running from 0 to 24. Run a case statement on that field.
