Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSAPP.DOC_P_TABLE_COLUMNS
All information on table columns needed for documentation web pages.
|
Column |
Comment |
|---|---|
|
OWNER |
|
|
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) |
|
COLUMN_ID |
|
|
NULLABLE |
|
|
DATA_TYPE |
|
|
PK_POSITION |
|
|
FK_TABLE |
|
|
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) |
|
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) |
|
USE_FOR_COLUMN_NAME |