Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_ALL_INFO_COMPARED_IF_SAME
Use this view to compare two instances of the FPS Data Warehouse to ensure they match. This view compares all objects in all FPS schemas along with columns, dependencies, and even the number of characters in views and constraints. It is a bit too much to compare the full PL/SQL code of functions, procedures, and triggers but this catches most discrepancies.
|
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) |
|
COLUMN_ID |
|
|
DATA_TYPE |
|
|
DATA_LENGTH |
|
|
DATA_SCALE |
|
|
NULLABLE |
|
|
DDL_SCOPE |
|
|
IS_CUSTOM_INPUT |