FPSADMIN.ECT_REF_STATE_7D_2D_CW

>

> FPSADMIN.WIP_WAFER_HIST_LOOP

View FPSBASE.ECT_REF_STATE_7D_2D_CW

ECT_STATE_7D_2D_CURRWK has the current data with the ect_state column added to the standard primary key of facility, prd, planprd, route, step, bank, prty_ctm_group, lot_group. This means that instead of having separate columns for total_proc_sec, total_hold_sec, total_wait_sec, etc. that we have separate rows for each ect_state and columns named total_unit_seconds_xxx. This total_unit_seconds column can be divided by the total seconds in the period to get the average WIP in that ect_state. It can also be divided by the total moves for the standard primary key in the period to get the cycle time.