data-dictionary

FPSBASE.DASH_E_H_SPOTLIGHT_QUERY

Data Dictionary

>

FPSBASE Views

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSAPP.DASH_E_H_SPOTLIGHT_QUERY

This is a copy of the complex spotlight history query used in the C# function. Please note this view is not used by the dashboard or anything else but is saved in this query for reference and to test speed. This is from Dashboard 3.9. Variables are filled in so the view compiles. Search for colon or curly brackets.

Column

Comment

PERIODNAME

PERIODINDEX

STARTPERIOD

SHIFTSPERPERIOD

OPERMOVES

MOVES

COMPLETES

REWORKCOMPLETES

AUTOCOMPLETES

MOVESPACE

OPERMOVESPACE

COMPLETESPACE

AVGWIP

ACTIVEWIP

BANKWIP

TESTWAFERWIP

HOLDWIP

PRIORITYWIP

END

TURNS

END

OPERTURNS

SCRAP