Responder Database Tables

The tables on this page may be modified to customize Responder Explorer. The field data is populated by Responder. Modifications to these tables are not required to configure Responder.

Some of the fields in the Responder tables utilize domains. Domains may be edited in the DatabaseSchemaConfig.xml file.

RX_AFFECTED_XFRS

Field Name

Description

DEVICE_OID

The object ID of the device to which the customer is associated. 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. 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.

INCIDENT_DEVICE_OID

The object ID of the device to which the incident is associated. This field links to the OID field in your geodatabase.

INCIDENT_DEVICE_FCID

The feature class ID of the device to which the incident is associated. This field utilizes the DEVICE_FCID domain.

INCIDENT_DEVICE_SUBID

The unique ID of each segment of a complex edge.

TIME_OUTAGE

The time the outage occurred.

TIME_RESTORED

The time the customer's power was restored.

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.

Return to Top

RX_CALLBACKS

Field Name

Description

ACCOUNT

The customer's account number. This is a foreign key to the RX_CUSTOMERS table. Acts as a primary key for this table.

INCIDENT_ID

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

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.

REGION

The region in which the incident is located. This field uses the REGION domain.

PRIORITY

The priority of the call (how high it will appear on the callback list), sorted descending (i.e., the larger priority number will be called first).

REASON

The reason for the callback (e.g., estimated time of restoration is about to expire).

RETRY_COUNT

The running number of retries.

MIN_RETRY_COUNT

The minimum number of times to attempt calling back (before auto-delete, if enabled, will delete a callback record).

AUTO_DELETE

Indicates whether a callback should be deleted automatically. This field uses the YES_NO domain (do not edit this domain). This field should not be edited.

BUSY_WAIT

Time (in minutes) to wait until the next callback if there is a busy signal.

NO_ANSWER_WAIT

Time (in minutes) to wait for the next callback if there is no answer.

PREV_RESULT

The result of the last callback attempt.

PREV_CALLER

The caller who performed the last callback attempt.

PREV_CALL_TIME

The time of the last callback attempt.

NEXT_CALL_TIME

The earliest time the next callback attempt should take place.

CALLING

Flag to note if the callback is currently be processed. This field uses the YES_NO domain (do not edit this domain).

CALLING_EXPIRES

The amount of time before the currently loaded callback is returned to the queue if no action is taken. This value corresponds with the MinutesCallingValid value in DataServices.exe.config.

CALLER_TYPE

Who made the last callback. This field uses the CALLER_TYPE domain (do not edit this domain).

COMMENTS

Notes from the operator or dispatcher.

Return to Top

RX_CALLS

Much of the data in this table may 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.

COOKTIME_UTC

Indicates the coordinated universal time that the call will be eligible for prediction by the enhanced Prediction Engine. This is a date/time field.

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.

Return to Top

RX_CREW_ASSIGNMENTS

Much of the data in this table may be viewed in Responder Explorer by right-clicking a crew and selecting Edit Crew.

Field Name

Description

INCIDENT_ID

Indicates the ID of the incident to which the crew has been assigned. This field is a foreign key to the RX_INCIDENTS table.

CREW_ID

Indicates the ID of the crew that has been assigned to the incident. This field is a foreign key to the RX_CREWS table.

STATUS

Indicates the status of the crew. This field uses the STATUS domain.

TIME ASSIGNED

The time the crew was assigned to the incident.

IS_LEAD_CREW

Indicates whether the crew is the lead crew. This field uses the IS_LEAD_CREW domain.

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.

TIME_STATUS_CHANGED

This is the time that a crew's status was changed (e.g., from Dispatched to Working) after it was modified by a dispatcher.

PREVIOUS_TIME

This is the original time that the crew's status was set.

MOBILE_CREW_ENABLED

A value that indicates whether the crew has been assigned a Mobile status.

Return to Top

RX_CREW_MEMBERS

Populate this table with your crew members.

You may choose to NOT populate this table. However, if you make this choice, you must update the ControlStylesConfig.xml and ArchiveStylesConfig.xml files to disable, hide and/or make not required the Crew Member field on all forms.

Field Name

Description

REGION

Indicates the region in which the crew member works primarily. This field uses the REGION domain.

UTILITY_TYPE

Indicates the type of utility for which the crew member works (gas, electric, water, cable). This field uses the UTILITY_TYPE domain.

CREW_ID

Indicates the crew to which the member is assigned. This field acts as a foreign key to the RX_CREWS table.

FIRSTNAME

The crew member's first name.

LASTNAME

The crew member's last name.

TITLE

The crew member's title. This field uses the TITLE domain.

EMPLOYEE_ID

The crew member's employee ID.

MOBILE_PHONE

The crew member's mobile phone number.

HOME_PHONE

The crew member's home phone number.

PAGER

The crew member's pager number.

RADIO_NUMBER

The crew member's radio number.

COMPANY

The company for which the crew member works. This field uses the COMPANY domain.

AVAILABLE

Indicates the crew member's availability. This field uses the AVAILABLE domain.

EXPERTISE

Indicates the crew member's expertise. This field uses the EXPERTISE domain.

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.

Return to Top

RX_CREWS

Populate this table with your crew information.

Field Name

Description

CREW_NAME

The name of the crew.

REGION

The region in which the crew works. This field uses the REGION domain.

CREW_TYPE

The type assigned to the crew.

COMPANY

The company for which the crew works. This field uses the COMPANY domain.

STATUS

The status of the crew. This field uses the STATUS domain.

FOREMAN_EMP_ID

The employee ID of the crew's foreman.

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.

MOBILE_CREW

A value that indicates whether the crew is mobile.

MOBILE_LAST_UPDATE

A date field that indicates the date of the last update by the mobile crew.

