Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSADMIN.DBF_SCHEMA_SCOPE
This is the base query to define the scope of GrimRepo, our database schema scraper. All objects in this view except CHGLOG have their DDL (structure) recorded by GrimRepo with the folder determined by the DDL_SCOPE column. Our DDL_SCOPE values (and therefore our GrimRepo folders except CHGLOG) are CHGLOG, GLOBAL, INSTANCE, RPT, and SITE. For tables, the DML_SCOPE determines whether it will have its DML (data) recorded by GrimRepo: - CFG, GLOBAL, and MANUAL tables are always recorded. - CHGLOG, DWH, ETL, FPSRPT, and OFF are never recorded. - WRITE_BY_APP ("written and maintained by application code") is determined by flag in GEN_PREFIXES. - ETL_W_MANUAL_COLS ("table records determined by ETL with at least one column updated manually") are currently not recorded but this could change in the future.
|
Column |
Comment |
|---|---|
|
OWNER |
|
|
OBJECT_NAME |
This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* inherited from FPSADMIN.CFG_DISABLED) |
|
CONS_OR_INDEX_NAME |
|
|
OBJECT_TYPE |
|
|
DDL_SCOPE |
|
|
SCHEMA_REPOSITORY |
|
|
DML_SCOPE |
|
|
TYPECODE |
|
|
LAST_DDL_TIME |