Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.RECENT_DATA_DATE_HIST
Detailed history on data_date recorded for the GEN_DATA_DATE object
|
Column |
Comment |
|---|---|
|
DATA_DATE_VALUE |
This column is unusually named DATA_DATE_VALUE to avoid confusion with the frequently used DATA_DATE function. Normally we just use the function but occasionally we might want to get the column from the table rather than the function and this allows us to do this. (* inherited from FPSBASE.GEN_DATA_DATE) |
|
SECONDS_BEHIND |
|
|
60 |
|
|
MINUTES_BEHIND |
|
|
SYS_TIME |
This is always SYSTIMESTAMP when the record was inserted in the MSO_MES_INTERACTION_HIST table. (* inherited from FPSBASE.MSO_MES_INTERACTION_HIST) |
|
LAST_START_TIME |
|
|
DURATION_SEC |
Duration in seconds of the period to be used to run the APF report. Used only for CLR, CLRA, and QE. (* inherited from FPSADMIN.CFG_TABLES) |
|
COMPONENT |
|
|
METHOD |
Method used to load data in table or execute procedure (* inherited from FPSADMIN.GEN_LOAD_METHODS) |
|
NUM_UPDATES |
|
|
OSUSER |
|
|
MACHINE |
|
|
SID |