Data Dictionary
>
FPSBASE Tables
> FPSBASE.WIP_EVENT_PARMS_BY_TYPE
Table FPSBASE.WIP_EVENT_PARMS_BY_TYPE"
Table to configure the definition of user-defined event_parm and event_inst columns in WIP_EVENT_HIST for each event_type;
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: EVENT_TYPE
-
Foreign keys: WIP_EVENT_PARMS_BY_TYPE_FK: EVENT_TYPE REFERENCES FPSADMIN.WIP_EVENT_TYPES (EVENT_TYPE)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
EVENT_TYPE |
VARCHAR2(12) |
N |
Event Type (* from FPSINPUT.EQP_SCHED_EVENTS_MANUAL) |
|
EVENT_INST1_DESC |
VARCHAR2(128) |
Description of the value written to the user-defined column event_inst1 in WIP_EVENT_HIST for this event_type. |
|
|
EVENT_INST2_DESC |
VARCHAR2(128) |
Description of the value written to the user-defined column event_inst2 in WIP_EVENT_HIST for this event_type. |
|
|
EVENT_INST3_DESC |
VARCHAR2(128) |
Description of the value written to the user-defined column event_inst3 in WIP_EVENT_HIST for this event_type. |
|
|
EVENT_PARM1_DESC |
VARCHAR2(128) |
Description of the value written to the user-defined column event_parm1 in WIP_EVENT_HIST for this event_type. |
|
|
EVENT_PARM2_DESC |
VARCHAR2(128) |
Description of the value written to the user-defined column event_parm2 in WIP_EVENT_HIST for this event_type. |
|
|
EVENT_PARM3_DESC |
VARCHAR2(128) |
Description of the value written to the user-defined column event_parm3 in WIP_EVENT_HIST for this event_type. |
|
|
EVENT_PARM4_DESC |
VARCHAR2(128) |
Description of the value written to the user-defined column event_parm4 in WIP_EVENT_HIST for this event_type. |