Adding numeric range domains

You add a numeric range domain when you want to add a domain that uses one of the numeric data types. However, you specify a range rather than specific values.

About this task

Because you can use a domain with multiple fields, the length that you specify here must be less than or equal to the length of the shortest field you use the domain with. For example, if you want to use the domain with three fields of lengths 8, 10, and 12, specify a length of 8 or less for the domain. If you specify a length greater than the field the domain is used in, you cannot assign the domain to the attribute in the Database Configuration application. Alternatively, you can specify a greater length in the Domains application. You can use the Database Configuration application later to change the length of the field that uses the domain.

Procedure

  1. In the Domains table window of the Domains application, add a domain and select Add New NUMERIC RANGE Domain.
  2. Specify a name and description for the domain.
  3. Specify a data type for the domain.
  4. Depending on the data type, the Length field might or might not be editable. If the field is editable, specify a length that is equal to or less than the length of the field that uses the domain.
    For example, if you are adding a domain for a field in the Assets application that has a length of 12, then specify a length of 12.
  5. For DECIMAL data type only, in the Scale field, specify a scale value if different from the default, 2.
  6. Click New Row and fill the following fields.
    Each row defines a range.
    Field Description
    Range Segment Specify an identifying number for the segment. For example, 1 if the range has just one segment, or 1, 2, or 3 if the domain has three segments.

    For a range with regular intervals or a simple continuous range, you need only one segment.
    Range Minimum Specify the lowest value in the range, for example, 10 in the range 10 - 50.

    You can leave either the Range Minimum field or the Range Maximum field empty (null value), but not both.
    Range Maximum Specify the highest value in the range, for example, 50 in the range 10 - 50.

    You can leave either the Range Minimum field or the Range Maximum empty (null value), but not both.
    Interval For a range with discrete values, specify the value of the interval that separates the values you want to appear in the list. For example, the interval is 10 in the range 10 - 50 if you want the values 10, 20, 30, 40, and 50 to be valid.

    For a continuous range of values between the minimum and maximum values, leave this field null (empty).

    Continuous is relative to the data type. For example, if the data type is INTEGER and the range is 1 - 5, then only 1, 2, 3, 4, and 5 are valid values.
  7. Optional: Apply a domain value to a specific organization or site by specifying values in the Organization and Site fields.
    Domains are applied at the system level by default.

    You might want to leave the Organization and/or Site fields empty for all range segments so that users in all organizations and sites can access them. Or you might specify an organization and/or site for all range segments so that only users in the specified organizations and/or sites can access them.

  8. Optional: Click New Row again to add ranges for more segments.
  9. Save your changes.

What to do next

After you add a domain, you might have several tasks to perform, depending on the domain and how you want to display it.
  • Associate the new domain with an attribute in the Database Configuration application.
  • Configure the database in the Database Configuration application.
  • Use the Application Designer application to modify the user interface as needed. For example, if you add an ALN domain for a field, you must add the select value button. New crossover domains might require new fields in the destination application.