Post

2 followers Follow
0
Avatar

Closed Work with an Employee with no entered time

This filter finds a list of work orders that have an employee resource record where no time was entered.  It is then sorted to show the Work Order, Task, and Employee.

 

Selected Module:

Work Orders

Filter:

WKORDER LEFT JOIN WKWOTSK ON WKORDER.WO_ID = WKWOTSK.WT_WO_ID LEFT JOIN WKRESRCE ON WKWOTSK.WT_ID = WKRESRCE.WR_WT_ID AND WKRESRCE.WR_RTYP_CD = 1 WHERE (WKRESRCE.WR_UNITS_GT = 0 AND WKORDER.WO_STAT_CD  >= 950)

Drill Downs:

WKORDER - WO_DEPT_TY

WKORDER - WO_NUMBER

WKWOTSK - WT_TASK_TY

WKRESRCE - WR_RSRC_TY

 

Jonathan Semones

Please sign in to leave a comment.