Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.STARTUP_COLUMN_WORKSHEET
This view is our worksheet to use for initial startup of the DWH at a new site. It includes only tables which are required for startup and only columns in those tables which are not null or which are specifically required for startup even though nullable. The output of this view should be pasted into Excel where we should populate the GEN_EXPLANATIONS columns and then write back to the DWH when done.
|
Column |
Comment |
|---|---|
|
APPROX_POPULATION_ORDER |
|
|
TABLE_NAME |
|
|
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) |
|
CONSTRAINT_TYPE |
|
|
COLUMN_ID |
|
|
DATA_TYPE |
|
|
NULLABLE |
|
|
COL_WIDTH |
|
|
R_CONSTRAINT_NAME |
|
|
FPSADMIN_FK_VALUE_LIST |
|
|
OTHER_TABLE_LIST |
|
|
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) |
|
NUM_COMMENTS |
|
|
EXPLANATION |
Explanation of how data is translated for specific column. For example, this might include the table name and column name from the MES used to populate the column in the FPSINPUT table. (* inherited from FPSINPUT.GEN_EXPLANATIONS) |
|
SRC_APPLICATION |
Application from which the source data is acquired. Usually this is the MES. (* inherited from FPSINPUT.GEN_EXPLANATIONS) |
|
SRC_TABLE |
|
|
SRC_COLUMN |
Column(s) from which the column is acquired. This may be more than one column in some cases. (* inherited from FPSINPUT.GEN_EXPLANATIONS) |
|
FORMULA |
Mathematical formula for how the data is derived. (* inherited from FPSINPUT.GEN_EXPLANATIONS) |