Data Dictionary
>
FPSAPP Tables
> FPSAPP.FGB_W_ACTIVITY_LOG
Table FPSAPP.FGB_W_ACTIVITY_LOG"
This table holds FabGuard Broker API Database activity if logging is enabled in the FabGuard procedures.
-
Schema: FPSAPP
-
Tablespace: FPSDATAHIST
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
DETAILS |
VARCHAR2(2000) |
A concatenation of all the other fields that can be inserted by FabGuard Broker procedures. |
|
|
FG_CHAMBER |
VARCHAR2(36) |
||
|
FG_FACILITY |
VARCHAR2(16) |
The facility logged by the FabGuard Broker. Needed to change the name to not bother ADM_CHK_ALL to allow null in Facility. |
|
|
FG_TOOL |
VARCHAR2(16) |
||
|
INSERTED_TIME |
TIMESTAMP(6) |
Timestamp field set by trigger storing SYSTIMESTAMP when record was inserted in the table. (* from FPSINPUT.WIP_EVENT_HIST) |
|
|
MES_CHAMBER |
VARCHAR2(19) |
If MES Chamber is populated it means that the site is using the Lookup table within FabGuard and the hopes is that this matches a MES chamber name. |
|
|
MES_TOOL |
VARCHAR2(16) |
If MES Tool is populated it means that the site is using the Lookup table within FabGuard and the hopes is that this matches a MES tool name. |