Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.BLD_FIRST_VALUE_EXAMPLE
This view has a useful query to figure out which of the many options to use to get the desired behavior from the first_value and last_value window functions.
|
Column |
Comment |
|---|---|
|
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) |
|
SEQ_NUM |
Sequence number of step in route (* inherited from FPSINPUT.RTG_ROUTE_STEPS) |
|
IS_FLAG |
|
|
FIRST_FLAGGED_STEP1 |
|
|
FIRST_FLAGGED_STEP2 |
|
|
FIRST_FLAGGED_STEP3 |
|
|
FIRST_FLAGGED_STEP4 |
|
|
FIRST_FLAGGED_STEP5 |
|
|
FIRST_FLAGGED_STEP6 |
|
|
FIRST_FLAGGED_STEP7 |
|
|
FIRST_FLAGGED_STEP8 |
|
|
FIRST_FLAGGED_STEP9 |
|
|
FIRST_FLAGGED_STEP10 |
|
|
FIRST_FLAGGED_STEP11 |
|
|
FIRST_FLAGGED_STEP12 |
|
|
FIRST_FLAGGED_STEP13 |
|
|
FIRST_FLAGGED_STEP14 |
|
|
FIRST_FLAGGED_STEP15 |
|
|
FIRST_FLAGGED_STEP16 |
|
|
FIRST_FLAGGED_STEP17 |
|
|
FIRST_FLAGGED_STEP18 |
|
|
FIRST_FLAGGED_STEP19 |
|
|
FIRST_FLAGGED_STEP20 |
|
|
FIRST_FLAGGED_STEP21 |
|
|
FIRST_FLAGGED_STEP22 |
|
|
FIRST_FLAGGED_STEP23 |
|
|
FIRST_FLAGGED_STEP24 |