Return to Top

RX_ELEMENT_LOCKS

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_EVENTS_FEEDERLOCK

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_FAULT_LOCATIONS

Field Name

Description

IDX

The unique ID assigned to the fault location.

OID

Object ID of the feature.

FCID

Feature class ID of the feature.

SUBID

The unique ID of each segment of a complex edge.

FACILITY_ID

The Facility ID of the incident feature as defined in the geodatabase.

X

The x-coordinate of the incident feature.

Y

The y-coordinate of the incident feature.

INCIDENT_ID

The ID associated with the incident. This field corresponds with the ID field in the RX_INCIDENTS table.

PROBABILITY

The percentage of probability that the fault location is accurate.

USER_CREATED

This field is not currently used by Responder. You may customize Responder to populate this field with the name of the user who created the record.

USER_UPDATED

This field is not currently used by Responder. You may customize Responder to populate this field with the name of the user who updated the record.

Return to Top

RX_FEEDER_ETR

This table holds the estimated time of restoration (ETR) for a specific feeder.

Field Name

Description

FEEDER_ID

The ID of the feeder.

ESTIMATED_TIME

The estimated time of restoration.

ETR_COMMENT

Any comments associated with the estimated restoration time.

Return to Top

RX_GLOBALID_XREF

This table is used only when you have implemented the optional Esri replication support. In order to support Esri replication, Responder requires this table to help manage GUIDs.

Field Name

Description

FCID

The feature class ID of the feature impacted by an incident.

OID

The object ID of the feature impacted by an incident.

GLOBALID

The GlobalID (GUID) of the feature impacted by an incident.

FCID_ACTUAL

Currently not used by Responder. This field should contain the FCID of the feature as it appears in the replicated database.

OID_ACTUAL

Currently not used by Responder. This field should contain the OID of the feature as it appears in the replicated database.

Return to Top

RX_HAZARD_ASSIGNMENTS

Field Name

Description

HAZARD_ID

The ID of the hazard. This field serves as a foreign key to the RX_HAZARDS table.

CREW_ASSIGNMENT_ID

The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.

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.

Return to Top

RX_HAZARDS

Field Name

Description

INCIDENT_ID

The ID associated with the hazard. This field acts as a foreign key to the RX_INCIDENTS table.

CALL_ID

The unique identifier associated with the call. This field corresponds with the ID field in the RX_CALLS table.

FCID

Feature class ID of the feature associated with the tag.

OID

Object ID of the feature associated with the tag.

SUBID

The unique ID of each segment of a complex edge.

FACILITY_ID

The Facility ID of the incident device as defined in the geodatabase.

REGION

The region in which the hazard exists. This field uses the REGION domain.

X

The x-coordinate of the incident device.

Y

The y-coordinate of the incident device.

DAMAGE_TYPE

This is the hazard type. This field uses the HAZARD_TYPE domain.

STATUS

Indicates the status of the hazard. This field uses the STATUS domain.

WIRE_OWNER

The owner of the "wires down" hazard. This field uses the HAZARD_TYPE_OWNER domain.

TIME_CREATED

The time the hazard incident was created.

TIME_COMPLETED

Indicates the time that the hazard was fixed.

TIME_SECURED

Indicates the time that the hazard was made secure.

TIME_PUBLIC_SAFETY_ARR

The time a public safety official arrived at the hazard scene.

TIME_PUBLIC_SAFETY_REL

The time a public safety official was relieved from the hazard scene.

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.

CANCEL_REASON

Reason the hazard was cancelled.

Return to Top

RX_INC_DEV_ASSIGNMENTS

Field Name

Description

INCIDENT_DEVICE_ID

The ID of the hazard. This field serves as a foreign key to the RX_HAZARDS table.

CREW_ASSIGNMENT_ID

The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.

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.

Return to Top

RX_INC_FEAT_ASSIGNMENTS

Field Name

Description

INCIDENT_FEATURE_ID

The ID of the hazard. This field serves as a foreign key to the RX_HAZARDS table.

CREW_ASSIGNMENT_ID

The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.

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.

Return to Top

RX_INCIDENT_DEVICE_STEPS

Field Name

Description

OPERATION_ID

The ID field from RX_OPERATIONS (foreign key).

EXPECTED_STATUS

The expected or normal status of the device (open, closed).

PLANNED_STATUS

The planned status of the device (e.g, Open, Closed).

PLANNED_CUSTOMER_COUNT

The number of customers affected by a planned step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).

PLANNED_CRITICAL_COUNT

The number of critical customers affected by a planned step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).

PLANNED_CONNECTED_LOAD

Amount (in kVA) by which the total system connected load will change due to the planned step.

EXECUTED_CUSTOMER_COUNT

The number of customers affected by an executed step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).

EXECUTED_CRITICAL_COUNT

The number of critical customers affected by an executed step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).

EXECUTED_CONNECTED_LOAD

Amount (in kVA) by which the total system connected load will change due to the executed step.

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.

ACTUAL_STATUS

The current actual status of the device (open, closed).

ACTION

The action to be taken by the operation (e.g., open, close).

PHASES

The phase(s) to be operated by the step.

Return to Top

RX_INCIDENT_DEVICES

Much of the data in this table may be viewed on Responder Explorer Incidents tab by right-clicking an incident device and selecting Edit Device.

Field Name

Description

DEVICE_OID

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

DEVICE_FCID

The feature class ID of the incident device (e.g., service point or transformer). This field utilizes the DEVICE_FCID domain.

SUBID

The unique ID of each segment of a complex edge.

X

The x-coordinate of the incident device.

Y

The y-coordinate of the incident device.

INCIDENT_ID

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

TIME_OPERATION

The time the device was opened or closed for repair.

FEEDER_ID

