Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSADMIN.WIP_TESTS_DIAG_SUMMARY
This view gets all of the data to compare shift completes between this database and yourdblink database link. The desired behavior here is for all six records of each shift to have the same qty_comp. If any of the rows do not match then we will have a failed match. If WSH is different from WESH for the same database then use WIP_TESTS_DIAG_WSH_VS_WESH view to get the details. If WSH and WESH match but this database is different from the link then use WIP_TESTS_DIAG_WSH_VS_LINK to get the details.
|
Column |
Comment |
|---|---|
|
WHICH_TABLE |
|
|
LINK |
|
|
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) |
|
QTY_COMP |