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 (in the UTC time zone). |
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 (in the UTC time zone). |
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 (in the UTC time zone). |
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. |