Scheduled machine/employee history

I am looking to write a report that shows the machines that the jobs were scheduled to run on last year and the time they took. I have been unable to find this data. It seems the only data kept is the information from the operation table?? I am looking to compare historical machine/employee utilization to future utilization

thanks
Kevin Weeks

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

unknown

Kevin,
You should be able to find that information in the labor ticket table, which stores data about the employee, the hours worked, and the resource used.

csepulveda

The information in the labor ticket table is the same as what is in the operation table. I thought the same thing and went there first. unless you have the employee enter the resource they utilize you only get the generic "group" you assigned not the specific machine the scheduler planned to use.

anyone else have a thought on a way to get this data??

unknown

The "machine" would have to be a "resource", in which case you should be able to get what you need using OPERATION.RESOURCE_ID, OPERATION.RUN, OPERATION.ACT_RUN_HRS, and slice it up by OPERATION.CLOSE_DATE into weeks, months, quarters, etc, to get your historical averages or graph.

unknown

I took these results and put them in an excel pivot table.

The work order is the machine.

The hours are charged to the resource.

There is a transaction date - this let me know how many days it took.

Hours worked was the summary field.

The Bits field tells me what stage they were working on.

I could also use the department field to get what was worked on.

select *

from labor_ticket a,

requirement b,

requirement_binary c

where a.workorder_base_id = '%MACHINEXYZ%'

and a.workorder_base_id = b.workorder_base_id

and a.workorder_type = b.workorder_type

and a.workorder_lot_id = b.workorder_lot_id

and a.workorder_split_id = b.workorder_split_id

and a.workorder_sub_id = b.subord_wo_sub_id

and b.workorder_type = c.workorder_type

and b.workorder_base_id = c.workorder_base_id

and b.workorder_lot_id = c.workorder_lot_id

and b.workorder_split_id = c.workorder_split_id

and b.operation_seq_no = c.operation_seq_no

and b.piece_no = c.piece_no

and c.workorder_sub_id = 0;

November 2020 webinar with David Foster.mp4

Copyright © 2025 Infor. All rights reserved.