Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSBASE.EQP_PORT_HIST_PLUS
At some point we will include port mode changes in EQP_EVENT_HIST and EQP_STATUS but until then we build the HIST table with a trigger than captures changes to EQP_PORTS. Note we include the same fast join with EQP_PORT_MODES as is in EQP_TOOL_PORTS but we do not join with EQP_TOOLS_PLUS since it is possible the tool values might have changed.
|
Column |
Comment |
|---|---|
|
ACTION |
For CHGLOG and automatic HIST tables, this is I for insert or U for updated or D for delete. (* inherited from FPSINPUT.EQP_PORT_HIST) |
|
UPDATED_INST |
Time when the record was updated according to the source data. Note this is not the time when the record was actually updated in this table - it will almost always be earlier. (* inherited from FPSINPUT.GEN_FACILITIES) |
|
AS |