Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.WIP_EVENT_TYPES
Table FPSINPUT.WIP_EVENT_TYPES"
FPS standard lot event types to use with FK to ensure event_type column in all tables has values from our standard list.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: EVENT_TYPE
-
Foreign keys: WIP_EVENT_TYPES_FK_PROC_STATE: PROCESS_STATE REFERENCES FPSADMIN.WIP_PROCESS_STATES (PROCESS_STATE)
-
Referenced by: FPSINPUT.WIP_EVENTS (EVENT_TYPE) FPSINPUT.WIP_EVENT_PARMS_BY_TYPE (EVENT_TYPE)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
EVENT_TYPE |
VARCHAR2(12) |
N |
Event Type (* from FPSINPUT.EQP_SCHED_EVENTS_MANUAL) |
|
DEFAULT_SEC |
NUMBER(6) |
||
|
DESCRIPTION |
VARCHAR2(512) |
N |
Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS) |
|
IS_AUTO_ONLY |
CHAR(1) |