Version: 10.1

Resource Center Home

As calls and incidents are added and updated in Responder Explorer, the data is collected and stored in the Responder History tables.

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

RX_AFFECTED_XFRS_HISTORY

Field Name	Description
AFFECTED_XFR_ID	The ID associated with the affected transformer. This field corresponds with the ID field in the RX_AFFECTED_XFRS table.
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.
CHANGE_DATE	The time and date an operation was performed on the callback record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.

 

Return to Top

 

RX_CALLBACKS_HISTORY

Field Name	Description
ACCOUNT	The customer's account number.
INCIDENT_ID	The ID associated with the incident resulting from the call. This field corresponds with the ID field in the RX_INCIDENTS table.
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. 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 previous callback. This field uses the CALL_RESULT domain.
PREV_CALLER	The operator who attempted the previous callback.
PREV_CALL_TIME	The time that the previous call was attempted.
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.
CALLER_TYPE	Who made the last callback. This field uses the CALLER_TYPE domain.
COMMENTS	Notes from the operator or dispatcher.
CHANGE_DATE	The time and date an operation was performed on the callback record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.

 

Return to Top

 

RX_CALLS_HISTORY

Field Name	Description
CALL_ID	The unique identifier associated with the call. This field corresponds with the ID field in the RX_CALLS table.
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 CALL_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 corresponds with the ID field in the RX_INCIDENTS table.
CUSTOMER_ACCOUNT	The customer's account number.
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	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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
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_HISTORY

Field Name	Description
ASSIGNMENT_ID	The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.
INCIDENT_ID	The ID associated with the incident to which the crew has been assigned. This field corresponds with the ID field in the RX_INCIDENTS table.
CREW_ID	Indicates the ID for the crew that has been assigned to the incident. This field corresponds to the ID field in 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.
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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
IS_LEAD_CREW	Indicates whether the crew is the lead crew. This field uses the IS_LEAD_CREW domain.
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.

 

Return to Top

 

RX_CREW_MEMBERS_HISTORY

Field Name	Description
CREW_MEMBER_ID	The unique identifier assigned to the crew member. This field corresponds to the ID field in the RX_CREW_MEMBERS table.
REGION	Indicates the region in which the crew member works primarily. This field uses the REGION virtual 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 ID fo the crew to which the members have been assigned. This field corresponds to the ID field in 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	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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.

 

Return to Top

 

RX_CREWS_HISTORY

Field Name	Description
CREW_ID	Indicates the ID fo the crew. This field corresponds to the ID field in the RX_CREWS table.
CREW_NAME	The name of the crew.
REGION	The region in which the crew works. This field uses the REGION virtual domain.
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	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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
CREW_TYPE	The type assigned to the crew.

 

Return to Top

 

RX_HAZARD_ASSIGN_HISTORY

Field Name	Description
HAZARD_ASSIGN_ID	The ID of the hazard assignment. This field serves as a foreign key to the RX_HAZARD_ASSIGNMENTS table.
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.
CHANGE_DATE	The date an operation was performed on the hazard record.
OPERATION	The operation (e.g., insert, delete, update) performed on the hazard record.

 

Return to Top

 

RX_HAZARDS_HISTORY

Field Name	Description
HAZARD_ID	The ID associated with the hazard. This field acts as a foreign key to the RX_HAZARDS table.
INCIDENT_ID	The ID associated with the incident. 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 fo 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.
CHANGE_DATE	The time and date an operation was performed on the callback record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident device.

 

Return to Top

 

RX_INC_DEV_ASSIGN_HISTORY

Field Name	Description
INC_DEV_ASSIGN_ID	The ID of the device assignment. This field serves as a foreign key to the RX_INC_DEV_ASSIGNMENTS table.
INCIDENT_DEVICE_ID	The ID of the incident device. This field serves as a foreign key to the RX_INCIDENT_DEVICES 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.
CHANGE_DATE	The date an operation was performed on the incident device.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident device.

 

Return to Top

 

RX_INC_DEVICE_STEPS_HISTORY

Field Name	Description
OPERATION_ID	This field corresponds to the ID field in the RX_OPERATIONS table.
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	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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
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_INC_FEAT_ASSIGN_HISTORY

Field Name	Description
INC_FEATURE_ASSIGN_ID	The ID of the incident feature. This field serves as a foreign key to the RX_INC_FEAT_ASSIGNMENTS table.
INCIDENT_FEATURE_ID	The ID of the incident feature. This field serves as a foreign key to the RX_INCIDENT_FEATURES 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.
CHANGE_DATE	The date an operation was performed on the feature.
OPERATION	The operation (e.g., insert, delete, update) performed on the feature.

 

