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.