data-dictionary

FPSBASE.STARTUP_TABLE_WORKSHEET

Data Dictionary

>

FPSBASE Views

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSADMIN.STARTUP_TABLE_WORKSHEET

This view is our second worksheet to use for initial startup of the DWH at a new site. This one has one line for each table so it is a better overview than BLD_STARTUP_WORKSHEET. It includes only tables which are required for startup. The output of this view should be pasted into Excel.

Column

Comment

APPROX_POPULATION_ORDER

IS_DATA_RQD_FOR_BASIC_OPS_DASH

TABLE_PREFIX

TABLE_NAME

OWNER

TABLESPACE_NAME

Tablespace to configure the SysMonitor alert limits. (* inherited from FPSAPP.SYSMNTR_C_TABLESPACE_ALERT)

APPS_USED

EFFORT_BY_CLIENT

KEY_COLUMNS

COMMENTS

A comment field allowing a user to document the source or reason of the values populated in the table (* inherited from FPSAPP.GP_C_RSEC_PROCESS_ROUTE)