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.