Numeric range domains

A numeric range domain is a domain that uses any of the numeric data types, but does not contain individual values. Instead, they specify valid ranges of values.

You can specify the following kinds of ranges:
Discrete
A range with a defined interval between values, for example, a range from 0 to 10, with valid values 0, 2, 4, 6, 8, and 10. The interval in this example is 2.
Continuous
A range within which any value that satisfies the data type is valid. For example, in a range of 1 to 6 with a decimal data type and scale of 2, values such as 1, 1.03, 2.14, 3, 4.73, 5.2, and 6 are all valid. The interval in this example is null (no value in the Interval field).

A length and scale are always specified for these domains and should match the attribute you link them to.

You cannot create lookups for numeric range domains. Add meaningful help in the attribute's Description field to help users choose valid values. Also, consider the types of values a user or automated process normally enter into a field with their type of domain. An invalid value results in an error message.

Numeric ranges with more than one segment

You might use multiple segments in your numeric range domain for various reasons. Here are two examples:
  • You want to define a measurement range for meter readings that is more precise at low measurements than at high measurements. You define three segments:

    Segment 1: minimum 0, maximum 0.8, interval 0.2, resulting valid values, 0, 0.2, 0.4, 0.6, 0.8

    Segment 2: minimum 1, maximum 9, interval 1, resulting valid values 1, 2, 3, 4, 5, 6, 7, 8, 9

    Segment 3: minimum 10, maximum 30, interval 5, resulting valid values 10, 15, 20, 25, 30

A user or automated process would always enter one of those values.
  • You want values inserted into a field only if the reported values are beyond the accepted normal range. For example, meter readings could be above or below the accepted tolerances. You can define two segments:

    Segment 1: minimum 0, maximum 9.9, interval null. Any reading between 0 and 9.9 could be entered.

    Segment 2: minimum 20.1, maximum null, interval null. Any reading of 20.1 or higher could be entered.

Meter readings from 10 and 20 would not be recorded.