Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_COLUMNS_TO_IGNORE
Get all ignored columns from both cfg_columns_to_ignore and gen_cols_updated_by_trigger and set appropriate information to use in all ADM procedures and CHK views.
|
Column |
Comment |
|---|---|
|
TABLE_NAME |
|
|
COLUMN_NAME |
Name of the column in DWH. Note: The column may exist in more than one table and/or schema. (* inherited from FPSINPUT.GEN_EXPLANATIONS) |
|
IGNORE_CODE |
|
|
IGNORE_NAME |
|
|
IS_IGNORED_BY_CFG |
|
|
IS_UPDATED_BY_TRIGGER |
|
|
IS_FILLIN_ONLY |
|
|
IS_INSERT_FROM_ETL |
For APF, if Y then we include the column in our pre-built insert statement but not in our update statement. For REF views, if Y we include the column in the pre-build REF view but we only use it for insert and ignore for update. This allows the ETL to populate a default value on initial insert but then not update it since it will be updated manually. (* inherited from FPSADMIN.GEN_COLUMN_IGNORE_CODES) |
|
IS_UPDATE_FROM_ETL |
|
|
IS_ALLOWED_IF_COL_NOT_NULL |
This column indicates exactly how the column is ignored by the ETL. (* inherited from FPSADMIN.GEN_COLUMN_IGNORE_CODES) |
|
IS_MANUAL_DML_SCOPE |