Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.SMMS_B_EVENTS_CNTR
Table FPSINPUT.SMMS_B_EVENTS_CNTR"
Counter (cntr) based Maintenance events. These are specific happening of an event_definition on an entity. If an event-definition happens on an entity, populatiing this is how we know about it. Only populatiing EVENT_DEFINITION and LOGGED_ENTITY are required. This table is effectivly an override table. It includes attributes that exist in MNT_EVENT_DEFINITIONS_OCAP, if they exist in here they will override the values at the definition-level.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: EVENT_DEFINITION, LOGGED_ENTITY
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
EVENT_DEFINITION |
VARCHAR2(200) |
N |
|
|
LOGGED_ENTITY |
VARCHAR2(36) |
N |
Entity to which event is logged in the MES. This could be a main tool, subtool, entity, or port. In MNT tables this could be a vehicle or durable as well which is why the column width is wider. If main tool or port, we apply the event to all entities. If subtool we apply to all within the subtool. If entity we apply only to the entity. (* from FPSINPUT.EQP_EVENT_HIST) |
|
OVR_COUNTER_DUE |
NUMBER(12,3) |
||
|
OVR_COUNTER_EARLY |
NUMBER(12,3) |
||
|
OVR_COUNTER_INTERVAL |
NUMBER(12,3) |
||
|
OVR_COUNTER_LATE |
NUMBER(12,3) |
||
|
OVR_COUNTER_NAME |
VARCHAR2(64) |
||
|
OVR_COUNTER_UNITS |
VARCHAR2(18) |
||
|
OVR_EST_MNT_DURATION_SEC |
NUMBER(8) |
||
|
OVR_IS_HIDDEN_BY_DEFAULT |
CHAR(1) |
||
|
OVR_NUM_TECHS_RQD |
NUMBER(1) |