Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.BLD_COLUMN_COMMENT_WORKSHEET
The output of this view should be pasted into Excel to add and edit comments and then the query can be run as a script.
|
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) |
|
DATA_TYPE |
|
|
NEED |
|
|
OWNER |
|
|
TABLE_NAME |
|
|
DESIRED_OWNER |
|
|
DESIRED_TABLE_NAME |
|
|
COMMENTS_LIST |
|
|
NUM_COMMENTS |
|
|
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) |
|
NEW_COMMENT |
|
|
F2 |
|
|
J2 |
|
|
EXCEL_FOR_ADD_SQL |
|
|
EXCEL_FOR_ERASE_SQL |
|
|
TABLE_LIST |