Version: 10.2.1c and 10.2.1c SP3 |
Responder Overview > Implement Responder > Data Preparation > Database Schema Configuration > Modify Domain Values |
You may modify the domain values displayed in Responder Explorer drop-downs using the DatabaseSchemaConfig.xml file.
In the example below, "Tidal Wave" was added to the list of options in the Weather field on the Edit Incident tab. Changes to DatabaseSchemaConfig.xml do not go into effect until DataServices.exe has been restarted. To use a different value other than one provided in the domain by default, we recommend creating a new value (see note) and deleting the existing value.
Schneider Electric reserves all domain values 11-99. Creating new values that are 100 or higher greatly reduces the possibility that we will add a value that overwrites a custom value. Notice in the example below that a customer-specific Tidal Wave entry is assigned a value of 100 (in the XML). |
Figure 1
Figure 2
Copy Code
|
|
---|---|
<Domain Name="WEATHER" xsi:type="CodedDomainConfig" DataType="Int32"> <DomainPair Value="0" Description="<Unknown>" /> <DomainPair Value="1" Description="Hurricane" /> <DomainPair Value="2" Description="Ice Storm" /> <DomainPair Value="3" Description="Other" /> <DomainPair Value="4" Description="Snow Storm" /> <DomainPair Value="5" Description="Thunderstorm" /> <DomainPair Value="100" Description="Tidal Wave" /> <DomainPair Value="6" Description="Tornado" /> <!-- Domain Values 7-99 are RESERVED FOR SCHNEIDER ELECTRIC USAGE!! --> </Domain> |
The following table contains a complete list of Responder domains. Some domains may NOT be modified and some domains have values that must not be modified. These are indicated.
Domain
Used by
Notes
ACCOUNT_TYPE
Indicates the type of client account (e.g., hospital, residential, industrial)
Modify any values in this domain.
CALL_TROUBLE
Problem reported at the incident location (e.g., No Power, Flickering Lights).
Do not modify the following values: 0=No Power, 5=<None>, 6=Other. All values except 0 are assumed to have at least some power (e.g., flickering). 0 is the only "no power" type value.
CALLBACK_REASON
Reason for the callback to the customer.
Modify any values in this domain.
CALLBACK_RESULT
The result of the last callback attempt (e.g., wrong number, left message).
Do not modify the following values: 0=Call Completed, 3=No Answer, 4=Busy Signal, 5=Power NOT Restored, 6=Delete Callback.
CANCEL_REASON
Indicates the reason for cancelling an incident.
No not modify the following value: 0=Unknown
CAUSE
Indicates the cause of the outage. This is the default domain. If you run the Reliability Indices: SAIDI by Cause Code Report OR Minutes and Outage Count by Cause Code Report with CAUSE_RUS domain values, the following message appears:
There was at least one Incident Cause value that did not match to a value in the specified domain.Do not modify the following values: 0=Unknown, 6=Planned Outage, 10=Non-Outage
CAUSE_RUS
Indicates the cause of the outage. An alternate domain created for RUS Bulletin 1730A-119.
Do not modify the following values: 0=Unknown, 6=Planned Outage, 10=Non-Outage, 1=Power Supply
CLOSED_PHASES
Indicates the actual status of the incident device (e.g., AB open).
You may edit the values in this domain, but do not change the meaning. For example, AB closed may become XY closed. But changing AB closed to X open will cause faulty behavior.
CONNECT_STATUS
Indicates the connection status for the customer (e.g., connected, disconnected)
Do not modify the following values: 0=Connected - normal, 1=Connected - seasonal. You may add values only for various types of disconnected status.
CREW_ASSIGNMENT_STATUS
Indicates the status of a crew's assignment (e.g., unassigned, dispatched, working).
Do not modify the 0=Unassigned value. You can change the remaining values, and you can change the meaning or add/remove as many statuses as desired between ‘Assigned’ and ‘Completed.' You cannot, however, change the meaning of ‘Assigned’ and ‘Completed.'
CREW_AVAILABILITY_STATUS
Indicates the availability of a crew (yes/no).
You may edit the values in this domain, but do not change the meaning (e.g., Available, Meal Break, Unavailable).
CREW_COMPANY
The name of the company to which the crew belongs.
Modify any values in this domain.
CREW_TYPE
The type of crew (e.g., company, contractor).
Modify any values in this domain.
CRITICAL_TYPE
Indicates the type for accounts designated as critical (e.g., residential medical, public utility).
Do not modify the following value: 0=Non-critical. All values except 0 are considered critical.
EXPERTISE
Indicates the expertise for a crew member (e.g., lineman, foreman).
Modify any values in this domain.
HAZARD_TYPE
The type of damage at a hazard location (e.g., wires down, broken pole).
Modify any values in this domain, except 2=Wires Down. You may edit this value, but do not change the meaning.
HAZARD_WIRE_OWNER
Owner of the wire on which the hazard resides (e.g., phone, CATV).
Modify any values in this domain.
NETWORK_LEVEL
Indicates the network level. Network level is a custom grouping set up by an administrator (e.g., primary, secondary, transmission, supply).
Refer to Configure Network Level Field topic for value modification details.
ORIGINATION_TYPE
This field indicates how the incident was created (e.g., User Created, Predicted, SCADA).
You may add values to this domain (values 100 and above). Do not modify the existing values. You may, however, change their visibility. PHASES
Indicates the phase (e.g., A, AB, BC).
You may edit the values in this domain, but do not change the meaning. For example, AB may become XY. But changing AB to X will cause faulty behavior.
PRIORITY_TYPE
Indicates the customer's priority (e.g., hospital, business center).
Do not modify the following value: 0=Non-priority.
SWITCH_ORDER_REQUEST_STATUS
Indicates status of a switch order request (e.g., created, approved, assigned).
You may edit the values in this domain, but do not change the meaning.
TAG_ACTION
Indicates what's being done to the tag (i.e., place or remove).
You may edit the values in this domain, but do not change the meaning. For example, "Remove" may be changed to "Eliminate".
TAG_TYPE
Indicates the type of tag being placed (e.g., Do Not Operate, Do Not Open).
Do not modify the following values: 1=Do Not Operate, 2=Do Not Close, 3=Do Not Open, 5=Do Not Energize.
TITLE
The job title associated with a crew member (e.g., Crew Leader, Electronic Tech).
Modify any values in this domain.
TRUCK_COMPANY
This domain provides a list of companies that may own trucks.
Modify any values in this domain.
TRUCK_STATUS
Indicates the availability status of a truck. All values except 0 are considered non-operational. 0=Operational, 1=Non-Operational
You may edit the values in this domain, but do not change the meaning of 'Operational' (0). All values other than 0 are considered non-operational.
TRUCK_TYPE
Indicates the type of truck assigned to the crew (e.g., bucket truck, line truck).
Modify any values in this domain.
UTILITY_TYPE
Indicates the type of utility (e.g., electric, water, gas).
Modify any values in this domain.
VOLTAGE_VALUES
Indicates the voltage of the device (e.g., < 1 KV, 25 KV, > 60KV).
Modify the sort order of this domain by changing the SortedBy attribute to one of the following:
- ListedOrder: Default. Displays the voltages as listed in the Domain.
- Value: Sorts the voltages by value (5 KV, 15 KV, 25 KV)
- Description: Sorts the voltages by description (35 KV, 5 KV, 60 KV)
WEATHER
The weather conditions at the time of the outage (e.g., tornado, snow storm).
Modify any values in this domain.
Do not modify the following domains. Responder functionality relies on these domains to remain unchanged.
CALLBACK_STATUS
Indicates the status of a customer callback (Regular Call/Power Not Restored Call).
Do not modify any values in this domain.
CALLER_TYPE
Indicates the source of the call (e.g., IVR, CSR).
Do not modify any values in this domain. If you do modify the values in this domain, the changes will not be visible in the Responder web application.
CONFIRMED_STATE
Indicates the confirmation status of an incident (confirmed/unconfirmed).
Do not modify any values in this domain.
CRITICAL
Indicates whether an incident is critical or not (yes/no value).
Do not modify any values in this domain.
DEVICE_FCID
Dynamic domain
Do not modify any values in this domain.
DEVICE_OPERATION
Indicates whether an operations is a fault (unplanned outage) or a switching operation (planned outage).
Do not modify any values in this domain.
FCID
Dynamic domain
Do not modify any values in this domain.
HAZARD_STATUS
Indicates the status of the hazard (e.g., unsecured, secured, completed).
Do not modify any values in this domain.
INCIDENT_CHILD_TYPE
Indicates the type of feature associated with an incident (e.g., electric feature, location feature, hazard).
Do not modify any values in this domain.
INCIDENT_DURATION
The length of time an incident exists.
Do not modify any values in this domain.
INCIDENT_STATUS
Indicates the status of an incident (e.g., created, restored, cancelled).
Do not modify any values in this domain.
OPEN_CLOSED
Indicates whether a device is opened or closed.
Do not modify any values in this domain.
OPERATION_STATUS
Indicates the status of the operation (e.g., not executed, executed).
Do not modify any values in this domain.
OPERATION_TYPE
Indicate the type of operation (e.g., Custom, Tag, Device).
Do not modify any values in this domain.
ORIGINATION_TYPE
The source of the incident (e.g., User Created, Predicted).
Do not modify any values in this domain.
OWNER
Dynamic domain
Do not modify any values in this domain.
OWNER_STATE
The status of the feature owner (e.g., no owner, pending, approved).
Do not modify any values in this domain.
REGION
Dynamic domain
Do not modify any values in this domain.
SWITCHING_ORDER_STATUS
Status of a switching order (e.g., created).
Do not modify any values in this domain.
SWITCHING_ORDER_TYPE
Indicates a switching order or restoration order.
Do not modify any values in this domain.
TAG_ORIGINATION
Indicates how the tag was created (e.g., manual, switching order).
Do not modify any values in this domain.
YES_NO
A general yes/no domain.
Do not modify any values in this domain.