Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_RTDLOAD_FINAL
This view is used by the Load_FPS_DWH.sh script for loading tables via APF/RTD.
|
Column |
Comment |
|---|---|
|
LOAD_JOB |
Name of load job (* inherited from FPSADMIN.CFG_JOBS) |
|
LOAD_ORDER |
Order of objects to load within the load job (* inherited from FPSADMIN.CFG_SCHED) |
|
OBJECT_NAME |
This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* inherited from FPSADMIN.CFG_DISABLED) |
|
TABLE_OR_FILE |
|
|
OWNER |
|
|
METHOD |
Method used to load data in table or execute procedure (* inherited from FPSADMIN.GEN_LOAD_METHODS) |
|
TIMEOUT_SEC |
This column is required with the status_tool (ST) method which calls the APF dispatcher but only works with this method. Status_tool allows a -timeout parameter as one of the inputs and we will pass that if specified here. (* inherited from FPSADMIN.CFG_TABLES) |
|
WHY_DISABLED |
|
|
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) |
|
OTHERS_TO_LOAD_IF_CHG |
This allows us to load a table only if another table changed. This is rarely used but can save time. (* inherited from FPSADMIN.CFG_TABLES) |
|
OVR_STATION_VAR |
This allows us to pass a value for $Station to an APF report or rule. This is rarely used. (* inherited from FPSADMIN.CFG_TABLES) |
|
END_REP_START_SHIFT |
This column is obsolete and will be dropped from the table in the next DWH version. (* inherited from FPSADMIN.CFG_TABLES) |
|
TABLE_LOG_QUERY_START |
|
|
TABLE_ERR_IF_NO_ROWS |
|
|
FILE_SKIP_DIFF_CHK |
|
|
FILE_CHANGE_EMAIL_LIST |
|
|
FILE_OVR_PERMISSION |
|
|
FILE_PCT_FEWER_ROWS_WARN |
|
|
FILE_PCT_FEWER_ROWS_ERR |
|
|
FILE_PCT_MORE_ROWS_WARN |
|
|
FILE_PCT_MORE_ROWS_ERR |
|
|
FILE_ARCHIVE |
|
|
FILE_COPY_AS_TXT |
|
|
APF_REP_PARM_W_COLON_DELIM |
We pass this value to the APF report as the parameter(s). The script replaces colon so we must use colon as the delimiter. This column works only for QE, CLR, CLRA and not ST because the dispatcher handles parameters differently. (* inherited from FPSADMIN.CFG_TABLES) |
|
USE_DATA_DATE_TO_CALC_DUR_SEC |