The Feeder ID of the incident device.

SUBSTATION

The substation that feeds the incident device.

CONFIRMED

Indicates whether the device has been confirmed out. This field uses the CONFIRMED domain.

DEVICE_OPERATION

Indicates the type of operation the device performs (Fault/Switching Operation). This field uses the DEVICE_OPERATION domain.

CUSTOMER_COUNT

Indicates the number of customers affected by the incident.

CRITICAL_CUSTOMER_COUNT

Indicates the number of critical customers affected by the incident.

PRIORITY_CUSTOMER_COUNT

Indicates the number of priority customers affected by the incident.

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.

FACILITY_ID

The Facility ID of the incident device as defined in the geodatabase.

EXPECTED_STATUS

The expected or normal status of the device (open, closed).

ACTUAL_STATUS

The current actual status of the device (open, closed).

REGION

The region in which the device resides. This field uses the REGION domain.

CANCEL_REASON

Reason the device was cancelled.

Return to Top

RX_INCIDENT_FEATURES

Much of the data in this table may be viewed on the Responder Explorer Incidents tab by right-clicking a location feature and selecting Edit.

Field Name

Description

OID

Object ID of the feature associated with the incident.

FCID

Feature class ID of the feature associated with the incident.

SUBID

The unique ID of each segment of a complex edge.

X

The x-coordinate of the incident feature.

Y

The y-coordinate of the incident feature.

INCIDENT_ID

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

TIME_REPORTED

Time that the feature was reported out.

CONFIRMED

Indicates whether the feature has been confirmed out. This field uses the CONFIRMED domain.

FACILITY_ID

The Facility ID of the incident feature as defined in the geodatabase.

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.

REMARKS

Notes from the operator or dispatcher.

REGION

The region in which the device resides. This field uses the REGION domain.

CANCEL_REASON

Reason the feature was cancelled.

Return to Top

RX_INCIDENTS

Much of the data in this table may be viewed on Responder Explorer Incidents tab by right-clicking an incident and selecting Edit Incident.

Field Name

Description

STATUS

The status of the incident. This field uses the STATUS domain.

REGION

The region in which the incident is located. This field uses the REGION domain.

CRITICAL

Indicates if the incident is at a customer site that is critical. This field uses the CRITICAL domain.

CAUSE

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

WEATHER

Indicates the weather at the incident site. This field uses the WEATHER domain.

TROUBLE

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

CUSTOMER_COUNT

Indicates the number of customers affected by the incident.

CRITICAL_CUSTOMER_COUNT

Indicates the number of critical customers affected by the incident.

PRIORITY_CUSTOMER_COUNT

Indicates the number of priority customers affected by the incident.

FEEDER_ID

The Feeder ID of the incident device.

SUBSTATION

The substation that feeds the incident device.

TIME_CREATED

The time the incident was created.

TIME_OUTAGE

The time the outage occurred.

TIME_RESTORED_EST

The time power is estimated to be restored.

TIME_RESTORED

The time power is actually restored.

REMARKS_DISPATCH

Remarks from the dispatcher.

REMARKS_FIELD

Remarks from the field crew.

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.

CONFIRMED

Indicates whether the device has been confirmed out. This field uses the CONFIRMED domain.

ORIGINATION

Indicates whether an incident was created by a user or by Prediction Services.

OWNER

The dispatcher to whom the incident has been assigned.

CANCEL_REASON

Reason the incident was cancelled.

NETWORK_LEVEL

This value indicates the grouping to which the incident device belongs. For example, incidents may be grouped by distribution vs. transmission. In this case all incident devices would have a Network Level value of distribution or transmission.

AMI_EVENT

The type of outage reported by the meter (e.g., No Power, Partial Power).

Return to Top

RX_LOADPOINTS

Field Name

Description

DEVICE_OID

The object ID of the incident device affecting the loadpoint (e.g., service point or transformer). This field links to the OID field in your geodatabase.

DEVICE_FCID

The feature class ID of the incident device affecting the loadpoint (e.g., service point or transformer). This field utilizes the DEVICE_FCID domain.

INCIDENT_ID

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

TIME_OUTAGE

The time the outage occurred.

TIME_RESTORED

The time power is actually restored.

CUSTOMER_COUNT

Indicates the number of customers affected by the incident.

CRITICAL_CUSTOMER_COUNT

Indicates the number of critical customers affected by the incident.

PRIORITY_CUSTOMER_COUNT

Indicates the number of priority customers affected by the incident.

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.

INCIDENT_DEVICE_OID

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

INCIDENT_DEVICE_FCID

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

CUSTOMER_ACCOUNT

The customer's account number.

Return to Top

RX_OPERATIONS

Field Name

Description

ORDER_ID

The ID associated with a switching order (foreign key to RX_SWITCHING_ORDERS).

SEQUENCE

The sequence number of the operation (the step number in the switching order).

TYPE

Indicates the type of operation (custom, tag, or device).

DESCRIPTION

Description of the operation (e.g., "Open", "Remove Ground", "Place Tag").

FCID

Feature class ID of the feature that was operated upon.

OID

Object ID of the feature that was operated upon.

SUBID

The unique ID of each segment of a complex edge.

X

The x-coordinate of the incident device.

Y

The y-coordinate of the incident device.

FACILITY_ID

The Facility ID of the incident device as defined in the geodatabase.

SUBSTATION_ID

The ID of the substation that feeds the incident device.

FEEDER_ID

The Feeder ID of the incident device.

OPERATION_STATUS

Indicates whether the operation has been executed, not executed, or cancelled.

EXECUTED_BY

User name of the person who executed the operation.

TIME_EXECUTED

The time the operation was executed.

REMARKS

Remarks associated with the operation.

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.

OWNER_STATE

