Data Dictionary
>
FPSBASE Tables
> FPSBASE.GEN_PREFIXES
Table FPSBASE.GEN_PREFIXES"
List of allowed prefixes in FPS database.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: PREFIX
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
PREFIX |
VARCHAR2(7) |
N |
|
|
DESCRIPTION |
VARCHAR2(256) |
N |
Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS) |
|
IS_DEV_ONLY |
CHAR(1) |
||
|
OVR_SCHEMA_REPOSITORY |
VARCHAR2(14) |
This will be populated with the name of the GrimRepo repository if we want to separate this prefix outside of the standard DWH_schema repository. For example, this will be SCH_schema for SCH so that all Scheduler objects will go into a separate SCH_schema repository. This does not need to be unique so we could, for example, have APP, FBK, and SEC in a common support repository. |