FPSBASE.CHK_CHGLOG

>

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSADMIN.CHK_CHGLOG

This view checks for all of the CHGLOG tables and the triggers to populate them. We want CHGLOG for all FPSINPUT tables which are updated manually or have at least one column updated manually. We also want FPSADMIN.CFG_xxx tables and FPSAPP C and W tables. Finally we always want EQP_PORTS and MHS_CARRIERS because port history and location history is critical to many applications. This view checks both for new CHGLOG tables that need to be created and existing ones that need to be modified or dropped. It also checks if the trigger should be recreated if the tables have DDL changes since the trigger was updated. This view feeds BLD_CHGLOG and then ADM_SET_CHGLOG if is_auto is set to Y so most changes are done automatically when you select from CHK_ALL.