This field tracks the state of a switching operation with regard to an external owner of a device. This field uses the Owner_State domain.

OWNER_TIME_APPROVED

This field tracks the time of approval by an external owner of the device (e.g., OASyS).

EXECUTED_BY_NAME

The name of the user who executed the switching order operation.

LINE_TYPE

Indicates the type of operation (e.g., open close, tag, etc.).

SUMMARY

Any summary comments included by the user on the switching order operation.

PARENT_SEQUENCE_ID

This value acts as a group number when grouping operations within a switching order. All operations in the same group share the same PARENT_SEQUENCE_ID.

Return to Top

RX_PENDING_ELEMENT_LOCKS

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_PERMISSION

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_PROBABLE_STATE_CANDIDATE

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_REGION_ASSIGNMENTS

Field Name

Description

REGION_ID

The ID of the region.

USER_ID

The ID of the user to which the region is assigned. This field serves as a foreign key to the RX_USERS table.

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.

Return to Top

RX_REGION_ETR

This table holds the estimated time of restoration (ETR) for a specific region.

Field Name

Description

REGION_ID

The ID of the region.

ESTIMATED_TIME

The estimated time of restoration.

ETR_COMMENT

Any comments associated with the estimated restoration time.

Return to Top

RX_REGION_MODE_ASSIGNMENTS

Field Name

Description

REGION_ID

The ID of the region.

REGION_NAME

The name assigned to the region.

P_MODE

The current prediction mode for the region (e.g., night, default, storm).

AUTO_CHANGE

Indicates whether Auto Change has been enabled on the region.

Return to Top

RX_RMA_TIMES

Field Name

Description

REGION_ID

The ID of the region.

REGION_NAME

The name assigned to the region.

P_MODE

The current prediction mode for the region (e.g., night, default, storm).

MODE_STARTS_UTC

The time that a Prediction mode starts when using Auto Change to set Prediction modes. The value in this table is stored as Coordinated Universal Time (UTC) or Greenwich Mean Time (GMT).

Return to Top

RX_ROLE

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_ROLE_TASKS

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_SIMULATED_SO_LOADPOINTS

Field Name

Description

OID

Object ID of the feature that was operated upon.

FCID

Feature class ID of the feature that was operated upon.

SWITCHING_ORDER_ID

The unique ID assigned to the switching order.

Return to Top

RX_SWITCHING_FOLDERS

Field Name

Description

NAME

Display name for the folder.

PARENT_FOLDER_ID

ID that corresponds to the folder in which the current folder resides.

Return to Top

RX_SWITCHING_ORDERS

Field Name

Description

NAME

The user-defined name of the switching order.

INCIDENT_ID

The ID of the incident associated with the switching order.

TYPE

Indicates a switching order or a restoration plan.

TIME_BEGIN

Start time for the switching order.

TIME_END

Finish time for the switching order.

REQUESTED_BY

Name of the person who requested the switching order.

TIME_REQUESTED

The time the switching order was requested.

CREATED_BY

The user name of the person who created the switching order.

TIME_CREATED

The time the switching order was created.

APPROVED_BY

User name of the person who approved the switching order.

TIME_APPROVED

The time that the switching order was approved.

REMARKS

Remarks associated with the switching order.

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.

REGION

The region in which the incident resides.

STATUS

Indicates the status of the switching order. This field uses the STATUS domain.

FOLDER_ID

ID of the Switching Order Library folder in which the switching order resides. This field corresponds to the ID field in the SWITCHING_ORDER_FOLDERS table.

Return to Top

RX_SWITCHING_ORDER_FEATURES

Field Name

Description

OID

Object ID of the feature that was operated upon.

FCID

Feature class ID of the feature that was operated upon.

SUBID

The unique ID of each segment of a complex edge.

X

The x-coordinate of the incident device.

Y

The y-coordinate of the incident device.

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.

FACILITY_ID

The Facility ID of the incident device as defined in the geodatabase.

REGION

The region in which the switching order feature is located. This field uses the REGION domain.

SUBSTATION

The substation that feeds the device.

COMMENTS

Notes from the operator or dispatcher.

ENABLED

Not used.

SUBTYPE

The subtype of the device.

FEEDER_ID

The ID of the feeder.

PHASE_DESIGNATION

The phase designation of the device.

OPERATING_VOLTAGE

The operating voltage of the device.

NAME

The name assigned to the device.

SW_ORDER_REQUEST_ID

The unique ID assigned to the switching order request.

AFFECTS_ENERGIZATION

Indicates whether the feature participates in the geometric network (electric device) or not (location feature).

Return to Top

RX_SWITCHING_REQUESTS

Field Name

Description

TOTAL_CUSTOMERS_COUNT

The total number of customers affected by the switching order request.

CRITICAL_CUSTOMERS_COUNT

The number of critical customers affected by the switching order request.

PRIORITY_CUSTOMERS_COUNT

The number of priority customers affected by the switching order request.

NAME

The name associated with the switching order request.

PHONE_NUMBER

The phone number associated with the switching order request.

FEEDER_ID

The ID of the feeder.

REGION

The region in which the switching order feature is located. This field uses the REGION domain.

SHORT_DESCRIPTION

The short description provided with the switching order request.

PLANNED_BEGIN_TIME

The planned time for the work in the request to begin.

PLANNED_END_TIME

The planned time for the work in the request to be completed.

REASON

The reason provided for the switching order request.

STATUS

The status of the switching order request.

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.

REQUEST_REFERENCE

The reference number assigned to the request.

SWITCHING_ORDER_ID

The unique ID that identifies the switching order to which the request has been assigned.

Return to Top

RX_SW_OR_AFFECTED_LOADPOINTS

Field Name

Description

OID

Object ID of the feature associated with the loadpoint.

