The Enumeration Editor dialog box appears when you select Enumerated as the Data Type for a user data extension, then click the Ellipses (...) button in the Default Value field. Enumerated fields are fields that contain multiple selections - you define these as members in the Enumeration Editor dialog box.

For example, suppose you want to identify conduits in a model of a new subdivision by one of the following states: Existing, Proposed, Abandoned, Removed, and Retired. You can define a new user data extension with the label "Pipe Status" for conduits, and select Enumerated as the data type. Click the Ellipses (...) button in the Default Value field in the Property Editor for the user data extension to display the Enumeration Editor dialog box. Then enter five members with unique labels (one member for each unique pipe status) and enumeration values in the table. After you close the User Data Extensions dialog box, the new field and its members will be available in the Property Editor for all conduits in your model. You will be able to select any of the statuses defined as members in the new Pipe Status field.

You can specify an unlimited number of members for each user data extension, but member labels and values must be unique. If they are not unique, an error message appears when you try to close the dialog box.

The dialog box contains a table and the following controls.

• New: Lets you add a new row to the table. Each row in the table represents a unique enumerated member of the current user data extension.
• Delete: Deletes the current row from the table. The enumerated member defined in that row is deleted from the user data extension.

You define enumerated members in the table, which contains the following columns:

• Enumeration Member Display Label: The label of the member. This is the label you will see in where ever the user data extension appears (Property Editor, FlexTables, etc.).
• Enumeration Value: A unique integer index associated with the member label. The software uses this number when it performs operations such as queries.