Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.THP_IGNORE_REASONS
Table FPSINPUT.THP_IGNORE_REASONS"
Reasons why we would not use a particular job in throughput calculations.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: THP_IGNORE_REASON
-
Foreign keys: THP_IGNORE_REASONS_FK_COLOR: BG_COLOR REFERENCES FPSADMIN.GEN_COLORS (COLOR)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
THP_IGNORE_REASON |
VARCHAR2(12) |
N |
|
|
BG_COLOR |
VARCHAR2(24) |
N |
Background color assigned. BG_COLOR is in English like red or blue or light green and we look up the HTML color like #FF0000 in the GEN_COLORS table. BG_COLOR must be set manually but the FPSADMIN view BLD_POPULATE_COLORS will generate queries to randomly set bg_color for all values in a table. (* from FPSINPUT.GEN_CUSTOMERS) |