Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSAPP.DASH_P_GANTT_LOT_STEPS
Includes all of the information needed for lot Gantt chart with one row for each lot/step. This view is designed to be filtered for a single lot as it is used in the Dashboard. This view is similar to DASH_REF_P_GANTT_PRIORITY_LOTS with two important distinctions. First we can write this view more easily to take advantage of the required single lot filter and still be fast. Second this view uses ECT_HIST rather than WIP_STEP_HIST to provide more detailed history. If we make changes to this view, we should review DASH_REF_P_GANTT_PRIORITY_LOTS to see if the same change is necessary.
|
Column |
Comment |
|---|---|
|
LOT |
A lot is a group of units that process together. Usually lot_id or lot_number in MES. All units in a lot are in the same carrier but there may be multiple lots in a carrier. (* inherited from FPSINPUT.WIP_LOTS_STATIC) |