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
- Open the Domains application.
- In the Domains table window, click Add New Domain and
select Add New NUMERIC RANGE Domain.
- In the Domain field, specify a name
for the domain.
- In the Description field, type a
short description for the domain.
- In the Data Type field, specify
a data type for the domain.
- Depending on the data type, the Length field
might or might not be editable. If 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.
- For DECIMAL data type only, in the Scale field,
specify a scale value if different from the default, 2.
- 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 to 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 to 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.
|
- 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 could specify an organization and/or
site for all range segments so that only users in the specified organizations
and/or sites can access them.
- Optional: Click New Row again
to add ranges for additional segments.
- Click OK.
What to do next
After you add a domain, you might still have several tasks
to perform, depending on the domain and how you want to display it.
In
the Classifications application, you associate a domain with an attribute
in the Attributes table window, and no further configuration is needed.
If
you use a domain in any other context, adding a domain requires additional
tasks:
- 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.