data-dictionary

FPSADMIN.WIP_TESTS_DIAG_WSH_VS_WESH

Data Dictionary

>

FPSADMIN Views

> FPSADMIN.WIP_WAFER_HIST_LOOP

View FPSADMIN.WIP_TESTS_DIAG_WSH_VS_WESH

This view builds a query to compare WIP_STEP_HIST to WIP_END_SHIFT_HIST for shifts of the last days. It is used to support the WIP_TESTS package when the test fails.

Column

Comment

SOURCE

START_SHIFT

Shifts can be of any length and it is important that all queries get the shift length based on start_shift and end_shift rather than assuming a set number of hours. (* inherited from FPSINPUT.CAL_SHIFTS)

STEP

A single processing step within a route representing a single tool visit. Step is often a very complex string and should rarely be displayed. Instead we should use process_display. (* inherited from FPSINPUT.RTG_ROUTE_STEPS)

ROUTE

Route that has threading requirements (* inherited from FPSINPUT.RTG_STEP_THREADING)

NUM_LOTS_COMP

QTY_COMP

LOT_LIST