Navigating an Issue List

The Issue list is an Excel file with an established structure that determines the configuration and attributes of work orders created in Service Automation. A template will have four tabs. Each tab serves an important part in developing an issue list.

Issues Tab

The bulk of the information for the issue list will be added on the Issues Tab.

1. Areas: Matching the specific area from the Areas Tab with each issue. For example a1 is Front Area, a2 is Back Room, a3 is Kitchen
2. Problem Group: Problem to associate with the work order.
3. Equipment: Type of equipment that is subject to the problem. ServiceChannel will accept only the equipment items that were predefined for the selected location. Assets (Equipment) > Manage Asset Types.
4. Problem Code: Problem code indicates the problem. Enter a brief, but clear problem description. 
5. Trade: Trade which the Problem Group is mapped to. ServiceChannel will accept only the trades that were pre-defined for the selected location. Admin > WO Properties > Trades/NTEs. 
6. Priority: Number of days from the Call Date the service provider should complete the requested work. ServiceChannel will accept only the priorities that were pre-defined for the selected location. Admin > WO Properties > Priorities.
7. NTE: Payment amount that cannot be exceeded for work orders. ServiceChannel will accept only NTE values that were pre-defined for specific trades of the selected location. Admin > WO Properties > Trades/NTEs.
8. Category: Classifications used to group different types of work orders ServiceChannel will accept only categories that were pre-defined for the selected location. Admin > WO Properties > Categories.
9. AttachmentRequired: Enter ‘TRUE’ if you want to prompt users to upload attachments when submitting work orders.
10. Equipment Entry: Specify the Optional or Required status for entry of information about equipment. 
11. Troubleshooting: Specify the troubleshooting text for each work order.
12. Link to Media File: Specify if a media file is required with the work order. 
13. Message: Enter the optional help message work orders. The key difference between Troubleshooting and Message is the following:
1. Troubleshooting: Provides details on what information is expected from the person who submits a work order.
2. Message: Provides feedback or instructions on what can be done next once the work order is submitted.
14. c1-c12: Specify Condition for Override on work orders.

Areas Tab 

You can include specified areas where services may be needed.  Only two columns are necessary for the issue list.

1. Id: Each specific area will require an Id. The process of creating an Id will be a1, a2, a3, and so forth with keeping the letter lowercase “a”.
2. Name: Add the name of the specific area. These names must match those listed in the Areas Tab under Dashboard Admin.

Conditions Tab

Conditions support the use of Overrides on a work order. Those are added in the conditions tab. On the Issues tab, c1-c12, you will add the name of condition for that issue in order for the override to go into effect. 

1. Id: Each specific condition will require an Id. The process of creating an Id will be c1, c2, c3, and so forth with keeping the letter lowercase “c”.
2. Name: Override name 
3. Value: Performs the task of the override.

Fields Tab

Fields Tab communicates with the interactive troubleshooting page of a work order after Area, Problem Type, Priority, and Category have been determined.

1. Area Name: Name of the area where the data entry field is applicable. By default, leave it empty to enable the display of the fields everywhere.
2. Problem Group: Specify the problem group which the data entry field is displayed for.
3. Equipment: Specify the equipment piece which the data entry field is displayed for.
4. Problem Code: Specify the problem code which the data entry field is displayed for.
5. Id: Specify ID of the data entry field.
6. Type: Specify type of the data entry field.
7. Allow: Enter ‘All’ for all data entry fields.
8. For: Leave it blank.
9. Expected Value: Specify the expected value for the data entry field or leave it blank, by default.
10. Options: Specify the list of options for select box fields.
11. Header: Enter the text label for the data entry field.
12. Error: Specify the error message displayed upon the failed validation of the data entry field.
13. Required: Enter ‘TRUE’ to make the field as required.
14. Exclude: Leave it blank, by default.
15. Min: Specify the minimal value for the field.
16. Max: Specify the maximal for the field.
17. Step: Specify the value step for the field.
18. Helptip: Specify the field placeholder for the field