Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSADMIN.CHK_COLUMN_WIDTHS
This view checks if a column of the same name in multiple tables has different types or column widths. Discrepancies within FPSADMIN/INPUT/BASE tables are listed first. Then discrepancies involving columns which exist in a table in any of those three schemas -- and for the desired type/length it uses the mode type and max length from tables in FPSADMIN/INPUT/BASE. Then finally discrepancies involving columns which are only in FPSAPP -- and it uses the mode type and max length from FPSAPP tables.
|
Column |
Comment |
|---|---|
|
PROBLEM |
|
|
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) |
|
CHK_COL_NAME |
|
|
OWNER |
|
|
TABLE_NAME |
|
|
DATA_TYPE |
|
|
DATA_LENGTH |
|
|
DESIRED_TYPE |
|
|
DESIRED_LENGTH_MIN_CHAR |
|
|
DESIRED_LENGTH_MAX_CHAR |
|
|
IS_ERR_NOT_FPSAPP |
|
|
IS_COLUMN_NOT_FPSAPP |
|
|
IS_NUMBER_WOUT_LENGTH |
|
|
IS_NUMBER_LENGTH_RQD |
|
|
COLUMNS |