Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSAPP.DOC_P_COLUMN_DEFINITIONS
All information on columns needed for documentation web pages. This view has one row for each column name which has a comment which generally means it is in an FPSINPUT table but might also be
|
Column |
Comment |
|---|---|
|
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) |
|
1 |
|
|
PREFIX |
|
|
1 |
|
|
FIRST_TABLE |
|
|
DATA_TYPE |
|
|
NULLABLE |
|
|
PK_TABLE_LIST |
|
|
NONPK_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) |
|
TABLE_NAME_WHERE_COMMENTED |
|
|
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) |
|
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) |