Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_ALL_INFO_COMPARED_IF_DIFF
Use this view to compare this instance of the FPS Data Warehouse with one which is on an thiser version to see what changed. Unlike ADM_ALL_INFO_COMPARED_IF_SAME which compares absolutely everything, this view ignores column positions, column width differences, and whether the column is nullable. It also sorts differences in the num of characters in the view/constraint/source at the end. This view only works if the linked DWH is 5.6 or above because we made improvements to the ADM_ALL_INFO_TO_COMPARE view itself in 5.6. If the linked DWH is before 5.6 then use the lines we include which are commented out in the first two sections.
|
Column |
Comment |
|---|---|
|
SOURCE |
|
|
OWNER |
|
|
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_NAME |
|
|
COMPARE_TYPE |
|
|
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) |
|
DATA_TYPE |
|
|
DDL_SCOPE |
|
|
IS_CUSTOM_INPUT |