FCID

Feature class ID of the feature associated with the tag.

SW_ORDER_REQUEST_ID

The unique ID that identifies the switching order request to which the loadpoint was assigned.

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.

Return to Top

RX_SW_OR_AFFECTED_XFRS

Field Name

Description

REQUEST_ID

The unique ID that identifies the switching order request to which the transformer was assigned.

OID

Object ID of the feature associated with the loadpoint.

FCID

Feature class ID of the feature associated with the tag.

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.

Return to Top

RX_TAG_AND_GROUND_STEPS

Field Name

Description

TAG_ID_1

ID of the tag.

TAG_ID_2

ID of the tag.

TAG_ID_3

ID of the tag.

OPERATION_ID

ID associated with the operation (foreign key to RX_OPERATIONS).

TAG_TYPE

The type of tag placed.

PHASES

Indicates which phases are affected.

ACTION

Indicates whether the action is a place or remove.

GROUND

Indicates whether the step is a ground (yes/no).

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.

TAG_GUID

The GUID assigned to the tag.

Return to Top

RX_TAGS_AND_GROUNDS

Field Name

Description

TAG_ID_1

ID of the tag.

TAG_ID_2

ID of the tag.

TAG_ID_3

ID of the tag.

FCID

Feature class ID of the feature associated with the tag.

OID

Object ID of the feature associated with the tag.

SUBID

The unique ID of each segment of a complex edge.

X

The x-coordinate of the incident device.

Y

The y-coordinate of the incident device.

TAG_TYPE

Indicates the type of tag (e.g., Information, Do Not Operate, Do Not Close).

PHASES

Indicates which phases are affected.

GROUND

Indicates whether the step is a ground (yes/no).

FACILITY_ID

The Facility ID of the incident device as defined in the geodatabase.

OWNER

The tag owner (who placed the tag).

TIME_PLACED

Time that the tag was placed.

TIME_REMOVED

Time that the tag was removed.

REMARKS

Remarks associated with the tag.

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.

REGION

The region in which the tag or ground is located. This field uses the REGION domain.

ORIGINATION

Indicates where the tag was originated (i.e., manual or switching order). Any tags originated within a switching order may not be deleted in the Tags window.

SUMMARY

The summary text provided on the tag.

OWNER_NAME

The name of the tag's owner.

TAG_GUID

The GUID assigned to the tag.

Return to Top

RX_TASK

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_TASK_PERMISSIONS

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_TRUCKS

Populate this table with your truck information.

Field Name

Description

REGION

The region in which the truck is located. This field uses the REGION domain.

TRUCK_TYPE

The type of truck.

RADIO1

The radio frequency at which the crew can be reached.

RADIO2

An alternative radio frequency at which the crew can be reached.

COMPANY

The company to which the truck belongs. This field uses the COMPANY domain.

STATUS

The status of the truck. This field uses the STATUS domain.

CREW_ID

Indicates the crew to which the truck is assigned. This field acts as a foreign key to the RX_CREWS table.

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.

TRUCK_NUMBER

This optional field holds company ID values (e.g., license plate numbers, inventory numbers). This string field holds up to 15 characters.

Return to Top

RX_USER_MEMBERSHIP

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_USER_ROLES

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_USERS

This table is for internal use only. Do not modify the data in this table.

Return to Top

RX_XLOCK

This table is for internal use only. Do not modify the data in this table.

Field Name	Description
DEVICE_OID	The object ID of the device to which the customer is associated. 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. 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.
INCIDENT_DEVICE_OID	The object ID of the device to which the incident is associated. This field links to the OID field in your geodatabase.
INCIDENT_DEVICE_FCID	The feature class ID of the device to which the incident is associated. This field utilizes the DEVICE_FCID domain.
INCIDENT_DEVICE_SUBID	The unique ID of each segment of a complex edge.
TIME_OUTAGE	The time the outage occurred.
TIME_RESTORED	The time the customer's power was restored.
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.

Field Name	Description
ACCOUNT	The customer's account number. This is a foreign key to the RX_CUSTOMERS table. Acts as a primary key for this table.
INCIDENT_ID	The ID associated with the incident resulting from the call. This field acts as a foreign key to the RX_INCIDENTS table.
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.
REGION	The region in which the incident is located. This field uses the REGION domain.
PRIORITY	The priority of the call (how high it will appear on the callback list), sorted descending (i.e., the larger priority number will be called first).
REASON	The reason for the callback (e.g., estimated time of restoration is about to expire).
RETRY_COUNT	The running number of retries.
MIN_RETRY_COUNT	The minimum number of times to attempt calling back (before auto-delete, if enabled, will delete a callback record).
AUTO_DELETE	Indicates whether a callback should be deleted automatically. This field uses the YES_NO domain (do not edit this domain). This field should not be edited.
BUSY_WAIT	Time (in minutes) to wait until the next callback if there is a busy signal.
NO_ANSWER_WAIT	Time (in minutes) to wait for the next callback if there is no answer.
PREV_RESULT	The result of the last callback attempt.
PREV_CALLER	The caller who performed the last callback attempt.
PREV_CALL_TIME	The time of the last callback attempt.
NEXT_CALL_TIME	The earliest time the next callback attempt should take place.
CALLING	Flag to note if the callback is currently be processed. This field uses the YES_NO domain (do not edit this domain).
CALLING_EXPIRES	The amount of time before the currently loaded callback is returned to the queue if no action is taken. This value corresponds with the MinutesCallingValid value in DataServices.exe.config.
CALLER_TYPE	Who made the last callback. This field uses the CALLER_TYPE domain (do not edit this domain).
COMMENTS	Notes from the operator or dispatcher.

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.
COOKTIME_UTC	Indicates the coordinated universal time that the call will be eligible for prediction by the enhanced Prediction Engine. This is a date/time field.
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.

