data-dictionary

FPSAPP.SMMS_B_EVENT_GROUPS

Data Dictionary

>

FPSAPP Tables

> FPSAPP.SMMS_B_EVENT_GROUPS

Table FPSAPP.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: FPSAPP

  • 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.