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.
- 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 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
- 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.