Return to Top

 

RX_INCIDENT_DEVICES_HISTORY

Field Name	Description
INCIDENT_DEVICE_ID	The unique identifier assigned to the incident device. This field corresponds to the ID field in the RX_INCIDENT_DEVICES table.
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.
INCIDENT_ID	The ID associated with the incident. This field corresponds with the ID field in 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	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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
FACILITY_ID	The Facility ID of the incident feature 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).
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.
CANCEL_REASON	Reason the device was cancelled.
REGION	The region in which the device resides. This field uses the REGION domain.

 

Return to Top

 

RX_INCIDENT_FEATURES_HISTORY

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
INCIDENT_FEATURE_ID	The unique identifier assigned to the incident feature. This field corresponds to the ID field in the RX_INCIDENT_FEATURES table.
OID	Object ID fo 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 corresponds with the ID field in 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	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.
REMARKS	Notes from the operator or dispatcher.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
CANCEL_REASON	Reason the feature was cancelled.
REGION	The region in which the feature resides. This field uses the REGION domain.

 

Return to Top

 

RX_INCIDENTS_HISTORY

Field Name	Description
INCIDENT_ID	The ID associated with the incident. This field corresponds with the ID field in the RX_INCIDENTS table.
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.
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	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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
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.
TROUBLE	Indicates the problem reported by the customer (e.g., no power, flickering lights, etc.). This field uses the TROUBLE domain.
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_HISTORY

Field Name	Description
LOADPOINT_ID	The unique identifier assigned to the loadpoint. This field corresponds to the ID field in the RX_LOADPOINTS table.
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 corresponds with the ID field in 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.
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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
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.
PRIORITY_CUSTOMER_COUNT	Indicates the number of priority customers affected by the incident.
CUSTOMER_ACOUNT	The customer's account number.

 

Return to Top

 

RX_OPERATIONS_HISTORY

Field Name	Description
ORDER_ID	The ID associated with a switching order. This field corresponds to the ID field in the RX_SWITCHING_ORDERS table.
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	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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
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.
TIME_OWNER_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_SWITCHING_ORDERS_HISTORY

Field Name	Description
NAME	The user-defined name of the switching order.
INCIDENT_ID	The ID associated with the incident associated with the switching order. This field corresponds with the ID field in the RX_INCIDENTS table.
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	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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
REGION	The region in which the incident is located. This field uses the REGION domain.
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_SW_OR_FEATURES_HISTORY

Field Name	Description
SW_OR_FEATURES_ID	The unique ID assigned to the switching order feature.
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 incident 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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
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_SW_OR_REQUESTS_HISTORY

Field Name	Description
SW_OR_REQUESTS_ID	The unique ID assigned to the switching order request.
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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.

 

Return to Top

  

RX_TAG_GROUND_STEPS_HISTORY

Field Name	Description
TAG_AND_GROUND_STEP_ID	A unique identifier for a tag or ground step. This field corresponds to the ID field in the RX_TAG_AND_GROUND_STEPS table.
TAG_ID_1	ID of the tag.
TAG_ID_2	ID of the tag.
TAG_ID_3	ID of the tag.
OPERATION_ID	This field corresponds to the ID field in the RX_OPERATIONS table.
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	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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
TAG_GUID	The GUID assigned to the tag.

 

Return to Top

 

RX_TAGS_AND_GROUNDS_HISTORY

Field Name	Description
TAG_AND_GROUND_ID	A unique identifier for a tag or ground. This field corresponds to the ID field in the RX_TAGS_AND_GROUNDS table.
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 fo 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	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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
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.
REGION	The region in which the device resides. This field uses the REGION domain.
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_TRUCKS_HISTORY

Field Name	Description
TRUCK_ID	The unique identifier assigned to the truck. This field corresponds to the ID field in the RX_TRUCKS table.
REGION	The region in which the truck is located. This field uses the REGION virtual 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 ID fo the crew to which the truck has been assigned. This field corresponds to the ID field in the RX_CREWS table.
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.
CHANGE_DATE	The date an operation was performed on the incident record.
OPERATION	The operation (e.g., insert, delete, update) performed on the incident record.
TRUCK_NUMBER	The number assigned to the truck.

---

Send Comment to documentation@schneider-electric.com