Numeric range domains

A numeric range domain is a domain that uses one of the numeric data types, but for which you specify a range rather than specific 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).

You cannot create lookups for numeric range domains. Therefore, 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 that is more precise at low measurements than at high measurements and that correspond with meter readings. You can 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.


Feedback