Example: Arrayed structure

An example of an arrayed structure is an unavailability graph. This structure is defined in the standard Configuration Item (CI) files distributed with the Configuration Management application.

To create your own CI files and track availability, add the following availability fields to the CI files:

Database Dictionary field name	Field type
number.of.problems	number
explicit.unavailability	date/time
implicit.unavailability	date/time
perceived.unavailability	date/time
start.of.operating.hours	date/time
graph.of.unavailability	array
graph.of.unavailability	structure
date	date/time
graph	character

The field names must be spelled exactly as they are shown in the above table and defined with the specified field type.

In this example, there is a devicepc file for which you want each record within this file to contain statistical information on availability.

Note: The graph fields must also be added to the CI formats.

Note: You must use the Windows client whenever you need to add or edit a field/key in a database dictionary table.

Add availability fields that pertain to the devicepc file

1. Log on to the Service Management system with a system administrator account.
2. Click Tailoring > Database Dictionary.
3. In the File Name field, type devicepc, and then click Search.

4. Place the cursor on the descriptor field, and then click New Field/Key.

   The field window opens.

5. In the Name field, type graph.of.unavailability.
6. Click the list in the Type field and choose array.

7. Click Add.

   The message Enter data type of array’s element displays at the top of the screen and the window refreshes.

   The Name field still displays graph.of.unavailability, but the Type field is blank.

   To create an arrayed structure, define the type of array as a structure, such as a character, number, or date and time structure.

   Click the list in the Type field and choose structure.

8. Click Add.

   There are two entries in the database dictionary record for the field graph.of.unavailability. The first entry defines the field as an array. The second entry defines the data type for the array. Both entries are listed as graph.of.unavailability. The system default, which can be overridden, is to use the same field name for both entries.

   The two entries are added to the bottom of the list of fields in the devicepc database dictionary record.

   Note: The second entry is indented in the above example. This occurs only if the number of fields specified in the record is less than 50.

Associate the new field to the structure

1. Tab to the second occurrence of the graph.of.unavailability field, the structure type.

   For any field to be part of a structure, the cursor must be positioned on that structure field name before clicking New for the new field to be associated with it.

2. Click New.

   The Structure field contains the value graph.of.unavailability, which is the current structure to which you are adding fields.

3. In the Name field, type date.
4. Click the list in the Type field and choose date/time.

5. Click Add.

   The date field is displayed under the structure field graph.of.unavailability.

6. Select the second occurrence of the graph.of.unavailability field, the structure type.

   Note: For any fields to be part of a structure, the cursor must be positioned on that structure field name before clicking New.

7. Click New.

   Notice the Structure field contains the value graph.of.unavailability, which is the current structure to which you are adding fields.

8. In the Name field of the window, type graph.
9. Click the list in the Type field and choose character.

10. Click Add.

    The graph field is added as the last field under the structure field graph.of.unavailability, and the message graph field added to the pcdevice file is displayed.

    In this example, the graph field is behind the window at the bottom of the screen.

When you have completed adding fields to the database dictionary record

1. Click OK.

   This closes and automatically updates the file. The message Record updated in the dbdict file displays when complete.

2. Press Back to end the database dictionary session and return to the main menu.

You have now added all of the required fields comprising the graph.of.unavailability structure. You can now edit your database dictionary record again, update it, or cancel without updating.

Note: You must update your database dictionary record when adding a new field or the database dictionary record will remain the same. You must also add new fields to the appropriate formats in Forms Designer.