Field Name	Description
INCIDENT_ID	Indicates the ID of the incident to which the crew has been assigned. This field is a foreign key to the RX_INCIDENTS table.
CREW_ID	Indicates the ID of the crew that has been assigned to the incident. This field is a foreign key to the RX_CREWS table.
STATUS	Indicates the status of the crew. This field uses the STATUS domain.
TIME ASSIGNED	The time the crew was assigned to the incident.
IS_LEAD_CREW	Indicates whether the crew is the lead crew. This field uses the IS_LEAD_CREW domain.
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.
TIME_STATUS_CHANGED	This is the time that a crew's status was changed (e.g., from Dispatched to Working) after it was modified by a dispatcher.
PREVIOUS_TIME	This is the original time that the crew's status was set.
MOBILE_CREW_ENABLED	A value that indicates whether the crew has been assigned a Mobile status.

Field Name	Description
REGION	Indicates the region in which the crew member works primarily. This field uses the REGION domain.
UTILITY_TYPE	Indicates the type of utility for which the crew member works (gas, electric, water, cable). This field uses the UTILITY_TYPE domain.
CREW_ID	Indicates the crew to which the member is assigned. This field acts as a foreign key to the RX_CREWS table.
FIRSTNAME	The crew member's first name.
LASTNAME	The crew member's last name.
TITLE	The crew member's title. This field uses the TITLE domain.
EMPLOYEE_ID	The crew member's employee ID.
MOBILE_PHONE	The crew member's mobile phone number.
HOME_PHONE	The crew member's home phone number.
PAGER	The crew member's pager number.
RADIO_NUMBER	The crew member's radio number.
COMPANY	The company for which the crew member works. This field uses the COMPANY domain.
AVAILABLE	Indicates the crew member's availability. This field uses the AVAILABLE domain.
EXPERTISE	Indicates the crew member's expertise. This field uses the EXPERTISE domain.
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.

Field Name	Description
CREW_NAME	The name of the crew.
REGION	The region in which the crew works. This field uses the REGION domain.
CREW_TYPE	The type assigned to the crew.
COMPANY	The company for which the crew works. This field uses the COMPANY domain.
STATUS	The status of the crew. This field uses the STATUS domain.
FOREMAN_EMP_ID	The employee ID of the crew's foreman.
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.
MOBILE_CREW	A value that indicates whether the crew is mobile.
MOBILE_LAST_UPDATE	A date field that indicates the date of the last update by the mobile crew.

Field Name	Description
IDX	The unique ID assigned to the fault location.
OID	Object ID of the feature.
FCID	Feature class ID of the feature.
SUBID	The unique ID of each segment of a complex edge.
FACILITY_ID	The Facility ID of the incident feature as defined in the geodatabase.
X	The x-coordinate of the incident feature.
Y	The y-coordinate of the incident feature.
INCIDENT_ID	The ID associated with the incident. This field corresponds with the ID field in the RX_INCIDENTS table.
PROBABILITY	The percentage of probability that the fault location is accurate.
USER_CREATED	This field is not currently used by Responder. You may customize Responder to populate this field with the name of the user who created the record.
USER_UPDATED	This field is not currently used by Responder. You may customize Responder to populate this field with the name of the user who updated the record.

Field Name	Description
FEEDER_ID	The ID of the feeder.
ESTIMATED_TIME	The estimated time of restoration.
ETR_COMMENT	Any comments associated with the estimated restoration time.

Field Name	Description
FCID	The feature class ID of the feature impacted by an incident.
OID	The object ID of the feature impacted by an incident.
GLOBALID	The GlobalID (GUID) of the feature impacted by an incident.
FCID_ACTUAL	Currently not used by Responder. This field should contain the FCID of the feature as it appears in the replicated database.
OID_ACTUAL	Currently not used by Responder. This field should contain the OID of the feature as it appears in the replicated database.

Field Name	Description
HAZARD_ID	The ID of the hazard. This field serves as a foreign key to the RX_HAZARDS table.
CREW_ASSIGNMENT_ID	The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.
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.

Field Name	Description
INCIDENT_ID	The ID associated with the hazard. This field acts as a foreign key to the RX_INCIDENTS table.
CALL_ID	The unique identifier associated with the call. This field corresponds with the ID field in the RX_CALLS table.
FCID	Feature class ID of the feature associated with the tag.
OID	Object ID of the feature associated with the tag.
SUBID	The unique ID of each segment of a complex edge.
FACILITY_ID	The Facility ID of the incident device as defined in the geodatabase.
REGION	The region in which the hazard exists. This field uses the REGION domain.
X	The x-coordinate of the incident device.
Y	The y-coordinate of the incident device.
DAMAGE_TYPE	This is the hazard type. This field uses the HAZARD_TYPE domain.
STATUS	Indicates the status of the hazard. This field uses the STATUS domain.
WIRE_OWNER	The owner of the "wires down" hazard. This field uses the HAZARD_TYPE_OWNER domain.
TIME_CREATED	The time the hazard incident was created.
TIME_COMPLETED	Indicates the time that the hazard was fixed.
TIME_SECURED	Indicates the time that the hazard was made secure.
TIME_PUBLIC_SAFETY_ARR	The time a public safety official arrived at the hazard scene.
TIME_PUBLIC_SAFETY_REL	The time a public safety official was relieved from the hazard scene.
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.
CANCEL_REASON	Reason the hazard was cancelled.

Field Name	Description
INCIDENT_DEVICE_ID	The ID of the hazard. This field serves as a foreign key to the RX_HAZARDS table.
CREW_ASSIGNMENT_ID	The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.
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.

