Data Dictionary
>
FPSAPP Tables
> FPSAPP.SMMS_B_EVENT_DEFINITIONS_TIME
Table FPSAPP.SMMS_B_EVENT_DEFINITIONS_TIME"
Time based maintenance definitions define a group of events to be performed on many entities. For example, a definition could be a weekly PM that is performed weekly on a group of tools that are all the same. (e.g. weekly PM). This table includes attributes that exist in MNT_EVENTS if they exist in MNT_EVENTS they will override the values at the family level.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: EVENT_GROUP, EVENT_DEFINITION
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
EVENT_GROUP |
VARCHAR2(128) |
N |
Event group is the second highest level in the maintenance event hierarchy it could be used to denote the group even maintenance definitions such as PMs, Adhoc tasks, OCAPS, Quals, or inspections. This grouping will be a collection of maintenance definitions. (* from FPSAPP.SMMS_B_EVENT_GROUPS) |
|
EVENT_DEFINITION |
VARCHAR2(200) |
N |
|
|
CREATED_INST |
DATE |
Time when the lot was created, either lot start or split. (* from FPSINPUT.WIP_LOTS_STATIC) |
|
|
DESCRIPTION |
VARCHAR2(256) |
N |
Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS) |
|
ENT_OR_CARR_OR_DUR |
VARCHAR2(1) |
N |
Upcoming maintenance for entities, carriers, and durables is included together in this table. An E here indicates that the `logged_entity` field in this table is an entity, C for carrier, and D for durable. (* from FPSINPUT.EQP_MNT_FUTURE) |
|
EST_MNT_DURATION_SEC |
NUMBER(8) |
N |
Est_mnt_duration_sec is the estimate of the total duration of the maintenance in seconds including work time, wait time, and qual time. Est_mnt_duration_sec is required then if desired, this total can be broken down into est_mnt_work_sec, est_mnt_wait_sec, and est_mnt_qual_sec. These three breakdown columns are optional but if any of those three columns are populated then they must sum to the value of est_mnt_duration_sec. Only est_mnt_duration_sec is used in FPS applications. The other three are available for informational purposes and to use for custom reporting but are not currently used in any FPS application. (* from FPSINPUT.EQP_MNT_FUTURE) |
|
IS_HIDDEN_BY_DEFAULT |
CHAR(1) |
If this flag is set then this event is hidden by default on the Maintenance Dashboard to avoid clutter. There is an option to show hidden events. (* from FPSINPUT.EQP_MNT_FUTURE) |
|
|
MNT_INTERVAL_EARLY_SEC |
NUMBER(9) |
N |
|
|
MNT_INTERVAL_LATE_SEC |
NUMBER(9) |
N |
|
|
MNT_INTERVAL_SEC |
NUMBER(9) |
N |
Indicates the frequency of future occurrences of this maintenance. For example, a daily PM will be listed once with due_inst set to the next occurrence and `mnt_interval_sec` set to 86400 so we know to plan for it to occur again 24, 48, 72, etc. hours after `mnt_due_inst`. (* from FPSINPUT.EQP_MNT_FUTURE) |
|
NUM_TECHS_RQD |
NUMBER(1) |
We assume that each maintenance event requires one technician but this column allows us to indicate that more than one person is required to complete the event. (* from FPSINPUT.EQP_MNT_FUTURE) |