Configuring Responder
Responder Archive Tables
Version: 10.2.1c and 10.2.1c SP3 |
| Responder Overview > Implement Responder > Data Preparation > Responder Archive Tables |
When an incident is closed or cancelled in Responder Explorer, it is added to the Responder Archive tables (assuming Archive Service is running). Use Archive Explorer to view the incidents added to the Archive tables.
Some of the fields in the Responder tables utilize domains. Domains may be edited in the ArchiveSchemaConfig.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_CALLS_ARCHIVE
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 TROUBLE domain.
CAUSE
Indicates the cause of the outage. This field uses the CAUSE 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. This field corresponds with the ID field in the RX_INCIDENTS table.
CUSTOMER_ACCOUNT
The customer's account number.
TROUBLE_AT_ACCOUNT
Indicates whether the trouble is located at the same location as the customer's account.
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.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
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.
CALLBACK_NUMBER
The telephone number at which the customer prefers to be called back. The area code of a phone number may not begin with a 1 or 0.
RX_CREW_ASSIGNMENTS_ARCHIVE
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. 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.
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.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
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.
RX_CREW_MEMBERS_ARCHIVE
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.
ASSIGNMENT_ID
The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.
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 ID for the crew to which the member has 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
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 record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
INCIDENT_ID
The ID associated with the incident. This field acts as a foreign key to the RX_INCIDENTS table.
RX_CREWS_ARCHIVE
Field Name
Description
CREW_ID
Unique identifier assigned to the crew. This is the table primary key.
CREW_NAME
The name of the crew.
CREW_TYPE
The type assigned to the crew.
REGION
The region in which the crew works. This field uses the REGION 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
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 record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
ASSIGNMENT_ID
The ID associated with the crew assignment. Corresponds to the ID field in the RX_CREW_ASSIGNMENTS table.
INCIDENT_ID
The ID associated with the incident. This field acts as a foreign key to the RX_INCIDENTS table.
RX_CUST_LOADPOINTS_ARCHIVE
Field Name
Description
CUSTOMER_ACCOUNT
The unique identifier assigned to the customer's account.
LOADPOINT_ID
The unique identifier assigned to the loadpoint. This field corresponds to the ID field in the RX_LOADPOINTS table.
RX_CUSTOMERS_ARCHIVE
Field Name
Description
ACCOUNT
The customer's account number.
ACCOUNT_TYPE
Indicates the type of account. Uses the Account_type domain.
METER
The customer's meter number.
FIRSTNAME
The customer's first name.
LASTNAME
The customer's last name.
STREET
The customer's street address.
CITY
The customer's city.
STATE
The customer's state.
POSTAL_CODE
The customer's zip code.
COUNTY
The customer's county.
TELEPHONE
The customer's telephone number.
TELEPHONE2
An alternate telephone number for the customer.
TELEPHONE3
An alternate telephone number for the customer.
TELEPHONE4
An alternate telephone number for the customer.
CALLBACK_NUMBER
Preferred number for contacting the customer.
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 customer is located. This field uses the REGION domain.
CONNECT_STATUS
Indicates the status of the user's connection (connected/disconnected). This field uses the CONNECT_STATUS domain.
TIME_DISCONNECT
Indicates the time the customer was disconnected.
TIME_RECONNECT
Indicates the time the customer's power was reconnected.
CRITICAL
Indicates if the customer site is critical. This field uses the CRITICAL_TYPE domain.
PRIORITY
Indicates if the customer site is priority. This field uses the PRIORITY 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.
USER_UPDATED_ARCH
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_CUSTOMERS
Field Name
Description
COUNT_DATE
The date the count was taken.
FEEDER_ID
The Feeder ID of the incident device.
CUSTOMER_COUNT
Indicates the number of customers on the feeder.
CRITICAL_CUSTOMER_COUNT
Indicates the number of critical customers on the feeder.
PRIORITY_CUSTOMER_COUNT
Indicates the number of priority customers on the feeder.
RX_HAZARD_ASSIGN_ARCHIVE
Field Name
Description
HAZARD_ASSIGN_ID
ID from the hazard assignment table. Corresponds to the ID field in 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 time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
INCIDENT_ID
The ID associated with the incident. This field acts as a foreign key to the RX_INCIDENTS table.
RX_HAZARDS_ARCHIVE
Field Name
Description
HAZARD_ID
ID associated with the hazard. Corresponds to the ID field in the RX_HAZARDS table.
INCIDENT_ID
The ID associated with the incident. This field corresponds with the ID field in 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 tag or ground is located. 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_SECURED
Indicates the time that the hazard was made secure.
TIME_COMPLETED
Indicates the time that the hazard was fixed.
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.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
CANCEL_REASON
Reason the hazard was cancelled.
RX_INC_DEVICE_STEPS_ARCHIVE
Field Name
Description
INCIDENT_DEVICE_STEP_ID
The ID associated with the device step.
OPERATION_ID
This field corresponds to the ID field in the RX_OPERATIONS table.
INCIDENT_ID
The ID associated with the incident. This field corresponds with the ID field in the RX_INCIDENTS 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).
ACTUAL_STATUS
The current actual status of the device (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.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
FCID
Feature class ID of the feature associated with the tag.
RX_INC_DEV_ASSIGN_ARCHIVE
Field Name
Description
INC_DEVICE_ASSIGN_ID
ID from the incident device assignment table. Corresponds to the ID field in the RX_INC_DEV_ASSIGNMENTS table.
INCIDENT_DEVICE_ID
The unique identifier assigned to the incident device. This field corresponds to the ID field in 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 time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
INCIDENT_ID
The ID associated with the incident. This field acts as a foreign key to the RX_INCIDENTS table.
RX_INC_FEAT_ASSIGN_ARCHIVE
Field Name
Description
INC_FEATURE_ASSIGN_ID
ID from the incident feature assignment table. Corresponds to the ID field in the RX_INC_FEAT_ASSIGNMENTS table.
INCIDENT_FEATURE_ID
The unique identifier assigned to the incident feature. This field corresponds to the ID field in 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 time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
INCIDENT_ID
The ID associated with the incident. This field acts as a foreign key to the RX_INCIDENTS table.
RX_INCIDENT_DEVICES_ARCHIVE
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.
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 corresponds with the ID field in the RX_INCIDENTS 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 time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
FEEDER_ID
The Feeder ID of the incident device.
FACILITY_ID
The Facility ID of the incident device as defined in the geodatabase.
REGION
The region in which the device is located. This field uses the REGION domain.
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.
EXPECTED_STATUS
The expected or normal status of the device (open, closed).
ACTUAL_STATUS
The current actual status of the device (open, closed).
CUSTOMER_COUNT
Indicates the number of customers affected by the incident.
TIME_OPERATION
The time the device was opened or closed for repair.
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_UPDATED_ARCH
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.
CANCEL_REASON
Reason the device was cancelled.
RX_INCIDENT_FEATURES_ARCHIVE
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.
REGION
The region in which the device is located. This field uses the REGION 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.
REMARKS
Notes from the operator or dispatcher.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
CANCEL_REASON
Reason the feature was cancelled.
RX_INCIDENTS_ARCHIVE
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.
OWNER
The dispatcher to whom the incident has been assigned.
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.
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.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
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.
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.
USER_UPDATED_ARCH
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.
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_LOADPOINTS_ARCHIVE
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. 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.
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 record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
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.
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.
USER_UPDATED_ARCH
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.
FEEDER_ID
The Feeder ID of the incident device.
CUSTOMER_ACCOUNT
Account number of the customer associated with the loadpoint.
RX_OPERATIONS_ARCHIVE
Field Name
Description
OPERATION_ID
This field corresponds to the ID field in the RX_OPERATIONS table.
ORDER_ID
The ID associated with a switching order. This field corresponds to the ID field in the RX_SWITCHING_ORDERS table.
INCIDENT_ID
The ID associated with the incident. This field corresponds with the ID field in the RX_INCIDENTS 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 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.
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.
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).
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.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
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.
RX_REGION_CUSTOMERS
This table is used to archive the number of customers within a specific region at a given point in time.
Field Name
Description
COUNT_DATE
Date the count was taken of all customers in the region.
REGION_ID
The ID of the region.
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.
RX_SWITCHING_ORDERS_ARCHIVE
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.
NAME
The name of the switching order.
INCIDENT_ID
The ID associated with the incident. This field corresponds with the ID field in the RX_INCIDENTS table.
TYPE
Indicates the type of operation (custom, tag, or device).
REGION
The region in which the incident is located. This field uses the REGION domain.
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.
TIME_CREATED
The time the switching order was created.
APPROVED_BY
User name of the person who approved the switching order.
STATUS
Indicates the status of the switching order. This field uses the STATUS domain.
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.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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_SW_OR_FEATURES_ARCHIVE
Field Name
Description
SW_OR_FEATURES_ID
The ID associated with the switching order feature.
INCIDENT_ID
The ID associated with the incident resulting from the call. This field corresponds with the ID field in the RX_INCIDENTS table.
OID
Object ID fo the feature associated with the tag.
FCID
Feature class 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.
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 feature exists. 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 Feeder ID of the feature.
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 time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
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_SW_OR_REQUESTS_ARCHIVE
Field Name
Description
SW_OR_REQUESTS_ID
The ID associated with the switching order request.
INCIDENT_ID
The ID associated with the incident resulting from the call. This field corresponds with the ID field in the RX_INCIDENTS table.
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.
REQUEST_REFERENCE
The reference number assigned to the 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.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
SWITCHING_ORDER_ID
The unique ID that identifies the switching order to which the request has been assigned.
RX_TAGS_AND_GROUNDS_ARCHIVE
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.
REGION
The region in which the tag or ground is located. This field uses the REGION domain.
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.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
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_TAG_GROUND_STEPS_ARCHIVE
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.
OPERATION_ID
This field corresponds to the ID field in the RX_OPERATIONS table.
INCIDENT_ID
The ID associated with the incident associated to the tag. This field corresponds with the ID field in the RX_INCIDENTS table.
TAG_ID_1
ID of the tag.
TAG_ID_2
ID of the tag.
TAG_ID_3
ID of the tag.
TAG_TYPE
The type of tag placed.
PHASES
Indicates which phases are affected.
ACTION
Indicates whether the action is a place or remove.
TAG_GUID
The ID associated with the incident associated with the tag. This field corresponds with the ID field in the RX_INCIDENTS 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 time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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_TRUCKS_ARCHIVE
Field Name
Description
TRUCK_ID
The unique identifier assigned to the truck. This field corresponds to the ID field in the RX_TRUCKS table.
ASSIGNMENT_ID
The unique identifier assigned to each crew assignment. This field corresponds with the ID field in the RX_CREW_ASSIGNMENTS table.
TRUCK_NUMBER
The number assigned to the truck as an identifier.
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 ID for the crew to which the truck has been assigned. This field corresponds to the ID field in 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.
CHANGE_DATE
The time and date an operation was performed on the record.
OPERATION
The operation (e.g., insert, delete, update) performed on the record.
USER_UPDATED_ARCH
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.
INCIDENT_ID
The ID associated with the incident. This field acts as a foreign key to the RX_INCIDENTS table.
RX_T_MAJOR_EVENT_DAY
The Calculate Tmed tool (in Archive Explorer) calculates the Major Event Duration (med) according to the IEEE Standard 1366-2012, section 4.5. When these values are calculated, they are stored in this table. Any incident that has a duration which exceeds the TMED_MINUTES value will be excluded from the Reliability Reports.
Field Name
Description
START_DATE
The outage date (Time of Outage field) of the first load point archive record within the five-year period.
END_DATE
The outage date (Time of Outage field) of the last load point archive record within the five-year period.
TMED_MINUTES
The length of the major event duration (med).
RX_XLOCK
This table is for internal use only. Do not modify the data in this table.