Field Name	Description
INCIDENT_FEATURE_ID	The ID of the hazard. This field serves as a foreign key to the RX_HAZARDS table.
CREW_ASSIGNMENT_ID	The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.
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.

Field Name	Description
OPERATION_ID	The ID field from RX_OPERATIONS (foreign key).
EXPECTED_STATUS	The expected or normal status of the device (open, closed).
PLANNED_STATUS	The planned status of the device (e.g, Open, Closed).
PLANNED_CUSTOMER_COUNT	The number of customers affected by a planned step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).
PLANNED_CRITICAL_COUNT	The number of critical customers affected by a planned step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).
PLANNED_CONNECTED_LOAD	Amount (in kVA) by which the total system connected load will change due to the planned step.
EXECUTED_CUSTOMER_COUNT	The number of customers affected by an executed step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).
EXECUTED_CRITICAL_COUNT	The number of critical customers affected by an executed step. This value indicates a net change in the number of energized customers. It will be either a positive number (power restored to customers) or negative number (customers losing power).
EXECUTED_CONNECTED_LOAD	Amount (in kVA) by which the total system connected load will change due to the executed step.
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.
ACTUAL_STATUS	The current actual status of the device (open, closed).
ACTION	The action to be taken by the operation (e.g., open, close).
PHASES	The phase(s) to be operated by the step.

Field Name	Description
DEVICE_OID	The object ID of the incident device (e.g., service point or transformer). This field links to the OID field in your geodatabase.
DEVICE_FCID	The feature class ID of the incident device (e.g., service point or transformer). This field utilizes the DEVICE_FCID domain.
SUBID	The unique ID of each segment of a complex edge.
X	The x-coordinate of the incident device.
Y	The y-coordinate of the incident device.
INCIDENT_ID	The ID associated with the incident. This field acts as a foreign key to the RX_INCIDENTS table.
TIME_OPERATION	The time the device was opened or closed for repair.
FEEDER_ID	The Feeder ID of the incident device.
SUBSTATION	The substation that feeds the incident device.
CONFIRMED	Indicates whether the device has been confirmed out. This field uses the CONFIRMED domain.
DEVICE_OPERATION	Indicates the type of operation the device performs (Fault/Switching Operation). This field uses the DEVICE_OPERATION domain.
CUSTOMER_COUNT	Indicates the number of customers affected by the incident.
CRITICAL_CUSTOMER_COUNT	Indicates the number of critical customers affected by the incident.
PRIORITY_CUSTOMER_COUNT	Indicates the number of priority customers affected by the incident.
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.
FACILITY_ID	The Facility ID of the incident device as defined in the geodatabase.
EXPECTED_STATUS	The expected or normal status of the device (open, closed).
ACTUAL_STATUS	The current actual status of the device (open, closed).
REGION	The region in which the device resides. This field uses the REGION domain.
CANCEL_REASON	Reason the device was cancelled.

Field Name	Description
STATUS	The status of the incident. This field uses the STATUS domain.
REGION	The region in which the incident is located. This field uses the REGION domain.
CRITICAL	Indicates if the incident is at a customer site that is critical. This field uses the CRITICAL domain.
CAUSE	Indicates the cause of the outage. This field uses the CAUSE domain.
WEATHER	Indicates the weather at the incident site. This field uses the WEATHER domain.
TROUBLE	Indicates the problem reported by the customer (e.g., no power, flickering lights, etc.). This field uses the TROUBLE domain.
CUSTOMER_COUNT	Indicates the number of customers affected by the incident.
CRITICAL_CUSTOMER_COUNT	Indicates the number of critical customers affected by the incident.
PRIORITY_CUSTOMER_COUNT	Indicates the number of priority customers affected by the incident.
FEEDER_ID	The Feeder ID of the incident device.
SUBSTATION	The substation that feeds the incident device.
TIME_CREATED	The time the incident was created.
TIME_OUTAGE	The time the outage occurred.
TIME_RESTORED_EST	The time power is estimated to be restored.
TIME_RESTORED	The time power is actually restored.
REMARKS_DISPATCH	Remarks from the dispatcher.
REMARKS_FIELD	Remarks from the field crew.
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.
CONFIRMED	Indicates whether the device has been confirmed out. This field uses the CONFIRMED domain.
ORIGINATION	Indicates whether an incident was created by a user or by Prediction Services.
OWNER	The dispatcher to whom the incident has been assigned.
CANCEL_REASON	Reason the incident was cancelled.
NETWORK_LEVEL	This value indicates the grouping to which the incident device belongs. For example, incidents may be grouped by distribution vs. transmission. In this case all incident devices would have a Network Level value of distribution or transmission.
AMI_EVENT	The type of outage reported by the meter (e.g., No Power, Partial Power).

Field Name	Description
DEVICE_OID	The object ID of the incident device affecting the loadpoint (e.g., service point or transformer). This field links to the OID field in your geodatabase.
DEVICE_FCID	The feature class ID of the incident device affecting the loadpoint (e.g., service point or transformer). This field utilizes the DEVICE_FCID domain.
INCIDENT_ID	The ID associated with the incident associated with the loadpoint. This field acts as a foreign key to the RX_INCIDENTS table.
TIME_OUTAGE	The time the outage occurred.
TIME_RESTORED	The time power is actually restored.
CUSTOMER_COUNT	Indicates the number of customers affected by the incident.
CRITICAL_CUSTOMER_COUNT	Indicates the number of critical customers affected by the incident.
PRIORITY_CUSTOMER_COUNT	Indicates the number of priority customers affected by the incident.
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.
INCIDENT_DEVICE_OID	The object ID of the device to which the incident is associated (e.g., service point or transformer). This field links to the OID field in your geodatabase.
INCIDENT_DEVICE_FCID	The feature class ID of the device to which the incident is associated (e.g., service point or transformer). This field utilizes the DEVICE_FCID domain.
CUSTOMER_ACCOUNT	The customer's account number.

