Configuring Responder
Responder Database Tables
Version: 10.2.1c and 10.2.1c SP3 |
| Responder Overview > Implement Responder > Data Preparation > 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.
 |
Information on FCID fields can be found in your geodatabase in the GDB_ITEMS and GDB_ITEMTYPES tables. |
 |
You can check the data architecture of each Responder table (i.e., field data type, field length) by viewing the SQL implementation scripts in your Miner and Miner\Responder\Developer Resources\Implementation Scripts directory. |
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.
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.
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.
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.
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.
RX_ELEMENT_LOCKS
This table is for internal use only. Do not modify the data in this table.
RX_EVENTS_FEEDERLOCK
This table is for internal use only. Do not modify the data in this table.
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.
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.
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.
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.
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.
RX_INC_DEV_ASSIGNMENTS
Field Name
Description
INCIDENT_DEVICE_ID
The ID of the device. This field serves as a foreign key to the RX_INCIDENT_DEVICES.
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.
RX_INC_FEAT_ASSIGNMENTS
Field Name
Description
INCIDENT_FEATURE_ID
The ID of the feature. 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.
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.
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.
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.
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).
RX_JUMPERS
Field Name
Description
ID
The ID associated with the Jumper.
JUMPER_FCID
Feature class ID of the Jumper.
JUMPER_OID
The object ID of the Jumper. This field links to the OID field in your geodatabase.
JUMPER_NAME
The name assigned to your Jumper.
TRACE_WEIGHT
Field containing information used by Feeder manager to utilize the Jumper when tracing the network.
WEIGHT_DESC
Description of phases connected by the Jumper.
EDGE_EID1
The edge element ID for the initial click of placing a Jumper.
EDGE_EID2
The edge element ID for the final click of placing a Jumper.
JUNCTION_EID1
The electrical junction to which the initial click of the Jumper is connected.
JUNCTION_EID2
The electrical junction to which the final click of the Jumper is connected.
USER_CREATED
The name of the user who created the jumper. This field is populated automatically by Responder.
USER_UPDATED
The name of the user who updated the jumper. This field is populated automatically by Responder.
FEEDER_ID
All Energized feeders to which either end of a Jumper is connected.
SUBSTATION
The Substations matching the Feeders in FEEDER_ID.
REGION
The region of the initial placement of the jumper.
TIME_OPERATION
Time when the jumper was placed in the field.
LOCATION
A text field that can be used to better indicate jumper location.
DISPATCHER
The name of the dispatcher assigned to the jumper. This field is set on the Place Jumper form.
CREW_MEMBER
The name of the crew member assigned to the jumper. This field is set on the Place Jumper form.
COMMENTS
Comments enetered in Responder Explorer for the jumper.
INCIDENT_ID
The ID associated with the incident associated with the jumper. This field acts as a foreign key to the RX_INCIDENTS table.
X1
The x-coordinate of the initial click of placing the jumper.
X2
The x-coordinate of the final click of placing the jumper.
Y1
The y-coordinate of the initial click of placing the jumper.
Y2
The y-coordinate of the final click of placing the jumper.
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.
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.
RX_PENDING_ELEMENT_LOCKS
This table is for internal use only. Do not modify the data in this table.
RX_PERMISSION
This table is for internal use only. Do not modify the data in this table.
RX_PROBABLE_STATE_CANDIDATE
This table is for internal use only. Do not modify the data in this table.
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.
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.
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.
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).
RX_ROLE
This table is for internal use only. Do not modify the data in this table.
RX_ROLE_TASKS
This table is for internal use only. Do not modify the data in this table.
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.
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.
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.
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).
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.
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.
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.
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.
RX_TASK
This table is for internal use only. Do not modify the data in this table.
RX_TASK_PERMISSIONS
This table is for internal use only. Do not modify the data in this table.
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.
RX_USER_MEMBERSHIP
This table is for internal use only. Do not modify the data in this table.
RX_USER_ROLES
This table is for internal use only. Do not modify the data in this table.
RX_USERS
This table is for internal use only. Do not modify the data in this table.
RX_XLOCK
This table is for internal use only. Do not modify the data in this table.
