RX_CALLS

Much of the data in this table can be viewed on Responder Explorer Calls tab by right-clicking a call and selecting Edit Call.

Field Name

Description

REGION

The region in which the call originated. This field uses the REGION domain.

CRITICAL

Indicates if the call came from a customer site that is critical. This field uses the CRITICAL_TYPE domain.

HAZARD

Indicates any hazards in the area (e.g., fire, wires down, etc.). This field uses the HAZARD domain.

TROUBLE

Indicates the problem reported by the customer (e.g., no power, flickering lights, etc.). This field uses the TROUBLE domain.

DEVICE_OID

The object ID of the device to which the customer is associated (e.g., service point or transformer). This field links to the OID field in your geodatabase.

DEVICE_FCID

The feature class ID of the device to which the customer is associated (e.g., service point or transformer). This field utilizes the DEVICE_FCID domain.

INCIDENT_ID

The ID associated with the incident resulting from the call. This field acts as a foreign key to the RX_INCIDENTS table.

CUSTOMER_ACCOUNT

The customer's account number. This field acts as a foreign key to the RX_CUSTOMERS table.

CALLBACK_REQUESTED

Indicates whether the customer requested a return call. This field uses the CALLBACK_REQUESTED domain.

CALLBACK_STATUS

Indicates whether this is a Regular Callback (0) or a Power Not Restored Callback (1). This field uses the CALLBACK_STATUS domain.

TIME_RECEIVED

The time the call was received by Responder.

TIME_OUTAGE

The time the outage occurred.

TIME_RESTORED

The time the customer's power was restored.

REMARKS

Notes from the operator or dispatcher.

USER_CREATED

The name of the user who created the record. This field is populated automatically by Responder.

USER_UPDATED

The name of the user who updated the record. This field is populated automatically by Responder.

TROUBLE_AT_ACCOUNT

Indicates whether the trouble is located at the same location as the customer's account.

CAUSE

Indicates the cause of the outage. This field uses the CAUSE domain.

ANALYZING

Indicates that a call is being analyzed. A Null value indicates the call has not been analyzed. A value of 1 indicates that a call is being analyzed. A value of 2 indicates that the call has been analyzed. All calls with an ANALYZING value of 2 should have an incident ID assigned. If not, the ANALYZING field is cleared and the call resubmitted for processing at the date/time indicated by the ANALYZING_EXPIRES_UTC field.

ANALYZING_EXPIRES_UTC

This is the coordinated universal time a call's ANALYZING and INCIDENTID fields may be cleared and the call made available for processing again. This happens only if the ANALYZING field contains a value of 1 for an extended period of time (due to contention, perhaps) or if the ANALYZING field contains a value of 2, but no incident ID has been assigned. This is a date/time field.

QR code for this page

Was this helpful?