Database Schema
The adapter uses several database tables where the information about trouble events, activities, and notifications is persisted.
OMS_MWM_EVENTS
This table stores the most recent information about the trouble events which have been sent to the Oracle Utilities Field Service system. This table is used to determine if trouble event update contains changes which should be sent out. This table is also used during synchronization sequence.
 
Field
Description
EVENT_IDX
Event index.
Primary key.
EXTERNAL_ID
Event's external id.
DEVICE_CLS
Class part of the event's device handle.
DEVICE_IDX
Index part of the event's device handle.
PHASES
Affected device phases.
STATUS
Event's condition status (PSO, PDO, etc.)
STATE_KEY
Event's state key.
NUM_CUST_OUT
Number of affected customers.
NUM_CALLS
Number of customer calls.
TROUBLE_CODE
Event's trouble code (combination of the unique trouble codes of the customer calls).
ERT
Estimated restoration time.
COMMENTS
Event comments.
LAST_UPDATE_TIME
Last update time.
 
OMS_MWM_ACTIVITIES
This table stores mobile activities known to the adapter.
Field
Description
ACTIVITY_ID
Activity identifier. Primary key. Generated by the adapter.
EXTERNAL_ID
OFS identifier of activity.
EVENT_IDX
NMS event index. Foreign key into the OMS_MWM_EVENTS table.
CREW_ID
Crew id/name.
CREW_TYPE
Crew type. Only populated if in NMS a generic crew is assigned to the activity.
STATUS
Activity status.
Valid values:
• INITIAL - initial state for activities created by NMS
• NO_CREW - activity without a crew
• DISPATCHED - activity has been given to a crew
• DISPATCHED_ACK - crew has accepted the activity
• EN_ROUTE - crew is en-route to work location
• ARRIVED - create has arrived at the work location but haven't started the work
• STARTED - crew has started the work
• SUSPENDED - crew has temporarily suspended this activity
• COMPLETE - activity is completed
• CANCELLED - activity is cancelled
PENDING
'Pending flag (Y means that this activity should not be cancelled when crew is released). It is set when an activity is created from the OFS without a crew.
CREATED
Activity creation time.
COMPLETED
Activity completion/cancellation time.
LAST_UPDATE_TIME
Last update time.
 
OMS_MWM_ALARMS
This table stores notifications sent to the Oracle Field Service system. It is used to prevent sending of duplicate notifications.
Note: This version of the integration does not support sending of notifications to the Oracle Field Service system.
Field
Description
ALARM_IDX
Alarm index.
Primary key.
ACTIVITY_ID
Activity identifier. Foreign key into the OMS_MWM_ACTIVITIES table.
SENT_TIME
Time when the alarm was sent to mobile system.
 
OMS_MWM_CREW_ACTIONS
This table is used to record actions performed by a mobile crew in the course of working on a trouble event.
Field
Description
ID
Primary key.
Generated by the sequence OMS_MWM_CREW_ACTIONS_SEQ.
EXTERNAL_ID
External identifier. Should be unique for the rows associated with the same trouble event.
EVENT_IDX
Event index.