Field Name	Description
ORDER_ID	The ID associated with a switching order (foreign key to RX_SWITCHING_ORDERS).
SEQUENCE	The sequence number of the operation (the step number in the switching order).
TYPE	Indicates the type of operation (custom, tag, or device).
DESCRIPTION	Description of the operation (e.g., "Open", "Remove Ground", "Place Tag").
FCID	Feature class ID of the feature that was operated upon.
OID	Object ID of the feature that was operated upon.
SUBID	The unique ID of each segment of a complex edge.
X	The x-coordinate of the incident device.
Y	The y-coordinate of the incident device.
FACILITY_ID	The Facility ID of the incident device as defined in the geodatabase.
SUBSTATION_ID	The ID of the substation that feeds the incident device.
FEEDER_ID	The Feeder ID of the incident device.
OPERATION_STATUS	Indicates whether the operation has been executed, not executed, or cancelled.
EXECUTED_BY	User name of the person who executed the operation.
TIME_EXECUTED	The time the operation was executed.
REMARKS	Remarks associated with the operation.
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.
OWNER_STATE	This field tracks the state of a switching operation with regard to an external owner of a device. This field uses the Owner_State domain.
OWNER_TIME_APPROVED	This field tracks the time of approval by an external owner of the device (e.g., OASyS).
EXECUTED_BY_NAME	The name of the user who executed the switching order operation.
LINE_TYPE	Indicates the type of operation (e.g., open close, tag, etc.).
SUMMARY	Any summary comments included by the user on the switching order operation.
PARENT_SEQUENCE_ID	This value acts as a group number when grouping operations within a switching order. All operations in the same group share the same PARENT_SEQUENCE_ID.

Field Name	Description
REGION_ID	The ID of the region.
USER_ID	The ID of the user to which the region is assigned. This field serves as a foreign key to the RX_USERS table.
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.

Field Name	Description
REGION_ID	The ID of the region.
REGION_NAME	The name assigned to the region.
P_MODE	The current prediction mode for the region (e.g., night, default, storm).
AUTO_CHANGE	Indicates whether Auto Change has been enabled on the region.

Field Name	Description
NAME	Display name for the folder.
PARENT_FOLDER_ID	ID that corresponds to the folder in which the current folder resides.

Field Name	Description
NAME	The user-defined name of the switching order.
INCIDENT_ID	The ID of the incident associated with the switching order.
TYPE	Indicates a switching order or a restoration plan.
TIME_BEGIN	Start time for the switching order.
TIME_END	Finish time for the switching order.
REQUESTED_BY	Name of the person who requested the switching order.
TIME_REQUESTED	The time the switching order was requested.
CREATED_BY	The user name of the person who created the switching order.
TIME_CREATED	The time the switching order was created.
APPROVED_BY	User name of the person who approved the switching order.
TIME_APPROVED	The time that the switching order was approved.
REMARKS	Remarks associated with the switching order.
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.
REGION	The region in which the incident resides.
STATUS	Indicates the status of the switching order. This field uses the STATUS domain.
FOLDER_ID	ID of the Switching Order Library folder in which the switching order resides. This field corresponds to the ID field in the SWITCHING_ORDER_FOLDERS table.

Field Name	Description
TOTAL_CUSTOMERS_COUNT	The total number of customers affected by the switching order request.
CRITICAL_CUSTOMERS_COUNT	The number of critical customers affected by the switching order request.
PRIORITY_CUSTOMERS_COUNT	The number of priority customers affected by the switching order request.
NAME	The name associated with the switching order request.
PHONE_NUMBER	The phone number associated with the switching order request.
FEEDER_ID	The ID of the feeder.
REGION	The region in which the switching order feature is located. This field uses the REGION domain.
SHORT_DESCRIPTION	The short description provided with the switching order request.
PLANNED_BEGIN_TIME	The planned time for the work in the request to begin.
PLANNED_END_TIME	The planned time for the work in the request to be completed.
REASON	The reason provided for the switching order request.
STATUS	The status of the switching order request.
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.
REQUEST_REFERENCE	The reference number assigned to the request.
SWITCHING_ORDER_ID	The unique ID that identifies the switching order to which the request has been assigned.

Field Name	Description
REQUEST_ID	The unique ID that identifies the switching order request to which the transformer was assigned.
OID	Object ID of the feature associated with the loadpoint.
FCID	Feature class ID of the feature associated with the tag.
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.

Field Name	Description
TAG_ID_1	ID of the tag.
TAG_ID_2	ID of the tag.
TAG_ID_3	ID of the tag.
OPERATION_ID	ID associated with the operation (foreign key to RX_OPERATIONS).
TAG_TYPE	The type of tag placed.
PHASES	Indicates which phases are affected.
ACTION	Indicates whether the action is a place or remove.
GROUND	Indicates whether the step is a ground (yes/no).
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.
TAG_GUID	The GUID assigned to the tag.

Field Name	Description
REGION	The region in which the truck is located. This field uses the REGION domain.
TRUCK_TYPE	The type of truck.
RADIO1	The radio frequency at which the crew can be reached.
RADIO2	An alternative radio frequency at which the crew can be reached.
COMPANY	The company to which the truck belongs. This field uses the COMPANY domain.
STATUS	The status of the truck. This field uses the STATUS domain.
CREW_ID	Indicates the crew to which the truck is assigned. This field acts as a foreign key to the RX_CREWS table.
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.
TRUCK_NUMBER	This optional field holds company ID values (e.g., license plate numbers, inventory numbers). This string field holds up to 15 characters.