FPSBASE.DBF_REF_TAB_COLUMNS

>

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSADMIN.DBF_REF_TAB_COLUMNS

Refresh SYS view DBA_TAB_COLUMNS into table with FPS only filter. We use this view rather than DBA_TAB_COLS because it does not include hidden columns. The three OVR columns are used by GrimRepo to override the real values for data_type, data_length, and column_id so that when we compare the snapshot branch to any other branch it appears to have these properties when in reality it does not. The reason why we need such overrides for data_type and data_length is because it is nearly impossible to shrink columns in large history tables and we changed IS_NONSTD so long after creation that we could not actually make the alter. The reason for column_id is because Oracle only allows new columns to be added to the end of the table and sites often add columns in different orders. We only do this when necessary since it is normally better to have GrimRepo match the real order. For the tables where we have differences we manually choose how many columns to lock (normally the original columns) then we sort by PK columns first then original columns to lock in their original order then alphabetically.