Data Dictionary
>
FPSBASE Tables
> FPSBASE.SMMS_B_EVENT_GROUPS
Table FPSBASE.SMMS_B_EVENT_GROUPS"
This table denotes the two highest levels in the Maintenance Event Hierarchy. This level is entirely up to the site to define. The highest level is Event_class, this can be set to whatever the site would like to configure. Event_class is a collection of Event_groups. Event_Groups are a collection of similar event_definitions, these event groups can be whatever the site would like to configure.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: EVENT_CLASS, EVENT_GROUP
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
EVENT_CLASS |
VARCHAR2(128) |
N |
Event class is the highest level in the maintenance event hierarchy. This level could denote what team is responsible for the events. e.g. Maintenance, Operations |
|
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. |